[interchange] Make transactions.update_date PREFER_NULL
Jon Jensen
interchange-cvs at icdevgroup.org
Thu Nov 2 05:54:45 UTC 2017
commit fdf73c8a451be46a0c9fdd74944768f64ff4b95a
Author: Jon Jensen <jon at endpoint.com>
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)"
More information about the interchange-cvs
mailing list