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

-- hh
-- 守卫信标首通记录修改

DROP TABLE `dun_guard_log`;
CREATE TABLE `dun_guard_log` (
    `dun_id` int(11) UNSIGNED NOT NULL COMMENT '副本id',
    `wave` int(11) UNSIGNED NOT NULL COMMENT '波数进度',
    `role_id` bigint(20) UNSIGNED NOT NULL COMMENT '人物ID',
    `team_id` int(32) UNSIGNED NOT NULL DEFAULT 0 COMMENT '队伍ID', 
    `role_data` varchar(3000) NOT NULL COMMENT '人物信息',
    `time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '时间',
    PRIMARY KEY(`dun_id`, `wave`, `role_id`)
) ENGINE=InnoDB CHARSET=utf8 COMMENT='守卫信标波数首通历史数据';