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.
28 rivejä
1.4 KiB
28 rivejä
1.4 KiB
-- liushl
|
|
ALTER TABLE `cross_point_fight_point` ADD COLUMN
|
|
`add_up_time` varchar(255) NOT NULL DEFAULT '[]' COMMENT '其他国家在该据点累计占领时间##[{faction,time}]' AFTER `seize_time`;
|
|
|
|
-- tyl
|
|
-- 跨服世界
|
|
alter table role_legion add column `p_utime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '军衔上次更新时间' after `ltime`;
|
|
|
|
CREATE TABLE IF NOT EXISTS `legion_military_rank` (
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
|
|
`zone_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区Id',
|
|
`faction` tinyint(3) unsigned NOT NULL COMMENT '阵型',
|
|
`server_num` int(11) unsigned NOT NULL COMMENT '服务器num',
|
|
`name` varchar(255) NOT NULL DEFAULT '' COMMENT '玩家名称',
|
|
`sex` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
|
|
`pos` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '军衔等级',
|
|
`vip` int(11) unsigned NOT NULL DEFAULT '0' COMMENT 'vip',
|
|
`sup_vip` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT '超级贵族',
|
|
`time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
|
|
PRIMARY KEY (`role_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='跨服军团-军衔排行';
|
|
|
|
-- hh
|
|
-- 团战战果日志字段修改
|
|
ALTER TABLE `camp_war_guild_rank_log`
|
|
ADD COLUMN `guild_power` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '社团战力' AFTER `hurt`;
|
|
|
|
ALTER TABLE `camp_war_guild_rank_log` DROP PRIMARY KEY, ADD PRIMARY KEY (`guild_id`);
|