Reservation

-- MySQL Script generated by MySQL Workbench
-- mer. 05 oct. 2016 13:24:30 CEST
-- 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 mydb
-- -----------------------------------------------------

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `mydb`.`élèves`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`élèves` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `nom` VARCHAR(45) NULL,
  `adresse` VARCHAR(150) NULL,
  `n°_de_dossier` VARCHAR(45) NULL,
  `prenom` VARCHAR(45) NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Formateurs`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Formateurs` (
  `id_formateurs` INT NOT NULL,
  `nom` VARCHAR(45) NULL,
  `prenom` VARCHAR(45) NULL,
  `n°_de_dossier` VARCHAR(45) NULL,
  `langage` VARCHAR(45) NULL,
  PRIMARY KEY (`id_formateurs`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Salles`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Salles` (
  `idSalle` INT NOT NULL,
  `nom` VARCHAR(45) NULL,
  PRIMARY KEY (`idSalle`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Reservation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Reservation` (
  `idReservation` INT NOT NULL,
  `Date` DATE NULL,
  `Durée` VARCHAR(45) NULL,
  `Reservation_personne` VARCHAR(45) NULL,
  PRIMARY KEY (`idReservation`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Reservation_has_Salles`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Reservation_has_Salles` (
  `Reservation_idReservation` INT NOT NULL,
  `Salles_idSalle` INT NOT NULL,
  PRIMARY KEY (`Reservation_idReservation`, `Salles_idSalle`),
  INDEX `fk_Reservation_has_Salles_Salles1_idx` (`Salles_idSalle` ASC),
  INDEX `fk_Reservation_has_Salles_Reservation_idx` (`Reservation_idReservation` ASC),
  CONSTRAINT `fk_Reservation_has_Salles_Reservation`
    FOREIGN KEY (`Reservation_idReservation`)
    REFERENCES `mydb`.`Reservation` (`idReservation`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Reservation_has_Salles_Salles1`
    FOREIGN KEY (`Salles_idSalle`)
    REFERENCES `mydb`.`Salles` (`idSalle`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`élèves_has_Reservation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`élèves_has_Reservation` (
  `élèves_id` INT NOT NULL,
  `Reservation_idReservation` INT NOT NULL,
  PRIMARY KEY (`élèves_id`, `Reservation_idReservation`),
  INDEX `fk_élèves_has_Reservation_Reservation1_idx` (`Reservation_idReservation` ASC),
  INDEX `fk_élèves_has_Reservation_élèves1_idx` (`élèves_id` ASC),
  CONSTRAINT `fk_élèves_has_Reservation_élèves1`
    FOREIGN KEY (`élèves_id`)
    REFERENCES `mydb`.`élèves` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_élèves_has_Reservation_Reservation1`
    FOREIGN KEY (`Reservation_idReservation`)
    REFERENCES `mydb`.`Reservation` (`idReservation`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Formateurs_has_Reservation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Formateurs_has_Reservation` (
  `Formateurs_id_formateurs` INT NOT NULL,
  `Reservation_idReservation` INT NOT NULL,
  PRIMARY KEY (`Formateurs_id_formateurs`, `Reservation_idReservation`),
  INDEX `fk_Formateurs_has_Reservation_Reservation1_idx` (`Reservation_idReservation` ASC),
  INDEX `fk_Formateurs_has_Reservation_Formateurs1_idx` (`Formateurs_id_formateurs` ASC),
  CONSTRAINT `fk_Formateurs_has_Reservation_Formateurs1`
    FOREIGN KEY (`Formateurs_id_formateurs`)
    REFERENCES `mydb`.`Formateurs` (`id_formateurs`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Formateurs_has_Reservation_Reservation1`
    FOREIGN KEY (`Reservation_idReservation`)
    REFERENCES `mydb`.`Reservation` (`idReservation`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


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

-- -----------------------------------------------------
-- Data for table `mydb`.`élèves`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`élèves` (`id`, `nom`, `adresse`, `n°_de_dossier`, `prenom`) VALUES (1, 'MOREAU', 'ORLEANS', '1', 'Ludovic');
INSERT INTO `mydb`.`élèves` (`id`, `nom`, `adresse`, `n°_de_dossier`, `prenom`) VALUES (2, 'PILOSEL', 'ORLEANS', '2', '');

COMMIT;


-- -----------------------------------------------------
-- Data for table `mydb`.`Formateurs`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Formateurs` (`id_formateurs`, `nom`, `prenom`, `n°_de_dossier`, `langage`) VALUES (1, 'KEITA', 'JULIEN', '1', 'PHP');
INSERT INTO `mydb`.`Formateurs` (`id_formateurs`, `nom`, `prenom`, `n°_de_dossier`, `langage`) VALUES (2, 'BLONDEAU', 'SYLVAIN', '2', 'Symphony');
INSERT INTO `mydb`.`Formateurs` (`id_formateurs`, `nom`, `prenom`, `n°_de_dossier`, `langage`) VALUES (3, 'GOOGLE', 'Gogle', '3', 'google');

COMMIT;


-- -----------------------------------------------------
-- Data for table `mydb`.`Salles`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Salles` (`idSalle`, `nom`) VALUES (1, 'WCS1');
INSERT INTO `mydb`.`Salles` (`idSalle`, `nom`) VALUES (2, 'WCS2');

COMMIT;


-- -----------------------------------------------------
-- Data for table `mydb`.`Reservation`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Reservation` (`idReservation`, `Date`, `Durée`, `Reservation_personne`) VALUES (1, '2016-10-05', '2H', 'JULIEN');
INSERT INTO `mydb`.`Reservation` (`idReservation`, `Date`, `Durée`, `Reservation_personne`) VALUES (2, '2016-10-05', '4H', 'GOOGLE');

COMMIT;