Kn9iZE3e

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 test2
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema test2
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `test2` DEFAULT CHARACTER SET utf8 ;
15-- -----------------------------------------------------
16-- Schema test
17-- -----------------------------------------------------
18USE `test2` ;
19
20-- -----------------------------------------------------
21-- Table `test2`.`User`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `test2`.`User` (
24  `idUser` INT NOT NULL AUTO_INCREMENT,
25  `steamId` VARCHAR(45) NULL,
26  PRIMARY KEY (`idUser`))
27ENGINE = InnoDB;
28
29
30-- -----------------------------------------------------
31-- Table `test2`.`Name`
32-- -----------------------------------------------------
33CREATE TABLE IF NOT EXISTS `test2`.`Name` (
34  `idNames` INT NOT NULL AUTO_INCREMENT,
35  `userName` VARCHAR(70) NULL,
36  `idUser` INT NULL,
37  PRIMARY KEY (`idNames`),
38  INDEX `Names_username_FK_idx` (`idUser` ASC),
39  CONSTRAINT `Names_username_FK`
40    FOREIGN KEY (`idUser`)
41    REFERENCES `test2`.`User` (`idUser`)
42    ON DELETE NO ACTION
43    ON UPDATE NO ACTION)
44ENGINE = InnoDB;
45
46
47-- -----------------------------------------------------
48-- Table `test2`.`UserMap`
49-- -----------------------------------------------------
50CREATE TABLE IF NOT EXISTS `test2`.`UserMap` (
51  `idUserMap` INT NOT NULL AUTO_INCREMENT,
52  `idMap` INT NULL,
53  `idUser` INT NULL,
54  PRIMARY KEY (`idUserMap`),
55  INDEX `UsernameMap_idx` (`idMap` ASC),
56  INDEX `UsernameMap_User_idx` (`idUser` ASC),
57  CONSTRAINT `UsernameMap_Map_FK`
58    FOREIGN KEY (`idMap`)
59    REFERENCES `test2`.`Map` (`idMap`)
60    ON DELETE NO ACTION
61    ON UPDATE NO ACTION,
62  CONSTRAINT `UsernameMap_User`
63    FOREIGN KEY (`idUser`)
64    REFERENCES `test2`.`User` (`idUser`)
65    ON DELETE NO ACTION
66    ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table `test2`.`Car`
72-- -----------------------------------------------------
73CREATE TABLE IF NOT EXISTS `test2`.`Car` (
74  `idCar` INT NOT NULL AUTO_INCREMENT,
75  `identifyCode` VARCHAR(45) NULL,
76  `name` VARCHAR(45) NULL,
77  PRIMARY KEY (`idCar`))
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `test2`.`Lap`
83-- -----------------------------------------------------
84CREATE TABLE IF NOT EXISTS `test2`.`Lap` (
85  `idLap` INT NOT NULL AUTO_INCREMENT,
86  `time` INT NULL,
87  `idCar` INT NULL,
88  `idUserMap` INT NULL,
89  PRIMARY KEY (`idLap`),
90  INDEX `Lap_UserMap_FK_idx` (`idUserMap` ASC),
91  INDEX `Lap_Car_FK_idx` (`idCar` ASC),
92  CONSTRAINT `Lap_UserMap_FK`
93    FOREIGN KEY (`idUserMap`)
94    REFERENCES `test2`.`UserMap` (`idUserMap`)
95    ON DELETE NO ACTION
96    ON UPDATE NO ACTION,
97  CONSTRAINT `Lap_Car_FK`
98    FOREIGN KEY (`idCar`)
99    REFERENCES `test2`.`Car` (`idCar`)
100    ON DELETE NO ACTION
101    ON UPDATE NO ACTION)
102ENGINE = InnoDB;
103
104
105-- -----------------------------------------------------
106-- Table `test2`.`Map`
107-- -----------------------------------------------------
108CREATE TABLE IF NOT EXISTS `test2`.`Map` (
109  `idMap` INT NOT NULL AUTO_INCREMENT,
110  `name` VARCHAR(45) NULL,
111  `identifyCode` VARCHAR(45) NULL,
112  `Mapcol` VARCHAR(45) NULL,
113  `bestLap` INT NULL,
114  PRIMARY KEY (`idMap`),
115  INDEX `bestLap_Lap_FK_idx` (`bestLap` ASC),
116  CONSTRAINT `bestLap_Lap_FK`
117    FOREIGN KEY (`bestLap`)
118    REFERENCES `test2`.`Lap` (`idLap`)
119    ON DELETE NO ACTION
120    ON UPDATE NO ACTION)
121ENGINE = InnoDB;
122
123
124SET SQL_MODE=@OLD_SQL_MODE;
125SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
126SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;