vKBpEbWP

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`.`genes`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `mydb`.`genes` (
43  `id` INT NOT NULL,
44  `gene1` VARCHAR(45) NOT NULL,
45  `gene2` VARCHAR(45) NOT NULL,
46  `gene3` VARCHAR(45) NOT NULL,
47  `gene4` VARCHAR(45) NOT NULL,
48  `gene5` VARCHAR(45) NOT NULL,
49  `gene6` VARCHAR(45) NOT NULL,
50  `gene7` VARCHAR(45) NOT NULL,
51  `gene8` VARCHAR(45) NOT NULL,
52  `gene9` VARCHAR(45) NOT NULL,
53  `gene10` VARCHAR(45) NOT NULL,
54  `gene11` VARCHAR(45) NOT NULL,
55  `gene12` VARCHAR(45) NOT NULL,
56  `gene13` VARCHAR(45) NOT NULL,
57  `gene14` VARCHAR(45) NOT NULL,
58  `gene15` VARCHAR(45) NOT NULL,
59  `gene16` VARCHAR(45) NOT NULL,
60  PRIMARY KEY (`id`))
61ENGINE = InnoDB;
62
63
64-- -----------------------------------------------------
65-- Table `mydb`.`saves`
66-- -----------------------------------------------------
67CREATE TABLE IF NOT EXISTS `mydb`.`saves` (
68  `id` INT NOT NULL AUTO_INCREMENT,
69  `game` INT NOT NULL,
70  `type` INT NOT NULL,
71  `gen` INT NOT NULL,
72  `age` VARCHAR(45) NOT NULL,
73  `maxage` VARCHAR(45) NOT NULL,
74  `energy` VARCHAR(45) NOT NULL,
75  `generation` VARCHAR(45) NOT NULL,
76  `children` VARCHAR(45) NOT NULL,
77  PRIMARY KEY (`id`, `game`, `type`, `gen`),
78  UNIQUE INDEX `id_UNIQUE` (`id` ASC) VISIBLE,
79  INDEX `saves_to_games_idx` (`game` ASC) VISIBLE,
80  INDEX `saves_to_types_idx` (`type` ASC) VISIBLE,
81  INDEX `saves_to_genes_idx` (`gen` ASC) VISIBLE,
82  CONSTRAINT `saves_to_games`
83    FOREIGN KEY (`game`)
84    REFERENCES `mydb`.`games` (`id`)
85    ON DELETE NO ACTION
86    ON UPDATE NO ACTION,
87  CONSTRAINT `saves_to_types`
88    FOREIGN KEY (`type`)
89    REFERENCES `mydb`.`types` (`id`)
90    ON DELETE NO ACTION
91    ON UPDATE NO ACTION,
92  CONSTRAINT `saves_to_genes`
93    FOREIGN KEY (`gen`)
94    REFERENCES `mydb`.`genes` (`id`)
95    ON DELETE NO ACTION
96    ON UPDATE NO ACTION)
97ENGINE = InnoDB;
98
99
100SET SQL_MODE=@OLD_SQL_MODE;
101SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
102SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;