| 奇迹muonline数据库基础库分析 |
一、表的组成：
XJQf8u http://blog.numino.net/
1、AccountCharacter
rPm8Mr http://blog.numino.net/
用来存放帐号的角色。
aJ7HPG http://blog.numino.net/
2、Character
dtNWLP http://blog.numino.net/
用来存放每个角色的详细数据。
B72s23 http://blog.numino.net/
3、MEMB_INFO
vErunH http://blog.numino.net/
帐号信息
cp3QB3 http://blog.numino.net/
4、MEMB_STAT
04OJeB http://blog.numino.net/
帐号状态
759hs0 http://blog.numino.net/
5、warehouse
XvgMLa http://blog.numino.net/
仓库
4VgPSw http://blog.numino.net/
6、VI_CURR_INFO
iIjqP4 http://blog.numino.net/
帐号费用
aA9gJM http://blog.numino.net/
7、WEB_ZS
u00LjW http://blog.numino.net/
PL 网站的转生数据
3LXLBy http://blog.numino.net/
二、各表说明
sP18l1 http://blog.numino.net/
1、AccountCharacter 表
186zaL http://blog.numino.net/
列名 类型 长 是否空 说明
NZbalh http://blog.numino.net/
Number int 4 0 自动增加的序数
9JmuvT http://blog.numino.net/
Id varchar 10 0 帐号
FKg6Zl http://blog.numino.net/
GameID1 varchar 10 1 角色1
tbKcyB http://blog.numino.net/
GameID2 varchar 10 1 角色2
P0R9fv http://blog.numino.net/
GameID3 varchar 10 1
XSeS8x http://blog.numino.net/
GameID4 varchar 10 1
Pl4kMK http://blog.numino.net/
GameID5 varchar 10 1
c0qbBH http://blog.numino.net/
GameIDC varchar 10 1
k5kbFa http://blog.numino.net/
2、Character 表
KxX14A http://blog.numino.net/
列名 类型 长 是否空 说明
Amef0j http://blog.numino.net/
AccountID varchar 10 0 --------帐号
6K9Hnt http://blog.numino.net/
Name nvarchar 10 0 --------角色名
87oLX3 http://blog.numino.net/
cLevel smallint 2 1 --------等级
rsVBK1 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
4B98C4 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
32LMKx http://blog.numino.net/
Experience int 4 1 --------经验
5Z67rj http://blog.numino.net/
Strength smallint 2 1 --------力量
4kA9ui http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
jmnKWC http://blog.numino.net/
Vitality smallint 2 1 --------体力
4FrgF0 http://blog.numino.net/
Energy smallint 2 1 --------智力
DgFX20 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
GTmLx0 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
jt5EJp http://blog.numino.net/
Money int 4 1 --------钱
s5NCYl http://blog.numino.net/
Life real 4 1 --------
oG0nBL http://blog.numino.net/
MaxLife real 4 1 --------
7yTpwq http://blog.numino.net/
Mana real 4 1 --------
k93CGh http://blog.numino.net/
MaxMana real 4 1 --------
eM9mDu http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
d3mM4s http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
7aKwqC http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
7F78cn http://blog.numino.net/
MapDir tinyint 1 1 --------
DL5vbW http://blog.numino.net/
PkCount int 4 1 --------
qQ7mzz http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
L499ko http://blog.numino.net/
PkTime int 4 1
KCX07r http://blog.numino.net/
MDate smalldatetime 4 1
UDWWbV http://blog.numino.net/
LDate smalldatetime 4 1
scG5US http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
UgtWeh http://blog.numino.net/
DbVersion tinyint 1 1
8cbKX7 http://blog.numino.net/
Quest varbinary 50 1
cwH88f http://blog.numino.net/
LINZB bit 1 0
4Fp74F http://blog.numino.net/
XDTIME datetime 8 0
5Apsi5 http://blog.numino.net/
STOPINFO nvarchar 100 1
Yh8wLx http://blog.numino.net/
STOPTIME datetime 8 0
u0o5Sa http://blog.numino.net/
zs_count int 4 1
m3K3C5 http://blog.numino.net/
zs_point int 4 1
oCmlQB http://blog.numino.net/
bs_count int 4 1
0oMJvW http://blog.numino.net/
bs_point int 4 1
Wb8TGh http://blog.numino.net/
shiji smalldatetime 4 1
qKB3N0 http://blog.numino.net/
banl nvarchar 10 1
kl9nry http://blog.numino.net/
lv_time datetime 8 1
MI24Mc http://blog.numino.net/
ex_ok int 4 1
44EC7S http://blog.numino.net/
ex_total int 4 1
OTfZTl http://blog.numino.net/
rb_count int 4 1
rvrMfT http://blog.numino.net/
rb_time datetime 8 1
Su1eyU http://blog.numino.net/
pz_time datetime 8 1
32FWM0 http://blog.numino.net/
3、MEMB_INFO
vTlxcs http://blog.numino.net/
列名 类型 长 是否空 说明
d3B43N http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
It5PBa http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
gpbkwI http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
Uf1V3k http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
WtBafP http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
eGcWGT http://blog.numino.net/
post_code nvarchar 6 1 --------1234
ImmSjs http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
L0fdum http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
odbl3z http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
z8Jcli http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
Nhe819 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
V9an6o http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
090f3L http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
93iXFa http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
FZHg5S http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
5Fhq5R http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
757CBq http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
J6M8tL http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
QT8v9k http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
2O6kUX http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
Kx0zJA http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
ykFwjv http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
997Mmv http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
CVaB5C http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
QpP8f3 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
ug3FvQ http://blog.numino.net/
QX char 1 1 --------B
j3POF7 http://blog.numino.net/
JF int 4 0 --------0
Edjj44 http://blog.numino.net/
huiy int 4 1 --------0
1PTt60 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
0uTTbF http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
59UJSH http://blog.numino.net/
FDB int 4 1 --------0
lclt2M http://blog.numino.net/
vip tinyint 1 1 --------0
YX835i http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
8YCn9M http://blog.numino.net/
4、MEMB_STAT
lIol2F http://blog.numino.net/
列名 类型 长 是否空 说明
2Nmstm http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
ZYTi5D http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
59PBQA http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
SEix24 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
UIsMz8 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
zO8QV4 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
LI1c5e http://blog.numino.net/
5、warehouse
c04wL6 http://blog.numino.net/
列名 类型 长 是否空 说明
jwWs7F http://blog.numino.net/
AccountID varchar 10 0 --------帐号
UusK3o http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
g7nNV1 http://blog.numino.net/
Money int 4 1 --------钱
R83AFv http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
v8jIRn http://blog.numino.net/
DbVersion tinyint 1 1 --------1
G0W9Y5 http://blog.numino.net/
pw smallint 2 1 --------密码 0
S3pGQH http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
s0oXkh http://blog.numino.net/
ExtCKNum int 4 0 --------0
10fpkJ http://blog.numino.net/
NeedExtCK int 4 0 --------0
fKXnu7 http://blog.numino.net/
6、VI_CURR_INFO
1WA16x http://blog.numino.net/
列名 类型 长 是否空 说明
19BXhY http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
A14Wv0 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
ykcF0T http://blog.numino.net/
used_time int 4 1 --------1234
7D2rE1 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
geynrY http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
ibc0Zc http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
6pjSVj http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
767vcU http://blog.numino.net/
Bill_Section int 4 1 --------6
4z2Sl5 http://blog.numino.net/
Bill_Value int 4 1 --------3
Icl3bT http://blog.numino.net/
Bill_Hour int 4 1 --------0
8EdK3M http://blog.numino.net/
Surplus_Point int 4 1 --------0
eH6P6K http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
5EtA2P http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
51O7n2 http://blog.numino.net/
7、WEB_ZS
57timw http://blog.numino.net/
列名 类型 长 是否空 说明
0vV5ur http://blog.numino.net/
ID bigint 8 0
Bv4A53 http://blog.numino.net/
ACC char 10 1
OS8Kmd http://blog.numino.net/
NAME char 10 1
0roMWW http://blog.numino.net/
ZSTIME datetime 8 1
5a4ELU http://blog.numino.net/
ZSCLEVEL smallint 2 1
i6OK1d http://blog.numino.net/
ZSCS smallint 2 0
oEKY07 http://blog.numino.net/
CZCS smallint 2 0
xn58NW http://blog.numino.net/
CZTIME datetime 8 0
SaQipd http://blog.numino.net/
ZJZSCS smallint 2 0
pN53yj http://blog.numino.net/
GJZSCS smallint 2 0
sOMllU http://blog.numino.net/
CJZSCS smallint 2 0
tS6tPy http://blog.numino.net/
BSCS smallint 2 0
CWslc5 http://blog.numino.net/
BSTIME datetime 8 0
ysNSZz http://blog.numino.net/
LEVELUPPOINT int 4 0
04kgw8 http://blog.numino.net/
GDDS int 4 0
|
|