yzySrv/db/20-05/20-05-08.sql

-- hh
-- 修改多人副本日志

ALTER TABLE `log_multi_dungeon`
    ADD COLUMN `node` varchar(255) NOT NULL DEFAULT 'undefined' COMMENT '玩家节点' AFTER `role_id`;

ALTER TABLE `log_multi_dungeon`
    ADD COLUMN `node1` varchar(255) NOT NULL DEFAULT 'undefined' COMMENT '玩家1节点' AFTER `role_id1`;

ALTER TABLE `log_multi_dungeon`
    ADD COLUMN `node2` varchar(255) NOT NULL DEFAULT 'undefined' COMMENT '玩家2节点' AFTER `role_id2`;

ALTER TABLE `log_multi_dungeon`
    ADD COLUMN `node3` varchar(255) NOT NULL DEFAULT 'undefined' COMMENT '玩家3节点' AFTER `role_id3`;


-- 修改vip日志
ALTER TABLE `log_vip_status`
    ADD COLUMN `trial_lv` tinyint(6) UNSIGNED NOT NULL DEFAULT 0 COMMENT '体验等级' AFTER `vip_type`;

ALTER TABLE `log_vip_status`
    MODIFY COLUMN `vip_status` int(8) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'vip状态 0激活体验|1激活永久|2体验过期|3永久升级';

ALTER TABLE `log_vip_upgrade` DROP COLUMN `login_exp`;
ALTER TABLE `log_vip_upgrade` DROP COLUMN `goods_exp`;