yzySrv/db/20-09/20-09-21.sql

-- 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='每日消费日志(合服合并保留)';