SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


CREATE TABLE IF NOT EXISTS `OrderDetail` (
  `orderdetailid` int(11) NOT NULL auto_increment,
  `orderid` int(11) NOT NULL,
  `lineitem` int(11) NOT NULL,
  `productid` int(11) NOT NULL,
  `price` decimal(10,2) default NULL,
  PRIMARY KEY  (`orderdetailid`),
  KEY `orderdetailid` (`orderdetailid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `OrderHeader` (
  `orderid` int(11) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  `address` varchar(200) NOT NULL,
  `city` varchar(200) NOT NULL,
  `state` varchar(10) default NULL,
  `zip` varchar(10) NOT NULL,
  `apt` varchar(10) default NULL,
  `country` varchar(100) NOT NULL,
  `email` varchar(200) NOT NULL,
  `allowrealnameonlabel` tinyint(1) default NULL,
  `ordertotal` decimal(10,2) default NULL,
  `subtotal` decimal(10,2) default NULL,
  `shipping` decimal(10,2) default NULL,
  `paymentmethod` varchar(100) NOT NULL,
  `orderdate` varchar(100) NOT NULL,
  PRIMARY KEY  (`orderid`),
  KEY `orderid` (`orderid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `Products` (
  `productid` int(11) NOT NULL auto_increment,
  `producttitle` varchar(255) NOT NULL,
  `productdesc` varchar(500) default NULL,
  `price` decimal(10,2) NOT NULL,
  `isfree` tinyint(1) default NULL,
  `isfreeshipping` tinyint(1) default NULL,
  `imageurl` varchar(255) default NULL,
  PRIMARY KEY  (`productid`),
  KEY `productid` (`productid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `ShippingRates` (
  `rateid` int(11) NOT NULL auto_increment,
  `firsttestkit` decimal(10,2) NOT NULL,
  `eachadditionaltest` decimal(10,2) NOT NULL,
  `overnight` decimal(10,2) NOT NULL,
  `canada` decimal(10,2) NOT NULL,
  `international` decimal(10,2) NOT NULL,
  PRIMARY KEY  (`rateid`),
  KEY `rateid` (`rateid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

INSERT INTO `ShippingRates` (`rateid`, `firsttestkit`, `eachadditionaltest`, `overnight`, `canada`, `international`) VALUES
(2, 2.99, 0.99, 20.00, 5.00, 10.00);