yzySrv/db/21-02/21-02-07.sql

-- liushl
CREATE TABLE `cross_point_role_data`(
    `zone_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '分区id',
    `role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '角色Id',
    `name` varchar(50) NOT NULL DEFAULT '[]' COMMENT '名字',
    `server_id` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '服务器id',
    `server_num` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '服务器编号',
    `faction` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '国家id',
    PRIMARY KEY(`zone_id`, `role_id`)
)ENGINE=InnoDB CHARSET=utf8 COMMENT="沙盘争夺战-玩家信息(合服保留)";