· 7 years ago · Nov 23, 2018, 04:52 PM
1-- MySQL Script generated by MySQL Workbench
2-- Fri Nov 23 19:43:48 2018
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`.`film_text`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`film_text` (
24 `film_id` INT NOT NULL,
25 `description` VARCHAR(45) NULL,
26 PRIMARY KEY (`film_id`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`Film`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`Film` (
34 `Fim_id` INT NOT NULL,
35 `title` VARCHAR(45) NULL,
36 `release_year` VARCHAR(45) NULL,
37 `length` VARCHAR(45) NULL,
38 `rating` VARCHAR(45) NULL,
39 `film_text_film_id` INT NOT NULL,
40 PRIMARY KEY (`Fim_id`, `film_text_film_id`),
41 INDEX `fk_Film_film_text1_idx` (`film_text_film_id` ASC) VISIBLE,
42 CONSTRAINT `fk_Film_film_text1`
43 FOREIGN KEY (`film_text_film_id`)
44 REFERENCES `mydb`.`film_text` (`film_id`)
45 ON DELETE NO ACTION
46 ON UPDATE NO ACTION)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `mydb`.`category`
52-- -----------------------------------------------------
53CREATE TABLE IF NOT EXISTS `mydb`.`category` (
54 `category_id` INT NOT NULL,
55 `name` VARCHAR(45) NULL,
56 PRIMARY KEY (`category_id`))
57ENGINE = InnoDB;
58
59
60-- -----------------------------------------------------
61-- Table `mydb`.`film reviews`
62-- -----------------------------------------------------
63CREATE TABLE IF NOT EXISTS `mydb`.`film reviews` (
64 `film_id` INT NOT NULL,
65 `film reviewscol` VARCHAR(45) NULL,
66 `Film_Fim_id` INT NOT NULL,
67 PRIMARY KEY (`film_id`, `Film_Fim_id`),
68 INDEX `fk_film reviews_Film1_idx` (`Film_Fim_id` ASC) VISIBLE,
69 CONSTRAINT `fk_film reviews_Film1`
70 FOREIGN KEY (`Film_Fim_id`)
71 REFERENCES `mydb`.`Film` (`Fim_id`)
72 ON DELETE NO ACTION
73 ON UPDATE NO ACTION)
74ENGINE = InnoDB;
75
76
77-- -----------------------------------------------------
78-- Table `mydb`.`actor`
79-- -----------------------------------------------------
80CREATE TABLE IF NOT EXISTS `mydb`.`actor` (
81 `id_actor` INT NOT NULL,
82 `name` VARCHAR(45) NULL,
83 PRIMARY KEY (`id_actor`))
84ENGINE = InnoDB;
85
86
87-- -----------------------------------------------------
88-- Table `mydb`.`category_has_Film`
89-- -----------------------------------------------------
90CREATE TABLE IF NOT EXISTS `mydb`.`category_has_Film` (
91 `category_id` INT NOT NULL,
92 `Fim_id` INT NOT NULL,
93 PRIMARY KEY (`category_id`, `Fim_id`),
94 INDEX `fk_category_has_Film_Film1_idx` (`Fim_id` ASC) VISIBLE,
95 INDEX `fk_category_has_Film_category_idx` (`category_id` ASC) VISIBLE,
96 CONSTRAINT `fk_category_has_Film_category`
97 FOREIGN KEY (`category_id`)
98 REFERENCES `mydb`.`category` (`category_id`)
99 ON DELETE NO ACTION
100 ON UPDATE NO ACTION,
101 CONSTRAINT `fk_category_has_Film_Film1`
102 FOREIGN KEY (`Fim_id`)
103 REFERENCES `mydb`.`Film` (`Fim_id`)
104 ON DELETE NO ACTION
105 ON UPDATE NO ACTION)
106ENGINE = InnoDB;
107
108
109-- -----------------------------------------------------
110-- Table `mydb`.`Film_has_actor`
111-- -----------------------------------------------------
112CREATE TABLE IF NOT EXISTS `mydb`.`Film_has_actor` (
113 `film_id` INT NOT NULL,
114 `id_actor` INT NOT NULL,
115 PRIMARY KEY (`film_id`, `id_actor`),
116 INDEX `fk_Film_has_actor_actor1_idx` (`id_actor` ASC) VISIBLE,
117 INDEX `fk_Film_has_actor_Film1_idx` (`film_id` ASC) VISIBLE,
118 CONSTRAINT `fk_Film_has_actor_Film1`
119 FOREIGN KEY (`film_id`)
120 REFERENCES `mydb`.`Film` (`Fim_id`)
121 ON DELETE NO ACTION
122 ON UPDATE NO ACTION,
123 CONSTRAINT `fk_Film_has_actor_actor1`
124 FOREIGN KEY (`id_actor`)
125 REFERENCES `mydb`.`actor` (`id_actor`)
126 ON DELETE NO ACTION
127 ON UPDATE NO ACTION)
128ENGINE = InnoDB;
129
130
131SET SQL_MODE=@OLD_SQL_MODE;
132SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
133SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;