5vswptks

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-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15-- -----------------------------------------------------
16-- Schema Oui
17-- -----------------------------------------------------
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Ecole`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Ecole` (
24  `Ecoleid` INT(11) NOT NULL AUTO_INCREMENT,
25  `ville` VARCHAR(150) NOT NULL,
26  `capacite` INT(11) NOT NULL,
27  PRIMARY KEY (`Ecoleid`))
28ENGINE = InnoDB
29DEFAULT CHARACTER SET = utf8;
30
31
32-- -----------------------------------------------------
33-- Table `mydb`.`Langage`
34-- -----------------------------------------------------
35CREATE TABLE IF NOT EXISTS `mydb`.`Langage` (
36  `idLangage` INT NOT NULL,
37  `Langage` VARCHAR(150) NOT NULL,
38  PRIMARY KEY (`idLangage`))
39ENGINE = InnoDB
40DEFAULT CHARACTER SET = utf8;
41
42
43-- -----------------------------------------------------
44-- Table `mydb`.`Ecole_has_Langage`
45-- -----------------------------------------------------
46CREATE TABLE IF NOT EXISTS `mydb`.`Ecole_has_Langage` (
47  `Ecole_Ecoleid` INT(11) NOT NULL,
48  `Langage_idLangage` INT(11) NOT NULL,
49  PRIMARY KEY (`Ecole_Ecoleid`, `Langage_idLangage`),
50  INDEX `fk_Ecole_has_Langage_Langage1_idx` (`Langage_idLangage` ASC),
51  INDEX `fk_Ecole_has_Langage_Ecole1_idx` (`Ecole_Ecoleid` ASC),
52  CONSTRAINT `fk_Ecole_has_Langage_Ecole1`
53    FOREIGN KEY (`Ecole_Ecoleid` , `Langage_idLangage`)
54    REFERENCES `mydb`.`Ecole` (`Ecoleid` , `Ecoleid`)
55    ON DELETE NO ACTION
56    ON UPDATE NO ACTION,
57  CONSTRAINT `fk_Ecole_has_Langage_Langage1`
58    FOREIGN KEY (`Langage_idLangage`)
59    REFERENCES `mydb`.`Langage` (`idLangage`)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION)
62ENGINE = InnoDB
63DEFAULT CHARACTER SET = utf8;
64
65
66-- -----------------------------------------------------
67-- Table `mydb`.`Eleve`
68-- -----------------------------------------------------
69CREATE TABLE IF NOT EXISTS `mydb`.`Eleve` (
70  `idEleve` INT(11) NOT NULL AUTO_INCREMENT,
71  `prenom` VARCHAR(150) NOT NULL,
72  `nom` VARCHAR(150) NOT NULL,
73  `date_naissance` DATE NOT NULL,
74  `Adresse` TEXT NOT NULL,
75  `Ecole_Ecoleid` INT(11) NOT NULL,
76  PRIMARY KEY (`idEleve`, `Ecole_Ecoleid`),
77  INDEX `fk_Eleve_Ecole_idx` (`Ecole_Ecoleid` ASC),
78  CONSTRAINT `fk_Eleve_Ecole`
79    FOREIGN KEY (`Ecole_Ecoleid`)
80    REFERENCES `mydb`.`Ecole` (`Ecoleid`)
81    ON DELETE NO ACTION
82    ON UPDATE NO ACTION)
83ENGINE = InnoDB
84DEFAULT CHARACTER SET = utf8;
85
86
87SET SQL_MODE=@OLD_SQL_MODE;
88SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
89SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
90
91-- -----------------------------------------------------
92-- Data for table `mydb`.`Ecole`
93-- -----------------------------------------------------
94START TRANSACTION;
95USE `mydb`;
96INSERT INTO `mydb`.`Ecole` (`Ecoleid`, `ville`, `capacite`) VALUES (DEFAULT, 'Orléans', DEFAULT);
97INSERT INTO `mydb`.`Ecole` (`Ecoleid`, `ville`, `capacite`) VALUES (DEFAULT, 'Paris', DEFAULT);
98INSERT INTO `mydb`.`Ecole` (`Ecoleid`, `ville`, `capacite`) VALUES (DEFAULT, 'Bordeaux', DEFAULT);
99
100COMMIT;
101
102
103-- -----------------------------------------------------
104-- Data for table `mydb`.`Langage`
105-- -----------------------------------------------------
106START TRANSACTION;
107USE `mydb`;
108INSERT INTO `mydb`.`Langage` (`idLangage`, `Langage`) VALUES (DEFAULT, 'PHP');
109INSERT INTO `mydb`.`Langage` (`idLangage`, `Langage`) VALUES (DEFAULT, 'JavaScript');
110INSERT INTO `mydb`.`Langage` (`idLangage`, `Langage`) VALUES (DEFAULT, 'Java');
111
112COMMIT;
113
114
115-- -----------------------------------------------------
116-- Data for table `mydb`.`Ecole_has_Langage`
117-- -----------------------------------------------------
118START TRANSACTION;
119USE `mydb`;
120INSERT INTO `mydb`.`Ecole_has_Langage` (`Ecole_Ecoleid`, `Langage_idLangage`) VALUES (1, 1);
121INSERT INTO `mydb`.`Ecole_has_Langage` (`Ecole_Ecoleid`, `Langage_idLangage`) VALUES (2, 2);
122INSERT INTO `mydb`.`Ecole_has_Langage` (`Ecole_Ecoleid`, `Langage_idLangage`) VALUES (2, 3);
123
124COMMIT;
125
126
127-- -----------------------------------------------------
128-- Data for table `mydb`.`Eleve`
129-- -----------------------------------------------------
130START TRANSACTION;
131USE `mydb`;
132INSERT INTO `mydb`.`Eleve` (`idEleve`, `prenom`, `nom`, `date_naissance`, `Adresse`, `Ecole_Ecoleid`) VALUES (DEFAULT, 'Laurie', 'Jcp', '01-01-0001', 'Inconnue', 2);
133INSERT INTO `mydb`.`Eleve` (`idEleve`, `prenom`, `nom`, `date_naissance`, `Adresse`, `Ecole_Ecoleid`) VALUES (DEFAULT, 'Google', 'MeilleurAmi', '02-01-0001', 'Silicon Valley', 1);
134INSERT INTO `mydb`.`Eleve` (`idEleve`, `prenom`, `nom`, `date_naissance`, `Adresse`, `Ecole_Ecoleid`) VALUES (DEFAULT, 'Tom', 'Guibard', '17-05-2000', 'Sully', 1);
135INSERT INTO `mydb`.`Eleve` (`idEleve`, `prenom`, `nom`, `date_naissance`, `Adresse`, `Ecole_Ecoleid`) VALUES (DEFAULT, 'Melissa', 'Viltet', '14-02-1982', 'Blois', 3);
136INSERT INTO `mydb`.`Eleve` (`idEleve`, `prenom`, `nom`, `date_naissance`, `Adresse`, `Ecole_Ecoleid`) VALUES (DEFAULT, 'Thomas', 'Pecout', '28-08-1994', DEFAULT, 3);
137
138COMMIT;