D9rE93vK

1-- MySQL Script generated by MySQL Workbench
2-- lun. 09 avril 2018 12:12:00 CEST
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 mydb
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Salles`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Salles` (
24  `idSalles` INT NOT NULL AUTO_INCREMENT,
25  `nom` VARCHAR(45) NULL,
26  PRIMARY KEY (`idSalles`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`Resas`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`Resas` (
34  `idresas` INT NOT NULL AUTO_INCREMENT,
35  `date` DATETIME NULL,
36  `heure` DATETIME NULL,
37  `duree` INT NULL,
38  `Salles_idSalles` INT NOT NULL,
39  PRIMARY KEY (`idresas`, `Salles_idSalles`),
40  INDEX `fk_Resas_Salles1_idx` (`Salles_idSalles` ASC),
41  CONSTRAINT `fk_Resas_Salles1`
42    FOREIGN KEY (`Salles_idSalles`)
43    REFERENCES `mydb`.`Salles` (`idSalles`)
44    ON DELETE NO ACTION
45    ON UPDATE NO ACTION)
46ENGINE = InnoDB;
47
48
49-- -----------------------------------------------------
50-- Table `mydb`.`personne`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `mydb`.`personne` (
53  `id` INT NOT NULL AUTO_INCREMENT,
54  `nom` VARCHAR(45) NULL,
55  `prenom` VARCHAR(45) NULL,
56  `age` INT NULL,
57  `lieu` VARCHAR(45) NULL,
58  `langage` VARCHAR(45) NULL,
59  `Resas_idresas` INT NOT NULL,
60  PRIMARY KEY (`id`, `Resas_idresas`),
61  INDEX `fk_personne_Resas_idx` (`Resas_idresas` ASC),
62  CONSTRAINT `fk_personne_Resas`
63    FOREIGN KEY (`Resas_idresas`)
64    REFERENCES `mydb`.`Resas` (`idresas`)
65    ON DELETE NO ACTION
66    ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70SET SQL_MODE=@OLD_SQL_MODE;
71SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
72SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
73
74-- -----------------------------------------------------
75-- Data for table `mydb`.`Salles`
76-- -----------------------------------------------------
77START TRANSACTION;
78USE `mydb`;
79INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Dojo');
80INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Réunion');
81INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Repos');
82INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Cuisine');
83INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Bureau');
84INSERT INTO `mydb`.`Salles` (`idSalles`, `nom`) VALUES (DEFAULT, 'Openspace');
85
86COMMIT;
87
88
89-- -----------------------------------------------------
90-- Data for table `mydb`.`Resas`
91-- -----------------------------------------------------
92START TRANSACTION;
93USE `mydb`;
94INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '22/03/18', '12:30', 2, 1);
95INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '03/04/18', '12:50', 4, 5);
96INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '11/04/18', '14:00', 1, 3);
97INSERT INTO `mydb`.`Resas` (`idresas`, `date`, `heure`, `duree`, `Salles_idSalles`) VALUES (DEFAULT, '26/10/18', '16:00', 3, 6);
98
99COMMIT;
100
101
102-- -----------------------------------------------------
103-- Data for table `mydb`.`personne`
104-- -----------------------------------------------------
105START TRANSACTION;
106USE `mydb`;
107INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (1, 'Chrome', 'Google', 44, 'San Francisco', 'JS', 1);
108INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Doreau', 'Estellle', 28, 'BDX', NULL, 2);
109INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'TouteSeule', 'Laurie', 60, 'Paris', 'PHP', 1);
110INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Moulin', 'Jean', 123, 'Paris', NULL, 1);
111INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Poulain', 'Amélie', 33, 'Lille', NULL, 3);
112INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Connors', 'Sarah', 1000, 'Caen', NULL, 2);
113INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Seurin', 'Benjamin', 28, 'BDX', NULL, 4);
114INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Charraud', 'Jules', 19, 'Paris', 'Java', 4);
115INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Castener', 'Marie', 21, 'Toulouse', NULL, 4);
116INSERT INTO `mydb`.`personne` (`id`, `nom`, `prenom`, `age`, `lieu`, `langage`, `Resas_idresas`) VALUES (DEFAULT, 'Nacher', 'JB', 22, 'Bordeaux', NULL, 4);
117
118COMMIT;