Mailing List Archive

commit fdf73c8a451be46a0c9fdd74944768f64ff4b95a
Author: Jon Jensen <jon@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)"

_______________________________________________
interchange-cvs mailing list
interchange-cvs@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-cvs