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

[<le...@us...>]

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

Added Files:
	deal.sql 
Log Message:
An SQL script to create the deal tables

--- NEW FILE: deal.sql ---
# MySQL dump 8.12
#
# Host: bo    Database: mesh
#--------------------------------------------------------
# Server version	3.23.39-log

#
# Table structure for table 'rhp'
#

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)
) TYPE=MyISAM;

#
# Table structure for table 'vendor'
#

DROP TABLE IF EXISTS vendor;
CREATE TABLE vendor (
  id int(11) NOT NULL auto_increment,
  name tinytext,
  url mediumtext,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Table structure for table 'deal'
#

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)
) TYPE=MyISAM;