[interchange] Make transactions.update_date PREFER_NULL
Jon Jensen <[email protected]> Thu, 02 Nov 2017 05:54:45 +0000
| Newsgroups | gmane.comp.web.interchange.cvs |
|---|---|
| Message-ID | <[email protected]> |
commit fdf73c8a451be46a0c9fdd74944768f64ff4b95a Author: Jon Jensen <[email protected]> Date: Wed Nov 1 23:51:40 2017 -0600 Make transactions.update_date PREFER_NULL Otherwise order editing in the admin fails. Also sync the transactions indexes between the 3 database types. dist/strap/dbconf/mysql/transactions.mysql | 4 ++++ dist/strap/dbconf/pgsql/transactions.pgsql | 1 + dist/strap/dbconf/sqlite/transactions.lite | 4 ++++ 3 files changed, 9 insertions(+), 0 deletions(-) --- diff --git a/dist/strap/dbconf/mysql/transactions.mysql b/dist/strap/dbconf/mysql/transactions.mysql index 30839d8..fe32a59 100644 --- a/dist/strap/dbconf/mysql/transactions.mysql +++ b/dist/strap/dbconf/mysql/transactions.mysql @@ -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)" diff --git a/dist/strap/dbconf/pgsql/transactions.pgsql b/dist/strap/dbconf/pgsql/transactions.pgsql index 01a08ba..e3c4a95 100644 --- a/dist/strap/dbconf/pgsql/transactions.pgsql +++ b/dist/strap/dbconf/pgsql/transactions.pgsql @@ -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 diff --git a/dist/strap/dbconf/sqlite/transactions.lite b/dist/strap/dbconf/sqlite/transactions.lite index 96aa0b8..420bac1 100644 --- a/dist/strap/dbconf/sqlite/transactions.lite +++ b/dist/strap/dbconf/sqlite/transactions.lite @@ -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)"