25개 이상의 토픽을 선택하실 수 없습니다.
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
17 lines
780 B
17 lines
780 B
-- 混乱星域新表
|
|
-- 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`;
|