-- phpMyAdmin SQL Dump
-- version 4.0.10.14
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Sep 19, 2016 at 12:29 PM
-- Server version: 5.6.31
-- PHP Version: 5.6.20

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `tmiva_subwaycart`
--

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

--
-- Table structure for table `breads`
--

CREATE TABLE IF NOT EXISTS `breads` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store` int(11) NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL DEFAULT '',
  `catering` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `breads`
--

INSERT INTO `breads` (`id`, `store`, `name`, `catering`) VALUES
(1, 0, 'Hearty Itallian', 1),
(2, 0, 'Honey Oat', 1),
(3, 0, 'Italian (white)', 1),
(4, 0, 'Italian Herb and Cheese', 1);

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

--
-- Table structure for table `cheeses`
--

CREATE TABLE IF NOT EXISTS `cheeses` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL DEFAULT '',
  `catering` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `cheeses`
--

INSERT INTO `cheeses` (`id`, `store`, `name`, `catering`) VALUES
(1, 0, 'Monterey Chedder', 1),
(2, 0, 'Pepper Jack', 1),
(3, 0, 'Provolone', 1),
(4, 0, 'White American', 1);

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

--
-- Table structure for table `cities`
--

CREATE TABLE IF NOT EXISTS `cities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `state` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `city` (`state`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `state`, `name`) VALUES
(1, 1, 'Arlington'),
(3, 1, 'Fairfax'),
(4, 1, 'Falls Church'),
(5, 1, 'Richmond'),
(6, 2, 'Baltimore'),
(7, 2, 'Bethesda'),
(8, 1, 'Harrisonburg'),
(9, 4, 'Delaware City'),
(10, 3, '');

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

--
-- Table structure for table `entreePrices`
--

CREATE TABLE IF NOT EXISTS `entreePrices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `store` int(11) NOT NULL DEFAULT '0',
  `price` float NOT NULL DEFAULT '0',
  `entree` int(10) unsigned NOT NULL DEFAULT '0',
  `type` enum('6 Inch','Footlong','Wrap','Salad') NOT NULL DEFAULT '6 Inch',
  PRIMARY KEY (`id`),
  KEY `store` (`store`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `entrees`
--

CREATE TABLE IF NOT EXISTS `entrees` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `entrees`
--

INSERT INTO `entrees` (`id`, `name`) VALUES
(1, 'Six Inch Sub'),
(2, 'Footlong Sub'),
(3, 'Wrap'),
(4, 'Salad'),
(5, 'Flatbread');

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

--
-- Table structure for table `entreeTypes`
--

CREATE TABLE IF NOT EXISTS `entreeTypes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store` int(11) NOT NULL DEFAULT '0',
  `name` varchar(250) NOT NULL DEFAULT '',
  `catering` tinyint(1) NOT NULL DEFAULT '1',
  `category` enum('Fresh Fit','Fresh Toasted','Local Favorites','Premium') NOT NULL DEFAULT 'Fresh Fit',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `entreeTypes`
--

INSERT INTO `entreeTypes` (`id`, `store`, `name`, `catering`, `category`) VALUES
(1, 0, 'Ham', 1, 'Fresh Fit');

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

--
-- Table structure for table `extraPrices`
--

CREATE TABLE IF NOT EXISTS `extraPrices` (
  `extra` int(10) unsigned NOT NULL DEFAULT '0',
  `entree` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `price` float NOT NULL DEFAULT '0',
  KEY `extra` (`extra`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `extras`
--

CREATE TABLE IF NOT EXISTS `extras` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL DEFAULT '',
  `price` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `store` (`store`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `extras`
--

INSERT INTO `extras` (`id`, `store`, `name`, `price`) VALUES
(1, 0, 'Double Meet', 0),
(2, 0, 'Extra Cheese', 0),
(3, 0, 'Bacon', 0);

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

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

CREATE TABLE IF NOT EXISTS `orders` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store` int(10) unsigned NOT NULL DEFAULT '0',
  `date` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `store` (`store`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `purchases`
--

CREATE TABLE IF NOT EXISTS `purchases` (
  `id` int(10) unsigned NOT NULL DEFAULT '0',
  `order` int(10) unsigned NOT NULL DEFAULT '0',
  `price` float NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `toppings` varchar(255) NOT NULL DEFAULT '',
  `sauces` varchar(255) NOT NULL DEFAULT '',
  `extras` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `order` (`order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `sauces`
--

CREATE TABLE IF NOT EXISTS `sauces` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL DEFAULT '',
  `catering` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Dumping data for table `sauces`
--

INSERT INTO `sauces` (`id`, `store`, `name`, `catering`) VALUES
(1, 0, 'Chipotle Southwest', 1),
(2, 0, 'Light Mayonaise', 1),
(3, 0, 'Mustard', 1),
(4, 0, 'BBQ Sauce', 1),
(5, 0, 'Buffalo Sauce', 1),
(6, 0, 'Honey Mustard', 1),
(7, 0, 'Mayonnaise', 1),
(8, 0, 'Oil', 1),
(9, 0, 'Ranch', 1),
(10, 0, 'Spicy Mustard', 1),
(11, 0, 'Vinegar', 1);

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

--
-- Table structure for table `states`
--

CREATE TABLE IF NOT EXISTS `states` (
  `id` tinyint(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `states`
--

INSERT INTO `states` (`id`, `name`) VALUES
(1, 'Virginia'),
(2, 'Maryland'),
(3, 'Washington DC'),
(4, 'Delaware');

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

--
-- Table structure for table `store`
--

CREATE TABLE IF NOT EXISTS `store` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `city` int(10) unsigned NOT NULL DEFAULT '0',
  `address` varchar(255) NOT NULL DEFAULT '',
  `phone` double NOT NULL DEFAULT '0',
  `faxPickup` double NOT NULL DEFAULT '0',
  `tax` float NOT NULL DEFAULT '0',
  `combo` float NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `city` (`city`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `store`
--

INSERT INTO `store` (`id`, `city`, `address`, `phone`, `faxPickup`, `tax`, `combo`) VALUES
(0, 0, '', 0, 0, 5, 2),
(2, 1, '1500 S. Joyce St', 0, 0, 0, 0),
(3, 1, '850 N. Stuart St', 0, 0, 0, 0),
(4, 5, '523 Aurthor Ave', 0, 0, 0, 0),
(5, 6, '823 2nd St NW', 0, 0, 0, 0),
(6, 6, '123 Blane Ave', 0, 0, 0, 0),
(7, 6, '432 Lincoln Way', 0, 0, 0, 0),
(8, 3, '1234 Fake Road', 0, 0, 0, 0),
(9, 4, '455 Sample Plaza', 0, 0, 0, 0),
(10, 8, '123 Fake St', 0, 0, 0, 0),
(11, 8, '123 Fake St', 0, 0, 0, 0),
(12, 7, '455 Sample Address Lane', 0, 0, 0, 0),
(13, 7, '455 Sample Address Lane', 0, 0, 0, 0),
(14, 10, '1234 Fake Road', 0, 0, 0, 0),
(15, 10, '455 Sample Plaza', 0, 0, 0, 0),
(16, 9, '1234 Fake Road', 0, 0, 0, 0);

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

--
-- Table structure for table `toppings`
--

CREATE TABLE IF NOT EXISTS `toppings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `store` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(200) NOT NULL DEFAULT '',
  `catering` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `toppings`
--

INSERT INTO `toppings` (`id`, `store`, `name`, `catering`) VALUES
(1, 0, 'Lettice', 1),
(2, 0, 'Pickle', 1),
(3, 0, 'Tomato', 1),
(4, 0, 'Banana Peppers', 1),
(5, 0, 'Cucumber', 1),
(6, 0, 'Hot Peppers', 1),
(7, 0, 'Olives', 1),
(8, 0, 'Onion', 1),
(9, 0, 'Pepper', 1);

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