· 7 years ago · Mar 04, 2019, 04:58 PM
1-- MySQL Script generated by MySQL Workbench
2-- Mon Mar 4 17:54:45 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 AUTO_INCREMENT,
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` INT 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 `job_city` VARCHAR(45) NULL,
132 `job_image_url` VARCHAR(255) NULL,
133 PRIMARY KEY (`job_id`),
134 UNIQUE INDEX `job_id_UNIQUE` (`job_id` ASC) ',
135 INDEX `fk_job_offer_company1_idx` (`company_id` ASC) ',
136 INDEX `fk_job_offer_job_category1_idx` (`job_category_id` ASC) ',
137 CONSTRAINT `fk_job_offer_company1`
138 FOREIGN KEY (`company_id`)
139 REFERENCES `mydb`.`company` (`company_id`)
140 ON DELETE NO ACTION
141 ON UPDATE NO ACTION,
142 CONSTRAINT `fk_job_offer_job_category1`
143 FOREIGN KEY (`job_category_id`)
144 REFERENCES `mydb`.`job_category` (`job_category_id`)
145 ON DELETE NO ACTION
146 ON UPDATE NO ACTION)
147ENGINE = InnoDB;
148
149
150-- -----------------------------------------------------
151-- Table `mydb`.`event`
152-- -----------------------------------------------------
153CREATE TABLE IF NOT EXISTS `mydb`.`event` (
154 `event_id` INT NOT NULL AUTO_INCREMENT,
155 `company_id` INT NOT NULL,
156 `event_name` VARCHAR(255) NULL,
157 `event_short_description` VARCHAR(255) NULL,
158 `event_long_description` TEXT NULL,
159 `event_date` DATETIME NULL,
160 `event_location` VARCHAR(255) NULL,
161 `event_price` DOUBLE NULL,
162 PRIMARY KEY (`event_id`),
163 UNIQUE INDEX `event_id_UNIQUE` (`event_id` ASC) ',
164 INDEX `fk_table1_company1_idx` (`company_id` ASC) ',
165 CONSTRAINT `fk_table1_company1`
166 FOREIGN KEY (`company_id`)
167 REFERENCES `mydb`.`company` (`company_id`)
168 ON DELETE NO ACTION
169 ON UPDATE NO ACTION)
170ENGINE = InnoDB;
171
172
173-- -----------------------------------------------------
174-- Table `mydb`.`instructor`
175-- -----------------------------------------------------
176CREATE TABLE IF NOT EXISTS `mydb`.`instructor` (
177 `instructor_id` INT NOT NULL AUTO_INCREMENT,
178 `customer_id` INT NOT NULL,
179 `short_description` VARCHAR(255) NULL,
180 `long_description` TEXT NULL,
181 `mark` DOUBLE NULL,
182 UNIQUE INDEX `instructor_id_UNIQUE` (`instructor_id` ASC) ',
183 INDEX `fk_instructor_customer1_idx` (`customer_id` ASC) ',
184 PRIMARY KEY (`instructor_id`),
185 CONSTRAINT `fk_instructor_customer1`
186 FOREIGN KEY (`customer_id`)
187 REFERENCES `mydb`.`customer` (`customer_id`)
188 ON DELETE NO ACTION
189 ON UPDATE NO ACTION)
190ENGINE = InnoDB;
191
192
193-- -----------------------------------------------------
194-- Table `mydb`.`category`
195-- -----------------------------------------------------
196CREATE TABLE IF NOT EXISTS `mydb`.`category` (
197 `category_id` INT NOT NULL AUTO_INCREMENT,
198 `category` VARCHAR(100) NULL,
199 `tags_category` TEXT NULL,
200 `description` TEXT NULL,
201 PRIMARY KEY (`category_id`),
202 UNIQUE INDEX `category_id_UNIQUE` (`category_id` ASC) ')
203ENGINE = InnoDB;
204
205
206-- -----------------------------------------------------
207-- Table `mydb`.`course`
208-- -----------------------------------------------------
209CREATE TABLE IF NOT EXISTS `mydb`.`course` (
210 `course_id` INT NOT NULL AUTO_INCREMENT,
211 `instructor_id` INT NOT NULL,
212 `category_id` INT NOT NULL,
213 `title` VARCHAR(255) NULL,
214 `image_url` TEXT NULL,
215 `short_description` VARCHAR(255) NULL,
216 `long_description` TEXT NULL,
217 `price` INT NULL,
218 `requirements` TEXT NULL,
219 `creation_date` DATE NULL,
220 `modification_date` DATE NULL,
221 PRIMARY KEY (`course_id`),
222 UNIQUE INDEX `course_id_UNIQUE` (`course_id` ASC) ',
223 INDEX `fk_course_instructor1_idx` (`instructor_id` ASC) ',
224 INDEX `fk_course_category1_idx` (`category_id` ASC) ',
225 CONSTRAINT `fk_course_instructor1`
226 FOREIGN KEY (`instructor_id`)
227 REFERENCES `mydb`.`instructor` (`instructor_id`)
228 ON DELETE NO ACTION
229 ON UPDATE NO ACTION,
230 CONSTRAINT `fk_course_category1`
231 FOREIGN KEY (`category_id`)
232 REFERENCES `mydb`.`category` (`category_id`)
233 ON DELETE NO ACTION
234 ON UPDATE NO ACTION)
235ENGINE = InnoDB;
236
237
238-- -----------------------------------------------------
239-- Table `mydb`.`chapter`
240-- -----------------------------------------------------
241CREATE TABLE IF NOT EXISTS `mydb`.`chapter` (
242 `chapter_id` INT NOT NULL AUTO_INCREMENT,
243 `course_id` INT NOT NULL,
244 `number` INT NOT NULL,
245 `title` VARCHAR(255) NULL,
246 `time_chapter` TIME NULL,
247 PRIMARY KEY (`chapter_id`),
248 UNIQUE INDEX `chapter_id_UNIQUE` (`chapter_id` ASC) ',
249 INDEX `fk_chapter_course1_idx` (`course_id` ASC) ',
250 CONSTRAINT `fk_chapter_course1`
251 FOREIGN KEY (`course_id`)
252 REFERENCES `mydb`.`course` (`course_id`)
253 ON DELETE NO ACTION
254 ON UPDATE NO ACTION)
255ENGINE = InnoDB;
256
257
258-- -----------------------------------------------------
259-- Table `mydb`.`lesson`
260-- -----------------------------------------------------
261CREATE TABLE IF NOT EXISTS `mydb`.`lesson` (
262 `lesson_id` INT NOT NULL AUTO_INCREMENT,
263 `chapter_id` INT NOT NULL,
264 `title` VARCHAR(255) NULL,
265 `time` TIME NULL,
266 `video_url` TEXT NULL,
267 PRIMARY KEY (`lesson_id`),
268 UNIQUE INDEX `lesson_id_UNIQUE` (`lesson_id` ASC) ',
269 INDEX `fk_lesson_chapter1_idx` (`chapter_id` ASC) ',
270 CONSTRAINT `fk_lesson_chapter1`
271 FOREIGN KEY (`chapter_id`)
272 REFERENCES `mydb`.`chapter` (`chapter_id`)
273 ON DELETE NO ACTION
274 ON UPDATE NO ACTION)
275ENGINE = InnoDB;
276
277
278-- -----------------------------------------------------
279-- Table `mydb`.`test`
280-- -----------------------------------------------------
281CREATE TABLE IF NOT EXISTS `mydb`.`test` (
282 `test_id` INT NOT NULL AUTO_INCREMENT,
283 `chapterchapter_id` INT NOT NULL,
284 PRIMARY KEY (`test_id`),
285 UNIQUE INDEX `test_id_UNIQUE` (`test_id` ASC) ',
286 INDEX `fk_test_chapter1_idx` (`chapterchapter_id` ASC) ',
287 CONSTRAINT `fk_test_chapter1`
288 FOREIGN KEY (`chapterchapter_id`)
289 REFERENCES `mydb`.`chapter` (`chapter_id`)
290 ON DELETE NO ACTION
291 ON UPDATE NO ACTION)
292ENGINE = InnoDB;
293
294
295-- -----------------------------------------------------
296-- Table `mydb`.`question`
297-- -----------------------------------------------------
298CREATE TABLE IF NOT EXISTS `mydb`.`question` (
299 `question_id` INT NOT NULL AUTO_INCREMENT,
300 `test_id` INT NOT NULL,
301 `question_content` TEXT NULL,
302 `answer_a` VARCHAR(100) NULL,
303 `answer_b` VARCHAR(100) NULL,
304 `answer_c` VARCHAR(100) NULL,
305 `answer_d` VARCHAR(100) NULL,
306 `correct_answer` VARCHAR(1) NULL,
307 PRIMARY KEY (`question_id`),
308 UNIQUE INDEX `question_id_UNIQUE` (`question_id` ASC) ',
309 INDEX `fk_question_test1_idx` (`test_id` ASC) ',
310 CONSTRAINT `fk_question_test1`
311 FOREIGN KEY (`test_id`)
312 REFERENCES `mydb`.`test` (`test_id`)
313 ON DELETE NO ACTION
314 ON UPDATE NO ACTION)
315ENGINE = InnoDB;
316
317
318-- -----------------------------------------------------
319-- Table `mydb`.`review`
320-- -----------------------------------------------------
321CREATE TABLE IF NOT EXISTS `mydb`.`review` (
322 `review_id` INT NOT NULL AUTO_INCREMENT,
323 `customer_id` INT NOT NULL,
324 `course_id` INT NOT NULL,
325 `mark` DOUBLE NULL,
326 `comment` TEXT NULL,
327 PRIMARY KEY (`review_id`),
328 UNIQUE INDEX `review_id_UNIQUE` (`review_id` ASC) ',
329 INDEX `fk_review_customer1_idx` (`customer_id` ASC) ',
330 INDEX `fk_review_course1_idx` (`course_id` ASC) ',
331 CONSTRAINT `fk_review_customer1`
332 FOREIGN KEY (`customer_id`)
333 REFERENCES `mydb`.`customer` (`customer_id`)
334 ON DELETE NO ACTION
335 ON UPDATE NO ACTION,
336 CONSTRAINT `fk_review_course1`
337 FOREIGN KEY (`course_id`)
338 REFERENCES `mydb`.`course` (`course_id`)
339 ON DELETE NO ACTION
340 ON UPDATE NO ACTION)
341ENGINE = InnoDB;
342
343
344-- -----------------------------------------------------
345-- Table `mydb`.`shopping_cart`
346-- -----------------------------------------------------
347CREATE TABLE IF NOT EXISTS `mydb`.`shopping_cart` (
348 `shopping_cart_id` INT NOT NULL AUTO_INCREMENT,
349 `customer_id` INT NOT NULL,
350 `active` TINYINT NULL,
351 PRIMARY KEY (`shopping_cart_id`),
352 UNIQUE INDEX `shopping_cart_id_UNIQUE` (`shopping_cart_id` ASC) ',
353 INDEX `fk_shopping_cart_customer1_idx` (`customer_id` ASC) ',
354 CONSTRAINT `fk_shopping_cart_customer1`
355 FOREIGN KEY (`customer_id`)
356 REFERENCES `mydb`.`customer` (`customer_id`)
357 ON DELETE NO ACTION
358 ON UPDATE NO ACTION)
359ENGINE = InnoDB;
360
361
362-- -----------------------------------------------------
363-- Table `mydb`.`order`
364-- -----------------------------------------------------
365CREATE TABLE IF NOT EXISTS `mydb`.`order` (
366 `order_id` INT NOT NULL AUTO_INCREMENT,
367 `customer_id` INT NOT NULL,
368 `shopping_cart_id` INT NOT NULL,
369 `date_order` DATE NULL,
370 `total_sum` INT NULL,
371 PRIMARY KEY (`order_id`),
372 UNIQUE INDEX `order_id_UNIQUE` (`order_id` ASC) ',
373 INDEX `fk_order_customer1_idx` (`customer_id` ASC) ',
374 INDEX `fk_order_shopping_cart1_idx` (`shopping_cart_id` ASC) ',
375 CONSTRAINT `fk_order_customer1`
376 FOREIGN KEY (`customer_id`)
377 REFERENCES `mydb`.`customer` (`customer_id`)
378 ON DELETE NO ACTION
379 ON UPDATE NO ACTION,
380 CONSTRAINT `fk_order_shopping_cart1`
381 FOREIGN KEY (`shopping_cart_id`)
382 REFERENCES `mydb`.`shopping_cart` (`shopping_cart_id`)
383 ON DELETE NO ACTION
384 ON UPDATE NO ACTION)
385ENGINE = InnoDB;
386
387
388-- -----------------------------------------------------
389-- Table `mydb`.`account_boost`
390-- -----------------------------------------------------
391CREATE TABLE IF NOT EXISTS `mydb`.`account_boost` (
392 `account_balance_id` INT NOT NULL AUTO_INCREMENT,
393 `customer_id` INT NOT NULL,
394 `total_sum` INT NULL,
395 `date_transaction` DATE NULL,
396 `bank_account` VARCHAR(16) NULL,
397 `title_transaction` VARCHAR(255) NULL,
398 PRIMARY KEY (`account_balance_id`),
399 UNIQUE INDEX `account_balance_id_UNIQUE` (`account_balance_id` ASC) ',
400 INDEX `fk_account_boost_customer1_idx` (`customer_id` ASC) ',
401 CONSTRAINT `fk_account_boost_customer1`
402 FOREIGN KEY (`customer_id`)
403 REFERENCES `mydb`.`customer` (`customer_id`)
404 ON DELETE NO ACTION
405 ON UPDATE NO ACTION)
406ENGINE = InnoDB;
407
408
409-- -----------------------------------------------------
410-- Table `mydb`.`position`
411-- -----------------------------------------------------
412CREATE TABLE IF NOT EXISTS `mydb`.`position` (
413 `position_id` INT NOT NULL AUTO_INCREMENT,
414 `shopping_cart_id` INT NOT NULL,
415 `course_id` INT NOT NULL,
416 `progress` DOUBLE NULL,
417 PRIMARY KEY (`position_id`),
418 INDEX `fk_position_shopping_cart1_idx` (`shopping_cart_id` ASC) ',
419 INDEX `fk_position_course1_idx` (`course_id` ASC) ',
420 CONSTRAINT `fk_position_shopping_cart1`
421 FOREIGN KEY (`shopping_cart_id`)
422 REFERENCES `mydb`.`shopping_cart` (`shopping_cart_id`)
423 ON DELETE NO ACTION
424 ON UPDATE NO ACTION,
425 CONSTRAINT `fk_position_course1`
426 FOREIGN KEY (`course_id`)
427 REFERENCES `mydb`.`course` (`course_id`)
428 ON DELETE NO ACTION
429 ON UPDATE NO ACTION)
430ENGINE = InnoDB;
431
432
433-- -----------------------------------------------------
434-- Table `mydb`.`material`
435-- -----------------------------------------------------
436CREATE TABLE IF NOT EXISTS `mydb`.`material` (
437 `material_id` INT NOT NULL AUTO_INCREMENT,
438 `course_id` INT NOT NULL,
439 `material_title` VARCHAR(255) NULL,
440 `material_url` TEXT NULL,
441 PRIMARY KEY (`material_id`),
442 UNIQUE INDEX `material_id_UNIQUE` (`material_id` ASC) ',
443 INDEX `fk_material_course1_idx` (`course_id` ASC) ',
444 CONSTRAINT `fk_material_course1`
445 FOREIGN KEY (`course_id`)
446 REFERENCES `mydb`.`course` (`course_id`)
447 ON DELETE NO ACTION
448 ON UPDATE NO ACTION)
449ENGINE = InnoDB;
450
451
452-- -----------------------------------------------------
453-- Table `mydb`.`slider`
454-- -----------------------------------------------------
455CREATE TABLE IF NOT EXISTS `mydb`.`slider` (
456 `slider_id` INT NOT NULL AUTO_INCREMENT,
457 `image_url` TEXT NULL,
458 `title` VARCHAR(120) NULL,
459 `content` VARCHAR(255) NULL,
460 PRIMARY KEY (`slider_id`),
461 UNIQUE INDEX `slider_id_UNIQUE` (`slider_id` ASC) ')
462ENGINE = InnoDB;
463
464
465-- -----------------------------------------------------
466-- Table `mydb`.`roles`
467-- -----------------------------------------------------
468CREATE TABLE IF NOT EXISTS `mydb`.`roles` (
469 `role_id` INT NOT NULL AUTO_INCREMENT,
470 `role_name` VARCHAR(45) NULL,
471 PRIMARY KEY (`role_id`))
472ENGINE = InnoDB;
473
474
475-- -----------------------------------------------------
476-- Table `mydb`.`user_role`
477-- -----------------------------------------------------
478CREATE TABLE IF NOT EXISTS `mydb`.`user_role` (
479 `customer_id` INT NOT NULL,
480 `role_id` INT NOT NULL,
481 PRIMARY KEY (`customer_id`, `role_id`),
482 INDEX `fk_customer_has_app_role_app_role1_idx` (`role_id` ASC) ',
483 INDEX `fk_customer_has_app_role_customer1_idx` (`customer_id` ASC) ',
484 CONSTRAINT `fk_customer_has_app_role_customer1`
485 FOREIGN KEY (`customer_id`)
486 REFERENCES `mydb`.`customer` (`customer_id`)
487 ON DELETE NO ACTION
488 ON UPDATE NO ACTION,
489 CONSTRAINT `fk_customer_has_app_role_app_role1`
490 FOREIGN KEY (`role_id`)
491 REFERENCES `mydb`.`roles` (`role_id`)
492 ON DELETE NO ACTION
493 ON UPDATE NO ACTION)
494ENGINE = InnoDB;
495
496
497-- -----------------------------------------------------
498-- Table `mydb`.`additional_information`
499-- -----------------------------------------------------
500CREATE TABLE IF NOT EXISTS `mydb`.`additional_information` (
501 `information_id` INT NOT NULL AUTO_INCREMENT,
502 `course_id` INT NOT NULL,
503 `name` VARCHAR(45) NULL,
504 `value` TINYINT NULL,
505 PRIMARY KEY (`information_id`),
506 UNIQUE INDEX `additional_UNIQUE` (`information_id` ASC) ',
507 INDEX `fk_additional_information_course1_idx` (`course_id` ASC) ',
508 CONSTRAINT `fk_additional_information_course1`
509 FOREIGN KEY (`course_id`)
510 REFERENCES `mydb`.`course` (`course_id`)
511 ON DELETE NO ACTION
512 ON UPDATE NO ACTION)
513ENGINE = InnoDB;
514
515
516-- -----------------------------------------------------
517-- Table `mydb`.`cities`
518-- -----------------------------------------------------
519CREATE TABLE IF NOT EXISTS `mydb`.`cities` (
520 `city_id` INT NOT NULL,
521 `name` VARCHAR(100) NULL,
522 PRIMARY KEY (`city_id`))
523ENGINE = InnoDB;
524
525
526SET SQL_MODE=@OLD_SQL_MODE;
527SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
528SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;