Update of /cvsroot/meshdb/www/deal/db/schema
In directory usw-pr-cvs1:/tmp/cvs-serv17923/db/schema
Modified Files:
deal.sql
Log Message:
Redundancy might be bad as school when learning about schemas.
But it sure as hell beats sub selects.
Modified deals table accordingly.
Index: deal.sql
===================================================================
RCS file: /cvsroot/meshdb/www/deal/db/schema/deal.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- deal.sql 17 Aug 2002 09:07:49 -0000 1.2
+++ deal.sql 17 Aug 2002 09:09:21 -0000 1.3
@@ -8,6 +8,7 @@
vendor_id mediumint(9) NOT NULL default '0',
product_id mediumint(9) NOT NULL default '0',
deal_quantity smallint(6) NOT NULL default '0',
+ deal_quantity_remaining smallint(6) NOT NULL default '0',
deal_unit_price float NOT NULL default '0',
deal_spotted int(11) unsigned NOT NULL default '0',
deal_expires int(11) unsigned NOT NULL default '0',
|
