[interchange-cvs] interchange - racke modified dist/foundation/dbconf/mysql/products.mysql

[interchange-cvs at icdevgroup.org]

User:      racke
Date:      2003-11-11 00:46:56 GMT
Modified:  dist/foundation/dbconf/mysql products.mysql
Log:
explicitly specify column type for inactive to save space and
avoid problems with NULL values in this column

Revision  Changes    Path
2.3       +1 -0      interchange/dist/foundation/dbconf/mysql/products.mysql


rev 2.3, prev_rev 2.2
Index: products.mysql
===================================================================
RCS file: /var/cvs/interchange/dist/foundation/dbconf/mysql/products.mysql,v
retrieving revision 2.2
retrieving revision 2.3
diff -u -r2.2 -r2.3
--- products.mysql	6 Jul 2003 04:34:18 -0000	2.2
+++ products.mysql	11 Nov 2003 00:46:56 -0000	2.3
@@ -22,4 +22,5 @@
 Database  products  COLUMN_DEF   "gift_cert=VARCHAR(3)"
 Database  products  COLUMN_DEF   "related=text"
 Database  products  COLUMN_DEF   "featured=VARCHAR(32)"
+Database  products  COLUMN_DEF	 "inactive=TINYINT(1) DEFAULT '0' NOT NULL"
 Database  products  NUMERIC      price