Ew4NbG69

1-- MySQL Script generated by MySQL Workbench
2-- lun. 01 oct. 2018 16:59:08 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-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `mydb` ;
14
15-- -----------------------------------------------------
16-- Schema mydb
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
19USE `mydb` ;
20
21-- -----------------------------------------------------
22-- Table `mydb`.`Ecole`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `mydb`.`Ecole` ;
25
26CREATE TABLE IF NOT EXISTS `mydb`.`Ecole` (
27  `id` INT NOT NULL AUTO_INCREMENT,
28  `ville` VARCHAR(255) NOT NULL,
29  PRIMARY KEY (`id`))
30ENGINE = InnoDB;
31
32
33-- -----------------------------------------------------
34-- Table `mydb`.`Langage`
35-- -----------------------------------------------------
36DROP TABLE IF EXISTS `mydb`.`Langage` ;
37
38CREATE TABLE IF NOT EXISTS `mydb`.`Langage` (
39  `id` INT NOT NULL AUTO_INCREMENT,
40  `nom_langage` VARCHAR(255) NOT NULL,
41  PRIMARY KEY (`id`))
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `mydb`.`Eleve`
47-- -----------------------------------------------------
48DROP TABLE IF EXISTS `mydb`.`Eleve` ;
49
50CREATE TABLE IF NOT EXISTS `mydb`.`Eleve` (
51  `id` INT NOT NULL AUTO_INCREMENT,
52  `nom` VARCHAR(255) NOT NULL,
53  `prenom` VARCHAR(255) NOT NULL,
54  `adresse` VARCHAR(255) NOT NULL,
55  `Ecole_id` INT NOT NULL,
56  `Langage_id` INT NOT NULL,
57  PRIMARY KEY (`id`, `Ecole_id`, `Langage_id`),
58  INDEX `fk_Eleve_Ecole_idx` (`Ecole_id` ASC),
59  INDEX `fk_Eleve_Langage1_idx` (`Langage_id` ASC))
60ENGINE = InnoDB;
61
62
63SET SQL_MODE=@OLD_SQL_MODE;
64SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
65SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;