6yKUHEnW

1-- Adminer 4.7.1 MySQL dump
2
3SET NAMES utf8;
4SET time_zone = '+00:00';
5SET foreign_key_checks = 0;
6SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
7
8DROP TABLE IF EXISTS `category`;
9CREATE TABLE `category` (
10  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
11  `name` varchar(200) DEFAULT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;
14
15
16DROP TABLE IF EXISTS `city`;
17CREATE TABLE `city` (
18  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
19  `name` varchar(200) DEFAULT NULL,
20  PRIMARY KEY (`id`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8;
22
23
24DROP TABLE IF EXISTS `company`;
25CREATE TABLE `company` (
26  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
27  `name` varchar(200) DEFAULT NULL,
28  `logo` varchar(20) DEFAULT NULL,
29  PRIMARY KEY (`id`)
30) ENGINE=InnoDB DEFAULT CHARSET=utf8;
31
32
33DROP TABLE IF EXISTS `events`;
34CREATE TABLE `events` (
35  `id` int(11) NOT NULL AUTO_INCREMENT,
36  `category_id` int(11) unsigned NOT NULL COMMENT 'Категория',
37  `name` text NOT NULL COMMENT 'Наименование',
38  `company_id` int(11) unsigned NOT NULL COMMENT 'Компания',
39  `city_id` int(11) unsigned NOT NULL COMMENT 'Город',
40  `request_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заявок c',
41  `request_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заявок до',
42  `event_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е с',
43  `event_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е до',
44  `sphere_id` int(11) unsigned NOT NULL COMMENT 'сфера',
45  `additional` text NOT NULL DEFAULT '' COMMENT 'Дополнительное поле',
46  PRIMARY KEY (`id`),
47  UNIQUE KEY `id` (`id`),
48  KEY `category_id` (`category_id`),
49  KEY `company_id` (`company_id`),
50  KEY `city_id` (`city_id`),
51  KEY `sphere_id` (`sphere_id`),
52  CONSTRAINT `events_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
53  CONSTRAINT `events_ibfk_2` FOREIGN KEY (`company_id`) REFERENCES `company` (`id`),
54  CONSTRAINT `events_ibfk_3` FOREIGN KEY (`city_id`) REFERENCES `city` (`id`),
55  CONSTRAINT `events_ibfk_4` FOREIGN KEY (`sphere_id`) REFERENCES `sphere` (`id`)
56) ENGINE=InnoDB DEFAULT CHARSET=utf8;
57
58
59DROP TABLE IF EXISTS `groups`;
60CREATE TABLE `groups` (
61  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
62  `name` varchar(20) NOT NULL,
63  `description` varchar(100) NOT NULL,
64  PRIMARY KEY (`id`)
65) ENGINE=InnoDB DEFAULT CHARSET=utf8;
66
67
68DROP TABLE IF EXISTS `industry`;
69CREATE TABLE `industry` (
70  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
71  `name` varchar(200) DEFAULT NULL,
72  PRIMARY KEY (`id`)
73) ENGINE=InnoDB DEFAULT CHARSET=utf8;
74
75
76DROP TABLE IF EXISTS `login_attempts`;
77CREATE TABLE `login_attempts` (
78  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
79  `ip_address` varchar(45) NOT NULL,
80  `login` varchar(100) NOT NULL,
81  `time` int(11) unsigned DEFAULT NULL,
82  PRIMARY KEY (`id`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84
85
86DROP TABLE IF EXISTS `sphere`;
87CREATE TABLE `sphere` (
88  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
89  `name` varchar(200) DEFAULT NULL,
90  PRIMARY KEY (`id`)
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92
93
94DROP TABLE IF EXISTS `users`;
95CREATE TABLE `users` (
96  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
97  `ip_address` varchar(45) NOT NULL,
98  `username` varchar(100) DEFAULT NULL,
99  `password` varchar(255) NOT NULL,
100  `email` varchar(254) NOT NULL,
101  `activation_selector` varchar(255) DEFAULT NULL,
102  `activation_code` varchar(255) DEFAULT NULL,
103  `forgotten_password_selector` varchar(255) DEFAULT NULL,
104  `forgotten_password_code` varchar(255) DEFAULT NULL,
105  `forgotten_password_time` int(11) unsigned DEFAULT NULL,
106  `remember_selector` varchar(255) DEFAULT NULL,
107  `remember_code` varchar(255) DEFAULT NULL,
108  `created_on` int(11) unsigned NOT NULL,
109  `last_login` int(11) unsigned DEFAULT NULL,
110  `active` tinyint(1) unsigned DEFAULT NULL,
111  `first_name` varchar(50) DEFAULT NULL,
112  `last_name` varchar(50) DEFAULT NULL,
113  `company` varchar(100) DEFAULT NULL,
114  `phone` varchar(20) DEFAULT NULL,
115  PRIMARY KEY (`id`),
116  UNIQUE KEY `uc_email` (`email`),
117  UNIQUE KEY `uc_activation_selector` (`activation_selector`),
118  UNIQUE KEY `uc_forgotten_password_selector` (`forgotten_password_selector`),
119  UNIQUE KEY `uc_remember_selector` (`remember_selector`)
120) ENGINE=InnoDB DEFAULT CHARSET=utf8;
121
122
123DROP TABLE IF EXISTS `users_groups`;
124CREATE TABLE `users_groups` (
125  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
126  `user_id` int(11) unsigned NOT NULL,
127  `group_id` mediumint(8) unsigned NOT NULL,
128  PRIMARY KEY (`id`),
129  UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
130  KEY `fk_users_groups_users1_idx` (`user_id`),
131  KEY `fk_users_groups_groups1_idx` (`group_id`),
132  CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
133  CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
134) ENGINE=InnoDB DEFAULT CHARSET=utf8;
135
136
137DROP TABLE IF EXISTS `user_category_interest`;
138CREATE TABLE `user_category_interest` (
139  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
140  `user_id` int(11) unsigned NOT NULL,
141  `category_id` int(11) unsigned NOT NULL,
142  PRIMARY KEY (`id`),
143  KEY `user_id` (`user_id`),
144  KEY `category_id` (`category_id`)
145) ENGINE=MyISAM DEFAULT CHARSET=utf8;
146
147
148DROP TABLE IF EXISTS `user_city_interest`;
149CREATE TABLE `user_city_interest` (
150  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
151  `user_id` int(11) unsigned NOT NULL,
152  `city_id` int(11) unsigned NOT NULL,
153  PRIMARY KEY (`id`),
154  KEY `user_id` (`user_id`),
155  KEY `city_id` (`city_id`)
156) ENGINE=MyISAM DEFAULT CHARSET=utf8;
157
158
159DROP TABLE IF EXISTS `user_company_interest`;
160CREATE TABLE `user_company_interest` (
161  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
162  `user_id` int(11) unsigned NOT NULL,
163  `company_id` int(11) unsigned NOT NULL,
164  PRIMARY KEY (`id`),
165  KEY `user_id` (`user_id`),
166  KEY `company_id` (`company_id`)
167) ENGINE=MyISAM DEFAULT CHARSET=utf8;
168
169
170DROP TABLE IF EXISTS `user_industry_interest`;
171CREATE TABLE `user_industry_interest` (
172  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
173  `user_id` int(11) unsigned NOT NULL,
174  `industry_id` int(11) unsigned NOT NULL,
175  PRIMARY KEY (`id`),
176  KEY `user_id` (`user_id`),
177  KEY `industry_id` (`industry_id`)
178) ENGINE=MyISAM DEFAULT CHARSET=utf8;
179
180
181DROP TABLE IF EXISTS `user_sphere_iterest`;
182CREATE TABLE `user_sphere_iterest` (
183  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
184  `user_id` int(11) unsigned NOT NULL,
185  `sphere_id` int(11) unsigned NOT NULL,
186  PRIMARY KEY (`id`),
187  KEY `user_id` (`user_id`),
188  KEY `sphere_id` (`sphere_id`)
189) ENGINE=MyISAM DEFAULT CHARSET=utf8;
190
191
192-- 2019-04-21 21:44:35