You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
22 regels
1011 B
22 regels
1011 B
-- zmh
|
|
-- 星辰数据
|
|
CREATE TABLE `role_galaxy`(
|
|
`rid` bigint(20) UNSIGNED NOT NULL COMMENT '人物id',
|
|
`pos_list` varchar(500) NOT NULL DEFAULT '[]' COMMENT '槽位开放记录',
|
|
`display` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '展示状态',
|
|
`skin` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '皮肤状态',
|
|
`refresh_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '刷新时间戳',
|
|
`refresh_times` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '刷新次数',
|
|
`item_list` varchar(1000) NOT NULL DEFAULT '[]' COMMENT '市场列表[]',
|
|
PRIMARY KEY(`rid`)
|
|
)ENGINE=InnoDB CHARSET=utf8 COMMENT="玩家星辰-合服保留";
|
|
|
|
|
|
-- zmh
|
|
-- 星辰皮肤数据
|
|
CREATE TABLE `role_galaxy_skin`(
|
|
`rid` bigint(20) UNSIGNED NOT NULL COMMENT '人物id',
|
|
`skin` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '皮肤',
|
|
`star` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '星级',
|
|
PRIMARY KEY(`rid`,`skin`)
|
|
)ENGINE=InnoDB CHARSET=utf8 COMMENT="玩家星辰皮肤-合服保留";
|