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 AUTO_INCREMENT=4 ;

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 AUTO_INCREMENT=47 ;
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 AUTO_INCREMENT=3 ;
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 AUTO_INCREMENT=1 ;

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 AUTO_INCREMENT=2 ;

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 AUTO_INCREMENT=1 ;

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 AUTO_INCREMENT=1 ;

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 AUTO_INCREMENT=6 ;

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;

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

