[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