【5/2】ヤマダゲームマラソン #382

テーブル

• master_yamada_game_marathon
• user_yamada_game_marathon

CREATE TABLE `user_yamada_game_marathon` (
  `user_no` int(10) unsigned NOT NULL,
  `marathon_id` tinyint(3) unsigned NOT NULL,
  `point` int(10) unsigned NOT NULL,
  `pass_point` int(10) unsigned NOT NULL,
  PRIMARY KEY (`user_no`,`marathon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

• log_user_yamada_game_marathon

CREATE TABLE `log_user_yamada_game_marathon` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_no` int(10) unsigned NOT NULL,
  `marathon_id` tinyint(3) unsigned NOT NULL,
  `days` tinyint(3) unsigned NOT NULL,
  `code` varchar(50) NOT NULL DEFAULT '',
  `send_api` tinyint(3) unsigned NOT NULL,
  `reg_date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `marathon_days` (`marathon_id`,`days`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;