SQL-complete-tutorial

1
-- MySQL Workbench Synchronization
2
-- Generated: 2021-11-21 17:39
3
-- Model: New Model
4
-- Version: 1.0
5
-- Project: Name of the project
6
-- Author: Biljana
7

8
SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
9
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
10
SET @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';
11

12
ALTER TABLE `school`.`courses` 
13
DROP FOREIGN KEY `fk_courses_instructors`;
14

15
ALTER TABLE `school`.`enrollments` 
16
DROP FOREIGN KEY `fk_enrollments_courses`;
17

18
ALTER TABLE `school`.`course_tabs` 
19
DROP FOREIGN KEY `fk_course_tabs_courses1`,
20
DROP FOREIGN KEY `fk_course_tabs_tags1`;
21

22
ALTER TABLE `school`.`students` 
23
CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
24

25
ALTER TABLE `school`.`courses` 
26
CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
27

28
ALTER TABLE `school`.`enrollments` 
29
CHARACTER SET = utf8 , COLLATE = utf8_general_ci ,
30
ADD COLUMN `coupon` VARCHAR(50) NULL DEFAULT NULL AFTER `price`;
31

32
ALTER TABLE `school`.`tags` 
33
CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
34

35
ALTER TABLE `school`.`course_tabs` 
36
CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
37

38
ALTER TABLE `school`.`instructors` 
39
CHARACTER SET = utf8 , COLLATE = utf8_general_ci ;
40

41
ALTER TABLE `school`.`courses` 
42
ADD CONSTRAINT `fk_courses_instructors`
43
  FOREIGN KEY (`instructor_id`)
44
  REFERENCES `school`.`instructors` (`instructor_id`)
45
  ON DELETE NO ACTION
46
  ON UPDATE CASCADE;
47

48
ALTER TABLE `school`.`enrollments` 
49
DROP FOREIGN KEY `fk_enrollments_students`;
50

51
ALTER TABLE `school`.`enrollments` ADD CONSTRAINT `fk_enrollments_students`
52
  FOREIGN KEY (`student_id`)
53
  REFERENCES `school`.`students` (`student_id`)
54
  ON DELETE NO ACTION
55
  ON UPDATE CASCADE,
56
ADD CONSTRAINT `fk_enrollments_courses`
57
  FOREIGN KEY (`course_id`)
58
  REFERENCES `school`.`courses` (`course_id`)
59
  ON DELETE NO ACTION
60
  ON UPDATE NO ACTION;
61

62
ALTER TABLE `school`.`course_tabs` 
63
ADD CONSTRAINT `fk_course_tabs_courses1`
64
  FOREIGN KEY (`course_id`)
65
  REFERENCES `school`.`courses` (`course_id`)
66
  ON DELETE NO ACTION
67
  ON UPDATE NO ACTION,
68
ADD CONSTRAINT `fk_course_tabs_tags1`
69
  FOREIGN KEY (`tag_id`)
70
  REFERENCES `school`.`tags` (`tag_id`)
71
  ON DELETE NO ACTION
72
  ON UPDATE NO ACTION;
73

74

75
SET SQL_MODE=@OLD_SQL_MODE;
76
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
77
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
78