quete.sql

quete.sql

-- MySQL Script generated by MySQL Workbench
-- lun. 09 avril 2018 12:12:00 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`.`Salles`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Salles` (
  `idSalles` INT NOT NULL AUTO_INCREMENT,
  `nom` VARCHAR(45) NULL,
  PRIMARY KEY (`idSalles`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`Resas`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`Resas` (
  `idresas` INT NOT NULL AUTO_INCREMENT,
  `date` DATETIME NULL,
  `heure` DATETIME NULL,
  `duree` INT NULL,
  `Salles_idSalles` INT NOT NULL,
  PRIMARY KEY (`idresas`, `Salles_idSalles`),
  INDEX `fk_Resas_Salles1_idx` (`Salles_idSalles` ASC),
  CONSTRAINT `fk_Resas_Salles1`
    FOREIGN KEY (`Salles_idSalles`)
    REFERENCES `mydb`.`Salles` (`idSalles`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`personne`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`personne` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `nom` VARCHAR(45) NULL,
  `prenom` VARCHAR(45) NULL,
  `age` INT NULL,
  `lieu` VARCHAR(45) NULL,
  `langage` VARCHAR(45) NULL,
  `Resas_idresas` INT NOT NULL,
  PRIMARY KEY (`id`, `Resas_idresas`),
  INDEX `fk_personne_Resas_idx` (`Resas_idresas` ASC),
  CONSTRAINT `fk_personne_Resas`
    FOREIGN KEY (`Resas_idresas`)
    REFERENCES `mydb`.`Resas` (`idresas`)
    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`.`Salles`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Dojo');
INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Réunion');
INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Repos');
INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Cuisine');
INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Bureau');
INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Openspace');

COMMIT;


-- -----------------------------------------------------
-- Data for table `mydb`.`Resas`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '22/03/18', '12:30', 2, 1);
INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '03/04/18', '12:50', 4, 5);
INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '11/04/18', '14:00', 1, 3);
INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '26/10/18', '16:00', 3, 6);

COMMIT;


-- -----------------------------------------------------
-- Data for table `mydb`.`personne`
-- -----------------------------------------------------
START TRANSACTION;
USE `mydb`;
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (1, 'Chrome', 'Google', 44, 'San Francisco', 'JS', 1);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Doreau', 'Estellle', 28, 'BDX', NULL, 2);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'TouteSeule', 'Laurie', 60, 'Paris', 'PHP', 1);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Moulin', 'Jean', 123, 'Paris', NULL, 1);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Poulain', 'Amélie', 33, 'Lille', NULL, 3);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Connors', 'Sarah', 1000, 'Caen', NULL, 2);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Seurin', 'Benjamin', 28, 'BDX', NULL, 4);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Charraud', 'Jules', 19, 'Paris', 'Java', 4);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Castener', 'Marie', 21, 'Toulouse', NULL, 4);
INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Nacher', 'JB', 22, 'Bordeaux', NULL, 4);

COMMIT;