Crust.sql

-- phpMyAdmin SQL Dump
-- version 4.8.3
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Nov 14, 2018 at 09:26 AM
-- Server version: 10.1.36-MariaDB
-- PHP Version: 7.2.11

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
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 utf8mb4 */;

--
-- Database: `Crust`
--

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

--
-- Table structure for table `Bakery`
--

CREATE TABLE `Bakery` (
  `prodId` int(11) NOT NULL,
  `breadType` varchar(20) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Bakery`
--

INSERT INTO `Bakery` (`prodId`, `breadType`) VALUES
(23, 'Sourdough'),
(102, 'Whole Wheat'),
(111, 'Whole Wheat'),
(202, 'White'),
(360, 'Flatbread'),
(381, 'Sourdough'),
(424, 'Cheesy Bread'),
(490, 'Whole Wheat'),
(577, 'Rye'),
(583, 'Italian'),
(636, 'Rye'),
(700, 'Sourdough'),
(719, 'Sourdough'),
(736, 'Flatbread'),
(781, 'White'),
(828, 'Italian'),
(834, 'White'),
(859, 'White'),
(899, 'Flatbread'),
(954, 'White'),
(981, 'White'),
(996, 'Sourdough');

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

--
-- Table structure for table `Customer`
--

CREATE TABLE `Customer` (
  `cid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Customer`
--

INSERT INTO `Customer` (`cid`) VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),
(10),
(11),
(12),
(13),
(14),
(15),
(16),
(17),
(18),
(19),
(20),
(21),
(22),
(23),
(24),
(25),
(26),
(27),
(28),
(29),
(30),
(31),
(32),
(33),
(34),
(35),
(36),
(37),
(38),
(39),
(40),
(41),
(42),
(43),
(44),
(45),
(46),
(47),
(48),
(49),
(50),
(51),
(52),
(53),
(54),
(55),
(56),
(57),
(58),
(59),
(60),
(61),
(62),
(63),
(64),
(65),
(66),
(67),
(68),
(69),
(71),
(72),
(73),
(74),
(75),
(76),
(77),
(78),
(79),
(80),
(81),
(82),
(83),
(84),
(85),
(86),
(87),
(88),
(89),
(90),
(91),
(92),
(93),
(94),
(95),
(96),
(97),
(98),
(99),
(100),
(101),
(102),
(103),
(104),
(105),
(106),
(107),
(108),
(109),
(110),
(111),
(112),
(113),
(114),
(115),
(116),
(117),
(118),
(119),
(120),
(121),
(122),
(123),
(124),
(125),
(126),
(127),
(128),
(129),
(130),
(131),
(132),
(133),
(134),
(135),
(136),
(137),
(138),
(139),
(140),
(141),
(142),
(143),
(144),
(145),
(146),
(147),
(148),
(149),
(150),
(151),
(152),
(153),
(154),
(155),
(156),
(157),
(158),
(159),
(160),
(161),
(162),
(163),
(164),
(165),
(166),
(167),
(168),
(169),
(170),
(171),
(172),
(173),
(174),
(175),
(176),
(177),
(178),
(179),
(180),
(181),
(182),
(183),
(184),
(185),
(186),
(187),
(188),
(189),
(190),
(191),
(192),
(193),
(194),
(195),
(196),
(197),
(198),
(199),
(200),
(201),
(202),
(203),
(204),
(205),
(206),
(207),
(208),
(209),
(210),
(211),
(212),
(213),
(214),
(215),
(216),
(217),
(218),
(219),
(220),
(221),
(222),
(223),
(224),
(225),
(226),
(227),
(228),
(229),
(230),
(231),
(232),
(233),
(234),
(235),
(236),
(237),
(238),
(239),
(240),
(241),
(242),
(243),
(244),
(245),
(246),
(247),
(248),
(249),
(250),
(251),
(252),
(253),
(254),
(255),
(256),
(257),
(258),
(259),
(260),
(261),
(262),
(263),
(264),
(265),
(266),
(267),
(268),
(269),
(270),
(271),
(272),
(273),
(274),
(275),
(276),
(277),
(278),
(279),
(280),
(281),
(282),
(283),
(284),
(285),
(286),
(287),
(288),
(289),
(290),
(291),
(292),
(293),
(294),
(295),
(296),
(297),
(298),
(299),
(300),
(301),
(302),
(303),
(304),
(305),
(306),
(307),
(308),
(309),
(310),
(311),
(312),
(313),
(314),
(315),
(316),
(317),
(318),
(319),
(320),
(321),
(322),
(323),
(324),
(325),
(326),
(327),
(328),
(329),
(330),
(331),
(332),
(333),
(334),
(335),
(336),
(337),
(338),
(339),
(340),
(341),
(342),
(343),
(344),
(345),
(346),
(347),
(348),
(349),
(350),
(351),
(352),
(353),
(354),
(355),
(356),
(357),
(358),
(359),
(360),
(361),
(362),
(363),
(364),
(365),
(366),
(367),
(368),
(369),
(370),
(371),
(372),
(373),
(374),
(375),
(376),
(377),
(378),
(379),
(380),
(381),
(382),
(383),
(384),
(385),
(386),
(387),
(388),
(389),
(390),
(391),
(392),
(393),
(394),
(395),
(396),
(397),
(398),
(399),
(400),
(401),
(402),
(403),
(404),
(405),
(406),
(407),
(408),
(409),
(410),
(411),
(412),
(413),
(414),
(415),
(416),
(417),
(418),
(419),
(420),
(421),
(422),
(423),
(424),
(425),
(426),
(427),
(428),
(429),
(430),
(431),
(432),
(433),
(434),
(435),
(436),
(437),
(438),
(439),
(440),
(441),
(442),
(443),
(444),
(445),
(446),
(447),
(448),
(449),
(450),
(451),
(452),
(453),
(454),
(455),
(456),
(457),
(458),
(459),
(460),
(461),
(462),
(463),
(464),
(465),
(466),
(467),
(468),
(469),
(470),
(471),
(472),
(473),
(474),
(475),
(476),
(477),
(478),
(479),
(480),
(481),
(482),
(483),
(484),
(485),
(486),
(487),
(488),
(489),
(490),
(491),
(492),
(493),
(494),
(495),
(496),
(497),
(498),
(499),
(500),
(501),
(502),
(503),
(504),
(505),
(506),
(507),
(508),
(509),
(510),
(511),
(512),
(513),
(514),
(515),
(516),
(517),
(518),
(519),
(520),
(521),
(522),
(523),
(524),
(525),
(526),
(527),
(528),
(529),
(530),
(531),
(532),
(533),
(534),
(535),
(536),
(537),
(538),
(539),
(540),
(541),
(542),
(543),
(544),
(545),
(546),
(547),
(548),
(549),
(550),
(551),
(552),
(553),
(554),
(555),
(556),
(557),
(558),
(559),
(560),
(561),
(562),
(563),
(564),
(565),
(566),
(567),
(568),
(569),
(570),
(571),
(572),
(573),
(574),
(575),
(576),
(577),
(578),
(579),
(580),
(581),
(582),
(583),
(584),
(585),
(586),
(587),
(588),
(589),
(590),
(591),
(592),
(593),
(594),
(595),
(596),
(597),
(598),
(599),
(600),
(601),
(602),
(603),
(604),
(605),
(606),
(607),
(608),
(609),
(610),
(611),
(612),
(613),
(614),
(615),
(616),
(617),
(618),
(619),
(620),
(621),
(622),
(623),
(624),
(625),
(626),
(627),
(628),
(629),
(630),
(631),
(632),
(633),
(634),
(635),
(636),
(637),
(638),
(639),
(640),
(641),
(642),
(643),
(644),
(645),
(646),
(647),
(648),
(649),
(650),
(651),
(652),
(653),
(654),
(655),
(656),
(657),
(658),
(659),
(660),
(661),
(662),
(663),
(664),
(665),
(666),
(667),
(668),
(669),
(670),
(671),
(672),
(673),
(674),
(675),
(676),
(677),
(678),
(679),
(680),
(681),
(682),
(683),
(684),
(685),
(686),
(687),
(688),
(689),
(690),
(691),
(692),
(693),
(694),
(695),
(696),
(697),
(698),
(699),
(700),
(701),
(702),
(703),
(704),
(705),
(706),
(707),
(708),
(709),
(710),
(711),
(712),
(713),
(714),
(715),
(716),
(717),
(718),
(719),
(720),
(721),
(722),
(723),
(724),
(725),
(726),
(727),
(728),
(729),
(730),
(731),
(732),
(733),
(734),
(735),
(736),
(737),
(738),
(739),
(740),
(741),
(742),
(743),
(744),
(745),
(746),
(747),
(748),
(749),
(750),
(751),
(752),
(753),
(754),
(755),
(756),
(757),
(758),
(759),
(760),
(761),
(762),
(763),
(764),
(765),
(766),
(767),
(768),
(769),
(770),
(771),
(772),
(773),
(774),
(775),
(776),
(777),
(778),
(779),
(780),
(781),
(782),
(783),
(784),
(785),
(786),
(787),
(788),
(789),
(790),
(791),
(792),
(793),
(794),
(795),
(796),
(797),
(798),
(799),
(800),
(801),
(802),
(803),
(804),
(805),
(806),
(807),
(808),
(809),
(810),
(811),
(812),
(813),
(814),
(815),
(816),
(817),
(818),
(819),
(820),
(821),
(822),
(823),
(824),
(825),
(826),
(827),
(828),
(829),
(830),
(831),
(832),
(833),
(834),
(835),
(836),
(837),
(838),
(839),
(840),
(841),
(842),
(843),
(844),
(845),
(846),
(847),
(848),
(849),
(850),
(851),
(852),
(853),
(854),
(855),
(856),
(857),
(858),
(859),
(860),
(861),
(862),
(863),
(864),
(865),
(866),
(867),
(868),
(869),
(870),
(871),
(872),
(873),
(874),
(875),
(876),
(877),
(878),
(879),
(880),
(881),
(882),
(883),
(884),
(885),
(886),
(887),
(888),
(889),
(890),
(891),
(892),
(893),
(894),
(895),
(896),
(897),
(898),
(899),
(900),
(901),
(902),
(903),
(904),
(905),
(906),
(907),
(908),
(909),
(910),
(911),
(912),
(913),
(914),
(915),
(916),
(917),
(918),
(919),
(920),
(921),
(922),
(923),
(924),
(925),
(926),
(927),
(928),
(929),
(930),
(931),
(932),
(933),
(934),
(935),
(936),
(937),
(938),
(939),
(940),
(941),
(942),
(943),
(944),
(945),
(946),
(947),
(948),
(949),
(950),
(951),
(952),
(953),
(954),
(955),
(956),
(957),
(958),
(959),
(960),
(961),
(962),
(963),
(964),
(965),
(966),
(967),
(968),
(969),
(970),
(971),
(972),
(973),
(974),
(975),
(976),
(977),
(978),
(979),
(980),
(981),
(982),
(983),
(984),
(985),
(986),
(987),
(988),
(989),
(990),
(991),
(992),
(993),
(994),
(995),
(996),
(997),
(998),
(999),
(1000),
(1001),
(1002),
(1003),
(1004),
(1005),
(1006),
(1007),
(1008),
(1009),
(1010),
(1011),
(1012),
(1013),
(1014),
(1015),
(1016),
(1017),
(1018),
(1019),
(1020),
(1021),
(1022),
(1023),
(1024),
(1025),
(1026),
(1027),
(1028),
(1029),
(1030),
(1031),
(1032),
(1033),
(1034),
(1035),
(1036),
(1037),
(1038),
(1039),
(1040),
(1041),
(1042),
(1043),
(1044),
(1045),
(1046),
(1047),
(1048),
(1049),
(1050),
(1051),
(1052),
(1053),
(1054),
(1055),
(1056),
(1057),
(1058),
(1059),
(1060),
(1061),
(1062),
(1063),
(1064),
(1065),
(1066),
(1067),
(1068),
(1069),
(1070),
(1071),
(1072),
(1073),
(1074),
(1075),
(1076),
(1077),
(1078),
(1079),
(1080),
(1081),
(1082),
(1083),
(1084),
(1085),
(1086),
(1087),
(1088),
(1089),
(1090),
(1091),
(1092),
(1093),
(1094),
(1095),
(1096),
(1097),
(1098),
(1099),
(1100),
(1101),
(1102),
(1103),
(1104),
(1105),
(1106),
(1107),
(1108),
(1109),
(1110),
(1111),
(1112),
(1113),
(1114),
(1115),
(1116),
(1117),
(1118),
(1119),
(1120),
(1121),
(1122),
(1123),
(1124),
(1125),
(1126),
(1127),
(1128),
(1129),
(1130),
(1131),
(1132),
(1133),
(1134),
(1135),
(1136),
(1137),
(1138),
(1139),
(1140),
(1141),
(1142),
(1143),
(1144),
(1145),
(1146),
(1147),
(1148),
(1149),
(1150),
(1151),
(1152),
(1153),
(1154),
(1155);

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

--
-- Stand-in structure for view `custview`
-- (See below for the actual view)
--
CREATE TABLE `custview` (
`cid` int(11)
,`Points` int(11)
,`Name` varchar(20)
,`Phone` varchar(10)
,`Email` varchar(32)
,`oid` int(11)
,`customerid` int(11)
,`EmpId` int(11)
,`PaymentMethod` varchar(20)
,`TimeStamp` date
,`OrderPrice` varchar(10)
,`sName` varchar(20)
,`Size` char(1)
,`toasted` tinyint(1)
,`SandwichPrice` double
,`S_VEG` tinyint(1)
,`calories` int(11)
,`iName` char(20)
,`I_VEG` tinyint(1)
);

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

--
-- Table structure for table `Distributor`
--

CREATE TABLE `Distributor` (
  `did` int(11) NOT NULL,
  `Name` varchar(20) CHARACTER SET utf8 NOT NULL,
  `Address` varchar(50) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Distributor`
--

INSERT INTO `Distributor` (`did`, `Name`, `Address`) VALUES
(1, 'Mr. MoveIt', '103 Courtright Street'),
(2, 'Farm Land', '3712 King Ave'),
(28, 'Allegheny Energy', '3176 South Eufaula Avenue'),
(53, 'Sunburst Garden Mana', '333 Main Street'),
(59, 'Gartner', '297 Grant Avenue'),
(73, 'Lexmark', '450 Highland Ave'),
(83, 'Castle Realty', '220 Salem Turnpike'),
(118, 'Bed Bath & Beyond', '1501 Hwy 14 East'),
(121, 'Alert Alarm Company', '4133 Veterans Memorial Drive'),
(158, 'A+ Investments', '16077 Highway 280'),
(164, 'Quantrix', '1717 South College Street'),
(181, 'Sunny Delight Bevera', '170 Fort Morgan Road'),
(216, 'The Liberty Corporat', '200 Sunrise Mall'),
(217, 'Medimix Internationa', '872 Route 13'),
(240, 'Marathon Oil', '43 Stephenville St'),
(248, 'Bountiful Harvest He', '42417 Hwy 195'),
(249, 'NetDNA', '3801 Eastern Blvd'),
(266, 'Dell, Inc.', '279 Troy Road'),
(320, 'Johnson Controls', '80 Town Line Rd'),
(342, 'QuickTrip', '5245 Rangeline Service Rd'),
(361, 'Multicerv', '1916 Center Point Rd'),
(443, 'Agilent Technologies', '900 Boston Post Road'),
(462, 'Quanta Services', '515 Sawmill Road'),
(481, 'ArvinMeritor', '1600 Montclair Rd'),
(500, 'Zapata', '7100 Aaron Aronov Drive'),
(503, 'Honeywell', '20 Soojian Dr'),
(536, 'Safeway Inc.', '626 Olive Street Sw'),
(558, 'Netcore', '515 Sawmill Road'),
(561, 'Rockstar Games', '506 State Road'),
(575, 'Bradley Pharmaceutic', '4133 Veterans Memorial Drive'),
(577, 'DC Shoes', '301 Falls Blvd'),
(593, 'Publix', '1706 Military Street South'),
(639, 'KBR', '1608 W Magnolia Ave'),
(641, 'Asian Answers', '1625 Pelham South'),
(642, 'Sprint Nextel Corpor', '2465 Hempstead Turnpike'),
(703, 'Mauna Loa Macadamia ', '255 W Main St'),
(718, 'DST Systems', '1300 Gilmer Ave'),
(722, 'Gold Touch', '450 Highland Ave'),
(745, 'Bosch Brewing Compan', '315 Foxon Blvd'),
(762, 'Sequoia Voting Syste', '42 Fairhaven Commons Way'),
(777, 'Lawnscape Garden Mai', '72 Main St'),
(793, 'New Balance', '295 Plymouth Street'),
(820, 'Frasca International', '288 Larkin'),
(825, 'Dole Foods', '901 Route 110'),
(870, 'VECO Corporation', '3949 Route 31'),
(876, 'Corinthian Designs', '170 Fort Morgan Road'),
(878, 'Landskip Yard Servic', '420 Buckland Hills Dr'),
(907, 'Integra Investment P', '350 E Fairmount Ave'),
(917, 'Dynegy', '42 Fairhaven Commons Way'),
(931, 'Entergy', '626 Olive Street Sw'),
(942, 'Discover Financial S', '1007 Red Farmer Drive'),
(995, 'Dream Home Real Esta', '24833 Johnt Reidprkw');

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

--
-- Stand-in structure for view `distview`
-- (See below for the actual view)
--
CREATE TABLE `distview` (
`Name` varchar(20)
,`Address` varchar(50)
,`did` int(11)
,`prodid` int(11)
,`ProducerAddress` varchar(50)
,`phone` varchar(10)
,`breadType` varchar(20)
,`MeatType` varchar(50)
,`ProduceType` varchar(20)
,`sid` int(11)
,`fid` int(11)
,`ship_date` date
,`iid` varchar(16)
,`iName` char(20)
,`vegetarian` tinyint(1)
,`bb_date` date
);

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

--
-- Table structure for table `Employee`
--

CREATE TABLE `Employee` (
  `empId` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  `personalId` int(11) DEFAULT NULL,
  `DOB` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Employee`
--

INSERT INTO `Employee` (`empId`, `fid`, `personalId`, `DOB`) VALUES
(1, 0, 420, '2018-11-07'),
(252, 3, 896860032, '1974-11-07'),
(253, 14, 585259345, '1949-02-23'),
(254, 13, 334769881, '1950-05-18'),
(255, 19, 414689964, '1965-11-27'),
(256, 7, 608131588, '1988-04-02'),
(257, 13, 757061199, '1971-11-22'),
(258, 15, 805312244, '1984-07-21'),
(259, 16, 495478971, '1983-06-05'),
(260, 16, 803574201, '1971-12-06'),
(261, 6, 851980044, '1992-02-01'),
(262, 3, 663028393, '1994-02-15'),
(263, 2, 472801816, '1976-12-16'),
(264, 13, 277819607, '1980-07-05'),
(265, 22, 903247567, '1932-02-18'),
(266, 1, 533462646, '1930-06-07'),
(267, 3, 485856286, '1978-03-16'),
(268, 2, 144947721, '1961-01-19'),
(269, 15, 409202479, '1982-08-17'),
(270, 19, 658186758, '1949-12-25'),
(271, 12, 489787976, '1967-01-08'),
(272, 22, 361938215, '1989-02-16'),
(273, 1, 191439053, '1962-02-08'),
(274, 12, 493440596, '2001-03-23'),
(275, 17, 709044942, '1953-11-26'),
(276, 15, 288533538, '1938-03-19'),
(277, 20, 773914557, '1952-06-11'),
(278, 14, 897877280, '1967-10-10'),
(279, 2, 138940817, '1943-02-20'),
(280, 6, 918143703, '1971-05-04'),
(281, 15, 835545122, '1981-12-11'),
(282, 6, 926810375, '1978-12-13'),
(283, 14, 365200618, '1961-10-09'),
(284, 0, 544215607, '1994-08-12'),
(285, 4, 764978303, '1992-04-19'),
(286, 4, 615931823, '1968-01-07'),
(287, 3, 965907558, '1955-02-22'),
(288, 16, 959188123, '1951-06-10'),
(289, 15, 370013865, '1977-01-21'),
(290, 20, 798643858, '1930-06-16'),
(291, 21, 618980458, '1933-05-25'),
(292, 0, 267577031, '1954-11-06'),
(293, 0, 538770875, '1998-07-03'),
(294, 21, 569015683, '1995-09-10'),
(295, 0, 843715928, '1985-01-09'),
(296, 8, 300961810, '1998-11-14'),
(297, 6, 153625317, '1976-07-04'),
(298, 6, 828123509, '1953-12-28'),
(299, 16, 888310349, '1937-02-07'),
(300, 23, 296459422, '2000-07-11'),
(301, 8, 610425293, '1956-01-25'),
(302, 5, 786905410, '1997-09-28'),
(303, 19, 697442559, '1944-06-14'),
(304, 6, 829792132, '1956-02-18'),
(305, 3, 969714922, '1999-01-10'),
(306, 10, 646811259, '1942-04-09'),
(307, 0, 631042703, '1985-12-01'),
(308, 4, 720002461, '1931-01-25'),
(309, 7, 498089733, '1933-09-15'),
(310, 2, 620993962, '1973-07-14'),
(311, 12, 537756826, '1949-03-05'),
(312, 0, 820806758, '1987-12-18'),
(313, 15, 221939681, '1965-12-10'),
(314, 2, 240766053, '1988-12-08'),
(315, 17, 932137818, '1998-05-21'),
(316, 11, 252838544, '2004-08-17'),
(317, 6, 692520733, '2000-03-20'),
(318, 14, 669569124, '1975-05-05'),
(319, 11, 983827062, '1959-01-21'),
(320, 21, 579452453, '1946-11-06'),
(321, 20, 703386425, '1974-09-24'),
(322, 22, 975978261, '1939-02-18'),
(323, 8, 842885578, '1945-05-19'),
(324, 21, 306855880, '1932-06-03'),
(325, 8, 253022282, '1938-08-06'),
(326, 1, 360609598, '1970-08-21'),
(327, 20, 938724955, '1967-05-09'),
(328, 0, 540059293, '1997-05-01'),
(329, 24, 410784983, '1984-03-14'),
(330, 14, 726549016, '1962-09-28'),
(331, 23, 967520084, '1930-07-15'),
(332, 6, 683903794, '1981-07-09'),
(333, 18, 982368875, '1946-05-14'),
(334, 6, 801396288, '1932-06-03'),
(335, 6, 402442957, '1960-12-14'),
(336, 5, 649204414, '1949-05-04'),
(337, 15, 145062619, '1997-10-03'),
(338, 23, 366813714, '1958-05-04'),
(339, 5, 874719840, '2003-09-28'),
(340, 9, 395359741, '1973-04-07'),
(341, 19, 303059581, '1961-03-13'),
(342, 20, 659636962, '1996-01-18'),
(343, 21, 410660685, '1974-07-27'),
(344, 14, 288378774, '1955-10-27'),
(345, 18, 469511554, '1992-11-02'),
(346, 5, 233322999, '1958-03-11'),
(347, 1, 136965903, '1960-06-22'),
(348, 7, 918954407, '1934-07-24'),
(349, 0, 532950745, '1979-06-17'),
(350, 10, 954945144, '1951-10-02'),
(351, 12, 384820239, '1981-11-22'),
(352, 6, 774310742, '2001-08-01'),
(353, 1, 962800469, '1969-09-08'),
(354, 6, 381474559, '1947-12-05'),
(355, 17, 636714825, '1989-12-15'),
(356, 5, 306100941, '1955-06-18'),
(357, 10, 748692315, '2001-01-26'),
(358, 13, 472802597, '1937-12-20'),
(359, 2, 847176665, '1934-09-09'),
(360, 18, 191909903, '1951-06-11'),
(361, 6, 257247438, '1934-07-15'),
(362, 11, 357364175, '2004-08-28'),
(363, 9, 164109171, '1991-10-18'),
(364, 21, 502476347, '1962-06-23'),
(365, 14, 803484435, '1965-10-19'),
(366, 15, 917215986, '1994-09-14'),
(367, 21, 369489706, '1934-12-12'),
(368, 17, 253956643, '1945-06-05'),
(369, 7, 931253689, '1984-10-24'),
(370, 5, 938835280, '1934-06-22'),
(371, 6, 588095038, '1992-07-08'),
(372, 4, 473246560, '1936-09-02'),
(373, 4, 716134134, '1996-01-08'),
(374, 5, 307456632, '1970-12-10'),
(375, 13, 896302744, '1967-10-05'),
(376, 23, 380262730, '1991-01-14'),
(377, 7, 647489190, '1953-01-08'),
(378, 2, 594178763, '1934-06-22'),
(379, 17, 751046297, '1971-03-23'),
(380, 18, 413260176, '1966-03-27'),
(381, 23, 973256873, '1946-02-07'),
(382, 23, 901051451, '1949-02-18'),
(383, 17, 918981517, '1935-03-18'),
(384, 7, 432674003, '1954-01-24'),
(385, 4, 724128389, '2004-03-02'),
(386, 20, 875653283, '1982-07-26'),
(387, 3, 826221018, '2004-12-28'),
(388, 6, 625620770, '1969-11-11'),
(389, 19, 406706502, '1985-07-19'),
(390, 0, 335237698, '1974-05-19'),
(391, 12, 258216010, '1971-09-12'),
(392, 8, 280734651, '1977-06-21'),
(393, 6, 657903650, '1971-12-26'),
(394, 17, 593757728, '1936-01-04'),
(395, 3, 828755797, '1931-09-01'),
(396, 17, 466924195, '1945-06-12'),
(397, 3, 734795269, '1988-12-05'),
(398, 21, 270572020, '1937-10-07'),
(399, 12, 274265765, '1960-01-17'),
(400, 4, 855705891, '2005-12-09'),
(401, 18, 298839619, '1978-03-03'),
(402, 6, 358978137, '1998-03-28'),
(403, 23, 298741620, '1979-07-17'),
(404, 10, 390370291, '1949-11-24'),
(405, 0, 354058704, '1973-05-08'),
(406, 22, 940084016, '1970-04-21'),
(407, 12, 834635486, '1992-10-03'),
(408, 19, 820537926, '1940-04-02'),
(409, 9, 362697281, '1964-10-23'),
(410, 24, 689252681, '1958-06-21'),
(411, 4, 983831484, '1934-03-04'),
(412, 15, 269200287, '1998-10-11'),
(413, 5, 563786905, '1937-08-22'),
(414, 14, 776421361, '1965-08-09'),
(415, 13, 952438731, '1935-01-19'),
(416, 9, 187848253, '1944-06-17'),
(417, 22, 515507610, '1950-06-04'),
(418, 23, 812156526, '1983-01-16'),
(419, 5, 650381021, '1969-08-07'),
(420, 20, 400260135, '1954-09-21'),
(421, 11, 192089354, '1966-12-14'),
(422, 11, 541626226, '1999-06-10'),
(423, 3, 796099590, '1931-09-28'),
(424, 16, 845424449, '1967-10-10'),
(425, 6, 522201575, '1984-01-11'),
(426, 1, 866942757, '1954-07-28'),
(427, 21, 843780445, '1999-05-04'),
(428, 19, 372309518, '1964-11-18'),
(429, 7, 131612686, '1942-11-05'),
(430, 8, 269699383, '2002-05-21'),
(431, 22, 182958120, '1954-03-17'),
(432, 22, 796729465, '1977-02-05'),
(433, 13, 581137070, '1978-06-03'),
(434, 3, 996807099, '1994-07-14'),
(435, 16, 703549921, '1976-05-14'),
(436, 17, 986217099, '1995-08-15'),
(437, 5, 336810288, '1934-04-06'),
(438, 17, 259864329, '1958-04-10'),
(439, 17, 668385816, '1993-08-13'),
(440, 21, 201520128, '1975-04-03'),
(441, 8, 893759846, '1942-05-11'),
(442, 5, 712443451, '1939-07-06'),
(443, 4, 914980105, '2000-08-13'),
(444, 7, 722863535, '1968-04-09'),
(445, 13, 488155531, '1987-08-07'),
(446, 22, 265103833, '1933-09-11'),
(447, 21, 848719820, '1974-04-09'),
(448, 24, 200273065, '1934-08-14'),
(449, 1, 242177492, '1945-12-04'),
(450, 22, 946811510, '1950-02-16'),
(451, 4, 378246610, '1947-11-09'),
(452, 0, 449340199, '1992-01-02'),
(453, 15, 243691918, '1962-10-19'),
(454, 14, 957218032, '1933-02-02'),
(455, 24, 454333545, '1961-12-12'),
(456, 19, 300959797, '1990-11-11'),
(457, 5, 555344614, '1968-06-13'),
(458, 14, 486090459, '1956-10-06'),
(459, 11, 899489782, '1970-12-16'),
(460, 20, 162000753, '1970-06-01'),
(461, 16, 433893389, '1973-10-04'),
(462, 21, 921268188, '1975-09-16'),
(463, 8, 960016371, '1977-11-14'),
(464, 14, 521070605, '1949-01-23'),
(465, 10, 576225957, '1937-02-14'),
(466, 14, 507671108, '2004-05-16'),
(467, 4, 540425982, '1949-12-20'),
(468, 2, 513082643, '1969-07-06'),
(469, 11, 394832565, '1990-07-17'),
(470, 18, 712230800, '1933-05-08'),
(471, 9, 709232766, '1937-06-16'),
(472, 24, 996853191, '1985-07-25'),
(473, 10, 449236495, '1978-05-13'),
(474, 8, 357204841, '1987-06-06'),
(475, 10, 855053858, '1995-05-03'),
(476, 9, 791147632, '1977-09-04'),
(477, 5, 804273028, '1992-06-12'),
(478, 22, 848835365, '2005-06-08'),
(479, 20, 981031944, '1948-10-15'),
(480, 10, 821057638, '1967-04-01'),
(481, 10, 507120852, '1991-07-25'),
(482, 15, 505211716, '1945-10-01'),
(483, 9, 201152550, '1940-12-21'),
(484, 21, 198468774, '1953-06-15'),
(485, 20, 450899127, '1933-07-24'),
(486, 1, 772715087, '1965-02-18'),
(487, 23, 885059859, '1976-08-05'),
(488, 15, 915971399, '1997-08-28'),
(489, 2, 308767673, '1990-06-12'),
(490, 0, 588480937, '1989-10-13'),
(491, 16, 162599783, '1979-06-08'),
(492, 8, 706210235, '2004-01-15'),
(493, 20, 787360061, '2003-07-15'),
(494, 5, 575563525, '1989-01-20'),
(495, 23, 496016797, '2005-09-08'),
(496, 12, 411560093, '1931-04-06'),
(497, 1, 448603771, '1933-12-18'),
(498, 2, 188367781, '1971-08-06'),
(499, 13, 984739351, '1947-11-10'),
(500, 19, 586424735, '1954-04-06'),
(501, 14, 390383787, '1973-05-11');

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

--
-- Stand-in structure for view `emplview`
-- (See below for the actual view)
--
CREATE TABLE `emplview` (
`empId` int(11)
,`personalId` int(11)
,`DOB` date
,`fid` int(11)
,`cid` int(11)
,`Points` int(11)
,`Name` varchar(20)
,`Phone` varchar(10)
,`Email` varchar(32)
,`oid` int(11)
,`PaymentMethod` varchar(20)
,`TimeStamp` date
,`OrderPrice` varchar(10)
,`sName` varchar(20)
,`Size` char(1)
,`toasted` tinyint(1)
,`SandwichPrice` double
,`S_VEG` tinyint(1)
,`calories` int(11)
,`iid` varchar(16)
,`iName` char(20)
,`I_VEG` tinyint(1)
,`bb_date` date
,`FranchiseAddress` varchar(50)
,`FranchisePhone` varchar(10)
,`did` int(11)
,`DistributorName` varchar(20)
,`DistributorAddress` varchar(50)
);

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

--
-- Table structure for table `Farm`
--

CREATE TABLE `Farm` (
  `prodId` int(11) NOT NULL,
  `ProduceType` varchar(20) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Farm`
--

INSERT INTO `Farm` (`prodId`, `ProduceType`) VALUES
(39, 'Lettuce'),
(111, 'Onions'),
(166, 'Pickles'),
(177, 'Lettuce'),
(278, 'Tomatoes'),
(326, 'Cucumbers'),
(358, 'Capsicums'),
(376, 'Olives'),
(391, 'Lettuce'),
(443, 'Olives'),
(537, 'Lettuce'),
(714, 'Tomatoes'),
(736, 'Tomatoes'),
(834, 'Sprouts'),
(859, 'Tomatoes'),
(899, 'Sprouts');

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

--
-- Table structure for table `Franchise`
--

CREATE TABLE `Franchise` (
  `fid` int(11) NOT NULL,
  `did` int(11) DEFAULT NULL,
  `Address` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `Phone` varchar(10) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Franchise`
--

INSERT INTO `Franchise` (`fid`, `did`, `Address`, `Phone`) VALUES
(0, 1, '1775 Washington St', '4503573776'),
(1, 2, '626 Olive Street Sw', '4010739114'),
(2, 28, '425 Route 31', '9093004559'),
(3, 53, '24833 Johnt Reidprkw', '1558585665'),
(4, 59, '103 North Caroline St', '1705621786'),
(5, 73, '164 Danbury Rd', '7480613638'),
(6, 83, '1549 Rt 9', '6216852823'),
(7, 118, '3186 Hwy 171 North', '7860967435'),
(8, 121, '1600 Montclair Rd', '9475451489'),
(9, 158, '103 North Caroline St', '7047141915'),
(10, 164, '4310 Montgomery Hwy', '2591629350'),
(11, 181, '255 W Main St', '6815892348'),
(12, 216, '600 Boll Weevil Circle', '8256564967'),
(13, 217, '555 East Main St', '9237127633'),
(14, 240, '1706 Military Street South', '4292033705'),
(15, 248, '374 William S Canning Blvd', '7805480445'),
(16, 249, '352 Palmer Road', '9060770111'),
(17, 266, '1717 South College Street', '5223703093'),
(18, 320, '5399 W Genesse St', '5816833090'),
(19, 342, '27520 Hwy 98', '6027858728'),
(20, 361, '690 Hwy 78', '6229125681'),
(21, 443, '1903 Cobbs Ford Rd', '5427141440'),
(22, 462, '5560 Mcclellan Blvd', '7496476078'),
(23, 481, '5100 Hwy 31', '5569861702'),
(24, 500, '2900 S Mem PkwyDrake Ave', '1760482732');

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

--
-- Table structure for table `Ingredient`
--

CREATE TABLE `Ingredient` (
  `iid` varchar(16) NOT NULL,
  `iName` char(20) NOT NULL,
  `vegetarian` tinyint(1) DEFAULT NULL,
  `bb_date` date DEFAULT NULL,
  `sid` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Ingredient`
--

INSERT INTO `Ingredient` (`iid`, `iName`, `vegetarian`, `bb_date`, `sid`) VALUES
('B1', 'Beef', 0, '2016-03-12', 63),
('B13', 'Beef', 0, '2018-10-01', 8),
('B17', 'Beef', 0, '2018-01-16', 18),
('B22', 'Beef', 0, '2019-09-26', 26),
('B27', 'Beef', 0, '2017-08-28', 61),
('B31', 'Beef', 0, '2018-05-03', 53),
('B35', 'Beef', 0, '2020-09-21', 52),
('B45', 'Beef', 0, '2016-12-22', 4),
('B5', 'Beef', 0, '2016-02-19', 4),
('B55', 'Beef', 0, '2016-08-19', 28),
('B57', 'Beef', 0, '2017-12-05', 31),
('B58', 'Beef', 0, '2018-04-06', 53),
('B59', 'Beef', 0, '2020-12-24', 54),
('B60', 'Beef', 0, '2019-02-01', 40),
('B61', 'Beef', 0, '2020-12-22', 32),
('B63', 'Beef', 0, '2018-08-02', 45),
('B64', 'Beef', 0, '2018-03-11', 47),
('B65', 'Beef', 0, '2016-03-17', 44),
('B66', 'Beef', 0, '2020-04-24', 52),
('B7', 'Beef', 0, '2018-10-02', 67),
('B70', 'Beef', 0, '2019-02-23', 55),
('B73', 'Beef', 0, '2020-03-21', 62),
('B74', 'Beef', 0, '2019-01-18', 52),
('B76', 'Beef', 0, '2017-11-10', 29),
('B77', 'Beef', 0, '2018-12-15', 56),
('B80', 'Beef', 0, '2018-07-10', 0),
('B85', 'Beef', 0, '2018-12-18', 13),
('B86', 'Beef', 0, '2019-04-25', 2),
('B9', 'Beef', 0, '2018-02-20', 58),
('B90', 'Beef', 0, '2019-12-01', 31),
('B92', 'Beef', 0, '2019-03-12', 8),
('B93', 'Beef', 0, '2017-01-06', 14),
('BBQ1', 'BBQSauce', 1, '2019-01-12', 21),
('BBQ12', 'BBQSauce', 1, '2019-10-02', 36),
('BBQ13', 'BBQSauce', 1, '2018-11-21', 56),
('BBQ18', 'BBQSauce', 1, '2016-08-10', 60),
('BBQ2', 'BBQSauce', 1, '2017-08-26', 49),
('BBQ21', 'BBQSauce', 1, '2016-11-08', 66),
('BBQ23', 'BBQSauce', 1, '2020-06-25', 46),
('BBQ24', 'BBQSauce', 1, '2017-08-21', 56),
('BBQ28', 'BBQSauce', 1, '2018-03-24', 18),
('BBQ37', 'BBQSauce', 1, '2020-06-01', 51),
('BBQ41', 'BBQSauce', 1, '2016-09-19', 43),
('BBQ42', 'BBQSauce', 1, '2018-03-08', 4),
('BBQ43', 'BBQSauce', 1, '2018-06-02', 45),
('BBQ50', 'BBQSauce', 1, '2019-09-03', 23),
('BBQ57', 'BBQSauce', 1, '2018-10-24', 37),
('BBQ59', 'BBQSauce', 1, '2018-08-12', 48),
('BBQ61', 'BBQSauce', 1, '2016-02-20', 46),
('BBQ64', 'BBQSauce', 1, '2020-03-05', 51),
('BBQ67', 'BBQSauce', 1, '2016-11-24', 21),
('BBQ70', 'BBQSauce', 1, '2016-05-23', 63),
('BBQ71', 'BBQSauce', 1, '2016-08-19', 32),
('BBQ72', 'BBQSauce', 1, '2017-08-28', 57),
('BBQ73', 'BBQSauce', 1, '2019-12-27', 0),
('BBQ74', 'BBQSauce', 1, '2017-01-19', 46),
('BBQ75', 'BBQSauce', 1, '2017-08-23', 12),
('BBQ78', 'BBQSauce', 1, '2019-07-19', 32),
('BBQ83', 'BBQSauce', 1, '2017-01-21', 42),
('BBQ84', 'BBQSauce', 1, '2018-07-01', 41),
('BBQ9', 'BBQSauce', 1, '2019-03-15', 9),
('BBQ91', 'BBQSauce', 1, '2016-02-06', 32),
('BBQ98', 'BBQSauce', 1, '2016-05-04', 11),
('BBQ99', 'BBQSauce', 1, '2019-06-04', 63),
('C1', 'Chicken', 0, '2018-03-16', 6),
('C11', 'Chicken', 0, '2018-11-13', NULL),
('C13', 'Chicken', 0, '2019-01-02', 42),
('C15', 'Chicken', 0, '2018-12-04', 13),
('C17', 'Chicken', 0, '2017-11-24', 17),
('C19', 'Chicken', 0, '2019-08-21', 39),
('C2', 'Chicken', 0, '2019-12-27', 28),
('C25', 'Chicken', 0, '2017-10-14', 59),
('C29', 'Chicken', 0, '2019-02-14', 62),
('C31', 'Chicken', 0, '2018-06-03', 14),
('C32', 'Chicken', 0, '2018-12-07', 60),
('C33', 'Chicken', 0, '2020-07-01', 41),
('C40', 'Chicken', 0, '2019-11-12', 8),
('C44', 'Chicken', 0, '2017-01-06', 12),
('C51', 'Chicken', 0, '2016-02-14', 50),
('C53', 'Chicken', 0, '2020-08-03', 35),
('C55', 'Chicken', 0, '2017-11-11', 36),
('C56', 'Chicken', 0, '2016-11-26', 32),
('C59', 'Chicken', 0, '2017-05-04', 50),
('C60', 'Chicken', 0, '2019-05-26', 57),
('C64', 'Chicken', 0, '2017-06-28', 45),
('C67', 'Chicken', 0, '2016-08-21', 19),
('C69', 'Chicken', 0, '2018-11-07', 6),
('C74', 'Chicken', 0, '2017-12-27', 27),
('C8', 'Chicken', 0, '2018-11-18', 4),
('C80', 'Chicken', 0, '2016-03-10', 5),
('C81', 'Chicken', 0, '2018-10-07', 57),
('C82', 'Chicken', 0, '2019-06-15', 11),
('C87', 'Chicken', 0, '2016-08-25', 20),
('C9', 'Chicken', 0, '2018-06-19', 0),
('C91', 'Chicken', 0, '2018-09-22', 64),
('C94', 'Chicken', 0, '2018-03-25', 62),
('C96', 'Chicken', 0, '2019-10-18', 48),
('C98', 'Chicken', 0, '2019-11-26', 20),
('C99', 'Chicken', 0, '2018-02-19', 28),
('CHE19', 'Cheese', 1, '2016-04-16', 44),
('CHE31', 'Cheese', 1, '2017-07-20', 49),
('CHE33', 'Cheese', 1, '2016-08-25', 60),
('CHE38', 'Cheese', 1, '2018-10-26', 15),
('CHE42', 'Cheese', 1, '2016-03-09', 66),
('CHE44', 'Cheese', 1, '2018-11-03', 32),
('CHE46', 'Cheese', 1, '2020-11-09', 60),
('CHE69', 'Cheese', 1, '2016-08-06', 15),
('CHE7', 'Cheese', 1, '2018-04-14', 11),
('CHE77', 'Cheese', 1, '2020-04-14', 31),
('CHE82', 'Cheese', 1, '2018-11-02', 10),
('CHE9', 'Cheese', 1, '2017-05-25', 26),
('CHE94', 'Cheese', 1, '2019-07-17', 31),
('CHE96', 'Cheese', 1, '2017-08-01', 25),
('CSB10', 'Cheesy Bread', 1, '2019-09-04', 47),
('CSB12', 'Cheesy Bread', 1, '2016-10-07', 16),
('CSB13', 'Cheesy Bread', 1, '2016-05-08', 7),
('CSB16', 'Cheesy Bread', 1, '2016-07-12', 31),
('CSB18', 'Cheesy Bread', 1, '2020-11-04', 68),
('CSB24', 'Cheesy Bread', 1, '2020-07-25', 69),
('CSB27', 'Cheesy Bread', 1, '2017-07-11', 9),
('CSB29', 'Cheesy Bread', 1, '2018-02-14', 28),
('CSB3', 'Cheesy Bread', 1, '2019-02-21', 4),
('CSB30', 'Cheesy Bread', 1, '2016-09-07', 22),
('CSB31', 'Cheesy Bread', 1, '2018-04-26', 10),
('CSB32', 'Cheesy Bread', 1, '2018-09-04', 34),
('CSB36', 'Cheesy Bread', 1, '2019-01-05', 14),
('CSB38', 'Cheesy Bread', 1, '2019-08-01', 52),
('CSB46', 'Cheesy Bread', 1, '2020-06-25', 53),
('CSB5', 'Cheesy Bread', 1, '2017-06-17', 57),
('CSB51', 'Cheesy Bread', 1, '2019-12-24', 68),
('CSB52', 'Cheesy Bread', 1, '2018-06-03', 19),
('CSB54', 'Cheesy Bread', 1, '2017-04-24', 39),
('CSB58', 'Cheesy Bread', 1, '2018-02-17', 23),
('CSB60', 'Cheesy Bread', 1, '2017-01-14', 38),
('CSB63', 'Cheesy Bread', 1, '2016-06-28', 24),
('CSB64', 'Cheesy Bread', 1, '2020-11-18', 36),
('CSB65', 'Cheesy Bread', 1, '2017-10-18', 48),
('CSB7', 'Cheesy Bread', 1, '2019-04-11', 44),
('CSB71', 'Cheesy Bread', 1, '2020-04-21', 15),
('CSB73', 'Cheesy Bread', 1, '2017-01-21', 60),
('CSB75', 'Cheesy Bread', 1, '2018-01-28', 68),
('CSB76', 'Cheesy Bread', 1, '2017-10-26', 47),
('CSB79', 'Cheesy Bread', 1, '2019-05-22', 35),
('CSB80', 'Cheesy Bread', 1, '2019-06-20', 47),
('CSB81', 'Cheesy Bread', 1, '2020-09-15', 67),
('CSB89', 'Cheesy Bread', 1, '2018-07-01', 39),
('CSB90', 'Cheesy Bread', 1, '2016-06-02', 37),
('CUC1', 'Cucumbers', 1, '2016-10-23', 15),
('CUC10', 'Cucumbers', 1, '2019-12-16', 58),
('CUC11', 'Cucumbers', 1, '2019-02-26', 65),
('CUC13', 'Cucumbers', 1, '2018-07-21', 39),
('CUC14', 'Cucumbers', 1, '2018-04-14', 46),
('CUC18', 'Cucumbers', 1, '2018-07-21', 64),
('CUC2', 'Cucumbers', 1, '2018-03-11', 34),
('CUC22', 'Cucumbers', 1, '2019-08-06', 65),
('CUC24', 'Cucumbers', 1, '2019-08-13', 39),
('CUC29', 'Cucumbers', 1, '2020-09-19', 63),
('CUC31', 'Cucumbers', 1, '2018-09-17', 10),
('CUC36', 'Cucumbers', 1, '2018-04-02', 65),
('CUC39', 'Cucumbers', 1, '2020-08-02', 60),
('CUC43', 'Cucumbers', 1, '2019-09-23', 67),
('CUC44', 'Cucumbers', 1, '2019-09-05', 11),
('CUC49', 'Cucumbers', 1, '2017-02-08', 50),
('CUC52', 'Cucumbers', 1, '2016-07-08', 60),
('CUC56', 'Cucumbers', 1, '2019-10-11', 61),
('CUC57', 'Cucumbers', 1, '2018-05-06', 50),
('CUC58', 'Cucumbers', 1, '2018-10-23', 65),
('CUC6', 'Cucumbers', 1, '2019-08-02', 5),
('CUC65', 'Cucumbers', 1, '2018-07-08', 15),
('CUC67', 'Cucumbers', 1, '2016-10-13', 53),
('CUC7', 'Cucumbers', 1, '2016-08-19', 18),
('CUC73', 'Cucumbers', 1, '2017-09-08', 64),
('CUC74', 'Cucumbers', 1, '2019-10-07', 22),
('CUC75', 'Cucumbers', 1, '2017-10-11', 62),
('CUC77', 'Cucumbers', 1, '2016-12-03', 61),
('CUC8', 'Cucumbers', 1, '2019-04-08', 8),
('CUC80', 'Cucumbers', 1, '2020-04-11', 18),
('CUC85', 'Cucumbers', 1, '2017-03-13', 30),
('CUC9', 'Cucumbers', 1, '2016-03-23', 32),
('F11', 'Fish', 0, '2016-11-20', 24),
('F12', 'Fish', 0, '2020-07-27', 69),
('F14', 'Fish', 0, '2019-09-03', 26),
('F15', 'Fish', 0, '2018-01-13', 21),
('F19', 'Fish', 0, '2019-10-03', 49),
('F2', 'Fish', 0, '2018-01-17', 46),
('F22', 'Fish', 0, '2018-08-04', 56),
('F23', 'Fish', 0, '2020-05-25', 12),
('F24', 'Fish', 0, '2019-03-12', 40),
('F3', 'Fish', 0, '2019-08-02', 2),
('F33', 'Fish', 0, '2018-08-16', 6),
('F34', 'Fish', 0, '2018-10-10', 46),
('F36', 'Fish', 0, '2018-10-08', 21),
('F37', 'Fish', 0, '2020-12-03', 10),
('F4', 'Fish', 0, '2018-05-08', 40),
('F41', 'Fish', 0, '2018-01-26', 17),
('F42', 'Fish', 0, '2018-02-22', 40),
('F43', 'Fish', 0, '2018-12-11', 3),
('F44', 'Fish', 0, '2019-02-20', 60),
('F45', 'Fish', 0, '2019-03-11', 16),
('F47', 'Fish', 0, '2019-01-16', 40),
('F49', 'Fish', 0, '2019-04-17', 42),
('F5', 'Fish', 0, '2019-08-12', 58),
('F50', 'Fish', 0, '2018-06-05', 47),
('F52', 'Fish', 0, '2018-09-18', 31),
('F53', 'Fish', 0, '2019-11-07', 51),
('F54', 'Fish', 0, '2016-06-13', 45),
('F61', 'Fish', 0, '2016-04-12', 39),
('F63', 'Fish', 0, '2019-05-07', 33),
('F64', 'Fish', 0, '2016-06-10', 31),
('F65', 'Fish', 0, '2017-01-12', 17),
('F66', 'Fish', 0, '2017-03-17', 34),
('F7', 'Fish', 0, '2016-09-25', 29),
('F70', 'Fish', 0, '2018-09-09', 62),
('F73', 'Fish', 0, '2017-07-22', 45),
('F76', 'Fish', 0, '2016-03-26', 30),
('F79', 'Fish', 0, '2020-05-27', 2),
('F81', 'Fish', 0, '2018-04-17', 46),
('F83', 'Fish', 0, '2018-12-16', 5),
('F84', 'Fish', 0, '2018-07-11', 55),
('F85', 'Fish', 0, '2017-07-12', 33),
('F88', 'Fish', 0, '2016-03-12', 25),
('F91', 'Fish', 0, '2019-12-18', 17),
('FLB11', 'Flatbread', 1, '2019-04-27', 24),
('FLB18', 'Flatbread', 1, '2016-04-27', 24),
('FLB20', 'Flatbread', 1, '2020-09-27', 23),
('FLB21', 'Flatbread', 1, '2018-03-17', 48),
('FLB22', 'Flatbread', 1, '2019-09-14', 69),
('FLB27', 'Flatbread', 1, '2016-05-08', 50),
('FLB28', 'Flatbread', 1, '2016-03-17', 51),
('FLB30', 'Flatbread', 1, '2016-04-09', 4),
('FLB32', 'Flatbread', 1, '2019-07-08', 62),
('FLB33', 'Flatbread', 1, '2017-11-05', 67),
('FLB42', 'Flatbread', 1, '2017-10-09', 15),
('FLB45', 'Flatbread', 1, '2020-05-14', 52),
('FLB47', 'Flatbread', 1, '2018-03-16', 62),
('FLB5', 'Flatbread', 1, '2018-11-26', 65),
('FLB53', 'Flatbread', 1, '2016-01-14', 39),
('FLB54', 'Flatbread', 1, '2020-05-23', 51),
('FLB57', 'Flatbread', 1, '2019-08-24', 20),
('FLB61', 'Flatbread', 1, '2020-03-01', 44),
('FLB62', 'Flatbread', 1, '2017-09-10', 64),
('FLB66', 'Flatbread', 1, '2018-05-20', 11),
('FLB72', 'Flatbread', 1, '2020-04-03', 10),
('FLB76', 'Flatbread', 1, '2018-10-12', 21),
('FLB83', 'Flatbread', 1, '2018-10-17', 13),
('FLB84', 'Flatbread', 1, '2018-04-28', 51),
('FLB85', 'Flatbread', 1, '2018-06-04', 48),
('FLB86', 'Flatbread', 1, '2020-09-02', 37),
('FLB87', 'Flatbread', 1, '2019-03-11', 1),
('FLB88', 'Flatbread', 1, '2018-08-12', 16),
('FLB89', 'Flatbread', 1, '2017-12-16', 45),
('FLB9', 'Flatbread', 1, '2016-02-21', 2),
('FLB90', 'Flatbread', 1, '2018-04-09', 49),
('FLB93', 'Flatbread', 1, '2016-12-12', 13),
('FLB96', 'Flatbread', 1, '2017-09-27', 23),
('ITB1', 'Italian', 1, '2018-12-03', 22),
('ITB10', 'Italian', 1, '2018-04-22', 49),
('ITB11', 'Italian', 1, '2018-01-13', 19),
('ITB12', 'Italian', 1, '2017-08-09', 36),
('ITB19', 'Italian', 1, '2020-09-01', 12),
('ITB2', 'Italian', 1, '2016-03-21', 4),
('ITB20', 'Italian', 1, '2018-01-08', 64),
('ITB21', 'Italian', 1, '2020-12-23', 61),
('ITB28', 'Italian', 1, '2018-11-04', 29),
('ITB3', 'Italian', 1, '2020-07-27', 1),
('ITB30', 'Italian', 1, '2020-10-22', 68),
('ITB34', 'Italian', 1, '2020-05-25', 66),
('ITB35', 'Italian', 1, '2019-03-06', 31),
('ITB38', 'Italian', 1, '2019-04-09', 44),
('ITB43', 'Italian', 1, '2016-08-05', 32),
('ITB45', 'Italian', 1, '2019-03-12', 27),
('ITB5', 'Italian', 1, '2020-10-11', 64),
('ITB62', 'Italian', 1, '2019-10-11', 50),
('ITB7', 'Italian', 1, '2018-04-17', 15),
('ITB71', 'Italian', 1, '2020-10-10', 40),
('ITB74', 'Italian', 1, '2020-06-12', 41),
('ITB79', 'Italian', 1, '2017-11-03', 28),
('ITB80', 'Italian', 1, '2016-04-03', 18),
('ITB82', 'Italian', 1, '2019-01-17', 41),
('ITB83', 'Italian', 1, '2018-06-16', 55),
('ITB87', 'Italian', 1, '2018-12-11', 1),
('ITB88', 'Italian', 1, '2019-01-23', 20),
('ITB9', 'Italian', 1, '2018-06-11', 66),
('ITB90', 'Italian', 1, '2018-02-21', 65),
('ITB93', 'Italian', 1, '2019-11-07', 57),
('ITB94', 'Italian', 1, '2019-09-21', 62),
('ITB95', 'Italian', 1, '2019-11-17', 26),
('ITB98', 'Italian', 1, '2016-04-04', 52),
('ITB99', 'Italian', 1, '2020-04-19', 16),
('KET1', 'Ketchup', 1, '2018-09-03', 41),
('KET10', 'Ketchup', 1, '2018-04-19', 66),
('KET15', 'Ketchup', 1, '2018-02-19', 50),
('KET20', 'Ketchup', 1, '2018-06-04', 10),
('KET21', 'Ketchup', 1, '2018-11-14', 37),
('KET22', 'Ketchup', 1, '2020-08-16', 55),
('KET25', 'Ketchup', 1, '2020-10-14', 65),
('KET26', 'Ketchup', 1, '2018-07-03', 42),
('KET27', 'Ketchup', 1, '2019-12-13', 48),
('KET28', 'Ketchup', 1, '2020-07-11', 12),
('KET31', 'Ketchup', 1, '2019-08-28', 32),
('KET33', 'Ketchup', 1, '2019-07-19', 8),
('KET37', 'Ketchup', 1, '2018-08-22', 68),
('KET38', 'Ketchup', 1, '2016-02-04', 34),
('KET4', 'Ketchup', 1, '2018-09-17', 7),
('KET40', 'Ketchup', 1, '2016-05-03', 59),
('KET41', 'Ketchup', 1, '2017-04-09', 15),
('KET46', 'Ketchup', 1, '2016-11-06', 19),
('KET47', 'Ketchup', 1, '2018-03-21', 44),
('KET51', 'Ketchup', 1, '2020-08-27', 44),
('KET57', 'Ketchup', 1, '2019-09-05', 20),
('KET6', 'Ketchup', 1, '2020-11-13', 6),
('KET61', 'Ketchup', 1, '2019-02-13', 8),
('KET62', 'Ketchup', 1, '2018-06-01', 21),
('KET65', 'Ketchup', 1, '2017-02-13', 47),
('KET70', 'Ketchup', 1, '2018-04-11', 45),
('KET78', 'Ketchup', 1, '2017-06-11', 12),
('KET80', 'Ketchup', 1, '2019-05-10', 16),
('KET85', 'Ketchup', 1, '2018-02-19', 53),
('KET88', 'Ketchup', 1, '2017-03-28', 13),
('KET9', 'Ketchup', 1, '2019-10-17', 36),
('KET90', 'Ketchup', 1, '2019-10-19', 60),
('KET92', 'Ketchup', 1, '2019-09-15', 51),
('KET93', 'Ketchup', 1, '2019-06-13', 19),
('KET96', 'Ketchup', 1, '2019-11-13', 52),
('KET99', 'Ketchup', 1, '2016-07-12', 61),
('L1', 'Lamb', 0, '2018-01-28', 48),
('L11', 'Lamb', 0, '2020-10-25', 47),
('L13', 'Lamb', 0, '2019-07-25', 41),
('L15', 'Lamb', 0, '2019-07-16', 57),
('L19', 'Lamb', 0, '2020-11-05', 38),
('L21', 'Lamb', 0, '2018-08-28', 29),
('L23', 'Lamb', 0, '2020-08-17', 34),
('L28', 'Lamb', 0, '2016-04-08', 31),
('L29', 'Lamb', 0, '2018-10-05', 9),
('L30', 'Lamb', 0, '2019-07-13', 6),
('L33', 'Lamb', 0, '2016-07-25', 22),
('L34', 'Lamb', 0, '2020-09-10', 12),
('L40', 'Lamb', 0, '2019-01-27', 20),
('L42', 'Lamb', 0, '2020-04-22', 18),
('L43', 'Lamb', 0, '2018-06-07', 23),
('L48', 'Lamb', 0, '2018-10-12', 51),
('L51', 'Lamb', 0, '2017-01-18', 5),
('L52', 'Lamb', 0, '2016-07-16', 52),
('L57', 'Lamb', 0, '2017-03-03', 31),
('L60', 'Lamb', 0, '2020-11-20', 55),
('L65', 'Lamb', 0, '2018-06-17', 31),
('L7', 'Lamb', 0, '2019-09-14', 21),
('L70', 'Lamb', 0, '2019-07-24', 44),
('L71', 'Lamb', 0, '2016-11-07', 20),
('L74', 'Lamb', 0, '2020-09-05', 11),
('L75', 'Lamb', 0, '2018-09-14', 35),
('L77', 'Lamb', 0, '2017-10-27', 54),
('L80', 'Lamb', 0, '2017-07-12', 58),
('L84', 'Lamb', 0, '2018-08-12', 20),
('L86', 'Lamb', 0, '2018-02-26', 44),
('L96', 'Lamb', 0, '2018-07-06', 7),
('L97', 'Lamb', 0, '2018-12-16', 57),
('L98', 'Lamb', 0, '2019-02-06', 61),
('L99', 'Lamb', 0, '2020-01-09', 16),
('MAY12', 'Mayonnaise', 1, '2018-10-10', 64),
('MAY15', 'Mayonnaise', 1, '2018-10-12', 69),
('MAY17', 'Mayonnaise', 1, '2019-09-23', 23),
('MAY18', 'Mayonnaise', 1, '2019-09-14', 51),
('MAY2', 'Mayonnaise', 1, '2019-03-20', 50),
('MAY20', 'Mayonnaise', 1, '2017-06-16', 1),
('MAY22', 'Mayonnaise', 1, '2018-05-11', 67),
('MAY26', 'Mayonnaise', 1, '2018-07-07', 29),
('MAY27', 'Mayonnaise', 1, '2019-12-19', 40),
('MAY28', 'Mayonnaise', 1, '2019-07-27', 36),
('MAY29', 'Mayonnaise', 1, '2017-08-03', 5),
('MAY3', 'Mayonnaise', 1, '2018-07-09', 22),
('MAY32', 'Mayonnaise', 1, '2018-03-11', 8),
('MAY33', 'Mayonnaise', 1, '2018-12-25', 21),
('MAY36', 'Mayonnaise', 1, '2018-12-14', 18),
('MAY37', 'Mayonnaise', 1, '2016-01-24', 28),
('MAY40', 'Mayonnaise', 1, '2018-07-28', 30),
('MAY42', 'Mayonnaise', 1, '2020-10-04', 28),
('MAY47', 'Mayonnaise', 1, '2019-09-14', 46),
('MAY50', 'Mayonnaise', 1, '2019-07-11', 28),
('MAY51', 'Mayonnaise', 1, '2018-08-17', 34),
('MAY53', 'Mayonnaise', 1, '2017-02-09', 4),
('MAY54', 'Mayonnaise', 1, '2019-12-02', 5),
('MAY55', 'Mayonnaise', 1, '2019-01-25', 44),
('MAY56', 'Mayonnaise', 1, '2016-11-02', 10),
('MAY58', 'Mayonnaise', 1, '2020-06-12', 11),
('MAY66', 'Mayonnaise', 1, '2016-05-01', 26),
('MAY68', 'Mayonnaise', 1, '2018-07-19', 21),
('MAY69', 'Mayonnaise', 1, '2020-01-21', 3),
('MAY7', 'Mayonnaise', 1, '2019-05-22', 51),
('MAY74', 'Mayonnaise', 1, '2019-12-25', 67),
('MAY78', 'Mayonnaise', 1, '2018-11-27', 8),
('MAY79', 'Mayonnaise', 1, '2020-04-05', 47),
('MAY83', 'Mayonnaise', 1, '2018-09-11', 35),
('MAY84', 'Mayonnaise', 1, '2019-08-23', 60),
('MAY87', 'Mayonnaise', 1, '2017-07-05', 15),
('MAY89', 'Mayonnaise', 1, '2018-08-13', 3),
('MAY90', 'Mayonnaise', 1, '2017-02-28', 27),
('MAY92', 'Mayonnaise', 1, '2017-02-03', 4),
('MAY94', 'Mayonnaise', 1, '2018-07-02', 56),
('MUS1', 'Mustard', 1, '2017-10-18', 9),
('MUS10', 'Mustard', 1, '2018-10-14', 52),
('MUS13', 'Mustard', 1, '2017-10-04', 55),
('MUS14', 'Mustard', 1, '2018-03-04', 43),
('MUS17', 'Mustard', 1, '2017-03-27', 31),
('MUS18', 'Mustard', 1, '2018-01-14', 10),
('MUS21', 'Mustard', 1, '2019-05-07', 34),
('MUS23', 'Mustard', 1, '2018-03-21', 0),
('MUS25', 'Mustard', 1, '2017-08-01', 12),
('MUS27', 'Mustard', 1, '2020-03-15', 16),
('MUS3', 'Mustard', 1, '2019-02-08', 29),
('MUS31', 'Mustard', 1, '2018-03-10', 37),
('MUS32', 'Mustard', 1, '2020-04-04', 16),
('MUS33', 'Mustard', 1, '2017-02-20', 58),
('MUS34', 'Mustard', 1, '2019-04-26', 57),
('MUS35', 'Mustard', 1, '2019-05-10', 38),
('MUS37', 'Mustard', 1, '2019-02-20', 50),
('MUS39', 'Mustard', 1, '2019-12-02', 56),
('MUS4', 'Mustard', 1, '2017-02-19', 13),
('MUS40', 'Mustard', 1, '2020-08-18', 37),
('MUS44', 'Mustard', 1, '2019-06-23', 56),
('MUS46', 'Mustard', 1, '2019-12-28', 5),
('MUS5', 'Mustard', 1, '2018-12-17', 69),
('MUS51', 'Mustard', 1, '2018-08-01', 0),
('MUS52', 'Mustard', 1, '2016-04-06', 15),
('MUS6', 'Mustard', 1, '2018-08-28', 42),
('MUS60', 'Mustard', 1, '2019-02-23', 3),
('MUS61', 'Mustard', 1, '2016-06-06', 15),
('MUS62', 'Mustard', 1, '2019-08-24', 16),
('MUS66', 'Mustard', 1, '2018-09-20', 44),
('MUS67', 'Mustard', 1, '2016-10-18', 25),
('MUS70', 'Mustard', 1, '2019-01-07', 9),
('MUS77', 'Mustard', 1, '2019-11-08', 1),
('MUS88', 'Mustard', 1, '2017-08-22', 67),
('MUS9', 'Mustard', 1, '2020-11-16', 48),
('MUS90', 'Mustard', 1, '2018-07-16', 18),
('MUS97', 'Mustard', 1, '2018-04-13', 11),
('ONS10', 'Onions', 1, '2018-01-04', 0),
('ONS16', 'Onions', 1, '2018-06-15', 51),
('ONS19', 'Onions', 1, '2018-10-25', 23),
('ONS20', 'Onions', 1, '2019-07-06', 29),
('ONS22', 'Onions', 1, '2017-06-18', 28),
('ONS26', 'Onions', 1, '2019-09-05', 36),
('ONS29', 'Onions', 1, '2019-04-10', 43),
('ONS31', 'Onions', 1, '2020-11-07', 55),
('ONS34', 'Onions', 1, '2017-07-17', 14),
('ONS39', 'Onions', 1, '2017-10-04', 23),
('ONS43', 'Onions', 1, '2018-09-03', 22),
('ONS44', 'Onions', 1, '2016-05-03', 46),
('ONS49', 'Onions', 1, '2017-07-06', 69),
('ONS5', 'Onions', 1, '2017-06-20', 4),
('ONS50', 'Onions', 1, '2016-10-14', 66),
('ONS52', 'Onions', 1, '2020-08-24', 4),
('ONS56', 'Onions', 1, '2018-12-08', 28),
('ONS60', 'Onions', 1, '2016-02-17', 48),
('ONS62', 'Onions', 1, '2019-06-10', 63),
('ONS63', 'Onions', 1, '2018-12-23', 34),
('ONS64', 'Onions', 1, '2018-04-07', 58),
('ONS66', 'Onions', 1, '2019-04-19', 12),
('ONS71', 'Onions', 1, '2020-10-02', 66),
('ONS75', 'Onions', 1, '2017-11-11', 52),
('ONS78', 'Onions', 1, '2019-09-02', 49),
('ONS83', 'Onions', 1, '2020-09-19', 40),
('ONS86', 'Onions', 1, '2018-07-03', 58),
('ONS87', 'Onions', 1, '2019-01-03', 20),
('ONS88', 'Onions', 1, '2018-11-04', 59),
('ONS89', 'Onions', 1, '2016-09-12', 15),
('ONS9', 'Onions', 1, '2018-02-05', 29),
('ONS90', 'Onions', 1, '2020-01-01', 46),
('ONS91', 'Onions', 1, '2017-02-01', 43),
('ONS93', 'Onions', 1, '2020-03-21', 10),
('ONS94', 'Onions', 1, '2020-02-08', 3),
('ONS95', 'Onions', 1, '2020-10-06', 12),
('ONS96', 'Onions', 1, '2018-08-25', 8),
('ONS98', 'Onions', 1, '2019-08-22', 54),
('P1', 'Pork', 0, '2017-11-12', 29),
('P13', 'Pork', 0, '2019-11-04', 50),
('P16', 'Pork', 0, '2017-07-18', 69),
('P21', 'Pork', 0, '2017-12-10', 20),
('P22', 'Pork', 0, '2018-03-04', 41),
('P24', 'Pork', 0, '2019-06-05', 52),
('P3', 'Pork', 0, '2016-11-07', 55),
('P30', 'Pork', 0, '2018-01-07', 38),
('P32', 'Pork', 0, '2018-04-18', 62),
('P33', 'Pork', 0, '2019-09-12', 23),
('P35', 'Pork', 0, '2020-11-08', 30),
('P37', 'Pork', 0, '2018-01-18', 32),
('P39', 'Pork', 0, '2019-04-25', 64),
('P41', 'Pork', 0, '2019-02-17', 18),
('P46', 'Pork', 0, '2020-01-25', 21),
('P48', 'Pork', 0, '2020-12-08', 23),
('P53', 'Pork', 0, '2019-09-04', 27),
('P54', 'Pork', 0, '2020-10-03', 17),
('P55', 'Pork', 0, '2020-03-11', 19),
('P70', 'Pork', 0, '2016-01-06', 15),
('P71', 'Pork', 0, '2018-11-18', 38),
('P77', 'Pork', 0, '2020-08-25', 9),
('P78', 'Pork', 0, '2019-07-11', 15),
('P79', 'Pork', 0, '2020-01-25', 68),
('P83', 'Pork', 0, '2019-06-12', 15),
('P87', 'Pork', 0, '2020-09-13', 50),
('P91', 'Pork', 0, '2018-07-07', 11),
('P92', 'Pork', 0, '2017-02-11', 37),
('P95', 'Pork', 0, '2018-07-11', 12),
('P96', 'Pork', 0, '2019-06-12', 10),
('P97', 'Pork', 0, '2018-09-08', 36),
('P99', 'Pork', 0, '2020-06-04', 4),
('PEP1', 'Pepper', 1, '2016-08-11', 10),
('PEP12', 'Pepper', 1, '2019-01-17', 58),
('PEP16', 'Pepper', 1, '2020-07-07', 64),
('PEP17', 'Pepper', 1, '2019-07-25', 3),
('PEP19', 'Pepper', 1, '2019-12-05', 58),
('PEP21', 'Pepper', 1, '2017-09-13', 49),
('PEP22', 'Pepper', 1, '2017-03-15', 12),
('PEP3', 'Pepper', 1, '2018-11-01', 38),
('PEP36', 'Pepper', 1, '2017-08-08', 3),
('PEP48', 'Pepper', 1, '2018-09-20', 43),
('PEP49', 'Pepper', 1, '2018-02-16', 33),
('PEP5', 'Pepper', 1, '2019-01-14', 51),
('PEP53', 'Pepper', 1, '2018-03-22', 40),
('PEP63', 'Pepper', 1, '2016-03-08', 7),
('PEP64', 'Pepper', 1, '2016-06-25', 54),
('PEP65', 'Pepper', 1, '2019-05-22', 47),
('PEP66', 'Pepper', 1, '2017-03-14', 37),
('PEP68', 'Pepper', 1, '2019-03-09', 11),
('PEP69', 'Pepper', 1, '2019-12-07', 10),
('PEP75', 'Pepper', 1, '2016-10-16', 56),
('PEP76', 'Pepper', 1, '2019-03-09', 67),
('PEP77', 'Pepper', 1, '2018-03-18', 2),
('PEP78', 'Pepper', 1, '2019-01-07', 62),
('PEP81', 'Pepper', 1, '2019-01-13', 54),
('PEP84', 'Pepper', 1, '2020-06-18', 61),
('PEP85', 'Pepper', 1, '2016-10-13', 20),
('PEP87', 'Pepper', 1, '2018-03-23', 54),
('PEP9', 'Pepper', 1, '2020-03-13', 59),
('PEP95', 'Pepper', 1, '2018-07-25', 49),
('PEP98', 'Pepper', 1, '2018-03-01', 52),
('PEP99', 'Pepper', 1, '2020-03-12', 11),
('PIC10', 'Pickles', 1, '2016-03-07', 46),
('PIC15', 'Pickles', 1, '2019-10-23', 55),
('PIC20', 'Pickles', 1, '2020-04-09', 60),
('PIC21', 'Pickles', 1, '2017-09-24', 28),
('PIC23', 'Pickles', 1, '2020-12-03', 26),
('PIC25', 'Pickles', 1, '2016-05-15', 52),
('PIC28', 'Pickles', 1, '2016-04-04', 32),
('PIC3', 'Pickles', 1, '2019-03-02', 43),
('PIC30', 'Pickles', 1, '2020-11-23', 2),
('PIC35', 'Pickles', 1, '2020-04-13', 5),
('PIC38', 'Pickles', 1, '2019-09-10', 68),
('PIC39', 'Pickles', 1, '2017-09-21', 39),
('PIC42', 'Pickles', 1, '2020-12-15', 38),
('PIC43', 'Pickles', 1, '2016-04-10', 62),
('PIC53', 'Pickles', 1, '2016-08-08', 17),
('PIC55', 'Pickles', 1, '2020-09-14', 47),
('PIC58', 'Pickles', 1, '2018-05-08', 63),
('PIC62', 'Pickles', 1, '2020-07-19', 15),
('PIC67', 'Pickles', 1, '2019-04-16', 41),
('PIC7', 'Pickles', 1, '2018-06-17', 12),
('PIC72', 'Pickles', 1, '2018-11-01', 29),
('PIC77', 'Pickles', 1, '2018-11-19', 28),
('PIC82', 'Pickles', 1, '2018-12-23', 16),
('PIC87', 'Pickles', 1, '2017-12-11', 68),
('PIC94', 'Pickles', 1, '2020-04-02', 4),
('PIC96', 'Pickles', 1, '2019-11-13', 36),
('REL10', 'Relish', 1, '2016-04-17', 16),
('REL17', 'Relish', 1, '2019-01-14', 10),
('REL19', 'Relish', 1, '2019-01-16', 64),
('REL26', 'Relish', 1, '2019-01-27', 55),
('REL27', 'Relish', 1, '2019-08-15', 65),
('REL29', 'Relish', 1, '2016-11-14', 23),
('REL31', 'Relish', 1, '2018-10-02', 69),
('REL32', 'Relish', 1, '2016-01-02', 64),
('REL33', 'Relish', 1, '2020-03-26', 1),
('REL34', 'Relish', 1, '2016-01-20', 68),
('REL35', 'Relish', 1, '2019-01-22', 48),
('REL41', 'Relish', 1, '2019-01-18', 41),
('REL43', 'Relish', 1, '2017-11-26', 57),
('REL46', 'Relish', 1, '2017-02-17', 47),
('REL49', 'Relish', 1, '2019-01-03', 35),
('REL5', 'Relish', 1, '2016-01-02', 34),
('REL52', 'Relish', 1, '2018-04-05', 25),
('REL63', 'Relish', 1, '2018-08-08', 44),
('REL64', 'Relish', 1, '2020-03-15', 64),
('REL66', 'Relish', 1, '2017-06-08', 29),
('REL67', 'Relish', 1, '2017-10-05', 15),
('REL68', 'Relish', 1, '2018-01-21', 49),
('REL69', 'Relish', 1, '2020-09-05', 10),
('REL71', 'Relish', 1, '2019-11-22', 38),
('REL75', 'Relish', 1, '2019-09-17', 29),
('REL80', 'Relish', 1, '2019-01-20', 45),
('REL82', 'Relish', 1, '2019-04-21', 49),
('REL85', 'Relish', 1, '2019-02-08', 6),
('REL90', 'Relish', 1, '2018-10-04', 60),
('REL91', 'Relish', 1, '2016-05-15', 67),
('REL95', 'Relish', 1, '2017-10-23', 64),
('REL96', 'Relish', 1, '2017-10-21', 65),
('REL98', 'Relish', 1, '2016-06-03', 37),
('RYB11', 'Rye', 1, '2018-06-22', 40),
('RYB14', 'Rye', 1, '2019-12-22', 41),
('RYB16', 'Rye', 1, '2018-07-23', 21),
('RYB17', 'Rye', 1, '2017-12-27', 49),
('RYB20', 'Rye', 1, '2018-02-07', 41),
('RYB22', 'Rye', 1, '2019-04-26', 61),
('RYB24', 'Rye', 1, '2018-05-23', 43),
('RYB3', 'Rye', 1, '2017-03-08', 32),
('RYB31', 'Rye', 1, '2018-02-22', 33),
('RYB32', 'Rye', 1, '2019-10-27', 43),
('RYB34', 'Rye', 1, '2018-04-04', 34),
('RYB43', 'Rye', 1, '2017-01-08', 28),
('RYB47', 'Rye', 1, '2017-05-10', 55),
('RYB51', 'Rye', 1, '2020-02-04', 11),
('RYB53', 'Rye', 1, '2018-11-26', 24),
('RYB56', 'Rye', 1, '2019-06-07', 52),
('RYB59', 'Rye', 1, '2020-02-26', 46),
('RYB6', 'Rye', 1, '2019-04-01', 40),
('RYB60', 'Rye', 1, '2019-12-26', 52),
('RYB61', 'Rye', 1, '2018-07-19', 9),
('RYB64', 'Rye', 1, '2019-07-22', 27),
('RYB68', 'Rye', 1, '2019-08-22', 15),
('RYB7', 'Rye', 1, '2016-10-02', 53),
('RYB79', 'Rye', 1, '2018-08-17', 17),
('RYB80', 'Rye', 1, '2019-12-19', 26),
('RYB83', 'Rye', 1, '2019-10-10', 37),
('RYB84', 'Rye', 1, '2019-07-08', 3),
('RYB86', 'Rye', 1, '2017-03-03', 29),
('RYB88', 'Rye', 1, '2019-09-16', 31),
('RYB9', 'Rye', 1, '2019-08-10', 58),
('RYB92', 'Rye', 1, '2020-05-20', 55),
('RYB95', 'Rye', 1, '2016-06-13', 33),
('RYB96', 'Rye', 1, '2017-02-06', 53),
('RYB99', 'Rye', 1, '2020-09-11', 21),
('SAL15', 'Salt', 1, '2018-03-26', 4),
('SAL19', 'Salt', 1, '2018-01-13', 29),
('SAL22', 'Salt', 1, '2019-09-20', 18),
('SAL24', 'Salt', 1, '2018-03-25', 17),
('SAL26', 'Salt', 1, '2020-06-08', 64),
('SAL27', 'Salt', 1, '2017-03-26', 21),
('SAL28', 'Salt', 1, '2018-02-04', 26),
('SAL30', 'Salt', 1, '2020-08-21', 15),
('SAL32', 'Salt', 1, '2018-11-26', 18),
('SAL37', 'Salt', 1, '2018-06-12', 62),
('SAL38', 'Salt', 1, '2018-05-13', 62),
('SAL40', 'Salt', 1, '2019-01-16', 6),
('SAL41', 'Salt', 1, '2018-04-05', 43),
('SAL42', 'Salt', 1, '2019-11-14', 56),
('SAL43', 'Salt', 1, '2020-01-20', 15),
('SAL46', 'Salt', 1, '2018-05-01', 67),
('SAL48', 'Salt', 1, '2019-10-10', 42),
('SAL51', 'Salt', 1, '2020-01-06', 44),
('SAL55', 'Salt', 1, '2016-09-06', 44),
('SAL57', 'Salt', 1, '2020-09-15', 30),
('SAL58', 'Salt', 1, '2020-10-14', 30),
('SAL59', 'Salt', 1, '2018-04-24', 48),
('SAL60', 'Salt', 1, '2016-11-13', 23),
('SAL65', 'Salt', 1, '2020-10-09', 62),
('SAL67', 'Salt', 1, '2016-02-14', 69),
('SAL7', 'Salt', 1, '2019-07-16', 54),
('SAL70', 'Salt', 1, '2018-04-26', 51),
('SAL72', 'Salt', 1, '2019-04-13', 24),
('SAL75', 'Salt', 1, '2016-11-14', 5),
('SAL76', 'Salt', 1, '2019-03-20', 15),
('SAL84', 'Salt', 1, '2016-11-25', 22),
('SAL85', 'Salt', 1, '2019-04-21', 23),
('SAL90', 'Salt', 1, '2018-12-06', 56),
('SAL98', 'Salt', 1, '2017-04-14', 41),
('SDB1', 'Sourdough', 1, '2020-07-20', 56),
('SDB11', 'Sourdough', 1, '2017-11-15', 44),
('SDB16', 'Sourdough', 1, '2019-05-09', 38),
('SDB2', 'Sourdough', 1, '2018-05-17', 69),
('SDB22', 'Sourdough', 1, '2018-06-15', 21),
('SDB25', 'Sourdough', 1, '2018-09-14', 20),
('SDB26', 'Sourdough', 1, '2019-08-03', 12),
('SDB3', 'Sourdough', 1, '2018-02-08', 68),
('SDB32', 'Sourdough', 1, '2018-04-25', 48),
('SDB35', 'Sourdough', 1, '2020-02-20', 2),
('SDB36', 'Sourdough', 1, '2019-04-11', 12),
('SDB37', 'Sourdough', 1, '2017-12-04', 6),
('SDB39', 'Sourdough', 1, '2016-02-02', 57),
('SDB4', 'Sourdough', 1, '2019-12-04', 69),
('SDB40', 'Sourdough', 1, '2016-01-26', 12),
('SDB44', 'Sourdough', 1, '2018-05-19', 15),
('SDB47', 'Sourdough', 1, '2017-09-12', 38),
('SDB49', 'Sourdough', 1, '2020-10-08', 45),
('SDB51', 'Sourdough', 1, '2020-07-20', 13),
('SDB56', 'Sourdough', 1, '2019-09-21', 24),
('SDB60', 'Sourdough', 1, '2019-06-02', 1),
('SDB64', 'Sourdough', 1, '2018-01-25', 14),
('SDB65', 'Sourdough', 1, '2020-12-22', 13),
('SDB66', 'Sourdough', 1, '2020-02-23', 42),
('SDB67', 'Sourdough', 1, '2019-01-08', 11),
('SDB68', 'Sourdough', 1, '2019-12-01', 41),
('SDB69', 'Sourdough', 1, '2020-11-13', 55),
('SDB71', 'Sourdough', 1, '2020-05-03', 55),
('SDB72', 'Sourdough', 1, '2016-08-16', 29),
('SDB75', 'Sourdough', 1, '2020-01-01', 3),
('SDB78', 'Sourdough', 1, '2020-04-15', 63),
('SDB81', 'Sourdough', 1, '2016-04-01', 66),
('SDB84', 'Sourdough', 1, '2019-02-15', 45),
('SDB88', 'Sourdough', 1, '2018-08-21', 46),
('SDB89', 'Sourdough', 1, '2019-08-10', 33),
('SDB9', 'Sourdough', 1, '2019-11-01', 4),
('SDB93', 'Sourdough', 1, '2019-09-03', 21),
('SDB94', 'Sourdough', 1, '2018-10-24', 40),
('SDB99', 'Sourdough', 1, '2017-10-13', 28),
('SPR1', 'Sprouts', 1, '2018-08-10', 2),
('SPR12', 'Sprouts', 1, '2017-08-04', 5),
('SPR14', 'Sprouts', 1, '2019-10-10', 44),
('SPR15', 'Sprouts', 1, '2019-11-20', 46),
('SPR19', 'Sprouts', 1, '2018-12-16', 63),
('SPR22', 'Sprouts', 1, '2017-08-11', 68),
('SPR24', 'Sprouts', 1, '2018-06-23', 47),
('SPR25', 'Sprouts', 1, '2019-08-14', 18),
('SPR27', 'Sprouts', 1, '2018-04-12', 60),
('SPR28', 'Sprouts', 1, '2019-12-01', 47),
('SPR30', 'Sprouts', 1, '2017-11-11', 69),
('SPR31', 'Sprouts', 1, '2016-01-14', 69),
('SPR33', 'Sprouts', 1, '2018-06-27', 43),
('SPR37', 'Sprouts', 1, '2019-06-10', 59),
('SPR39', 'Sprouts', 1, '2020-01-13', 4),
('SPR46', 'Sprouts', 1, '2018-08-11', 0),
('SPR47', 'Sprouts', 1, '2018-01-19', 69),
('SPR48', 'Sprouts', 1, '2016-07-01', 27),
('SPR5', 'Sprouts', 1, '2019-11-08', 56),
('SPR53', 'Sprouts', 1, '2018-03-20', 50),
('SPR58', 'Sprouts', 1, '2019-07-23', 33),
('SPR59', 'Sprouts', 1, '2019-12-24', 28),
('SPR7', 'Sprouts', 1, '2020-03-15', 12),
('SPR70', 'Sprouts', 1, '2018-04-01', 55),
('SPR73', 'Sprouts', 1, '2020-08-06', 58),
('SPR74', 'Sprouts', 1, '2020-01-11', 18),
('SPR76', 'Sprouts', 1, '2020-07-12', 64),
('SPR78', 'Sprouts', 1, '2019-07-06', 23),
('SPR83', 'Sprouts', 1, '2017-06-14', 48),
('SPR86', 'Sprouts', 1, '2016-06-23', 45),
('SPR87', 'Sprouts', 1, '2017-10-12', 23),
('SPR9', 'Sprouts', 1, '2016-02-24', 62),
('SPR95', 'Sprouts', 1, '2019-04-15', 45),
('SPR96', 'Sprouts', 1, '2017-08-06', 45),
('SPR98', 'Sprouts', 1, '2020-04-17', 25),
('SPR99', 'Sprouts', 1, '2020-04-08', 68),
('TOM13', 'Tomatoes', 1, '2017-11-23', 41),
('TOM15', 'Tomatoes', 1, '2019-12-12', 15),
('TOM18', 'Tomatoes', 1, '2017-12-09', 52),
('TOM2', 'Tomatoes', 1, '2020-10-21', 36),
('TOM27', 'Tomatoes', 1, '2017-12-26', 5),
('TOM28', 'Tomatoes', 1, '2017-02-22', 45),
('TOM29', 'Tomatoes', 1, '2017-02-28', 16),
('TOM31', 'Tomatoes', 1, '2019-01-02', 26),
('TOM35', 'Tomatoes', 1, '2020-11-03', 66),
('TOM36', 'Tomatoes', 1, '2018-02-25', 26),
('TOM38', 'Tomatoes', 1, '2020-09-02', 55),
('TOM39', 'Tomatoes', 1, '2017-12-24', 38),
('TOM42', 'Tomatoes', 1, '2020-12-05', 68),
('TOM43', 'Tomatoes', 1, '2018-06-08', 64),
('TOM53', 'Tomatoes', 1, '2018-04-11', 45),
('TOM55', 'Tomatoes', 1, '2020-11-12', 67),
('TOM6', 'Tomatoes', 1, '2017-06-09', 43),
('TOM62', 'Tomatoes', 1, '2018-04-07', 20),
('TOM69', 'Tomatoes', 1, '2019-10-12', 59),
('TOM71', 'Tomatoes', 1, '2018-08-18', 62),
('TOM74', 'Tomatoes', 1, '2019-01-08', 14),
('TOM79', 'Tomatoes', 1, '2019-01-17', 37),
('TOM8', 'Tomatoes', 1, '2017-08-22', 58),
('TOM80', 'Tomatoes', 1, '2017-07-27', 32),
('TOM83', 'Tomatoes', 1, '2020-08-28', 19),
('TOM84', 'Tomatoes', 1, '2020-06-12', 17),
('TOM9', 'Tomatoes', 1, '2017-01-20', 7),
('TOM92', 'Tomatoes', 1, '2016-12-05', 56),
('TOM93', 'Tomatoes', 1, '2019-11-28', 30),
('TOM97', 'Tomatoes', 1, '2017-05-28', 9),
('TOM98', 'Tomatoes', 1, '2016-02-28', 33),
('TOM99', 'Tomatoes', 1, '2017-01-18', 34),
('WB1', 'White', 1, '2017-08-15', 16),
('WB10', 'White', 1, '2018-03-07', 8),
('WB11', 'White', 1, '2019-10-10', 39),
('WB12', 'White', 1, '2019-01-03', 67),
('WB18', 'White', 1, '2018-08-12', 46),
('WB23', 'White', 1, '2017-01-02', 1),
('WB25', 'White', 1, '2019-07-01', 32),
('WB27', 'White', 1, '2020-08-02', 38),
('WB30', 'White', 1, '2019-08-07', 19),
('WB34', 'White', 1, '2018-12-22', 48),
('WB38', 'White', 1, '2019-08-13', 42),
('WB39', 'White', 1, '2016-07-01', 39),
('WB40', 'White', 1, '2018-09-28', 13),
('WB41', 'White', 1, '2018-12-16', 1),
('WB43', 'White', 1, '2016-11-22', 19),
('WB44', 'White', 1, '2019-03-11', 68),
('WB45', 'White', 1, '2017-06-05', 50),
('WB48', 'White', 1, '2018-05-12', 39),
('WB49', 'White', 1, '2017-08-10', 4),
('WB5', 'White', 1, '2019-05-08', 40),
('WB63', 'White', 1, '2019-05-27', 2),
('WB64', 'White', 1, '2020-04-05', 50),
('WB65', 'White', 1, '2019-04-15', 51),
('WB67', 'White', 1, '2018-05-13', 57),
('WB68', 'White', 1, '2019-05-11', 38),
('WB72', 'White', 1, '2016-08-13', 30),
('WB73', 'White', 1, '2017-05-13', 9),
('WB77', 'White', 1, '2019-04-25', 12),
('WB78', 'White', 1, '2018-05-11', 27),
('WB81', 'White', 1, '2017-06-15', 21),
('WB82', 'White', 1, '2017-08-13', 49),
('WB90', 'White', 1, '2018-06-12', 44),
('WWB1', 'WholeWheat', 1, '2018-02-12', 7),
('WWB12', 'WholeWheat', 1, '2018-07-21', 19),
('WWB13', 'WholeWheat', 1, '2017-05-16', 61),
('WWB16', 'WholeWheat', 1, '2018-07-12', 51),
('WWB21', 'WholeWheat', 1, '2020-10-01', 13),
('WWB22', 'WholeWheat', 1, '2019-10-07', 52),
('WWB24', 'WholeWheat', 1, '2017-10-23', 25),
('WWB25', 'WholeWheat', 1, '2018-07-21', 27),
('WWB26', 'WholeWheat', 1, '2019-11-19', 20),
('WWB36', 'WholeWheat', 1, '2018-04-12', 40),
('WWB38', 'WholeWheat', 1, '2016-02-16', 32),
('WWB45', 'WholeWheat', 1, '2020-07-09', 63),
('WWB46', 'WholeWheat', 1, '2016-01-03', 67),
('WWB47', 'WholeWheat', 1, '2016-09-25', 23),
('WWB5', 'WholeWheat', 1, '2019-02-17', 64),
('WWB50', 'WholeWheat', 1, '2017-04-21', 50),
('WWB52', 'WholeWheat', 1, '2017-12-13', 66),
('WWB57', 'WholeWheat', 1, '2019-09-21', 57),
('WWB58', 'WholeWheat', 1, '2020-06-14', 16),
('WWB59', 'WholeWheat', 1, '2020-12-13', 65),
('WWB61', 'WholeWheat', 1, '2019-09-05', 69),
('WWB67', 'WholeWheat', 1, '2017-02-28', 29),
('WWB68', 'WholeWheat', 1, '2020-08-20', 43),
('WWB7', 'WholeWheat', 1, '2019-04-04', 13),
('WWB72', 'WholeWheat', 1, '2019-12-28', 49),
('WWB75', 'WholeWheat', 1, '2017-09-12', 61),
('WWB77', 'WholeWheat', 1, '2019-05-21', 62),
('WWB80', 'WholeWheat', 1, '2016-11-05', 3),
('WWB81', 'WholeWheat', 1, '2016-07-22', 36),
('WWB82', 'WholeWheat', 1, '2018-10-26', 25),
('WWB83', 'WholeWheat', 1, '2017-06-24', 9),
('WWB84', 'WholeWheat', 1, '2019-11-10', 50),
('WWB85', 'WholeWheat', 1, '2018-06-07', 39),
('WWB86', 'WholeWheat', 1, '2018-08-07', 23);

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

--
-- Table structure for table `IngredientProducer`
--

CREATE TABLE `IngredientProducer` (
  `did` int(11) DEFAULT NULL,
  `prodid` int(11) NOT NULL,
  `address` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `phone` varchar(10) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `IngredientProducer`
--

INSERT INTO `IngredientProducer` (`did`, `prodid`, `address`, `phone`) VALUES
(1, 23, '3855 Joyce Street', '2522088151'),
(1, 39, '4310 Montgomery Hwy', NULL),
(443, 40, '311 RT 9W', NULL),
(575, 72, '1095 Industrial Pkwy', '7012156658'),
(703, 94, '11610 Memorial Pkwy South', NULL),
(158, 100, '123 Street St', '4201236969'),
(462, 102, '1625 Pelham South', '5148187052'),
(240, 106, '970 Torringford Street', NULL),
(443, 111, '121 Worcester Rd', '4377583170'),
(593, 166, '3005 Cranberry Hwy Rt 6 28', NULL),
(762, 177, '3191 County rd 10', '1944227980'),
(121, 202, '3133 E Main St', '4516736188'),
(878, 203, '5710 Mcfarland Blvd', NULL),
(53, 267, '5783 So Transit Road', NULL),
(917, 278, '155 Waterford Parkway No', NULL),
(53, 326, '11610 Memorial Pkwy South', '2957741520'),
(217, 358, '2500 Dawes Road', '1897668582'),
(443, 359, '43 Stephenville St', '2206052124'),
(2, 360, '1972 Hwy 431', NULL),
(59, 373, '164 Danbury Rd', '4227768339'),
(825, 376, '66-4 Parkhurst Rd', NULL),
(158, 381, '80 Town Line Rd', NULL),
(995, 391, '180 River Rd', NULL),
(777, 408, '450 Highland Ave', '2128693970'),
(481, 424, '5335 Hwy 280 South', '4839820311'),
(181, 443, '250 Hartford Avenue', NULL),
(59, 472, '550 Providence Hwy', '1487052940'),
(558, 476, '150 Barnum Avenue Cutoff', NULL),
(722, 490, '24833 Johnt Reidprkw', NULL),
(876, 537, '2001 Glenn Bldv Sw', '9489632743'),
(216, 549, '42 Fairhaven Commons Way', NULL),
(536, 577, '872 Route 13', NULL),
(575, 583, '11697 US Hwy 431', '5388642472'),
(158, 600, '999 Lion Street', NULL),
(342, 636, '2900 Pepperrell Pkwy', NULL),
(158, 700, '32437 Orange Ave', '1234567789'),
(718, 704, '340 East Meighan Blvd', NULL),
(266, 714, '250 Hartford Avenue', NULL),
(59, 719, '501 Willow Lane', NULL),
(216, 736, '145 Kelley Blvd', '5136910084'),
(121, 781, '3164 Berlin Turnpike', '2136297662'),
(870, 810, '1600 Montclair Rd', NULL),
(722, 828, '3300 South Oates Street', '8067828549'),
(561, 834, '15445 Highway 24', NULL),
(481, 851, '3222 State Rt 11', '4292033705'),
(1, 859, '150 Barnum Avenue Cutoff', '9312940564'),
(53, 888, '1501 Skyland Blvd E', '9258515865'),
(361, 899, '41301 US Hwy 280', NULL),
(942, 954, '9248 Parkway East', '6850996899'),
(575, 975, '4300 Lakeville Road', '3887819636'),
(121, 981, '101 Sanford Farm Shpg Center', '5929728161'),
(878, 985, '2465 Hempstead Turnpike', '3489255795'),
(878, 996, '1801 Hwy 78 East', NULL);

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

--
-- Table structure for table `Member`
--

CREATE TABLE `Member` (
  `cid` int(11) NOT NULL,
  `Points` int(11) DEFAULT NULL,
  `Name` varchar(20) CHARACTER SET utf8 DEFAULT NULL,
  `Phone` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `Email` varchar(32) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Member`
--

INSERT INTO `Member` (`cid`, `Points`, `Name`, `Phone`, `Email`) VALUES
(10, 4839, 'Sheila-Kathryn Irma', '6436405759', 'SIrma@gmail.com'),
(13, 4755, 'Eleonore Jemie', '5223703093', 'EJemie@gmail.com'),
(16, 3310, 'Amelita Andi', '3572269620', 'AAndi@gmail.com'),
(18, 5712, 'Wynnie Bessie', '4505498863', 'WBessie@gmail.com'),
(37, 5408, 'Martica Belia', '5887455075', 'MBelia@gmail.com'),
(44, 9216, 'Shannah Edita', '1313705239', 'SEdita@gmail.com'),
(52, 6972, 'Dulcinea Cissiee', '2717234450', 'DCissiee@gmail.com'),
(53, 9788, 'Maddi Willetta', '6257374180', 'MWilletta@gmail.com'),
(60, 5248, 'Zahara Zarah', '5163491342', 'ZZarah@gmail.com'),
(63, 6352, 'Cori Rayshell', '2575344731', 'CRayshell@gmail.com'),
(100, 1524, 'Dorella Aurore', '7967994213', 'DAurore@gmail.com'),
(103, 5171, 'Caroline Aime', '7271138402', 'CAime@gmail.com'),
(115, 2137, 'Maxine Debby', '6199483136', 'MDebby@gmail.com'),
(120, 2034, 'Effie Clarissa', '1313705239', 'EClarissa@gmail.com'),
(129, 4418, 'Corinna Collette', '8447599692', 'CCollette@gmail.com'),
(144, 5966, 'Perla Lavina', '3345969525', 'PLavina@gmail.com'),
(148, 1458, 'Elnora Rasla', '5748675599', 'ERasla@gmail.com'),
(153, 4729, 'Milli Kori', '9078851947', 'MKori@gmail.com'),
(155, 708, 'Rhiamon Alice', '3080975243', 'RAlice@gmail.com'),
(162, 6968, 'Demetra Valina', '2602141998', 'DValina@gmail.com'),
(165, 8573, 'Melicent Winnie', '7446881340', 'MWinnie@gmail.com'),
(172, 7494, 'Trudi Sharline', '7446881340', 'TSharline@gmail.com'),
(193, 9201, 'Katrine Katuscha', '3602810265', 'KKatuscha@gmail.com'),
(221, 3501, 'Tobey Jilli', '9948375046', 'TJilli@gmail.com'),
(251, 7017, 'Neala Avie', '1780172929', 'NAvie@gmail.com'),
(254, 7362, 'Alayne Aviva', '2897205476', 'AAviva@gmail.com'),
(257, 8199, 'Karly Dita', '1966307883', 'KDita@gmail.com'),
(259, 2940, 'Jehanna Celestyna', '5657724407', 'JCelestyna@gmail.com'),
(264, 9842, 'Addy Tamqrah', '6938606056', 'ATamqrah@gmail.com'),
(270, 9896, 'Angelica Salaidh', '6850996899', 'ASalaidh@gmail.com'),
(282, 3888, 'Gipsy Cristina', '1630622538', 'GCristina@gmail.com'),
(289, 2805, 'Tate Alejandra', '8688104012', 'TAlejandra@gmail.com'),
(294, 5523, 'Mariette Danette', '4995065767', 'MDanette@gmail.com'),
(296, 7531, 'Gusty Tory', '7756169040', 'GTory@gmail.com'),
(310, 929, 'Calley Ynez', '6012215553', 'CYnez@gmail.com'),
(311, 1735, 'Phyllis Trisha', '6190284782', 'PTrisha@gmail.com'),
(316, 7733, 'Wilona Josie', '7756169040', 'WJosie@gmail.com'),
(329, 8372, 'Anallese Avril', '4002285397', 'AAvril@gmail.com'),
(361, 2853, 'Gillian Vida', '1966307883', 'GVida@gmail.com'),
(366, 3134, 'Betty Heddi', '8493377201', 'BHeddi@gmail.com'),
(374, 941, 'Dory Dolorita', '8079686649', 'DDolorita@gmail.com'),
(384, 7895, 'Marybelle Novelia', '7831248003', 'MNovelia@gmail.com'),
(385, 6558, 'Jannelle Cindi', '7658426796', 'JCindi@gmail.com'),
(393, 4972, 'Cissiee Stephana', '3055489559', 'CStephana@gmail.com'),
(401, 7233, 'Datha Wilona', '7841939899', 'DWilona@gmail.com'),
(411, 8172, 'Audra Jaimie', '9475451489', 'AJaimie@gmail.com'),
(412, 7971, 'Dulcy Claude', '1630622538', 'DClaude@gmail.com'),
(424, 2766, 'Nerita Devi', '6284456634', 'NDevi@gmail.com'),
(443, 403, 'Risa Genni', '9339938708', 'RGenni@gmail.com'),
(448, 776, 'Elyssa Etheline', '6292982878', 'EEtheline@gmail.com'),
(452, 2239, 'Pamelina Marje', '4571761643', 'PMarje@gmail.com'),
(463, 3565, 'Mufinella Dru', '1457034870', 'MDru@gmail.com'),
(471, 5657, 'Barrie Roda', '4231973074', 'BRoda@gmail.com'),
(474, 227, 'Shannah Tina', '7496476078', 'STina@gmail.com'),
(476, 2048, 'Clio Phylys', '4839820311', 'CPhylys@gmail.com'),
(481, 4860, 'Josey Blisse', '2683948660', 'JBlisse@gmail.com'),
(485, 9733, 'Ailee Nomi', '9005425742', 'ANomi@gmail.com'),
(500, 5606, 'Fredericka Carree', '2849594107', 'FCarree@gmail.com'),
(505, 4246, 'Sal Dodi', '9670981814', 'SDodi@gmail.com'),
(510, 1318, 'Melanie Adella', '2730929220', 'MAdella@gmail.com'),
(513, 9267, 'Gae Johannah', '4996951874', 'GJohannah@gmail.com'),
(519, 8149, 'Merridie Lana', '7466476235', 'MLana@gmail.com'),
(533, 781, 'Noelyn Corissa', '9459783982', 'NCorissa@gmail.com'),
(559, 272, 'Florenza Janice', '1975327677', 'FJanice@gmail.com'),
(561, 898, 'Cleopatra Charlean', '5427141440', 'CCharlean@gmail.com'),
(566, 4665, 'Ardath Bibby', '8928412282', 'ABibby@gmail.com'),
(570, 5037, 'Roseanne Shantee', '7167999839', 'RShantee@gmail.com'),
(584, 3309, 'Hallie Marna', '6538460911', 'HMarna@gmail.com'),
(587, 6785, 'Alison Teresita', '1944227980', 'ATeresita@gmail.com'),
(597, 168, 'Sibby Jenny', '5918818236', 'SJenny@gmail.com'),
(598, 5573, 'Verla Mira', '7596010541', 'VMira@gmail.com'),
(600, 1136, 'Ianthe Alanah', '2730929220', 'IAlanah@gmail.com'),
(611, 4105, 'Bonnie Winnah', '9312940564', 'BWinnah@gmail.com'),
(613, 3938, 'Teri Charita', '3967148749', 'TCharita@gmail.com'),
(614, 8451, 'Marcelia Diandra', '1583040665', 'MDiandra@gmail.com'),
(616, 9956, 'Rosalinde Roxine', '3145524550', 'RRoxine@gmail.com'),
(619, 7059, 'Teddy Perle', '9842647674', 'TPerle@gmail.com'),
(633, 7413, 'Britta Katharyn', '1192955413', 'BKatharyn@gmail.com'),
(634, 916, 'Mufi Mei', '1750972620', 'MMei@gmail.com'),
(635, 3033, 'Barbey Lindy', '8549341357', 'BLindy@gmail.com'),
(648, 9153, 'Janaye Eilis', '7717572837', 'JEilis@gmail.com'),
(653, 6908, 'Dorie Gerry', '9842647674', 'DGerry@gmail.com'),
(655, 549, 'Blaire Perrine', '3966108169', 'BPerrine@gmail.com'),
(657, 4264, 'Odetta Xena', '6455167056', 'OXena@gmail.com'),
(670, 7497, 'Rhea Sharla', '6815892348', 'RSharla@gmail.com'),
(672, 7390, 'Marris Moina', '5489444689', 'MMoina@gmail.com'),
(674, 1777, 'Kassie Charlotte', '1332023870', 'KCharlotte@gmail.com'),
(681, 8493, 'Melania Reine', '6229125681', 'MReine@gmail.com'),
(689, 7174, 'Damara Corrie', '7196267516', 'DCorrie@gmail.com'),
(693, 1996, 'Paolina Veronike', '2591629350', 'PVeronike@gmail.com'),
(694, 5350, 'Marga Anett', '3984603804', 'MAnett@gmail.com'),
(695, 6786, 'Kaycee Lyssa', '8580326865', 'KLyssa@gmail.com'),
(708, 4407, 'Jenny Ede', '6521793741', 'JEde@gmail.com'),
(710, 7705, 'Georgia Deonne', '1110306961', 'GDeonne@gmail.com'),
(729, 5516, 'Elna Ted', '8154754448', 'ETed@gmail.com'),
(753, 100, 'Farica Gill', '7022953333', 'FGill@gmail.com'),
(755, 921, 'Rubie Constance', '7353217992', 'RConstance@gmail.com'),
(757, 1452, 'Cthrine Ula', '7361850521', 'CUla@gmail.com'),
(768, 5382, 'Nolana Drucill', '8688104012', 'NDrucill@gmail.com'),
(782, 311, 'Katherina Faythe', '1743202159', 'KFaythe@gmail.com'),
(785, 6942, 'Gwenette Rene', '1730539184', 'GRene@gmail.com'),
(790, 7206, 'Mitzi Dominica', '9339938708', 'MDominica@gmail.com'),
(795, 3981, 'Cher Shina', '2187513265', 'CShina@gmail.com'),
(799, 5281, 'Lesli Aliza', '2683948660', 'LAliza@gmail.com'),
(800, 8647, 'Blinny Lucila', '9324399043', 'BLucila@gmail.com'),
(802, 5954, 'Kathy Karlie', '5285792354', 'KKarlie@gmail.com'),
(813, 6311, 'Sioux Jenna', '9304528866', 'SJenna@gmail.com'),
(816, 2658, 'Aile Gillie', '3351214123', 'AGillie@gmail.com'),
(821, 2524, 'Charmaine Cristen', '8642280558', 'CCristen@gmail.com'),
(830, 3564, 'Veriee Dorise', '1000802161', 'VDorise@gmail.com'),
(842, 7142, 'Sheilah Roby', '2278303393', 'SRoby@gmail.com'),
(843, 3730, 'Anastasie Moyra', '5929728161', 'AMoyra@gmail.com'),
(844, 7859, 'Kylila Hendrika', '7966803104', 'KHendrika@gmail.com'),
(879, 8934, 'Moria Gayleen', '8627374986', 'MGayleen@gmail.com'),
(880, 562, 'Gwen Sonni', '4995065767', 'GSonni@gmail.com'),
(881, 6204, 'Patrice Gavrielle', '3339778651', 'PGavrielle@gmail.com'),
(886, 4122, 'Silvia Shoshanna', '2830038957', 'SShoshanna@gmail.com'),
(887, 6434, 'Madelon Magdalen', '2225826278', 'MMagdalen@gmail.com'),
(890, 5526, 'Suzanne Eva', '6815892348', 'SEva@gmail.com'),
(907, 854, 'Trix Stephie', '7999269512', 'TStephie@gmail.com'),
(912, 7896, 'Ann-Marie Christi', '2206052124', 'AChristi@gmail.com'),
(934, 9860, 'Idell Caye', '9475451489', 'ICaye@gmail.com'),
(939, 4995, 'Betty Valencia', '4222438857', 'BValencia@gmail.com'),
(951, 7964, 'Leoline Camile', '3504306657', 'LCamile@gmail.com'),
(962, 102, 'Karyl Ronni', '4377583170', 'KRonni@gmail.com'),
(966, 557, 'Michal Ginelle', '3145524550', 'MGinelle@gmail.com'),
(983, 9556, 'Neilla Madelle', '9459783982', 'NMadelle@gmail.com'),
(989, 4220, 'Jessica Patience', '5148187052', 'JPatience@gmail.com'),
(991, 6589, 'Sue Meredith', '6935344601', 'SMeredith@gmail.com'),
(996, 5480, 'Lorrayne Sula', '8891457106', 'LSula@gmail.com');

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

--
-- Table structure for table `Order`
--

CREATE TABLE `Order` (
  `oid` int(11) NOT NULL,
  `customerid` int(11) NOT NULL,
  `EmpId` int(11) NOT NULL,
  `PaymentMethod` varchar(20) CHARACTER SET utf8 NOT NULL,
  `TimeStamp` date NOT NULL,
  `Price` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `sName` varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Order`
--

INSERT INTO `Order` (`oid`, `customerid`, `EmpId`, `PaymentMethod`, `TimeStamp`, `Price`, `sName`) VALUES
(1, 1, 263, 'Visa', '2018-11-08', '$5.84', 'Cheese Steak'),
(2, 1, 263, 'Visa', '2018-11-01', '$6.92', 'Roast Beef'),
(3, 342, 270, 'Cash', '2010-02-09', '$35.16', 'Cheese Steak'),
(4, 93, 479, 'Visa', '2005-02-11', '$50.74', 'Roasted Lamb'),
(5, 617, 252, 'Debit', '2012-12-17', '$44.15', 'Cheese Steak'),
(6, 365, 266, 'Cash', '2012-11-08', '$50.43', 'Tuna Salad'),
(7, 458, 275, 'Visa', '2018-10-13', '$45.59', 'Roast Beef'),
(8, 910, 332, 'Visa', '2011-06-27', '$28.59', 'Cold Cut'),
(9, 927, 474, 'Visa', '2014-05-16', '$20.36', NULL),
(10, 857, 429, 'Debit', '2018-07-05', '$41.23', 'Cold Cut'),
(11, 353, 448, 'Mastercard', '2015-03-07', '$45.83', 'Tuna Salad'),
(12, 412, 348, 'Mastercard', '2003-02-08', '$47.50', 'British'),
(13, 801, 365, 'Cash', '2007-07-24', '$33.19', 'BLT'),
(14, 565, 398, 'Debit', '2005-04-23', '$23.40', 'British'),
(15, 313, 293, 'Visa', '2007-12-19', '$10.88', NULL),
(16, 230, 278, 'Cash', '2008-04-24', '$2.42', 'Tuna Salad'),
(17, 371, 348, 'Visa', '2016-08-10', '$38.0', 'Cold Cut'),
(18, 494, 289, 'Visa', '2018-04-09', '$25.63', 'Sweet Onion Chicken'),
(19, 444, 440, 'Debit', '2015-05-05', '$48.62', 'Sweet Onion Chicken'),
(20, 586, 252, 'Mastercard', '2014-03-19', '$49.67', 'Cheese Steak'),
(21, 286, 379, 'Visa', '2014-09-01', '$2.97', 'Cold Cut'),
(22, 976, 282, 'Debit', '2002-11-24', '$23.85', NULL),
(23, 98, 437, 'Cash', '2004-03-24', '$30.77', 'Roast Beef'),
(24, 737, 295, 'Debit', '2010-03-21', '$40.68', 'Cheese Steak'),
(25, 564, 327, 'Mastercard', '2011-05-12', '$32.58', 'BLT'),
(26, 129, 456, 'Debit', '2010-04-06', '$38.79', 'BLT'),
(27, 492, 438, 'Visa', '2015-07-08', '$47.46', 'Cold Cut'),
(28, 62, 366, 'Mastercard', '2013-04-07', '$47.12', 'Tuna Salad'),
(29, 892, 466, 'Debit', '2002-12-04', '$26.81', 'Roast Beef'),
(30, 782, 341, 'Cash', '2009-04-13', '$7.76', 'British'),
(31, 334, 415, 'Cash', '2007-07-16', '$32.69', 'Roast Beef'),
(32, 597, 442, 'Cash', '2013-08-11', '$5.69', 'BLT'),
(33, 601, 361, 'Debit', '2006-09-17', '$46.35', NULL),
(34, 496, 355, 'Cash', '2007-02-27', '$30.89', 'Ham and Cheese'),
(35, 427, 425, 'Cash', '2009-05-20', '$43.89', 'Chicken Salad'),
(36, 655, 470, 'Debit', '2003-09-22', '$20.11', 'Ham and Cheese'),
(37, 193, 279, 'Mastercard', '2006-03-27', '$13.6', 'British'),
(38, 172, 499, 'Cash', '2013-10-22', '$35.11', 'Ham and Cheese'),
(39, 447, 312, 'Mastercard', '2004-12-13', '$28.6', 'British'),
(40, 188, 499, 'Visa', '2016-11-07', '$41.32', 'Roasted Lamb'),
(41, 562, 411, 'Cash', '2008-04-20', '$39.57', 'Tuna Salad'),
(42, 98, 263, 'Mastercard', '2009-05-13', '$4.39', 'Cheese Steak'),
(43, 133, 358, 'Debit', '2016-05-06', '$29.30', 'Roasted Lamb'),
(44, 323, 471, 'Debit', '2007-07-11', '$37.23', 'Sweet Onion Chicken'),
(45, 553, 328, 'Visa', '2003-07-17', '$22.2', 'Veggie'),
(46, 531, 331, 'Cash', '2009-10-22', '$15.69', 'Chicken Salad'),
(47, 596, 486, 'Debit', '2010-10-24', '$26.34', 'Ham and Cheese'),
(48, 571, 333, 'Visa', '2016-05-13', '$28.92', 'BLT'),
(49, 748, 500, 'Visa', '2016-02-08', '$8.34', 'Cold Cut'),
(50, 82, 274, 'Cash', '2008-03-01', '$4.85', 'British'),
(51, 790, 261, 'Debit', '2013-01-07', '$11.35', 'Roast Beef'),
(52, 7, 363, 'Debit', '2018-12-03', '$7.71', 'Roasted Lamb'),
(53, 452, 334, 'Visa', '2016-10-27', '$25.0', 'Sweet Onion Chicken'),
(54, 934, 258, 'Visa', '2010-03-28', '$12.28', 'Cheese Steak'),
(55, 855, 385, 'Mastercard', '2008-01-08', '$19.33', 'Cold Cut'),
(56, 230, 421, 'Mastercard', '2007-06-19', '$40.63', 'Sweet Onion Chicken'),
(57, 15, 430, 'Debit', '2017-11-15', '$28.96', 'Tuna Salad'),
(58, 647, 309, 'Mastercard', '2007-06-26', '$5.62', 'Roast Beef'),
(59, 250, 434, 'Mastercard', '2013-01-13', '$16.61', 'Veggie'),
(60, 932, 337, 'Debit', '2006-05-28', '$47.95', 'Cheese Steak');

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

--
-- Table structure for table `PairsWith`
--

CREATE TABLE `PairsWith` (
  `sName` varchar(20) CHARACTER SET utf8 NOT NULL,
  `iName` varchar(16) CHARACTER SET utf8 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PairsWith`
--

INSERT INTO `PairsWith` (`sName`, `iName`) VALUES
('BLT', 'Lettuce'),
('BLT', 'Mayonaise'),
('BLT', 'Pork'),
('BLT', 'Sourdough'),
('BLT', 'Tomatoes'),
('British', 'Cheese'),
('British', 'Lamb'),
('British', 'Mustard'),
('British', 'Onions'),
('British', 'Pepper'),
('British', 'Pickles'),
('British', 'Rye'),
('British', 'Salt'),
('Cheese Steak', 'BBQSauce'),
('Cheese Steak', 'Beef'),
('Cheese Steak', 'Cheese'),
('Cheese Steak', 'Cheesy Bread'),
('Cheese Steak', 'Ketchup'),
('Cheese Steak', 'Mustard'),
('Cheese Steak', 'Onions'),
('Chicken Salad', 'Chicken'),
('Chicken Salad', 'Mayonnaise'),
('Chicken Salad', 'Onions'),
('Chicken Salad', 'Pepper'),
('Chicken Salad', 'Salt'),
('Chicken Salad', 'WholeWheat'),
('Cold Cut', 'Beef'),
('Cold Cut', 'Chicken'),
('Cold Cut', 'Lamb'),
('Cold Cut', 'Lettuce'),
('Cold Cut', 'Pork'),
('Cold Cut', 'White'),
('Ham and Cheese', 'Cheese'),
('Ham and Cheese', 'Mayonaise'),
('Ham and Cheese', 'Mustard'),
('Ham and Cheese', 'Pork'),
('Ham and Cheese', 'White'),
('Roast Beef', 'BBQSauce'),
('Roast Beef', 'Beef'),
('Roast Beef', 'Cucumbers'),
('Roast Beef', 'Italian'),
('Roast Beef', 'Onions'),
('Roast Beef', 'Relish'),
('Roasted Lamb', 'Lamb'),
('Roasted Lamb', 'Pepper'),
('Roasted Lamb', 'Rye'),
('Roasted Lamb', 'Salt'),
('Roasted Lamb', 'Sprouts'),
('Sweet Onion Chicken', 'BBQSauce'),
('Sweet Onion Chicken', 'Chicken'),
('Sweet Onion Chicken', 'Flatbread'),
('Sweet Onion Chicken', 'Ketchup'),
('Sweet Onion Chicken', 'Lettuce'),
('Sweet Onion Chicken', 'Onion'),
('Tuna Salad', 'Cucumbers'),
('Tuna Salad', 'Fish'),
('Tuna Salad', 'Mayonaise'),
('Tuna Salad', 'Pepper'),
('Tuna Salad', 'Salt'),
('Tuna Salad', 'Sourdough'),
('Veggie', 'Cucumbers'),
('Veggie', 'Flatbread'),
('Veggie', 'Mayonnaise'),
('Veggie', 'Onions'),
('Veggie', 'Pickles'),
('Veggie', 'Sprouts'),
('Veggie', 'Tomatoes');

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

--
-- Table structure for table `Ranch`
--

CREATE TABLE `Ranch` (
  `prodId` int(11) NOT NULL,
  `MeatType` varchar(50) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Ranch`
--

INSERT INTO `Ranch` (`prodId`, `MeatType`) VALUES
(23, 'Beef'),
(39, 'Fish'),
(72, 'Chicken'),
(177, 'Pork'),
(202, 'Beef'),
(267, 'Chicken'),
(472, 'Fish'),
(537, 'Chicken'),
(577, 'Chicken'),
(704, 'Chicken');

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

--
-- Table structure for table `Sandwich`
--

CREATE TABLE `Sandwich` (
  `sName` varchar(20) CHARACTER SET utf8 NOT NULL,
  `Size` char(1) DEFAULT NULL,
  `toasted` tinyint(1) DEFAULT NULL,
  `Price` double DEFAULT NULL,
  `Vegetarian` tinyint(1) DEFAULT NULL,
  `calories` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sandwich`
--

INSERT INTO `Sandwich` (`sName`, `Size`, `toasted`, `Price`, `Vegetarian`, `calories`) VALUES
('BLT', 'S', 0, 5, 0, 480),
('British', 'L', 1, 6.35, 0, 590),
('Cheese Steak', 'L', 1, 7.5, 0, 800),
('Chicken Salad', 'S', 1, 5, 0, 523),
('Cold Cut', 'L', 0, 6, 0, 550),
('Ham and Cheese', 'L', 1, 4.5, 0, 450),
('Roast Beef', 'L', 0, 4, 0, 520),
('Roasted Lamb', 'L', 1, 5.75, 0, 600),
('Sweet Onion Chicken', 'S', 1, 5.5, 0, 469),
('Tuna Salad', 'S', 1, 5, 0, 578),
('Veggie', 'L', 0, 4.5, 1, 350);

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

--
-- Table structure for table `StoredIn`
--

CREATE TABLE `StoredIn` (
  `fid` int(11) NOT NULL,
  `iid` varchar(16) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `StoredIn`
--

INSERT INTO `StoredIn` (`fid`, `iid`) VALUES
(9, 'B35'),
(21, 'B63'),
(14, 'B64'),
(17, 'B66'),
(14, 'B70'),
(16, 'B80'),
(18, 'B90'),
(5, 'BBQ1'),
(2, 'BBQ13'),
(10, 'BBQ42'),
(22, 'BBQ57'),
(13, 'BBQ73'),
(6, 'BBQ84'),
(2, 'BBQ9'),
(21, 'C15'),
(8, 'C19'),
(18, 'C29'),
(5, 'C8'),
(14, 'C81'),
(0, 'C82'),
(19, 'C9'),
(1, 'C94'),
(4, 'C98'),
(2, 'CHE19'),
(23, 'CHE31'),
(18, 'CHE33'),
(24, 'CHE38'),
(2, 'CHE42'),
(6, 'CHE44'),
(15, 'CHE46'),
(8, 'CHE69'),
(20, 'CHE7'),
(8, 'CHE77'),
(3, 'CHE82'),
(17, 'CHE9'),
(8, 'CHE94'),
(3, 'CHE96'),
(5, 'CSB10'),
(23, 'CSB29'),
(19, 'CSB38'),
(10, 'CSB5'),
(16, 'CSB7'),
(8, 'CSB71'),
(21, 'CSB79'),
(9, 'CSB80'),
(20, 'CSB89'),
(10, 'CUC11'),
(9, 'CUC14'),
(8, 'CUC24'),
(8, 'CUC31'),
(16, 'CUC44'),
(16, 'CUC65'),
(1, 'CUC74'),
(9, 'F12'),
(16, 'F14'),
(17, 'F19'),
(8, 'F2'),
(22, 'F24'),
(8, 'F3'),
(18, 'F33'),
(23, 'F36'),
(1, 'F41'),
(2, 'F49'),
(3, 'F50'),
(14, 'F52'),
(7, 'F53'),
(22, 'F63'),
(13, 'F64'),
(20, 'F70'),
(10, 'F81'),
(18, 'F84'),
(7, 'FLB11'),
(24, 'FLB47'),
(21, 'FLB53'),
(23, 'FLB66'),
(20, 'FLB72'),
(20, 'FLB84'),
(20, 'FLB87'),
(24, 'FLB88'),
(5, 'ITB1'),
(8, 'ITB2'),
(0, 'ITB20'),
(10, 'ITB38'),
(21, 'ITB7'),
(12, 'ITB82'),
(22, 'ITB88'),
(14, 'ITB90'),
(20, 'ITB95'),
(4, 'KET15'),
(14, 'KET26'),
(7, 'KET31'),
(19, 'KET33'),
(5, 'KET4'),
(11, 'KET62'),
(16, 'KET80'),
(16, 'KET85'),
(5, 'KET92'),
(24, 'KET93'),
(8, 'KET96'),
(15, 'L13'),
(5, 'L15'),
(2, 'L29'),
(15, 'L33'),
(0, 'L70'),
(18, 'L75'),
(7, 'L86'),
(16, 'L96'),
(17, 'L98'),
(15, 'MAY17'),
(13, 'MAY2'),
(9, 'MAY22'),
(20, 'MAY26'),
(24, 'MAY27'),
(22, 'MAY29'),
(10, 'MAY32'),
(23, 'MAY33'),
(21, 'MAY40'),
(9, 'MAY50'),
(15, 'MAY66'),
(10, 'MAY68'),
(7, 'MAY7'),
(1, 'MAY84'),
(10, 'MAY94'),
(11, 'MUS14'),
(12, 'MUS21'),
(5, 'MUS23'),
(8, 'MUS25'),
(6, 'MUS3'),
(5, 'MUS35'),
(17, 'MUS40'),
(7, 'MUS44'),
(7, 'MUS5'),
(5, 'MUS51'),
(22, 'MUS6'),
(8, 'MUS62'),
(11, 'ONS10'),
(20, 'ONS16'),
(13, 'ONS19'),
(5, 'ONS20'),
(0, 'ONS56'),
(7, 'ONS60'),
(23, 'ONS62'),
(3, 'ONS63'),
(22, 'ONS66'),
(24, 'ONS78'),
(17, 'ONS88'),
(5, 'ONS91'),
(20, 'ONS96'),
(20, 'P32'),
(23, 'P33'),
(24, 'P53'),
(4, 'P71'),
(4, 'P83'),
(13, 'P96'),
(20, 'P97'),
(1, 'PEP1'),
(8, 'PEP48'),
(5, 'PEP69'),
(11, 'PEP75'),
(8, 'PEP77'),
(5, 'PEP84'),
(15, 'PIC23'),
(19, 'REL17'),
(5, 'REL26'),
(15, 'REL27'),
(2, 'REL35'),
(22, 'REL49'),
(1, 'REL52'),
(6, 'REL85'),
(15, 'REL95'),
(7, 'RYB11'),
(19, 'RYB14'),
(3, 'RYB16'),
(19, 'RYB53'),
(4, 'RYB6'),
(21, 'RYB64'),
(5, 'RYB68'),
(16, 'RYB79'),
(9, 'RYB80'),
(21, 'SAL15'),
(9, 'SAL19'),
(17, 'SAL28'),
(17, 'SAL40'),
(14, 'SAL48'),
(6, 'SAL59'),
(24, 'SAL76'),
(16, 'SAL85'),
(5, 'SAL90'),
(8, 'SDB16'),
(8, 'SDB2'),
(21, 'SDB22'),
(0, 'SDB25'),
(8, 'SDB32'),
(9, 'SDB35'),
(6, 'SDB39'),
(2, 'SDB4'),
(16, 'SDB56'),
(15, 'SDB60'),
(15, 'SDB89'),
(24, 'SDB9'),
(22, 'SDB93'),
(8, 'SDB99'),
(0, 'SPR14'),
(1, 'SPR19'),
(2, 'SPR31'),
(21, 'SPR33'),
(1, 'SPR37'),
(18, 'SPR46'),
(13, 'SPR47'),
(9, 'SPR59'),
(16, 'SPR70'),
(10, 'SPR76'),
(10, 'SPR87'),
(3, 'TOM15'),
(2, 'TOM31'),
(8, 'TOM36'),
(16, 'TOM43'),
(3, 'TOM69'),
(20, 'TOM74'),
(20, 'TOM93'),
(23, 'WB10'),
(6, 'WB18'),
(23, 'WB25'),
(23, 'WB30'),
(24, 'WB43'),
(5, 'WB67'),
(4, 'WB68'),
(6, 'WWB1'),
(19, 'WWB16'),
(15, 'WWB25'),
(23, 'WWB26'),
(18, 'WWB61'),
(19, 'WWB68'),
(15, 'WWB7'),
(6, 'WWB82'),
(24, 'WWB85'),
(0, 'B22'),
(0, 'C69'),
(0, 'P24'),
(0, 'L99'),
(0, 'F42'),
(0, 'CUC43'),
(0, 'TOM62'),
(0, 'ONS39'),
(0, 'PIC82'),
(0, 'SPR1'),
(0, 'WB41'),
(0, 'WWB72'),
(0, 'SDB84'),
(0, 'RYB34'),
(0, 'FLB27'),
(0, 'CSB52'),
(0, 'ITB45'),
(0, 'KET37'),
(0, 'MUS13'),
(0, 'SAL27'),
(0, 'PEP63'),
(0, 'MAY83'),
(0, 'REL29'),
(0, 'BBQ74'),
(1, 'B86'),
(1, 'C55'),
(1, 'P37'),
(1, 'L52'),
(1, 'F11'),
(1, 'CUC75'),
(1, 'TOM2'),
(1, 'ONS93'),
(1, 'PIC58'),
(1, 'SPR12'),
(1, 'WB27'),
(1, 'WWB75'),
(1, 'SDB66'),
(1, 'RYB22'),
(1, 'FLB89'),
(1, 'CSB51'),
(1, 'ITB3'),
(1, 'KET21'),
(1, 'MUS9'),
(1, 'SAL42'),
(1, 'PEP76'),
(1, 'MAY55'),
(1, 'REL90'),
(1, 'BBQ59'),
(2, 'B7'),
(2, 'C25'),
(2, 'P39'),
(2, 'L21'),
(2, 'F73'),
(2, 'CUC13'),
(2, 'TOM35'),
(2, 'ONS31'),
(2, 'PIC20'),
(2, 'SPR95'),
(2, 'WB77'),
(2, 'WWB80'),
(2, 'SDB36'),
(2, 'RYB60'),
(2, 'FLB5'),
(2, 'CSB63'),
(2, 'ITB21'),
(2, 'KET47'),
(2, 'MUS70'),
(2, 'SAL57'),
(2, 'PEP85'),
(2, 'MAY89'),
(2, 'REL66'),
(2, 'BBQ23'),
(3, 'B9'),
(3, 'C1'),
(3, 'P1'),
(3, 'L34'),
(3, 'F65'),
(3, 'CUC77'),
(3, 'TOM27'),
(3, 'ONS5'),
(3, 'PIC62'),
(3, 'SPR53'),
(3, 'WB90'),
(3, 'WWB57'),
(3, 'SDB94'),
(3, 'RYB99'),
(3, 'FLB21'),
(3, 'CSB16'),
(3, 'ITB79'),
(3, 'KET65'),
(3, 'MUS32'),
(3, 'SAL65'),
(3, 'PEP36'),
(3, 'MAY92'),
(3, 'REL46'),
(3, 'BBQ37'),
(4, 'B58'),
(4, 'C74'),
(4, 'P22'),
(4, 'L28'),
(4, 'F91'),
(4, 'CUC85'),
(4, 'TOM8'),
(4, 'ONS44'),
(4, 'PIC39'),
(4, 'SPR83'),
(4, 'WB38'),
(4, 'WWB47'),
(4, 'SDB81'),
(4, 'RYB43'),
(4, 'FLB20'),
(4, 'CSB46'),
(4, 'ITB94'),
(4, 'KET46'),
(4, 'MUS46'),
(4, 'SAL98'),
(4, 'PEP65'),
(4, 'MAY78'),
(4, 'REL67'),
(4, 'BBQ72'),
(5, 'B45'),
(5, 'C80'),
(5, 'P87'),
(5, 'L7'),
(5, 'F45'),
(5, 'CUC67'),
(5, 'TOM99'),
(5, 'ONS64'),
(5, 'PIC96'),
(5, 'SPR96'),
(5, 'WB82'),
(5, 'WWB50'),
(5, 'SDB68'),
(5, 'RYB59'),
(5, 'FLB42'),
(5, 'CSB81'),
(5, 'ITB30'),
(5, 'KET10'),
(5, 'MUS1'),
(5, 'SAL46'),
(5, 'PEP87'),
(5, 'MAY53'),
(5, 'REL31'),
(5, 'BBQ24'),
(6, 'B27'),
(6, 'C99'),
(6, 'P46'),
(6, 'L23'),
(6, 'F34'),
(6, 'CUC29'),
(6, 'TOM79'),
(6, 'ONS49'),
(6, 'PIC10'),
(6, 'SPR25'),
(6, 'WB39'),
(6, 'WWB81'),
(6, 'SDB47'),
(6, 'RYB17'),
(6, 'FLB32'),
(6, 'CSB3'),
(6, 'ITB99'),
(6, 'KET99'),
(6, 'MUS33'),
(6, 'SAL84'),
(6, 'PEP12'),
(6, 'MAY69'),
(6, 'REL75'),
(6, 'BBQ43'),
(7, 'B74'),
(7, 'C53'),
(7, 'P48'),
(7, 'L57'),
(7, 'F22'),
(7, 'CUC52'),
(7, 'TOM83'),
(7, 'ONS52'),
(7, 'PIC28'),
(7, 'SPR22'),
(7, 'WB34'),
(7, 'WWB46'),
(7, 'SDB37'),
(7, 'RYB31'),
(7, 'FLB18'),
(7, 'CSB24'),
(7, 'ITB5'),
(7, 'KET57'),
(7, 'MUS18'),
(7, 'SAL43'),
(7, 'PEP5'),
(7, 'MAY87'),
(7, 'REL91'),
(7, 'BBQ71'),
(8, 'B59'),
(8, 'C31'),
(8, 'P95'),
(8, 'L11'),
(8, 'F5'),
(8, 'CUC9'),
(8, 'TOM55'),
(8, 'ONS89'),
(8, 'PIC30'),
(8, 'SPR99'),
(8, 'WB12'),
(8, 'WWB24'),
(8, 'SDB65'),
(8, 'RYB86'),
(8, 'FLB45'),
(8, 'CSB76'),
(8, 'ITB35'),
(8, 'KET51'),
(8, 'MUS27'),
(8, 'SAL51'),
(8, 'PEP16'),
(8, 'MAY12'),
(8, 'REL98'),
(8, 'BBQ78'),
(9, 'B31'),
(9, 'C64'),
(9, 'P55'),
(9, 'L65'),
(9, 'F61'),
(9, 'CUC2'),
(9, 'TOM53'),
(9, 'ONS90'),
(9, 'PIC43'),
(9, 'SPR30'),
(9, 'WB5'),
(9, 'WWB21'),
(9, 'SDB3'),
(9, 'RYB95'),
(9, 'FLB28'),
(9, 'CSB30'),
(9, 'ITB83'),
(9, 'KET78'),
(9, 'MUS66'),
(9, 'SAL60'),
(9, 'PEP17'),
(9, 'MAY90'),
(9, 'REL63'),
(9, 'BBQ64'),
(10, 'B76'),
(10, 'C17'),
(10, 'P70'),
(10, 'L51'),
(10, 'F43'),
(10, 'CUC80'),
(10, 'TOM28'),
(10, 'ONS98'),
(10, 'PIC77'),
(10, 'SPR28'),
(10, 'WB63'),
(10, 'WWB13'),
(10, 'SDB51'),
(10, 'RYB3'),
(10, 'FLB90'),
(10, 'CSB18'),
(10, 'ITB43'),
(10, 'KET28'),
(10, 'MUS61'),
(10, 'SAL22'),
(10, 'PEP21'),
(10, 'MAY37'),
(10, 'REL80'),
(10, 'BBQ83'),
(11, 'B65'),
(11, 'C44'),
(11, 'P16'),
(11, 'L40'),
(11, 'F54'),
(11, 'CUC39'),
(11, 'TOM13'),
(11, 'ONS29'),
(11, 'PIC7'),
(11, 'SPR86'),
(11, 'WB48'),
(11, 'WWB84'),
(11, 'SDB64'),
(11, 'RYB9'),
(11, 'FLB83'),
(11, 'CSB64'),
(11, 'ITB80'),
(11, 'KET22'),
(11, 'MUS10'),
(11, 'SAL58'),
(11, 'PEP3'),
(11, 'MAY18'),
(11, 'REL41'),
(11, 'BBQ41'),
(12, 'B92'),
(12, 'C13'),
(12, 'P54'),
(12, 'L19'),
(12, 'F15'),
(12, 'CUC58'),
(12, 'TOM80'),
(12, 'ONS43'),
(12, 'PIC38'),
(12, 'SPR7'),
(12, 'WB40'),
(12, 'WWB38'),
(12, 'SDB67'),
(12, 'RYB96'),
(12, 'FLB96'),
(12, 'CSB36'),
(12, 'ITB74'),
(12, 'KET9'),
(12, 'MUS4'),
(12, 'SAL7'),
(12, 'PEP22'),
(12, 'MAY20'),
(12, 'REL71'),
(12, 'BBQ12'),
(13, 'B77'),
(13, 'C96'),
(13, 'P79'),
(13, 'L48'),
(13, 'F79'),
(13, 'CUC57'),
(13, 'TOM9'),
(13, 'ONS94'),
(13, 'PIC72'),
(13, 'SPR58'),
(13, 'WB64'),
(13, 'WWB22'),
(13, 'SDB75'),
(13, 'RYB83'),
(13, 'FLB30'),
(13, 'CSB90'),
(13, 'ITB10'),
(13, 'KET90'),
(13, 'MUS37'),
(13, 'SAL37'),
(13, 'PEP68'),
(13, 'MAY28'),
(13, 'REL33'),
(13, 'BBQ91'),
(14, 'B57'),
(14, 'C2'),
(14, 'P92'),
(14, 'L30'),
(14, 'F4'),
(14, 'CUC6'),
(14, 'TOM71'),
(14, 'ONS83'),
(14, 'PIC67'),
(14, 'SPR15'),
(14, 'WB73'),
(14, 'WWB59'),
(14, 'SDB49'),
(14, 'RYB20'),
(14, 'FLB85'),
(14, 'CSB32'),
(14, 'ITB71'),
(14, 'KET27'),
(14, 'MUS39'),
(14, 'SAL67'),
(14, 'PEP64'),
(14, 'MAY47'),
(14, 'REL64'),
(14, 'BBQ18'),
(15, 'B60'),
(15, 'C87'),
(15, 'P30'),
(15, 'L43'),
(15, 'F83'),
(15, 'CUC8'),
(15, 'TOM84'),
(15, 'ONS9'),
(15, 'PIC35'),
(15, 'SPR48'),
(15, 'WB65'),
(15, 'WWB12'),
(15, 'SDB78'),
(15, 'RYB88'),
(15, 'FLB93'),
(15, 'CSB75'),
(15, 'ITB98'),
(15, 'KET40'),
(15, 'MUS34'),
(15, 'SAL55'),
(15, 'PEP99'),
(15, 'MAY56'),
(15, 'REL10'),
(15, 'BBQ21'),
(16, 'B1'),
(16, 'C59'),
(16, 'P91'),
(16, 'L74'),
(16, 'F66'),
(16, 'CUC56'),
(16, 'TOM98'),
(16, 'ONS95'),
(16, 'PIC3'),
(16, 'SPR27'),
(16, 'WB49'),
(16, 'WWB67'),
(16, 'SDB26'),
(16, 'RYB84'),
(16, 'FLB62'),
(16, 'CSB27'),
(16, 'ITB62'),
(16, 'KET88'),
(16, 'MUS52'),
(16, 'SAL30'),
(16, 'PEP53'),
(16, 'MAY79'),
(16, 'REL32'),
(16, 'BBQ75'),
(17, 'B85'),
(17, 'C91'),
(17, 'P21'),
(17, 'L84'),
(17, 'F37'),
(17, 'CUC7'),
(17, 'TOM92'),
(17, 'ONS22'),
(17, 'PIC25'),
(17, 'SPR78'),
(17, 'WB44'),
(17, 'WWB77'),
(17, 'SDB44'),
(17, 'RYB24'),
(17, 'FLB9'),
(17, 'CSB60'),
(17, 'ITB11'),
(17, 'KET1'),
(17, 'MUS90'),
(17, 'SAL38'),
(17, 'PEP66'),
(17, 'MAY42'),
(17, 'REL68'),
(17, 'BBQ50'),
(18, 'B55'),
(18, 'C32'),
(18, 'P78'),
(18, 'L71'),
(18, 'F85'),
(18, 'CUC10'),
(18, 'TOM97'),
(18, 'ONS26'),
(18, 'PIC21'),
(18, 'SPR98'),
(18, 'WB72'),
(18, 'WWB45'),
(18, 'SDB88'),
(18, 'RYB51'),
(18, 'FLB86'),
(18, 'CSB13'),
(18, 'ITB28'),
(18, 'KET20'),
(18, 'MUS31'),
(18, 'SAL70'),
(18, 'PEP49'),
(18, 'MAY51'),
(18, 'REL5'),
(18, 'BBQ28'),
(19, 'B61'),
(19, 'C60'),
(19, 'P13'),
(19, 'L60'),
(19, 'F76'),
(19, 'CUC1'),
(19, 'TOM38'),
(19, 'ONS50'),
(19, 'PIC53'),
(19, 'SPR73'),
(19, 'WB23'),
(19, 'WWB83'),
(19, 'SDB72'),
(19, 'RYB7'),
(19, 'FLB57'),
(19, 'CSB65'),
(19, 'ITB19'),
(19, 'KET61'),
(19, 'MUS60'),
(19, 'SAL72'),
(19, 'PEP78'),
(19, 'MAY15'),
(19, 'REL34'),
(19, 'BBQ99'),
(20, 'B73'),
(20, 'C67'),
(20, 'P99'),
(20, 'L77'),
(20, 'F88'),
(20, 'CUC73'),
(20, 'TOM6'),
(20, 'ONS87'),
(20, 'PIC55'),
(20, 'SPR74'),
(20, 'WB45'),
(20, 'WWB36'),
(20, 'SDB40'),
(20, 'RYB47'),
(20, 'FLB76'),
(20, 'CSB73'),
(20, 'ITB12'),
(20, 'KET41'),
(20, 'MUS97'),
(20, 'SAL32'),
(20, 'PEP9'),
(20, 'MAY54'),
(20, 'REL82'),
(20, 'BBQ70'),
(21, 'B5'),
(21, 'C51'),
(21, 'P35'),
(21, 'L80'),
(21, 'F23'),
(21, 'CUC49'),
(21, 'TOM42'),
(21, 'ONS71'),
(21, 'PIC42'),
(21, 'SPR39'),
(21, 'WB11'),
(21, 'WWB52'),
(21, 'SDB11'),
(21, 'RYB56'),
(21, 'FLB61'),
(21, 'CSB12'),
(21, 'ITB34'),
(21, 'KET38'),
(21, 'MUS67'),
(21, 'SAL41'),
(21, 'PEP81'),
(21, 'MAY3'),
(21, 'REL96'),
(21, 'BBQ98'),
(22, 'B93'),
(22, 'C33'),
(22, 'P3'),
(22, 'L97'),
(22, 'F47'),
(22, 'CUC36'),
(22, 'TOM29'),
(22, 'ONS75'),
(22, 'PIC15'),
(22, 'SPR24'),
(22, 'WB78'),
(22, 'WWB86'),
(22, 'SDB69'),
(22, 'RYB92'),
(22, 'FLB22'),
(22, 'CSB54'),
(22, 'ITB9'),
(22, 'KET6'),
(22, 'MUS77'),
(22, 'SAL24'),
(22, 'PEP98'),
(22, 'MAY74'),
(22, 'REL69'),
(22, 'BBQ67'),
(23, 'B17'),
(23, 'C40'),
(23, 'P77'),
(23, 'L1'),
(23, 'F7'),
(23, 'CUC22'),
(23, 'TOM39'),
(23, 'ONS86'),
(23, 'PIC87'),
(23, 'SPR9'),
(23, 'WB81'),
(23, 'WWB58'),
(23, 'SDB1'),
(23, 'RYB32'),
(23, 'FLB33'),
(23, 'CSB31'),
(23, 'ITB87'),
(23, 'KET70'),
(23, 'MUS88'),
(23, 'SAL26'),
(23, 'PEP19'),
(23, 'MAY58'),
(23, 'REL43'),
(23, 'BBQ61'),
(24, 'B13'),
(24, 'C56'),
(24, 'P41'),
(24, 'L42'),
(24, 'F44'),
(24, 'CUC18'),
(24, 'TOM18'),
(24, 'ONS34'),
(24, 'PIC94'),
(24, 'SPR5'),
(24, 'WB1'),
(24, 'WWB5'),
(24, 'SDB71'),
(24, 'RYB61'),
(24, 'FLB54'),
(24, 'CSB58'),
(24, 'ITB93'),
(24, 'KET25'),
(24, 'MUS17'),
(24, 'SAL75'),
(24, 'PEP95'),
(24, 'MAY36'),
(24, 'REL19'),
(24, 'BBQ2');

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

--
-- Table structure for table `Supplies`
--

CREATE TABLE `Supplies` (
  `sid` int(11) NOT NULL,
  `did` int(11) NOT NULL,
  `fid` int(11) NOT NULL,
  `ship_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Supplies`
--

INSERT INTO `Supplies` (`sid`, `did`, `fid`, `ship_date`) VALUES
(1, 240, 8, '2002-11-05'),
(2, 762, 6, '2018-12-08'),
(3, 28, 6, '2017-03-03'),
(4, 777, 16, '2016-10-07'),
(5, 642, 22, '2007-04-21'),
(6, 820, 6, '2006-12-18'),
(7, 718, 1, '2011-05-08'),
(8, 641, 3, '2011-06-13'),
(9, 320, 6, '2013-11-24'),
(10, 503, 23, '2003-12-03'),
(11, 745, 11, '2003-01-24'),
(12, 793, 24, '2002-01-21'),
(13, 158, 23, '2011-04-10'),
(14, 320, 9, '2005-11-03'),
(15, 777, 22, '2012-07-17'),
(16, 593, 8, '2013-09-05'),
(17, 917, 6, '2007-12-04'),
(18, 907, 1, '2013-09-03'),
(19, 240, 2, '2012-02-08'),
(20, 443, 14, '2012-02-21'),
(21, 917, 9, '2011-10-05'),
(22, 73, 0, '2003-11-09'),
(23, 1, 2, '2009-10-28'),
(24, 83, 24, '2010-05-03'),
(25, 718, 3, '2013-04-26'),
(26, 558, 23, '2015-05-22'),
(27, 2, 13, '2005-03-17'),
(28, 703, 7, '2009-11-22'),
(29, 722, 13, '2017-06-06'),
(30, 907, 24, '2011-04-01'),
(31, 53, 18, '2016-10-04'),
(32, 462, 11, '2006-10-21'),
(33, 443, 10, '2009-08-16'),
(34, 118, 4, '2013-10-06'),
(35, 870, 13, '2004-12-02'),
(36, 641, 2, '2011-04-11'),
(37, 536, 20, '2007-04-09'),
(38, 443, 8, '2015-12-02'),
(39, 342, 1, '2004-11-04'),
(40, 942, 9, '2002-12-27'),
(41, 876, 11, '2014-09-21'),
(42, 825, 17, '2012-07-27'),
(43, 320, 13, '2007-10-11'),
(44, 217, 21, '2003-05-15'),
(45, 249, 15, '2012-07-26'),
(46, 820, 15, '2010-05-18'),
(47, 561, 0, '2002-09-11'),
(48, 641, 9, '2011-05-08'),
(49, 907, 5, '2010-09-10'),
(50, 249, 19, '2002-07-05'),
(51, 500, 14, '2004-04-02'),
(52, 641, 20, '2013-06-24'),
(53, 575, 5, '2013-06-14'),
(54, 931, 23, '2007-04-23'),
(55, 870, 11, '2007-11-17'),
(56, 745, 19, '2009-05-01'),
(57, 536, 19, '2008-06-12'),
(58, 266, 19, '2012-05-19'),
(59, 703, 19, '2017-04-25'),
(60, 118, 17, '2005-12-23'),
(61, 718, 8, '2002-07-25'),
(62, 342, 13, '2008-04-21'),
(63, 158, 11, '2015-12-08'),
(64, 443, 4, '2012-09-28'),
(65, 558, 10, '2017-03-05'),
(66, 917, 8, '2007-02-10'),
(67, 718, 4, '2003-08-14'),
(68, 577, 15, '2014-06-09'),
(69, 777, 3, '2006-09-25');

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

--
-- Structure for view `custview`
--
DROP TABLE IF EXISTS `custview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `crust`.`custview`  AS  select distinct `crust`.`customer`.`cid` AS `cid`,`crust`.`member`.`Points` AS `Points`,`crust`.`member`.`Name` AS `Name`,`crust`.`member`.`Phone` AS `Phone`,`crust`.`member`.`Email` AS `Email`,`crust`.`order`.`oid` AS `oid`,`crust`.`order`.`customerid` AS `customerid`,`crust`.`order`.`EmpId` AS `EmpId`,`crust`.`order`.`PaymentMethod` AS `PaymentMethod`,`crust`.`order`.`TimeStamp` AS `TimeStamp`,`crust`.`order`.`Price` AS `OrderPrice`,`crust`.`order`.`sName` AS `sName`,`crust`.`sandwich`.`Size` AS `Size`,`crust`.`sandwich`.`toasted` AS `toasted`,`crust`.`sandwich`.`Price` AS `SandwichPrice`,`crust`.`sandwich`.`Vegetarian` AS `S_VEG`,`crust`.`sandwich`.`calories` AS `calories`,`crust`.`ingredient`.`iName` AS `iName`,`crust`.`ingredient`.`vegetarian` AS `I_VEG` from ((((((((`crust`.`customer` left join `crust`.`member` on((`crust`.`member`.`cid` = `crust`.`customer`.`cid`))) join `crust`.`order` on((`crust`.`order`.`customerid` = `crust`.`customer`.`cid`))) join `crust`.`employee` on((`crust`.`employee`.`empId` = `crust`.`order`.`EmpId`))) join `crust`.`franchise` on((`crust`.`employee`.`fid` = `crust`.`franchise`.`fid`))) join `crust`.`storedin` on((`crust`.`storedin`.`fid` = `crust`.`franchise`.`fid`))) join `crust`.`sandwich` on((`crust`.`sandwich`.`sName` = `crust`.`order`.`sName`))) join `crust`.`pairswith` on((`crust`.`sandwich`.`sName` = `crust`.`pairswith`.`sName`))) join `crust`.`ingredient` on(((`crust`.`pairswith`.`iName` = `crust`.`ingredient`.`iName`) and (`crust`.`storedin`.`iid` = `crust`.`ingredient`.`iid`)))) order by `crust`.`customer`.`cid` ;

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

--
-- Structure for view `distview`
--
DROP TABLE IF EXISTS `distview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `crust`.`distview`  AS  select distinct `crust`.`distributor`.`Name` AS `Name`,`crust`.`distributor`.`Address` AS `Address`,`crust`.`distributor`.`did` AS `did`,`crust`.`ingredientproducer`.`prodid` AS `prodid`,`crust`.`ingredientproducer`.`address` AS `ProducerAddress`,`crust`.`ingredientproducer`.`phone` AS `phone`,`crust`.`bakery`.`breadType` AS `breadType`,`crust`.`ranch`.`MeatType` AS `MeatType`,`crust`.`farm`.`ProduceType` AS `ProduceType`,`crust`.`supplies`.`sid` AS `sid`,`crust`.`supplies`.`fid` AS `fid`,`crust`.`supplies`.`ship_date` AS `ship_date`,`crust`.`ingredient`.`iid` AS `iid`,`crust`.`ingredient`.`iName` AS `iName`,`crust`.`ingredient`.`vegetarian` AS `vegetarian`,`crust`.`ingredient`.`bb_date` AS `bb_date` from ((((((`crust`.`distributor` join `crust`.`ingredientproducer` on((`crust`.`ingredientproducer`.`did` = `crust`.`distributor`.`did`))) left join `crust`.`bakery` on((`crust`.`bakery`.`prodId` = `crust`.`ingredientproducer`.`prodid`))) left join `crust`.`ranch` on((`crust`.`ranch`.`prodId` = `crust`.`ingredientproducer`.`prodid`))) left join `crust`.`farm` on((`crust`.`farm`.`prodId` = `crust`.`ingredientproducer`.`prodid`))) join `crust`.`supplies` on((`crust`.`supplies`.`did` = `crust`.`distributor`.`did`))) join `crust`.`ingredient` on((`crust`.`ingredient`.`sid` = `crust`.`supplies`.`sid`))) ;

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

--
-- Structure for view `emplview`
--
DROP TABLE IF EXISTS `emplview`;

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `crust`.`emplview`  AS  select distinct `crust`.`employee`.`empId` AS `empId`,`crust`.`employee`.`personalId` AS `personalId`,`crust`.`employee`.`DOB` AS `DOB`,`crust`.`employee`.`fid` AS `fid`,`crust`.`customer`.`cid` AS `cid`,`crust`.`member`.`Points` AS `Points`,`crust`.`member`.`Name` AS `Name`,`crust`.`member`.`Phone` AS `Phone`,`crust`.`member`.`Email` AS `Email`,`crust`.`order`.`oid` AS `oid`,`crust`.`order`.`PaymentMethod` AS `PaymentMethod`,`crust`.`order`.`TimeStamp` AS `TimeStamp`,`crust`.`order`.`Price` AS `OrderPrice`,`crust`.`order`.`sName` AS `sName`,`crust`.`sandwich`.`Size` AS `Size`,`crust`.`sandwich`.`toasted` AS `toasted`,`crust`.`sandwich`.`Price` AS `SandwichPrice`,`crust`.`sandwich`.`Vegetarian` AS `S_VEG`,`crust`.`sandwich`.`calories` AS `calories`,`crust`.`ingredient`.`iid` AS `iid`,`crust`.`ingredient`.`iName` AS `iName`,`crust`.`ingredient`.`vegetarian` AS `I_VEG`,`crust`.`ingredient`.`bb_date` AS `bb_date`,`crust`.`franchise`.`Address` AS `FranchiseAddress`,`crust`.`franchise`.`Phone` AS `FranchisePhone`,`crust`.`distributor`.`did` AS `did`,`crust`.`distributor`.`Name` AS `DistributorName`,`crust`.`distributor`.`Address` AS `DistributorAddress` from (((((((((`crust`.`order` left join `crust`.`customer` on((`crust`.`order`.`customerid` = `crust`.`customer`.`cid`))) left join `crust`.`member` on((`crust`.`member`.`cid` = `crust`.`customer`.`cid`))) left join `crust`.`sandwich` on((`crust`.`sandwich`.`sName` = `crust`.`order`.`sName`))) join `crust`.`employee` on((`crust`.`employee`.`empId` = `crust`.`order`.`EmpId`))) join `crust`.`pairswith` on((`crust`.`sandwich`.`sName` = `crust`.`pairswith`.`sName`))) join `crust`.`franchise` on((`crust`.`franchise`.`fid` = `crust`.`employee`.`fid`))) join `crust`.`distributor` on((`crust`.`distributor`.`did` = `crust`.`franchise`.`did`))) join `crust`.`storedin` on((`crust`.`storedin`.`fid` = `crust`.`franchise`.`fid`))) join `crust`.`ingredient` on(((`crust`.`ingredient`.`iName` = `crust`.`pairswith`.`iName`) and (`crust`.`ingredient`.`iid` = `crust`.`storedin`.`iid`)))) order by `crust`.`member`.`Points` desc ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `Bakery`
--
ALTER TABLE `Bakery`
  ADD PRIMARY KEY (`prodId`);

--
-- Indexes for table `Customer`
--
ALTER TABLE `Customer`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `Distributor`
--
ALTER TABLE `Distributor`
  ADD PRIMARY KEY (`did`);

--
-- Indexes for table `Employee`
--
ALTER TABLE `Employee`
  ADD PRIMARY KEY (`empId`),
  ADD KEY `fid` (`fid`);

--
-- Indexes for table `Farm`
--
ALTER TABLE `Farm`
  ADD PRIMARY KEY (`prodId`);

--
-- Indexes for table `Franchise`
--
ALTER TABLE `Franchise`
  ADD PRIMARY KEY (`fid`),
  ADD KEY `did` (`did`);

--
-- Indexes for table `Ingredient`
--
ALTER TABLE `Ingredient`
  ADD PRIMARY KEY (`iid`);

--
-- Indexes for table `IngredientProducer`
--
ALTER TABLE `IngredientProducer`
  ADD PRIMARY KEY (`prodid`),
  ADD KEY `did` (`did`);

--
-- Indexes for table `Member`
--
ALTER TABLE `Member`
  ADD PRIMARY KEY (`cid`);

--
-- Indexes for table `Order`
--
ALTER TABLE `Order`
  ADD PRIMARY KEY (`oid`),
  ADD KEY `customerid` (`customerid`),
  ADD KEY `EmpId` (`EmpId`);

--
-- Indexes for table `PairsWith`
--
ALTER TABLE `PairsWith`
  ADD PRIMARY KEY (`sName`,`iName`);

--
-- Indexes for table `Ranch`
--
ALTER TABLE `Ranch`
  ADD PRIMARY KEY (`prodId`);

--
-- Indexes for table `Sandwich`
--
ALTER TABLE `Sandwich`
  ADD PRIMARY KEY (`sName`);

--
-- Indexes for table `StoredIn`
--
ALTER TABLE `StoredIn`
  ADD KEY `fk_SI_ingredient` (`iid`);

--
-- Indexes for table `Supplies`
--
ALTER TABLE `Supplies`
  ADD PRIMARY KEY (`sid`),
  ADD KEY `fk_S_distributor` (`did`),
  ADD KEY `fk_S_franchise` (`fid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `Customer`
--
ALTER TABLE `Customer`
  MODIFY `cid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1156;

--
-- AUTO_INCREMENT for table `Employee`
--
ALTER TABLE `Employee`
  MODIFY `empId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=502;

--
-- AUTO_INCREMENT for table `Order`
--
ALTER TABLE `Order`
  MODIFY `oid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1686;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `Bakery`
--
ALTER TABLE `Bakery`
  ADD CONSTRAINT `bakery_ibfk_1` FOREIGN KEY (`prodId`) REFERENCES `IngredientProducer` (`prodid`) ON UPDATE CASCADE;

--
-- Constraints for table `Employee`
--
ALTER TABLE `Employee`
  ADD CONSTRAINT `employee_ibfk_1` FOREIGN KEY (`fid`) REFERENCES `Franchise` (`fid`) ON UPDATE CASCADE;

--
-- Constraints for table `Farm`
--
ALTER TABLE `Farm`
  ADD CONSTRAINT `farm_ibfk_1` FOREIGN KEY (`prodId`) REFERENCES `IngredientProducer` (`prodid`) ON UPDATE CASCADE;

--
-- Constraints for table `Franchise`
--
ALTER TABLE `Franchise`
  ADD CONSTRAINT `franchise_ibfk_1` FOREIGN KEY (`did`) REFERENCES `Distributor` (`did`) ON UPDATE CASCADE;

--
-- Constraints for table `IngredientProducer`
--
ALTER TABLE `IngredientProducer`
  ADD CONSTRAINT `ingredientproducer_ibfk_1` FOREIGN KEY (`did`) REFERENCES `Distributor` (`did`) ON UPDATE CASCADE;

--
-- Constraints for table `Member`
--
ALTER TABLE `Member`
  ADD CONSTRAINT `member_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `Customer` (`cid`) ON UPDATE CASCADE;

--
-- Constraints for table `Order`
--
ALTER TABLE `Order`
  ADD CONSTRAINT `order_ibfk_1` FOREIGN KEY (`customerid`) REFERENCES `Customer` (`cid`) ON UPDATE CASCADE,
  ADD CONSTRAINT `order_ibfk_2` FOREIGN KEY (`EmpId`) REFERENCES `Employee` (`empId`) ON UPDATE CASCADE;

--
-- Constraints for table `PairsWith`
--
ALTER TABLE `PairsWith`
  ADD CONSTRAINT `pairswith_ibfk_1` FOREIGN KEY (`sName`) REFERENCES `Sandwich` (`sName`) ON UPDATE CASCADE;

--
-- Constraints for table `Ranch`
--
ALTER TABLE `Ranch`
  ADD CONSTRAINT `ranch_ibfk_1` FOREIGN KEY (`prodId`) REFERENCES `IngredientProducer` (`prodid`) ON UPDATE CASCADE;

--
-- Constraints for table `StoredIn`
--
ALTER TABLE `StoredIn`
  ADD CONSTRAINT `fk_SI_ingredient` FOREIGN KEY (`iid`) REFERENCES `Ingredient` (`iid`) ON DELETE CASCADE;

--
-- Constraints for table `Supplies`
--
ALTER TABLE `Supplies`
  ADD CONSTRAINT `fk_S_distributor` FOREIGN KEY (`did`) REFERENCES `Distributor` (`did`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  ADD CONSTRAINT `fk_S_franchise` FOREIGN KEY (`fid`) REFERENCES `Franchise` (`fid`) ON DELETE NO ACTION ON UPDATE NO ACTION;
COMMIT;

/*!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 */;