yzySrv/db/20-12/20-12-04.sql

-- hh
-- 守卫信标支援&通关记录

CREATE TABLE `role_guard_pass_log`(
    `dun_id` int(11) UNSIGNED NOT NULL COMMENT '副本id',
    `pass_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '通关时长',
    `team_mates` varchar(1000) NOT NULL DEFAULT '[]' COMMENT '队伍成员',
    PRIMARY KEY(`dun_id`)
)ENGINE=InnoDb CHARSET=utf8 COMMENT="守卫信标通关数据";


CREATE TABLE `role_guard_assist_rank`(
    `role_id` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
    `server_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所在服id',
    `server_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所在服编号',
    `val` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '支援值',
    `power` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '战力',
    PRIMARY KEY(`role_id`)
)ENGINE=InnoDb CHARSET=utf8 COMMENT="守卫信标支援周榜";