| 奇迹muonline数据库基础库分析 |
一、表的组成：
BtF2CS http://blog.numino.net/
1、AccountCharacter
ykCipx http://blog.numino.net/
用来存放帐号的角色。
3F21om http://blog.numino.net/
2、Character
0If1Fw http://blog.numino.net/
用来存放每个角色的详细数据。
jM6EBl http://blog.numino.net/
3、MEMB_INFO
WEy6he http://blog.numino.net/
帐号信息
9f0V91 http://blog.numino.net/
4、MEMB_STAT
4q63XZ http://blog.numino.net/
帐号状态
oGK67u http://blog.numino.net/
5、warehouse
7KohyG http://blog.numino.net/
仓库
lA1RcU http://blog.numino.net/
6、VI_CURR_INFO
0qjrm4 http://blog.numino.net/
帐号费用
76oLfq http://blog.numino.net/
7、WEB_ZS
oS7w05 http://blog.numino.net/
PL 网站的转生数据
Q5A602 http://blog.numino.net/
二、各表说明
TG4TIB http://blog.numino.net/
1、AccountCharacter 表
vZxlL9 http://blog.numino.net/
列名 类型 长 是否空 说明
GMF7Sg http://blog.numino.net/
Number int 4 0 自动增加的序数
LLFylC http://blog.numino.net/
Id varchar 10 0 帐号
7HECQl http://blog.numino.net/
GameID1 varchar 10 1 角色1
Re1O12 http://blog.numino.net/
GameID2 varchar 10 1 角色2
d1yxUZ http://blog.numino.net/
GameID3 varchar 10 1
9VbTI7 http://blog.numino.net/
GameID4 varchar 10 1
352x82 http://blog.numino.net/
GameID5 varchar 10 1
St1YoZ http://blog.numino.net/
GameIDC varchar 10 1
52uKB4 http://blog.numino.net/
2、Character 表
AwZqdg http://blog.numino.net/
列名 类型 长 是否空 说明
TIsE87 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
HL5hBk http://blog.numino.net/
Name nvarchar 10 0 --------角色名
yD63ag http://blog.numino.net/
cLevel smallint 2 1 --------等级
Xid80W http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
4RcbJ4 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
2X2Fgk http://blog.numino.net/
Experience int 4 1 --------经验
W26D35 http://blog.numino.net/
Strength smallint 2 1 --------力量
0MdXuy http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
2PkNjV http://blog.numino.net/
Vitality smallint 2 1 --------体力
vnbYL5 http://blog.numino.net/
Energy smallint 2 1 --------智力
J7aTo6 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
153A6E http://blog.numino.net/
MagicList varbinary 60 1 --------技能
A2sDfV http://blog.numino.net/
Money int 4 1 --------钱
Qqi2XJ http://blog.numino.net/
Life real 4 1 --------
2D26gY http://blog.numino.net/
MaxLife real 4 1 --------
rSG2nq http://blog.numino.net/
Mana real 4 1 --------
FC693N http://blog.numino.net/
MaxMana real 4 1 --------
6Ygbqy http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
G4q5ua http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
V4OPW9 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
tO05Du http://blog.numino.net/
MapDir tinyint 1 1 --------
WA69EH http://blog.numino.net/
PkCount int 4 1 --------
Wf5Ok8 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
D46nZW http://blog.numino.net/
PkTime int 4 1
T8Y6jE http://blog.numino.net/
MDate smalldatetime 4 1
RzQUDm http://blog.numino.net/
LDate smalldatetime 4 1
NhF8bw http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
YohswM http://blog.numino.net/
DbVersion tinyint 1 1
M4zd6X http://blog.numino.net/
Quest varbinary 50 1
vS2aSx http://blog.numino.net/
LINZB bit 1 0
l1enEU http://blog.numino.net/
XDTIME datetime 8 0
0EoQJn http://blog.numino.net/
STOPINFO nvarchar 100 1
h0SL5K http://blog.numino.net/
STOPTIME datetime 8 0
2KWOEw http://blog.numino.net/
zs_count int 4 1
s7z69d http://blog.numino.net/
zs_point int 4 1
2OMf8E http://blog.numino.net/
bs_count int 4 1
sTtF4s http://blog.numino.net/
bs_point int 4 1
eyENih http://blog.numino.net/
shiji smalldatetime 4 1
Z8jP7e http://blog.numino.net/
banl nvarchar 10 1
3gzg6Z http://blog.numino.net/
lv_time datetime 8 1
jxB82m http://blog.numino.net/
ex_ok int 4 1
hc1VC3 http://blog.numino.net/
ex_total int 4 1
8DGxpf http://blog.numino.net/
rb_count int 4 1
80bBJQ http://blog.numino.net/
rb_time datetime 8 1
u3Aagg http://blog.numino.net/
pz_time datetime 8 1
u8TFEO http://blog.numino.net/
3、MEMB_INFO
uyjFsN http://blog.numino.net/
列名 类型 长 是否空 说明
CtpzWk http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
Zixrm0 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
ixABV9 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
aX0rzF http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
7aARNM http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
sSlX89 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
IkFgQ2 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
jD3VEs http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
11LQe8 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
6e3AoW http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
rR9i45 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
ezrfB5 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
GBhtvh http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
Kk3gIY http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
ABRXs5 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
3P5899 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
lb0PI6 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
D6X6q0 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
Ls3iN0 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
F7n4Mb http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
ffBXNl http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
CCOEUR http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
5u8Y60 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
pY1vh5 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
mzL8jC http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
0RG1zd http://blog.numino.net/
QX char 1 1 --------B
nUhl3Q http://blog.numino.net/
JF int 4 0 --------0
6AF76A http://blog.numino.net/
huiy int 4 1 --------0
84MJ9Q http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
wg8tzz http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
xO04Oe http://blog.numino.net/
FDB int 4 1 --------0
JbM2AW http://blog.numino.net/
vip tinyint 1 1 --------0
515P58 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
I2V0ER http://blog.numino.net/
4、MEMB_STAT
fm6Ho8 http://blog.numino.net/
列名 类型 长 是否空 说明
ybLVre http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
4GRNlz http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
7o3x8A http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
qq4yIj http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
R624um http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
Pg1b2l http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
XlRC4D http://blog.numino.net/
5、warehouse
w4UuED http://blog.numino.net/
列名 类型 长 是否空 说明
A3h8L3 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
Uia71M http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
rVOXoN http://blog.numino.net/
Money int 4 1 --------钱
Fu9a2E http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
zzDk47 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
1p6181 http://blog.numino.net/
pw smallint 2 1 --------密码 0
J3U1Te http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
1u24q5 http://blog.numino.net/
ExtCKNum int 4 0 --------0
vgfvCT http://blog.numino.net/
NeedExtCK int 4 0 --------0
a8939X http://blog.numino.net/
6、VI_CURR_INFO
2PDI7P http://blog.numino.net/
列名 类型 长 是否空 说明
iE1wSv http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
L6Nw8g http://blog.numino.net/
chek_code nvarchar 1 0 --------1
XwZwcz http://blog.numino.net/
used_time int 4 1 --------1234
7p21w1 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
QmS4a0 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
O7mbEe http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
yW2q6M http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
lRhk2f http://blog.numino.net/
Bill_Section int 4 1 --------6
2XXE4j http://blog.numino.net/
Bill_Value int 4 1 --------3
YLWENp http://blog.numino.net/
Bill_Hour int 4 1 --------0
35MyKI http://blog.numino.net/
Surplus_Point int 4 1 --------0
eY9784 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
9JEIv3 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
0S65nP http://blog.numino.net/
7、WEB_ZS
mJLbZi http://blog.numino.net/
列名 类型 长 是否空 说明
rhfg5t http://blog.numino.net/
ID bigint 8 0
j372Oj http://blog.numino.net/
ACC char 10 1
s1lPIk http://blog.numino.net/
NAME char 10 1
J6p96H http://blog.numino.net/
ZSTIME datetime 8 1
YAHpfn http://blog.numino.net/
ZSCLEVEL smallint 2 1
L39WwV http://blog.numino.net/
ZSCS smallint 2 0
4JH1UC http://blog.numino.net/
CZCS smallint 2 0
OJ27t8 http://blog.numino.net/
CZTIME datetime 8 0
kengCK http://blog.numino.net/
ZJZSCS smallint 2 0
YaS5JF http://blog.numino.net/
GJZSCS smallint 2 0
lcAX9n http://blog.numino.net/
CJZSCS smallint 2 0
3JXU1a http://blog.numino.net/
BSCS smallint 2 0
2LZ8EH http://blog.numino.net/
BSTIME datetime 8 0
5i68KP http://blog.numino.net/
LEVELUPPOINT int 4 0
vOOXyy http://blog.numino.net/
GDDS int 4 0
|
|