【8/31】リリース手順書 #183

ヤマダpt配布 #160 9/1~
アイテムパック #176 8/31~

ログテーブル更新

エラーが出るので先に更新しておく

DROP TABLE IF EXISTS `log_yamada_point`;
CREATE TABLE `log_yamada_point` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `user_no` int(11) NOT NULL,
  `campaign_id` int(11) unsigned NOT NULL,
  `mission_type` tinyint(4) unsigned NOT NULL,
  `mission_id` int(11) unsigned NOT NULL DEFAULT '0',
  `send_api` tinyint(4) unsigned NOT NULL DEFAULT '0',
  `request_no` varchar(50) NOT NULL DEFAULT '',
  `reg_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_mission` (`user_no`,`campaign_id`,`mission_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

web更新

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

db更新

• master_yamada_campaign
• master_yamada_point
• master_item_pack
• master_item_pack_info
• master_shop
• master_shop_item

git checkout master
git pull
git merge origin/develop
ssh jr-adm
deploy db