· 9 years ago · Oct 21, 2016, 06:00 PM
1-- phpMyAdmin SQL Dump
2-- version 4.4.14.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 13, 2016 at 10:06 PM
7-- Server version: 5.6.26
8-- PHP Version: 5.6.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `jimsjoint`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `Categories`
27--
28
29CREATE TABLE IF NOT EXISTS `Categories` (
30 `id` varchar(1) NOT NULL,
31 `name` varchar(64) NOT NULL,
32 `description` text NOT NULL,
33 `images` varchar(100) NOT NULL
34) ENGINE=InnoDB DEFAULT CHARSET=latin1;
35
36--
37-- Dumping data for table `Categories`
38--
39
40INSERT INTO `Categories` (`id`, `name`, `description`, `images`) VALUES
41('d', 'Drinks', 'Purees made from the finest of Venusian insects, government-inspected.', ''),
42('m', 'Mains', 'Made from only the finest ingredients found deep in the Martian jungle, and harvested or slaughtered by academy-trained druids, we bring you 45 day aged premium "meat".', ''),
43('s', 'Sides', 'Perfect accompaniments to our mains, these side dish pairings have been exclsisvely formulated by Ben & Jerry.', '');
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `Menu`
49--
50
51CREATE TABLE IF NOT EXISTS `Menu` (
52 `id` int(11) NOT NULL,
53 `name` varchar(32) NOT NULL,
54 `description` varchar(256) NOT NULL,
55 `price` decimal(10,2) NOT NULL,
56 `picture` varchar(100) NOT NULL,
57 `category` varchar(1) NOT NULL
58) ENGINE=MyISAM DEFAULT CHARSET=utf8;
59
60--
61-- Dumping data for table `Menu`
62--
63
64INSERT INTO `Menu` (`id`, `name`, `description`, `price`, `picture`, `category`) VALUES
65(1, 'Cheese', 'Leave this raw milk, beefy and sweet cheese out for an hour before serving and pair with pear jam.', '2.95', '1.png', 's'),
66(2, 'Turkey', 'Roasted, succulent, stuffed, lovingly sliced turkey breast', '5.95', '2.png', 'm'),
67(6, 'Donut', 'Disgustingly sweet, topped with artery clogging chocolate and then sprinkled with Pixie dust', '1.25', '6.png', 's'),
68(10, 'Bubbly', '1964 Moet Charmon, made from grapes crushed by elves with clean feet, perfectly chilled.', '14.50', '10.png', 'd'),
69(11, 'Ice Cream', 'Combination of decadent chocolate topped with luscious strawberry, churned by gifted virgins using only cream from the Tajima strain of wagyu cattle', '3.75', '11.png', 's'),
70(8, 'Hot Dog', 'Pork trimmings mixed with powdered preservatives, flavourings, red colouring and drenched in water before being squeezed into plastic tubes. Topped with onions, bacon, chili or cheese - no extra charge.', '6.90', '8.png', 'm'),
71(25, 'Burger', 'Half-pound of beef, topped with bacon and served with your choice of a slice of American cheese, red onion, sliced tomato, and Heart Attack Grill''s own unique special sauce.', '9.99', 'burger.png', 'm'),
72(21, 'Coffee', 'A delicious cup of the nectar of life, saviour of students, morning kick-starter; made with freshly grounds that you don''t want to know where they came from!', '2.95', 'coffee.png', 'd');
73
74-- --------------------------------------------------------
75
76--
77-- Table structure for table `orderitems`
78--
79
80CREATE TABLE IF NOT EXISTS `orderitems` (
81 `order` int(11) NOT NULL,
82 `item` int(11) NOT NULL,
83 `quantity` int(11) NOT NULL,
84 `special` text NOT NULL
85) ENGINE=MyISAM DEFAULT CHARSET=utf8;
86
87-- --------------------------------------------------------
88
89--
90-- Table structure for table `orders`
91--
92
93CREATE TABLE IF NOT EXISTS `orders` (
94 `num` int(11) NOT NULL,
95 `date` datetime NOT NULL,
96 `status` varchar(1) NOT NULL,
97 `total` decimal(10,2) NOT NULL,
98 `customer` varchar(64) NOT NULL
99) ENGINE=MyISAM DEFAULT CHARSET=utf8;
100
101--
102-- Indexes for dumped tables
103--
104
105--
106-- Indexes for table `Categories`
107--
108ALTER TABLE `Categories`
109 ADD PRIMARY KEY (`id`);
110
111--
112-- Indexes for table `Menu`
113--
114ALTER TABLE `Menu`
115 ADD PRIMARY KEY (`id`);
116
117--
118-- Indexes for table `orderitems`
119--
120ALTER TABLE `orderitems`
121 ADD PRIMARY KEY (`order`,`item`);
122
123--
124-- Indexes for table `orders`
125--
126ALTER TABLE `orders`
127 ADD PRIMARY KEY (`num`);
128
129/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
130/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
131/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;