Não pode escolher mais do que 25 tópicos
Os tópicos devem começar com uma letra ou um número, podem incluir traços ('-') e podem ter até 35 caracteres.
26 linhas
1.4 KiB
26 linhas
1.4 KiB
-- 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`;
|
|
|