| 奇迹muonline数据库基础库分析 |
一、表的组成：
gOI9VU http://blog.numino.net/
1、AccountCharacter
9R8uuz http://blog.numino.net/
用来存放帐号的角色。
ank80K http://blog.numino.net/
2、Character
O5RGuF http://blog.numino.net/
用来存放每个角色的详细数据。
i6o1OG http://blog.numino.net/
3、MEMB_INFO
o1id7I http://blog.numino.net/
帐号信息
87pKGo http://blog.numino.net/
4、MEMB_STAT
Kk1p63 http://blog.numino.net/
帐号状态
yllCOT http://blog.numino.net/
5、warehouse
D2Ucxw http://blog.numino.net/
仓库
TlHWq4 http://blog.numino.net/
6、VI_CURR_INFO
Ek5Yfm http://blog.numino.net/
帐号费用
lS090M http://blog.numino.net/
7、WEB_ZS
67HzTK http://blog.numino.net/
PL 网站的转生数据
zuZff0 http://blog.numino.net/
二、各表说明
l7hrRt http://blog.numino.net/
1、AccountCharacter 表
2orRno http://blog.numino.net/
列名 类型 长 是否空 说明
9UyJJ5 http://blog.numino.net/
Number int 4 0 自动增加的序数
5vn7N1 http://blog.numino.net/
Id varchar 10 0 帐号
30N5q5 http://blog.numino.net/
GameID1 varchar 10 1 角色1
a6cDA5 http://blog.numino.net/
GameID2 varchar 10 1 角色2
W66Pj8 http://blog.numino.net/
GameID3 varchar 10 1
247h8X http://blog.numino.net/
GameID4 varchar 10 1
ar3mBu http://blog.numino.net/
GameID5 varchar 10 1
ZJqClz http://blog.numino.net/
GameIDC varchar 10 1
M9r9SK http://blog.numino.net/
2、Character 表
6Z0Qem http://blog.numino.net/
列名 类型 长 是否空 说明
MqH211 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
VDEODc http://blog.numino.net/
Name nvarchar 10 0 --------角色名
8mSr40 http://blog.numino.net/
cLevel smallint 2 1 --------等级
ReTVG3 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
cx0oGw http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
Z58IS9 http://blog.numino.net/
Experience int 4 1 --------经验
8ZZ4FO http://blog.numino.net/
Strength smallint 2 1 --------力量
hfbit8 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
9Z30Zm http://blog.numino.net/
Vitality smallint 2 1 --------体力
2pjx15 http://blog.numino.net/
Energy smallint 2 1 --------智力
2LkBdk http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
1t6njY http://blog.numino.net/
MagicList varbinary 60 1 --------技能
bC8v83 http://blog.numino.net/
Money int 4 1 --------钱
75Pa9M http://blog.numino.net/
Life real 4 1 --------
m8jhy3 http://blog.numino.net/
MaxLife real 4 1 --------
L2KMCd http://blog.numino.net/
Mana real 4 1 --------
1v1pu8 http://blog.numino.net/
MaxMana real 4 1 --------
3QDmbT http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
P983dh http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
D6784q http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
BakzLO http://blog.numino.net/
MapDir tinyint 1 1 --------
BHL0gY http://blog.numino.net/
PkCount int 4 1 --------
v2s34u http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
qR47mX http://blog.numino.net/
PkTime int 4 1
f0OC6R http://blog.numino.net/
MDate smalldatetime 4 1
Gk7u7M http://blog.numino.net/
LDate smalldatetime 4 1
UOTvUW http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
z1sPjI http://blog.numino.net/
DbVersion tinyint 1 1
oEAD5S http://blog.numino.net/
Quest varbinary 50 1
EY5WST http://blog.numino.net/
LINZB bit 1 0
E1j9aH http://blog.numino.net/
XDTIME datetime 8 0
Jt8vh6 http://blog.numino.net/
STOPINFO nvarchar 100 1
C7d2XU http://blog.numino.net/
STOPTIME datetime 8 0
vCy8Oy http://blog.numino.net/
zs_count int 4 1
e2T7nw http://blog.numino.net/
zs_point int 4 1
F4oHjb http://blog.numino.net/
bs_count int 4 1
sq34RI http://blog.numino.net/
bs_point int 4 1
X0988V http://blog.numino.net/
shiji smalldatetime 4 1
Ky0p73 http://blog.numino.net/
banl nvarchar 10 1
A3gvWp http://blog.numino.net/
lv_time datetime 8 1
5X6zoZ http://blog.numino.net/
ex_ok int 4 1
Htcm92 http://blog.numino.net/
ex_total int 4 1
up3IhW http://blog.numino.net/
rb_count int 4 1
XWA3t2 http://blog.numino.net/
rb_time datetime 8 1
3JAr5n http://blog.numino.net/
pz_time datetime 8 1
Vzpciq http://blog.numino.net/
3、MEMB_INFO
WHlzcv http://blog.numino.net/
列名 类型 长 是否空 说明
3UO53E http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
UY1rKR http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Z8llzo http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
Dr7QTB http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
Asxg9K http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
BSDe69 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
Zz4Nyf http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
0WouC6 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
qc6c2t http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
msHdCM http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
37eZu5 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
el1NSf http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
KjsuVd http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
l45kW9 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
tGj8xD http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
12w2Od http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
2BMt1Z http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Mxse4T http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
w39BeA http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
RTtyuh http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
1jGN10 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
MdIClb http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
V56q8d http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
UTa5v4 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
rK5637 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
aE4Oq4 http://blog.numino.net/
QX char 1 1 --------B
GXh7MG http://blog.numino.net/
JF int 4 0 --------0
Hg1hNl http://blog.numino.net/
huiy int 4 1 --------0
7hecR7 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
t9qLB2 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
NYdRCr http://blog.numino.net/
FDB int 4 1 --------0
587zXS http://blog.numino.net/
vip tinyint 1 1 --------0
g1AHnl http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
59Oa8L http://blog.numino.net/
4、MEMB_STAT
X7470N http://blog.numino.net/
列名 类型 长 是否空 说明
99qOZd http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
E4jV96 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
Eo9Nd2 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
av2s68 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
ZJvrs8 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
7xZD3D http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
aXr9Xq http://blog.numino.net/
5、warehouse
T6XxQs http://blog.numino.net/
列名 类型 长 是否空 说明
0nGdwj http://blog.numino.net/
AccountID varchar 10 0 --------帐号
Is74SA http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
RRoait http://blog.numino.net/
Money int 4 1 --------钱
0y2vYK http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
Ric074 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
LAqGfj http://blog.numino.net/
pw smallint 2 1 --------密码 0
0360aO http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
l3D1Cp http://blog.numino.net/
ExtCKNum int 4 0 --------0
kUAg9g http://blog.numino.net/
NeedExtCK int 4 0 --------0
42llyw http://blog.numino.net/
6、VI_CURR_INFO
AHfD1t http://blog.numino.net/
列名 类型 长 是否空 说明
h78rEU http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
7f2G1h http://blog.numino.net/
chek_code nvarchar 1 0 --------1
thF9nX http://blog.numino.net/
used_time int 4 1 --------1234
7FUJjm http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
ULMB45 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
lKapLn http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
3oGr4a http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
IHscm6 http://blog.numino.net/
Bill_Section int 4 1 --------6
D4pShY http://blog.numino.net/
Bill_Value int 4 1 --------3
Gm3WrP http://blog.numino.net/
Bill_Hour int 4 1 --------0
v2srW4 http://blog.numino.net/
Surplus_Point int 4 1 --------0
f075bj http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
dzmjmX http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
Zp0tnD http://blog.numino.net/
7、WEB_ZS
88YoL3 http://blog.numino.net/
列名 类型 长 是否空 说明
dn1sgG http://blog.numino.net/
ID bigint 8 0
xACYqA http://blog.numino.net/
ACC char 10 1
IrRgnx http://blog.numino.net/
NAME char 10 1
kdcql3 http://blog.numino.net/
ZSTIME datetime 8 1
mvkEq5 http://blog.numino.net/
ZSCLEVEL smallint 2 1
FuMZ99 http://blog.numino.net/
ZSCS smallint 2 0
02sGoL http://blog.numino.net/
CZCS smallint 2 0
qPYQnk http://blog.numino.net/
CZTIME datetime 8 0
J073fL http://blog.numino.net/
ZJZSCS smallint 2 0
5aduSU http://blog.numino.net/
GJZSCS smallint 2 0
99YfNq http://blog.numino.net/
CJZSCS smallint 2 0
L177rh http://blog.numino.net/
BSCS smallint 2 0
D3KCzQ http://blog.numino.net/
BSTIME datetime 8 0
D9lyU3 http://blog.numino.net/
LEVELUPPOINT int 4 0
gGLOS7 http://blog.numino.net/
GDDS int 4 0
|
|