-- liushl
CREATE TABLE `madness_land_zone_guild_rank`(
    `zone_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区id',
    `rank` int(11) NOT NULL DEFAULT '0' COMMENT '排名',
    `server_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '服务器',
    `guild_name` varchar(50) NOT NULL DEFAULT '[]' COMMENT '公会名字',
    `score` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
    PRIMARY KEY(`zone_id`, `rank`)
)ENGINE=InnoDB CHARSET=utf8 COMMENT="狂战领域-跨服公会排名(合服保留)";

CREATE TABLE `madness_land_guild_rank`(
    `rank` int(11) NOT NULL DEFAULT '0' COMMENT '排名',
    `guild_name` varchar(50) NOT NULL DEFAULT '[]' COMMENT '公会名字',
    `score` int(11) NOT NULL DEFAULT '0' COMMENT '积分',
    PRIMARY KEY(`rank`)
)ENGINE=InnoDB CHARSET=utf8 COMMENT="狂战领域-本服公会排名(合服清空)";

drop table if exists madness_land_zone_server_rank;