|
|
- -- zmh 外援存储
- ALTER TABLE `cross_guild_war_guild_info`
- ADD COLUMN `help_ups` varchar(6000) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]' COMMENT '外援列表' AFTER `sign_ups`;
-
-
- CREATE TABLE `log_cgwar_city_info` (
- `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增id',
- `zone_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区Id',
- `room_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '房间Id',
- `city_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '城池Id',
- `server_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '游戏服ServerId',
- `server_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '游戏服编号(玩家看到的服数)',
- `guild_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '帮派Id',
- `guild_name` varchar(50) NOT NULL DEFAULT '' COMMENT '帮派名称',
- `guild_power` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '帮派战力',
- `chief_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '帮主Id',
- `chief_name` varchar(50) NOT NULL DEFAULT '' COMMENT '帮主名称',
- `chief_power` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '帮主战力',
- `time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '时间',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='跨服国战往期战报';
-
-
- ALTER TABLE `cross_guild_war_last_zone`
- ADD COLUMN `fact_id` int(11) NOT NULL DEFAULT 0 COMMENT '阵营ID' AFTER `zone_id`;
-
|
