[Meshdb-cvs] www/deal/db/schema deal.sql,NONE,1.1

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

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

Added Files:
	deal.sql 
Log Message:
OK. This is the new code for the deal system, basically this is the framework of how the system will work, with db abstraction, templating and files broken up to handle each respective bit.

The current code does not do anything, it simple prints a header, foo, and footer, but when it does that it is connecting to the DB, loading the templating system. What has to happen now is the functions/system from index-conv.php (the old index) to be re-imploemented in the new framework.

--- NEW FILE: deal.sql ---
# 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 `deal`
#
DROP TABLE IF EXISTS deal;
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 `donation`
#
DROP TABLE IF EXISTS donation;
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 `product`
#
DROP TABLE IF EXISTS product;
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 `vendor`
#
DROP TABLE IF EXISTS vendor;
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;