Skip to content

Commit

Permalink
Browse files Browse the repository at this point in the history
Make transactions.update_date PREFER_NULL
Otherwise order editing in the admin fails.

Also sync the transactions indexes between the 3 database types.
  • Loading branch information
jonjensen committed Nov 2, 2017
1 parent 57f71fe commit fdf73c8
Show file tree
Hide file tree
Showing 3 changed files with 9 additions and 0 deletions.
4 changes: 4 additions & 0 deletions dist/strap/dbconf/mysql/transactions.mysql
Expand Up @@ -40,14 +40,18 @@ Database transactions COLUMN_DEF "b_phone=varchar(20)"
Database transactions COLUMN_DEF "payment_method=varchar(128)"
Database transactions COLUMN_DEF "avs=varchar(32)"
Database transactions COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database transactions INDEX order_date
Database transactions COLUMN_DEF "update_date=timestamp"
Database transactions PREFER_NULL update_date
Database transactions COLUMN_DEF "order_id=varchar(32)"
Database transactions COLUMN_DEF "auth_code=varchar(32)"
Database transactions COLUMN_DEF "tracking_number=varchar(64)"
Database transactions COLUMN_DEF "status=varchar(32)"
Database transactions COLUMN_DEF "parent=varchar(9)"
Database transactions COLUMN_DEF "archived=varchar(1) DEFAULT ''"
Database transactions INDEX archived
Database transactions COLUMN_DEF "deleted=varchar(1) DEFAULT ''"
Database transactions INDEX deleted
Database transactions COLUMN_DEF "complete=varchar(1) DEFAULT ''"
Database transactions COLUMN_DEF "comments=text"
Database transactions COLUMN_DEF "currency_locale=varchar(32)"
Expand Down
1 change: 1 addition & 0 deletions dist/strap/dbconf/pgsql/transactions.pgsql
Expand Up @@ -51,6 +51,7 @@ Database transactions COLUMN_DEF "comments=text"
Database transactions COLUMN_DEF "currency_locale=varchar(32)"
Database transactions COLUMN_DEF "pay_cert_total=varchar(16)"
Database transactions COLUMN_DEF "pay_cert_ord_total=varchar(16)"
Database transactions PREFER_NULL update_date
Database transactions INDEX store_id
Database transactions INDEX order_number
Database transactions INDEX order_date
Expand Down
4 changes: 4 additions & 0 deletions dist/strap/dbconf/sqlite/transactions.lite
Expand Up @@ -40,14 +40,18 @@ Database transactions COLUMN_DEF "b_phone=varchar(20)"
Database transactions COLUMN_DEF "payment_method=varchar(128)"
Database transactions COLUMN_DEF "avs=varchar(32)"
Database transactions COLUMN_DEF "order_date=varchar(32) NOT NULL"
Database transactions INDEX order_date
Database transactions COLUMN_DEF "update_date=timestamp"
Database transactions PREFER_NULL update_date
Database transactions COLUMN_DEF "order_id=varchar(32)"
Database transactions COLUMN_DEF "auth_code=varchar(32)"
Database transactions COLUMN_DEF "tracking_number=varchar(64)"
Database transactions COLUMN_DEF "status=varchar(32)"
Database transactions COLUMN_DEF "parent=varchar(9)"
Database transactions COLUMN_DEF "archived=varchar(1) DEFAULT ''"
Database transactions INDEX archived
Database transactions COLUMN_DEF "deleted=varchar(1) DEFAULT ''"
Database transactions INDEX deleted
Database transactions COLUMN_DEF "complete=varchar(1) DEFAULT ''"
Database transactions COLUMN_DEF "comments=text"
Database transactions COLUMN_DEF "currency_locale=varchar(32)"
Expand Down

0 comments on commit fdf73c8

Please sign in to comment.