· 7 years ago · Oct 02, 2018, 10:02 AM
1-- MySQL Script generated by MySQL Workbench
2-- mar. 02 oct. 2018 09:44:30 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`))
58ENGINE = InnoDB;
59
60
61SET SQL_MODE=@OLD_SQL_MODE;
62SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
63SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
64
65-- -----------------------------------------------------
66-- Data for table `mydb`.`Ecole`
67-- -----------------------------------------------------
68START TRANSACTION;
69USE `mydb`;
70INSERT INTO `mydb`.`Ecole` (`id`, `ville`) VALUES (DEFAULT, 'Paris');
71INSERT INTO `mydb`.`Ecole` (`id`, `ville`) VALUES (DEFAULT, 'Orleans');
72
73COMMIT;
74
75
76-- -----------------------------------------------------
77-- Data for table `mydb`.`Langage`
78-- -----------------------------------------------------
79START TRANSACTION;
80USE `mydb`;
81INSERT INTO `mydb`.`Langage` (`id`, `nom_langage`) VALUES (DEFAULT, 'PHP');
82INSERT INTO `mydb`.`Langage` (`id`, `nom_langage`) VALUES (DEFAULT, 'Javascript');
83INSERT INTO `mydb`.`Langage` (`id`, `nom_langage`) VALUES (DEFAULT, 'Java');
84
85COMMIT;
86
87
88-- -----------------------------------------------------
89-- Data for table `mydb`.`Eleve`
90-- -----------------------------------------------------
91START TRANSACTION;
92USE `mydb`;
93INSERT INTO `mydb`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`, `Langage_id`) VALUES (DEFAULT, 'Millon', 'Teddy', 'Orleans', 2, DEFAULT);
94INSERT INTO `mydb`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`, `Langage_id`) VALUES (DEFAULT, 'Drive', 'Google', 'Paris', 1, DEFAULT);
95INSERT INTO `mydb`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`, `Langage_id`) VALUES (DEFAULT, 'Pester', 'Lorie', 'Paris', 1, DEFAULT);
96INSERT INTO `mydb`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`, `Langage_id`) VALUES (DEFAULT, 'Vivant', 'Billy', 'Orleans', 2, DEFAULT);
97INSERT INTO `mydb`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`, `Langage_id`) VALUES (DEFAULT, 'Francois', 'Nicolas', 'Orleans', 2, DEFAULT);
98INSERT INTO `mydb`.`Eleve` (`id`, `nom`, `prenom`, `adresse`, `Ecole_id`, `Langage_id`) VALUES (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT);
99
100COMMIT;