· 7 years ago · Feb 26, 2019, 07:20 PM
1-- MySQL Script generated by MySQL Workbench
2-- Tue Feb 26 20:16:16 2019
3-- Model: New Model Version: 1.0
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
9
10-- -----------------------------------------------------
11-- Schema mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`newsletter`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`newsletter` (
24 `newsletter_id` INT NOT NULL AUTO_INCREMENT,
25 `name` VARCHAR(100) NULL,
26 `content` TEXT NULL,
27 `type` VARCHAR(45) NULL,
28 PRIMARY KEY (`newsletter_id`),
29 UNIQUE INDEX `newsletter_id_UNIQUE` (`newsletter_id` ASC) )
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`address`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`address` (
37 `address_id` INT NOT NULL AUTO_INCREMENT,
38 `street` VARCHAR(40) NULL,
39 `city` VARCHAR(40) NULL,
40 `post_code` VARCHAR(6) NULL,
41 `number_house` VARCHAR(6) NULL,
42 `number_flat` VARCHAR(6) NULL,
43 PRIMARY KEY (`address_id`),
44 UNIQUE INDEX `address_id_UNIQUE` (`address_id` ASC) )
45ENGINE = InnoDB;
46
47
48-- -----------------------------------------------------
49-- Table `mydb`.`customer`
50-- -----------------------------------------------------
51CREATE TABLE IF NOT EXISTS `mydb`.`customer` (
52 `customer_id` INT NOT NULL AUTO_INCREMENT,
53 `address_id` INT NULL,
54 `name` VARCHAR(30) NULL,
55 `last_name` VARCHAR(30) NULL,
56 `avatar` TEXT NULL,
57 `account_balance` INT NULL,
58 `username` VARCHAR(32) NULL,
59 `password` VARCHAR(255) NULL,
60 `active` TINYINT NULL,
61 `birthday` DATE NULL,
62 `newsletter` TINYINT NULL,
63 `email` VARCHAR(100) NULL,
64 `phone_number` VARCHAR(15) NULL,
65 `token` VARCHAR(255) NULL,
66 `hash` VARCHAR(255) NULL,
67 `hash_date` DATE NULL,
68 PRIMARY KEY (`customer_id`),
69 INDEX `fk_customer_address1_idx` (`address_id` ASC) ,
70 CONSTRAINT `fk_customer_address1`
71 FOREIGN KEY (`address_id`)
72 REFERENCES `mydb`.`address` (`address_id`)
73 ON DELETE NO ACTION
74 ON UPDATE NO ACTION)
75ENGINE = InnoDB;
76
77
78-- -----------------------------------------------------
79-- Table `mydb`.`company`
80-- -----------------------------------------------------
81CREATE TABLE IF NOT EXISTS `mydb`.`company` (
82 `company_id` INT NOT NULL AUTO_INCREMENT,
83 `address_id` INT NOT NULL,
84 `customer_id` INT NOT NULL,
85 `name` VARCHAR(255) NULL,
86 `short_description` VARCHAR(255) NULL,
87 `long_description` TEXT NULL,
88 PRIMARY KEY (`company_id`),
89 UNIQUE INDEX `company_id_UNIQUE` (`company_id` ASC) ,
90 INDEX `fk_company_address1_idx` (`address_id` ASC) ,
91 INDEX `fk_company_customer1_idx` (`customer_id` ASC) ,
92 CONSTRAINT `fk_company_address1`
93 FOREIGN KEY (`address_id`)
94 REFERENCES `mydb`.`address` (`address_id`)
95 ON DELETE NO ACTION
96 ON UPDATE NO ACTION,
97 CONSTRAINT `fk_company_customer1`
98 FOREIGN KEY (`customer_id`)
99 REFERENCES `mydb`.`customer` (`customer_id`)
100 ON DELETE NO ACTION
101 ON UPDATE NO ACTION)
102ENGINE = InnoDB;
103
104
105-- -----------------------------------------------------
106-- Table `mydb`.`job_category`
107-- -----------------------------------------------------
108CREATE TABLE IF NOT EXISTS `mydb`.`job_category` (
109 `job_category_id` INT NOT NULL,
110 `category` VARCHAR(45) NULL,
111 PRIMARY KEY (`job_category_id`))
112ENGINE = InnoDB;
113
114
115-- -----------------------------------------------------
116-- Table `mydb`.`job_offer`
117-- -----------------------------------------------------
118CREATE TABLE IF NOT EXISTS `mydb`.`job_offer` (
119 `job_id` INT NOT NULL AUTO_INCREMENT,
120 `company_id` INT NOT NULL,
121 `job_category_id` INT NOT NULL,
122 `job_name` VARCHAR(255) NULL,
123 `job_position` VARCHAR(255) NULL,
124 `job_requirements` TEXT NULL,
125 `job_description` TEXT NULL,
126 `job_salary` DOUBLE NULL,
127 `job_active` TINYINT NULL,
128 `job_validity` TINYINT NULL,
129 `job_creation` DATETIME NULL,
130 `job_length_of_the_advertisement` TINYINT NULL,
131 PRIMARY KEY (`job_id`),
132 UNIQUE INDEX `job_id_UNIQUE` (`job_id` ASC) ,
133 INDEX `fk_job_offer_company1_idx` (`company_id` ASC) ,
134 INDEX `fk_job_offer_job_category1_idx` (`job_category_id` ASC) ,
135 CONSTRAINT `fk_job_offer_company1`
136 FOREIGN KEY (`company_id`)
137 REFERENCES `mydb`.`company` (`company_id`)
138 ON DELETE NO ACTION
139 ON UPDATE NO ACTION,
140 CONSTRAINT `fk_job_offer_job_category1`
141 FOREIGN KEY (`job_category_id`)
142 REFERENCES `mydb`.`job_category` (`job_category_id`)
143 ON DELETE NO ACTION
144 ON UPDATE NO ACTION)
145ENGINE = InnoDB;
146
147
148-- -----------------------------------------------------
149-- Table `mydb`.`event`
150-- -----------------------------------------------------
151CREATE TABLE IF NOT EXISTS `mydb`.`event` (
152 `event_id` INT NOT NULL AUTO_INCREMENT,
153 `company_id` INT NOT NULL,
154 `event_name` VARCHAR(255) NULL,
155 `event_short_description` VARCHAR(255) NULL,
156 `event_long_description` TEXT NULL,
157 `event_date` DATETIME NULL,
158 `event_location` VARCHAR(255) NULL,
159 `event_price` DOUBLE NULL,
160 PRIMARY KEY (`event_id`),
161 UNIQUE INDEX `event_id_UNIQUE` (`event_id` ASC) ,
162 INDEX `fk_table1_company1_idx` (`company_id` ASC) ,
163 CONSTRAINT `fk_table1_company1`
164 FOREIGN KEY (`company_id`)
165 REFERENCES `mydb`.`company` (`company_id`)
166 ON DELETE NO ACTION
167 ON UPDATE NO ACTION)
168ENGINE = InnoDB;
169
170
171-- -----------------------------------------------------
172-- Table `mydb`.`instructor`
173-- -----------------------------------------------------
174CREATE TABLE IF NOT EXISTS `mydb`.`instructor` (
175 `instructor_id` INT NOT NULL AUTO_INCREMENT,
176 `customer_id` INT NOT NULL,
177 `short_description` VARCHAR(255) NULL,
178 `long_description` TEXT NULL,
179 `mark` DOUBLE NULL,
180 UNIQUE INDEX `instructor_id_UNIQUE` (`instructor_id` ASC) ,
181 INDEX `fk_instructor_customer1_idx` (`customer_id` ASC) ,
182 PRIMARY KEY (`instructor_id`),
183 CONSTRAINT `fk_instructor_customer1`
184 FOREIGN KEY (`customer_id`)
185 REFERENCES `mydb`.`customer` (`customer_id`)
186 ON DELETE NO ACTION
187 ON UPDATE NO ACTION)
188ENGINE = InnoDB;
189
190
191-- -----------------------------------------------------
192-- Table `mydb`.`category`
193-- -----------------------------------------------------
194CREATE TABLE IF NOT EXISTS `mydb`.`category` (
195 `category_id` INT NOT NULL AUTO_INCREMENT,
196 `category` VARCHAR(100) NULL,
197 `tags_category` TEXT NULL,
198 `description` TEXT NULL,
199 PRIMARY KEY (`category_id`),
200 UNIQUE INDEX `category_id_UNIQUE` (`category_id` ASC) )
201ENGINE = InnoDB;
202
203
204-- -----------------------------------------------------
205-- Table `mydb`.`course`
206-- -----------------------------------------------------
207CREATE TABLE IF NOT EXISTS `mydb`.`course` (
208 `course_id` INT NOT NULL AUTO_INCREMENT,
209 `instructor_id` INT NOT NULL,
210 `category_id` INT NOT NULL,
211 `title` VARCHAR(255) NULL,
212 `image_url` TEXT NULL,
213 `short_description` VARCHAR(255) NULL,
214 `long_description` TEXT NULL,
215 `price` INT NULL,
216 `requirements` TEXT NULL,
217 `creation_date` DATE NULL,
218 `modification_date` DATE NULL,
219 PRIMARY KEY (`course_id`),
220 UNIQUE INDEX `course_id_UNIQUE` (`course_id` ASC) ,
221 INDEX `fk_course_instructor1_idx` (`instructor_id` ASC) ,
222 INDEX `fk_course_category1_idx` (`category_id` ASC) ,
223 CONSTRAINT `fk_course_instructor1`
224 FOREIGN KEY (`instructor_id`)
225 REFERENCES `mydb`.`instructor` (`instructor_id`)
226 ON DELETE NO ACTION
227 ON UPDATE NO ACTION,
228 CONSTRAINT `fk_course_category1`
229 FOREIGN KEY (`category_id`)
230 REFERENCES `mydb`.`category` (`category_id`)
231 ON DELETE NO ACTION
232 ON UPDATE NO ACTION)
233ENGINE = InnoDB;
234
235
236-- -----------------------------------------------------
237-- Table `mydb`.`chapter`
238-- -----------------------------------------------------
239CREATE TABLE IF NOT EXISTS `mydb`.`chapter` (
240 `chapter_id` INT NOT NULL AUTO_INCREMENT,
241 `course_id` INT NOT NULL,
242 `number` INT NOT NULL,
243 `title` VARCHAR(255) NULL,
244 `time_chapter` TIME NULL,
245 PRIMARY KEY (`chapter_id`),
246 UNIQUE INDEX `chapter_id_UNIQUE` (`chapter_id` ASC) ,
247 INDEX `fk_chapter_course1_idx` (`course_id` ASC) ,
248 CONSTRAINT `fk_chapter_course1`
249 FOREIGN KEY (`course_id`)
250 REFERENCES `mydb`.`course` (`course_id`)
251 ON DELETE NO ACTION
252 ON UPDATE NO ACTION)
253ENGINE = InnoDB;
254
255
256-- -----------------------------------------------------
257-- Table `mydb`.`lesson`
258-- -----------------------------------------------------
259CREATE TABLE IF NOT EXISTS `mydb`.`lesson` (
260 `lesson_id` INT NOT NULL AUTO_INCREMENT,
261 `chapter_id` INT NOT NULL,
262 `title` VARCHAR(255) NULL,
263 `time` TIME NULL,
264 `video_url` TEXT NULL,
265 PRIMARY KEY (`lesson_id`),
266 UNIQUE INDEX `lesson_id_UNIQUE` (`lesson_id` ASC) ,
267 INDEX `fk_lesson_chapter1_idx` (`chapter_id` ASC) ,
268 CONSTRAINT `fk_lesson_chapter1`
269 FOREIGN KEY (`chapter_id`)
270 REFERENCES `mydb`.`chapter` (`chapter_id`)
271 ON DELETE NO ACTION
272 ON UPDATE NO ACTION)
273ENGINE = InnoDB;
274
275
276-- -----------------------------------------------------
277-- Table `mydb`.`test`
278-- -----------------------------------------------------
279CREATE TABLE IF NOT EXISTS `mydb`.`test` (
280 `test_id` INT NOT NULL AUTO_INCREMENT,
281 `chapterchapter_id` INT NOT NULL,
282 PRIMARY KEY (`test_id`),
283 UNIQUE INDEX `test_id_UNIQUE` (`test_id` ASC) ,
284 INDEX `fk_test_chapter1_idx` (`chapterchapter_id` ASC) ,
285 CONSTRAINT `fk_test_chapter1`
286 FOREIGN KEY (`chapterchapter_id`)
287 REFERENCES `mydb`.`chapter` (`chapter_id`)
288 ON DELETE NO ACTION
289 ON UPDATE NO ACTION)
290ENGINE = InnoDB;
291
292
293-- -----------------------------------------------------
294-- Table `mydb`.`question`
295-- -----------------------------------------------------
296CREATE TABLE IF NOT EXISTS `mydb`.`question` (
297 `question_id` INT NOT NULL AUTO_INCREMENT,
298 `test_id` INT NOT NULL,
299 `question_content` TEXT NULL,
300 `answer_a` VARCHAR(100) NULL,
301 `answer_b` VARCHAR(100) NULL,
302 `answer_c` VARCHAR(100) NULL,
303 `answer_d` VARCHAR(100) NULL,
304 `correct_answer` VARCHAR(1) NULL,
305 PRIMARY KEY (`question_id`),
306 UNIQUE INDEX `question_id_UNIQUE` (`question_id` ASC) ,
307 INDEX `fk_question_test1_idx` (`test_id` ASC) ,
308 CONSTRAINT `fk_question_test1`
309 FOREIGN KEY (`test_id`)
310 REFERENCES `mydb`.`test` (`test_id`)
311 ON DELETE NO ACTION
312 ON UPDATE NO ACTION)
313ENGINE = InnoDB;
314
315
316-- -----------------------------------------------------
317-- Table `mydb`.`review`
318-- -----------------------------------------------------
319CREATE TABLE IF NOT EXISTS `mydb`.`review` (
320 `review_id` INT NOT NULL AUTO_INCREMENT,
321 `customer_id` INT NOT NULL,
322 `course_id` INT NOT NULL,
323 `mark` DOUBLE NULL,
324 `comment` TEXT NULL,
325 PRIMARY KEY (`review_id`),
326 UNIQUE INDEX `review_id_UNIQUE` (`review_id` ASC) ,
327 INDEX `fk_review_customer1_idx` (`customer_id` ASC) ,
328 INDEX `fk_review_course1_idx` (`course_id` ASC) ,
329 CONSTRAINT `fk_review_customer1`
330 FOREIGN KEY (`customer_id`)
331 REFERENCES `mydb`.`customer` (`customer_id`)
332 ON DELETE NO ACTION
333 ON UPDATE NO ACTION,
334 CONSTRAINT `fk_review_course1`
335 FOREIGN KEY (`course_id`)
336 REFERENCES `mydb`.`course` (`course_id`)
337 ON DELETE NO ACTION
338 ON UPDATE NO ACTION)
339ENGINE = InnoDB;
340
341
342-- -----------------------------------------------------
343-- Table `mydb`.`shopping_cart`
344-- -----------------------------------------------------
345CREATE TABLE IF NOT EXISTS `mydb`.`shopping_cart` (
346 `shopping_cart_id` INT NOT NULL AUTO_INCREMENT,
347 `customer_id` INT NOT NULL,
348 `active` TINYINT NULL,
349 PRIMARY KEY (`shopping_cart_id`),
350 UNIQUE INDEX `shopping_cart_id_UNIQUE` (`shopping_cart_id` ASC) ,
351 INDEX `fk_shopping_cart_customer1_idx` (`customer_id` ASC) ,
352 CONSTRAINT `fk_shopping_cart_customer1`
353 FOREIGN KEY (`customer_id`)
354 REFERENCES `mydb`.`customer` (`customer_id`)
355 ON DELETE NO ACTION
356 ON UPDATE NO ACTION)
357ENGINE = InnoDB;
358
359
360-- -----------------------------------------------------
361-- Table `mydb`.`order`
362-- -----------------------------------------------------
363CREATE TABLE IF NOT EXISTS `mydb`.`order` (
364 `order_id` INT NOT NULL AUTO_INCREMENT,
365 `customer_id` INT NOT NULL,
366 `shopping_cart_id` INT NOT NULL,
367 `date_order` DATE NULL,
368 `total_sum` INT NULL,
369 PRIMARY KEY (`order_id`),
370 UNIQUE INDEX `order_id_UNIQUE` (`order_id` ASC) ,
371 INDEX `fk_order_customer1_idx` (`customer_id` ASC) ,
372 INDEX `fk_order_shopping_cart1_idx` (`shopping_cart_id` ASC) ,
373 CONSTRAINT `fk_order_customer1`
374 FOREIGN KEY (`customer_id`)
375 REFERENCES `mydb`.`customer` (`customer_id`)
376 ON DELETE NO ACTION
377 ON UPDATE NO ACTION,
378 CONSTRAINT `fk_order_shopping_cart1`
379 FOREIGN KEY (`shopping_cart_id`)
380 REFERENCES `mydb`.`shopping_cart` (`shopping_cart_id`)
381 ON DELETE NO ACTION
382 ON UPDATE NO ACTION)
383ENGINE = InnoDB;
384
385
386-- -----------------------------------------------------
387-- Table `mydb`.`account_boost`
388-- -----------------------------------------------------
389CREATE TABLE IF NOT EXISTS `mydb`.`account_boost` (
390 `account_balance_id` INT NOT NULL AUTO_INCREMENT,
391 `customer_id` INT NOT NULL,
392 `total_sum` INT NULL,
393 `date_transaction` DATE NULL,
394 `bank_account` VARCHAR(16) NULL,
395 `title_transaction` VARCHAR(255) NULL,
396 PRIMARY KEY (`account_balance_id`),
397 UNIQUE INDEX `account_balance_id_UNIQUE` (`account_balance_id` ASC) ,
398 INDEX `fk_account_boost_customer1_idx` (`customer_id` ASC) ,
399 CONSTRAINT `fk_account_boost_customer1`
400 FOREIGN KEY (`customer_id`)
401 REFERENCES `mydb`.`customer` (`customer_id`)
402 ON DELETE NO ACTION
403 ON UPDATE NO ACTION)
404ENGINE = InnoDB;
405
406
407-- -----------------------------------------------------
408-- Table `mydb`.`position`
409-- -----------------------------------------------------
410CREATE TABLE IF NOT EXISTS `mydb`.`position` (
411 `position_id` INT NOT NULL AUTO_INCREMENT,
412 `shopping_cart_id` INT NOT NULL,
413 `course_id` INT NOT NULL,
414 `progress` DOUBLE NULL,
415 PRIMARY KEY (`position_id`),
416 INDEX `fk_position_shopping_cart1_idx` (`shopping_cart_id` ASC) ,
417 INDEX `fk_position_course1_idx` (`course_id` ASC) ,
418 CONSTRAINT `fk_position_shopping_cart1`
419 FOREIGN KEY (`shopping_cart_id`)
420 REFERENCES `mydb`.`shopping_cart` (`shopping_cart_id`)
421 ON DELETE NO ACTION
422 ON UPDATE NO ACTION,
423 CONSTRAINT `fk_position_course1`
424 FOREIGN KEY (`course_id`)
425 REFERENCES `mydb`.`course` (`course_id`)
426 ON DELETE NO ACTION
427 ON UPDATE NO ACTION)
428ENGINE = InnoDB;
429
430
431-- -----------------------------------------------------
432-- Table `mydb`.`material`
433-- -----------------------------------------------------
434CREATE TABLE IF NOT EXISTS `mydb`.`material` (
435 `material_id` INT NOT NULL AUTO_INCREMENT,
436 `course_id` INT NOT NULL,
437 `material_title` VARCHAR(255) NULL,
438 `material_url` TEXT NULL,
439 PRIMARY KEY (`material_id`),
440 UNIQUE INDEX `material_id_UNIQUE` (`material_id` ASC) ,
441 INDEX `fk_material_course1_idx` (`course_id` ASC) ,
442 CONSTRAINT `fk_material_course1`
443 FOREIGN KEY (`course_id`)
444 REFERENCES `mydb`.`course` (`course_id`)
445 ON DELETE NO ACTION
446 ON UPDATE NO ACTION)
447ENGINE = InnoDB;
448
449
450-- -----------------------------------------------------
451-- Table `mydb`.`slider`
452-- -----------------------------------------------------
453CREATE TABLE IF NOT EXISTS `mydb`.`slider` (
454 `slider_id` INT NOT NULL AUTO_INCREMENT,
455 `image_url` TEXT NULL,
456 `title` VARCHAR(120) NULL,
457 `content` VARCHAR(255) NULL,
458 PRIMARY KEY (`slider_id`),
459 UNIQUE INDEX `slider_id_UNIQUE` (`slider_id` ASC) )
460ENGINE = InnoDB;
461
462
463-- -----------------------------------------------------
464-- Table `mydb`.`roles`
465-- -----------------------------------------------------
466CREATE TABLE IF NOT EXISTS `mydb`.`roles` (
467 `role_id` INT NOT NULL AUTO_INCREMENT,
468 `role_name` VARCHAR(45) NULL,
469 PRIMARY KEY (`role_id`))
470ENGINE = InnoDB;
471
472
473-- -----------------------------------------------------
474-- Table `mydb`.`user_role`
475-- -----------------------------------------------------
476CREATE TABLE IF NOT EXISTS `mydb`.`user_role` (
477 `customer_id` INT NOT NULL,
478 `role_id` INT NOT NULL,
479 PRIMARY KEY (`customer_id`, `role_id`),
480 INDEX `fk_customer_has_app_role_app_role1_idx` (`role_id` ASC) ,
481 INDEX `fk_customer_has_app_role_customer1_idx` (`customer_id` ASC) ,
482 CONSTRAINT `fk_customer_has_app_role_customer1`
483 FOREIGN KEY (`customer_id`)
484 REFERENCES `mydb`.`customer` (`customer_id`)
485 ON DELETE NO ACTION
486 ON UPDATE NO ACTION,
487 CONSTRAINT `fk_customer_has_app_role_app_role1`
488 FOREIGN KEY (`role_id`)
489 REFERENCES `mydb`.`roles` (`role_id`)
490 ON DELETE NO ACTION
491 ON UPDATE NO ACTION)
492ENGINE = InnoDB;
493
494
495-- -----------------------------------------------------
496-- Table `mydb`.`additional_information`
497-- -----------------------------------------------------
498CREATE TABLE IF NOT EXISTS `mydb`.`additional_information` (
499 `information_id` INT NOT NULL AUTO_INCREMENT,
500 `course_id` INT NOT NULL,
501 `name` VARCHAR(45) NULL,
502 `value` TINYINT NULL,
503 PRIMARY KEY (`information_id`),
504 UNIQUE INDEX `additional_UNIQUE` (`information_id` ASC) ,
505 INDEX `fk_additional_information_course1_idx` (`course_id` ASC) ,
506 CONSTRAINT `fk_additional_information_course1`
507 FOREIGN KEY (`course_id`)
508 REFERENCES `mydb`.`course` (`course_id`)
509 ON DELETE NO ACTION
510 ON UPDATE NO ACTION)
511ENGINE = InnoDB;
512
513
514-- -----------------------------------------------------
515-- Table `mydb`.`cities`
516-- -----------------------------------------------------
517CREATE TABLE IF NOT EXISTS `mydb`.`cities` (
518 `city_id` INT NOT NULL,
519 `name` VARCHAR(100) NULL,
520 PRIMARY KEY (`city_id`))
521ENGINE = InnoDB;
522
523
524SET SQL_MODE=@OLD_SQL_MODE;
525SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
526SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;