· 8 years ago · Apr 17, 2018, 04:22 AM
1-- MySQL Script generated by MySQL Workbench
2-- Mon Apr 9 12:14:57 2018
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 simon_r_wcs_bdx
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema simon_r_wcs_bdx
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `simon_r_wcs_bdx` DEFAULT CHARACTER SET latin1 ;
18USE `simon_r_wcs_bdx` ;
19
20-- -----------------------------------------------------
21-- Table `simon_r_wcs_bdx`.`Salles`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `simon_r_wcs_bdx`.`Salles` (
24 `idSalles` INT(11) NOT NULL AUTO_INCREMENT,
25 `name` VARCHAR(50) NULL DEFAULT NULL,
26 PRIMARY KEY (`idSalles`))
27ENGINE = InnoDB
28AUTO_INCREMENT = 7
29DEFAULT CHARACTER SET = latin1;
30
31
32-- -----------------------------------------------------
33-- Table `simon_r_wcs_bdx`.`promo`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `simon_r_wcs_bdx`.`promo` (
36 `id` INT(11) NOT NULL,
37 `Nom` VARCHAR(30) NULL DEFAULT NULL,
38 `Prenom` VARCHAR(30) NULL DEFAULT NULL,
39 `Age` INT(11) NULL DEFAULT NULL,
40 `Lieu` VARCHAR(30) NULL DEFAULT NULL,
41 PRIMARY KEY (`id`))
42ENGINE = InnoDB
43DEFAULT CHARACTER SET = latin1;
44
45
46-- -----------------------------------------------------
47-- Table `simon_r_wcs_bdx`.`Reservations`
48-- -----------------------------------------------------
49CREATE TABLE IF NOT EXISTS `simon_r_wcs_bdx`.`Reservations` (
50 `idReservations` INT NOT NULL AUTO_INCREMENT,
51 `date` DATETIME NOT NULL,
52 `idSalles` INT NULL,
53 `idpromo` INT NULL,
54 PRIMARY KEY (`idReservations`),
55 INDEX `idSalles_idx` (`idSalles` ASC),
56 INDEX `id promo_idx` (`idpromo` ASC),
57 CONSTRAINT `id promo`
58 FOREIGN KEY (`idpromo`)
59 REFERENCES `simon_r_wcs_bdx`.`promo` (`id`)
60 ON DELETE NO ACTION
61 ON UPDATE NO ACTION,
62 CONSTRAINT `idSalles`
63 FOREIGN KEY (`idSalles`)
64 REFERENCES `simon_r_wcs_bdx`.`Salles` (`idSalles`)
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 `simon_r_wcs_bdx`.`Salles`
76-- -----------------------------------------------------
77START TRANSACTION;
78USE `simon_r_wcs_bdx`;
79INSERT INTO `simon_r_wcs_bdx`.`Salles` (`idSalles`, `name`) VALUES (1, 'Salle de dojo');
80INSERT INTO `simon_r_wcs_bdx`.`Salles` (`idSalles`, `name`) VALUES (2, 'Salle de réunion');
81INSERT INTO `simon_r_wcs_bdx`.`Salles` (`idSalles`, `name`) VALUES (3, 'Salle de repos');
82INSERT INTO `simon_r_wcs_bdx`.`Salles` (`idSalles`, `name`) VALUES (4, 'Cuisine');
83INSERT INTO `simon_r_wcs_bdx`.`Salles` (`idSalles`, `name`) VALUES (5, 'Bureau');
84INSERT INTO `simon_r_wcs_bdx`.`Salles` (`idSalles`, `name`) VALUES (6, 'OpenSpace');
85
86COMMIT;
87
88
89-- -----------------------------------------------------
90-- Data for table `simon_r_wcs_bdx`.`promo`
91-- -----------------------------------------------------
92START TRANSACTION;
93USE `simon_r_wcs_bdx`;
94INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (1, 'Fett', 'Boba', 45, 'Tatouine');
95INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (2, 'McFly', 'Marty', 30, 'Los Angeles');
96INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (3, 'Deckard', 'Rick', 30, 'Los Angeles');
97INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (4, 'Organa', 'Leia', 29, 'Alderaan');
98INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (5, 'Darkhölme', 'Raven', 33, 'San Francisco');
99INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (6, 'Laurie', '...', 35, 'France');
100INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (7, 'Google', '...', 99, 'Silicon');
101INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (8, 'Howlett', 'James', 250, 'USA');
102INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (9, 'Monroe', 'Marilyn', 90, 'Los Angeles');
103INSERT INTO `simon_r_wcs_bdx`.`promo` (`id`, `Nom`, `Prenom`, `Age`, `Lieu`) VALUES (10, 'Zaraï', 'Rika', 80, 'Palestine');
104
105COMMIT;
106
107
108-- -----------------------------------------------------
109-- Data for table `simon_r_wcs_bdx`.`Reservations`
110-- -----------------------------------------------------
111START TRANSACTION;
112USE `simon_r_wcs_bdx`;
113INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (1, '9999-12-31 23:59:59','12:30', 1, 1);
114INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (2, '9999-12-31 23:59:34','12:40', 1, 2);
115INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (3, '9999-12-31 23:59:45','12:30', 1, 3);
116INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (4, '9999-12-30 23:59:34','12:20', 5, 4);
117INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (5, '9999-12-30 23:59:20','12:50', 5, 5);
118INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (6, '9999-12-29 23:59:04','12:40', 3, 6);
119INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (7, '9999-11-29 23:59:04','12:30', 6, 7);
120INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (8, '9999-07-29 23:59:04','12:10', 6, 8);
121INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (9, '9999-08-29 23:59:04','12:15', 6, 9);
122INSERT INTO `simon_r_wcs_bdx`.`Reservations` (`idReservations`, `date`,`duree`, `idSalles`, `idpromo`) VALUES (10, '9999-07-29 23:59:31','12:30', 6, 10);
123
124COMMIT;