-- tyl
-- 源樱之礼抽奖记录优化
ALTER TABLE sakura_server_log ADD COLUMN `tag` tinyint(2) UNSIGNED NOT NULL DEFAULT '0' COMMENT '奖励档次' AFTER `role_id`;

-- hh
-- 幻光扫荡排行

CREATE TABLE `role_visus_rank`(
    `role_id` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
    `level` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '通关(扫荡)层数',
    `show` varchar(255) NOT NULL DEFAULT '[]' COMMENT '附带展示信息',
    `power` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '战力',
    PRIMARY KEY(`role_id`)
)ENGINE=InnoDB CHARSET=utf8 COMMENT="幻光扫荡排行数据";