yzySrv/db/20-07/20-07-08.sql

-- hh
-- 守卫信标
CREATE TABLE `role_dun_guard_achieve` (
  `role_id` bigint(20) UNSIGNED NOT NULL DEFAULT '0' COMMENT '人物id',
  `dun_id` int(11) UNSIGNED NOT NULL DEFAULT '3400' COMMENT '副本id',
  `wave` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '副本进度',
  `state` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '里程碑领取状态',
  PRIMARY KEY (`role_id`,`dun_id`,`wave`)
) ENGINE=InnoDB CHARSET=utf8 COMMENT='守卫信标数据';


CREATE TABLE `dun_guard_log` (
    `dun_id` int(11) UNSIGNED NOT NULL COMMENT '副本id',
    `wave` int(11) UNSIGNED NOT NULL COMMENT '波数进度',
    `role_list` varchar(255) NOT NULL DEFAULT '[]' COMMENT '队员列表',
    `time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '时间',
    PRIMARY KEY(`dun_id`, `wave`)
) ENGINE=InnoDB CHARSET=utf8 COMMENT='守卫信标波数首通历史数据';