· 6 years ago · Aug 19, 2019, 05:26 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Хост: localhost
6-- Время создания: Апр 14 2016 г., 08:38
7-- Версия сервера: 5.5.46-0ubuntu0.14.04.2
8-- Версия PHP: 5.5.9-1ubuntu4.14
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 utf8 */;
18
19--
20-- База данных: `vezu24`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Структура таблицы `container_types`
27--
28
29CREATE TABLE IF NOT EXISTS `container_types` (
30 `id` int(10) NOT NULL AUTO_INCREMENT,
31 `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
32 `created_at` timestamp NULL DEFAULT NULL,
33 `updated_at` timestamp NULL DEFAULT NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18 ;
36
37--
38-- Дамп данных таблицы `container_types`
39--
40
41INSERT INTO `container_types` (`id`, `name`, `created_at`, `updated_at`) VALUES
42(1, '20 DC', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
43(3, '20 OT', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
44(4, '20 FR', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
45(7, '20 Tank', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
46(8, '20 VC', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
47(10, '40 DC', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
48(11, '40 HC', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
49(12, ' 40 RE', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
50(15, '40 HC', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
51(16, ' 40 PL', '2016-02-21 21:00:00', '2016-02-21 21:00:00');
52
53-- --------------------------------------------------------
54
55--
56-- Структура таблицы `currency`
57--
58
59CREATE TABLE IF NOT EXISTS `currency` (
60 `id` int(10) NOT NULL AUTO_INCREMENT,
61 `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
62 PRIMARY KEY (`id`)
63) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=4 ;
64
65--
66-- Дамп данных таблицы `currency`
67--
68
69INSERT INTO `currency` (`id`, `name`) VALUES
70(1, '$'),
71(2, '€'),
72(3, 'руб.');
73
74-- --------------------------------------------------------
75
76--
77-- Структура таблицы `documents`
78--
79
80CREATE TABLE IF NOT EXISTS `documents` (
81 `id` int(11) NOT NULL AUTO_INCREMENT,
82 `user_id` int(11) NOT NULL,
83 `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
84 `full_path` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
85 `created_at` timestamp NULL DEFAULT NULL,
86 `updated_at` timestamp NULL DEFAULT NULL,
87 PRIMARY KEY (`id`)
88) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=149 ;
89
90-- --------------------------------------------------------
91
92--
93-- Структура таблицы `feedback`
94--
95
96CREATE TABLE IF NOT EXISTS `feedback` (
97 `id` int(11) NOT NULL AUTO_INCREMENT,
98 `user_id` int(11) DEFAULT NULL,
99 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
100 `message` text COLLATE utf8_unicode_ci NOT NULL,
101 `is_read` tinyint(1) NOT NULL DEFAULT '0',
102 `created_at` timestamp NULL DEFAULT NULL,
103 `updated_at` timestamp NULL DEFAULT NULL,
104 PRIMARY KEY (`id`)
105) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=23 ;
106
107-- --------------------------------------------------------
108
109--
110-- Структура таблицы `information_users`
111--
112
113CREATE TABLE IF NOT EXISTS `information_users` (
114 `id` int(11) NOT NULL AUTO_INCREMENT,
115 `user_id` int(11) NOT NULL,
116 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
117 `surname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
118 `email` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
119 `phone` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
120 `organization` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
121 `license_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
122 `license_term` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
123 `region_activity` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
124 `max_cost_execution` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
125 `max_time_execution` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
126 `cost_inspection` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
127 `more_information` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
128 `rating` float NOT NULL DEFAULT '5',
129 `created_at` timestamp NULL DEFAULT NULL,
130 `updated_at` timestamp NULL DEFAULT NULL,
131 PRIMARY KEY (`id`)
132) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=50 ;
133
134--
135-- Дамп данных таблицы `information_users`
136--
137
138INSERT INTO `information_users` (`id`, `user_id`, `name`, `surname`, `email`, `phone`, `organization`, `license_number`, `license_term`, `region_activity`, `max_cost_execution`, `max_time_execution`, `cost_inspection`, `more_information`, `rating`, `created_at`, `updated_at`) VALUES
139(19, 36, 'Администратор', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 5, NULL, NULL);
140
141-- --------------------------------------------------------
142
143--
144-- Структура таблицы `measurements_volume`
145--
146
147CREATE TABLE IF NOT EXISTS `measurements_volume` (
148 `id` int(11) NOT NULL AUTO_INCREMENT,
149 `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
150 `created_at` timestamp NULL DEFAULT NULL,
151 `updated_at` timestamp NULL DEFAULT NULL,
152 PRIMARY KEY (`id`)
153) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
154
155--
156-- Дамп данных таблицы `measurements_volume`
157--
158
159INSERT INTO `measurements_volume` (`id`, `name`, `created_at`, `updated_at`) VALUES
160(1, 'м', '2016-02-21 21:00:00', '2016-02-21 21:00:00'),
161(2, 'см', '2016-02-21 21:00:00', '2016-02-21 21:00:00');
162
163-- --------------------------------------------------------
164
165--
166-- Структура таблицы `measurements_weight`
167--
168
169CREATE TABLE IF NOT EXISTS `measurements_weight` (
170 `id` int(10) NOT NULL AUTO_INCREMENT,
171 `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
172 `created_at` timestamp NULL DEFAULT NULL,
173 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
174 PRIMARY KEY (`id`)
175) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
176
177--
178-- Дамп данных таблицы `measurements_weight`
179--
180
181INSERT INTO `measurements_weight` (`id`, `name`, `created_at`, `updated_at`) VALUES
182(1, 'кг', '2016-02-21 21:00:00', '2016-02-22 09:25:43'),
183(2, 'т', '2016-02-21 21:00:00', '2016-02-22 09:25:43');
184
185-- --------------------------------------------------------
186
187--
188-- Структура таблицы `messages`
189--
190
191CREATE TABLE IF NOT EXISTS `messages` (
192 `id` int(11) NOT NULL AUTO_INCREMENT,
193 `id_user_from` int(11) NOT NULL,
194 `id_user_to` int(11) NOT NULL,
195 `message` varchar(1024) COLLATE utf8_unicode_ci NOT NULL,
196 `created_at` timestamp NULL DEFAULT NULL,
197 `updated_at` timestamp NULL DEFAULT NULL,
198 PRIMARY KEY (`id`)
199) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=183 ;
200
201-- --------------------------------------------------------
202
203--
204-- Структура таблицы `migrations`
205--
206
207CREATE TABLE IF NOT EXISTS `migrations` (
208 `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
209 `batch` int(11) NOT NULL
210) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
211
212--
213-- Дамп данных таблицы `migrations`
214--
215
216INSERT INTO `migrations` (`migration`, `batch`) VALUES
217('2014_10_12_000000_create_users_table', 1),
218('2014_10_12_100000_create_password_resets_table', 1);
219
220-- --------------------------------------------------------
221
222--
223-- Структура таблицы `notifications`
224--
225
226CREATE TABLE IF NOT EXISTS `notifications` (
227 `id` int(11) NOT NULL AUTO_INCREMENT,
228 `user_id` int(11) NOT NULL,
229 `is_read` tinyint(1) NOT NULL DEFAULT '0',
230 `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
231 `notification` text COLLATE utf8_unicode_ci NOT NULL,
232 `created_at` timestamp NULL DEFAULT NULL,
233 `updated_at` timestamp NULL DEFAULT NULL,
234 PRIMARY KEY (`id`)
235) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=490 ;
236
237-- --------------------------------------------------------
238
239--
240-- Структура таблицы `responses_to_feedback`
241--
242
243CREATE TABLE IF NOT EXISTS `responses_to_feedback` (
244 `id` int(10) NOT NULL AUTO_INCREMENT,
245 `feedback_id` int(10) NOT NULL,
246 `answer` text COLLATE utf8_unicode_ci NOT NULL,
247 `created_at` timestamp NULL DEFAULT NULL,
248 `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
249 PRIMARY KEY (`id`)
250) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=25 ;
251
252-- --------------------------------------------------------
253
254--
255-- Структура таблицы `responses_to_transportation`
256--
257
258CREATE TABLE IF NOT EXISTS `responses_to_transportation` (
259 `id` int(11) NOT NULL AUTO_INCREMENT,
260 `user_id` int(10) NOT NULL,
261 `transportation_id` int(10) NOT NULL,
262 `status_id` int(10) NOT NULL,
263 `cost` int(10) NOT NULL,
264 `currency_id` int(11) NOT NULL,
265 `valid_until` timestamp NULL DEFAULT NULL COMMENT 'действительно до',
266 `is_blocked` int(10) NOT NULL DEFAULT '0',
267 `created_at` timestamp NULL DEFAULT NULL,
268 `updated_at` timestamp NULL DEFAULT NULL,
269 PRIMARY KEY (`id`)
270) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=88 ;
271
272-- --------------------------------------------------------
273
274--
275-- Структура таблицы `roles`
276--
277
278CREATE TABLE IF NOT EXISTS `roles` (
279 `id` int(11) NOT NULL AUTO_INCREMENT,
280 `name` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
281 `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
282 `created_at` timestamp NULL DEFAULT NULL,
283 `updated_at` timestamp NULL DEFAULT NULL,
284 PRIMARY KEY (`id`)
285) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=5 ;
286
287--
288-- Дамп данных таблицы `roles`
289--
290
291INSERT INTO `roles` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
292(1, 'transporter', 'Перевозчик', '2016-02-15 21:00:00', '2016-02-15 21:00:00'),
293(2, 'broker', 'Брокер', '2016-02-15 21:00:00', '2016-02-15 21:00:00'),
294(3, 'administrator', 'Администратор', '2016-02-15 21:00:00', '2016-02-15 21:00:00'),
295(4, 'client', 'Заказчик', '2016-02-15 21:00:00', '2016-02-15 21:00:00');
296
297-- --------------------------------------------------------
298
299--
300-- Структура таблицы `transportations`
301--
302
303CREATE TABLE IF NOT EXISTS `transportations` (
304 `id` int(11) NOT NULL AUTO_INCREMENT,
305 `user_id` int(11) NOT NULL,
306 `status_id` int(11) NOT NULL,
307 `is_paid` tinyint(1) NOT NULL DEFAULT '0',
308 `payment_details` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
309 `is_active` tinyint(1) NOT NULL DEFAULT '1',
310 `description_query` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
311 `need_broker` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'нужен ли брокер',
312 `need_insurance` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'страхование',
313 `need_container` tinyint(1) DEFAULT NULL,
314 `container_type_id` int(10) NOT NULL,
315 `length` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
316 `width` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
317 `height` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
318 `cargo_weight` varchar(60) COLLATE utf8_unicode_ci NOT NULL COMMENT 'вес груза',
319 `measurements_weight_id` int(10) NOT NULL,
320 `volume_cargo` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
321 `measurements_volume_id` int(10) NOT NULL,
322 `date_availability` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'дата поступления',
323 `date_delivery` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'дата поставки',
324 `is_soon` tinyint(1) DEFAULT NULL,
325 `number_seats` int(10) NOT NULL COMMENT 'количество мест',
326 `methods_of_transportation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
327 `country_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
328 `city_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
329 `port_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
330 `intermediate_port_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
331 `country_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
332 `city_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
333 `port_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
334 `intermediate_port_to` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
335 `created_at` timestamp NULL DEFAULT NULL,
336 `updated_at` timestamp NULL DEFAULT NULL,
337 `ended_at` timestamp NULL DEFAULT NULL,
338 PRIMARY KEY (`id`)
339) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=10337 ;
340
341-- --------------------------------------------------------
342
343--
344-- Структура таблицы `users`
345--
346
347CREATE TABLE IF NOT EXISTS `users` (
348 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
349 `role_id` int(11) NOT NULL,
350 `login` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
351 `is_active` tinyint(1) NOT NULL DEFAULT '0',
352 `is_banned` tinyint(1) NOT NULL DEFAULT '0',
353 `is_paid` tinyint(1) NOT NULL DEFAULT '0',
354 `password` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
355 `remember_token` varchar(500) COLLATE utf8_unicode_ci DEFAULT NULL,
356 `created_at` timestamp NULL DEFAULT NULL,
357 `updated_at` timestamp NULL DEFAULT NULL,
358 PRIMARY KEY (`id`)
359) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1227 ;
360
361--
362-- Дамп данных таблицы `users`
363--
364
365INSERT INTO `users` (`id`, `role_id`, `login`, `is_active`, `is_banned`, `is_paid`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
366(36, 3, 'vezu_admin', 0, 0, 0, '$2y$10$qY7eMivXFP2sEyaiBL43YeQC.DXVoELajKH5gWg/yfCo/81Wxk2La', 'BaB0vzov77zeyuaoAg9lkFZTcYOCWh8WZozylw1h4rtPP2tA7EuF7qPEmttC', NULL, '2016-04-13 21:37:23');
367
368/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
369/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
370/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;