Qu1H74ki

1-- MySQL Script generated by MySQL Workbench
2-- mar. 25 sept. 2018 10:19:18 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 Patricia_b_wcs_orleans
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema Patricia_b_wcs_orleans
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `Patricia_b_wcs_orleans` DEFAULT CHARACTER SET utf8 ;
18USE `Patricia_b_wcs_orleans` ;
19
20-- -----------------------------------------------------
21-- Table `Patricia_b_wcs_orleans`.`langage`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `Patricia_b_wcs_orleans`.`langage` (
24  `idlangage` INT NOT NULL,
25  `name` VARCHAR(45) NULL,
26  PRIMARY KEY (`idlangage`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `Patricia_b_wcs_orleans`.`school`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `Patricia_b_wcs_orleans`.`school` (
34  `idschool` INT NOT NULL,
35  `city` VARCHAR(45) NULL,
36  PRIMARY KEY (`idschool`))
37ENGINE = InnoDB;
38
39
40-- -----------------------------------------------------
41-- Table `Patricia_b_wcs_orleans`.`eleve`
42-- -----------------------------------------------------
43CREATE TABLE IF NOT EXISTS `Patricia_b_wcs_orleans`.`eleve` (
44  `ideleve` INT NOT NULL AUTO_INCREMENT,
45  `firstname` VARCHAR(45) NULL,
46  `lastname` VARCHAR(45) NULL,
47  `adress` VARCHAR(45) NULL,
48  `langage_idlangage` INT NULL,
49  `school_idschool` INT NULL,
50  PRIMARY KEY (`ideleve`),
51  INDEX `fk_eleve_langage_idx` (`langage_idlangage` ASC),
52  INDEX `fk_eleve_school1_idx` (`school_idschool` ASC),
53  CONSTRAINT `fk_eleve_langage`
54    FOREIGN KEY (`langage_idlangage`)
55    REFERENCES `Patricia_b_wcs_orleans`.`langage` (`idlangage`)
56    ON DELETE NO ACTION
57    ON UPDATE NO ACTION,
58  CONSTRAINT `fk_eleve_school1`
59    FOREIGN KEY (`school_idschool`)
60    REFERENCES `Patricia_b_wcs_orleans`.`school` (`idschool`)
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 `Patricia_b_wcs_orleans`.`langage`
72-- -----------------------------------------------------
73START TRANSACTION;
74USE `Patricia_b_wcs_orleans`;
75INSERT INTO `Patricia_b_wcs_orleans`.`langage` (`idlangage`, `name`) VALUES (1, 'php');
76INSERT INTO `Patricia_b_wcs_orleans`.`langage` (`idlangage`, `name`) VALUES (2, 'javascript');
77INSERT INTO `Patricia_b_wcs_orleans`.`langage` (`idlangage`, `name`) VALUES (3, 'java');
78
79COMMIT;
80
81
82-- -----------------------------------------------------
83-- Data for table `Patricia_b_wcs_orleans`.`school`
84-- -----------------------------------------------------
85START TRANSACTION;
86USE `Patricia_b_wcs_orleans`;
87INSERT INTO `Patricia_b_wcs_orleans`.`school` (`idschool`, `city`) VALUES (1, 'Lyon');
88INSERT INTO `Patricia_b_wcs_orleans`.`school` (`idschool`, `city`) VALUES (2, 'Orléans');
89
90COMMIT;
91
92
93-- -----------------------------------------------------
94-- Data for table `Patricia_b_wcs_orleans`.`eleve`
95-- -----------------------------------------------------
96START TRANSACTION;
97USE `Patricia_b_wcs_orleans`;
98INSERT INTO `Patricia_b_wcs_orleans`.`eleve` (`ideleve`, `firstname`, `lastname`, `adress`, `langage_idlangage`, `school_idschool`) VALUES (1, 'google', 'google', '14 RUE DE LA SOURCE', 1, 1);
99INSERT INTO `Patricia_b_wcs_orleans`.`eleve` (`ideleve`, `firstname`, `lastname`, `adress`, `langage_idlangage`, `school_idschool`) VALUES (2, 'laurie', 'chanteuse', '35 rue des illusions', 2, 2);
100INSERT INTO `Patricia_b_wcs_orleans`.`eleve` (`ideleve`, `firstname`, `lastname`, `adress`, `langage_idlangage`, `school_idschool`) VALUES (3, 'martin', 'dupont', '26 bd de la routine', 3, 1);
101INSERT INTO `Patricia_b_wcs_orleans`.`eleve` (`ideleve`, `firstname`, `lastname`, `adress`, `langage_idlangage`, `school_idschool`) VALUES (4, 'louis', 'braquet', '6 rue des chaussees', 1, 1);
102INSERT INTO `Patricia_b_wcs_orleans`.`eleve` (`ideleve`, `firstname`, `lastname`, `adress`, `langage_idlangage`, `school_idschool`) VALUES (5, 'Lucie', 'coulomb', '14 rue martin', 3, 2);
103
104COMMIT;