--
-- Host: localhost    Database: foodservice
-- ------------------------------------------------------


--
-- 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=15 DEFAULT CHARSET=latin1;

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

INSERT INTO `Category` VALUES (1,0,0,0,6,NULL,NULL,'Top Level',NULL,0),(6,0,1,0,7,'',NULL,'Projects','',0),(9,0,1,12,0,'',NULL,'Bennigans','BENNIGANS.JPG',0),(7,0,1,8,0,'',NULL,'Denny\'s','DENNYS.JPG',0),(8,0,1,10,0,'',NULL,'Chilis','CHILIS.JPG',0),(10,0,1,9,0,'',NULL,'Del Taco','DELTACO.JPG',0),(13,0,1,0,14,'Frozen Custard',NULL,'Caliches','MVC-012S.JPG',0),(12,0,1,13,0,'New Chilis Proto Built by F.S.C for Brinker',NULL,'New Chilis Proto','Chilis-New.jpg',0),(14,0,1,0,0,'Frozen Custard',NULL,'Deming Caliches','MVC-023S.JPG',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=34 DEFAULT CHARSET=latin1;

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

INSERT INTO `Inventory` VALUES (5,1,7),(6,2,7),(8,3,7),(10,4,8),(11,5,8),(18,6,9),(15,7,10),(16,8,10),(17,9,9),(20,10,7),(33,11,12),(29,13,14),(30,14,14),(31,15,8),(32,16,12);

--
-- 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,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- 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=14 DEFAULT CHARSET=latin1;

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

INSERT INTO `Page` VALUES (1,'<P align=left>Food Service Concepts is a full service general contractor and a food service equipment dealer.For detailed information see our services page.</P>\r\n<center>\r\n<table width=100%>\r\n<tr>\r\n<td><tr><img src=\"/Images/thumbnails/DELTACO.JPG\"><BR>\r\n                     Del Taco<br>\r\n<tr><img src=\"/Images/thumbnails/Chilis-New.jpg\"><BR>\r\n                     New Chilis Corp.Proto by F.S.C<br>\r\n                     </td>\r\n<td><tr><img src=\"/Images/thumbnails/BENNIGANS.JPG\"><BR>\r\n                     Bennigan\'s<br>\r\n<tr><img src=\"/Images/thumbnails/DENNYS.JPG\"><BR>\r\n                     Denny\'s<br>  \r\n                     </td>\r\n<td><tr><img \r\n<img src=\"/Images/thumbnails/MVC-012S.JPG\"><BR>\r\n                     Deming Caliches<br>\r\n\r\n</td>\r\n</tr>\r\n</table>\r\n\r\n</center>\r\n\r\n',3,0,'','','','Food Service Concepts',NULL,NULL),(2,'For over ten years, Food Service Concepts (FSC) has specialized in tightly integrating all the services needed to create cost-effective, attractive, innovative projects on the most demanding timetables. This comprehensive approach includes:\r\n<H3>General Construction</H3>\r\nFSC is a licensed general contractor and we can handle a ground up project, remodel or conversion of an existing space.\r\n\r\n<H3>Food Service Equipment</H3>\r\nFSC is a full service dealer/fabricator for all items needed for complete food service projects, including exhaust hoods/buyout equipment, stainless steel fabrication, custom millwork, boothwork, carpeting, etc.\r\n\r\n<H3>Design Services</H3>\r\nFSC has a licensed architect on staff as well as an in-house CAD designer. We can coordinate the design and drawings for the entire project.\r\n',1,1,'',NULL,NULL,'Products & Services','Services',NULL),(3,NULL,0,2,NULL,NULL,NULL,NULL,'Home','http://foodserviceconcepts.net'),(4,NULL,0,2,NULL,NULL,NULL,NULL,'Google Search','http://www.google.com/'),(5,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(6,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(7,NULL,0,2,NULL,NULL,NULL,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,'<H3>Kevin Killham</H3>\r\nKevin Killham is the President and a Director of the Company. He has been with FSC since its inception in 1991 and prior to that had spent 14 years with SYSCO Foods as branch manager in charge of food service design.  His degree is in Construction Management.\r\n<H3>Colleen Killham</H3>\r\nColleen Killham is the CFO of FSC. Her background is in public accounting and prior to founding FSC she was a CPA and CFP with a local public accounting firm in Phoenix. \r\n<H3>David Winter</H3>\r\nDavid Winter is the Vice-President and Director of East Coast Development.  Prior to joining FSC he was with Denny’s as a Senior Project Manager and has considerable experience in design, development and construction.  He is based in Pittsburgh, Pennsylvania.\r\n<H3>Roy McKinney</H3>\r\nRoy is a licensed architect since 1974 and has been with FSC since 1998. Prior to that he had owned his own architectural design firm for 22 years and worked on a diverse list of projects including banks, medical clinics, hospitality, heavy industry and high end residential. He is adept at organizing projects, permitting, presentations before design review boards and meeting deadlines.\r\n<H3>William Keller</H3>\r\nBill has been with FSC since 1997 and heads up the Food Service Equipment Sales Dept. He has over 30 years experience in this industry and has owned four restaurants in Colorado. He has also been a manufacturers rep and design engineer for Forum Restaurants in Kansas City, MO.\r\n',1,1,'',NULL,NULL,'Key Personnel','Key Personnel',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',
  `notax` smallint(6) DEFAULT NULL,
  `inactive` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (1,'Dennys','0','',NULL,NULL,1,1,'','',0.00,'','','DENNYS.JPG','',0.0000,1,1,'',0.00,1,NULL,NULL),(3,'Denny\'s Conversions','0','',NULL,NULL,1,1,'','',0.00,'','','dennyspg.JPG','',0.0000,1,1,'',0.00,3,NULL,NULL),(2,'Ground-up Stores','0','',NULL,NULL,1,1,'','',0.00,'','','dennysnew2.JPG','',0.0000,1,1,'',0.00,2,NULL,NULL),(4,'Chilis Mall Location','0','',NULL,NULL,1,1,'','',0.00,'','','CHILIS.JPG','',0.0000,1,1,'',0.00,4,NULL,NULL),(5,'Chilis Mall Location','0','',NULL,NULL,1,1,'','',0.00,'','','chilispg.JPG','',0.0000,1,1,'',0.00,5,NULL,NULL),(6,'Ground-up Bennigan\'s','0','',NULL,NULL,1,1,'','',0.00,'','','BENNIGANS.JPG','',0.0000,1,1,'',0.00,6,NULL,NULL),(7,'Albuquerque Del Taco','0','',NULL,NULL,1,1,'','',0.00,'','','DELTACO.JPG','',0.0000,1,1,'',0.00,7,NULL,NULL),(8,'Ground-up Del Taco','0','',NULL,NULL,1,1,'','',0.00,'','','deltacopg.JPG','',0.0000,1,1,'',0.00,8,NULL,NULL),(9,'Minnesota Bennigan\'s','0','',NULL,NULL,1,1,'','',0.00,'','','benniganspg.JPG','',0.0000,1,1,'',0.00,9,NULL,NULL),(10,'Denny\'s New Mexico','0','',NULL,NULL,1,1,'','',0.00,'','','dennysnew.JPG','',0.0000,1,1,'',0.00,10,NULL,NULL),(11,'New Chilis Proto','0','',NULL,NULL,1,1,'','',0.00,'','','Chilis-New.jpg','',0.0000,1,1,'New Chilis Proto Type Built by F.S.C for Brinker.\r\n',0.00,11,NULL,NULL),(13,'','0','Caliches Frozen Custard',NULL,NULL,1,1,'','',0.00,'','','MVC-012S.JPG','',0.0000,1,1,'',0.00,13,NULL,NULL),(14,'','0','',NULL,NULL,1,1,'','',0.00,'','','MVC-023S.JPG','',0.0000,1,1,'',0.00,14,NULL,NULL),(15,'','0','',NULL,NULL,1,1,'','',0.00,'','','Chilis-New.jpg','',0.0000,1,1,'',0.00,15,NULL,NULL),(16,'','0','',NULL,NULL,1,1,'','',0.00,'','','Chilis-New.jpg','',0.0000,1,1,'',0.00,16,NULL,NULL);

--
-- 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',
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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


--
-- 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 DEFAULT CHARSET=latin1;

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


--
-- 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 DEFAULT CHARSET=latin1;

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


--
-- Dumping events for database 'foodservice'
--

--
-- Dumping routines for database 'foodservice'
--


