GccqYC65

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
15INSERT INTO `category` (`id`, `name`) VALUES
16(1,	'Тестовая категория'),
17(2,	'Категория работа');
18
19DROP TABLE IF EXISTS `city`;
20CREATE TABLE `city` (
21  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
22  `name` varchar(200) DEFAULT NULL,
23  PRIMARY KEY (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
26INSERT INTO `city` (`id`, `name`) VALUES
27(1,	'Москва');
28
29DROP TABLE IF EXISTS `company`;
30CREATE TABLE `company` (
31  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
32  `name` varchar(200) DEFAULT NULL,
33  `logo` varchar(20) DEFAULT NULL,
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37
38DROP TABLE IF EXISTS `events`;
39CREATE TABLE `events` (
40  `id` int(11) NOT NULL AUTO_INCREMENT,
41  `category` int(11) unsigned NOT NULL COMMENT 'Категория',
42  `name` text NOT NULL COMMENT 'Наименование',
43  `company` int(11) unsigned NOT NULL COMMENT 'Компания',
44  `city` int(11) unsigned NOT NULL COMMENT 'Город',
45  `request_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заявок c',
46  `request_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Подача заявок до',
47  `event_start` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е с',
48  `event_end` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Провед-е до',
49  `sphere` int(11) unsigned NOT NULL COMMENT 'сфера',
50  `additional` text NOT NULL DEFAULT '' COMMENT 'Дополнительное поле',
51  PRIMARY KEY (`id`),
52  UNIQUE KEY `id` (`id`)
53) ENGINE=InnoDB DEFAULT CHARSET=utf8;
54
55
56DROP TABLE IF EXISTS `groups`;
57CREATE TABLE `groups` (
58  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
59  `name` varchar(20) NOT NULL,
60  `description` varchar(100) NOT NULL,
61  PRIMARY KEY (`id`)
62) ENGINE=InnoDB DEFAULT CHARSET=utf8;
63
64INSERT INTO `groups` (`id`, `name`, `description`) VALUES
65(1,	'admin',	'Administrator'),
66(2,	'members',	'User');
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
122INSERT 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
123(1,	'127.0.0.1',	'admin',	'$2y$12$IukxtrvcvIGGlvw59D8O4.QGdOEkWQATC.vwj7v.nig2O6g5NYZ3O',	'admin@admin.com',	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	1268889823,	1555835198,	1,	'admin',	'st',	'ADMIN',	'0'),
124(2,	'127.0.0.1',	'user',	'$2y$08$200Z6ZZbp3RAEXoaWcMA6uJOFicwNZaqk4oDhqTUiFXFe63MG.Daa',	'user@admin.com',	NULL,	'',	NULL,	NULL,	NULL,	NULL,	NULL,	1268889823,	1555793809,	1,	'admin',	'st',	'ADMIN',	'0');
125
126DROP TABLE IF EXISTS `users_groups`;
127CREATE TABLE `users_groups` (
128  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
129  `user_id` int(11) unsigned NOT NULL,
130  `group_id` mediumint(8) unsigned NOT NULL,
131  PRIMARY KEY (`id`),
132  UNIQUE KEY `uc_users_groups` (`user_id`,`group_id`),
133  KEY `fk_users_groups_users1_idx` (`user_id`),
134  KEY `fk_users_groups_groups1_idx` (`group_id`),
135  CONSTRAINT `fk_users_groups_groups1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
136  CONSTRAINT `fk_users_groups_users1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION
137) ENGINE=InnoDB DEFAULT CHARSET=utf8;
138
139INSERT INTO `users_groups` (`id`, `user_id`, `group_id`) VALUES
140(1,	1,	1),
141(2,	1,	2);
142
143DROP TABLE IF EXISTS `user_category_interest`;
144CREATE TABLE `user_category_interest` (
145  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
146  `user_id` int(2) unsigned NOT NULL,
147  `category_id` int(2) unsigned NOT NULL,
148  PRIMARY KEY (`id`)
149) ENGINE=MyISAM DEFAULT CHARSET=utf8;
150
151
152DROP TABLE IF EXISTS `user_city_interest`;
153CREATE TABLE `user_city_interest` (
154  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
155  `user_id` int(2) unsigned NOT NULL,
156  `cyty_id` int(2) unsigned NOT NULL,
157  PRIMARY KEY (`id`)
158) ENGINE=MyISAM DEFAULT CHARSET=utf8;
159
160INSERT INTO `user_city_interest` (`id`, `user_id`, `cyty_id`) VALUES
161(1,	1,	1);
162
163DROP TABLE IF EXISTS `user_company_interest`;
164CREATE TABLE `user_company_interest` (
165  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
166  `user_id` int(2) unsigned NOT NULL,
167  `company_id` int(2) unsigned NOT NULL,
168  PRIMARY KEY (`id`)
169) ENGINE=MyISAM DEFAULT CHARSET=utf8;
170
171
172DROP TABLE IF EXISTS `user_industry_interest`;
173CREATE TABLE `user_industry_interest` (
174  `id` tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
175  `user_id` int(2) unsigned NOT NULL,
176  `industry_id` int(2) unsigned NOT NULL,
177  PRIMARY KEY (`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(2) unsigned NOT NULL,
185  `sphere_id` int(2) unsigned NOT NULL,
186  PRIMARY KEY (`id`)
187) ENGINE=MyISAM DEFAULT CHARSET=utf8;
188
189
190-- 2019-04-21 20:45:49