--
-- Host: localhost    Database: superknife
-- ------------------------------------------------------


--
-- Table structure for table `Category`
--

CREATE TABLE `Category` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `protected` int(11) NOT NULL DEFAULT '0',
  `display` int(11) NOT NULL DEFAULT '0',
  `next` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `description` blob,
  `short_description` blob,
  `name` varchar(50) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Category`
--

INSERT INTO `Category` VALUES (1,0,0,0,2,NULL,NULL,'Top Level',NULL,0),(2,0,1,3,0,'','','Super Knives','silver.gif',0),(3,0,1,7,0,'',NULL,'accessories','',0),(7,0,1,0,0,'',NULL,'test','',0);

--
-- Table structure for table `Inventory`
--

CREATE TABLE `Inventory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `categoryID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `categoryID` (`categoryID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Inventory`
--

INSERT INTO `Inventory` VALUES (5,1,2),(40,5,6),(7,4,2),(37,3,2),(8,2,2),(17,7,4),(42,9,3),(43,10,3);

--
-- Table structure for table `Invoice`
--

CREATE TABLE `Invoice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `purchasedby` int(11) NOT NULL DEFAULT '0',
  `deliverto` int(11) NOT NULL DEFAULT '0',
  `processed` int(11) NOT NULL DEFAULT '0',
  `shiptype` varchar(50) DEFAULT NULL,
  `shipcost` double(8,2) NOT NULL DEFAULT '0.00',
  `comment` blob,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Invoice`
--

INSERT INTO `Invoice` VALUES (17,'2004-03-03 00:48:45',22,23,0,'Shipping',0.00,''),(18,'2006-07-01 16:41:45',26,27,0,'Shipping',4.95,'sdfsadsdf');

--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `body` blob,
  `template` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `featured` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `linkname` varchar(50) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` VALUES (1,'Super Knife by CEM is a patented hybrid of a quality pocketknife and a functional utility knife.  The Super Knife features a modern anodized aluminum handle and ergonomic belt clip.  The folding blade holder will accept all standared utility blades including contractor grade blades.',3,0,'silver.gif','Super Knives in 5 Colors','3,5,4,1,2','Super Knife',NULL,NULL),(2,'\r\n<script language=JavaScript>\r\n<!--\r\n\r\nvar message=\"\";\r\n///////////////////////////////////\r\nfunction clickIE() {if (document.all) {(message);return false;}}\r\nfunction clickNS(e) {if \r\n(document.layers||(document.getElementById&&!document.all)) {\r\nif (e.which==2||e.which==3) {(message);return false;}}}\r\nif (document.layers) \r\n{document.captureEvents(Event.MOUSEDOWN);document.onmousedown=clickNS;}\r\nelse{document.onmouseup=clickNS;document.oncontextmenu=clickIE;}\r\n\r\ndocument.oncontextmenu=new Function(\"return false\")\r\n// --> \r\n</script>\r\n\r\nThe Super Knife accepts standard household or contractor grade utility blades and gives them a convenience and versatility never seen before. \r\nSuper Knife is compact and folds to an amazing 3-1/2\" inches long which is small enough for anyone\'s pocket or purse. It easily opens with your thumb and becomes an easy to use utility knife.\r\n<br><br>\r\nEach Super Knife features a easy access belt clip and is made from top quality aircraft grade materials.\r\n<br><br>\r\nBlade changing is a snap with the blade changing tool (included).\r\n<br><br>\r\nThe Blade Swing Arm Adjustment Tool (included) allows you to control the rate that your Super Knife opens and closes.\r\n<br><br>\r\nNot only are Super Knives one of the greatest all around utility knives, they are also rapidly becoming an indispensable tool for Police SWAT Teams, Firefighters, EMS & Rescue Personnel. Add a hooked blade and you\'ve got a folding seatbelt cutter! Super Knife will quickly become you favorite knife!\r\n',3,1,'black.gif',NULL,NULL,'What are Superknives?','What Are Super Knives?',NULL),(5,'This is the extra page\r\n\r\nYeah mmmmmmmmnnnnn',3,1,'',NULL,NULL,'extra page','extra page',NULL),(8,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(9,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(10,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(11,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(12,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(13,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(14,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(15,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(16,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(17,NULL,0,2,NULL,NULL,NULL,NULL,'','');

--
-- Table structure for table `Product`
--

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `short_description` blob,
  `linkname` varchar(50) DEFAULT NULL,
  `link` blob,
  `alloworder` smallint(6) DEFAULT NULL,
  `instock` smallint(6) DEFAULT NULL,
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `list1` longblob,
  `list2` longblob,
  `image` varchar(255) DEFAULT NULL,
  `prices` longblob,
  `weight` double(8,4) NOT NULL DEFAULT '0.0000',
  `display` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `long_description` blob,
  `shipcost` float(10,2) NOT NULL DEFAULT '0.00',
  `number` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Product`
--

INSERT INTO `Product` VALUES (1,'Red Superknife','101','',NULL,NULL,1,1,'','',24.95,'','','red.gif','',0.0000,1,1,'',4.95,1),(2,'Silver Super Knife','102','',NULL,NULL,1,1,'','',24.95,'','','silver.gif','',0.0000,1,1,'',4.95,2),(3,'Black Super Knife','103','',NULL,NULL,1,1,'','',24.95,'','','black.gif','',0.0000,1,1,'',4.95,3),(4,'Purple Super Knife','104','',NULL,NULL,1,1,'','',24.95,'','','purple.gif','',0.0000,1,1,'',4.95,4),(5,'Blue Super Knife','0','',NULL,NULL,1,1,'','',24.95,'','','','',0.0000,1,1,'',4.95,5),(7,'beginner class','0','December 18',NULL,NULL,0,0,'','',0.00,'','','','',0.0000,1,1,'December 18, come learn how to quilt.',0.00,7),(9,'Guy with guitar','0','this is a guy with a guitar',NULL,NULL,1,1,'size','color',1.30,'small, med, large','blue, red, black','guy-guitar.jpg','2.20, 5.00, 10.00',0.0000,1,1,'this is a guy with a guitarsadf dlk fasdlfj lkj flksadj flkas l;k jllkjf lksadjf la',0.00,9),(10,'item 1','1005','short description',NULL,NULL,1,1,'size','',55.00,'small, med, large','','purple.gif','1,2,4',0.0000,1,1,'long description',0.00,10);

--
-- Table structure for table `Sale`
--

CREATE TABLE `Sale` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `invoiceID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sale`
--

INSERT INTO `Sale` VALUES (1,3,1,'Black Super Knife','103',24.95,'','',18);

--
-- Table structure for table `Shipping`
--

CREATE TABLE `Shipping` (
  `carrier` tinytext,
  `method` tinytext,
  `weight` double(16,2) DEFAULT NULL,
  `price` double(16,2) DEFAULT NULL,
  `record_type` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(5) DEFAULT NULL,
  `class` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shipping`
--

INSERT INTO `Shipping` VALUES (NULL,'Ground',5.00,10.00,2,1,NULL,NULL),(NULL,'Ground',10.00,20.00,2,2,NULL,NULL);

--
-- Table structure for table `Shopping`
--

CREATE TABLE `Shopping` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `product` int(11) NOT NULL DEFAULT '0',
  `session` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `label1` tinytext,
  `sitename` tinytext,
  `label2` tinytext,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=62 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shopping`
--

INSERT INTO `Shopping` VALUES (61,1,1265483395,1,'','superknife','');

--
-- Dumping events for database 'superknife'
--

--
-- Dumping routines for database 'superknife'
--


