· 5 years ago · May 16, 2020, 01:36 PM
1-- MySQL Script generated by MySQL Workbench
2-- Sat May 16 15:32:51 2020
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-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema mydb
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
18USE `mydb` ;
19
20-- -----------------------------------------------------
21-- Table `mydb`.`Classe`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `mydb`.`Classe` (
24 `idClasse` INT NOT NULL AUTO_INCREMENT,
25 `ClasseName` VARCHAR(45) NULL,
26 PRIMARY KEY (`idClasse`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `mydb`.`Meneur`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `mydb`.`Meneur` (
34 `username` VARCHAR(16) NOT NULL,
35 `email` VARCHAR(255) NULL,
36 `password` VARCHAR(32) NOT NULL,
37 `create_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
38 `Classe_idClasse` INT NOT NULL,
39 `GuildeName` VARCHAR(45) NULL,
40 `Niveau` INT NULL,
41 INDEX `fk_Meneur_Classe1_idx` (`Classe_idClasse` ASC),
42 CONSTRAINT `fk_Meneur_Classe1`
43 FOREIGN KEY (`Classe_idClasse`)
44 REFERENCES `mydb`.`Classe` (`idClasse`)
45 ON DELETE NO ACTION
46 ON UPDATE NO ACTION);
47
48
49-- -----------------------------------------------------
50-- Table `mydb`.`Guilde`
51-- -----------------------------------------------------
52CREATE TABLE IF NOT EXISTS `mydb`.`Guilde` (
53 `idGuilde` INT NOT NULL AUTO_INCREMENT,
54 `GuildeName` VARCHAR(45) NULL,
55 PRIMARY KEY (`idGuilde`),
56 INDEX `fk_Guilde_Meneur1_idx` (`GuildeName` ASC),
57 CONSTRAINT `fk_Guilde_Meneur1`
58 FOREIGN KEY (`GuildeName`)
59 REFERENCES `mydb`.`Meneur` (`GuildeName`)
60 ON DELETE NO ACTION
61 ON UPDATE NO ACTION)
62ENGINE = InnoDB;
63
64
65-- -----------------------------------------------------
66-- Table `mydb`.`utilisateur`
67-- -----------------------------------------------------
68CREATE TABLE IF NOT EXISTS `mydb`.`utilisateur` (
69 `username` VARCHAR(16) NOT NULL,
70 `email` VARCHAR(255) NULL,
71 `password` VARCHAR(32) NOT NULL,
72 `create_time` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
73 `classe` VARCHAR(45) NULL,
74 `niveau` INT NULL,
75 `guilde` VARCHAR(45) NULL,
76 `Classe_idClasse` INT NOT NULL,
77 `Guilde_idGuilde` INT NOT NULL,
78 INDEX `fk_utilisateur_Classe_idx` (`Classe_idClasse` ASC),
79 INDEX `fk_utilisateur_Guilde1_idx` (`Guilde_idGuilde` ASC),
80 CONSTRAINT `fk_utilisateur_Classe`
81 FOREIGN KEY (`Classe_idClasse`)
82 REFERENCES `mydb`.`Classe` (`idClasse`)
83 ON DELETE NO ACTION
84 ON UPDATE NO ACTION,
85 CONSTRAINT `fk_utilisateur_Guilde1`
86 FOREIGN KEY (`Guilde_idGuilde`)
87 REFERENCES `mydb`.`Guilde` (`idGuilde`)
88 ON DELETE NO ACTION
89 ON UPDATE NO ACTION);
90
91
92SET SQL_MODE=@OLD_SQL_MODE;
93SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
94SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;