· 4 years ago · Jun 29, 2021, 01:16 PM
1SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
2SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
3SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
4
5-- -----------------------------------------------------
6-- Schema mydb
7-- -----------------------------------------------------
8
9-- -----------------------------------------------------
10-- Schema mydb
11-- -----------------------------------------------------
12CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
13USE `mydb` ;
14
15-- -----------------------------------------------------
16-- Table `mydb`.`games`
17-- -----------------------------------------------------
18CREATE TABLE IF NOT EXISTS `mydb`.`games` (
19 `id` INT NOT NULL AUTO_INCREMENT,
20 `time` VARCHAR(45) NOT NULL,
21 `save` VARCHAR(45) NOT NULL,
22 PRIMARY KEY (`id`),
23 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE)
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `mydb`.`types`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `mydb`.`types` (
31 `id` INT NOT NULL AUTO_INCREMENT,
32 `food` VARCHAR(45) NOT NULL,
33 `color` VARCHAR(45) NOT NULL,
34 PRIMARY KEY (`id`),
35 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE)
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `mydb`.`saves`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `mydb`.`saves` (
43 `id` INT NOT NULL AUTO_INCREMENT,
44 `game` INT NOT NULL,
45 `type` INT NOT NULL,
46 `days` VARCHAR(45) NOT NULL,
47 `energy` VARCHAR(45) NOT NULL,
48 `generation` VARCHAR(45) NOT NULL,
49 `gen` VARCHAR(45) NOT NULL,
50 PRIMARY KEY (`id`, `game`, `type`),
51 UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
52 INDEX `saves_to_games_idx` (`game` ASC) VISIBLE,
53 INDEX `saves_to_types_idx` (`type` ASC) VISIBLE,
54 CONSTRAINT `saves_to_games`
55 FOREIGN KEY (`game`)
56 REFERENCES `mydb`.`games` (`id`)
57 ON DELETE NO ACTION
58 ON UPDATE NO ACTION,
59 CONSTRAINT `saves_to_types`
60 FOREIGN KEY (`type`)
61 REFERENCES `mydb`.`types` (`id`)
62 ON DELETE NO ACTION
63 ON UPDATE NO ACTION)
64ENGINE = InnoDB;
65
66
67SET SQL_MODE=@OLD_SQL_MODE;
68SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
69SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
70