-- MySQL Script generated by MySQL Workbench
-- lun. 16 oct. 2017 23:08:19 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 Resa_salle BDD_2
-- -----------------------------------------------------

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

-- -----------------------------------------------------
-- Table `Resa_salle BDD_2`.`Langage`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Resa_salle BDD_2`.`Langage` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `PHP` VARCHAR(45) NOT NULL,
  `JS` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Resa_salle BDD_2`.`Role`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Resa_salle BDD_2`.`Role` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `Eleve` VARCHAR(45) NOT NULL,
  `Formateur` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Resa_salle BDD_2`.`Ecole`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Resa_salle BDD_2`.`Ecole` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `Wcs` VARCHAR(45) NOT NULL,
  `Simplon` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Resa_salle BDD_2`.`Personne`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Resa_salle BDD_2`.`Personne` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `Jean Bon avenue du cochon 45000 Truy` VARCHAR(45) NOT NULL,
  `René Charles rue du tombeau 45000 Maure` VARCHAR(45) NOT NULL,
  `Alfred Hitchock Afraid Street 45000 Lapeurrre` VARCHAR(45) NOT NULL,
  `Bob Marley rue des rasta 45000 Jamaique` VARCHAR(45) NOT NULL,
  `Jules Renard villa maupassant 45000 Contes` VARCHAR(45) NOT NULL,
  `Lorem Ipsum impasse du faux 45000 Teexte` VARCHAR(45) NOT NULL,
  `Décoc Tion rue de la tisane 45000 Pissemémée` VARCHAR(45) NOT NULL,
  `Noé Motivé rue de l'arche 45000 Bato` VARCHAR(45) NOT NULL,
  `Google Técon rue de l'info 45000 Vauleurre` VARCHAR(45) NOT NULL,
  `Laurie Ipsum rue de rien 45000 Byebye` VARCHAR(45) NOT NULL,
  `Langage_id` INT NOT NULL,
  `Role_id` INT NOT NULL,
  `Ecole_id` INT NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_Personne_Langage_idx` (`Langage_id` ASC),
  INDEX `fk_Personne_Role1_idx` (`Role_id` ASC),
  INDEX `fk_Personne_Ecole1_idx` (`Ecole_id` ASC),
  CONSTRAINT `fk_Personne_Langage`
    FOREIGN KEY (`Langage_id`)
    REFERENCES `Resa_salle BDD_2`.`Langage` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Personne_Role1`
    FOREIGN KEY (`Role_id`)
    REFERENCES `Resa_salle BDD_2`.`Role` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Personne_Ecole1`
    FOREIGN KEY (`Ecole_id`)
    REFERENCES `Resa_salle BDD_2`.`Ecole` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Resa_salle BDD_2`.`Salle`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Resa_salle BDD_2`.`Salle` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `Dojo` VARCHAR(45) NOT NULL,
  `Reunion` VARCHAR(45) NOT NULL,
  `Repos` VARCHAR(45) NOT NULL,
  `Cuisine` VARCHAR(45) NOT NULL,
  `Bureau` VARCHAR(45) NOT NULL,
  `Openspace` VARCHAR(45) NOT NULL,
  `Ecole_id` INT NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_Salle_Ecole1_idx` (`Ecole_id` ASC),
  CONSTRAINT `fk_Salle_Ecole1`
    FOREIGN KEY (`Ecole_id`)
    REFERENCES `Resa_salle BDD_2`.`Ecole` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `Resa_salle BDD_2`.`Reservation`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `Resa_salle BDD_2`.`Reservation` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `Date` DATETIME NOT NULL,
  `Durée` INT NOT NULL,
  `Salle_id` INT NOT NULL,
  `Personne_id` INT NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `fk_Reservation_Salle1_idx` (`Salle_id` ASC, `Personne_id` ASC),
  INDEX `fk_Reservation_Personne1_idx` (`Personne_id` ASC),
  CONSTRAINT `fk_Reservation_Salle1`
    FOREIGN KEY (`Salle_id` , `Personne_id`)
    REFERENCES `Resa_salle BDD_2`.`Salle` (`id` , `id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_Reservation_Personne1`
    FOREIGN KEY (`Personne_id`)
    REFERENCES `Resa_salle BDD_2`.`Personne` (`id`)
    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;