· 8 years ago · Apr 06, 2018, 03:56 AM
1-- MySQL Script generated by MySQL Workbench
2-- mer. 28 mars 2018 17:53:39 CEST
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='TRADITIONAL,ALLOW_INVALID_DATES';
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`.`serie`
22-- -----------------------------------------------------
23DROP TABLE IF EXISTS `mydb`.`serie` ;
24
25CREATE TABLE IF NOT EXISTS `mydb`.`serie` (
26 `idserie` INT NOT NULL AUTO_INCREMENT,
27 `title` VARCHAR(150) NULL,
28 `synopsis` TEXT NULL,
29 `genre` VARCHAR(100) NULL,
30 `creation_date` DATE NULL,
31 `global_note` FLOAT NULL,
32 `link_picture` TEXT NULL,
33 PRIMARY KEY (`idserie`))
34ENGINE = InnoDB;
35
36
37-- -----------------------------------------------------
38-- Table `mydb`.`season`
39-- -----------------------------------------------------
40DROP TABLE IF EXISTS `mydb`.`season` ;
41
42CREATE TABLE IF NOT EXISTS `mydb`.`season` (
43 `idseason` INT NOT NULL AUTO_INCREMENT,
44 `numero_season` INT NULL,
45 `idserie` INT NOT NULL,
46 PRIMARY KEY (`idseason`),
47 INDEX `fk_season_serie_idx` (`idserie` ASC),
48 CONSTRAINT `fk_season_serie`
49 FOREIGN KEY (`idserie`)
50 REFERENCES `mydb`.`serie` (`idserie`)
51 ON DELETE CASCADE
52 ON UPDATE NO ACTION)
53ENGINE = InnoDB;
54
55
56-- -----------------------------------------------------
57-- Table `mydb`.`episode`
58-- -----------------------------------------------------
59DROP TABLE IF EXISTS `mydb`.`episode` ;
60
61CREATE TABLE IF NOT EXISTS `mydb`.`episode` (
62 `idepisode` INT NOT NULL AUTO_INCREMENT,
63 `numero` INT NULL,
64 `title` VARCHAR(150) NULL,
65 `has_seen` TINYINT(1) NULL,
66 `note` INT NULL,
67 `broadcasting_date` DATE NULL,
68 `idseason` INT NOT NULL,
69 `idserie` INT NOT NULL,
70 PRIMARY KEY (`idepisode`),
71 INDEX `fk_episode_serie1_idx` (`idserie` ASC),
72 INDEX `fk_episode_season1_idx` (`idseason` ASC),
73 CONSTRAINT `fk_episode_serie1`
74 FOREIGN KEY (`idserie`)
75 REFERENCES `mydb`.`serie` (`idserie`)
76 ON DELETE CASCADE
77 ON UPDATE NO ACTION,
78 CONSTRAINT `fk_episode_season1`
79 FOREIGN KEY (`idseason`)
80 REFERENCES `mydb`.`season` (`idseason`)
81 ON DELETE CASCADE
82 ON UPDATE NO ACTION)
83ENGINE = InnoDB;
84
85
86SET SQL_MODE=@OLD_SQL_MODE;
87SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
88SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
89
90-- -----------------------------------------------------
91-- Data for table `mydb`.`serie`
92-- -----------------------------------------------------
93START TRANSACTION;
94USE `mydb`;
95INSERT INTO `mydb`.`serie` (`idserie`, `title`, `synopsis`, `genre`, `creation_date`, `global_note`, `link_picture`) VALUES (1, 'jcvhjchjvjhj', 'jhgfklkjhgfqdhtj', 'dfgsghjkj', '1990-02-10', NULL, NULL);
96
97COMMIT;
98
99
100-- -----------------------------------------------------
101-- Data for table `mydb`.`season`
102-- -----------------------------------------------------
103START TRANSACTION;
104USE `mydb`;
105INSERT INTO `mydb`.`season` (`idseason`, `numero_season`, `idserie`) VALUES (1, 1, 1);
106
107COMMIT;
108
109
110-- -----------------------------------------------------
111-- Data for table `mydb`.`episode`
112-- -----------------------------------------------------
113START TRANSACTION;
114USE `mydb`;
115INSERT INTO `mydb`.`episode` (`idepisode`, `numero`, `title`, `has_seen`, `note`, `broadcasting_date`, `idseason`, `idserie`) VALUES (1, 1, 'hgsfqdfdghfj', 1, , '1990-02-15', 1, 1);
116
117COMMIT;