Description
https://docs.google.com/spreadsheets/d/18IRfB6Uw08AgqeXDGW2Mb-7agBY0aDN7fDjvMeEW8-w/edit#gid=1711739197
コロプラ
CREATE TABLE user_battle_archive (
user_no bigint(20) NOT NULL,
archive_id char(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
battle_type tinyint(4) NOT NULL,
enemy_name varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
title varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
comment varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
thumbnail varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
battle_log_gzip mediumblob,
reg_date timestamp NOT NULL,
PRIMARY KEY (user_no,archive_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='バトル保存機能';
dゲーム
CREATE TABLE user_battle_archive (
user_no bigint(20) NOT NULL,
archive_id char(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
text_data_id bigint(20) NOT NULL,
battle_type tinyint(4) NOT NULL,
enemy_name varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
title varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
comment varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
thumbnail varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
battle_log_gzip mediumblob,
reg_date timestamp NOT NULL,
PRIMARY KEY (user_no,archive_id),
KEY idx_battle_type (battle_type),
KEY idx_reg_date (reg_date)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='バトル保存機能';
ログ
CREATE TABLE log_battle_archive_favorite (
id int(11) NOT NULL AUTO_INCREMENT,
user_no bigint(20) NOT NULL,
state tinyint(4) NOT NULL,
archive_id char(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
reg_date timestamp NOT NULL,
PRIMARY KEY (id),
KEY idx_user_no (user_no),
KEY idx_reg_date (reg_date)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='バトル保存機能 お気に入り登録ログ';