· 8 years ago · Apr 17, 2018, 04:26 AM
1-- MySQL Script generated by MySQL Workbench
2-- Mon Apr 9 13:28:24 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='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema Reservation salle
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema Reservation salle
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `Reservation salle` DEFAULT CHARACTER SET utf8 ;
18-- -----------------------------------------------------
19-- Schema new_schema1
20-- -----------------------------------------------------
21USE `Reservation salle` ;
22
23-- -----------------------------------------------------
24-- Table `Reservation salle`.`Salle`
25-- -----------------------------------------------------
26CREATE TABLE IF NOT EXISTS `Reservation salle`.`Salle` (
27 `idSalle` INT NOT NULL AUTO_INCREMENT,
28 `Nom_Salle` VARCHAR(45) NULL,
29 PRIMARY KEY (`idSalle`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `Reservation salle`.`Formateur`
35-- -----------------------------------------------------
36CREATE TABLE IF NOT EXISTS `Reservation salle`.`Formateur` (
37 `idFormateur` INT NOT NULL AUTO_INCREMENT,
38 `name` VARCHAR(45) NULL,
39 `firstname` VARCHAR(45) NULL,
40 `langage` VARCHAR(45) NULL,
41 PRIMARY KEY (`idFormateur`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `Reservation salle`.`Reservation`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `Reservation salle`.`Reservation` (
49 `idReservation` INT NOT NULL AUTO_INCREMENT,
50 `Day` DATETIME NULL,
51 `Heure` DATETIME NULL,
52 `Salle_idSalle1` INT NOT NULL,
53 `Formateur_idFormateur` INT NOT NULL,
54 PRIMARY KEY (`idReservation`, `Salle_idSalle1`),
55 INDEX `fk_Reservation_Salle1_idx` (`Salle_idSalle1` ASC),
56 INDEX `fk_Reservation_Formateur1_idx` (`Formateur_idFormateur` ASC),
57 CONSTRAINT `fk_Reservation_Salle1`
58 FOREIGN KEY (`Salle_idSalle1`)
59 REFERENCES `Reservation salle`.`Salle` (`idSalle`)
60 ON DELETE NO ACTION
61 ON UPDATE NO ACTION,
62 CONSTRAINT `fk_Reservation_Formateur1`
63 FOREIGN KEY (`Formateur_idFormateur`)
64 REFERENCES `Reservation salle`.`Formateur` (`idFormateur`)
65 ON DELETE NO ACTION
66 ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table `Reservation salle`.`Eleve`
72-- -----------------------------------------------------
73CREATE TABLE IF NOT EXISTS `Reservation salle`.`Eleve` (
74 `idEleve` INT NOT NULL AUTO_INCREMENT,
75 `name` VARCHAR(45) NULL,
76 `firstname` VARCHAR(45) NULL,
77 `age` INT NULL,
78 `lieu` VARCHAR(45) NULL,
79 `Reservation_idReservation` INT NOT NULL,
80 PRIMARY KEY (`idEleve`, `Reservation_idReservation`),
81 INDEX `fk_Eleve_Reservation1_idx` (`Reservation_idReservation` ASC),
82 CONSTRAINT `fk_Eleve_Reservation1`
83 FOREIGN KEY (`Reservation_idReservation`)
84 REFERENCES `Reservation salle`.`Reservation` (`idReservation`)
85 ON DELETE NO ACTION
86 ON UPDATE NO ACTION)
87ENGINE = InnoDB;
88
89
90SET SQL_MODE=@OLD_SQL_MODE;
91SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
92SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
93
94-- -----------------------------------------------------
95-- Data for table `Reservation salle`.`Salle`
96-- -----------------------------------------------------
97START TRANSACTION;
98USE `Reservation salle`;
99INSERT INTO `Reservation salle`.`Salle` (`idSalle`, `Nom_Salle`) VALUES (1, 'Salle de Dojo');
100INSERT INTO `Reservation salle`.`Salle` (`idSalle`, `Nom_Salle`) VALUES (6, 'Cuisine');
101INSERT INTO `Reservation salle`.`Salle` (`idSalle`, `Nom_Salle`) VALUES (5, 'Salle de réunion');
102INSERT INTO `Reservation salle`.`Salle` (`idSalle`, `Nom_Salle`) VALUES (3, 'Salle de repos');
103INSERT INTO `Reservation salle`.`Salle` (`idSalle`, `Nom_Salle`) VALUES (2, 'Bureau');
104INSERT INTO `Reservation salle`.`Salle` (`idSalle`, `Nom_Salle`) VALUES (4, 'Open-space');
105
106COMMIT;
107
108
109-- -----------------------------------------------------
110-- Data for table `Reservation salle`.`Reservation`
111-- -----------------------------------------------------
112START TRANSACTION;
113USE `Reservation salle`;
114INSERT INTO `Reservation salle`.`Reservation` (`idReservation`, `Day`, `Heure`, `Salle_idSalle1`, `Formateur_idFormateur`) VALUES (1, '18/01/18', '14:00', 1, DEFAULT);
115INSERT INTO `Reservation salle`.`Reservation` (`idReservation`, `Day`, `Heure`, `Salle_idSalle1`, `Formateur_idFormateur`) VALUES (2, '18/01/18', '16:00', 2, DEFAULT);
116INSERT INTO `Reservation salle`.`Reservation` (`idReservation`, `Day`, `Heure`, `Salle_idSalle1`, `Formateur_idFormateur`) VALUES (3, '18/01/18', '17:00', 3, DEFAULT);
117
118COMMIT;
119
120
121-- -----------------------------------------------------
122-- Data for table `Reservation salle`.`Eleve`
123-- -----------------------------------------------------
124START TRANSACTION;
125USE `Reservation salle`;
126INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'DUPOUY', 'Fred', 40, 'Bordeaux', 1);
127INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'RULEQUIN', 'Simon', 27, 'Bordeaux', 1);
128INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'SEN', 'Orhan', 25, 'Bordeaux', 1);
129INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'BONAPARTE', 'Napoléon', 30, 'Bastia', 2);
130INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'DESCARTES', 'René', 28, 'Pessac', 2);
131INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'HUGO', 'Victor', 42, 'Paris', 3);
132INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'PESTER', 'Lorie', 35, 'Paris', 4);
133INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'GOOGLE', 'Alphabet', 20, 'San Francisco', 4);
134INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'SINISTRE', 'Mister', 18, 'Londres', 4);
135INSERT INTO `Reservation salle`.`Eleve` (`idEleve`, `name`, `firstname`, `age`, `lieu`, `Reservation_idReservation`) VALUES (DEFAULT, 'PYM', 'Henry', 22, 'Talence', 4);
136
137COMMIT;
138
139
140COMMIT;