yzySrv/db/21-01/21-01-26.sql

-- 混乱星域新表
-- hh

CREATE TABLE `deserted_boss_status`(
    `zone_id` bigint(20) UNSIGNED NOT NULL COMMENT '分区id',
    `fac_id` int(11) UNSIGNED NOT NULL COMMENT '阵营id',
    `boss_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '怪物id',
    `dead_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '死亡时间',
    `killer` varchar(255) NOT NULL DEFAULT 0 COMMENT '击杀者',
    `srv_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '击杀者服务器编号',
    PRIMARY KEY(`zone_id`, `fac_id`, `boss_id`)
)ENGINE=InnoDB CHARSET=utf8 COMMENT="混乱星域boss状态";


-- huangyongxing
ALTER TABLE `center_zones`
ADD COLUMN `faction_names` varchar(200) NOT NULL DEFAULT '[]' COMMENT '阵营名字列表（空时使用默认名）' AFTER `server_ids`;