· 9 years ago · Dec 15, 2016, 02:52 PM
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 127.0.01 (MySQL 5.7.16)
9# Database: examlearning
10# Generation Time: 2016-12-15 14:47:40 +0000
11# ************************************************************
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 utf8 */;
18/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table breaks
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `breaks`;
27
28CREATE TABLE `breaks` (
29 `id` bigint(20) NOT NULL AUTO_INCREMENT,
30 `text` varchar(255) DEFAULT NULL,
31 `image_path` varchar(255) DEFAULT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1;
34
35
36
37# Dump of table data
38# ------------------------------------------------------------
39
40DROP TABLE IF EXISTS `data`;
41
42CREATE TABLE `data` (
43 `id` bigint(20) NOT NULL AUTO_INCREMENT,
44 `type` varchar(255) DEFAULT NULL,
45 `value` int(11) DEFAULT NULL,
46 `unit` varchar(255) DEFAULT NULL,
47 `date` datetime(6) DEFAULT NULL,
48 `user_id` bigint(20) DEFAULT NULL,
49 PRIMARY KEY (`id`),
50 KEY `ix_data_user_id` (`user_id`),
51 CONSTRAINT `fk_data_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
52) ENGINE=InnoDB DEFAULT CHARSET=latin1;
53
54
55
56# Dump of table exam
57# ------------------------------------------------------------
58
59DROP TABLE IF EXISTS `exam`;
60
61CREATE TABLE `exam` (
62 `id` bigint(20) NOT NULL AUTO_INCREMENT,
63 `name` varchar(255) DEFAULT NULL,
64 `date` datetime(6) DEFAULT NULL,
65 PRIMARY KEY (`id`)
66) ENGINE=InnoDB DEFAULT CHARSET=latin1;
67
68LOCK TABLES `exam` WRITE;
69/*!40000 ALTER TABLE `exam` DISABLE KEYS */;
70
71INSERT INTO `exam` (`id`, `name`, `date`)
72VALUES
73 (1,'Analysis A','2017-04-25 15:00:00.000000'),
74 (2,'Analysis B','2017-04-25 19:00:00.000000'),
75 (3,'Betriebssysteme','2017-04-19 15:00:00.000000'),
76 (4,'Datenstrukturen und Algorithmen','2017-03-03 13:30:00.000000'),
77 (5,'Elektrotechnische Grundlagen der Informatik','2017-04-14 09:00:00.000000'),
78 (6,'Grundlagen Digitaler Systeme','2017-04-11 07:00:00.000000'),
79 (7,'Grundlagen der Nachrichtentechnik','2017-04-02 12:00:00.000000'),
80 (8,'Grundlagen der Softwaretechnik','2017-04-13 15:00:00.000000'),
81 (9,'Grundlagen der Theoretischen Informatik','2017-04-06 12:00:00.000000'),
82 (10,'Komplexität von Algorithmen','2017-03-18 14:00:00.000000'),
83 (11,'Lineare Algebra A','2017-03-07 11:00:00.000000'),
84 (12,'Lineare Algebra B','2017-03-07 14:00:00.000000'),
85 (13,'Logik und Formale Systeme','2017-03-05 10:00:00.000000'),
86 (14,'Mathematik für Ingenieure I','2017-04-11 07:00:00.000000'),
87 (15,'Mathematik für Ingenieure II','2017-04-12 07:00:00.000000'),
88 (16,'Mathematik für Ingenieure III','2017-04-13 07:00:00.000000'),
89 (17,'Mathematik für Ingenieure VI','2017-04-14 07:00:00.000000'),
90 (18,'Numerik A','2017-04-12 11:00:00.000000'),
91 (19,'Signale und Systeme','2017-04-19 14:00:00.000000'),
92 (20,'Software Qualität','2017-04-13 12:00:00.000000');
93
94/*!40000 ALTER TABLE `exam` ENABLE KEYS */;
95UNLOCK TABLES;
96
97
98# Dump of table exam_user
99# ------------------------------------------------------------
100
101DROP TABLE IF EXISTS `exam_user`;
102
103CREATE TABLE `exam_user` (
104 `exam_id` bigint(20) NOT NULL,
105 `user_id` bigint(20) NOT NULL,
106 PRIMARY KEY (`exam_id`,`user_id`),
107 KEY `ix_exam_user_exam` (`exam_id`),
108 KEY `ix_exam_user_user` (`user_id`),
109 CONSTRAINT `fk_exam_user_exam` FOREIGN KEY (`exam_id`) REFERENCES `exam` (`id`),
110 CONSTRAINT `fk_exam_user_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
111) ENGINE=InnoDB DEFAULT CHARSET=latin1;
112
113LOCK TABLES `exam_user` WRITE;
114/*!40000 ALTER TABLE `exam_user` DISABLE KEYS */;
115
116INSERT INTO `exam_user` (`exam_id`, `user_id`)
117VALUES
118 (1,1),
119 (2,2),
120 (2,4),
121 (3,1),
122 (3,3),
123 (3,5),
124 (3,7),
125 (4,1),
126 (4,2),
127 (4,3),
128 (4,4),
129 (4,5),
130 (4,6),
131 (4,7),
132 (5,1),
133 (6,2),
134 (6,4),
135 (6,7),
136 (7,2),
137 (7,5),
138 (7,7),
139 (8,3),
140 (8,4),
141 (8,5),
142 (8,6),
143 (8,7),
144 (9,1),
145 (9,3),
146 (9,5),
147 (9,6),
148 (9,7),
149 (10,2),
150 (10,3),
151 (10,7),
152 (11,6),
153 (12,7),
154 (13,6),
155 (15,6),
156 (16,5),
157 (17,2),
158 (17,4),
159 (17,5),
160 (17,7),
161 (18,2),
162 (18,4),
163 (18,5),
164 (18,6),
165 (19,4),
166 (19,6),
167 (20,2),
168 (20,5);
169
170/*!40000 ALTER TABLE `exam_user` ENABLE KEYS */;
171UNLOCK TABLES;
172
173
174# Dump of table invite
175# ------------------------------------------------------------
176
177DROP TABLE IF EXISTS `invite`;
178
179CREATE TABLE `invite` (
180 `id` bigint(20) NOT NULL AUTO_INCREMENT,
181 `user_id` bigint(20) DEFAULT NULL,
182 `group_id` bigint(20) DEFAULT NULL,
183 PRIMARY KEY (`id`),
184 KEY `ix_invite_user_id` (`user_id`),
185 KEY `ix_invite_group_id` (`group_id`),
186 CONSTRAINT `fk_invite_group_id` FOREIGN KEY (`group_id`) REFERENCES `learning_groups` (`id`),
187 CONSTRAINT `fk_invite_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
188) ENGINE=InnoDB DEFAULT CHARSET=latin1;
189
190LOCK TABLES `invite` WRITE;
191/*!40000 ALTER TABLE `invite` DISABLE KEYS */;
192
193INSERT INTO `invite` (`id`, `user_id`, `group_id`)
194VALUES
195 (1,5,9);
196
197/*!40000 ALTER TABLE `invite` ENABLE KEYS */;
198UNLOCK TABLES;
199
200
201# Dump of table learning_groups
202# ------------------------------------------------------------
203
204DROP TABLE IF EXISTS `learning_groups`;
205
206CREATE TABLE `learning_groups` (
207 `id` bigint(20) NOT NULL AUTO_INCREMENT,
208 `exam_id` bigint(20) DEFAULT NULL,
209 PRIMARY KEY (`id`),
210 KEY `ix_learning_groups_exam_id` (`exam_id`),
211 CONSTRAINT `fk_learning_groups_exam_id` FOREIGN KEY (`exam_id`) REFERENCES `exam` (`id`)
212) ENGINE=InnoDB DEFAULT CHARSET=latin1;
213
214LOCK TABLES `learning_groups` WRITE;
215/*!40000 ALTER TABLE `learning_groups` DISABLE KEYS */;
216
217INSERT INTO `learning_groups` (`id`, `exam_id`)
218VALUES
219 (1,1),
220 (2,2),
221 (3,3),
222 (4,4),
223 (5,5),
224 (8,8),
225 (10,9),
226 (6,16),
227 (7,17),
228 (9,20);
229
230/*!40000 ALTER TABLE `learning_groups` ENABLE KEYS */;
231UNLOCK TABLES;
232
233
234# Dump of table learning_groups_user
235# ------------------------------------------------------------
236
237DROP TABLE IF EXISTS `learning_groups_user`;
238
239CREATE TABLE `learning_groups_user` (
240 `learning_groups_id` bigint(20) NOT NULL,
241 `user_id` bigint(20) NOT NULL,
242 PRIMARY KEY (`learning_groups_id`,`user_id`),
243 KEY `ix_learning_groups_user_learning_groups` (`learning_groups_id`),
244 KEY `ix_learning_groups_user_user` (`user_id`),
245 CONSTRAINT `fk_learning_groups_user_learning_groups` FOREIGN KEY (`learning_groups_id`) REFERENCES `learning_groups` (`id`),
246 CONSTRAINT `fk_learning_groups_user_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
247) ENGINE=InnoDB DEFAULT CHARSET=latin1;
248
249LOCK TABLES `learning_groups_user` WRITE;
250/*!40000 ALTER TABLE `learning_groups_user` DISABLE KEYS */;
251
252INSERT INTO `learning_groups_user` (`learning_groups_id`, `user_id`)
253VALUES
254 (2,2),
255 (2,4),
256 (4,1),
257 (4,2),
258 (4,3),
259 (4,4),
260 (4,5),
261 (4,6),
262 (4,7),
263 (9,2),
264 (9,5),
265 (10,1),
266 (10,3),
267 (10,5),
268 (10,6),
269 (10,7);
270
271/*!40000 ALTER TABLE `learning_groups_user` ENABLE KEYS */;
272UNLOCK TABLES;
273
274
275# Dump of table play_evolutions
276# ------------------------------------------------------------
277
278DROP TABLE IF EXISTS `play_evolutions`;
279
280CREATE TABLE `play_evolutions` (
281 `id` int(11) NOT NULL,
282 `hash` varchar(255) NOT NULL,
283 `applied_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
284 `apply_script` mediumtext,
285 `revert_script` mediumtext,
286 `state` varchar(255) DEFAULT NULL,
287 `last_problem` mediumtext,
288 PRIMARY KEY (`id`)
289) ENGINE=InnoDB DEFAULT CHARSET=latin1;
290
291LOCK TABLES `play_evolutions` WRITE;
292/*!40000 ALTER TABLE `play_evolutions` DISABLE KEYS */;
293
294INSERT INTO `play_evolutions` (`id`, `hash`, `applied_at`, `apply_script`, `revert_script`, `state`, `last_problem`)
295VALUES
296 (1,'90b451f3a8c812bfcdeb524d3790dbef04e0d62f','2016-12-15 14:44:02','create table breaks (\nid bigint auto_increment not null,\ntext varchar(255),\nimage_path varchar(255),\nconstraint pk_breaks primary key (id)\n);\n\ncreate table data (\nid bigint auto_increment not null,\ntype varchar(255),\nvalue integer,\nunit varchar(255),\ndate datetime(6),\nuser_id bigint,\nconstraint pk_data primary key (id)\n);\n\ncreate table exam (\nid bigint auto_increment not null,\nname varchar(255),\ndate datetime(6),\nconstraint pk_exam primary key (id)\n);\n\ncreate table exam_user (\nexam_id bigint not null,\nuser_id bigint not null,\nconstraint pk_exam_user primary key (exam_id,user_id)\n);\n\ncreate table learning_groups (\nid bigint auto_increment not null,\nexam_id bigint,\nconstraint pk_learning_groups primary key (id)\n);\n\ncreate table learning_groups_user (\nlearning_groups_id bigint not null,\nuser_id bigint not null,\nconstraint pk_learning_groups_user primary key (learning_groups_id,user_id)\n);\n\ncreate table invite (\nid bigint auto_increment not null,\nuser_id bigint,\ngroup_id bigint,\nconstraint pk_invite primary key (id)\n);\n\ncreate table user (\nid bigint auto_increment not null,\nusername varchar(255),\nagb tinyint(1) default 0,\ncourse varchar(255),\nsemester bigint,\nsocial_provider varchar(255),\nsocial_token varchar(255),\ndata_agreement tinyint(1) default 0,\nconstraint uq_user_username unique (username),\nconstraint pk_user primary key (id)\n);\n\ncreate table user_exam (\nuser_id bigint not null,\nexam_id bigint not null,\nconstraint pk_user_exam primary key (user_id,exam_id)\n);\n\ncreate table user_learning_groups (\nuser_id bigint not null,\nlearning_groups_id bigint not null,\nconstraint pk_user_learning_groups primary key (user_id,learning_groups_id)\n);\n\nalter table data add constraint fk_data_user_id foreign key (user_id) references user (id) on delete restrict on update restrict;\ncreate index ix_data_user_id on data (user_id);\n\nalter table exam_user add constraint fk_exam_user_exam foreign key (exam_id) references exam (id) on delete restrict on update restrict;\ncreate index ix_exam_user_exam on exam_user (exam_id);\n\nalter table exam_user add constraint fk_exam_user_user foreign key (user_id) references user (id) on delete restrict on update restrict;\ncreate index ix_exam_user_user on exam_user (user_id);\n\nalter table learning_groups add constraint fk_learning_groups_exam_id foreign key (exam_id) references exam (id) on delete restrict on update restrict;\ncreate index ix_learning_groups_exam_id on learning_groups (exam_id);\n\nalter table learning_groups_user add constraint fk_learning_groups_user_learning_groups foreign key (learning_groups_id) references learning_groups (id) on delete restrict on update restrict;\ncreate index ix_learning_groups_user_learning_groups on learning_groups_user (learning_groups_id);\n\nalter table learning_groups_user add constraint fk_learning_groups_user_user foreign key (user_id) references user (id) on delete restrict on update restrict;\ncreate index ix_learning_groups_user_user on learning_groups_user (user_id);\n\nalter table invite add constraint fk_invite_user_id foreign key (user_id) references user (id) on delete restrict on update restrict;\ncreate index ix_invite_user_id on invite (user_id);\n\nalter table invite add constraint fk_invite_group_id foreign key (group_id) references learning_groups (id) on delete restrict on update restrict;\ncreate index ix_invite_group_id on invite (group_id);\n\nalter table user_exam add constraint fk_user_exam_user foreign key (user_id) references user (id) on delete restrict on update restrict;\ncreate index ix_user_exam_user on user_exam (user_id);\n\nalter table user_exam add constraint fk_user_exam_exam foreign key (exam_id) references exam (id) on delete restrict on update restrict;\ncreate index ix_user_exam_exam on user_exam (exam_id);\n\nalter table user_learning_groups add constraint fk_user_learning_groups_user foreign key (user_id) references user (id) on delete restrict on update restrict;\ncreate index ix_user_learning_groups_user on user_learning_groups (user_id);\n\nalter table user_learning_groups add constraint fk_user_learning_groups_learning_groups foreign key (learning_groups_id) references learning_groups (id) on delete restrict on update restrict;\ncreate index ix_user_learning_groups_learning_groups on user_learning_groups (learning_groups_id);','alter table data drop foreign key fk_data_user_id;\ndrop index ix_data_user_id on data;\n\nalter table exam_user drop foreign key fk_exam_user_exam;\ndrop index ix_exam_user_exam on exam_user;\n\nalter table exam_user drop foreign key fk_exam_user_user;\ndrop index ix_exam_user_user on exam_user;\n\nalter table learning_groups drop foreign key fk_learning_groups_exam_id;\ndrop index ix_learning_groups_exam_id on learning_groups;\n\nalter table learning_groups_user drop foreign key fk_learning_groups_user_learning_groups;\ndrop index ix_learning_groups_user_learning_groups on learning_groups_user;\n\nalter table learning_groups_user drop foreign key fk_learning_groups_user_user;\ndrop index ix_learning_groups_user_user on learning_groups_user;\n\nalter table invite drop foreign key fk_invite_user_id;\ndrop index ix_invite_user_id on invite;\n\nalter table invite drop foreign key fk_invite_group_id;\ndrop index ix_invite_group_id on invite;\n\nalter table user_exam drop foreign key fk_user_exam_user;\ndrop index ix_user_exam_user on user_exam;\n\nalter table user_exam drop foreign key fk_user_exam_exam;\ndrop index ix_user_exam_exam on user_exam;\n\nalter table user_learning_groups drop foreign key fk_user_learning_groups_user;\ndrop index ix_user_learning_groups_user on user_learning_groups;\n\nalter table user_learning_groups drop foreign key fk_user_learning_groups_learning_groups;\ndrop index ix_user_learning_groups_learning_groups on user_learning_groups;\n\ndrop table if exists breaks;\n\ndrop table if exists data;\n\ndrop table if exists exam;\n\ndrop table if exists exam_user;\n\ndrop table if exists learning_groups;\n\ndrop table if exists learning_groups_user;\n\ndrop table if exists invite;\n\ndrop table if exists user;\n\ndrop table if exists user_exam;\n\ndrop table if exists user_learning_groups;','applied','');
297
298/*!40000 ALTER TABLE `play_evolutions` ENABLE KEYS */;
299UNLOCK TABLES;
300
301
302# Dump of table user
303# ------------------------------------------------------------
304
305DROP TABLE IF EXISTS `user`;
306
307CREATE TABLE `user` (
308 `id` bigint(20) NOT NULL AUTO_INCREMENT,
309 `username` varchar(255) DEFAULT NULL,
310 `agb` tinyint(1) DEFAULT '0',
311 `course` varchar(255) DEFAULT NULL,
312 `semester` bigint(20) DEFAULT NULL,
313 `social_provider` varchar(255) DEFAULT NULL,
314 `social_token` varchar(255) DEFAULT NULL,
315 `data_agreement` tinyint(1) DEFAULT '0',
316 PRIMARY KEY (`id`),
317 UNIQUE KEY `uq_user_username` (`username`)
318) ENGINE=InnoDB DEFAULT CHARSET=latin1;
319
320LOCK TABLES `user` WRITE;
321/*!40000 ALTER TABLE `user` DISABLE KEYS */;
322
323INSERT INTO `user` (`id`, `username`, `agb`, `course`, `semester`, `social_provider`, `social_token`, `data_agreement`)
324VALUES
325 (1,'sarah',1,'Informatik',5,'facebook','FB_SOCIAL_TOKEN_1',1),
326 (2,'tobias',1,'Informatik',7,'google','GOOGLE_SOCIAL_TOKEN_1',1),
327 (3,'maik',1,'Technische Informatik',4,'google','GOOGLE_SOCIAL_TOKEN_2',1),
328 (4,'tim',1,'Informatik',10,'google','GOOGLE_SOCIAL_TOKEN_3',1),
329 (5,'johannes',1,'Informatik',8,'facebook','FB_SOCIAL_TOKEN_2',1),
330 (6,'kai',1,'Informatik',4,'facebook','FB_SOCIAL_TOKEN_3',1),
331 (7,'kay',1,'Informatik',9,'google','GOOGLE_SOCIAL_TOKEN_4',1);
332
333/*!40000 ALTER TABLE `user` ENABLE KEYS */;
334UNLOCK TABLES;
335
336
337# Dump of table user_exam
338# ------------------------------------------------------------
339
340DROP TABLE IF EXISTS `user_exam`;
341
342CREATE TABLE `user_exam` (
343 `user_id` bigint(20) NOT NULL,
344 `exam_id` bigint(20) NOT NULL,
345 PRIMARY KEY (`user_id`,`exam_id`),
346 KEY `ix_user_exam_user` (`user_id`),
347 KEY `ix_user_exam_exam` (`exam_id`),
348 CONSTRAINT `fk_user_exam_exam` FOREIGN KEY (`exam_id`) REFERENCES `exam` (`id`),
349 CONSTRAINT `fk_user_exam_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
350) ENGINE=InnoDB DEFAULT CHARSET=latin1;
351
352LOCK TABLES `user_exam` WRITE;
353/*!40000 ALTER TABLE `user_exam` DISABLE KEYS */;
354
355INSERT INTO `user_exam` (`user_id`, `exam_id`)
356VALUES
357 (1,1),
358 (1,3),
359 (1,4),
360 (1,5),
361 (1,9),
362 (2,2),
363 (2,4),
364 (2,6),
365 (2,7),
366 (2,10),
367 (2,17),
368 (2,18),
369 (2,20),
370 (3,3),
371 (3,4),
372 (3,8),
373 (3,9),
374 (3,10),
375 (4,2),
376 (4,4),
377 (4,6),
378 (4,8),
379 (4,17),
380 (4,18),
381 (4,19),
382 (5,3),
383 (5,4),
384 (5,7),
385 (5,8),
386 (5,9),
387 (5,16),
388 (5,17),
389 (5,18),
390 (5,20),
391 (6,4),
392 (6,8),
393 (6,9),
394 (6,11),
395 (6,13),
396 (6,15),
397 (6,18),
398 (6,19),
399 (7,3),
400 (7,4),
401 (7,6),
402 (7,7),
403 (7,8),
404 (7,9),
405 (7,10),
406 (7,12),
407 (7,17);
408
409/*!40000 ALTER TABLE `user_exam` ENABLE KEYS */;
410UNLOCK TABLES;
411
412
413# Dump of table user_learning_groups
414# ------------------------------------------------------------
415
416DROP TABLE IF EXISTS `user_learning_groups`;
417
418CREATE TABLE `user_learning_groups` (
419 `user_id` bigint(20) NOT NULL,
420 `learning_groups_id` bigint(20) NOT NULL,
421 PRIMARY KEY (`user_id`,`learning_groups_id`),
422 KEY `ix_user_learning_groups_user` (`user_id`),
423 KEY `ix_user_learning_groups_learning_groups` (`learning_groups_id`),
424 CONSTRAINT `fk_user_learning_groups_learning_groups` FOREIGN KEY (`learning_groups_id`) REFERENCES `learning_groups` (`id`),
425 CONSTRAINT `fk_user_learning_groups_user` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
426) ENGINE=InnoDB DEFAULT CHARSET=latin1;
427
428LOCK TABLES `user_learning_groups` WRITE;
429/*!40000 ALTER TABLE `user_learning_groups` DISABLE KEYS */;
430
431INSERT INTO `user_learning_groups` (`user_id`, `learning_groups_id`)
432VALUES
433 (1,4),
434 (1,10),
435 (2,2),
436 (2,4),
437 (2,9),
438 (3,4),
439 (3,10),
440 (4,2),
441 (4,4),
442 (5,4),
443 (5,9),
444 (5,10),
445 (6,4),
446 (6,10),
447 (7,4),
448 (7,10);
449
450/*!40000 ALTER TABLE `user_learning_groups` ENABLE KEYS */;
451UNLOCK TABLES;
452
453
454
455/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
456/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
457/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
458/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
459/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
460/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;