[Meshdb-cvs] www/deal/db/schema deal.sql,1.2,1.3

[<unl...@us...>]

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',