Nevar pievienot vairāk kā 25 tēmas
Tēmai ir jāsākas ar burtu vai ciparu, tā var saturēt domu zīmes ('-') un var būt līdz 35 simboliem gara.
34 rindas
1.6 KiB
34 rindas
1.6 KiB
-- zmh
|
|
-- 进阶系统
|
|
CREATE TABLE `player_foster` (
|
|
`rid` bigint(20) UNSIGNED NOT NULL COMMENT '玩家id',
|
|
`type` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '系统类型',
|
|
`grade` int(11) UNSIGNED NOT NULL DEFAULT '1' COMMENT '阶',
|
|
`star` int(11) UNSIGNED NOT NULL DEFAULT '1' COMMENT '星',
|
|
`exp` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '进度',
|
|
`clear` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '是否清零',
|
|
`display` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '当前幻化',
|
|
`lowcore` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '初级核心',
|
|
`highcore` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '高级核心',
|
|
`etime` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '有效时间',
|
|
`skills` varchar(500) NOT NULL DEFAULT '[]' COMMENT '技能列表',
|
|
PRIMARY KEY (`rid`,`type`),
|
|
KEY `type` (`type`) USING BTREE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='玩家进阶系统表';
|
|
|
|
-- 进阶装备
|
|
CREATE TABLE `player_foster_equip` (
|
|
`rid` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家id',
|
|
`type` int(11) UNSIGNED NOT NULL DEFAULT '0' COMMENT '系统类型',
|
|
`grade` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '阶数',
|
|
`equips` varchar(2000) NOT NULL DEFAULT '[]' COMMENT '穿戴',
|
|
PRIMARY KEY (`rid`,`type`,`grade`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='进阶装备';
|
|
|
|
-- liushl
|
|
-- 装备系统
|
|
CREATE TABLE `equipment` (
|
|
`role_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '玩家ID',
|
|
`stars` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '当前激活的星级数',
|
|
PRIMARY KEY (`role_id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='装备-通用信息';
|