[interchange-cvs] interchange - heins modified dist/foundation/dbconf/pgsql/options.pgsql

[interchange-core@interchange.redhat.com]

User:      heins
Date:      2002-06-25 02:33:02 GMT
Modified:  dist/foundation/dbconf/pgsql options.pgsql
Log:
	* Remove unneeded NOT NULL that screws up with Postgres. Why
	  does "DEFAULT ''" not work in Postgres?

Revision  Changes    Path
2.1       +5 -5      interchange/dist/foundation/dbconf/pgsql/options.pgsql


rev 2.1, prev_rev 2.0
Index: options.pgsql
===================================================================
RCS file: /anon_cvs/repository/interchange/dist/foundation/dbconf/pgsql/options.pgsql,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -r2.0 -r2.1
--- options.pgsql	18 Jul 2001 02:20:57 -0000	2.0
+++ options.pgsql	25 Jun 2002 02:33:02 -0000	2.1
@@ -16,19 +16,19 @@
 Database options COLUMN_DEF "differential=varchar(20)"
 Database options COLUMN_DEF "mv_shipmode=varchar(128)"
 Database options COLUMN_DEF "o_default=varchar(64)"
-Database options COLUMN_DEF "o_enable=varchar(1) NOT NULL DEFAULT ''"
-Database options COLUMN_DEF "o_group=varchar(20) NOT NULL DEFAULT ''"
+Database options COLUMN_DEF "o_enable=varchar(1)"
+Database options COLUMN_DEF "o_group=varchar(20)"
 Database options COLUMN_DEF "o_height=int"
 Database options COLUMN_DEF "o_label=text"
-Database options COLUMN_DEF "o_master=varchar(64) NOT NULL DEFAULT ''"
+Database options COLUMN_DEF "o_master=varchar(64)"
 Database options COLUMN_DEF "o_matrix=varchar(1)"
 Database options COLUMN_DEF "o_modular=varchar(1)"
-Database options COLUMN_DEF "o_sort=varchar(16) NOT NULL DEFAULT ''"
+Database options COLUMN_DEF "o_sort=varchar(16)"
 Database options COLUMN_DEF "o_value=text"
 Database options COLUMN_DEF "o_width=int"
 Database options COLUMN_DEF "phantom=varchar(1)"
 Database options COLUMN_DEF "price=varchar(20)"
-Database options COLUMN_DEF "sku=varchar(64) NOT NULL DEFAULT ''"
+Database options COLUMN_DEF "sku=varchar(64)"
 Database options COLUMN_DEF "volume=varchar(20)"
 Database options COLUMN_DEF "weight=varchar(20)"
 Database options COLUMN_DEF "wholesale=varchar(20)"