CeSVQ9Fg

1-- MySQL Script generated by MySQL Workbench
2-- Mon May 14 13:42:58 2018
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 galos_db
12-- -----------------------------------------------------
13
14-- -----------------------------------------------------
15-- Schema galos_db
16-- -----------------------------------------------------
17CREATE SCHEMA IF NOT EXISTS `galos_db` DEFAULT CHARACTER SET utf8 ;
18USE `galos_db` ;
19
20-- -----------------------------------------------------
21-- Table `galos_db`.`users`
22-- -----------------------------------------------------
23CREATE TABLE IF NOT EXISTS `galos_db`.`users` (
24  `_id` INT NOT NULL AUTO_INCREMENT,
25  `login` VARCHAR(45) NOT NULL,
26  `password` VARCHAR(45) NOT NULL,
27  `email` VARCHAR(45) NOT NULL,
28  `money` INT NOT NULL DEFAULT 0,
29  `record` INT NOT NULL DEFAULT 0,
30  PRIMARY KEY (`_id`),
31  UNIQUE INDEX `idtable1_UNIQUE` (`_id` ASC),
32  UNIQUE INDEX `login_UNIQUE` (`login` ASC),
33  UNIQUE INDEX `email_UNIQUE` (`email` ASC))
34ENGINE = InnoDB
35DEFAULT CHARACTER SET = utf8
36COLLATE = utf8_unicode_ci;
37
38
39-- -----------------------------------------------------
40-- Table `galos_db`.`achievements`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `galos_db`.`achievements` (
43  `_id` INT NULL AUTO_INCREMENT,
44  `status` VARCHAR(26) NOT NULL DEFAULT '00000000000000000000000000',
45  `all_levels` INT NOT NULL DEFAULT 0,
46  `all_money` INT NOT NULL DEFAULT 0,
47  `all_eating` INT NOT NULL DEFAULT 0,
48  `all_wins` INT NOT NULL DEFAULT 0,
49  `id_user` INT NULL,
50  PRIMARY KEY (`_id`),
51  UNIQUE INDEX `_id_UNIQUE` (`_id` ASC),
52  INDEX `id_user_idx` (`id_user` ASC),
53  CONSTRAINT `achievementsUserFK`
54    FOREIGN KEY (`id_user`)
55    REFERENCES `galos_db`.`users` (`_id`)
56    ON DELETE CASCADE
57    ON UPDATE NO ACTION)
58ENGINE = InnoDB
59DEFAULT CHARACTER SET = utf8
60COLLATE = utf8_unicode_ci;
61
62
63-- -----------------------------------------------------
64-- Table `galos_db`.`resume`
65-- -----------------------------------------------------
66CREATE TABLE IF NOT EXISTS `galos_db`.`resume` (
67  `_id` INT NOT NULL AUTO_INCREMENT,
68  `mode` INT NOT NULL DEFAULT 1,
69  `score` INT NOT NULL DEFAULT 0,
70  `all_rewards` INT NOT NULL DEFAULT 0,
71  `id_user` INT NULL,
72  PRIMARY KEY (`_id`),
73  UNIQUE INDEX `_id_UNIQUE` (`_id` ASC),
74  INDEX `id_user_idx` (`id_user` ASC),
75  CONSTRAINT `resumeUserFK`
76    FOREIGN KEY (`id_user`)
77    REFERENCES `galos_db`.`users` (`_id`)
78    ON DELETE CASCADE
79    ON UPDATE NO ACTION)
80ENGINE = InnoDB;
81
82
83SET SQL_MODE=@OLD_SQL_MODE;
84SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
85SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;