| 奇迹muonline数据库基础库分析 |
一、表的组成：
0Ii09c http://blog.numino.net/
1、AccountCharacter
Jb8d2D http://blog.numino.net/
用来存放帐号的角色。
fmCa8R http://blog.numino.net/
2、Character
jbJ6X7 http://blog.numino.net/
用来存放每个角色的详细数据。
C3aKTe http://blog.numino.net/
3、MEMB_INFO
2kf9RL http://blog.numino.net/
帐号信息
ef35V0 http://blog.numino.net/
4、MEMB_STAT
C7rZ6x http://blog.numino.net/
帐号状态
9Y5x6m http://blog.numino.net/
5、warehouse
Hp7uu3 http://blog.numino.net/
仓库
63ssAh http://blog.numino.net/
6、VI_CURR_INFO
S8ClGl http://blog.numino.net/
帐号费用
rRi0y5 http://blog.numino.net/
7、WEB_ZS
vwGzl8 http://blog.numino.net/
PL 网站的转生数据
9YyWEz http://blog.numino.net/
二、各表说明
DaKrmN http://blog.numino.net/
1、AccountCharacter 表
4V0A6r http://blog.numino.net/
列名 类型 长 是否空 说明
Gfvj2u http://blog.numino.net/
Number int 4 0 自动增加的序数
nei5nJ http://blog.numino.net/
Id varchar 10 0 帐号
XVLBWM http://blog.numino.net/
GameID1 varchar 10 1 角色1
TpC7Gn http://blog.numino.net/
GameID2 varchar 10 1 角色2
hVXktG http://blog.numino.net/
GameID3 varchar 10 1
m1w1ki http://blog.numino.net/
GameID4 varchar 10 1
N07c9q http://blog.numino.net/
GameID5 varchar 10 1
gvNmd1 http://blog.numino.net/
GameIDC varchar 10 1
1BzFJA http://blog.numino.net/
2、Character 表
MzhcN1 http://blog.numino.net/
列名 类型 长 是否空 说明
hg7NzF http://blog.numino.net/
AccountID varchar 10 0 --------帐号
AtzO8t http://blog.numino.net/
Name nvarchar 10 0 --------角色名
o0IqmN http://blog.numino.net/
cLevel smallint 2 1 --------等级
P9au79 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
O899MZ http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
8gT6r8 http://blog.numino.net/
Experience int 4 1 --------经验
FqW7fu http://blog.numino.net/
Strength smallint 2 1 --------力量
74eVIp http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
ddxsIz http://blog.numino.net/
Vitality smallint 2 1 --------体力
402Tv0 http://blog.numino.net/
Energy smallint 2 1 --------智力
7QWR6r http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
OH9cIY http://blog.numino.net/
MagicList varbinary 60 1 --------技能
h65i15 http://blog.numino.net/
Money int 4 1 --------钱
XDqeA8 http://blog.numino.net/
Life real 4 1 --------
84rRBO http://blog.numino.net/
MaxLife real 4 1 --------
6Pzns6 http://blog.numino.net/
Mana real 4 1 --------
qn2Czh http://blog.numino.net/
MaxMana real 4 1 --------
3nq0nQ http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
64Ivdl http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
FK5vsu http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
9HNuGQ http://blog.numino.net/
MapDir tinyint 1 1 --------
6ohWPN http://blog.numino.net/
PkCount int 4 1 --------
nldvd7 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
iBN2jZ http://blog.numino.net/
PkTime int 4 1
oW54Kp http://blog.numino.net/
MDate smalldatetime 4 1
3Nni19 http://blog.numino.net/
LDate smalldatetime 4 1
v1luiv http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
du60lT http://blog.numino.net/
DbVersion tinyint 1 1
zUnkOA http://blog.numino.net/
Quest varbinary 50 1
62IQV8 http://blog.numino.net/
LINZB bit 1 0
lNlCQq http://blog.numino.net/
XDTIME datetime 8 0
qY5gj9 http://blog.numino.net/
STOPINFO nvarchar 100 1
316NGn http://blog.numino.net/
STOPTIME datetime 8 0
ojce8y http://blog.numino.net/
zs_count int 4 1
iPduyW http://blog.numino.net/
zs_point int 4 1
O28Yhk http://blog.numino.net/
bs_count int 4 1
Av5C1D http://blog.numino.net/
bs_point int 4 1
AlqlrU http://blog.numino.net/
shiji smalldatetime 4 1
kZoE0C http://blog.numino.net/
banl nvarchar 10 1
gmT67v http://blog.numino.net/
lv_time datetime 8 1
uIChWG http://blog.numino.net/
ex_ok int 4 1
xUDRmW http://blog.numino.net/
ex_total int 4 1
21BdCb http://blog.numino.net/
rb_count int 4 1
X0yY8f http://blog.numino.net/
rb_time datetime 8 1
aq8ro4 http://blog.numino.net/
pz_time datetime 8 1
Tc42di http://blog.numino.net/
3、MEMB_INFO
6HRNX2 http://blog.numino.net/
列名 类型 长 是否空 说明
trEUGz http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
FSznUf http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Sw0qAK http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
ZmBEFe http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
26LIKr http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
f2ETKK http://blog.numino.net/
post_code nvarchar 6 1 --------1234
6kpb6H http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
2a8Jls http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
pvGHWN http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
a3FK6V http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
1iAd3N http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
45ALqE http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
Jv0Qh5 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
k26Hw7 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
FaLu2z http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
AQ7lv1 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
skAfvD http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
9KsQbn http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
Brf2yk http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
2KPX80 http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
nnUP5Q http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
QhOQaO http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
AuS1EB http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
3R0K5F http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
ivN7oV http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
w7NTD7 http://blog.numino.net/
QX char 1 1 --------B
ifK1Ik http://blog.numino.net/
JF int 4 0 --------0
52oH62 http://blog.numino.net/
huiy int 4 1 --------0
zjgtT0 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
6YMsl2 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
A6ulTC http://blog.numino.net/
FDB int 4 1 --------0
iJo1O5 http://blog.numino.net/
vip tinyint 1 1 --------0
OKePpX http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
ix0Uqf http://blog.numino.net/
4、MEMB_STAT
Ct6Ike http://blog.numino.net/
列名 类型 长 是否空 说明
TC4E7a http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
861FU8 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
4E554s http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
9eZafV http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
0l5wES http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
BXEB1f http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
4Xg9i5 http://blog.numino.net/
5、warehouse
cJo7NO http://blog.numino.net/
列名 类型 长 是否空 说明
0KiH9I http://blog.numino.net/
AccountID varchar 10 0 --------帐号
2A1EeO http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
FFMo3a http://blog.numino.net/
Money int 4 1 --------钱
TLn32P http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
8evQhT http://blog.numino.net/
DbVersion tinyint 1 1 --------1
N3wDyo http://blog.numino.net/
pw smallint 2 1 --------密码 0
uL9Gfj http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
n87lF9 http://blog.numino.net/
ExtCKNum int 4 0 --------0
rUUw3L http://blog.numino.net/
NeedExtCK int 4 0 --------0
qGjd42 http://blog.numino.net/
6、VI_CURR_INFO
5RP8Yo http://blog.numino.net/
列名 类型 长 是否空 说明
w4kDx9 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
2jQSjC http://blog.numino.net/
chek_code nvarchar 1 0 --------1
Bt18Jt http://blog.numino.net/
used_time int 4 1 --------1234
W53S97 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
9eLExp http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
moSsD6 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
bhM1LL http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
IvdxFu http://blog.numino.net/
Bill_Section int 4 1 --------6
CW6eIN http://blog.numino.net/
Bill_Value int 4 1 --------3
6eS2vs http://blog.numino.net/
Bill_Hour int 4 1 --------0
w7bG7E http://blog.numino.net/
Surplus_Point int 4 1 --------0
a4laU9 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
1B2oFw http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
9KASC8 http://blog.numino.net/
7、WEB_ZS
SnbFbQ http://blog.numino.net/
列名 类型 长 是否空 说明
BYaG49 http://blog.numino.net/
ID bigint 8 0
6di0s2 http://blog.numino.net/
ACC char 10 1
CKI96C http://blog.numino.net/
NAME char 10 1
J7Ip7W http://blog.numino.net/
ZSTIME datetime 8 1
s3lQPN http://blog.numino.net/
ZSCLEVEL smallint 2 1
Nqn7n6 http://blog.numino.net/
ZSCS smallint 2 0
zC2H7W http://blog.numino.net/
CZCS smallint 2 0
DdRPDL http://blog.numino.net/
CZTIME datetime 8 0
HPPH13 http://blog.numino.net/
ZJZSCS smallint 2 0
rS71gE http://blog.numino.net/
GJZSCS smallint 2 0
4cTmvm http://blog.numino.net/
CJZSCS smallint 2 0
V41s1y http://blog.numino.net/
BSCS smallint 2 0
0niwxr http://blog.numino.net/
BSTIME datetime 8 0
MlTdmV http://blog.numino.net/
LEVELUPPOINT int 4 0
e0boAa http://blog.numino.net/
GDDS int 4 0
|
|