[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