[interchange] Remove invalid date default that doesn't work with more strict MySQL 5.7

Jon Jensen interchange-cvs at icdevgroup.org
Sat Apr 7 03:41:40 UTC 2018


commit e5751e09527fc1536e4ea18f6526387268d140e4
Author: Jon Jensen <jon at endpoint.com>
Date:   Fri Apr 6 16:13:16 2018 -0600

    Remove invalid date default that doesn't work with more strict MySQL 5.7

 dist/strap/dbconf/mysql/stock_alert.mysql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/dist/strap/dbconf/mysql/stock_alert.mysql b/dist/strap/dbconf/mysql/stock_alert.mysql
index 5fc8be0..4cf312c 100644
--- a/dist/strap/dbconf/mysql/stock_alert.mysql
+++ b/dist/strap/dbconf/mysql/stock_alert.mysql
@@ -6,6 +6,6 @@ Database  stock_alert  COLUMN_DEF   "description=varchar(255) DEFAULT '' NOT NUL
 Database  stock_alert  COLUMN_DEF   "fname=varchar(255) DEFAULT NULL"
 Database  stock_alert  COLUMN_DEF   "lname=varchar(255) DEFAULT NULL"
 Database  stock_alert  COLUMN_DEF   "email=varchar(255) DEFAULT '' NOT NULL"
-Database  stock_alert  COLUMN_DEF   "date=date DEFAULT '0000-00-00' NOT NULL"
+Database  stock_alert  COLUMN_DEF   "date=date"
 Database  stock_alert  CREATE_EMPTY_TXT 1
 Database  stock_alert  NAME   uid sku price description fname lname email date



More information about the interchange-cvs mailing list