vy5q6isY

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='TRADITIONAL,ALLOW_INVALID_DATES';
4
5CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
6USE `mydb` ;
7
8-- -----------------------------------------------------
9-- Table `mydb`.`user_master`
10-- -----------------------------------------------------
11DROP TABLE IF EXISTS `mydb`.`user_master` ;
12
13CREATE TABLE IF NOT EXISTS `mydb`.`user_master` (
14  `user_id` INT UNSIGNED NOT NULL,
15  `name` VARCHAR(45) NOT NULL,
16  `last_login` DATETIME NOT NULL,
17  `create_time` DATETIME NOT NULL,
18  `update_time` DATETIME NULL,
19  PRIMARY KEY (`user_id`))
20ENGINE = InnoDB;
21
22
23-- -----------------------------------------------------
24-- Table `mydb`.`game_master`
25-- -----------------------------------------------------
26DROP TABLE IF EXISTS `mydb`.`game_master` ;
27
28CREATE TABLE IF NOT EXISTS `mydb`.`game_master` (
29  `game_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
30  `game_salt` INT UNSIGNED NOT NULL,
31  `name` VARCHAR(45) NULL,
32  `start_time` DATETIME NOT NULL,
33  `end_time` DATETIME NOT NULL,
34  `create_time` DATETIME NOT NULL,
35  `update_time` DATETIME NULL,
36  PRIMARY KEY (`game_id`),
37  INDEX `search_idx` (`start_time` ASC, `end_time` ASC))
38ENGINE = InnoDB;
39
40
41-- -----------------------------------------------------
42-- Table `mydb`.`Infobbs_master`
43-- -----------------------------------------------------
44DROP TABLE IF EXISTS `mydb`.`Infobbs_master` ;
45
46CREATE TABLE IF NOT EXISTS `mydb`.`Infobbs_master` (
47  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
48  `game_id` INT NOT NULL,
49  `pai_id` INT(3) UNSIGNED NOT NULL,
50  `user_id` INT UNSIGNED NOT NULL,
51  `place_id` INT(3) UNSIGNED NOT NULL,
52  `house_id` INT(3) UNSIGNED NOT NULL,
53  `true_flag` INT(1) NOT NULL DEFAULT 0,
54  `create_time` DATETIME NOT NULL,
55  `update_time` DATETIME NULL,
56  PRIMARY KEY (`id`, `create_time`),
57  INDEX `search_id_idx` (`game_id` ASC, `pai_id` ASC),
58  INDEX `fk_Infobbs_master_user_master1_idx` (`user_id` ASC))
59ENGINE = InnoDB;
60
61
62-- -----------------------------------------------------
63-- Table `mydb`.`infobbs_user_master`
64-- -----------------------------------------------------
65DROP TABLE IF EXISTS `mydb`.`infobbs_user_master` ;
66
67CREATE TABLE IF NOT EXISTS `mydb`.`infobbs_user_master` (
68  `id` INT UNSIGNED NOT NULL,
69  `game_id` INT NOT NULL,
70  `user_id` INT UNSIGNED NOT NULL,
71  `pai_id` INT(3) UNSIGNED NOT NULL,
72  `kakunin_flag` INT(1) UNSIGNED NOT NULL DEFAULT 0,
73  `create_time` DATETIME NOT NULL,
74  `update_time` DATETIME NULL,
75  PRIMARY KEY (`id`),
76  INDEX `search_id_idx` (`game_id` ASC, `user_id` ASC, `pai_id` ASC),
77  INDEX `fk_infobbs_user_master_user_master1_idx` (`user_id` ASC))
78ENGINE = InnoDB;
79
80
81-- -----------------------------------------------------
82-- Table `mydb`.`map_master`
83-- -----------------------------------------------------
84DROP TABLE IF EXISTS `mydb`.`map_master` ;
85
86CREATE TABLE IF NOT EXISTS `mydb`.`map_master` (
87  `map_id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
88  `mv_map_id` INT UNSIGNED NOT NULL COMMENT 'MV用マップID',
89  `name` VARCHAR(45) NULL,
90  PRIMARY KEY (`map_id`))
91ENGINE = InnoDB;
92
93
94-- -----------------------------------------------------
95-- Table `mydb`.`place_master`
96-- -----------------------------------------------------
97DROP TABLE IF EXISTS `mydb`.`place_master` ;
98
99CREATE TABLE IF NOT EXISTS `mydb`.`place_master` (
100  `place_id` INT(3) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'マップの地域や場所',
101  `map_id` INT(3) NOT NULL,
102  `name` VARCHAR(45) NOT NULL,
103  `create_time` DATETIME NOT NULL,
104  `update_time` DATETIME NULL,
105  PRIMARY KEY (`place_id`),
106  INDEX `map_id_idx` (`map_id` ASC))
107ENGINE = InnoDB;
108
109
110-- -----------------------------------------------------
111-- Table `mydb`.`house_master`
112-- -----------------------------------------------------
113DROP TABLE IF EXISTS `mydb`.`house_master` ;
114
115CREATE TABLE IF NOT EXISTS `mydb`.`house_master` (
116  `house_id` INT UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '牌の取得可能場所（店等）',
117  `place_id` INT(3) UNSIGNED NOT NULL,
118  `name` VARCHAR(45) NOT NULL,
119  `create_time` DATETIME NOT NULL,
120  `update_time` DATETIME NULL,
121  PRIMARY KEY (`house_id`),
122  INDEX `place_id_idx` (`place_id` ASC))
123ENGINE = InnoDB;
124
125
126-- -----------------------------------------------------
127-- Table `mydb`.`user_pai_master`
128-- -----------------------------------------------------
129DROP TABLE IF EXISTS `mydb`.`user_pai_master` ;
130
131CREATE TABLE IF NOT EXISTS `mydb`.`user_pai_master` (
132  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
133  `user_id` INT UNSIGNED NOT NULL,
134  `game_id` INT UNSIGNED NOT NULL,
135  `table_id` INT UNSIGNED NOT NULL,
136  `wind_id` INT(1) UNSIGNED NOT NULL,
137  `pai_array` BLOB NOT NULL,
138  `end_flag` INT(1) UNSIGNED NOT NULL DEFAULT 0,
139  `create_time` DATETIME NOT NULL,
140  `update_time` DATETIME NULL,
141  PRIMARY KEY (`id`),
142  INDEX `search_idx` (`user_id` ASC, `game_id` ASC, `table_id` ASC),
143  UNIQUE INDEX `user_id_UNIQUE` (`user_id` ASC))
144ENGINE = InnoDB;
145
146
147-- -----------------------------------------------------
148-- Table `mydb`.`user_table_master`
149-- -----------------------------------------------------
150DROP TABLE IF EXISTS `mydb`.`user_table_master` ;
151
152CREATE TABLE IF NOT EXISTS `mydb`.`user_table_master` (
153  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
154  `game_id` INT UNSIGNED NOT NULL,
155  `table_id` INT UNSIGNED NOT NULL,
156  `users_array` BLOB NOT NULL COMMENT 'user_idとwind_idを含む連想配列',
157  `table_salt` INT UNSIGNED NOT NULL,
158  `result_flag` INT(1) UNSIGNED NOT NULL DEFAULT 0,
159  `create_time` DATETIME NULL,
160  `update_time` DATETIME NULL,
161  PRIMARY KEY (`id`),
162  INDEX `search_idx` (`game_id` ASC, `table_id` ASC))
163ENGINE = InnoDB;
164
165
166-- -----------------------------------------------------
167-- Table `mydb`.`yakuman_master`
168-- -----------------------------------------------------
169DROP TABLE IF EXISTS `mydb`.`yakuman_master` ;
170
171CREATE TABLE IF NOT EXISTS `mydb`.`yakuman_master` (
172  `id` INT UNSIGNED NOT NULL AUTO_INCREMENT,
173  `yaku_id` INT UNSIGNED NULL,
174  `user_id` INT UNSIGNED NOT NULL,
175  `name` VARCHAR(45) NOT NULL,
176  `multiple` INT(1) UNSIGNED NOT NULL DEFAULT 1,
177  `create_time` VARCHAR(45) NULL,
178  PRIMARY KEY (`id`))
179ENGINE = InnoDB;
180
181
182SET SQL_MODE=@OLD_SQL_MODE;
183SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
184SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;