[interchange] fix issue with PostgreSQL stock_alert table definition

David Christensen interchange-cvs at icdevgroup.org
Wed Jan 6 21:39:09 UTC 2016


commit 6d8c2fc4f20a0a6186140d0a7c5036e78449254f
Author: David Christensen <david at endpoint.com>
Date:   Tue Jan 5 22:13:22 2016 -0600

    fix issue with PostgreSQL stock_alert table definition

 dist/strap/dbconf/pgsql/stock_alert.pgsql |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/dist/strap/dbconf/pgsql/stock_alert.pgsql b/dist/strap/dbconf/pgsql/stock_alert.pgsql
index 5fc8be0..861aff7 100644
--- a/dist/strap/dbconf/pgsql/stock_alert.pgsql
+++ b/dist/strap/dbconf/pgsql/stock_alert.pgsql
@@ -1,11 +1,11 @@
 Database  stock_alert  stock_alert.txt      __SQLDSN__
-Database  stock_alert  COLUMN_DEF   "uid=int(11) NOT NULL auto_increment PRIMARY KEY"
+Database  stock_alert  COLUMN_DEF   "uid=serial primary key"
 Database  stock_alert  COLUMN_DEF   "sku=varchar(20) DEFAULT '' NOT NULL"
 Database  stock_alert  COLUMN_DEF   "price=decimal(10,2) DEFAULT '0.00' NOT NULL"
 Database  stock_alert  COLUMN_DEF   "description=varchar(255) DEFAULT '' NOT NULL"
 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