· 6 years ago · May 02, 2019, 10:38 PM
1-- phpMyAdmin SQL Dump
2-- version 4.8.3
3-- https://www.phpmyadmin.net/
4--
5-- ХоÑÑ‚: localhost
6-- Ð’Ñ€ÐµÐ¼Ñ ÑозданиÑ: Май 03 2019 г., 01:33
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--
22-- Структура таблицы `category`
23--
24
25CREATE TABLE IF NOT EXISTS `category` (
26 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
27 `name` varchar(200) DEFAULT 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`) 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, '7,10,12,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 PRIMARY KEY (`id`)
159) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;
160
161--
162-- Дамп данных таблицы `industry`
163--
164
165INSERT INTO `industry` (`id`, `name`) VALUES
166(6, 'IT, Digital'),
167(7, 'Банки, кредиты'),
168(8, 'ИнвеÑтиции'),
169(9, 'ИÑкуÑÑтво, культура'),
170(10, 'Кино, ТВ'),
171(11, 'КонÑалтинг'),
172(12, 'Маркетинг, реклама, PR'),
173(13, 'Медицина, здравоохранение, фармацевтика'),
174(14, 'Музыка'),
175(15, 'Ðаука'),
176(16, 'Образование'),
177(17, 'ÐекоммерчеÑкие организации'),
178(18, 'Продажи'),
179(19, 'ПроизводÑтво'),
180(20, 'РазвлечениÑ'),
181(21, 'СМИ, журналиÑтика'),
182(22, 'Спорт, краÑота'),
183(24, 'Страхование'),
184(25, 'СтроительÑтво, архитектура'),
185(26, 'ÐедвижимоÑÑ‚ÑŒ'),
186(27, 'ЖКХ, коммунальные уÑлуги'),
187(28, 'ЛогиÑтика'),
188(29, 'Туризм, отели, гоÑтиницы'),
189(30, 'РеÑтораны, кафе'),
190(31, 'HR, управление перÑоналом'),
191(32, 'ФинанÑÑ‹, аудит'),
192(33, 'ЮриÑпруденциÑ, право'),
193(34, 'Животные, природа'),
194(35, 'ТранÑпорт, автомобили'),
195(36, 'FMCG'),
196(37, 'Дизайн'),
197(38, 'СельÑкое хозÑйÑтво'),
198(39, 'Мода, Ñ„Ñшн'),
199(40, 'Политика, гоÑударÑÑ‚Ð²ÐµÐ½Ð½Ð°Ñ Ñлужба'),
200(41, 'Сырье, нефтегаз'),
201(42, 'Телеком, ÑвÑзь'),
202(43, 'Другое');
203
204-- --------------------------------------------------------
205
206--
207-- Структура таблицы `login_attempts`
208--
209
210CREATE TABLE IF NOT EXISTS `login_attempts` (
211 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
212 `ip_address` varchar(45) NOT NULL,
213 `login` varchar(100) NOT NULL,
214 `time` int(11) UNSIGNED DEFAULT NULL,
215 PRIMARY KEY (`id`)
216) ENGINE=InnoDB DEFAULT CHARSET=utf8;
217
218-- --------------------------------------------------------
219
220--
221-- Структура таблицы `sphere`
222--
223
224CREATE TABLE IF NOT EXISTS `sphere` (
225 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
226 `name` varchar(200) DEFAULT NULL,
227 PRIMARY KEY (`id`)
228) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8;
229
230--
231-- Дамп данных таблицы `sphere`
232--
233
234INSERT INTO `sphere` (`id`, `name`) VALUES
235(1, 'Ффера 1'),
236(2, 'Сфера 2'),
237(3, 'Сфера 3'),
238(4, 'Менеджмент'),
239(5, 'Продажи'),
240(6, 'Развитие бизнеÑа'),
241(7, 'Разработка'),
242(8, 'Дизайн'),
243(9, 'Маркетинг'),
244(10, 'Ðналитика'),
245(11, 'ЮриÑпруденциÑ'),
246(12, 'ÐдминиÑÑ‚Ñ€Ð°Ñ‚Ð¸Ð²Ð½Ð°Ñ Ñ€Ð°Ð±Ð¾Ñ‚Ð°'),
247(13, 'Продуктовый менеджмент'),
248(14, 'Менеджмент проектов'),
249(15, 'ФинанÑÑ‹, аудит'),
250(16, 'Работа Ñ Ð¿ÐµÑ€Ñоналом'),
251(17, 'СервиÑное обÑлуживание'),
252(18, 'ИнженериÑ'),
253(19, 'Другое');
254
255-- --------------------------------------------------------
256
257--
258-- Структура таблицы `users`
259--
260
261CREATE TABLE IF NOT EXISTS `users` (
262 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
263 `ip_address` varchar(45) NOT NULL,
264 `username` varchar(100) DEFAULT NULL,
265 `password` varchar(255) NOT NULL,
266 `email` varchar(254) NOT NULL,
267 `activation_selector` varchar(255) DEFAULT NULL,
268 `activation_code` varchar(255) DEFAULT NULL,
269 `forgotten_password_selector` varchar(255) DEFAULT NULL,
270 `forgotten_password_code` varchar(255) DEFAULT NULL,
271 `forgotten_password_time` int(11) UNSIGNED DEFAULT NULL,
272 `remember_selector` varchar(255) DEFAULT NULL,
273 `remember_code` varchar(255) DEFAULT NULL,
274 `created_on` int(11) UNSIGNED NOT NULL,
275 `last_login` int(11) UNSIGNED DEFAULT NULL,
276 `active` tinyint(1) UNSIGNED DEFAULT NULL,
277 `first_name` varchar(50) DEFAULT NULL,
278 `last_name` varchar(50) DEFAULT NULL,
279 `company` varchar(100) DEFAULT NULL,
280 `phone` varchar(20) DEFAULT NULL,
281 PRIMARY KEY (`id`),
282 UNIQUE KEY `uc_email` (`email`),
283 UNIQUE KEY `uc_activation_selector` (`activation_selector`),
284 UNIQUE KEY `uc_forgotten_password_selector` (`forgotten_password_selector`),
285 UNIQUE KEY `uc_remember_selector` (`remember_selector`)
286) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
287
288--
289-- Дамп данных таблицы `users`
290--
291
292INSERT 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
293(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');
294
295-- --------------------------------------------------------
296
297--
298-- Структура таблицы `users_groups`
299--
300
301CREATE TABLE IF NOT EXISTS `users_groups` (
302 `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
303 `user_id` int(11) UNSIGNED NOT NULL,
304 `group_id` mediumint(8) UNSIGNED NOT NULL,
305 PRIMARY KEY (`id`),
306 UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
307 KEY `fk_users_groups_users1_idx` (`user_id`),
308 KEY `fk_users_groups_groups1_idx` (`group_id`)
309) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
310
311--
312-- Дамп данных таблицы `users_groups`
313--
314
315INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
316(1, 1, 1),
317(2, 1, 2);
318
319-- --------------------------------------------------------
320
321--
322-- Структура таблицы `user_category_interest`
323--
324
325CREATE TABLE IF NOT EXISTS `user_category_interest` (
326 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
327 `user_id` int(11) UNSIGNED NOT NULL,
328 `category_id` int(11) UNSIGNED NOT NULL,
329 PRIMARY KEY (`id`),
330 KEY `user_id` (`user_id`),
331 KEY `category_id` (`category_id`)
332) ENGINE=MyISAM DEFAULT CHARSET=utf8;
333
334-- --------------------------------------------------------
335
336--
337-- Структура таблицы `user_city_interest`
338--
339
340CREATE TABLE IF NOT EXISTS `user_city_interest` (
341 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
342 `user_id` int(11) UNSIGNED NOT NULL,
343 `city_id` int(11) UNSIGNED NOT NULL,
344 PRIMARY KEY (`id`),
345 KEY `user_id` (`user_id`),
346 KEY `city_id` (`city_id`)
347) ENGINE=MyISAM DEFAULT CHARSET=utf8;
348
349-- --------------------------------------------------------
350
351--
352-- Структура таблицы `user_company_interest`
353--
354
355CREATE TABLE IF NOT EXISTS `user_company_interest` (
356 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
357 `user_id` int(11) UNSIGNED NOT NULL,
358 `company_id` int(11) UNSIGNED NOT NULL,
359 PRIMARY KEY (`id`),
360 KEY `user_id` (`user_id`),
361 KEY `company_id` (`company_id`)
362) ENGINE=MyISAM DEFAULT CHARSET=utf8;
363
364-- --------------------------------------------------------
365
366--
367-- Структура таблицы `user_industry_interest`
368--
369
370CREATE TABLE IF NOT EXISTS `user_industry_interest` (
371 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
372 `user_id` int(11) UNSIGNED NOT NULL,
373 `industry_id` int(11) UNSIGNED NOT NULL,
374 PRIMARY KEY (`id`),
375 KEY `user_id` (`user_id`),
376 KEY `industry_id` (`industry_id`)
377) ENGINE=MyISAM DEFAULT CHARSET=utf8;
378
379-- --------------------------------------------------------
380
381--
382-- Структура таблицы `user_sphere_interest`
383--
384
385CREATE TABLE IF NOT EXISTS `user_sphere_interest` (
386 `id` tinyint(3) UNSIGNED NOT NULL AUTO_INCREMENT,
387 `user_id` int(11) UNSIGNED NOT NULL,
388 `sphere_id` int(11) UNSIGNED NOT NULL,
389 PRIMARY KEY (`id`),
390 KEY `user_id` (`user_id`),
391 KEY `sphere_id` (`sphere_id`)
392) ENGINE=MyISAM DEFAULT CHARSET=utf8;
393
394--
395-- ÐžÐ³Ñ€Ð°Ð½Ð¸Ñ‡ÐµÐ½Ð¸Ñ Ð²Ð½ÐµÑˆÐ½ÐµÐ³Ð¾ ключа Ñохраненных таблиц
396--
397
398--
399-- ÐžÐ³Ñ€Ð°Ð½Ð¸Ñ‡ÐµÐ½Ð¸Ñ Ð²Ð½ÐµÑˆÐ½ÐµÐ³Ð¾ ключа таблицы `events`
400--
401ALTER TABLE `events`
402 ADD CONSTRAINT `events_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
403 ADD CONSTRAINT `events_ibfk_2` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
404 ADD CONSTRAINT `events_ibfk_3` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`);
405
406--
407-- ÐžÐ³Ñ€Ð°Ð½Ð¸Ñ‡ÐµÐ½Ð¸Ñ Ð²Ð½ÐµÑˆÐ½ÐµÐ³Ð¾ ключа таблицы `users_groups`
408--
409ALTER TABLE `users_groups`
410 ADD CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
411 ADD CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
412
413/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
414/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
415/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;