· 9 years ago · Oct 28, 2016, 12:10 AM
1-- phpMyAdmin SQL Dump
2-- version 4.4.15.5
3-- http://www.phpmyadmin.net
4--
5-- ХоÑÑ‚: 127.0.0.1:3306
6-- Ð’Ñ€ÐµÐ¼Ñ ÑозданиÑ: Окт 28 2016 г., 03:07
7-- ВерÑÐ¸Ñ Ñервера: 5.5.48
8-- ВерÑÐ¸Ñ PHP: 5.4.45
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-- База данных: `lunchscan`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `categories`
27--
28
29CREATE TABLE IF NOT EXISTS `categories` (
30 `id` int(11) unsigned NOT NULL,
31 `name` varchar(50) NOT NULL,
32 `lunch_offer_id` int(11) unsigned NOT NULL
33) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
34
35--
36-- Дамп данных таблицы `categories`
37--
38
39INSERT INTO `categories` (`id`, `name`, `lunch_offer_id`) VALUES
40(1, 'sup', 1),
41(2, 'kasha', 1);
42
43-- --------------------------------------------------------
44
45--
46-- Структура таблицы `dishes`
47--
48
49CREATE TABLE IF NOT EXISTS `dishes` (
50 `id` int(10) unsigned NOT NULL,
51 `category_id` int(11) unsigned NOT NULL,
52 `name` varchar(50) NOT NULL,
53 `description` varchar(255) NOT NULL,
54 `weight` smallint(4) unsigned NOT NULL,
55 `price` float unsigned DEFAULT NULL
56) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;
57
58--
59-- Дамп данных таблицы `dishes`
60--
61
62INSERT INTO `dishes` (`id`, `category_id`, `name`, `description`, `weight`, `price`) VALUES
63(1, 1, 'Борщ', 'Борщ зеленый', 230, 18.5),
64(2, 1, 'Суп з фрікадельками', 'Суп з фрікадельками', 200, 23),
65(4, 2, 'Каша гречана', 'Каша гречана з шкварками', 150, 8);
66
67-- --------------------------------------------------------
68
69--
70-- Структура таблицы `dish_tags`
71--
72
73CREATE TABLE IF NOT EXISTS `dish_tags` (
74 `id` int(11) unsigned NOT NULL,
75 `tag` varchar(20) NOT NULL
76) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
77
78--
79-- Дамп данных таблицы `dish_tags`
80--
81
82INSERT INTO `dish_tags` (`id`, `tag`) VALUES
83(1, 'креветки');
84
85-- --------------------------------------------------------
86
87--
88-- Структура таблицы `food_places`
89--
90
91CREATE TABLE IF NOT EXISTS `food_places` (
92 `id` int(11) unsigned NOT NULL,
93 `name` varchar(50) NOT NULL,
94 `coordinates` point NOT NULL
95) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
96
97--
98-- Дамп данных таблицы `food_places`
99--
100
101INSERT INTO `food_places` (`id`, `name`, `coordinates`) VALUES
102(1, 'У ВаÑилÑ', '\0\0\0\0\0\0\0????@?gC? 8@'),
103(2, 'У Вадіка', '\0\0\0\0\0\0\0?A???@???? 8@');
104
105-- --------------------------------------------------------
106
107--
108-- Структура таблицы `images`
109--
110
111CREATE TABLE IF NOT EXISTS `images` (
112 `id` int(11) unsigned NOT NULL,
113 `owner_id` int(11) unsigned NOT NULL,
114 `image` varchar(255) NOT NULL
115) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
116
117--
118-- Дамп данных таблицы `images`
119--
120
121INSERT INTO `images` (`id`, `owner_id`, `image`) VALUES
122(1, 1, 'adhgvhgv.jpg');
123
124-- --------------------------------------------------------
125
126--
127-- Структура таблицы `lunch_offers`
128--
129
130CREATE TABLE IF NOT EXISTS `lunch_offers` (
131 `id` int(11) unsigned NOT NULL,
132 `name` varchar(50) NOT NULL,
133 `image_id` int(11) unsigned NOT NULL,
134 `food_place_id` int(11) unsigned NOT NULL,
135 `price` float NOT NULL
136) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
137
138--
139-- Дамп данных таблицы `lunch_offers`
140--
141
142INSERT INTO `lunch_offers` (`id`, `name`, `image_id`, `food_place_id`, `price`) VALUES
143(1, 'Ð‘Ð¸Ð·Ð½ÐµÑ Ð»Ð°Ð½Ñ‡ 1', 1, 2, 100);
144
145--
146-- ИндекÑÑ‹ Ñохранённых таблиц
147--
148
149--
150-- ИндекÑÑ‹ таблицы `categories`
151--
152ALTER TABLE `categories`
153 ADD PRIMARY KEY (`id`);
154
155--
156-- ИндекÑÑ‹ таблицы `dishes`
157--
158ALTER TABLE `dishes`
159 ADD PRIMARY KEY (`id`);
160
161--
162-- ИндекÑÑ‹ таблицы `dish_tags`
163--
164ALTER TABLE `dish_tags`
165 ADD PRIMARY KEY (`id`);
166
167--
168-- ИндекÑÑ‹ таблицы `food_places`
169--
170ALTER TABLE `food_places`
171 ADD PRIMARY KEY (`id`),
172 ADD SPATIAL KEY `coordinates` (`coordinates`);
173
174--
175-- ИндекÑÑ‹ таблицы `images`
176--
177ALTER TABLE `images`
178 ADD PRIMARY KEY (`id`);
179
180--
181-- ИндекÑÑ‹ таблицы `lunch_offers`
182--
183ALTER TABLE `lunch_offers`
184 ADD PRIMARY KEY (`id`);
185
186--
187-- AUTO_INCREMENT Ð´Ð»Ñ Ñохранённых таблиц
188--
189
190--
191-- AUTO_INCREMENT Ð´Ð»Ñ Ñ‚Ð°Ð±Ð»Ð¸Ñ†Ñ‹ `categories`
192--
193ALTER TABLE `categories`
194 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
195--
196-- AUTO_INCREMENT Ð´Ð»Ñ Ñ‚Ð°Ð±Ð»Ð¸Ñ†Ñ‹ `dishes`
197--
198ALTER TABLE `dishes`
199 MODIFY `id` int(10) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
200--
201-- AUTO_INCREMENT Ð´Ð»Ñ Ñ‚Ð°Ð±Ð»Ð¸Ñ†Ñ‹ `dish_tags`
202--
203ALTER TABLE `dish_tags`
204 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
205--
206-- AUTO_INCREMENT Ð´Ð»Ñ Ñ‚Ð°Ð±Ð»Ð¸Ñ†Ñ‹ `food_places`
207--
208ALTER TABLE `food_places`
209 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
210--
211-- AUTO_INCREMENT Ð´Ð»Ñ Ñ‚Ð°Ð±Ð»Ð¸Ñ†Ñ‹ `images`
212--
213ALTER TABLE `images`
214 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
215--
216-- AUTO_INCREMENT Ð´Ð»Ñ Ñ‚Ð°Ð±Ð»Ð¸Ñ†Ñ‹ `lunch_offers`
217--
218ALTER TABLE `lunch_offers`
219 MODIFY `id` int(11) unsigned NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
220/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
221/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
222/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;