yzySrv/db/20-09/20-09-01.sql

-- zmh
-- 星辰图鉴数据
CREATE TABLE `player_galaxy` (
  `rid` bigint(20) unsigned NOT NULL COMMENT '角色id',
  `type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '星群',
  `subtype` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '星团',
  `gain` varchar(500) NOT NULL DEFAULT '[]' COMMENT '已收集',
  `state` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`rid`,`type`,`subtype`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='星辰图鉴数据合服保留';