[interchange-cvs] interchange - heins modified dist/foundation/dbconf/pgsql/products.pgsql
interchange-core@icdevgroup.org
interchange-core@icdevgroup.org
Sun Jul 28 00:20:01 2002
User: heins
Date: 2002-07-28 04:19:44 GMT
Modified: dist/foundation/dbconf/pgsql products.pgsql
Log:
* Change default type to varchar(128) vs. char, no ChopBlanks needed
* Turn on NO_ASCII_INDEX
Revision Changes Path
2.1 +17 -14 interchange/dist/foundation/dbconf/pgsql/products.pgsql
rev 2.1, prev_rev 2.0
Index: products.pgsql
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
RCS file: /anon_cvs/repository/interchange/dist/foundation/dbconf/pgsql/pro=
ducts.pgsql,v
retrieving revision 2.0
retrieving revision 2.1
diff -u -r2.0 -r2.1
--- products.pgsql 18 Jul 2001 02:20:57 -0000 2.0
+++ products.pgsql 28 Jul 2002 04:19:44 -0000 2.1
@@ -5,23 +5,26 @@
ifdef SQLPASS
Database products PASS __SQLPASS__
endif
+Database products DEFAULT_TYPE varchar(128)
Database products KEY sku
-Database products COLUMN_DEF "sku=3DVARCHAR(64) NOT NULL PRIMARY KEY"
-Database products COLUMN_DEF "description=3DVARCHAR(128)"
-Database products COLUMN_DEF "title=3DVARCHAR(128)"
-Database products COLUMN_DEF "artist=3DVARCHAR(128)"
-Database products COLUMN_DEF "comment=3DTEXT"
-Database products COLUMN_DEF "thumb=3DVARCHAR(128)"
-Database products COLUMN_DEF "image=3DVARCHAR(64)"
-Database products COLUMN_DEF "price=3DVARCHAR(12)"
-Database products COLUMN_DEF "category=3DVARCHAR(64)"
-Database products COLUMN_DEF "nontaxable=3DVARCHAR(3)"
-Database products COLUMN_DEF "weight=3DVARCHAR(12)"
-Database products COLUMN_DEF "size=3DVARCHAR(96)"
-Database products COLUMN_DEF "color=3DVARCHAR(96)"
+Database products COLUMN_DEF "sku=3Dvarchar(64) NOT NULL PRIMARY KEY"
+Database products COLUMN_DEF "description=3Dvarchar(128)"
+Database products COLUMN_DEF "title=3Dvarchar(128)"
+Database products COLUMN_DEF "comment=3Dtext"
+Database products COLUMN_DEF "thumb=3Dvarchar(128)"
+Database products COLUMN_DEF "image=3Dvarchar(64)"
+Database products COLUMN_DEF "price=3Dvarchar(12)"
+Database products COLUMN_DEF "category=3Dvarchar(64)"
+Database products COLUMN_DEF "nontaxable=3Dvarchar(3)"
+Database products COLUMN_DEF "weight=3Dvarchar(12)"
+Database products COLUMN_DEF "size=3Dvarchar(96)"
+Database products COLUMN_DEF "color=3Dvarchar(96)"
Database products COLUMN_DEF "related=3Dtext"
-Database products COLUMN_DEF "featured=3DVARCHAR(32)"
+Database products COLUMN_DEF "featured=3Dvarchar(32)"
+Database products COLUMN_DEF "inactive=3Dchar(1) default ''"
+Database products NO_ASCII_INDEX 1
Database products INDEX description
Database products INDEX price
Database products INDEX category
Database products INDEX prod_group
+Database products INDEX inactive