10/1リリース手順 #300

テーブル作成 12:00

CREATE TABLE `log_teamwar_reward_gold` (
  `user_no` bigint(20) NOT NULL,
  `year_mon_day` int(11) NOT NULL,
  `result_type` int(11) NOT NULL,
  `team_no` int(11) NOT NULL,
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`user_no`,`year_mon_day`,`result_type`),
  KEY `year_mon_day` (`year_mon_day`,`team_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `log_war_win_reward` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_no` bigint(20) NOT NULL,
  `type` tinyint(4) NOT NULL COMMENT '11:宝箱取得、21:星ストック取得、22：星ストック消費',
  `count` tinyint(4) NOT NULL,
  `after_count` int(11) NOT NULL,
  `reg_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `type` (`type`,`reg_date`),
  KEY `user_no` (`user_no`,`reg_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `user_war_win_reward` (
  `user_no` bigint(20) NOT NULL,
  `reward_type` tinyint(4) NOT NULL COMMENT '宝箱の種類',
  `star_need` tinyint(4) NOT NULL,
  `star_stock` tinyint(4) NOT NULL,
  `star_total` int(11) NOT NULL,
  PRIMARY KEY (`user_no`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `teamWar_combat` (
  `year_mon_day` int(11) NOT NULL,
  `team_no1` int(11) NOT NULL,
  `team_no2` int(11) NOT NULL,
  `combat_no` int(11) NOT NULL,
  `user_no1` bigint(20) NOT NULL,
  `card_no1_1` int(11) NOT NULL,
  `card_no1_2` int(11) NOT NULL,
  `card_no1_3` int(11) NOT NULL,
  `user_no2` bigint(20) NOT NULL,
  `card_no2_1` int(11) NOT NULL,
  `card_no2_2` int(11) NOT NULL,
  `card_no2_3` int(11) NOT NULL,
  `key` char(255) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`year_mon_day`,`team_no1`,`team_no2`,`combat_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

CREATE TABLE `teamWar_userDetail` (
  `user_no` bigint(20) NOT NULL,
  `team_no` int(11) NOT NULL,
  `year_mon_day` int(11) NOT NULL,
  `user_pt` int(11) NOT NULL DEFAULT '0',
  `pt_time` int(11) NOT NULL DEFAULT '0',
  `sink_ship` int(11) NOT NULL DEFAULT '0',
  `sink_time` int(11) NOT NULL DEFAULT '0',
  `win` int(11) NOT NULL DEFAULT '0',
  `max_win` int(11) NOT NULL DEFAULT '0',
  `attack` int(11) NOT NULL DEFAULT '0',
  `attack_time` int(11) NOT NULL DEFAULT '0',
  `defense` int(11) NOT NULL DEFAULT '0',
  `defense_time` int(11) NOT NULL DEFAULT '0',
  `inspire` int(11) NOT NULL DEFAULT '0',
  `inspire_time` int(11) NOT NULL DEFAULT '0',
  `goal_flag` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_no`,`team_no`,`year_mon_day`),
  KEY `team_no` (`team_no`,`year_mon_day`,`user_pt`,`pt_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

web更新 14:00

#prマージ
ssh jr-adm
update web
deploy web

SELECT * FROM jrye.log_teamwar_reward_gold;
SELECT * FROM jrye.log_war_win_reward;
SELECT * FROM jrye.user_war_win_reward;
SELECT * FROM jrye_teamWar.teamWar_combat;
SELECT * FROM jrye_teamWar.teamWar_userDetail;