· 8 years ago · Apr 26, 2018, 04:42 PM
1-- MySQL Script generated by MySQL Workbench
2-- 04/26/18 18:36:42
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 ProjetStarcraftFinal
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `ProjetStarcraftFinal` ;
14
15-- -----------------------------------------------------
16-- Schema ProjetStarcraftFinal
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `ProjetStarcraftFinal` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
19USE `ProjetStarcraftFinal` ;
20
21-- -----------------------------------------------------
22-- Table `ProjetStarcraftFinal`.`USER`
23-- -----------------------------------------------------
24DROP TABLE IF EXISTS `ProjetStarcraftFinal`.`USER` ;
25
26CREATE TABLE IF NOT EXISTS `ProjetStarcraftFinal`.`USER` (
27 `idUSER` INT NOT NULL AUTO_INCREMENT COMMENT '',
28 `nom` VARCHAR(45) NOT NULL COMMENT '',
29 `prenom` VARCHAR(45) NOT NULL COMMENT '',
30 `mail` VARCHAR(45) NOT NULL COMMENT '',
31 `mdp` VARCHAR(45) NOT NULL COMMENT '',
32 `type` INT NOT NULL COMMENT '',
33 PRIMARY KEY (`idUSER`) COMMENT '')
34ENGINE = InnoDB;
35
36
37-- -----------------------------------------------------
38-- Table `ProjetStarcraftFinal`.`Liste`
39-- -----------------------------------------------------
40DROP TABLE IF EXISTS `ProjetStarcraftFinal`.`Liste` ;
41
42CREATE TABLE IF NOT EXISTS `ProjetStarcraftFinal`.`Liste` (
43 `idListe` INT NOT NULL COMMENT '',
44 `USER_idUSER` INT NOT NULL COMMENT '',
45 `dateCreer` DATE NOT NULL COMMENT '',
46 `dateModif` DATE NULL COMMENT '',
47 PRIMARY KEY (`idListe`) COMMENT '',
48 CONSTRAINT `fk_Liste_USER`
49 FOREIGN KEY (`USER_idUSER`)
50 REFERENCES `ProjetStarcraftFinal`.`USER` (`idUSER`)
51 ON DELETE NO ACTION
52 ON UPDATE NO ACTION)
53ENGINE = InnoDB;
54
55CREATE INDEX `fk_Liste_USER_idx` ON `ProjetStarcraftFinal`.`Liste` (`USER_idUSER` ASC) COMMENT '';
56
57
58-- -----------------------------------------------------
59-- Table `ProjetStarcraftFinal`.`Type`
60-- -----------------------------------------------------
61DROP TABLE IF EXISTS `ProjetStarcraftFinal`.`Type` ;
62
63CREATE TABLE IF NOT EXISTS `ProjetStarcraftFinal`.`Type` (
64 `idType` INT NOT NULL COMMENT '',
65 `nom` VARCHAR(45) NULL COMMENT '',
66 PRIMARY KEY (`idType`) COMMENT '')
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table `ProjetStarcraftFinal`.`Race`
72-- -----------------------------------------------------
73DROP TABLE IF EXISTS `ProjetStarcraftFinal`.`Race` ;
74
75CREATE TABLE IF NOT EXISTS `ProjetStarcraftFinal`.`Race` (
76 `idRace` INT NOT NULL COMMENT '',
77 `nom` VARCHAR(45) NULL COMMENT '',
78 `texte` LONGTEXT NULL COMMENT '',
79 `image` VARCHAR(255) NULL COMMENT '',
80 PRIMARY KEY (`idRace`) COMMENT '')
81ENGINE = InnoDB;
82
83
84-- -----------------------------------------------------
85-- Table `ProjetStarcraftFinal`.`UNITE`
86-- -----------------------------------------------------
87DROP TABLE IF EXISTS `ProjetStarcraftFinal`.`UNITE` ;
88
89CREATE TABLE IF NOT EXISTS `ProjetStarcraftFinal`.`UNITE` (
90 `idUNITE` INT NOT NULL COMMENT '',
91 `nom` VARCHAR(45) NOT NULL COMMENT '',
92 `vie` INT NOT NULL COMMENT '',
93 `armure` INT NOT NULL COMMENT '',
94 `degats` INT NOT NULL COMMENT '',
95 `shield` INT NULL COMMENT '',
96 `Type_idType` INT NOT NULL COMMENT '',
97 `Race_idRace` INT NOT NULL COMMENT '',
98 PRIMARY KEY (`idUNITE`, `Type_idType`) COMMENT '',
99 CONSTRAINT `fk_UNITE_Type1`
100 FOREIGN KEY (`Type_idType`)
101 REFERENCES `ProjetStarcraftFinal`.`Type` (`idType`)
102 ON DELETE NO ACTION
103 ON UPDATE NO ACTION,
104 CONSTRAINT `fk_UNITE_Race1`
105 FOREIGN KEY (`Race_idRace`)
106 REFERENCES `ProjetStarcraftFinal`.`Race` (`idRace`)
107 ON DELETE NO ACTION
108 ON UPDATE NO ACTION)
109ENGINE = InnoDB;
110
111CREATE INDEX `fk_UNITE_Type1_idx` ON `ProjetStarcraftFinal`.`UNITE` (`Type_idType` ASC) COMMENT '';
112
113CREATE INDEX `fk_UNITE_Race1_idx` ON `ProjetStarcraftFinal`.`UNITE` (`Race_idRace` ASC) COMMENT '';
114
115
116-- -----------------------------------------------------
117-- Table `ProjetStarcraftFinal`.`CONTIENT`
118-- -----------------------------------------------------
119DROP TABLE IF EXISTS `ProjetStarcraftFinal`.`CONTIENT` ;
120
121CREATE TABLE IF NOT EXISTS `ProjetStarcraftFinal`.`CONTIENT` (
122 `idCONTIENT` INT NOT NULL COMMENT '',
123 `creation` INT NOT NULL COMMENT '',
124 `Liste_idListe` INT NOT NULL COMMENT '',
125 `UNITE_idUNITE` INT NOT NULL COMMENT '',
126 PRIMARY KEY (`idCONTIENT`) COMMENT '',
127 CONSTRAINT `fk_CONTIENT_Liste1`
128 FOREIGN KEY (`Liste_idListe`)
129 REFERENCES `ProjetStarcraftFinal`.`Liste` (`idListe`)
130 ON DELETE NO ACTION
131 ON UPDATE NO ACTION,
132 CONSTRAINT `fk_CONTIENT_UNITE1`
133 FOREIGN KEY (`UNITE_idUNITE`)
134 REFERENCES `ProjetStarcraftFinal`.`UNITE` (`idUNITE`)
135 ON DELETE NO ACTION
136 ON UPDATE NO ACTION)
137ENGINE = InnoDB;
138
139CREATE INDEX `fk_CONTIENT_Liste1_idx` ON `ProjetStarcraftFinal`.`CONTIENT` (`Liste_idListe` ASC) COMMENT '';
140
141CREATE INDEX `fk_CONTIENT_UNITE1_idx` ON `ProjetStarcraftFinal`.`CONTIENT` (`UNITE_idUNITE` ASC) COMMENT '';
142
143
144SET SQL_MODE=@OLD_SQL_MODE;
145SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
146SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;