[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