[interchange] fix issue with PostgreSQL stock_alert table definition
David Christensen <[email protected]> Wed, 06 Jan 2016 21:39:09 +0000
| Newsgroups | gmane.comp.web.interchange.cvs |
|---|---|
| Message-ID | <[email protected]> |
commit 6d8c2fc4f20a0a6186140d0a7c5036e78449254f Author: David Christensen <[email protected]> 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