| 奇迹muonline数据库基础库分析 |
一、表的组成：
sRBa5Z http://blog.numino.net/
1、AccountCharacter
nHcmwD http://blog.numino.net/
用来存放帐号的角色。
BCMB1W http://blog.numino.net/
2、Character
Bv8kS2 http://blog.numino.net/
用来存放每个角色的详细数据。
qhqV9E http://blog.numino.net/
3、MEMB_INFO
F1EbVy http://blog.numino.net/
帐号信息
vqB829 http://blog.numino.net/
4、MEMB_STAT
hJAbp0 http://blog.numino.net/
帐号状态
EVeMI6 http://blog.numino.net/
5、warehouse
X3nSPO http://blog.numino.net/
仓库
L0VTBr http://blog.numino.net/
6、VI_CURR_INFO
rKwpdm http://blog.numino.net/
帐号费用
nNvCQl http://blog.numino.net/
7、WEB_ZS
vU19EO http://blog.numino.net/
PL 网站的转生数据
VKfl0N http://blog.numino.net/
二、各表说明
5R4w85 http://blog.numino.net/
1、AccountCharacter 表
o5hoYX http://blog.numino.net/
列名 类型 长 是否空 说明
J6rdtE http://blog.numino.net/
Number int 4 0 自动增加的序数
kL0saO http://blog.numino.net/
Id varchar 10 0 帐号
Kl7cjF http://blog.numino.net/
GameID1 varchar 10 1 角色1
X4I1H3 http://blog.numino.net/
GameID2 varchar 10 1 角色2
FkuE89 http://blog.numino.net/
GameID3 varchar 10 1
52qyGz http://blog.numino.net/
GameID4 varchar 10 1
B85Je0 http://blog.numino.net/
GameID5 varchar 10 1
gkyz99 http://blog.numino.net/
GameIDC varchar 10 1
p0s25y http://blog.numino.net/
2、Character 表
WBha0z http://blog.numino.net/
列名 类型 长 是否空 说明
tG53aD http://blog.numino.net/
AccountID varchar 10 0 --------帐号
qoq8Ch http://blog.numino.net/
Name nvarchar 10 0 --------角色名
hi3Hpf http://blog.numino.net/
cLevel smallint 2 1 --------等级
vG3vJ4 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
tH8p37 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
2IT6X4 http://blog.numino.net/
Experience int 4 1 --------经验
Nt9R9k http://blog.numino.net/
Strength smallint 2 1 --------力量
E19MtD http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
duqca6 http://blog.numino.net/
Vitality smallint 2 1 --------体力
2RSahA http://blog.numino.net/
Energy smallint 2 1 --------智力
5Oru33 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
CCFk2l http://blog.numino.net/
MagicList varbinary 60 1 --------技能
E601ZX http://blog.numino.net/
Money int 4 1 --------钱
S5xZhb http://blog.numino.net/
Life real 4 1 --------
KFCg16 http://blog.numino.net/
MaxLife real 4 1 --------
HbxFwE http://blog.numino.net/
Mana real 4 1 --------
JRznJT http://blog.numino.net/
MaxMana real 4 1 --------
nhAQF2 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
oDfNTX http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
Z0dTk3 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
LXHVYp http://blog.numino.net/
MapDir tinyint 1 1 --------
H5p68r http://blog.numino.net/
PkCount int 4 1 --------
v8q93G http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
U8hSMs http://blog.numino.net/
PkTime int 4 1
33yT5Q http://blog.numino.net/
MDate smalldatetime 4 1
SO7WVA http://blog.numino.net/
LDate smalldatetime 4 1
hOavnO http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
963GBf http://blog.numino.net/
DbVersion tinyint 1 1
hYgFGb http://blog.numino.net/
Quest varbinary 50 1
PEwk5u http://blog.numino.net/
LINZB bit 1 0
Vi89J0 http://blog.numino.net/
XDTIME datetime 8 0
rKz0T6 http://blog.numino.net/
STOPINFO nvarchar 100 1
w4Pk70 http://blog.numino.net/
STOPTIME datetime 8 0
GdrDLA http://blog.numino.net/
zs_count int 4 1
buFb6W http://blog.numino.net/
zs_point int 4 1
tomrt7 http://blog.numino.net/
bs_count int 4 1
Hc9437 http://blog.numino.net/
bs_point int 4 1
EVinA5 http://blog.numino.net/
shiji smalldatetime 4 1
FI0n4l http://blog.numino.net/
banl nvarchar 10 1
Npz558 http://blog.numino.net/
lv_time datetime 8 1
5PLAb9 http://blog.numino.net/
ex_ok int 4 1
JwM3t9 http://blog.numino.net/
ex_total int 4 1
Evx9b8 http://blog.numino.net/
rb_count int 4 1
TmiThl http://blog.numino.net/
rb_time datetime 8 1
Hhk87B http://blog.numino.net/
pz_time datetime 8 1
z3dF44 http://blog.numino.net/
3、MEMB_INFO
51QMdN http://blog.numino.net/
列名 类型 长 是否空 说明
clK1i0 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
hkFgF8 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
f2e6fg http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
Me6KJ1 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
0776Yh http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
5xIxf4 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
Vljr7u http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
qdgFhu http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
aPJNs4 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
G1gCfU http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
xjpIei http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
ZZ1NYk http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
XW1skK http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
Zd21a3 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
6HH2ha http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
tQDL3j http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
nnX9hG http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
nhjz2F http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
qvT287 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
OwvmNe http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
1Regnd http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
0bL16R http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
4qJQGF http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
3l0ace http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
vEVAcf http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
NRC2Ka http://blog.numino.net/
QX char 1 1 --------B
JXNEUo http://blog.numino.net/
JF int 4 0 --------0
RSjb81 http://blog.numino.net/
huiy int 4 1 --------0
MhDd39 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
iCqfOR http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
CybBfK http://blog.numino.net/
FDB int 4 1 --------0
7HTg6I http://blog.numino.net/
vip tinyint 1 1 --------0
97MH0a http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
NObZuT http://blog.numino.net/
4、MEMB_STAT
kj8my6 http://blog.numino.net/
列名 类型 长 是否空 说明
r3v1Li http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
QgjcCM http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
1Sx1VJ http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
CjMH8K http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
4d83Wq http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
zfA3Z5 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
1wGPdi http://blog.numino.net/
5、warehouse
S351pE http://blog.numino.net/
列名 类型 长 是否空 说明
6elIVh http://blog.numino.net/
AccountID varchar 10 0 --------帐号
e9pml8 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
HHIs38 http://blog.numino.net/
Money int 4 1 --------钱
TG65OY http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
PdpVhu http://blog.numino.net/
DbVersion tinyint 1 1 --------1
Iaz2ZD http://blog.numino.net/
pw smallint 2 1 --------密码 0
62UcFW http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
lxTY36 http://blog.numino.net/
ExtCKNum int 4 0 --------0
KKg0w8 http://blog.numino.net/
NeedExtCK int 4 0 --------0
fUH9AG http://blog.numino.net/
6、VI_CURR_INFO
TmW249 http://blog.numino.net/
列名 类型 长 是否空 说明
3ovp8I http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
1B621m http://blog.numino.net/
chek_code nvarchar 1 0 --------1
9VMkE8 http://blog.numino.net/
used_time int 4 1 --------1234
aL0qFq http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
8Xfzsb http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
u3a4aj http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
Ex8kn1 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
dhGBV6 http://blog.numino.net/
Bill_Section int 4 1 --------6
80W0g0 http://blog.numino.net/
Bill_Value int 4 1 --------3
ItARlH http://blog.numino.net/
Bill_Hour int 4 1 --------0
WiLuG3 http://blog.numino.net/
Surplus_Point int 4 1 --------0
Kv54at http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
7QFYoM http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
YwO2fs http://blog.numino.net/
7、WEB_ZS
zszfM8 http://blog.numino.net/
列名 类型 长 是否空 说明
7l4554 http://blog.numino.net/
ID bigint 8 0
k11RAC http://blog.numino.net/
ACC char 10 1
ltlh4N http://blog.numino.net/
NAME char 10 1
N5r6b0 http://blog.numino.net/
ZSTIME datetime 8 1
IprqeG http://blog.numino.net/
ZSCLEVEL smallint 2 1
9au4Ph http://blog.numino.net/
ZSCS smallint 2 0
2W84Jl http://blog.numino.net/
CZCS smallint 2 0
Kl03xY http://blog.numino.net/
CZTIME datetime 8 0
23t7r8 http://blog.numino.net/
ZJZSCS smallint 2 0
PUiys9 http://blog.numino.net/
GJZSCS smallint 2 0
5YpmPA http://blog.numino.net/
CJZSCS smallint 2 0
crWpMu http://blog.numino.net/
BSCS smallint 2 0
Y86VPq http://blog.numino.net/
BSTIME datetime 8 0
I1562n http://blog.numino.net/
LEVELUPPOINT int 4 0
4lHeHr http://blog.numino.net/
GDDS int 4 0
|
|