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

-- liushl
-- 删除旧系统-离线挂机
drop table if exists log_onhook;
drop table if exists log_onhook_result;
drop table if exists role_onhook;


ALTER TABLE `log_local_vie_rank`
ADD COLUMN `dtime`  int(11) NOT NULL DEFAULT 0 COMMENT '有效时间' AFTER `rtime`;

ALTER TABLE `log_vie_rank`
ADD COLUMN `dtime`  int(11) NOT NULL DEFAULT 0 COMMENT '有效时间' AFTER `rtime`;

alter table player_state
add column `passive_skill` varchar(5000) NOT NULL DEFAULT '[]' COMMENT '被动技能列表##离线保存' after last_be_kill,
add column `attr` varchar(5000) NOT NULL DEFAULT '[]' COMMENT '玩家属性##离线保存' after passive_skill;