gvjzpnrV

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 soufflerie
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema soufflerie
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `soufflerie` DEFAULT CHARACTER SET utf8 ;
15USE `soufflerie` ;
16
17-- -----------------------------------------------------
18-- Table `soufflerie`.`scenario`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `soufflerie`.`scenario` (
21  `id` INT ZEROFILL NOT NULL,
22  `nom` VARCHAR(255) NOT NULL,
23  PRIMARY KEY (`id`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `soufflerie`.`phase`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `soufflerie`.`phase` (
31  `id` INT NOT NULL AUTO_INCREMENT,
32  `fk_scenario` INT NOT NULL,
33  `temps` INT NOT NULL,
34  `puissance` INT NOT NULL,
35  PRIMARY KEY (`id`),
36  INDEX `test_idx` (`fk_scenario` ASC),
37  CONSTRAINT `fkk_scenario`
38    FOREIGN KEY (`fk_scenario`)
39    REFERENCES `soufflerie`.`scenario` (`id`)
40    ON DELETE NO ACTION
41    ON UPDATE NO ACTION)
42ENGINE = InnoDB;
43
44
45-- -----------------------------------------------------
46-- Table `soufflerie`.`capteurs`
47-- -----------------------------------------------------
48CREATE TABLE IF NOT EXISTS `soufflerie`.`capteurs` (
49  `id` INT NOT NULL AUTO_INCREMENT,
50  `nom` VARCHAR(45) NOT NULL,
51  PRIMARY KEY (`id`))
52ENGINE = InnoDB;
53
54
55-- -----------------------------------------------------
56-- Table `soufflerie`.`etatCapteur`
57-- -----------------------------------------------------
58CREATE TABLE IF NOT EXISTS `soufflerie`.`etatCapteur` (
59  `id` INT NOT NULL AUTO_INCREMENT,
60  `fk_capteur` INT NOT NULL,
61  `relevé` DATETIME NOT NULL,
62  PRIMARY KEY (`id`),
63  INDEX `fk_capteur_idx` (`fk_capteur` ASC),
64  CONSTRAINT `fk_capteur`
65    FOREIGN KEY (`fk_capteur`)
66    REFERENCES `soufflerie`.`capteurs` (`id`)
67    ON DELETE NO ACTION
68    ON UPDATE NO ACTION)
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `soufflerie`.`resultat`
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS `soufflerie`.`resultat` (
76  `id` INT NOT NULL AUTO_INCREMENT,
77  `fk_scenario` INT NOT NULL,
78  `fk_phase` INT NOT NULL,
79  `puissance` INT NOT NULL,
80  `vent` INT NOT NULL,
81  PRIMARY KEY (`id`),
82  INDEX `fk_scenario_idx` (`fk_scenario` ASC),
83  INDEX `fk_phase_idx` (`fk_phase` ASC),
84  CONSTRAINT `fk_scenario`
85    FOREIGN KEY (`fk_scenario`)
86    REFERENCES `soufflerie`.`scenario` (`id`)
87    ON DELETE NO ACTION
88    ON UPDATE NO ACTION,
89  CONSTRAINT `fk_phase`
90    FOREIGN KEY (`fk_phase`)
91    REFERENCES `soufflerie`.`phase` (`id`)
92    ON DELETE NO ACTION
93    ON UPDATE NO ACTION)
94ENGINE = InnoDB;
95
96
97-- -----------------------------------------------------
98-- Table `soufflerie`.`direct`
99-- -----------------------------------------------------
100CREATE TABLE IF NOT EXISTS `soufflerie`.`direct` (
101  `id` INT NOT NULL,
102  `puissance` INT NOT NULL,
103  `vent` INT NOT NULL,
104  PRIMARY KEY (`id`))
105ENGINE = InnoDB;
106
107
108SET SQL_MODE=@OLD_SQL_MODE;
109SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
110SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;