# phpMyAdmin MySQL-Dump
# version 2.2.0
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: February 2, 2002, 2:47 pm
# Server version: 3.23.36
# PHP Version: 3.0.15
# Database : `test2`
# --------------------------------------------------------

#
# Table structure for table `Buyers`
#

CREATE TABLE Buyers (
  Name varchar(100) NOT NULL default '',
  Address1 varchar(100) NOT NULL default '',
  Address2 varchar(100) NOT NULL default '',
  City varchar(100) NOT NULL default '',
  State char(2) NOT NULL default '',
  Zip varchar(20) NOT NULL default '',
  Email varchar(100) NOT NULL default '',
  DayPhone varchar(100) NOT NULL default '',
  EvePhone varchar(100) NOT NULL default '',
  Contact int(1) NOT NULL default '0',
  PayMethod varchar(100) NOT NULL default '',
  CCType varchar(100) NOT NULL default '',
  CCNum varchar(100) NOT NULL default '',
  CCExpire varchar(100) NOT NULL default '',
  OrderTotal decimal(8,2) NOT NULL default '0.00',
  Date varchar(100) NOT NULL default '',
  OrderNumber bigint(20) NOT NULL default '0',
  UserID varchar(100) NOT NULL default '',
  BuyerID bigint(20) NOT NULL auto_increment,
  Pass varchar(10) NOT NULL default '',
  PRIMARY KEY  (BuyerID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `CartItems`
#

CREATE TABLE CartItems (
  UserID varchar(100) NOT NULL default '',
  ItemID varchar(25) NOT NULL default '',
  ItemQuantity int(4) NOT NULL default '0',
  Date varchar(100) NOT NULL default '',
  CartItemsID bigint(20) NOT NULL auto_increment,
  ItemOptions text,
  PRIMARY KEY  (CartItemsID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `Category`
#

CREATE TABLE Category (
  Category varchar(100) NOT NULL default '',
  CategoryID bigint(20) NOT NULL auto_increment,
  PagingStep int(11) NOT NULL default '10',
  PRIMARY KEY  (CategoryID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `ItemOption`
#

CREATE TABLE ItemOption (
  OptionID int(11) NOT NULL auto_increment,
  ItemID int(11) NOT NULL default '0',
  OptionName varchar(100) NOT NULL default '',
  OptionType varchar(10) NOT NULL default '',
  PRIMARY KEY  (OptionID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `Items`
#

CREATE TABLE Items (
  ItemSKU varchar(25) NOT NULL default '',
  ItemName varchar(100) NOT NULL default '',
  ItemDescription mediumtext NOT NULL,
  ItemCost decimal(7,2) NOT NULL default '0.00',
  Category bigint(20) NOT NULL default '0',
  ShippingCost decimal(6,2) NOT NULL default '0.00',
  ItemID bigint(20) NOT NULL auto_increment,
  ItemGraphic text,
  PaymentCycle char(1) NOT NULL default 'O',
  PRIMARY KEY  (ItemID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `OptionValue`
#

CREATE TABLE OptionValue (
  ValueID int(11) NOT NULL auto_increment,
  OptionID int(11) NOT NULL default '0',
  ValueName varchar(100) NOT NULL default '',
  PRIMARY KEY  (ValueID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `OrderOption`
#

CREATE TABLE OrderOption (
  OptionID int(11) NOT NULL auto_increment,
  OptionName varchar(100) NOT NULL default '',
  OptionType varchar(10) NOT NULL default '',
  PRIMARY KEY  (OptionID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `OrderOptionValue`
#

CREATE TABLE OrderOptionValue (
  ValueID int(11) NOT NULL auto_increment,
  OptionID int(11) NOT NULL default '0',
  ValueName varchar(100) NOT NULL default '',
  PRIMARY KEY  (ValueID)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `Orders`
#

CREATE TABLE Orders (
  BuyerID bigint(20) NOT NULL default '0',
  UserID varchar(100) NOT NULL default '',
  Date varchar(100) NOT NULL default '',
  OrderTotal decimal(8,2) NOT NULL default '0.00',
  OrderNumber bigint(20) NOT NULL auto_increment,
  OrderStatus varchar(10) NOT NULL default 'processing',
  bName varchar(100) NOT NULL default '',
  bAddress1 varchar(100) NOT NULL default '',
  bAddress2 varchar(100) NOT NULL default '',
  bCity varchar(100) NOT NULL default '',
  bState char(2) NOT NULL default '',
  bZip varchar(20) NOT NULL default '',
  bDayPhone varchar(100) NOT NULL default '',
  bEvePhone varchar(100) NOT NULL default '',
  bContact int(1) NOT NULL default '0',
  bPayMethod varchar(100) NOT NULL default '',
  bCCType varchar(100) NOT NULL default '',
  bCCNum varchar(100) NOT NULL default '',
  bCCExpire varchar(100) NOT NULL default '',
  OrderOptions text,
  PaymentCycle char(1) NOT NULL default 'O',
  PaymentStatus int(11) NOT NULL default '0',
  PRIMARY KEY  (OrderNumber)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `Receipts`
#

CREATE TABLE Receipts (
  BuyerID bigint(20) NOT NULL default '0',
  UserID varchar(100) NOT NULL default '',
  OrderNumber bigint(20) NOT NULL default '0',
  Date varchar(100) NOT NULL default '',
  ItemID bigint(20) NOT NULL default '0',
  ItemSKU varchar(25) NOT NULL default '',
  ItemName varchar(100) NOT NULL default '',
  ItemCost decimal(7,2) NOT NULL default '0.00',
  ShippingCost decimal(6,2) NOT NULL default '0.00',
  ItemQuantity int(11) NOT NULL default '0',
  TotalCost decimal(8,2) NOT NULL default '0.00',
  ItemOptions text,
  PaymentCycle char(1) NOT NULL default 'O'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `Users`
#

CREATE TABLE Users (
  User varchar(100) NOT NULL default '',
  Date int(4) NOT NULL default '0'
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `admin`
#

CREATE TABLE admin (
  id tinyint(4) unsigned NOT NULL auto_increment,
  username varchar(255) NOT NULL default '',
  password varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `cort_menu`
#

CREATE TABLE cort_menu (
  id mediumint(6) NOT NULL auto_increment,
  pid mediumint(6) NOT NULL default '0',
  name varchar(100) NOT NULL default '0',
  link varchar(30) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# Table structure for table `cort_temp`
#

CREATE TABLE cort_temp (
  id smallint(6) NOT NULL auto_increment,
  name varchar(30) NOT NULL default '',
  body mediumtext NOT NULL,
  type tinyint(4) NOT NULL default '0',
  show_t tinyint(2) NOT NULL default '1',
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) TYPE=MyISAM;

    
