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;
|
