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

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

Update of /cvsroot/meshdb/www/deal
In directory usw-pr-cvs1:/tmp/cvs-serv5172

Modified Files:
	deal.sql 
Log Message:

Changes to the deal and donations database schema. 
Table attributes have been updated to reflect.
The main difference is the ability via the deal_status for a person to disable eenable a deal. The other changes are purely for efficeny and schema readability.

The next step the the PHP.


Index: deal.sql
===================================================================
RCS file: /cvsroot/meshdb/www/deal/deal.sql,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- deal.sql	10 Aug 2002 11:57:18 -0000	1.2
+++ deal.sql	11 Aug 2002 06:42:24 -0000	1.3
@@ -1,75 +1,77 @@
-# MySQL dump 8.12
-#
-# Host: bo    Database: mesh
-#--------------------------------------------------------
-# Server version	3.23.39-log
+# Host: localhost
+# Generation Time: Aug 11, 2002 at 04:32 
+# Server version: 3.23.49
+# PHP Version: 4.1.2
+# Database : `meshdb`
+# --------------------------------------------------------
 
 #
-# Table structure for table 'rhp'
+# Table structure for table `deal`
 #
 
-DROP TABLE IF EXISTS rhp;
-CREATE TABLE rhp (
-  id int(11) NOT NULL auto_increment,
-  status tinytext,
-  class tinytext,
-  description mediumtext,
-  descriptionurl mediumtext,
-  donator mediumtext,
-  donatedwhen datetime default NULL,
-  donatorurl mediumtext,
-  user mediumtext,
-  usedwhen datetime default NULL,
-  userurl mediumtext,
-  lostwhen datetime default NULL,
-  comment text,
-  PRIMARY KEY  (id)
+CREATE TABLE deal (
+  deal_id mediumint(9) NOT NULL auto_increment,
+  vendor_id mediumint(9) NOT NULL default '0',
+  product_id mediumint(9) NOT NULL default '0',
+  deal_minimum_quantity 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',
+  deal_spotter varchar(255) default NULL,
+  deal_description text,
+  deal_key varchar(16) NOT NULL default '',
+  deal_url varchar(255) default NULL,
+  deal_status tinyint(1) NOT NULL default '1',
+  PRIMARY KEY  (deal_id)
 ) TYPE=MyISAM;
+# --------------------------------------------------------
 
 #
-# Table structure for table 'vendor'
+# Table structure for table `donation`
 #
 
-DROP TABLE IF EXISTS vendor;
-CREATE TABLE vendor (
-  id int(11) NOT NULL auto_increment,
-  name tinytext,
-  url mediumtext,
-  PRIMARY KEY  (id)
+CREATE TABLE donation (
+  donation_id mediumint(9) NOT NULL auto_increment,
+  donation_class varchar(255) default NULL,
+  donation_description text,
+  donation_description_url varchar(255) default NULL,
+  donation_donator varchar(255) default NULL,
+  donation_donator_email varchar(255) default NULL,
+  donation_donator_url varchar(255) default NULL,
+  donation_donated_when int(11) unsigned NOT NULL default '0',
+  donation_user varchar(255) default NULL,
+  donation_user_email varchar(255) default NULL,
+  donation_user_url varchar(255) default NULL,
+  donation_user_used int(11) unsigned NOT NULL default '0',
+  donation_user_lost int(11) unsigned NOT NULL default '0',
+  donation_status tinyint(1) NOT NULL default '1',
+  PRIMARY KEY  (donation_id)
 ) TYPE=MyISAM;
+# --------------------------------------------------------
 
 #
-# Table structure for table 'deal'
+# Table structure for table `product`
 #
 
-DROP TABLE IF EXISTS deal;
-CREATE TABLE deal (
-  id int(11) NOT NULL auto_increment,
-  vendorid int(11) default NULL,
-  productid int(11) default NULL,
-  minqty int(11) default NULL,
-  unitprice float default NULL,
-  spotted datetime default NULL,
-  expires datetime default NULL,
-  spotter mediumtext,
-  note mediumtext,
-  keypass varchar(64) default NULL,
-  url mediumtext,
-  PRIMARY KEY  (id)
+CREATE TABLE product (
+  product_id mediumint(9) NOT NULL auto_increment,
+  product_class varchar(255) default NULL,
+  product_name varchar(255) default NULL,
+  product_url varchar(255) default NULL,
+  product_manufacturer varchar(255) default NULL,
+  product_description text,
+  PRIMARY KEY  (product_id)
 ) TYPE=MyISAM;
+# --------------------------------------------------------
 
 #
-# Table structure for table 'product'
+# Table structure for table `vendor`
 #
 
-DROP TABLE IF EXISTS product;
-CREATE TABLE product (
-  id int(11) NOT NULL auto_increment,
-  class tinytext,
-  name mediumtext,
-  url mediumtext,
-  manuf tinytext,
-  description mediumtext,
-  PRIMARY KEY  (id)
+CREATE TABLE vendor (
+  vendor_id mediumint(9) NOT NULL auto_increment,
+  vendor_name varchar(255) default NULL,
+  vendor_url varchar(255) default NULL,
+  PRIMARY KEY  (vendor_id)
 ) TYPE=MyISAM;