x1546j7x

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`.`ecoles`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`ecoles` (
21  `id` INT(11) NOT NULL AUTO_INCREMENT,
22  `villes` VARCHAR(80) NULL DEFAULT NULL,
23  PRIMARY KEY (`id`))
24ENGINE = InnoDB
25AUTO_INCREMENT = 7
26DEFAULT CHARACTER SET = utf8;
27
28
29-- -----------------------------------------------------
30-- Table `mydb`.`langages`
31-- -----------------------------------------------------
32CREATE TABLE IF NOT EXISTS `mydb`.`langages` (
33  `id` INT(11) NOT NULL AUTO_INCREMENT,
34  `langage` VARCHAR(45) NULL DEFAULT NULL,
35  PRIMARY KEY (`id`))
36ENGINE = InnoDB
37DEFAULT CHARACTER SET = utf8;
38
39
40-- -----------------------------------------------------
41-- Table `mydb`.`eleves`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `mydb`.`eleves` (
44  `id` INT NOT NULL AUTO_INCREMENT,
45  `nom` VARCHAR(45) NULL,
46  `adresse` VARCHAR(45) NULL,
47  `prenom` VARCHAR(45) NULL,
48  `ecoles_id` INT(11) NOT NULL,
49  `langages_id` INT(11) NOT NULL,
50  PRIMARY KEY (`id`, `ecoles_id`, `langages_id`),
51  INDEX `fk_eleves_ecoles_idx` (`ecoles_id` ASC),
52  INDEX `fk_eleves_langages1_idx` (`langages_id` ASC),
53  CONSTRAINT `fk_eleves_ecoles`
54    FOREIGN KEY (`ecoles_id`)
55    REFERENCES `mydb`.`ecoles` (`id`)
56    ON DELETE NO ACTION
57    ON UPDATE NO ACTION,
58  CONSTRAINT `fk_eleves_langages1`
59    FOREIGN KEY (`langages_id`)
60    REFERENCES `mydb`.`langages` (`id`)
61    ON DELETE NO ACTION
62    ON UPDATE NO ACTION)
63ENGINE = InnoDB;
64
65
66SET SQL_MODE=@OLD_SQL_MODE;
67SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
68SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
69
70-- -----------------------------------------------------
71-- Data for table `mydb`.`ecoles`
72-- -----------------------------------------------------
73START TRANSACTION;
74USE `mydb`;
75INSERT INTO `mydb`.`ecoles` (`id`, `villes`) VALUES (1, 'Orleans');
76INSERT INTO `mydb`.`ecoles` (`id`, `villes`) VALUES (2, 'Montargis');
77INSERT INTO `mydb`.`ecoles` (`id`, `villes`) VALUES (3, 'Paris');
78
79COMMIT;
80
81
82-- -----------------------------------------------------
83-- Data for table `mydb`.`langages`
84-- -----------------------------------------------------
85START TRANSACTION;
86USE `mydb`;
87INSERT INTO `mydb`.`langages` (`id`, `langage`) VALUES (1, 'PHP');
88INSERT INTO `mydb`.`langages` (`id`, `langage`) VALUES (2, 'Javascript');
89INSERT INTO `mydb`.`langages` (`id`, `langage`) VALUES (3, 'Java');
90
91COMMIT;
92
93
94-- -----------------------------------------------------
95-- Data for table `mydb`.`eleves`
96-- -----------------------------------------------------
97START TRANSACTION;
98USE `mydb`;
99INSERT INTO `mydb`.`eleves` (`id`, `nom`, `adresse`, `prenom`, `ecoles_id`, `langages_id`) VALUES (1, 'Google', 'Paris', 'Chrome', 3, 2);
100INSERT INTO `mydb`.`eleves` (`id`, `nom`, `adresse`, `prenom`, `ecoles_id`, `langages_id`) VALUES (2, 'Pester', 'Paris', 'Lorie', 3, 2);
101INSERT INTO `mydb`.`eleves` (`id`, `nom`, `adresse`, `prenom`, `ecoles_id`, `langages_id`) VALUES (3, 'Milon', 'Montargis', 'Teddy', 2, 3);
102INSERT INTO `mydb`.`eleves` (`id`, `nom`, `adresse`, `prenom`, `ecoles_id`, `langages_id`) VALUES (4, 'Francois', 'Orleans', 'Nicolas', 1, 1);
103INSERT INTO `mydb`.`eleves` (`id`, `nom`, `adresse`, `prenom`, `ecoles_id`, `langages_id`) VALUES (5, 'Hoarau', 'Orleans', 'Mathieu', 1, 1);
104
105COMMIT;