有償プロモーションクエスト #4338

概要

有償リワードガチャキャンペーン
3stepキャンペーン

db更新内容

有償プロモーションクエスト jolly/jrye-db#1233

新規テーブル

CREATE TABLE `user_gesoten_quest` (
  `campaign_id` int(11) unsigned NOT NULL,
  `quest_id` tinyint(3) unsigned NOT NULL,
  `user_no` int(10) unsigned NOT NULL,
  `target_date` date NOT NULL,
  `user_count` int(10) unsigned NOT NULL DEFAULT '0',
  `api_send_flg` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`campaign_id`,`quest_id`,`user_no`,`target_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE `log_gesoten_quest` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `campaign_id` int(10) unsigned NOT NULL,
  `quest_id` tinyint(3) unsigned NOT NULL,
  `user_no` int(10) unsigned NOT NULL,
  `amount` int(10) unsigned NOT NULL,
  `send_api` tinyint(3) unsigned NOT NULL,
  `reg_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `campaign_quest` (`campaign_id`,`quest_id`),
  KEY `user_reg` (`user_no`,`reg_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

TODO

• [x] dbデプロイ
• [x] webデプロイ