wPFVAwnx

1-- MySQL Script generated by MySQL Workbench
2-- Mon Apr  9 12:46:25 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
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema RESERVATION
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `RESERVATION` DEFAULT CHARACTER SET latin1 ;
18USE `RESERVATION` ;
19
20-- -----------------------------------------------------
21-- Table `RESERVATION`.`salle`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `RESERVATION`.`salle` (
24  `ID_salle` INT(11) NOT NULL,
25  `nom_de_la_salle` TEXT NULL DEFAULT NULL,
26  PRIMARY KEY (`ID_salle`))
27ENGINE = InnoDB
28DEFAULT CHARACTER SET = latin1
29PACK_KEYS = Default;
30
31
32-- -----------------------------------------------------
33-- Table `RESERVATION`.`reserver`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `RESERVATION`.`reserver` (
36  `ID_reservation` INT NULL,
37  `duree` INT NULL,
38  `date` DATETIME NULL,
39  `salle_ID_salle` INT(11) NOT NULL,
40  PRIMARY KEY (`ID_reservation`),
41  INDEX `fk_reserver_salle1_idx` (`salle_ID_salle` ASC),
42  CONSTRAINT `fk_reserver_salle1`
43    FOREIGN KEY (`salle_ID_salle`)
44    REFERENCES `RESERVATION`.`salle` (`ID_salle`)
45    ON DELETE NO ACTION
46    ON UPDATE NO ACTION)
47ENGINE = InnoDB;
48
49
50-- -----------------------------------------------------
51-- Table `RESERVATION`.`Personnes`
52-- -----------------------------------------------------
53CREATE TABLE IF NOT EXISTS `RESERVATION`.`Personnes` (
54  `ID_eleve` INT(11) NOT NULL AUTO_INCREMENT,
55  `nom` VARCHAR(25) NOT NULL,
56  `prenom` VARCHAR(25) NOT NULL,
57  `adresse` VARCHAR(25) NOT NULL,
58  `numerodedossier` VARCHAR(25) NOT NULL,
59  `reserver_ID_reservation` INT NOT NULL,
60  PRIMARY KEY (`ID_eleve`),
61  INDEX `fk_Personnes_reserver1_idx` (`reserver_ID_reservation` ASC),
62  CONSTRAINT `fk_Personnes_reserver1`
63    FOREIGN KEY (`reserver_ID_reservation`)
64    REFERENCES `RESERVATION`.`reserver` (`ID_reservation`)
65    ON DELETE NO ACTION
66    ON UPDATE NO ACTION)
67ENGINE = InnoDB
68DEFAULT CHARACTER SET = latin1;
69
70
71SET SQL_MODE=@OLD_SQL_MODE;
72SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
73SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
74
75-- -----------------------------------------------------
76-- Data for table `RESERVATION`.`salle`
77-- -----------------------------------------------------
78START TRANSACTION;
79USE `RESERVATION`;
80INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (1, 'Salle de dojo');
81INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (2, 'Salle de réunion');
82INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (3, 'Salle de repos');
83INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (4, 'Cuisine');
84INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (5, 'Bureau');
85INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (6, 'OpenSpace');
86
87COMMIT;
88
89
90-- -----------------------------------------------------
91-- Data for table `RESERVATION`.`reserver`
92-- -----------------------------------------------------
93START TRANSACTION;
94USE `RESERVATION`;
95INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (1, 1, '18/01/18', 1);
96INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (2, 1, '19/01/18', 5);
97INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (3, 1, '20/01/18', 3);
98INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (4, 1, '21/02/18', 6);
99
100COMMIT;
101
102
103-- -----------------------------------------------------
104-- Data for table `RESERVATION`.`Personnes`
105-- -----------------------------------------------------
106START TRANSACTION;
107USE `RESERVATION`;
108INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (1, 'CASTOR', 'Emmanuel', '', '', 1);
109INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (2, 'CASTAN', 'Bill', '', DEFAULT, 1);
110INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (3, 'BORIS', 'Guy', '', DEFAULT, 1);
111INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (4, 'RUITO', 'Emmanuel', '', DEFAULT, 2);
112INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (5, 'MATOS', 'Juliette', '', DEFAULT, 2);
113INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (6, 'MILOS', 'Bernard', '', DEFAULT, 3);
114INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (7, 'EVY', 'Nestor', DEFAULT, DEFAULT, 4);
115INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (8, 'JOEL', 'Bob', DEFAULT, DEFAULT, 4);
116INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (9, 'LAPIN', 'Jacques', DEFAULT, DEFAULT, 4);
117INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (10, 'RENARD', 'Nicky', DEFAULT, DEFAULT, 4);
118
119COMMIT;