-- 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='星辰图鉴数据合服保留';
|
|
|