· 9 years ago · Oct 05, 2016, 11:44 AM
1-- MySQL Script generated by MySQL Workbench
2-- mer. 05 oct. 2016 13:24:30 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`.`élèves`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`élèves` (
24 `id` INT NOT NULL AUTO_INCREMENT,
25 `nom` VARCHAR(45) NULL,
26 `adresse` VARCHAR(150) NULL,
27 `n°_de_dossier` VARCHAR(45) NULL,
28 `prenom` VARCHAR(45) NULL,
29 PRIMARY KEY (`id`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Formateurs`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `mydb`.`Formateurs` (
37 `id_formateurs` INT NOT NULL,
38 `nom` VARCHAR(45) NULL,
39 `prenom` VARCHAR(45) NULL,
40 `n°_de_dossier` VARCHAR(45) NULL,
41 `langage` VARCHAR(45) NULL,
42 PRIMARY KEY (`id_formateurs`))
43ENGINE = InnoDB;
44
45
46-- -----------------------------------------------------
47-- Table `mydb`.`Salles`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `mydb`.`Salles` (
50 `idSalle` INT NOT NULL,
51 `nom` VARCHAR(45) NULL,
52 PRIMARY KEY (`idSalle`))
53ENGINE = InnoDB;
54
55
56-- -----------------------------------------------------
57-- Table `mydb`.`Reservation`
58-- -----------------------------------------------------
59CREATE TABLE IF NOT EXISTS `mydb`.`Reservation` (
60 `idReservation` INT NOT NULL,
61 `Date` DATE NULL,
62 `Durée` VARCHAR(45) NULL,
63 `Reservation_personne` VARCHAR(45) NULL,
64 PRIMARY KEY (`idReservation`))
65ENGINE = InnoDB;
66
67
68-- -----------------------------------------------------
69-- Table `mydb`.`Reservation_has_Salles`
70-- -----------------------------------------------------
71CREATE TABLE IF NOT EXISTS `mydb`.`Reservation_has_Salles` (
72 `Reservation_idReservation` INT NOT NULL,
73 `Salles_idSalle` INT NOT NULL,
74 PRIMARY KEY (`Reservation_idReservation`, `Salles_idSalle`),
75 INDEX `fk_Reservation_has_Salles_Salles1_idx` (`Salles_idSalle` ASC),
76 INDEX `fk_Reservation_has_Salles_Reservation_idx` (`Reservation_idReservation` ASC),
77 CONSTRAINT `fk_Reservation_has_Salles_Reservation`
78 FOREIGN KEY (`Reservation_idReservation`)
79 REFERENCES `mydb`.`Reservation` (`idReservation`)
80 ON DELETE NO ACTION
81 ON UPDATE NO ACTION,
82 CONSTRAINT `fk_Reservation_has_Salles_Salles1`
83 FOREIGN KEY (`Salles_idSalle`)
84 REFERENCES `mydb`.`Salles` (`idSalle`)
85 ON DELETE NO ACTION
86 ON UPDATE NO ACTION)
87ENGINE = InnoDB;
88
89
90-- -----------------------------------------------------
91-- Table `mydb`.`élèves_has_Reservation`
92-- -----------------------------------------------------
93CREATE TABLE IF NOT EXISTS `mydb`.`élèves_has_Reservation` (
94 `élèves_id` INT NOT NULL,
95 `Reservation_idReservation` INT NOT NULL,
96 PRIMARY KEY (`élèves_id`, `Reservation_idReservation`),
97 INDEX `fk_élèves_has_Reservation_Reservation1_idx` (`Reservation_idReservation` ASC),
98 INDEX `fk_élèves_has_Reservation_élèves1_idx` (`élèves_id` ASC),
99 CONSTRAINT `fk_élèves_has_Reservation_élèves1`
100 FOREIGN KEY (`élèves_id`)
101 REFERENCES `mydb`.`élèves` (`id`)
102 ON DELETE NO ACTION
103 ON UPDATE NO ACTION,
104 CONSTRAINT `fk_élèves_has_Reservation_Reservation1`
105 FOREIGN KEY (`Reservation_idReservation`)
106 REFERENCES `mydb`.`Reservation` (`idReservation`)
107 ON DELETE NO ACTION
108 ON UPDATE NO ACTION)
109ENGINE = InnoDB;
110
111
112-- -----------------------------------------------------
113-- Table `mydb`.`Formateurs_has_Reservation`
114-- -----------------------------------------------------
115CREATE TABLE IF NOT EXISTS `mydb`.`Formateurs_has_Reservation` (
116 `Formateurs_id_formateurs` INT NOT NULL,
117 `Reservation_idReservation` INT NOT NULL,
118 PRIMARY KEY (`Formateurs_id_formateurs`, `Reservation_idReservation`),
119 INDEX `fk_Formateurs_has_Reservation_Reservation1_idx` (`Reservation_idReservation` ASC),
120 INDEX `fk_Formateurs_has_Reservation_Formateurs1_idx` (`Formateurs_id_formateurs` ASC),
121 CONSTRAINT `fk_Formateurs_has_Reservation_Formateurs1`
122 FOREIGN KEY (`Formateurs_id_formateurs`)
123 REFERENCES `mydb`.`Formateurs` (`id_formateurs`)
124 ON DELETE NO ACTION
125 ON UPDATE NO ACTION,
126 CONSTRAINT `fk_Formateurs_has_Reservation_Reservation1`
127 FOREIGN KEY (`Reservation_idReservation`)
128 REFERENCES `mydb`.`Reservation` (`idReservation`)
129 ON DELETE NO ACTION
130 ON UPDATE NO ACTION)
131ENGINE = InnoDB;
132
133
134SET SQL_MODE=@OLD_SQL_MODE;
135SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
136SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
137
138-- -----------------------------------------------------
139-- Data for table `mydb`.`élèves`
140-- -----------------------------------------------------
141START TRANSACTION;
142USE `mydb`;
143INSERT INTO `mydb`.`élèves` (`id`, `nom`, `adresse`, `n°_de_dossier`, `prenom`) VALUES (1, 'MOREAU', 'ORLEANS', '1', 'Ludovic');
144INSERT INTO `mydb`.`élèves` (`id`, `nom`, `adresse`, `n°_de_dossier`, `prenom`) VALUES (2, 'PILOSEL', 'ORLEANS', '2', '');
145
146COMMIT;
147
148
149-- -----------------------------------------------------
150-- Data for table `mydb`.`Formateurs`
151-- -----------------------------------------------------
152START TRANSACTION;
153USE `mydb`;
154INSERT INTO `mydb`.`Formateurs` (`id_formateurs`, `nom`, `prenom`, `n°_de_dossier`, `langage`) VALUES (1, 'KEITA', 'JULIEN', '1', 'PHP');
155INSERT INTO `mydb`.`Formateurs` (`id_formateurs`, `nom`, `prenom`, `n°_de_dossier`, `langage`) VALUES (2, 'BLONDEAU', 'SYLVAIN', '2', 'Symphony');
156INSERT INTO `mydb`.`Formateurs` (`id_formateurs`, `nom`, `prenom`, `n°_de_dossier`, `langage`) VALUES (3, 'GOOGLE', 'Gogle', '3', 'google');
157
158COMMIT;
159
160
161-- -----------------------------------------------------
162-- Data for table `mydb`.`Salles`
163-- -----------------------------------------------------
164START TRANSACTION;
165USE `mydb`;
166INSERT INTO `mydb`.`Salles` (`idSalle`, `nom`) VALUES (1, 'WCS1');
167INSERT INTO `mydb`.`Salles` (`idSalle`, `nom`) VALUES (2, 'WCS2');
168
169COMMIT;
170
171
172-- -----------------------------------------------------
173-- Data for table `mydb`.`Reservation`
174-- -----------------------------------------------------
175START TRANSACTION;
176USE `mydb`;
177INSERT INTO `mydb`.`Reservation` (`idReservation`, `Date`, `Durée`, `Reservation_personne`) VALUES (1, '2016-10-05', '2H', 'JULIEN');
178INSERT INTO `mydb`.`Reservation` (`idReservation`, `Date`, `Durée`, `Reservation_personne`) VALUES (2, '2016-10-05', '4H', 'GOOGLE');
179
180COMMIT;