You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
25 regels
1.0 KiB
25 regels
1.0 KiB
-- 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`;
|