· 6 years ago · May 02, 2019, 11:10 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- ХоÑÑ‚: localhost
6-- Ð’Ñ€ÐµÐ¼Ñ ÑозданиÑ: Май 03 2019 г., 02:05
7-- ВерÑÐ¸Ñ Ñервера: 5.6.39-83.1
8-- ВерÑÐ¸Ñ PHP: 5.6.40
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--
21-- Структура таблицы `category`
22--
23
24CREATE TABLE IF NOT EXISTS `category` (
25 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
26 `name` varchar(200) DEFAULT NULL,
27 `code_name` varchar(200) NOT NULL,
28 PRIMARY KEY (`id`)
29) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
30
31--
32-- Дамп данных таблицы `category`
33--
34
35INSERT INTO `category` (`id`, `name`, `code_name`) VALUES
36(2, ' Программы Ñ€Ð°Ð·Ð²Ð¸Ñ‚Ð¸Ñ Ð¸ Ñтажировок ', ''),
37(3, 'КейÑ-турниры', ''),
38(4, 'Ярмарки ваканÑий и дни карьеры', ''),
39(5, 'ранты, конкурÑÑ‹, Ñтипендиальные программы, олимпиады', '');
40
41-- --------------------------------------------------------
42
43--
44-- Структура таблицы `city`
45--
46
47CREATE TABLE IF NOT EXISTS `city` (
48 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
49 `name` varchar(200) DEFAULT NULL,
50 PRIMARY KEY (`id`)
51) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
52
53--
54-- Дамп данных таблицы `city`
55--
56
57INSERT INTO `city` (`id`, `name`) VALUES
58(1, 'МоÑква'),
59(2, 'ÐовоÑибирÑк'),
60(3, 'Барнаул'),
61(4, 'Санкт-Петербург'),
62(5, 'ОмÑк'),
63(6, 'ТомÑк');
64
65-- --------------------------------------------------------
66
67--
68-- Структура таблицы `company`
69--
70
71CREATE TABLE IF NOT EXISTS `company` (
72 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
73 `name` varchar(200) DEFAULT NULL,
74 `logo` varchar(20) DEFAULT NULL,
75 PRIMARY KEY (`id`)
76) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
77
78--
79-- Дамп данных таблицы `company`
80--
81
82INSERT INTO `company` (`id`, `name`, `logo`) VALUES
83(1, 'pwc', '7c209-company_1.png'),
84(2, 'McKinsey', 'e7d56-company_2.png'),
85(3, 'BCG', '200ed-company_3.png'),
86(4, 'yandex', '1eb94-company_4.png'),
87(5, 'СеверÑталь', 'be741-company_5.png'),
88(6, 'Docker', 'ef7e7-bpb9x.jpeg');
89
90-- --------------------------------------------------------
91
92--
93-- Структура таблицы `events`
94--
95
96CREATE TABLE IF NOT EXISTS `events` (
97 `id` int(11) NOT NULL AUTO_INCREMENT,
98 `category_id` int(11) UNSIGNED NOT NULL COMMENT 'КатегориÑ',
99 `name` text NOT NULL COMMENT 'Ðаименование',
100 `company_id` int(11) UNSIGNED NOT NULL COMMENT 'КомпаниÑ',
101 `city_id` int(11) UNSIGNED NOT NULL COMMENT 'Город',
102 `industry_id` varchar(25) NOT NULL,
103 `request_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заÑвок c',
104 `request_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заÑвок до',
105 `event_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е Ñ',
106 `event_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е до',
107 `sphere_id` varchar(25) NOT NULL COMMENT 'Ñфера',
108 `additional` text NOT NULL COMMENT 'Дополнительное поле',
109 `contacts` varchar(255) NOT NULL COMMENT 'Контакты',
110 PRIMARY KEY (`id`),
111 UNIQUE KEY `id` (`id`),
112 KEY `category_id` (`category_id`),
113 KEY `company_id` (`company_id`),
114 KEY `city_id` (`city_id`)
115) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
116
117--
118-- Дамп данных таблицы `events`
119--
120
121INSERT INTO `events` (`id`, `category_id`, `name`, `company_id`, `city_id`, `industry_id`, `request_start`, `request_end`, `event_start`, `event_end`, `sphere_id`, `additional`, `contacts`) VALUES
122(5, 2, '<p>\n sdf</p>\n', 2, 2, '3,4', '2019-04-17 00:00:00', '2019-04-24 00:00:00', '2019-04-04 00:00:00', '2019-04-11 00:00:00', '2', '<p>\n sdf</p>\n', ''),
123(6, 3, '<p>\n Ðазвание</p>\n', 4, 2, '13', '2019-04-24 00:00:00', '2019-04-28 00:00:00', '2019-04-25 00:00:00', '2019-04-30 00:00:00', '1,2', '', 'test@yandex.ru'),
124(7, 3, '<p>\n sdfadfdsfsdfsdf</p>\n', 5, 2, '3', '2019-04-20 00:00:00', '2019-04-21 00:00:00', '2019-04-17 00:00:00', '2019-04-28 00:00:00', '2,3', '', ''),
125(8, 2, '<p>\n asdasd</p>\n', 1, 2, '3,4', '2019-04-02 00:00:00', '2019-04-27 00:00:00', '2019-04-12 00:00:00', '2019-04-26 00:00:00', '2', '', ''),
126(9, 2, '<p>\n sdfdfsdfsdf</p>\n', 3, 1, '2', '2019-04-10 00:00:00', '2019-04-12 00:00:00', '2019-04-19 00:00:00', '2019-04-18 00:00:00', '1', '', '');
127
128-- --------------------------------------------------------
129
130--
131-- Структура таблицы `groups`
132--
133
134CREATE TABLE IF NOT EXISTS `groups` (
135 `id` mediumint(8) UNSIGNED NOT NULL AUTO_INCREMENT,
136 `name` varchar(20) NOT NULL,
137 `description` varchar(100) NOT NULL,
138 PRIMARY KEY (`id`)
139) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
140
141--
142-- Дамп данных таблицы `groups`
143--
144
145INSERT INTO `groups` (`id`, `name`, `description`) VALUES
146(1, 'admin', 'Administrator'),
147(2, 'members', 'User');
148
149-- --------------------------------------------------------
150
151--
152-- Структура таблицы `industry`
153--
154
155CREATE TABLE IF NOT EXISTS `industry` (
156 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
157 `name` varchar(200) DEFAULT NULL,
158 `code_name` varchar(200) NOT NULL,
159 PRIMARY KEY (`id`)
160) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
161
162--
163-- Дамп данных таблицы `industry`
164--
165
166INSERT INTO `industry` (`id`, `name`, `code_name`) VALUES
167(6, 'IT, Digital', ''),
168(7, 'Банки, кредиты', ''),
169(8, 'ИнвеÑтиции', ''),
170(9, 'ИÑкуÑÑтво, культура', ''),
171(10, 'Кино, ТВ', ''),
172(11, 'КонÑалтинг', ''),
173(12, 'Маркетинг, реклама, PR', ''),
174(13, 'Медицина, здравоохранение, фармацевтика', ''),
175(14, 'Музыка', ''),
176(15, 'Ðаука', ''),
177(16, 'Образование', ''),
178(17, 'ÐекоммерчеÑкие организации', ''),
179(18, 'Продажи', ''),
180(19, 'ПроизводÑтво', ''),
181(20, 'РазвлечениÑ', ''),
182(21, 'СМИ, журналиÑтика', ''),
183(22, 'Спорт, краÑота', ''),
184(24, 'Страхование', ''),
185(25, 'СтроительÑтво, архитектура', ''),
186(26, 'ÐедвижимоÑÑ‚ÑŒ', ''),
187(27, 'ЖКХ, коммунальные уÑлуги', ''),
188(28, 'ЛогиÑтика', ''),
189(29, 'Туризм, отели, гоÑтиницы', ''),
190(30, 'РеÑтораны, кафе', ''),
191(31, 'HR, управление перÑоналом', ''),
192(32, 'ФинанÑÑ‹, аудит', ''),
193(33, 'ЮриÑпруденциÑ, право', ''),
194(34, 'Животные, природа', ''),
195(35, 'ТранÑпорт, автомобили', ''),
196(36, 'FMCG', ''),
197(37, 'Дизайн', ''),
198(38, 'СельÑкое хозÑйÑтво', ''),
199(39, 'Мода, Ñ„Ñшн', ''),
200(40, 'Политика, гоÑударÑÑ‚Ð²ÐµÐ½Ð½Ð°Ñ Ñлужба', ''),
201(41, 'Сырье, нефтегаз', ''),
202(42, 'Телеком, ÑвÑзь', ''),
203(43, 'Другое', '');
204
205-- --------------------------------------------------------
206
207--
208-- Структура таблицы `login_attempts`
209--
210
211CREATE TABLE IF NOT EXISTS `login_attempts` (
212 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
213 `ip_address` varchar(45) NOT NULL,
214 `login` varchar(100) NOT NULL,
215 `time` int(11) UNSIGNED DEFAULT NULL,
216 PRIMARY KEY (`id`)
217) ENGINE=InnoDB DEFAULT CHARSET=utf8;
218
219-- --------------------------------------------------------
220
221--
222-- Структура таблицы `sphere`
223--
224
225CREATE TABLE IF NOT EXISTS `sphere` (
226 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
227 `name` varchar(200) DEFAULT NULL,
228 `code_name` varchar(200) NOT NULL,
229 PRIMARY KEY (`id`)
230) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
231
232--
233-- Дамп данных таблицы `sphere`
234--
235
236INSERT INTO `sphere` (`id`, `name`, `code_name`) VALUES
237(1, 'Ффера 1', ''),
238(2, 'Сфера 2', ''),
239(3, 'Сфера 3', ''),
240(4, 'Менеджмент', ''),
241(5, 'Продажи', ''),
242(6, 'Развитие бизнеÑа', ''),
243(7, 'Разработка', ''),
244(8, 'Дизайн', ''),
245(9, 'Маркетинг', ''),
246(10, 'Ðналитика', ''),
247(11, 'ЮриÑпруденциÑ', ''),
248(12, 'ÐдминиÑÑ‚Ñ€Ð°Ñ‚Ð¸Ð²Ð½Ð°Ñ Ñ€Ð°Ð±Ð¾Ñ‚Ð°', ''),
249(13, 'Продуктовый менеджмент', ''),
250(14, 'Менеджмент проектов', ''),
251(15, 'ФинанÑÑ‹, аудит', ''),
252(16, 'Работа Ñ Ð¿ÐµÑ€Ñоналом', ''),
253(17, 'СервиÑное обÑлуживание', ''),
254(18, 'ИнженериÑ', ''),
255(19, 'Другое', '');
256
257-- --------------------------------------------------------
258
259--
260-- Структура таблицы `users`
261--
262
263CREATE TABLE IF NOT EXISTS `users` (
264 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
265 `ip_address` varchar(45) NOT NULL,
266 `username` varchar(100) DEFAULT NULL,
267 `password` varchar(255) NOT NULL,
268 `email` varchar(254) NOT NULL,
269 `activation_selector` varchar(255) DEFAULT NULL,
270 `activation_code` varchar(255) DEFAULT NULL,
271 `forgotten_password_selector` varchar(255) DEFAULT NULL,
272 `forgotten_password_code` varchar(255) DEFAULT NULL,
273 `forgotten_password_time` int(11) UNSIGNED DEFAULT NULL,
274 `remember_selector` varchar(255) DEFAULT NULL,
275 `remember_code` varchar(255) DEFAULT NULL,
276 `created_on` int(11) UNSIGNED NOT NULL,
277 `last_login` int(11) UNSIGNED DEFAULT NULL,
278 `active` tinyint(1) UNSIGNED DEFAULT NULL,
279 `first_name` varchar(50) DEFAULT NULL,
280 `last_name` varchar(50) DEFAULT NULL,
281 `company` varchar(100) DEFAULT NULL,
282 `phone` varchar(20) DEFAULT NULL,
283 PRIMARY KEY (`id`),
284 UNIQUE KEY `uc_email` (`email`),
285 UNIQUE KEY `uc_activation_selector` (`activation_selector`),
286 UNIQUE KEY `uc_forgotten_password_selector` (`forgotten_password_selector`),
287 UNIQUE KEY `uc_remember_selector` (`remember_selector`)
288) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
289
290--
291-- Дамп данных таблицы `users`
292--
293
294INSERT INTO `users` (`id`, `ip_address`, `username`, `password`, `email`, `activation_selector`, `activation_code`, `forgotten_password_selector`, `forgotten_password_code`, `forgotten_password_time`, `remember_selector`, `remember_code`, `created_on`, `last_login`, `active`, `first_name`, `last_name`, `company`, `phone`) VALUES
295(1, '127.0.0.1', 'admin', '$2y$12$nm5g/ei6sgC2imdqgdoWauu0YMwBkvQCJ5o5dzv7PRJmEO/e42W9S', 'admin@admin.com', NULL, '', NULL, NULL, NULL, NULL, NULL, 1268889823, 1556831248, 1, 'admin', 'st', 'ADMIN', '0');
296
297-- --------------------------------------------------------
298
299--
300-- Структура таблицы `users_groups`
301--
302
303CREATE TABLE IF NOT EXISTS `users_groups` (
304 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
305 `user_id` int(11) UNSIGNED NOT NULL,
306 `group_id` mediumint(8) UNSIGNED NOT NULL,
307 PRIMARY KEY (`id`),
308 UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
309 KEY `fk_users_groups_users1_idx` (`user_id`),
310 KEY `fk_users_groups_groups1_idx` (`group_id`)
311) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
312
313--
314-- Дамп данных таблицы `users_groups`
315--
316
317INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
318(1, 1, 1),
319(2, 1, 2);
320
321-- --------------------------------------------------------
322
323--
324-- Структура таблицы `user_category_interest`
325--
326
327CREATE TABLE IF NOT EXISTS `user_category_interest` (
328 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
329 `user_id` int(11) UNSIGNED NOT NULL,
330 `category_id` int(11) UNSIGNED NOT NULL,
331 PRIMARY KEY (`id`),
332 KEY `user_id` (`user_id`),
333 KEY `category_id` (`category_id`)
334) ENGINE=MyISAM DEFAULT CHARSET=utf8;
335
336-- --------------------------------------------------------
337
338--
339-- Структура таблицы `user_city_interest`
340--
341
342CREATE TABLE IF NOT EXISTS `user_city_interest` (
343 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
344 `user_id` int(11) UNSIGNED NOT NULL,
345 `city_id` int(11) UNSIGNED NOT NULL,
346 PRIMARY KEY (`id`),
347 KEY `user_id` (`user_id`),
348 KEY `city_id` (`city_id`)
349) ENGINE=MyISAM DEFAULT CHARSET=utf8;
350
351-- --------------------------------------------------------
352
353--
354-- Структура таблицы `user_company_interest`
355--
356
357CREATE TABLE IF NOT EXISTS `user_company_interest` (
358 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
359 `user_id` int(11) UNSIGNED NOT NULL,
360 `company_id` int(11) UNSIGNED NOT NULL,
361 PRIMARY KEY (`id`),
362 KEY `user_id` (`user_id`),
363 KEY `company_id` (`company_id`)
364) ENGINE=MyISAM DEFAULT CHARSET=utf8;
365
366-- --------------------------------------------------------
367
368--
369-- Структура таблицы `user_industry_interest`
370--
371
372CREATE TABLE IF NOT EXISTS `user_industry_interest` (
373 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
374 `user_id` int(11) UNSIGNED NOT NULL,
375 `industry_id` int(11) UNSIGNED NOT NULL,
376 PRIMARY KEY (`id`),
377 KEY `user_id` (`user_id`),
378 KEY `industry_id` (`industry_id`)
379) ENGINE=MyISAM DEFAULT CHARSET=utf8;
380
381-- --------------------------------------------------------
382
383--
384-- Структура таблицы `user_sphere_interest`
385--
386
387CREATE TABLE IF NOT EXISTS `user_sphere_interest` (
388 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
389 `user_id` int(11) UNSIGNED NOT NULL,
390 `sphere_id` int(11) UNSIGNED NOT NULL,
391 PRIMARY KEY (`id`),
392 KEY `user_id` (`user_id`),
393 KEY `sphere_id` (`sphere_id`)
394) ENGINE=MyISAM DEFAULT CHARSET=utf8;
395
396--
397-- ÐžÐ³Ñ€Ð°Ð½Ð¸Ñ‡ÐµÐ½Ð¸Ñ Ð²Ð½ÐµÑˆÐ½ÐµÐ³Ð¾ ключа Ñохраненных таблиц
398--
399
400--
401-- ÐžÐ³Ñ€Ð°Ð½Ð¸Ñ‡ÐµÐ½Ð¸Ñ Ð²Ð½ÐµÑˆÐ½ÐµÐ³Ð¾ ключа таблицы `events`
402--
403ALTER TABLE `events`
404 ADD CONSTRAINT `events_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
405 ADD CONSTRAINT `events_ibfk_2` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
406 ADD CONSTRAINT `events_ibfk_3` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`);
407
408--
409-- ÐžÐ³Ñ€Ð°Ð½Ð¸Ñ‡ÐµÐ½Ð¸Ñ Ð²Ð½ÐµÑˆÐ½ÐµÐ³Ð¾ ключа таблицы `users_groups`
410--
411ALTER TABLE `users_groups`
412 ADD CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
413 ADD CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
414
415/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
416/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
417/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;