-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Sep 19, 2016 at 12:26 PM
-- Server version: 5.6.31
-- PHP Version: 5.6.20
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!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 */;
--
-- Database: `tmiva_cart`
--
-- --------------------------------------------------------
--
-- Table structure for table `breads`
--
CREATE TABLE IF NOT EXISTS `breads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`catering` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Dumping data for table `breads`
--
INSERT INTO `breads` (`id`, `name`, `catering`) VALUES
(1, 'Italian (white)', 1),
(2, 'Italian Herb and Cheese', 0),
(3, 'Whole Weat', 1),
(4, 'Hearty Italian', 0),
(5, 'Honey Oat', 0);
-- --------------------------------------------------------
--
-- Table structure for table `catering_groups`
--
CREATE TABLE IF NOT EXISTS `catering_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`order` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `catering_groups`
--
INSERT INTO `catering_groups` (`id`, `name`, `order`) VALUES
(1, 'Party Platters', 0),
(2, 'Giant Subs', 0),
(3, 'Wrap Platters', 0),
(4, 'Cookie Platter', 0),
(5, 'Boxed Lunches', 0);
-- --------------------------------------------------------
--
-- Table structure for table `cheeses`
--
CREATE TABLE IF NOT EXISTS `cheeses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
--
-- Dumping data for table `cheeses`
--
INSERT INTO `cheeses` (`id`, `name`) VALUES
(1, 'Swiss'),
(2, 'Provolone'),
(4, 'White American'),
(5, 'Monterey Cheddar');
-- --------------------------------------------------------
--
-- Table structure for table `extras`
--
CREATE TABLE IF NOT EXISTS `extras` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`price` double NOT NULL DEFAULT '0',
`topping` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `extras`
--
INSERT INTO `extras` (`id`, `name`, `price`, `topping`) VALUES
(1, 'Double Meat', 1, 0),
(2, 'Extra Cheese', 1, 0),
(3, 'Bacon', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `extras_order`
--
CREATE TABLE IF NOT EXISTS `extras_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sandwich_order_id` int(11) NOT NULL DEFAULT '0',
`extra_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=428 ;
--
-- Dumping data for table `extras_order`
--
INSERT INTO `extras_order` (`id`, `sandwich_order_id`, `extra_id`) VALUES
(8, 8, 0),
(7, 7, 0),
(3, 3, 0),
(9, 9, 0),
(10, 10, 3),
(11, 10, 1),
(13, 12, 3),
(14, 13, 3),
(15, 14, 0),
(16, 14, 1),
(17, 14, 2),
(18, 15, 0),
(19, 16, 0),
(20, 17, 0),
(21, 18, 0),
(22, 19, 0),
(23, 20, 0),
(24, 21, 0),
(25, 21, 1),
(26, 21, 2),
(27, 22, 0),
(28, 23, 0),
(29, 24, 0),
(30, 25, 0),
(31, 26, 0),
(32, 26, 1),
(33, 26, 2),
(34, 27, 0),
(35, 28, 0),
(36, 29, 0),
(37, 29, 2),
(38, 30, 0),
(39, 31, 0),
(40, 32, 0),
(41, 33, 0),
(42, 34, 0),
(43, 34, 1),
(44, 35, 0),
(45, 36, 0),
(46, 37, 0),
(47, 38, 0),
(48, 39, 0),
(49, 40, 0),
(50, 40, 2),
(51, 41, 0),
(52, 42, 0),
(53, 43, 0),
(54, 43, 1),
(55, 43, 2),
(56, 44, 0),
(57, 45, 0),
(58, 45, 1),
(59, 45, 2),
(60, 46, 0),
(61, 46, 1),
(62, 46, 2),
(63, 47, 0),
(64, 48, 3),
(65, 48, 1),
(66, 48, 2),
(67, 49, 0),
(68, 49, 2),
(69, 50, 0),
(70, 51, 0),
(71, 52, 0),
(72, 53, 0),
(73, 54, 0),
(74, 55, 0),
(75, 56, 0),
(76, 57, 0),
(77, 58, 0),
(78, 59, 0),
(79, 60, 0),
(80, 60, 2),
(81, 61, 0),
(82, 61, 1),
(83, 61, 2),
(84, 62, 3),
(85, 62, 2),
(86, 63, 0),
(87, 63, 1),
(88, 63, 2),
(89, 64, 3),
(90, 64, 2),
(91, 65, 3),
(92, 65, 2),
(93, 66, 0),
(94, 66, 1),
(95, 67, 0),
(96, 68, 0),
(97, 69, 0),
(98, 70, 0),
(99, 70, 1),
(100, 71, 0),
(101, 71, 1),
(102, 72, 0),
(103, 73, 3),
(104, 73, 1),
(105, 73, 2),
(106, 74, 0),
(107, 74, 1),
(108, 75, 0),
(109, 76, 0),
(110, 77, 0),
(111, 78, 0),
(112, 79, 0),
(113, 80, 0),
(114, 81, 0),
(115, 82, 0),
(116, 83, 0),
(117, 84, 0),
(118, 85, 0),
(119, 86, 0),
(120, 87, 0),
(121, 87, 2),
(122, 88, 0),
(123, 89, 0),
(124, 90, 0),
(125, 91, 0),
(126, 92, 0),
(127, 92, 2),
(128, 93, 0),
(129, 94, 0),
(130, 95, 0),
(131, 96, 0),
(132, 97, 0),
(133, 98, 0),
(134, 99, 0),
(135, 100, 0),
(136, 101, 0),
(137, 102, 0),
(138, 103, 0),
(139, 104, 0),
(140, 105, 0),
(141, 106, 0),
(142, 107, 0),
(143, 108, 0),
(144, 109, 0),
(145, 109, 1),
(146, 110, 0),
(147, 111, 0),
(148, 112, 0),
(149, 113, 0),
(150, 114, 0),
(151, 115, 0),
(152, 116, 0),
(153, 117, 0),
(154, 117, 2),
(155, 118, 0),
(156, 119, 0),
(157, 120, 0),
(158, 121, 0),
(159, 122, 0),
(160, 122, 1),
(161, 123, 0),
(162, 124, 0),
(163, 125, 0),
(164, 126, 0),
(165, 127, 0),
(166, 128, 0),
(167, 129, 0),
(168, 130, 0),
(169, 131, 0),
(170, 132, 0),
(171, 133, 3),
(172, 134, 3),
(173, 135, 3),
(174, 136, 0),
(175, 137, 0),
(176, 138, 0),
(177, 139, 3),
(178, 140, 0),
(179, 141, 0),
(180, 141, 2),
(181, 142, 0),
(182, 143, 0),
(183, 144, 0),
(184, 145, 0),
(185, 145, 1),
(186, 146, 0),
(187, 147, 0),
(188, 148, 0),
(189, 149, 0),
(190, 150, 0),
(191, 151, 0),
(192, 152, 0),
(193, 153, 0),
(194, 154, 0),
(195, 154, 1),
(196, 154, 2),
(197, 155, 0),
(198, 156, 0),
(199, 157, 0),
(200, 158, 0),
(201, 159, 0),
(202, 159, 1),
(203, 159, 2),
(204, 160, 0),
(205, 161, 0),
(206, 161, 2),
(207, 162, 0),
(208, 162, 1),
(209, 163, 0),
(210, 164, 0),
(211, 165, 0),
(212, 166, 0),
(213, 167, 0),
(214, 168, 0),
(215, 169, 0),
(216, 170, 0),
(217, 171, 0),
(218, 172, 0),
(219, 173, 0),
(220, 174, 0),
(221, 175, 0),
(222, 176, 0),
(223, 176, 1),
(224, 177, 0),
(225, 178, 0),
(226, 179, 0),
(227, 180, 0),
(228, 181, 0),
(229, 182, 0),
(230, 183, 0),
(231, 184, 0),
(232, 185, 0),
(233, 186, 0),
(234, 187, 0),
(235, 188, 0),
(236, 189, 0),
(237, 190, 0),
(238, 191, 0),
(239, 192, 0),
(240, 193, 0),
(241, 194, 0),
(242, 195, 0),
(243, 196, 0),
(244, 197, 0),
(245, 198, 0),
(246, 199, 0),
(247, 200, 0),
(248, 201, 0),
(249, 202, 0),
(250, 203, 0),
(251, 204, 0),
(252, 205, 0),
(253, 206, 0),
(254, 207, 3),
(255, 207, 1),
(256, 208, 0),
(257, 209, 3),
(258, 210, 0),
(259, 210, 1),
(260, 210, 2),
(261, 211, 0),
(262, 212, 0),
(263, 213, 0),
(264, 214, 0),
(265, 215, 0),
(266, 216, 0),
(267, 217, 0),
(268, 217, 1),
(269, 218, 0),
(270, 219, 0),
(271, 220, 0),
(272, 221, 0),
(273, 222, 0),
(274, 223, 0),
(275, 224, 0),
(276, 225, 0),
(277, 226, 0),
(278, 227, 0),
(279, 228, 0),
(280, 229, 0),
(281, 230, 0),
(282, 231, 0),
(283, 232, 0),
(284, 233, 0),
(285, 234, 0),
(286, 235, 0),
(287, 236, 0),
(288, 237, 0),
(289, 238, 0),
(290, 239, 0),
(291, 240, 0),
(292, 241, 0),
(293, 242, 0),
(294, 243, 0),
(295, 244, 0),
(296, 245, 0),
(297, 246, 0),
(298, 247, 0),
(299, 248, 0),
(300, 249, 0),
(301, 250, 0),
(302, 251, 0),
(303, 252, 0),
(304, 253, 0),
(305, 254, 0),
(306, 255, 0),
(307, 256, 0),
(308, 257, 0),
(309, 258, 0),
(310, 259, 0),
(311, 260, 0),
(312, 261, 0),
(313, 262, 0),
(314, 263, 0),
(315, 264, 0),
(316, 265, 0),
(317, 266, 0),
(318, 267, 0),
(319, 268, 0),
(320, 269, 0),
(321, 270, 0),
(322, 271, 0),
(323, 272, 0),
(324, 273, 0),
(325, 274, 0),
(326, 275, 0),
(327, 276, 0),
(328, 277, 0),
(329, 278, 0),
(330, 279, 0),
(331, 280, 0),
(332, 281, 0),
(333, 282, 0),
(334, 283, 0),
(335, 284, 0),
(336, 285, 0),
(337, 286, 0),
(338, 287, 0),
(339, 287, 1),
(340, 287, 2),
(341, 288, 0),
(342, 289, 0),
(343, 290, 0),
(344, 291, 0),
(345, 292, 0),
(346, 293, 0),
(347, 294, 0),
(348, 295, 0),
(349, 296, 0),
(350, 297, 3),
(351, 297, 1),
(352, 298, 0),
(353, 299, 0),
(354, 299, 1),
(355, 300, 0),
(356, 301, 0),
(357, 302, 0),
(358, 303, 0),
(359, 304, 0),
(360, 304, 1),
(361, 305, 0),
(362, 305, 1),
(363, 306, 0),
(364, 307, 0),
(365, 308, 0),
(366, 309, 0),
(367, 310, 0),
(368, 311, 0),
(369, 312, 0),
(370, 313, 0),
(371, 314, 0),
(372, 315, 0),
(373, 316, 0),
(374, 317, 0),
(375, 318, 0),
(376, 319, 0),
(377, 320, 0),
(378, 321, 0),
(379, 322, 0),
(380, 323, 0),
(381, 324, 0),
(382, 325, 0),
(383, 326, 0),
(384, 327, 0),
(385, 328, 0),
(386, 329, 0),
(387, 330, 0),
(388, 331, 0),
(389, 332, 0),
(390, 333, 0),
(391, 334, 0),
(392, 335, 0),
(393, 336, 0),
(394, 337, 0),
(395, 338, 0),
(396, 339, 0),
(397, 340, 0),
(398, 341, 0),
(399, 342, 0),
(400, 343, 0),
(401, 344, 0),
(402, 345, 0),
(403, 346, 0),
(404, 347, 0),
(405, 348, 0),
(406, 349, 0),
(407, 350, 0),
(408, 351, 0),
(409, 352, 0),
(410, 353, 3),
(411, 353, 1),
(412, 354, 0),
(413, 355, 0),
(414, 356, 0),
(415, 357, 0),
(416, 358, 0),
(417, 359, 0),
(418, 360, 0),
(419, 361, 0),
(420, 362, 0),
(421, 363, 0),
(422, 364, 0),
(423, 365, 0),
(424, 366, 0),
(425, 366, 2),
(426, 367, 0),
(427, 368, 0);
-- --------------------------------------------------------
--
-- Table structure for table `mailing_list`
--
CREATE TABLE IF NOT EXISTS `mailing_list` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`email` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `mailing_list`
--
INSERT INTO `mailing_list` (`id`, `email`) VALUES
(8, 'mj@email.com'),
(7, 'comment@email.com'),
(6, 'levert@tmiva.com');
-- --------------------------------------------------------
--
-- Table structure for table `newtable`
--
CREATE TABLE IF NOT EXISTS `newtable` (
`id` int(11) NOT NULL DEFAULT '0' COMMENT 'This is a comment'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='this is a table comment';
-- --------------------------------------------------------
--
-- Table structure for table `orders`
--
CREATE TABLE IF NOT EXISTS `orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` varchar(255) NOT NULL DEFAULT '',
`type` varchar(25) NOT NULL DEFAULT '',
`name` varchar(100) NOT NULL DEFAULT '',
`phone` varchar(50) NOT NULL DEFAULT '',
`status` int(11) NOT NULL DEFAULT '0' COMMENT '0 is un-ordered, 1 is pending order, 2 is made, 3 is viewed but not completed, 4 is received by customer',
`placed` int(11) NOT NULL DEFAULT '0',
`pickup` int(11) NOT NULL DEFAULT '0',
`pickup_store` varchar(255) NOT NULL DEFAULT '',
`delivery_address` varchar(255) NOT NULL DEFAULT '',
`catering` tinyint(4) NOT NULL DEFAULT '0',
`comments` text NOT NULL,
`email` varchar(50) NOT NULL DEFAULT '',
`completed` int(11) NOT NULL DEFAULT '0',
`made` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=254 ;
--
-- Dumping data for table `orders`
--
INSERT INTO `orders` (`id`, `sid`, `type`, `name`, `phone`, `status`, `placed`, `pickup`, `pickup_store`, `delivery_address`, `catering`, `comments`, `email`, `completed`, `made`) VALUES
(5, 'dac6ac9e006842722d2291c9f993b8e3', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(6, '460b44ce73ef91446429d4ce6eee8c73', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(7, '9d11b60602bd0e0f57fe8fe8de637200', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(8, 'fe28b48053fdbd0818f2c8eda6b20476', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(10, 'becd3a55a3a456339c101655255c21f1', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(11, '9eba3903a436784d98eb14cc14c1644f', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(12, '436053785e31f428448f9bfa20c17587', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(13, 'a33e21907bdbbb7cb4f27b9ff604a211', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(14, 'ed6d0378b9c071221863dc4947ca797c', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(15, 'e72479adee4d496ba65086b4adfeed9e', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(16, 'c10b0355c010184a6557a5eb352ef7aa', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(17, '2ea03c8455205475fc8ea1855c8fd755', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(18, '7231ad32f2453d68a36de765925b8ba1', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(19, 'ed54d06fc0eeb5543e6dfac152eb762e', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(20, '2ef9cecd068d3701e75caa4afb543768', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(21, 'e2b7264fad391cddbbaa25de1f87a071', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(22, '015b76675782a3a8da35424124946e2b', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(24, '1b6583a855ffd6de9faee6d32d53078c', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(25, '1e56c6fbe5ea49151d303c27dbc09fc1', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(26, '0cdfadcdb04733485e3ceed81bbf6b18', 'delivery', 'Josh', '703 505 4059', 2, 1210015584, 0, '', '901 N. Glebe suite 10', 0, '', '', 1210187478, NULL),
(27, '42faf4e00e0d758d915fe3889ec0c833', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(28, '0cdfadcdb04733485e3ceed81bbf6b18', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(29, '9fce86ccbd7fe3458b3e073698f74bba', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(30, '296f30570122e2490a3dfe8e0e10f87e', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(31, 'ded0e011df9cb433227fb32a0759d4e8', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(32, 'b0931c9336b159a36cfba9835bbacc6f', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(33, 'e118da0f640bc73e529ac8d74591ade4', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(34, '96db0fc3b4ba70733ef596cddbbcb3da', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(35, 'bd4ab05638e5b6e78ce007595360090f', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(36, '84aa4e4f7f68d7845c1ad349a15ef9d5', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(37, '4bb47dd57c4b908dca92455266bafdb0', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(38, 'b8feff4a3bec9dcb6f053182c3062259', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(39, '67a49c8ed2242719eec93bb07a244945', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(40, 'fb10160af7f00e8af20ed0def5676dbf', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(41, 'd8cf6edb5e8cfaa0a32d756218b7b2d0', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(42, '86126e8a37a67bc427e981ffeab2eb61', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(43, 'f3aa85a8b8bf37c5ada7b0df547cf074', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(44, '9c98b15bf5a878810d5eecef9e7f2bff', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(45, '4c044e14c7a134066c01d5d7b2894a7b', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(46, '1b6c4107a4765c10ff602bb10d17363e', 'pickup', 'John Locke', '555-567-1234', 2, 1210728853, 1210729800, 'Next to Taco Bell', '901 N. Glebe Road 1010', 0, '', '', 1214578845, NULL),
(47, '1b6c4107a4765c10ff602bb10d17363e', 'pickup', 'John Locke', '555-567-1234', 2, 1210728853, 1210729800, 'Next to Taco Bell', '', 0, '', '', 1210729862, NULL),
(81, '9cc1816abd48ee35145707eac2b03746', 'pickup', 'James', '7032170905\\', 2, 1214579050, 1214579400, 'Subway Cafe', '', 0, '', '', 1214579172, NULL),
(49, '2c84d636015b468f9fcde5cd05cf7b32', 'pickup', 'John Smith', '555-234-1234', 2, 1210729098, 1210729200, 'Next to Taco Bell', '', 0, '', '', 1214578335, NULL),
(50, '43695488d7cdc9fe44b43f7fa8f2a522', 'pickup', 'Chiplover', '345-556-7632', 2, 1210729150, 1210729800, 'Next to Taco Bell', '', 0, '', '', 1210729867, NULL),
(51, '1c66aef339144d4091be3d73526198c5', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(52, '6dfca41dda72db0f0b6243f5821f7b58', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(53, 'f9f34b7625be3f3229c988294bd19c32', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(54, '24f2f3b47090ccbf3c4dd3d03c8c22be', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(83, '3b0e62011b0fb10669ab51cc4b30a020', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(86, '91f0982ae8ffcd3676e68205434b55ea', 'delivery', 'Jonny Cash', '703 217 0905', 2, 1214586265, 0, '', '1533 Dale Blvd.', 0, '', '', 1214587058, NULL),
(82, 'b439e63ab8dd005e3d1580b836ca6b81', 'pickup', 'Levert', '7032170905', 2, 1214580033, 1214580600, 'Subway Cafe', '', 0, '', '', 1214582549, NULL),
(57, '1dc70714e3764f8852d317fdbb91b5f0', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(58, '64c8e12370b5a29bc3e8e9a6e9647597', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(59, '171991fe7ceafcb2e0757593ca4fe44b', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(60, '5c5782b5caae7b52b19560b20eb841ef', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(61, '22e9c8e6cf65a3cb6302d7d299b22d23', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(62, '6defa81ffa8250834438221aa49bc157', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(63, '7db46026a3ed8f8f5fb5d2e225fae755', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(64, '9e03b53f6f2b08084a7f82bfdf907306', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(65, '7a24c8dac2a104b42dbe91b71771bd3c', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(66, '11e6268700ec4dc99b24b0e6dca6c731', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(67, 'c24477d3997a28e51524a372a0aeab53', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(68, '778c4f196659ee869002d0e804543145', 'pickup', 'Levert James', '7032170905', 2, 1213728261, 1213728600, 'Subway Cafe', '', 0, '', '', 1214578397, NULL),
(69, '04661801d0c0304d2b381c312fd8231e', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(70, '221a76491a3f5fdc709f97a91572d5be', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(71, 'fa7dc1f079c04bfb3826d2b413da7f73', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(72, '537cab1804a21dfc4410f155d692f80e', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(73, 'f73a06a60f35f4a120bf6fd6fa6736dd', 'pickup', 'Levert3-217-0905', '70', 2, 1214510147, 1214510400, 'Subway Cafe', '', 0, '', '', 1214578391, NULL),
(74, 'bc68c77f8a381243201f16543e15a9d0', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(75, '3fd97b39ffa2bf8930f898d7d16b5b88', 'pickup', 'Levert', '703-217-0905', 2, 1214575273, 1214575200, 'Subway Cafe', '', 0, '', '', 1214576999, NULL),
(76, '4ea4030feb0d849615f288a4e61dcd2f', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(77, '5561855f86050e1bb1dc44d609eb0d39', 'pickup', 'test', '7036708205', 2, 1214575918, 1214576400, 'Subway Cafe', '', 0, '', '', 1214576935, NULL),
(78, '6b31b3e9a546a930799b6db44fa324f9', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(79, 'b7ab4e45e0d4b7236644fb49b3e71a9e', 'pickup', 'Jonny Cash', '555-555-1212', 2, 1214577857, 1214578200, 'Subway Cafe', '', 0, '', '', 1214578323, NULL),
(80, 'fdbaeeb4c918de1272fdc445c03a6784', 'pickup', 'Money Bags McGee', '703-555-1212', 2, 1214578010, 1214578200, 'Subway Cafe', '', 0, '', '', 1214578135, NULL),
(85, 'ca5907a7485a2f3e5a0661a6ce3fc78a', 'delivery', 'Levert', '7032170905', 2, 1214585597, 0, '', '12414 Everest Peak Ln', 0, '', '', 1214587997, NULL),
(123, '15e40c27b9d4d48d6602f19f40c03ebd', 'pickup', 'Levert James', '1234567890', 2, 1214597161, 1214597400, 'Subway Cafe', '', 0, 'This is something that i need you to know about my order.', 'levert@tmiva.com', 1215024577, NULL),
(89, '8fd38545c355c38d07bea88c4966e173', 'pickup', 'Levert James', '7032170905', 2, 1214588608, 1214590800, 'Subway Cafe', '', 0, '', '', 1214592727, NULL),
(92, '7f7331633207ac4f67255f3105d0d64b', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(96, '12286749359450ffe4414d26062b0814', 'pickup', 'blah', 'blah', 2, 1214591540, 1214592000, 'Subway Cafe', '', 0, '', '', 1214592731, NULL),
(97, '12286749359450ffe4414d26062b0814', 'pickup', 'blah', 'blah', 2, 1214591540, 1214592000, 'Subway Cafe', '', 0, '', '', 1214592735, NULL),
(124, '75693cc394f5e099c18f3da7ee24f49c', 'pickup', 'Levert James Jr', '7032170905', 2, 1214597281, 1214597400, 'Subway Cafe', '', 0, 'This is somethign important', 'levert@tmiva.com', 1215024741, NULL),
(100, '907d61a273a73826fb93c649112a673c', 'pickup', 'Josh', '703 405 42342', 2, 1214591115, 1214591400, 'Subway Cafe', '', 0, '', '', 1214592719, NULL),
(102, '907d61a273a73826fb93c649112a673c', 'pickup', 'Josh', '703 405 42342', 2, 1214591115, 1214591400, 'Subway Cafe', '', 0, '', '', 1214592723, NULL),
(125, '7a502145e72f722ac810cd87ea08634e', 'delivery', 'Josh West', '1552367555', 2, 1214597431, 0, '', '901 N Glebe St. 1010', 0, '', 'josh@tmiva.com', 1214922527, NULL),
(126, 'b53e3294507b4fade0f634afe1ad1ff6', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(127, 'bccaebe48279c6eacf9aa066a3ec717b', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(128, 'a2b09bc24b83c6d507fdec760682f01c', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(169, '33bcee2f61e7786a95b3e7a4183534fe', 'pickup', 'Levert', '1234567890', 2, 1215026124, 1216249200, 'Subway Cafe', '', 1, '', '', 1215096665, NULL),
(108, '4558ccaa516b1713a4effb1bb7183e0b', 'pickup', 'Levert James', '703-670-8205', 2, 1214592452, 1214592600, 'Subway Cafe', '', 0, '', '', 1214592783, NULL),
(109, '197698db5b79f5d0ad94ff5c9c30eb18', 'pickup', 'Name', 'number', 2, 1214592541, 1214592600, 'Subway Cafe', '', 0, 'comment', '', 1214592743, NULL),
(130, 'e87a7ade1b56cb83929cac797761b4ba', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(131, '8d74e6b82ac9768c45a816584b1881c1', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(132, 'd4dc780437c3e341e835c6ae5609011a', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(112, 'bbaa329de33ad01388dec38b155dd5d9', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(113, '1e912183b43365fc6c532d6e97051ef5', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(142, '4869a3ef5036bd76be76b45de017e1d8', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(143, 'a6212f897f4a50ddf7e192d788763771', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(133, '3709d43a3960f8c0982f662671c3dbbf', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(134, 'f128192884fe13585937332f4bc5cb9e', 'pickup', 'Levert', '7032170905', 2, 1214950836, 1214951400, 'Subway Cafe', '', 0, '', '', 1215024783, NULL),
(135, '488e1e6f410d3d551c2a406053920cde', 'pickup', 'Levert', 'James', 2, 1214949329, 1214949600, 'Subway Cafe', '', 0, '', '', 1215024763, NULL),
(171, '60094afb3f157e4100f9c1d76c9497e2', 'delivery', 'tester', '1234567890', 2, 1215026580, 1216202400, '', 'Home', 1, '', '', 1215096747, NULL),
(137, '2a6d1ab8bcc248a87231fab1f17a7ea0', 'pickup', 'Levert', '7035551212', 2, 1214950391, 1214950800, 'Subway Cafe', '', 0, '', '', 1215024778, NULL),
(174, 'c7c824694d5cfea6dee3b873001dd1fb', 'delivery', 'blah', '1234567890', 2, 1215027392, 1215565800, '', 'A place', 1, '', '', 1215096679, NULL),
(140, 'bffb5c9dacf7cb6b0f0cf19da571f262', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(141, '233bce93427404395f85ec2ecd9c0bdb', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(144, '2b5423bc83206e5c2069c3cdd202271a', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(145, '905f754c6340859976f64d7c0f271302', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(146, '556a4df9fe3c0c17e0a242d747b95d71', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(147, '1125e51354dfaee269e629784ad8ec53', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(148, 'c06ed9e7207415112d0b5933d3cc20f3', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(149, '5a449def890d97b799469e774642b966', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(150, '2db731e41d4c21c0bf0f18e7e541d0c7', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(151, '95080034ff4f5a843cb844cc4915abb8', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(152, '4c4184c46504f825b66789ac364ed89c', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(153, '362e74a7dcd14699282cceda8dea71f6', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(154, '4c58ea444362bdc249c38e0edf2fee8e', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(155, '0931a02b5ec6d1f6124150ed459d46da', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(173, '4c5c696bce4bb50178ac7a0bfb1165ef', 'pickup', 'Me', '1234567890', 2, 1215027318, 1216064400, 'Subway Cafe', '', 1, '', '', 1215096639, NULL),
(157, '58e2d3d3f6a1301f1a19783d585426ec', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(158, '6e3d29489b6e475990c12fedcc6c947e', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(160, 'b7b9ab5abb01c6c8e47604f7875776fa', 'delivery', 'Cater Guy', '7035551212', 2, 1215013123, 0, '', 'My Addy', 1, '', '', 1215024951, NULL),
(161, '43c437e4cd7fac62f1bf7a2224071bc8', 'delivery', 'Name', '1111111111', 2, 1215013307, 0, '', 'my place', 1, '', '', 1215024963, NULL),
(162, '9cc5c9d9e400cbc41c875c07645f153f', 'delivery', 'Name', '1234567890', 2, 1215013583, 1215013800, '', 'Address', 1, 'Comment', '', 1215024969, NULL),
(163, '522d7218f9b9ea2941c2e77006b8b073', 'delivery', 'Levert', '1234567890', 2, 1215018434, 0, '', 'My place', 1, '', '', 1215024957, NULL),
(164, '2563dc6d2fb99b96410ed94c3f107e09', 'delivery', 'Mary Jane Watson', '1234567890', 2, 1215020749, 1215022200, '', 'Park St.', 1, '', '', 1215024975, NULL),
(172, 'a21fe9d5a5a3771a51366f3351ff81a0', 'pickup', 'ihoih', '1234567890', 2, 1215027044, 1215027600, 'Subway Cafe', '', 0, '', '', 1215031702, NULL),
(166, '4a6fd8e37ba53555586f489b8d1b30f7', 'pickup', 'Tony Stark', '1234567890', 2, 1215021895, 0, 'Pike 7 Plaza', '', 1, 'Hey there', '', 1215024552, NULL),
(167, '350943ea86a1bdefb6139d5636ec2340', 'pickup', 'Tony danze', '1234567890', 2, 1215022153, 0, 'Subway Cafe', '', 1, 'This is something', '', 1215024844, NULL),
(170, 'd3534dfac67dd79a8da895385ef9431a', 'delivery', 'Test', '1234567890', 2, 1215026363, 1215662400, '', 'here', 1, '', '', 1215096686, NULL),
(193, 'cd55c6ac5ead441b1fa362cda9437356', 'delivery', 'Mary jane Watson', '4545551212', 2, 1215096469, 0, '', 'Park St.', 0, 'I want this with my order', 'mj@email.com', 1215096597, NULL),
(192, 'd0ed32e71a5d37babc735111aa9eb680', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(194, '4b3d868f84504300aa52e4becb809bad', 'pickup', 'h', '1234567890', 2, 1215097092, 1215097200, 'Subway Cafe', '', 0, '', '', 1215463092, NULL),
(191, 'd89616d68ba24907de949f74657b9d17', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(181, '6a0ffcb41e524a1c51aac027c39852cb', 'pickup', 'name', '1234567890', 2, 1215029979, 1216256400, 'Subway Cafe', '', 1, 'stuff', '', 1215096672, NULL),
(182, 'e379d9582b302352eff7c58aaa8707e0', 'pickup', 'name', '1234567890', 2, 1215030243, 1216240200, 'Subway Cafe', '', 1, '', '', 1215096645, NULL),
(183, '7a63f597963b43ecac7f127c3b29bc88', 'delivery', 'My name', '1234567890', 2, 1215030383, 1216153800, '', 'My addy', 1, '', '', 1215096697, NULL),
(184, '05be10955f03521faa917070f81a0a51', 'pickup', 'name', '1234567890', 2, 1215030487, 1216240200, 'Subway Cafe', '', 1, '', '', 1215096657, NULL),
(189, '31eb25cc956713eb0ddf7f91385ce8c5', 'pickup', 'John', '32424', 2, 1215039452, 1215039600, 'Subway Cafe', '', 0, '', '', 1215091710, NULL),
(186, '6f807daa24fe892ef6260341c72242e9', 'delivery', 'name', '1234567890', 2, 1215030577, 0, '', 'place', 0, 'stuff', '', 1215096590, NULL),
(187, 'be8182d05975be3de74ce28cbdda92b1', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(188, '3e3c9cd042270625120cd3f0a1424090', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(206, '3a4f2189d6abd7fe98b8b6266ca59ef6', 'pickup', 'Levert', '1234567890', 3, 1215463484, 1215604800, 'Subway Cafe', '', 1, '', '', 0, NULL),
(196, '4df36e775f6ea5148d4d5215d177ecb2', 'pickup', 'Levert', '987654321', 2, 1215442532, 1216311600, 'Subway Cafe', '', 1, '', '', 1215463030, NULL),
(248, '4e10c1cfad479a6d50dca63edb8db651', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(246, 'b0f70cf91d1738dfd2c63ac27dcb842b', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(198, 'd9c5b01c366c4d42d96639a58d170ce2', 'pickup', 'New Customer', '1234567890', 2, 1215451373, 1216737000, 'Subway Cafe', '', 1, '', '', 1215463016, NULL),
(200, '40ebab0c5168e9c76f10c0adc9d29a41', 'pickup', 'levert', '1234567890', 2, 1215454165, 1216296000, 'Subway Cafe', '', 1, '', '', 1215463049, NULL),
(251, '64457991315d99749491afd14786a5b6', 'pickup', 'name', '1234567890', 1, 1216671018, 1216672200, 'Subway Cafe', '', 0, '', '', 0, NULL),
(204, 'ad21d66f7033609cf7281639cbfa836f', 'pickup', 'My Name', '1234567890', 2, 1215462716, 1216555200, 'Subway Cafe', '', 1, '', '', 1215463023, NULL),
(208, '1ef206aeef480c87e0f45f9765f7ea86', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(249, 'd39e4b9779aa1c3d527af87c7ac8e760', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(211, 'e4b0480c7a9288f3fab0dd72a5aa3261', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(212, '8eed223155eb3e79847980513728955f', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(213, '74698c13fdc3b303365d93df240ced6e', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(214, 'c563168b716675c0bb8df8e8056122da', 'pickup', 'Me', '1234567890', 3, 1215628843, 1216900800, 'Subway Cafe', '', 1, '', '', 0, NULL),
(215, '649ff1d31f82aa14ee440b68adfce809', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(216, '5877002dbab9d9ff8bec14696a5e5d60', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(217, '0a95e96e647efca44f4645f1a412c8dc', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(218, '60839ad474fcc681b900f3bbb7881b56', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(219, 'd820aa70ae454f3ddb831ec508a3b903', 'pickup', 'Levert James', '1234567890', 3, 1215698486, 1216987200, 'Subway Cafe', '', 1, 'I would like this delivered asap', '', 0, NULL),
(220, 'f0401f3d9fa9782a2ef771eca7dd6f67', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(221, '1e54b51eb345328ce59173110bbffed1', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(222, 'dcd4edc42a191329b914acc10d7b7199', 'delivery', 'Levert', '1234567890', 2, 1216304288, 0, '', 'My Place McLean, VA', 0, '', '', 1216323372, NULL),
(223, 'a0cafe297d7f0dc5a578976a35650669', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(247, '366c46126546bad7fd2ca38dc356d1ca', 'delivery', 'James', '1234567890', 3, 1216664269, 1217438100, '', 'Addy McLean, VA', 1, '', '', 0, NULL),
(225, 'bf1a378d54f90f231dbcc35835264a7b', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(242, 'ea3fed9e2c6d60ddf35a4ee0d6d1e224', 'pickup', 'Levert James', '1234567890', 3, 1216654145, 1216677900, 'Tyson''s Mall', '', 0, '', '', 0, NULL),
(228, '365fbcb3e48de878351169dffb22c4e6', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(229, '50dbb3eccaae2ffd8601501866ebd28e', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(244, '40517d9e75ba19b886ed452c0f20a562', 'pickup', 'Levert James', '1234567890', 4, 1216655159, 1216656600, 'Subway Cafe', '', 0, '', '', 0, 1216660539),
(234, '7763d24db8e570ad1e6cc96f0d3fd0a6', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(232, '7bc6809255cc55bb9885bcc063a45c5b', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(241, '3f19010dfca0ce3f4362f975f4bd43f3', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(235, '136eab53180784cbb4d0f2400d50bca1', 'pickup', 'Levert', '1234567890', 1, 1216400581, 1217332800, 'Subway Cafe', '', 1, '', '', 0, NULL),
(239, '5bbabf25f79c2f7dc5944745ad8cd818', 'pickup', 'ki wak', '7038830636', 2, 1216409355, 1216413000, 'Old Courthouse Road', '', 0, '', 'kdkwak@gmail.com', 1216410853, 1216409461),
(250, '1320e4f30318fb8baee653dcefe75cc9', 'pickup', 'Levert', '1234567890', 1, 1216670731, 1217530800, 'Subway Cafe', '', 1, '', '', 0, NULL),
(245, 'a4d8eff9529fd96d70cf58f8674796bd', '', '', '', 0, 0, 0, '', '', 1, '', '', 0, NULL),
(252, '27e30fc6ec13efe9aa84be424bb65180', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL),
(253, '8b5a3157d029d7687ad63403231de7df', '', '', '', 0, 0, 0, '', '', 0, '', '', 0, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `promotions`
--
CREATE TABLE IF NOT EXISTS `promotions` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`offer` varchar(50) NOT NULL DEFAULT '',
`exp_date` int(11) NOT NULL DEFAULT '0',
`location` varchar(25) NOT NULL DEFAULT '',
`active` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `promotions`
--
INSERT INTO `promotions` (`id`, `offer`, `exp_date`, `location`, `active`) VALUES
(1, '$~@1.00@~ off footlong or $~@0.50@~ off 6" sub', 1341979200, 'Old Couthouse Road', 1),
(2, 'Buy One Get One Sub w/ purchase of large drink', 1310011200, 'Old Couthouse Road', 1),
(3, 'Buy One 6" Sub Get One For $~@0.99@~', 0, 'Pike 7 Plaza', 0),
(4, 'Buy two 6" Subs, Get one free', 0, 'Subway Cafe', 1),
(5, '$ ~@0.00@~ meal for two', 0, 'All four Stores', 0),
(6, 'Free Cookie w/ footlong Fresh Value Meal', 0, 'All four Stores', 1),
(7, '3 footlongs for $~@10.99@~', 0, 'All four Stores', 1);
-- --------------------------------------------------------
--
-- Table structure for table `sandwiches`
--
CREATE TABLE IF NOT EXISTS `sandwiches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`group_id` int(11) NOT NULL DEFAULT '0',
`catering` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `sandwiches`
--
INSERT INTO `sandwiches` (`id`, `name`, `group_id`, `catering`) VALUES
(1, 'Turkey Breast', 2, 1),
(2, 'Sweet Onion Chicken Teriyaki', 2, 0),
(3, 'Oven Roasted Chicken Breast', 2, 0),
(4, 'Spicy Italian', 1, 0),
(5, 'Chicken Bacon Ranch', 1, 0),
(6, 'Classic Tuna', 3, 1),
(7, 'Veggie Delite', 2, 1),
(8, 'Roast Beef', 2, 1),
(9, 'Subway Club', 2, 1),
(10, 'The Feast', 4, 0),
(11, 'Turkey Breast and Ham', 2, 0),
(12, 'Big Philly Cheese Steak', 4, 0),
(13, 'Pastrami', 4, 0),
(14, 'Cold Cut Combo', 3, 1),
(15, 'Meatball Marinara', 1, 0),
(17, 'Ham', 2, 1),
(20, 'BLT', 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `sandwiches_groups`
--
CREATE TABLE IF NOT EXISTS `sandwiches_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `sandwiches_groups`
--
INSERT INTO `sandwiches_groups` (`id`, `name`) VALUES
(1, 'Fresh Toasted Subs'),
(2, 'Fresh Fit Choices'),
(3, 'Local Favorites'),
(4, 'Premium');
-- --------------------------------------------------------
--
-- Table structure for table `sandwiches_types`
--
CREATE TABLE IF NOT EXISTS `sandwiches_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sandwich_id` int(11) NOT NULL DEFAULT '0',
`type_id` int(11) NOT NULL DEFAULT '0',
`price` double NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=162 ;
--
-- Dumping data for table `sandwiches_types`
--
INSERT INTO `sandwiches_types` (`id`, `sandwich_id`, `type_id`, `price`) VALUES
(1, 1, 1, 3.39),
(2, 1, 2, 5.39),
(3, 1, 3, 3.69),
(4, 1, 4, 4.89),
(5, 2, 1, 3.69),
(6, 2, 2, 5.69),
(7, 2, 3, 3.69),
(8, 2, 4, 5.19),
(9, 3, 1, 3.69),
(10, 3, 2, 5.69),
(11, 3, 3, 3.69),
(12, 3, 4, 5.19),
(13, 4, 1, 3.99),
(14, 4, 2, 5.99),
(15, 4, 3, 3.99),
(16, 4, 4, 5.46),
(17, 5, 1, 3.39),
(18, 5, 2, 6.59),
(19, 5, 3, 4.29),
(20, 5, 4, 5.79),
(21, 6, 1, 3.39),
(22, 6, 2, 5.39),
(23, 6, 3, 3.39),
(24, 6, 4, 4.89),
(25, 7, 1, 2.79),
(26, 7, 2, 4.79),
(27, 7, 3, 2.79),
(28, 7, 4, 4.29),
(29, 8, 1, 3.69),
(30, 8, 2, 5.69),
(31, 8, 3, 3.69),
(32, 8, 4, 5.19),
(33, 9, 1, 3.39),
(34, 9, 2, 5.39),
(35, 9, 3, 3.39),
(36, 9, 4, 4.89),
(37, 10, 1, 13.69),
(38, 10, 2, 5.69),
(39, 10, 3, 3.69),
(40, 10, 4, 5.19),
(41, 11, 1, 3.39),
(42, 11, 2, 5.39),
(43, 11, 3, 3.39),
(44, 11, 4, 4.89),
(45, 12, 1, 4.29),
(46, 12, 2, 6.59),
(47, 12, 3, 4.29),
(48, 12, 4, 5.79),
(49, 13, 1, 4.29),
(50, 13, 2, 6.59),
(51, 13, 3, 4.29),
(52, 13, 4, 5.79),
(53, 14, 1, 4.29),
(54, 14, 2, 6.59),
(55, 14, 3, 4.29),
(56, 14, 4, 5.79),
(57, 15, 1, 2.99),
(58, 15, 2, 4.99),
(59, 15, 3, 2.99),
(60, 15, 4, 4.59),
(161, 0, 12, 21.99),
(160, 0, 10, 39.99),
(159, 0, 9, 29.99),
(158, 0, 8, 69.99),
(65, 17, 1, 3.39),
(66, 17, 2, 5.39),
(67, 17, 3, 3.39),
(68, 17, 4, 4.89),
(69, 23, 1, 5),
(70, 23, 2, 10),
(71, 23, 3, 15),
(72, 23, 4, 20),
(73, 1, 5, 39.99),
(74, 1, 6, 69.99),
(75, 1, 7, 42.99),
(76, 1, 8, 69.99),
(77, 1, 9, 29.99),
(78, 1, 10, 39.99),
(79, 17, 5, 39.99),
(80, 17, 6, 69.99),
(81, 17, 7, 42.99),
(82, 17, 8, 69.99),
(83, 17, 9, 29.99),
(84, 17, 10, 39.99),
(85, 8, 5, 39.99),
(86, 8, 6, 69.99),
(87, 8, 7, 42.99),
(88, 8, 8, 69.99),
(89, 8, 9, 29.99),
(90, 8, 10, 39.99),
(91, 14, 5, 39.99),
(92, 14, 6, 69.99),
(93, 14, 7, 42.99),
(94, 14, 8, 69.99),
(95, 14, 9, 29.99),
(96, 14, 10, 39.99),
(157, 0, 7, 42.99),
(156, 0, 6, 69.99),
(155, 0, 5, 39.99),
(154, 0, 11, 15.99),
(153, 6, 7, 11),
(152, 6, 6, 10),
(103, 9, 5, 39.99),
(104, 9, 6, 69.99),
(105, 9, 7, 42.99),
(106, 9, 8, 69.99),
(107, 9, 9, 29.99),
(108, 9, 10, 39.99),
(109, 20, 1, 4.75),
(110, 20, 2, 5.75),
(111, 20, 3, 3.45),
(112, 20, 4, 5.25),
(113, 20, 5, 38.99),
(114, 20, 6, 69.99),
(115, 20, 7, 42.99),
(116, 20, 8, 69.99),
(117, 20, 9, 29.99),
(118, 20, 10, 39.99),
(119, 7, 5, 39.99),
(120, 7, 6, 29.99),
(121, 7, 7, 42.99),
(122, 7, 8, 69.99),
(123, 7, 9, 29.99),
(124, 7, 10, 39.99),
(129, 6, 5, 29.99);
-- --------------------------------------------------------
--
-- Table structure for table `sandwich_highlight`
--
CREATE TABLE IF NOT EXISTS `sandwich_highlight` (
`sandwich_id` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `sandwich_highlight`
--
INSERT INTO `sandwich_highlight` (`sandwich_id`) VALUES
(5);
-- --------------------------------------------------------
--
-- Table structure for table `sandwich_order`
--
CREATE TABLE IF NOT EXISTS `sandwich_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`order_id` int(11) NOT NULL DEFAULT '0',
`sandwich_id` int(11) NOT NULL DEFAULT '0',
`type_id` int(11) NOT NULL DEFAULT '0',
`bread_id` int(11) NOT NULL DEFAULT '0',
`cheese_id` int(11) NOT NULL DEFAULT '0',
`toasted` tinyint(4) NOT NULL DEFAULT '0',
`all_toppings` varchar(255) NOT NULL DEFAULT '',
`all_sauces` varchar(255) NOT NULL DEFAULT '',
`combo` tinyint(4) NOT NULL DEFAULT '0',
`snack_id` int(11) NOT NULL DEFAULT '0',
`drink_id` int(11) NOT NULL DEFAULT '0',
`comments` text NOT NULL,
`quantity` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=369 ;
--
-- Dumping data for table `sandwich_order`
--
INSERT INTO `sandwich_order` (`id`, `order_id`, `sandwich_id`, `type_id`, `bread_id`, `cheese_id`, `toasted`, `all_toppings`, `all_sauces`, `combo`, `snack_id`, `drink_id`, `comments`, `quantity`) VALUES
(8, 6, 8, 30, 0, 0, 0, '', '', 0, 0, 0, '', 0),
(7, 5, 3, 11, -1, 2, 0, '', '', 1, 0, 0, '', 0),
(9, 7, 16, 58, 2, 5, 1, '', '', 1, 0, 0, '', 1),
(10, 8, 2, 5, 5, 2, 0, '', '', 1, 0, 0, '', 0),
(15, 12, 3, 10, 4, 0, 0, '', '', 0, 0, 0, 'Toppings: Lettuce, Pickles, Tomato', 0),
(16, 10, 2, 6, 4, 4, 0, '', '', 0, 0, 0, 'Toppings: Lettuce, Extra Olives
Sauces: Side of BBQ Sauce, Lite Buffalo Sauce, Chipotle Southwest, Extra Oil', 0),
(17, 13, 9, 34, 1, 1, 0, '', '', 0, 0, 0, 'Toppings: Lettuce, Banana Peppers
Sauces: BBQ Sauce', 0),
(19, 15, 8, 29, 4, 2, 0, '', '', 0, 0, 0, 'Toppings: Lettuce
No Sauces Selected', 0),
(21, 14, 1, 2, 1, 4, 1, '', '', 0, 0, 0, 'Toppings: Extra Lettuce, Pickles, Extra Tomato, Side of Hot Peppers, Onion, Pepper
No Sauces Selected', 0),
(23, 17, 1, 1, 1, 0, 0, '', '', 0, 0, 0, 'Toppings: No toppings selected
No Sauces Selected', 0),
(142, 71, 12, 46, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(27, 16, 17, 66, 1, 1, 0, '', '', 1, 0, 0, 'No Toppings Selected
No Sauces Selected', 0),
(28, 18, 9, 34, 4, 4, 0, '', '', 0, 0, 0, 'No Toppings Selected
No Sauces Selected', 2),
(29, 19, 17, 66, 1, 2, 0, '', '', 0, 0, 0, 'Toppings: Lettuce
No Sauces Selected', 7),
(30, 19, 3, 10, 2, 2, 1, '', '', 1, 0, 0, 'Toppings: Lite Lettuce, Cucumber, Onion
Sauces: Extra Mayonnaise', 10),
(31, 20, 3, 11, -1, 1, 0, '', '', 0, 0, 0, 'No Toppings Selected
No Sauces Selected', 3),
(32, 19, 2, 7, -1, 2, 0, '', '', 0, 0, 0, 'No Toppings Selected
No Sauces Selected', 3),
(33, 20, 17, 66, 2, 5, 0, '', '', 0, 0, 0, 'Toppings: Lettuce, Pickles
No Sauces Selected', 1),
(34, 21, 1, 2, 2, 2, 0, '', '', 0, 0, 0, 'Toppings: Lettuce
No Sauces Selected', 3),
(35, 21, 3, 11, -1, 2, 0, '', '', 0, 0, 0, 'Toppings: Pickles
No Sauces Selected', 1),
(41, 22, 1, 3, -1, 5, 0, 'Lettuce, Lite Pickles, Banana Peppers, Side of Olives', 'BBQ Sauce, Mayonnaise, Side of Buffalo Sauce, Lite Pepper', 1, 0, 0, '', 1),
(40, 22, 16, 62, 5, 2, 0, 'Toppings: Extra Lettuce, Lite Pickles, Tomato', 'Sauces: Lite BBQ Sauce, Extra Mayonnaise, Side of Mustard', 0, 0, 0, '', 1),
(43, 24, 2, -1, 2, 2, 0, 's Selected', 's Selected', 0, 0, 0, '', 1),
(44, 25, 8, 31, -1, 2, 0, 'Lettuce, Pickles, Tomato', 's Selected', 1, 0, 0, '', 2),
(45, 25, 8, 30, 5, 2, 1, 'Lite Lettuce, Lite Pickles, Banana Peppers, Olives, Onion', 's Selected', 0, 0, 0, '', 1),
(49, 26, 9, 34, 2, 5, 0, 'Lettuce', 'No Sauces Selected', 0, 0, 0, '', 5),
(61, 34, 3, 9, 2, 1, 1, 'Olives', 'Mayonnaise', 1, 0, 0, '', 3),
(55, 31, 11, 42, 2, 2, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(48, 23, 8, 30, 3, 2, 1, 'Lite Lettuce, Extra Pickles, Tomato, Banana Peppers, Bacon', 'BBQ Sauce, Oil, Pepper', 1, 0, 0, '', 1),
(53, 29, 16, 61, 3, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(56, 31, 4, 14, 2, 2, 0, 'Lettuce', 'Mayonnaise', 0, 0, 0, '', 1),
(57, 32, 8, 31, -1, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 3),
(58, 32, 15, 58, 2, 5, 0, 'Lettuce, Pickles, Tomato, Hot Peppers, Olives', 'BBQ Sauce, Mayonnaise, Mustard, Buffalo Sauce, Ranch, Salt', 1, 0, 0, '', 10),
(60, 33, 4, 14, 2, 2, 1, 'Banana Peppers', 'No Sauces Selected', 0, 0, 0, '', 1),
(62, 35, 14, 55, -1, 1, 0, 'Pickles, Lite Tomato, Pepper, Extra Bacon', 'Mayonnaise, Lite Salt', 0, 0, 0, '', 3),
(63, 35, 16, 62, 4, 0, 1, 'Pickles', 'Mayonnaise', 1, 0, 0, '', 1),
(64, 35, 1, 1, 5, 5, 1, 'Lettuce, Pickles, Tomato, Banana Peppers, Cucumber, Hot Peppers, Olives, Onion, Pepper, Bacon', 'Extra BBQ Sauce, Mayonnaise, Mustard, Sweet Onion, Vinegar', 0, 0, 0, '', 2),
(65, 35, 1, 1, 5, 5, 1, 'Lettuce, Pickles, Tomato, Banana Peppers, Cucumber, Hot Peppers, Olives, Onion, Pepper, Bacon', 'Extra BBQ Sauce, Mayonnaise, Mustard, Sweet Onion, Vinegar', 0, 0, 0, '', 1),
(66, 36, 11, 42, 4, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 5),
(86, 40, 2, 7, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(73, 37, 17, 65, 4, 2, 1, 'Bacon', 'No Sauces Selected', 0, 0, 0, '', 1),
(69, 36, 8, 31, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(105, 44, 6, -1, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 6),
(72, 37, 9, 35, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(75, 38, 3, 9, 4, 2, 0, 'Extra Lettuce', 'No Sauces Selected', 0, 0, 0, '', 3),
(96, 43, 16, 62, 2, 5, 1, 'Lite Lettuce, Pickles, Tomato, Banana Peppers, Olives, Onion, Pepper', 'Lite Mayonnaise, Pepper, Salt', 1, 0, 0, '', 2),
(89, 42, 11, 42, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(106, 45, 17, 67, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 4),
(108, 46, 9, 36, -1, 1, 0, 'Lettuce, Pickles', 'No Sauces Selected', 0, 0, 0, '', 1),
(109, 49, 7, 26, 2, 0, 1, 'Lettuce, Pickles, Extra Tomato, Lite Onion', 'No Sauces Selected', 0, 0, 0, '', 1),
(111, 52, 9, 34, 2, 2, 0, 'Lettuce, Extra Pickles, Tomato, Lite Banana Peppers', 'BBQ Sauce', 0, 0, 0, '', 4),
(112, 53, 9, 33, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(113, 55, 3, 10, 2, 0, 0, 'Lettuce, Pickles, Extra Tomato', 'Lite Mayonnaise', 0, 0, 0, '', 1),
(114, 56, 15, 59, -1, 5, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(115, 56, 8, 29, 5, 5, 1, 'Lettuce, Pickles, Tomato, Olives', 'Mayonnaise', 0, 0, 0, '', 2),
(116, 56, 3, 9, -1, 0, 0, 'Lettuce, Extra Pickles, Tomato', 'No Sauces Selected', 0, 0, 0, '', 3),
(117, 58, 17, 65, 2, 4, 0, 'Side of Lettuce, Extra Pickles', 'No Sauces Selected', 0, 0, 0, '', 2),
(118, 59, 4, 15, -1, 1, 0, 'Extra Lettuce, Lite Pickles, Tomato', 'No Sauces Selected', 0, 0, 0, '', 4),
(119, 61, 9, 35, -1, 1, 1, 'Lite Lettuce, Extra Pickles, Cucumber, Onion', 'Mustard', 1, 0, 0, '', 2),
(120, 62, 3, 10, 2, 5, 0, 'Lite Lettuce, Pickles, Tomato', 'BBQ Sauce', 1, 0, 0, '', 1),
(121, 63, 14, 53, 2, 5, 1, 'Lettuce, Tomato', 'No Sauces Selected', 1, 0, 0, '', 1),
(122, 64, 10, 38, -1, 0, 0, 'Lettuce, Extra Pickles, Side of Tomato, Lite Cucumber', 'BBQ Sauce, Mayonnaise', 0, 0, 0, '', 2),
(123, 65, 17, 65, 1, 0, 0, 'Lite Tomato', 'BBQ Sauce, Mayonnaise', 0, 0, 0, '', 1),
(124, 66, 9, 33, -1, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(125, 66, 9, 34, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 0, 0, '', 3),
(126, 67, 3, 10, 2, 1, 0, 'No toppings selected', 'Extra BBQ Sauce, Side of Mayonnaise, Extra Mustard', 1, 0, 0, '', 3),
(128, 68, 10, 39, -1, 1, 0, 'Lite Lettuce, Lite Pickles', 'No Sauces Selected', 1, 0, 0, '', 5),
(129, 68, 9, 34, 1, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 0, 0, '', 1),
(146, 74, 1, 2, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(143, 71, 14, 92, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(144, 72, 16, 98, 3, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(145, 73, 16, 62, 2, 0, 0, 'Lettuce, Banana Peppers', 'No Sauces Selected', 0, 0, 0, '', 1),
(147, 75, 8, 31, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 10, '', 1),
(148, 76, 9, 35, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 10, '', 1),
(149, 76, 9, 34, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 5, 10, '', 1),
(151, 77, 5, 19, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 9, '', 1),
(152, 78, 8, 30, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 9, '', 1),
(153, 79, 1, 2, 4, 1, 1, 'Pickles', 'BBQ Sauce', 1, 6, 9, '', 1),
(154, 80, 24, 126, 2, 2, 1, 'Pickles', 'Mayonnaise', 1, 4, 8, '', 1),
(155, 81, 9, 34, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 5, 10, '', 1),
(156, 82, 11, 43, -1, 4, 0, 'Pickles', 'Mayonnaise', 1, 5, 10, '', 1),
(157, 83, 9, 33, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 9, '', 1),
(160, 84, 12, 46, 1, 2, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 11, 9, '', 2),
(159, 84, 4, 14, 1, 1, 1, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 9, '', 3),
(161, 85, 24, 127, -1, 2, 0, 'Lettuce', 'Mayonnaise', 1, 7, 9, '', 2),
(162, 86, 5, 18, 4, 2, 0, 'Pickles', 'Mayonnaise', 1, 0, 0, '', 1),
(163, 87, 11, 42, 2, 0, 0, 'Pickles', 'Mayonnaise', 0, 0, 0, '', 1),
(164, 88, 11, 43, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(165, 89, 2, 7, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(166, 90, 11, 44, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(167, 91, 3, 12, -1, 0, 0, 'Pickles', 'Mayonnaise', 0, 0, 0, '', 1),
(168, 92, 9, 33, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(169, 93, 15, 57, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(170, 94, 11, 42, 2, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(171, 95, 11, 43, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(172, 96, 1, 3, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(173, 97, 15, 59, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(174, 98, 4, 14, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(175, 99, 11, 42, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(176, 100, 15, 59, -1, 0, 0, 'No Toppings Selected', 'BBQ Sauce, Extra Buffalo Sauce', 0, 0, 0, '', 1),
(177, 101, 11, 42, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(178, 102, 15, 58, 1, 0, 0, 'No Toppings Selected', 'Extra BBQ Sauce', 1, 5, 9, '', 1),
(179, 101, 11, 42, 4, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(180, 103, 11, 42, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(181, 104, 1, 2, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(182, 104, 1, 2, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(183, 105, 11, 42, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(184, 106, 11, 43, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(185, 107, 1, 2, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(186, 108, 11, 43, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 11, 9, '', 1),
(187, 109, 7, 28, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(188, 110, 2, 5, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(189, 111, 7, 25, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(190, 112, 15, 58, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(191, 112, 3, 9, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(192, 113, 11, 43, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(193, 114, 8, 30, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(194, 115, 11, 44, -1, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(195, 116, 4, 13, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(196, 117, 5, 20, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(197, 118, 4, 13, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(198, 119, 3, 10, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(199, 120, 3, 10, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(200, 120, 3, 10, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(201, 121, 4, 16, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(202, 122, 9, 104, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(203, 123, 2, 7, -1, 5, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(204, 124, 11, 41, 2, 0, 1, 'No Toppings Selected', 'No Sauces Selected', 1, 6, 10, '', 1),
(205, 125, 14, 54, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(206, 126, 17, 81, -1, 0, 0, 'Extra Pickles', 'No Sauces Selected', 0, 0, 0, '', 1),
(207, 127, 16, 62, 4, 0, 0, 'Bacon', 'No Sauces Selected', 0, 0, 0, '', 1),
(208, 128, 11, 41, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(209, 129, 30, 144, -1, 2, 0, 'Lettuce, Extra Pickles, Extra Tomato, Side of Olives, Pepper, Bacon', 'Extra Mayonnaise', 1, 6, 10, '', 2),
(210, 129, 17, 65, 2, 1, 1, 'No Toppings Selected', 'No Sauces Selected', 1, 0, 0, '', 1),
(211, 130, 17, 81, -1, 5, 0, 'Lettuce, Pickles, Tomato', 'Extra Mayonnaise, Extra Mustard', 0, 0, 0, '', 1),
(212, 131, 10, 40, -1, 1, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 4),
(213, 132, 14, 91, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 4),
(214, 133, 14, 95, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 6),
(215, 133, 1, 2, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 6),
(216, 133, 1, 2, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(217, 133, 11, 42, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(218, 134, 16, 64, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 0, 0, '', 1),
(219, 134, 2, 7, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 8, '', 1),
(220, 135, 9, 106, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(222, 136, 8, 30, 4, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(223, 137, 30, 144, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 7, 9, '', 1),
(224, 138, 11, 43, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(225, 139, 3, 10, 1, 0, 0, '', '', 0, 0, 0, '', 1),
(226, 140, 16, 99, -1, 0, 0, '', '', 0, 0, 0, '', 1),
(227, 141, 16, 99, -1, 0, 0, '', '', 0, 0, 0, '', 1),
(228, 142, 7, 123, 1, 0, 0, '', '', 0, 0, 0, '', 1),
(229, 143, 30, 148, -1, 0, 0, '', '', 0, 0, 0, '', 1),
(230, 144, 1, 77, 1, 0, 0, '', '', 0, 0, 0, '', 1),
(231, 145, 9, 107, -1, 0, 0, '', '', 0, 0, 0, '', 1),
(232, 146, 7, 121, -1, 0, 0, '', '', 0, 0, 0, '', 1),
(233, 147, 14, 95, 1, 0, 0, '', '', 0, 0, 0, '', 1),
(234, 148, 6, 129, 1, 0, 0, '', '', 0, 0, 0, '', 1),
(235, 149, 14, 95, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(236, 150, 9, 105, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(239, 150, 14, 94, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(240, 150, 16, 102, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(241, 151, 20, 113, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(242, 151, 30, 149, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(243, 152, 6, 129, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(244, 153, 30, 148, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(245, 154, 6, 129, 3, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(246, 154, 14, 93, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 6),
(247, 154, 30, 147, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(248, 155, 10, 38, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(249, 156, 20, 113, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(250, 156, 30, 148, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(251, 157, 14, 95, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(252, 158, 9, 36, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(253, 159, 30, 148, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(254, 160, 30, 146, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(255, 161, 9, 105, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(256, 162, 30, 149, -1, 5, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(257, 163, 30, 149, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(258, 164, 30, 150, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(259, 165, 30, 151, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(260, 166, 9, 103, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(261, 167, 6, 129, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(262, 168, 8, 90, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(263, 169, 8, 90, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(264, 170, 30, 149, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(265, 171, 20, 113, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(266, 172, 12, 48, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(267, 173, 16, 98, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(268, 174, 16, 98, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(269, 175, 13, 51, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(270, 176, 30, 149, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(271, 177, 30, 149, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(272, 178, 16, 98, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(273, 179, 16, 99, -1, 2, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(274, 180, 30, 149, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(275, 181, 1, 75, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(276, 182, 7, 122, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(277, 183, 30, 148, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(278, 184, 7, 121, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(279, 185, 7, 28, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(280, 186, 14, 54, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(281, 187, 16, 62, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(282, 188, 6, 129, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(283, 189, 3, 10, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(284, 190, 14, 93, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(285, 191, 16, 98, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(286, 192, 9, 36, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(287, 193, 20, 111, -1, 1, 0, 'Side of Pickles', 'BBQ Sauce', 1, 11, 10, '', 3),
(288, 194, 3, 10, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(289, 195, 15, 60, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(290, 196, 30, 147, 1, 4, 0, 'Lettuce', 'No Sauces Selected', 0, 0, 0, '', 1),
(291, 197, 4, 16, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(292, 198, 30, 148, -1, 2, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(293, 199, 7, 120, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(294, 200, 8, 86, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(295, 201, 4, 14, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(296, 202, 14, 94, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(297, 203, 30, 145, -1, 0, 0, 'Side of Lettuce, Extra Bacon', 'Mayonnaise, Oil, Extra Ranch, Salt', 1, 11, 10, '', 56),
(298, 204, 8, 87, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(299, 205, 10, 39, -1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 1, 11, 9, '', 1),
(300, 206, 14, 92, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(301, 207, 5, 17, 1, 2, 1, 'Lettuce, Pickles, Tomato, Olives', 'No Sauces Selected', 0, 0, 0, '', 1),
(302, 207, 5, 18, 1, 0, 0, 'Lettuce, Pickles', 'No Sauces Selected', 0, 0, 0, '', 1),
(303, 207, 9, 34, 1, 0, 0, 'No Toppings Selected', 'No Sauces Selected', 0, 0, 0, '', 1),
(304, 208, 4, 14, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(305, 208, 4, 13, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(306, 209, 8, 90, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(307, 210, 12, 48, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(308, 211, 3, 12, -1, 4, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(311, 213, 8, 81, -1, 0, 0, '', '', 0, 0, 0, '', 1),
(312, 214, 0, 81, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(313, 214, 0, 80, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(314, 215, 0, 81, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(315, 216, 0, 81, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(316, 217, 11, 42, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(319, 218, 0, 11, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(329, 220, 0, 80, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(327, 219, 0, 154, 0, 0, 0, '', '', 0, 0, 0, '', 3),
(328, 219, 0, 81, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(330, 221, 0, 81, 0, 0, 0, '', '', 0, 0, 0, '', 5),
(331, 222, 8, 30, 2, 2, 0, 'No toppings selected', 'No Sauces or Spices Selected', 1, 7, 9, '', 1),
(332, 223, 1, 2, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(333, 223, 15, 58, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(334, 224, 7, 27, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(337, 226, 11, 42, 3, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(338, 227, 9, 36, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(339, 228, 0, 77, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(340, 228, 0, 154, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(341, 229, 9, 34, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(342, 230, 4, 14, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(343, 231, 6, 23, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(344, 232, 0, 83, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(345, 233, 4, 16, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(346, 234, 0, 80, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(347, 235, 0, 83, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(348, 236, 4, 15, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(349, 237, 15, 60, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(350, 238, 15, 59, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(351, 239, 4, 14, 5, 2, 1, 'Extra Lettuce, Pickles, Banana Peppers, Hot Peppers, Olives', '', 0, 0, 0, '', 15),
(352, 240, 7, 26, 2, 4, 1, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(353, 240, 8, 30, 3, 2, 1, 'Lettuce, Pickles, Tomato, Onion, Bacon on the side', '', 0, 0, 0, '', 3),
(354, 241, 0, 160, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(355, 242, 4, 14, 1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(356, 242, 9, 35, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(357, 243, 0, 154, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(358, 244, 7, 27, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(359, 245, 0, 159, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(360, 246, 0, 154, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(361, 247, 0, 161, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(362, 248, 11, 43, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 1, 11, 10, '', 1),
(363, 249, 0, 157, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(364, 250, 0, 155, 0, 0, 0, '', '', 0, 0, 0, '', 1),
(365, 251, 9, 36, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(366, 252, 9, 34, 1, 5, 0, 'Extra Lettuce, Extra Cucumber, Extra Onion', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(367, 252, 14, 58, 1, 0, 0, 'Lettuce, Pickles, Cucumber, Onion', 'No Sauces or Spices Selected', 0, 0, 0, '', 1),
(368, 253, 11, 44, -1, 0, 0, 'No Toppings Selected', 'No Sauces or Spices Selected', 0, 0, 0, '', 1);
-- --------------------------------------------------------
--
-- Table structure for table `sauces`
--
CREATE TABLE IF NOT EXISTS `sauces` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`common` tinyint(4) NOT NULL DEFAULT '0',
`catering` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;
--
-- Dumping data for table `sauces`
--
INSERT INTO `sauces` (`id`, `name`, `common`, `catering`) VALUES
(1, 'Mayonnaise', 0, 1),
(12, 'Salt', 0, 0),
(3, 'Honey Mustard', 0, 0),
(4, 'Vinegar', 0, 0),
(5, 'Mustard', 1, 1),
(6, 'Ranch', 0, 0),
(7, 'Sweet Onion', 0, 0),
(8, 'Buffalo Sauce', 0, 0),
(9, 'Chipotle Southwest', 1, 0),
(10, 'BBQ Sauce', 0, 0),
(11, 'Oil', 0, 0),
(13, 'Pepper', 0, 0),
(14, 'Spicy Mustard', 0, 0),
(15, 'Oregano', 0, 0),
(16, 'Light Mayonaise', 1, 0);
-- --------------------------------------------------------
--
-- Table structure for table `sauces_order`
--
CREATE TABLE IF NOT EXISTS `sauces_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sandwich_order_id` int(11) NOT NULL DEFAULT '0',
`sauce_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=421 ;
--
-- Dumping data for table `sauces_order`
--
INSERT INTO `sauces_order` (`id`, `sandwich_order_id`, `sauce_id`) VALUES
(11, 7, 12),
(10, 7, 8),
(9, 7, 10),
(4, 3, 10),
(5, 3, 1),
(12, 8, 0),
(13, 9, 1),
(14, 10, 10),
(15, 10, 1),
(16, 10, 11),
(18, 12, 0),
(19, 13, 0),
(20, 14, 10),
(21, 15, 0),
(22, 16, 10),
(23, 16, 8),
(24, 16, 9),
(25, 16, 11),
(26, 17, 10),
(27, 18, 1),
(28, 19, 0),
(29, 20, 0),
(30, 21, 0),
(31, 22, 10),
(32, 23, 0),
(33, 24, 10),
(34, 25, 0),
(35, 26, 10),
(36, 27, 10),
(37, 28, 0),
(38, 29, 0),
(39, 30, 1),
(40, 31, 0),
(41, 32, 0),
(42, 33, 0),
(43, 34, 0),
(44, 35, 0),
(45, 36, 0),
(46, 37, 0),
(47, 38, 1),
(48, 39, 0),
(49, 40, 10),
(50, 40, 1),
(51, 40, 5),
(52, 41, 10),
(53, 41, 1),
(54, 41, 8),
(55, 41, 13),
(56, 42, 0),
(57, 43, 0),
(58, 44, 0),
(59, 45, 0),
(60, 46, 0),
(61, 47, 0),
(62, 48, 10),
(63, 48, 11),
(64, 48, 13),
(65, 49, 0),
(66, 50, 0),
(67, 51, 0),
(68, 52, 0),
(69, 53, 0),
(70, 54, 0),
(71, 55, 0),
(72, 56, 1),
(73, 57, 0),
(74, 58, 10),
(75, 58, 1),
(76, 58, 5),
(77, 58, 8),
(78, 58, 6),
(79, 58, 12),
(80, 59, 0),
(81, 60, 0),
(82, 61, 1),
(83, 62, 1),
(84, 62, 12),
(85, 63, 1),
(86, 64, 10),
(87, 64, 1),
(88, 64, 5),
(89, 64, 7),
(90, 64, 4),
(91, 65, 10),
(92, 65, 1),
(93, 65, 5),
(94, 65, 7),
(95, 65, 4),
(96, 66, 0),
(97, 67, 0),
(98, 68, 0),
(99, 69, 0),
(100, 70, 0),
(101, 71, 0),
(102, 72, 0),
(103, 73, 0),
(104, 74, 10),
(105, 74, 1),
(106, 74, 5),
(107, 75, 0),
(108, 76, 0),
(109, 77, 0),
(110, 78, 0),
(111, 79, 0),
(112, 80, 0),
(113, 81, 0),
(114, 82, 0),
(115, 83, 0),
(116, 84, 0),
(117, 85, 0),
(118, 86, 0),
(119, 87, 10),
(120, 88, 0),
(121, 89, 0),
(122, 90, 10),
(123, 90, 1),
(124, 91, 0),
(125, 92, 11),
(126, 93, 0),
(127, 94, 0),
(128, 95, 0),
(129, 96, 1),
(130, 96, 13),
(131, 96, 12),
(132, 97, 0),
(133, 98, 0),
(134, 99, 0),
(135, 100, 0),
(136, 101, 0),
(137, 102, 0),
(138, 103, 0),
(139, 104, 0),
(140, 105, 0),
(141, 106, 0),
(142, 107, 0),
(143, 108, 0),
(144, 109, 0),
(145, 110, 0),
(146, 111, 10),
(147, 112, 0),
(148, 113, 1),
(149, 114, 0),
(150, 115, 1),
(151, 116, 0),
(152, 117, 0),
(153, 118, 0),
(154, 119, 5),
(155, 120, 10),
(156, 121, 0),
(157, 122, 10),
(158, 122, 1),
(159, 123, 10),
(160, 123, 1),
(161, 124, 0),
(162, 125, 0),
(163, 126, 10),
(164, 126, 1),
(165, 126, 5),
(166, 127, 10),
(167, 127, 1),
(168, 128, 0),
(169, 129, 0),
(170, 130, 1),
(171, 130, 5),
(172, 131, 0),
(173, 132, 0),
(174, 133, 0),
(175, 134, 0),
(176, 135, 0),
(177, 136, 8),
(178, 136, 11),
(179, 136, 12),
(180, 137, 0),
(181, 138, 0),
(182, 139, 10),
(183, 139, 8),
(184, 139, 11),
(185, 139, 12),
(186, 140, 0),
(187, 141, 0),
(188, 142, 0),
(189, 143, 0),
(190, 144, 0),
(191, 145, 0),
(192, 146, 0),
(193, 147, 0),
(194, 148, 0),
(195, 149, 0),
(196, 150, 0),
(197, 151, 0),
(198, 152, 0),
(199, 153, 10),
(200, 154, 1),
(201, 155, 0),
(202, 156, 1),
(203, 157, 0),
(204, 158, 0),
(205, 159, 0),
(206, 160, 0),
(207, 161, 1),
(208, 162, 1),
(209, 163, 1),
(210, 164, 0),
(211, 165, 0),
(212, 166, 0),
(213, 167, 1),
(214, 168, 0),
(215, 169, 0),
(216, 170, 0),
(217, 171, 0),
(218, 172, 0),
(219, 173, 0),
(220, 174, 0),
(221, 175, 0),
(222, 176, 10),
(223, 176, 8),
(224, 177, 0),
(225, 178, 10),
(226, 179, 0),
(227, 180, 0),
(228, 181, 0),
(229, 182, 0),
(230, 183, 0),
(231, 184, 0),
(232, 185, 0),
(233, 186, 0),
(234, 187, 0),
(235, 188, 0),
(236, 189, 0),
(237, 190, 0),
(238, 191, 0),
(239, 192, 0),
(240, 193, 0),
(241, 194, 0),
(242, 195, 0),
(243, 196, 0),
(244, 197, 0),
(245, 198, 0),
(246, 199, 0),
(247, 200, 0),
(248, 201, 0),
(249, 202, 0),
(250, 203, 0),
(251, 204, 0),
(252, 205, 0),
(253, 206, 0),
(254, 207, 0),
(255, 208, 0),
(256, 209, 1),
(257, 210, 0),
(258, 211, 1),
(259, 211, 5),
(260, 212, 0),
(261, 213, 0),
(262, 214, 0),
(263, 215, 0),
(264, 216, 0),
(265, 217, 0),
(266, 218, 0),
(267, 219, 0),
(268, 220, 0),
(269, 221, 0),
(270, 222, 0),
(271, 223, 0),
(272, 224, 0),
(273, 225, 0),
(274, 226, 0),
(275, 227, 0),
(276, 228, 0),
(277, 229, 0),
(278, 230, 0),
(279, 231, 0),
(280, 232, 0),
(281, 233, 0),
(282, 234, 0),
(283, 235, 0),
(284, 236, 0),
(285, 237, 0),
(286, 238, 0),
(287, 239, 0),
(288, 240, 0),
(289, 241, 0),
(290, 242, 0),
(291, 243, 0),
(292, 244, 0),
(293, 245, 0),
(294, 246, 0),
(295, 247, 0),
(296, 248, 0),
(297, 249, 0),
(298, 250, 0),
(299, 251, 0),
(300, 252, 0),
(301, 253, 0),
(302, 254, 0),
(303, 255, 0),
(304, 256, 0),
(305, 257, 0),
(306, 258, 0),
(307, 259, 0),
(308, 260, 0),
(309, 261, 0),
(310, 262, 0),
(311, 263, 0),
(312, 264, 0),
(313, 265, 0),
(314, 266, 0),
(315, 267, 0),
(316, 268, 0),
(317, 269, 0),
(318, 270, 0),
(319, 271, 0),
(320, 272, 0),
(321, 273, 0),
(322, 274, 0),
(323, 275, 0),
(324, 276, 0),
(325, 277, 0),
(326, 278, 0),
(327, 279, 0),
(328, 280, 0),
(329, 281, 0),
(330, 282, 0),
(331, 283, 0),
(332, 284, 0),
(333, 285, 0),
(334, 286, 0),
(335, 287, 10),
(336, 288, 0),
(337, 289, 0),
(338, 290, 0),
(339, 291, 0),
(340, 292, 0),
(341, 293, 0),
(342, 294, 0),
(343, 295, 0),
(344, 296, 0),
(345, 297, 1),
(346, 297, 11),
(347, 297, 6),
(348, 297, 12),
(349, 298, 0),
(350, 299, 0),
(351, 300, 0),
(352, 301, 0),
(353, 302, 0),
(354, 303, 0),
(355, 304, 0),
(356, 305, 0),
(357, 306, 0),
(358, 307, 0),
(359, 308, 0),
(360, 309, 0),
(361, 310, 0),
(362, 311, 0),
(363, 312, 0),
(364, 313, 0),
(365, 314, 0),
(366, 315, 0),
(367, 316, 0),
(368, 317, 0),
(369, 318, 0),
(370, 319, 0),
(371, 320, 0),
(372, 321, 0),
(373, 322, 0),
(374, 323, 0),
(375, 324, 0),
(376, 325, 0),
(377, 326, 0),
(378, 327, 0),
(379, 328, 0),
(380, 329, 0),
(381, 330, 0),
(382, 331, 0),
(383, 332, 0),
(384, 333, 0),
(385, 334, 0),
(386, 335, 0),
(387, 336, 0),
(388, 337, 0),
(389, 338, 0),
(390, 339, 0),
(391, 340, 0),
(392, 341, 0),
(393, 342, 0),
(394, 343, 0),
(395, 344, 0),
(396, 345, 0),
(397, 346, 0),
(398, 347, 0),
(399, 348, 0),
(400, 349, 0),
(401, 350, 0),
(402, 351, 4),
(403, 352, 0),
(404, 353, 16),
(405, 353, 10),
(406, 354, 0),
(407, 355, 0),
(408, 356, 0),
(409, 357, 0),
(410, 358, 0),
(411, 359, 0),
(412, 360, 0),
(413, 361, 0),
(414, 362, 0),
(415, 363, 0),
(416, 364, 0),
(417, 365, 0),
(418, 366, 0),
(419, 367, 0),
(420, 368, 0);
-- --------------------------------------------------------
--
-- Table structure for table `sides`
--
CREATE TABLE IF NOT EXISTS `sides` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`price` float unsigned NOT NULL DEFAULT '0',
`type` enum('Sides','Drinks','Cookies') NOT NULL DEFAULT 'Sides',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=21 ;
--
-- Dumping data for table `sides`
--
INSERT INTO `sides` (`id`, `name`, `price`, `type`) VALUES
(1, 'Cookie (1)', 0.49, 'Cookies'),
(2, 'Cookies (3)', 1.29, 'Cookies'),
(3, 'Dozen Cookies (12)', 4.49, 'Cookies'),
(4, 'Bag of Chips', 0.89, 'Sides'),
(5, 'Sliced Apples', 0.99, 'Sides'),
(15, 'Rasins', 0.69, 'Sides'),
(7, 'Low Fat Yogurt - Strawberry', 0.99, 'Sides'),
(8, '1% Low Fat Milk', 1.59, 'Drinks'),
(9, '2% Chocolate Milk', 1.69, 'Drinks'),
(10, 'Regular Coffee', 1.39, 'Drinks'),
(11, 'Cookies (2)', 0, 'Sides');
-- --------------------------------------------------------
--
-- Table structure for table `sides_catered`
--
CREATE TABLE IF NOT EXISTS `sides_catered` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`price` varchar(10) NOT NULL DEFAULT '',
`st_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `sides_catered`
--
INSERT INTO `sides_catered` (`id`, `name`, `price`, `st_id`) VALUES
(11, 'Cookie Platter', '15.99', 154);
-- --------------------------------------------------------
--
-- Table structure for table `sides_order`
--
CREATE TABLE IF NOT EXISTS `sides_order` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order_id` int(10) unsigned NOT NULL DEFAULT '0',
`side_id` int(10) unsigned NOT NULL DEFAULT '0',
`quantity` mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ;
--
-- Dumping data for table `sides_order`
--
INSERT INTO `sides_order` (`id`, `order_id`, `side_id`, `quantity`) VALUES
(7, 46, 8, 1),
(6, 45, 8, 5),
(5, 44, 3, 7),
(8, 46, 4, 2),
(9, 47, 7, 2),
(10, 48, 8, 1),
(11, 48, 3, 2),
(12, 49, 7, 1),
(13, 50, 4, 5),
(14, 52, 9, 2),
(15, 53, 4, 1),
(16, 54, 2, 1),
(17, 54, 5, 1),
(18, 56, 5, 1),
(19, 57, 9, 1),
(20, 59, 9, 1),
(21, 60, 3, 1),
(22, 64, 9, 23),
(23, 68, 1, 1),
(25, 70, 8, 10),
(26, 70, 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `toppings`
--
CREATE TABLE IF NOT EXISTS `toppings` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`common` tinyint(4) NOT NULL DEFAULT '0',
`catering` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
--
-- Dumping data for table `toppings`
--
INSERT INTO `toppings` (`id`, `name`, `common`, `catering`) VALUES
(1, 'Onion', 0, 0),
(2, 'Cucumber', 0, 0),
(3, 'Olives', 0, 0),
(4, 'Pepper', 0, 1),
(5, 'Lettuce', 1, 1),
(6, 'Hot Peppers', 0, 0),
(7, 'Banana Peppers', 0, 0),
(8, 'Tomato', 1, 1),
(9, 'Pickles', 1, 1);
-- --------------------------------------------------------
--
-- Table structure for table `toppings_order`
--
CREATE TABLE IF NOT EXISTS `toppings_order` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sandwich_order_id` int(11) NOT NULL DEFAULT '0',
`topping_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=552 ;
--
-- Dumping data for table `toppings_order`
--
INSERT INTO `toppings_order` (`id`, `sandwich_order_id`, `topping_id`) VALUES
(10, 7, 3),
(9, 7, 7),
(8, 7, 5),
(4, 3, 8),
(11, 8, 0),
(12, 9, 5),
(13, 9, 9),
(14, 9, 8),
(15, 9, 7),
(16, 9, 1),
(17, 10, 5),
(18, 10, 9),
(19, 10, 8),
(21, 12, 5),
(22, 12, 7),
(23, 12, 3),
(24, 13, 5),
(25, 13, 7),
(26, 13, 3),
(27, 14, 7),
(28, 14, 2),
(29, 15, 5),
(30, 15, 9),
(31, 15, 8),
(32, 16, 5),
(33, 16, 3),
(34, 17, 5),
(35, 17, 7),
(36, 18, 5),
(37, 18, 9),
(38, 18, 8),
(39, 19, 5),
(40, 20, 0),
(41, 21, 5),
(42, 21, 9),
(43, 21, 8),
(44, 21, 6),
(45, 21, 1),
(46, 21, 4),
(47, 22, 5),
(48, 22, 9),
(49, 22, 8),
(50, 22, 3),
(51, 23, 0),
(52, 24, 5),
(53, 24, 9),
(54, 24, 7),
(55, 24, 3),
(56, 25, 0),
(57, 26, 5),
(58, 26, 9),
(59, 27, 5),
(60, 27, 9),
(61, 28, 0),
(62, 29, 5),
(63, 30, 5),
(64, 30, 2),
(65, 30, 1),
(66, 31, 0),
(67, 32, 0),
(68, 33, 5),
(69, 33, 9),
(70, 34, 5),
(71, 35, 9),
(72, 36, 5),
(73, 37, 5),
(74, 37, 9),
(75, 38, 5),
(76, 38, 9),
(77, 39, 0),
(78, 40, 5),
(79, 40, 9),
(80, 40, 8),
(81, 41, 5),
(82, 41, 9),
(83, 41, 7),
(84, 41, 3),
(85, 42, 0),
(86, 43, 0),
(87, 44, 5),
(88, 44, 9),
(89, 44, 8),
(90, 45, 5),
(91, 45, 9),
(92, 45, 7),
(93, 45, 3),
(94, 45, 1),
(95, 46, 5),
(96, 46, 9),
(97, 46, 8),
(98, 46, 6),
(99, 46, 1),
(100, 47, 0),
(101, 48, 5),
(102, 48, 9),
(103, 48, 8),
(104, 48, 7),
(105, 49, 5),
(106, 50, 0),
(107, 51, 5),
(108, 51, 9),
(109, 51, 8),
(110, 52, 0),
(111, 53, 0),
(112, 54, 0),
(113, 55, 0),
(114, 56, 5),
(115, 57, 0),
(116, 58, 5),
(117, 58, 9),
(118, 58, 8),
(119, 58, 6),
(120, 58, 3),
(121, 59, 0),
(122, 60, 7),
(123, 61, 3),
(124, 62, 9),
(125, 62, 8),
(126, 62, 4),
(127, 63, 9),
(128, 64, 5),
(129, 64, 9),
(130, 64, 8),
(131, 64, 7),
(132, 64, 2),
(133, 64, 6),
(134, 64, 3),
(135, 64, 1),
(136, 64, 4),
(137, 65, 5),
(138, 65, 9),
(139, 65, 8),
(140, 65, 7),
(141, 65, 2),
(142, 65, 6),
(143, 65, 3),
(144, 65, 1),
(145, 65, 4),
(146, 66, 0),
(147, 67, 5),
(148, 67, 9),
(149, 67, 8),
(150, 68, 0),
(151, 69, 0),
(152, 70, 5),
(153, 70, 9),
(154, 70, 8),
(155, 71, 5),
(156, 71, 9),
(157, 71, 8),
(158, 72, 0),
(159, 73, 0),
(160, 74, 5),
(161, 74, 9),
(162, 74, 8),
(163, 74, 2),
(164, 75, 5),
(165, 76, 0),
(166, 77, 0),
(167, 78, 0),
(168, 79, 5),
(169, 79, 9),
(170, 80, 0),
(171, 81, 0),
(172, 82, 0),
(173, 83, 0),
(174, 84, 0),
(175, 85, 0),
(176, 86, 0),
(177, 87, 9),
(178, 87, 8),
(179, 87, 7),
(180, 88, 0),
(181, 89, 0),
(182, 90, 9),
(183, 91, 0),
(184, 92, 5),
(185, 92, 9),
(186, 92, 8),
(187, 92, 2),
(188, 92, 6),
(189, 93, 0),
(190, 94, 0),
(191, 95, 0),
(192, 96, 5),
(193, 96, 9),
(194, 96, 8),
(195, 96, 7),
(196, 96, 3),
(197, 96, 1),
(198, 96, 4),
(199, 97, 0),
(200, 98, 0),
(201, 99, 0),
(202, 100, 0),
(203, 101, 0),
(204, 102, 0),
(205, 103, 0),
(206, 104, 0),
(207, 105, 0),
(208, 106, 0),
(209, 107, 5),
(210, 107, 9),
(211, 107, 8),
(212, 108, 5),
(213, 108, 9),
(214, 109, 5),
(215, 109, 9),
(216, 109, 8),
(217, 109, 1),
(218, 110, 0),
(219, 111, 5),
(220, 111, 9),
(221, 111, 8),
(222, 111, 7),
(223, 112, 0),
(224, 113, 5),
(225, 113, 9),
(226, 113, 8),
(227, 114, 0),
(228, 115, 5),
(229, 115, 9),
(230, 115, 8),
(231, 115, 3),
(232, 116, 5),
(233, 116, 9),
(234, 116, 8),
(235, 117, 5),
(236, 117, 9),
(237, 118, 5),
(238, 118, 9),
(239, 118, 8),
(240, 119, 5),
(241, 119, 9),
(242, 119, 2),
(243, 119, 1),
(244, 120, 5),
(245, 120, 9),
(246, 120, 8),
(247, 121, 5),
(248, 121, 8),
(249, 122, 5),
(250, 122, 9),
(251, 122, 8),
(252, 122, 2),
(253, 123, 8),
(254, 124, 0),
(255, 125, 0),
(256, 126, 0),
(257, 127, 9),
(258, 127, 6),
(259, 127, 1),
(260, 127, 4),
(261, 128, 5),
(262, 128, 9),
(263, 129, 0),
(264, 130, 5),
(265, 130, 9),
(266, 130, 4),
(267, 131, 0),
(268, 132, 0),
(269, 133, 5),
(270, 133, 9),
(271, 133, 8),
(272, 133, 7),
(273, 133, 2),
(274, 133, 6),
(275, 133, 3),
(276, 133, 4),
(277, 134, 5),
(278, 134, 9),
(279, 134, 8),
(280, 134, 7),
(281, 134, 2),
(282, 134, 6),
(283, 134, 3),
(284, 134, 4),
(285, 135, 5),
(286, 135, 9),
(287, 135, 8),
(288, 135, 7),
(289, 135, 2),
(290, 135, 6),
(291, 135, 3),
(292, 135, 4),
(293, 136, 9),
(294, 136, 3),
(295, 137, 0),
(296, 138, 0),
(297, 139, 5),
(298, 139, 7),
(299, 139, 3),
(300, 140, 0),
(301, 141, 0),
(302, 142, 0),
(303, 143, 0),
(304, 144, 0),
(305, 145, 5),
(306, 145, 7),
(307, 146, 0),
(308, 147, 0),
(309, 148, 0),
(310, 149, 0),
(311, 150, 0),
(312, 151, 0),
(313, 152, 0),
(314, 153, 9),
(315, 154, 9),
(316, 155, 0),
(317, 156, 9),
(318, 157, 0),
(319, 158, 0),
(320, 159, 0),
(321, 160, 0),
(322, 161, 5),
(323, 162, 9),
(324, 163, 9),
(325, 164, 0),
(326, 165, 0),
(327, 166, 0),
(328, 167, 9),
(329, 168, 0),
(330, 169, 0),
(331, 170, 0),
(332, 171, 0),
(333, 172, 0),
(334, 173, 0),
(335, 174, 0),
(336, 175, 0),
(337, 176, 0),
(338, 177, 0),
(339, 178, 0),
(340, 179, 0),
(341, 180, 0),
(342, 181, 0),
(343, 182, 0),
(344, 183, 0),
(345, 184, 0),
(346, 185, 0),
(347, 186, 0),
(348, 187, 0),
(349, 188, 0),
(350, 189, 0),
(351, 190, 0),
(352, 191, 0),
(353, 192, 0),
(354, 193, 0),
(355, 194, 0),
(356, 195, 0),
(357, 196, 0),
(358, 197, 0),
(359, 198, 0),
(360, 199, 0),
(361, 200, 0),
(362, 201, 0),
(363, 202, 0),
(364, 203, 0),
(365, 204, 0),
(366, 205, 0),
(367, 206, 9),
(368, 207, 0),
(369, 208, 0),
(370, 209, 5),
(371, 209, 9),
(372, 209, 8),
(373, 209, 3),
(374, 209, 4),
(375, 210, 0),
(376, 211, 5),
(377, 211, 9),
(378, 211, 8),
(379, 212, 0),
(380, 213, 0),
(381, 214, 0),
(382, 215, 0),
(383, 216, 0),
(384, 217, 0),
(385, 218, 0),
(386, 219, 0),
(387, 220, 0),
(388, 221, 0),
(389, 222, 0),
(390, 223, 0),
(391, 224, 0),
(392, 225, 0),
(393, 226, 0),
(394, 227, 0),
(395, 228, 0),
(396, 229, 0),
(397, 230, 0),
(398, 231, 0),
(399, 232, 0),
(400, 233, 0),
(401, 234, 0),
(402, 235, 0),
(403, 236, 0),
(404, 237, 0),
(405, 238, 0),
(406, 239, 0),
(407, 240, 0),
(408, 241, 0),
(409, 242, 0),
(410, 243, 0),
(411, 244, 0),
(412, 245, 0),
(413, 246, 0),
(414, 247, 0),
(415, 248, 0),
(416, 249, 0),
(417, 250, 0),
(418, 251, 0),
(419, 252, 0),
(420, 253, 0),
(421, 254, 0),
(422, 255, 0),
(423, 256, 0),
(424, 257, 0),
(425, 258, 0),
(426, 259, 0),
(427, 260, 0),
(428, 261, 0),
(429, 262, 0),
(430, 263, 0),
(431, 264, 0),
(432, 265, 0),
(433, 266, 0),
(434, 267, 0),
(435, 268, 0),
(436, 269, 0),
(437, 270, 0),
(438, 271, 0),
(439, 272, 0),
(440, 273, 0),
(441, 274, 0),
(442, 275, 0),
(443, 276, 0),
(444, 277, 0),
(445, 278, 0),
(446, 279, 0),
(447, 280, 0),
(448, 281, 0),
(449, 282, 0),
(450, 283, 0),
(451, 284, 0),
(452, 285, 0),
(453, 286, 0),
(454, 287, 9),
(455, 288, 0),
(456, 289, 0),
(457, 290, 5),
(458, 291, 0),
(459, 292, 0),
(460, 293, 0),
(461, 294, 0),
(462, 295, 0),
(463, 296, 0),
(464, 297, 5),
(465, 298, 0),
(466, 299, 0),
(467, 300, 0),
(468, 301, 5),
(469, 301, 9),
(470, 301, 8),
(471, 301, 3),
(472, 302, 5),
(473, 302, 9),
(474, 303, 0),
(475, 304, 0),
(476, 305, 0),
(477, 306, 0),
(478, 307, 0),
(479, 308, 0),
(480, 309, 0),
(481, 310, 0),
(482, 311, 0),
(483, 312, 0),
(484, 313, 0),
(485, 314, 0),
(486, 315, 0),
(487, 316, 0),
(488, 317, 0),
(489, 318, 0),
(490, 319, 0),
(491, 320, 0),
(492, 321, 0),
(493, 322, 0),
(494, 323, 0),
(495, 324, 0),
(496, 325, 0),
(497, 326, 0),
(498, 327, 0),
(499, 328, 0),
(500, 329, 0),
(501, 330, 0),
(502, 331, 0),
(503, 332, 0),
(504, 333, 0),
(505, 334, 0),
(506, 335, 0),
(507, 336, 0),
(508, 337, 0),
(509, 338, 0),
(510, 339, 0),
(511, 340, 0),
(512, 341, 0),
(513, 342, 0),
(514, 343, 0),
(515, 344, 0),
(516, 345, 0),
(517, 346, 0),
(518, 347, 0),
(519, 348, 0),
(520, 349, 0),
(521, 350, 0),
(522, 351, 5),
(523, 351, 9),
(524, 351, 7),
(525, 351, 6),
(526, 351, 3),
(527, 352, 0),
(528, 353, 5),
(529, 353, 9),
(530, 353, 8),
(531, 353, 1),
(532, 354, 0),
(533, 355, 0),
(534, 356, 0),
(535, 357, 0),
(536, 358, 0),
(537, 359, 0),
(538, 360, 0),
(539, 361, 0),
(540, 362, 0),
(541, 363, 0),
(542, 364, 0),
(543, 365, 0),
(544, 366, 5),
(545, 366, 2),
(546, 366, 1),
(547, 367, 5),
(548, 367, 9),
(549, 367, 2),
(550, 367, 1),
(551, 368, 0);
-- --------------------------------------------------------
--
-- Table structure for table `types`
--
CREATE TABLE IF NOT EXISTS `types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`catering` tinyint(4) NOT NULL DEFAULT '0',
`order` mediumint(9) NOT NULL DEFAULT '0',
`group_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `types`
--
INSERT INTO `types` (`id`, `name`, `catering`, `order`, `group_id`) VALUES
(1, '6 inch', 0, 0, 0),
(2, 'Footlong', 0, 0, 0),
(3, 'Wrap', 0, 0, 0),
(4, 'Salad', 0, 0, 0),
(5, '3 Foot Giant Sub', 1, 3, 2),
(6, '6 Foot Giant Sub', 1, 4, 2),
(7, 'Regular Wrap Platter (10 Wraps)', 1, 5, 3),
(8, 'Large Wrap Platter (15 Wraps)', 1, 6, 3),
(9, 'Regular Party Platter (5 footlongs)', 1, 1, 1),
(10, 'Large Party Platter (7 footlongs)', 1, 2, 1),
(11, 'Cookie Platter', 1, 0, 4),
(12, 'Boxed Lunches', 1, 0, 5);
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE IF NOT EXISTS `users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(255) NOT NULL DEFAULT '',
`password` varchar(255) NOT NULL DEFAULT '',
`permission` int(11) NOT NULL DEFAULT '0',
`store` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `username`, `password`, `permission`, `store`) VALUES
(3, 'tmiva', 'cee4bbf6b0fb812afc701f7595447168', 1, 'Subway Cafe'),
(4, 'courthouse', 'cee4bbf6b0fb812afc701f7595447168', 0, 'Old Courthouse Road'),
(5, 'cafe', 'cee4bbf6b0fb812afc701f7595447168', 0, 'Subway Cafe'),
(6, 'pike', 'cee4bbf6b0fb812afc701f7595447168', 0, 'Pike 7 Plaza'),
(7, 'tyson', 'cee4bbf6b0fb812afc701f7595447168', 0, 'Tyson''s Mall');
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;