ESrmdPSz

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10-- -----------------------------------------------------
11-- Schema florence_g_wcs_orleans
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema florence_g_wcs_orleans
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `florence_g_wcs_orleans` DEFAULT CHARACTER SET latin1 ;
18USE `florence_g_wcs_orleans` ;
19
20-- -----------------------------------------------------
21-- Table `florence_g_wcs_orleans`.`Ecole`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `florence_g_wcs_orleans`.`Ecole` (
24  `id` INT(11) NOT NULL AUTO_INCREMENT,
25  `Ville` VARCHAR(250) NOT NULL,
26  PRIMARY KEY (`id`))
27ENGINE = InnoDB
28AUTO_INCREMENT = 3
29DEFAULT CHARACTER SET = latin1;
30
31
32-- -----------------------------------------------------
33-- Table `florence_g_wcs_orleans`.`Eleve`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `florence_g_wcs_orleans`.`Eleve` (
36  `id` INT(11) NOT NULL AUTO_INCREMENT,
37  `nom` VARCHAR(250) NULL DEFAULT NULL,
38  `prenom` VARCHAR(250) NULL DEFAULT NULL,
39  `adresse` TEXT NULL DEFAULT NULL,
40  `Ecole_id` INT(11) NOT NULL,
41  PRIMARY KEY (`id`, `Ecole_id`),
42  INDEX `fk_Eleve_Ecole1_idx` (`Ecole_id` ASC),
43  CONSTRAINT `fk_Eleve_Ecole1`
44    FOREIGN KEY (`Ecole_id`)
45    REFERENCES `florence_g_wcs_orleans`.`Ecole` (`id`)
46    ON DELETE NO ACTION
47    ON UPDATE NO ACTION)
48ENGINE = InnoDB
49AUTO_INCREMENT = 6
50DEFAULT CHARACTER SET = latin1;
51
52
53-- -----------------------------------------------------
54-- Table `florence_g_wcs_orleans`.`Langage`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `florence_g_wcs_orleans`.`Langage` (
57  `id` INT(11) NOT NULL AUTO_INCREMENT,
58  `nom` VARCHAR(250) NOT NULL,
59  PRIMARY KEY (`id`))
60ENGINE = InnoDB
61AUTO_INCREMENT = 4
62DEFAULT CHARACTER SET = latin1;
63
64
65-- -----------------------------------------------------
66-- Table `florence_g_wcs_orleans`.`Langage_ecole`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `florence_g_wcs_orleans`.`Langage_ecole` (
69  `id` INT(11) NOT NULL AUTO_INCREMENT,
70  `langage_id` INT(11) NOT NULL,
71  `ecole_id` INT(11) NOT NULL,
72  PRIMARY KEY (`id`),
73  INDEX `fk_Langage_ecole_1_idx` (`ecole_id` ASC),
74  INDEX `fk_Langage_ecole_2_idx` (`langage_id` ASC),
75  CONSTRAINT `fk_Langage_ecole_1`
76    FOREIGN KEY (`ecole_id`)
77    REFERENCES `florence_g_wcs_orleans`.`Ecole` (`id`)
78    ON DELETE CASCADE
79    ON UPDATE CASCADE,
80  CONSTRAINT `fk_Langage_ecole_2`
81    FOREIGN KEY (`langage_id`)
82    REFERENCES `florence_g_wcs_orleans`.`Langage` (`id`)
83    ON DELETE CASCADE
84    ON UPDATE CASCADE)
85ENGINE = InnoDB
86DEFAULT CHARACTER SET = latin1;
87
88
89SET SQL_MODE=@OLD_SQL_MODE;
90SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
91SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
92
93-- -----------------------------------------------------
94-- Data for table `florence_g_wcs_orleans`.`Ecole`
95-- -----------------------------------------------------
96START TRANSACTION;
97USE `florence_g_wcs_orleans`;
98INSERT INTO `florence_g_wcs_orleans`.`Ecole` (`id`, `Ville`) VALUES (DEFAULT, 'Paris');
99INSERT INTO `florence_g_wcs_orleans`.`Ecole` (`id`, `Ville`) VALUES (DEFAULT, 'Orleans');
100INSERT INTO `florence_g_wcs_orleans`.`Ecole` (`id`, `Ville`) VALUES (DEFAULT, 'Bordeaux');
101
102COMMIT;
103
104
105-- -----------------------------------------------------
106-- Data for table `florence_g_wcs_orleans`.`Eleve`
107-- -----------------------------------------------------
108START TRANSACTION;
109USE `florence_g_wcs_orleans`;
110INSERT INTO `florence_g_wcs_orleans`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`) VALUES (, 'Google', 'Google', 'Boulevard des Aires Paris', 1);
111INSERT INTO `florence_g_wcs_orleans`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`) VALUES (DEFAULT, 'Star', 'Lorie', 'Avenue C\'est ma meilleur Amie Avignon', 2);
112INSERT INTO `florence_g_wcs_orleans`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`) VALUES (DEFAULT, 'Napoleon', 'Josephine', 'Rue du pendu l\'Ile Saint Helène ', 3);
113INSERT INTO `florence_g_wcs_orleans`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`) VALUES (DEFAULT, 'Maupertus', 'Claudius', 'Terminus du square glandu Bergerac', 3);
114INSERT INTO `florence_g_wcs_orleans`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`) VALUES (DEFAULT, 'Laparesse', 'Walter', 'Rue du val dormeur Montmartre', 1);
115
116COMMIT;
117
118
119-- -----------------------------------------------------
120-- Data for table `florence_g_wcs_orleans`.`Langage`
121-- -----------------------------------------------------
122START TRANSACTION;
123USE `florence_g_wcs_orleans`;
124INSERT INTO `florence_g_wcs_orleans`.`Langage` (`id`, `nom`) VALUES (DEFAULT, 'PHP');
125INSERT INTO `florence_g_wcs_orleans`.`Langage` (`id`, `nom`) VALUES (DEFAULT, 'JavaScript');
126INSERT INTO `florence_g_wcs_orleans`.`Langage` (`id`, `nom`) VALUES (DEFAULT, 'Java');
127
128COMMIT;
129
130
131-- -----------------------------------------------------
132-- Data for table `florence_g_wcs_orleans`.`Langage_ecole`
133-- -----------------------------------------------------
134START TRANSACTION;
135USE `florence_g_wcs_orleans`;
136INSERT INTO `florence_g_wcs_orleans`.`Langage_ecole` (`id`, `langage_id`, `ecole_id`) VALUES (, 1, 3);
137INSERT INTO `florence_g_wcs_orleans`.`Langage_ecole` (`id`, `langage_id`, `ecole_id`) VALUES (DEFAULT, 2, 2);
138INSERT INTO `florence_g_wcs_orleans`.`Langage_ecole` (`id`, `langage_id`, `ecole_id`) VALUES (DEFAULT, 3, 1);
139
140COMMIT;