reservationbddpart2.sql

-- MySQL Script generated by MySQL Workbench
-- Mon Apr  9 12:46:25 2018
-- Model: New Model    Version: 1.0
-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

-- -----------------------------------------------------
-- Schema RESERVATION
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema RESERVATION
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `RESERVATION` DEFAULT CHARACTER SET latin1 ;
USE `RESERVATION` ;

-- -----------------------------------------------------
-- Table `RESERVATION`.`salle`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `RESERVATION`.`salle` (
  `ID_salle` INT(11) NOT NULL,
  `nom_de_la_salle` TEXT NULL DEFAULT NULL,
  PRIMARY KEY (`ID_salle`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1
PACK_KEYS = Default;


-- -----------------------------------------------------
-- Table `RESERVATION`.`reserver`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `RESERVATION`.`reserver` (
  `ID_reservation` INT NULL,
  `duree` INT NULL,
  `date` DATETIME NULL,
  `salle_ID_salle` INT(11) NOT NULL,
  PRIMARY KEY (`ID_reservation`),
  INDEX `fk_reserver_salle1_idx` (`salle_ID_salle` ASC),
  CONSTRAINT `fk_reserver_salle1`
    FOREIGN KEY (`salle_ID_salle`)
    REFERENCES `RESERVATION`.`salle` (`ID_salle`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `RESERVATION`.`Personnes`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `RESERVATION`.`Personnes` (
  `ID_eleve` INT(11) NOT NULL AUTO_INCREMENT,
  `nom` VARCHAR(25) NOT NULL,
  `prenom` VARCHAR(25) NOT NULL,
  `adresse` VARCHAR(25) NOT NULL,
  `numerodedossier` VARCHAR(25) NOT NULL,
  `reserver_ID_reservation` INT NOT NULL,
  PRIMARY KEY (`ID_eleve`),
  INDEX `fk_Personnes_reserver1_idx` (`reserver_ID_reservation` ASC),
  CONSTRAINT `fk_Personnes_reserver1`
    FOREIGN KEY (`reserver_ID_reservation`)
    REFERENCES `RESERVATION`.`reserver` (`ID_reservation`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

-- -----------------------------------------------------
-- Data for table `RESERVATION`.`salle`
-- -----------------------------------------------------
START TRANSACTION;
USE `RESERVATION`;
INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (1, 'Salle de dojo');
INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (2, 'Salle de réunion');
INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (3, 'Salle de repos');
INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (4, 'Cuisine');
INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (5, 'Bureau');
INSERT INTO `RESERVATION`.`salle` (`ID_salle`, `nom_de_la_salle`) VALUES (6, 'OpenSpace');

COMMIT;


-- -----------------------------------------------------
-- Data for table `RESERVATION`.`reserver`
-- -----------------------------------------------------
START TRANSACTION;
USE `RESERVATION`;
INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (1, 1, '18/01/18', 1);
INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (2, 1, '19/01/18', 5);
INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (3, 1, '20/01/18', 3);
INSERT INTO `RESERVATION`.`reserver` (`ID_reservation`, `duree`, `date`, `salle_ID_salle`) VALUES (4, 1, '21/02/18', 6);

COMMIT;


-- -----------------------------------------------------
-- Data for table `RESERVATION`.`Personnes`
-- -----------------------------------------------------
START TRANSACTION;
USE `RESERVATION`;
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (1, 'CASTOR', 'Emmanuel', '', '', 1);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (2, 'CASTAN', 'Bill', '', DEFAULT, 1);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (3, 'BORIS', 'Guy', '', DEFAULT, 1);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (4, 'RUITO', 'Emmanuel', '', DEFAULT, 2);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (5, 'MATOS', 'Juliette', '', DEFAULT, 2);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (6, 'MILOS', 'Bernard', '', DEFAULT, 3);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (7, 'EVY', 'Nestor', DEFAULT, DEFAULT, 4);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (8, 'JOEL', 'Bob', DEFAULT, DEFAULT, 4);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (9, 'LAPIN', 'Jacques', DEFAULT, DEFAULT, 4);
INSERT INTO `RESERVATION`.`Personnes` (`ID_eleve`, `nom`, `prenom`, `adresse`, `numerodedossier`, `reserver_ID_reservation`) VALUES (10, 'RENARD', 'Nicky', DEFAULT, DEFAULT, 4);

COMMIT;