SYfgu4wj

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 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`Ecole`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Ecole` (
21  `Ecoleid` INT(11) NOT NULL AUTO_INCREMENT,
22  `ville` VARCHAR(150) NOT NULL,
23  `capacite` INT(11) NOT NULL,
24  PRIMARY KEY (`Ecoleid`))
25ENGINE = InnoDB
26DEFAULT CHARACTER SET = utf8;
27
28
29-- -----------------------------------------------------
30-- Table `mydb`.`Langage`
31-- -----------------------------------------------------
32CREATE TABLE IF NOT EXISTS `mydb`.`Langage` (
33  `idLangage` INT NOT NULL,
34  `Langage` VARCHAR(150) NOT NULL,
35  PRIMARY KEY (`idLangage`))
36ENGINE = InnoDB
37DEFAULT CHARACTER SET = utf8;
38
39
40-- -----------------------------------------------------
41-- Table `mydb`.`Ecole_has_Langage`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `mydb`.`Ecole_has_Langage` (
44  `Ecole_Ecoleid` INT(11) NOT NULL,
45  `Langage_idLangage` INT(11) NOT NULL,
46  INDEX `fk_Ecole_has_Langage_Langage1_idx` (`Langage_idLangage` ASC),
47  INDEX `fk_Ecole_has_Langage_Ecole1_idx` (`Ecole_Ecoleid` ASC),
48  CONSTRAINT `fk_Ecole_has_Langage_Ecole1`
49    FOREIGN KEY (`Ecole_Ecoleid`)
50    REFERENCES `mydb`.`Ecole` (`Ecoleid`)
51    ON DELETE NO ACTION
52    ON UPDATE NO ACTION,
53  CONSTRAINT `fk_Ecole_has_Langage_Langage1`
54    FOREIGN KEY (`Langage_idLangage`)
55    REFERENCES `mydb`.`Langage` (`idLangage`)
56    ON DELETE NO ACTION
57    ON UPDATE NO ACTION)
58ENGINE = InnoDB
59DEFAULT CHARACTER SET = utf8;
60
61
62-- -----------------------------------------------------
63-- Table `mydb`.`Eleve`
64-- -----------------------------------------------------
65CREATE TABLE IF NOT EXISTS `mydb`.`Eleve` (
66  `idEleve` INT(11) NOT NULL AUTO_INCREMENT,
67  `prenom` VARCHAR(150) NOT NULL,
68  `nom` VARCHAR(150) NOT NULL,
69  `date_naissance` DATE NOT NULL,
70  `Adresse` TEXT NOT NULL,
71  `Ecole_Ecoleid` INT(11) NOT NULL,
72  PRIMARY KEY (`idEleve`, `Ecole_Ecoleid`),
73  INDEX `fk_Eleve_Ecole_idx` (`Ecole_Ecoleid` ASC),
74  CONSTRAINT `fk_Eleve_Ecole`
75    FOREIGN KEY (`Ecole_Ecoleid`)
76    REFERENCES `mydb`.`Ecole` (`Ecoleid`)
77    ON DELETE NO ACTION
78    ON UPDATE NO ACTION)
79ENGINE = InnoDB
80DEFAULT CHARACTER SET = utf8;
81
82
83SET SQL_MODE=@OLD_SQL_MODE;
84SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
85SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;