tpm9xp2H

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
75INSERT INTO `industry` (`id`, `name`) VALUES
76(1,	'Отрасль 1');
77
78DROP TABLE IF EXISTS `login_attempts`;
79CREATE TABLE `login_attempts` (
80  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
81  `ip_address` varchar(45) NOT NULL,
82  `login` varchar(100) NOT NULL,
83  `time` int(11) unsigned DEFAULT NULL,
84  PRIMARY KEY (`id`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8;
86
87
88DROP TABLE IF EXISTS `sphere`;
89CREATE TABLE `sphere` (
90  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
91  `name` varchar(200) DEFAULT NULL,
92  PRIMARY KEY (`id`)
93) ENGINE=InnoDB DEFAULT CHARSET=utf8;
94
95
96DROP TABLE IF EXISTS `users`;
97CREATE TABLE `users` (
98  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
99  `ip_address` varchar(45) NOT NULL,
100  `username` varchar(100) DEFAULT NULL,
101  `password` varchar(255) NOT NULL,
102  `email` varchar(254) NOT NULL,
103  `activation_selector` varchar(255) DEFAULT NULL,
104  `activation_code` varchar(255) DEFAULT NULL,
105  `forgotten_password_selector` varchar(255) DEFAULT NULL,
106  `forgotten_password_code` varchar(255) DEFAULT NULL,
107  `forgotten_password_time` int(11) unsigned DEFAULT NULL,
108  `remember_selector` varchar(255) DEFAULT NULL,
109  `remember_code` varchar(255) DEFAULT NULL,
110  `created_on` int(11) unsigned NOT NULL,
111  `last_login` int(11) unsigned DEFAULT NULL,
112  `active` tinyint(1) unsigned DEFAULT NULL,
113  `first_name` varchar(50) DEFAULT NULL,
114  `last_name` varchar(50) DEFAULT NULL,
115  `company` varchar(100) DEFAULT NULL,
116  `phone` varchar(20) DEFAULT NULL,
117  PRIMARY KEY (`id`),
118  UNIQUE KEY `uc_email` (`email`),
119  UNIQUE KEY `uc_activation_selector` (`activation_selector`),
120  UNIQUE KEY `uc_forgotten_password_selector` (`forgotten_password_selector`),
121  UNIQUE KEY `uc_remember_selector` (`remember_selector`)
122) ENGINE=InnoDB DEFAULT CHARSET=utf8;
123
124
125DROP TABLE IF EXISTS `users_groups`;
126CREATE TABLE `users_groups` (
127  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
128  `user_id` int(11) unsigned NOT NULL,
129  `group_id` mediumint(8) unsigned NOT NULL,
130  PRIMARY KEY (`id`),
131  UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
132  KEY `fk_users_groups_users1_idx` (`user_id`),
133  KEY `fk_users_groups_groups1_idx` (`group_id`),
134  CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
135  CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
136) ENGINE=InnoDB DEFAULT CHARSET=utf8;
137
138
139DROP TABLE IF EXISTS `user_category_interest`;
140CREATE TABLE `user_category_interest` (
141  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
142  `user_id` int(2) unsigned NOT NULL,
143  `category_id` int(2) unsigned NOT NULL,
144  PRIMARY KEY (`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(2) unsigned NOT NULL,
152  `cyty_id` int(2) unsigned NOT NULL,
153  PRIMARY KEY (`id`)
154) ENGINE=MyISAM DEFAULT CHARSET=utf8;
155
156
157DROP TABLE IF EXISTS `user_company_interest`;
158CREATE TABLE `user_company_interest` (
159  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
160  `user_id` int(2) unsigned NOT NULL,
161  `company_id` int(2) unsigned NOT NULL,
162  PRIMARY KEY (`id`)
163) ENGINE=MyISAM DEFAULT CHARSET=utf8;
164
165
166DROP TABLE IF EXISTS `user_industry_interest`;
167CREATE TABLE `user_industry_interest` (
168  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
169  `user_id` int(2) unsigned NOT NULL,
170  `industry_id` int(2) unsigned NOT NULL,
171  PRIMARY KEY (`id`)
172) ENGINE=MyISAM DEFAULT CHARSET=utf8;
173
174
175DROP TABLE IF EXISTS `user_sphere_iterest`;
176CREATE TABLE `user_sphere_iterest` (
177  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
178  `user_id` int(2) unsigned NOT NULL,
179  `sphere_id` int(2) unsigned NOT NULL,
180  PRIMARY KEY (`id`)
181) ENGINE=MyISAM DEFAULT CHARSET=utf8;
182
183
184-- 2019-04-21 21:39:12