· 5 years ago · Mar 04, 2020, 01:52 PM
1-- MySQL Script generated by MySQL Workbench
2-- Wed Mar 4 13:51:37 2020
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 prietord
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema prietord
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `prietord` DEFAULT CHARACTER SET utf8 ;
18USE `prietord` ;
19
20-- -----------------------------------------------------
21-- Table `prietord`.`Specialite`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `prietord`.`Specialite` (
24 `id` INT NOT NULL AUTO_INCREMENT,
25 `intitulé` VARCHAR(100) NULL,
26 PRIMARY KEY (`id`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `prietord`.`Eleve`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `prietord`.`Eleve` (
34 `id` INT NOT NULL AUTO_INCREMENT,
35 `nom` VARCHAR(45) NULL,
36 `prénom` VARCHAR(45) NULL,
37 `niveau` INT NULL,
38 `classe` INT NULL,
39 PRIMARY KEY (`id`))
40ENGINE = InnoDB;
41
42
43-- -----------------------------------------------------
44-- Table `prietord`.`Manuel`
45-- -----------------------------------------------------
46CREATE TABLE IF NOT EXISTS `prietord`.`Manuel` (
47 `id` INT NOT NULL AUTO_INCREMENT,
48 `titre` VARCHAR(100) NULL,
49 `niveau` INT NULL,
50 `éditeur_id` INT NULL,
51 PRIMARY KEY (`id`))
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `prietord`.`Editeur`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `prietord`.`Editeur` (
59 `id` INT NOT NULL AUTO_INCREMENT,
60 `nom` VARCHAR(45) NULL,
61 `Manuel_id` INT NOT NULL,
62 PRIMARY KEY (`id`, `Manuel_id`),
63 INDEX `fk_Editeur_Manuel1_idx` (`Manuel_id` ASC) ,
64 CONSTRAINT `fk_Editeur_Manuel1`
65 FOREIGN KEY (`Manuel_id`)
66 REFERENCES `prietord`.`Manuel` (`id`)
67 ON DELETE NO ACTION
68 ON UPDATE NO ACTION)
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `prietord`.`Eleve_has_Specialite`
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS `prietord`.`Eleve_has_Specialite` (
76 `Eleve_id` INT NOT NULL,
77 `Specialite_id` INT NOT NULL,
78 PRIMARY KEY (`Eleve_id`, `Specialite_id`),
79 INDEX `fk_Eleve_has_Specialite_Specialite1_idx` (`Specialite_id` ASC) ,
80 INDEX `fk_Eleve_has_Specialite_Eleve_idx` (`Eleve_id` ASC) ,
81 CONSTRAINT `fk_Eleve_has_Specialite_Eleve`
82 FOREIGN KEY (`Eleve_id`)
83 REFERENCES `prietord`.`Eleve` (`id`)
84 ON DELETE CASCADE
85 ON UPDATE CASCADE,
86 CONSTRAINT `fk_Eleve_has_Specialite_Specialite1`
87 FOREIGN KEY (`Specialite_id`)
88 REFERENCES `prietord`.`Specialite` (`id`)
89 ON DELETE CASCADE
90 ON UPDATE CASCADE)
91ENGINE = InnoDB;
92
93
94-- -----------------------------------------------------
95-- Table `prietord`.`Specialite_has_Manuel`
96-- -----------------------------------------------------
97CREATE TABLE IF NOT EXISTS `prietord`.`Specialite_has_Manuel` (
98 `Specialite_id` INT NOT NULL,
99 `Manuel_id` INT NOT NULL,
100 PRIMARY KEY (`Specialite_id`, `Manuel_id`),
101 INDEX `fk_Specialite_has_Manuel_Manuel1_idx` (`Manuel_id` ASC) ,
102 INDEX `fk_Specialite_has_Manuel_Specialite1_idx` (`Specialite_id` ASC) ,
103 CONSTRAINT `fk_Specialite_has_Manuel_Specialite1`
104 FOREIGN KEY (`Specialite_id`)
105 REFERENCES `prietord`.`Specialite` (`id`)
106 ON DELETE CASCADE
107 ON UPDATE CASCADE,
108 CONSTRAINT `fk_Specialite_has_Manuel_Manuel1`
109 FOREIGN KEY (`Manuel_id`)
110 REFERENCES `prietord`.`Manuel` (`id`)
111 ON DELETE CASCADE
112 ON UPDATE CASCADE)
113ENGINE = InnoDB;
114
115
116SET SQL_MODE=@OLD_SQL_MODE;
117SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
118SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;