No puede seleccionar más de 25 temas
Los temas deben comenzar con una letra o número, pueden incluir guiones ('-') y pueden tener hasta 35 caracteres de largo.
24 líneas
1.1 KiB
24 líneas
1.1 KiB
-- hh
|
|
|
|
-- 爬塔星级奖励
|
|
CREATE TABLE `role_tower_star_reward`(
|
|
`role_id` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
|
|
`index` int(11) UNSIGNED NOT NULL COMMENT '通关星数序号',
|
|
`state` tinyint(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '领取状态',
|
|
PRIMARY KEY(`role_id`, `index`)
|
|
)ENGINE=InnoDB CHARSET=utf8 COMMENT="爬塔副本星级奖励领取状态";
|
|
|
|
-- 爬塔星级排行
|
|
CREATE TABLE `role_tower_rank`(
|
|
`role_id` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
|
|
`role_name` varchar(255) NOT NULL DEFAULT "" COMMENT '玩家名字',
|
|
`star` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '总星数',
|
|
`time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上榜时间',
|
|
PRIMARY KEY(`role_id`)
|
|
)ENGINE=InnoDB CHARSET=utf8 COMMENT="爬塔副本星级排行数据";
|
|
|
|
-- liushl
|
|
ALTER TABLE log_player_daily
|
|
ADD COLUMN `is_login` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '今日是否登陆' AFTER `trade`;
|
|
ALTER TABLE log_player_attr
|
|
ADD COLUMN `is_login` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '今日是否登陆' AFTER `top`;
|