-- --------------------------------------------------------

--
-- Table structure for table `accesslog`
--

CREATE TABLE `accesslog` (
  `url` varchar(100) default NULL,
  `shortdate` varchar(100) default NULL,
  `request_uri` varchar(100) default NULL,
  `visit` varchar(100) default NULL,
  `remote_addr` varchar(100) default NULL,
  `http_user_agent` varchar(100) default NULL,
  `http_referer` varchar(100) default NULL,
  `unixdate` varchar(100) default NULL
);

--
-- Dumping data for table `accesslog`
--


-- --------------------------------------------------------

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `id` int(11) NOT NULL auto_increment,
  `cart_id` varchar(30) NOT NULL default '',
  `cart_row` text NOT NULL,
  `add_time` int(30) NOT NULL default '0',
  `number` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `cart_id` (`cart_id`)
) AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cart`
--


-- --------------------------------------------------------

--
-- Table structure for table `emaillog`
--

CREATE TABLE `emaillog` (
  `address` varchar(100) NOT NULL default '',
  UNIQUE KEY `address` (`address`)
);

--
-- Dumping data for table `emaillog`
--


-- --------------------------------------------------------

--
-- Table structure for table `errorlog`
--

CREATE TABLE `errorlog` (
  `type_of_error` varchar(100) default NULL,
  `file_name` varchar(100) default NULL,
  `line_number` int(11) default NULL,
  `env_vars` text
);

--
-- Dumping data for table `errorlog`
--


-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` int(10) NOT NULL auto_increment,
  `invoice` varchar(20) default NULL,
  `name` varchar(50) default NULL,
  `address` varchar(100) default NULL,
  `city` varchar(50) default NULL,
  `state` varchar(5) default NULL,
  `zip` varchar(15) default NULL,
  `country` varchar(50) default NULL,
  `shiptoname` varchar(50) default NULL,
  `shiptostreet` varchar(100) default NULL,
  `shiptocity` varchar(50) default NULL,
  `shiptostate` varchar(5) default NULL,
  `shiptozip` varchar(15) default NULL,
  `shiptocountry` varchar(50) default NULL,
  `phone` varchar(20) default NULL,
  `fax` varchar(20) default NULL,
  `email` varchar(50) default NULL,
  `method` varchar(50) default NULL,
  `ccname` varchar(100) default NULL,
  `cardnum` varchar(25) default NULL,
  `expdate` varchar(8) default NULL,
  `hw2ship` varchar(50) default NULL,
  `comment` text,
  `quantity` int(10) default NULL,
  `discount` double(6,2) default NULL,
  `category` varchar(50) default NULL,
  `price` double(6,2) default NULL,
  `prdname` varchar(100) default NULL,
  `options` text,
  `prafo` double(6,2) default NULL,
  `line` varchar(10) default NULL,
  `extamt` double(6,2) default NULL,
  `subtotal` double(6,2) default NULL,
  `shipping` double(6,2) default NULL,
  `salestax` double(6,2) default NULL,
  `grandtotal` double(6,2) default NULL,
  `status` int(1) NOT NULL default '0',
  `ip` varchar(15) default NULL,
  `time` varchar(15) default NULL,
  KEY `id` (`id`),
  KEY `invoice` (`invoice`)
);

--
-- Dumping data for table `orders`
--


-- --------------------------------------------------------

--
-- Table structure for table `prd_stats`
--

CREATE TABLE `prd_stats` (
  `id` int(11) NOT NULL default '0',
  `prd` int(11) NOT NULL default '0',
  `count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `prd` (`prd`)
);

--
-- Dumping data for table `prd_stats`
--


-- --------------------------------------------------------

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `rowid` int(9) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `merchantid` varchar(10) NOT NULL default '',
  `merchant` varchar (20) NOT NULL default '',
  `link` varchar(100) NOT NULL default '',
  `thumbnail` text,
  `bigimage` text,
  `price` double(6,2) NOT NULL default '0.00',
  `retailprice` double(6,2) NOT NULL default '0.00',
  `category` varchar(50) NOT NULL default '',
  `subcategory` varchar(50) NOT NULL default '',  
  `description` text,
  `custom1` text,
  `custom2` text,
  `custom3` text,
  `custom4` text,
  `custom5` text,
  `lastupdated` text,
  `status` text,
  `manufacturer` text,
  `partnumber` text,
  `merchantcategory` text,
  `merchantsubcategory` text,
  `shortdescription` text,
  `isbn` text,
  `upc` text,
  PRIMARY KEY  (`rowid`),
  KEY `category` (`category`),
  KEY `name` (`name`)
);

--
-- Dumping data for table `product`
--

-- INSERT INTO `product` VALUES (456004755, 'Books', 23.96, 'Learning Perl', '<IMG SRC="%%URLofImages%%/0001.jpg" BORDER=0>', 'In this smooth, carefully paced course, a leading Perl trainer teaches you to program in the language that threatens to make C, sed, awk, and the Unix shell obsolete for many tasks. This book is the "official" guide for both formal (classroom) and informal learning. It is fully accessible to the novice programmer.<br><br><p align="center"><a href="http://www.amazon.com/exec/obidos/ASIN/1565922840/thebookstore03">MORE INFO</a></p>', 4.00, '', '', '', '', '', '');

INSERT INTO `product` VALUES (456004755,'Xerox 006R01009 Black Toner Cartridge','12015','Toner-N-More', 'http://www.shareasale.com/m-pr.cfm?merchantID=12015&userID=268568&productID=456004755', '', '', '147', '', 'Computer', 'Hardware', 'Original Xerox 006R01009 Black Toner Cartridge Phaser(R) 790 (5500 Yield)', '', '', '', '', '', '03:26.7', 'instock', '', '', '', '', '', '', '456004755');