-- 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="幻光扫荡排行数据";
|