|
-- hh
|
|
-- boss关注修改字段
|
|
|
|
ALTER TABLE `local_boss_focus`
|
|
ADD COLUMN `boss_type` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT "boss类型" AFTER `boss_id`;
|
|
|
|
-- liushl
|
|
CREATE TABLE daily_consume_log(
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家ID',
|
|
`zero_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '0点时间戳',
|
|
`gold` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '元宝数',
|
|
`bgold` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '绑元数',
|
|
`coin` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '铜币数',
|
|
PRIMARY KEY (`role_id`,`zero_time`)
|
|
)ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='每日消费日志(合服合并保留)';
|