| 奇迹muonline数据库基础库分析 |
一、表的组成：
9dm7Mv http://blog.numino.net/
1、AccountCharacter
vzbvh3 http://blog.numino.net/
用来存放帐号的角色。
1msR60 http://blog.numino.net/
2、Character
xN5Q31 http://blog.numino.net/
用来存放每个角色的详细数据。
p5743W http://blog.numino.net/
3、MEMB_INFO
PieJj8 http://blog.numino.net/
帐号信息
I02Ist http://blog.numino.net/
4、MEMB_STAT
1nYGpr http://blog.numino.net/
帐号状态
5ftSK5 http://blog.numino.net/
5、warehouse
y4gWy2 http://blog.numino.net/
仓库
wHEd03 http://blog.numino.net/
6、VI_CURR_INFO
Aauf1E http://blog.numino.net/
帐号费用
J55HWO http://blog.numino.net/
7、WEB_ZS
i1BfVH http://blog.numino.net/
PL 网站的转生数据
THx3zz http://blog.numino.net/
二、各表说明
x81bq1 http://blog.numino.net/
1、AccountCharacter 表
OCKHcW http://blog.numino.net/
列名 类型 长 是否空 说明
Ru1BL5 http://blog.numino.net/
Number int 4 0 自动增加的序数
22fsY9 http://blog.numino.net/
Id varchar 10 0 帐号
q8qzp5 http://blog.numino.net/
GameID1 varchar 10 1 角色1
i55J4x http://blog.numino.net/
GameID2 varchar 10 1 角色2
55yiOc http://blog.numino.net/
GameID3 varchar 10 1
UDMa3H http://blog.numino.net/
GameID4 varchar 10 1
b1zuGi http://blog.numino.net/
GameID5 varchar 10 1
QZK9Lt http://blog.numino.net/
GameIDC varchar 10 1
un42zc http://blog.numino.net/
2、Character 表
sLy1xk http://blog.numino.net/
列名 类型 长 是否空 说明
5Uox55 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
wexQnk http://blog.numino.net/
Name nvarchar 10 0 --------角色名
I5ewG3 http://blog.numino.net/
cLevel smallint 2 1 --------等级
VsL3jg http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
61ni1o http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
49pi36 http://blog.numino.net/
Experience int 4 1 --------经验
193jmJ http://blog.numino.net/
Strength smallint 2 1 --------力量
jpXO66 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
pQ16UL http://blog.numino.net/
Vitality smallint 2 1 --------体力
6lQaEF http://blog.numino.net/
Energy smallint 2 1 --------智力
7O821M http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
dSh6FW http://blog.numino.net/
MagicList varbinary 60 1 --------技能
a09NMV http://blog.numino.net/
Money int 4 1 --------钱
5YOtyA http://blog.numino.net/
Life real 4 1 --------
FkcrCg http://blog.numino.net/
MaxLife real 4 1 --------
HnLZ09 http://blog.numino.net/
Mana real 4 1 --------
ta1vE7 http://blog.numino.net/
MaxMana real 4 1 --------
v49C92 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
4ESu53 http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
jD72Y2 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
2a7qC5 http://blog.numino.net/
MapDir tinyint 1 1 --------
rrd45S http://blog.numino.net/
PkCount int 4 1 --------
N5ncD6 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
8nuuFr http://blog.numino.net/
PkTime int 4 1
P3qyfd http://blog.numino.net/
MDate smalldatetime 4 1
Rog81S http://blog.numino.net/
LDate smalldatetime 4 1
z9t8JS http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
PHFUFL http://blog.numino.net/
DbVersion tinyint 1 1
4GkJ96 http://blog.numino.net/
Quest varbinary 50 1
YBDcXm http://blog.numino.net/
LINZB bit 1 0
6k5tMI http://blog.numino.net/
XDTIME datetime 8 0
r7qsv0 http://blog.numino.net/
STOPINFO nvarchar 100 1
TjZ86P http://blog.numino.net/
STOPTIME datetime 8 0
azzmRb http://blog.numino.net/
zs_count int 4 1
HmVYMC http://blog.numino.net/
zs_point int 4 1
TID0QH http://blog.numino.net/
bs_count int 4 1
95T1us http://blog.numino.net/
bs_point int 4 1
T18b7s http://blog.numino.net/
shiji smalldatetime 4 1
9uLtZ0 http://blog.numino.net/
banl nvarchar 10 1
vFf4B7 http://blog.numino.net/
lv_time datetime 8 1
fgJnOJ http://blog.numino.net/
ex_ok int 4 1
X6qxSD http://blog.numino.net/
ex_total int 4 1
yAwTF3 http://blog.numino.net/
rb_count int 4 1
9UJjqK http://blog.numino.net/
rb_time datetime 8 1
xq6bAq http://blog.numino.net/
pz_time datetime 8 1
a7XhnR http://blog.numino.net/
3、MEMB_INFO
KJqJT4 http://blog.numino.net/
列名 类型 长 是否空 说明
3jxA1R http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
6e86xU http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
4FRdIs http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
ZuFaw7 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
5I1UTH http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
DDpW5G http://blog.numino.net/
post_code nvarchar 6 1 --------1234
zf8GQ7 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
RD7yEI http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
1JbQh3 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
pnq9vc http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
4nEuGC http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
FFKM1c http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
Y1R1YM http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
YW4aVh http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
i5YIJK http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
3fa5k1 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
j50LJ1 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
3HKa5T http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
fvypKw http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
VbZmGV http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
lnWruV http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
poan0f http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
PbCrWz http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
drg8Us http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
38S1uM http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
u5Po6o http://blog.numino.net/
QX char 1 1 --------B
q19M4N http://blog.numino.net/
JF int 4 0 --------0
B0oc8q http://blog.numino.net/
huiy int 4 1 --------0
zw3I8O http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
7O04HC http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
Y65C6s http://blog.numino.net/
FDB int 4 1 --------0
6xWulg http://blog.numino.net/
vip tinyint 1 1 --------0
HO5I3f http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
tJxA19 http://blog.numino.net/
4、MEMB_STAT
3rsbg3 http://blog.numino.net/
列名 类型 长 是否空 说明
rwNEE0 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
JNjf41 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
197IwN http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
65XpOj http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
Daj2wG http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
o8Piq3 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
LHoM9j http://blog.numino.net/
5、warehouse
y60Puo http://blog.numino.net/
列名 类型 长 是否空 说明
dzm752 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
3x4MOr http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
o5JO1t http://blog.numino.net/
Money int 4 1 --------钱
xVBZW7 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
ID3MnC http://blog.numino.net/
DbVersion tinyint 1 1 --------1
m150t8 http://blog.numino.net/
pw smallint 2 1 --------密码 0
jd6IMB http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
55UEYA http://blog.numino.net/
ExtCKNum int 4 0 --------0
wdXkxF http://blog.numino.net/
NeedExtCK int 4 0 --------0
jEZrXL http://blog.numino.net/
6、VI_CURR_INFO
AAgHow http://blog.numino.net/
列名 类型 长 是否空 说明
yeAQsV http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
97jqhK http://blog.numino.net/
chek_code nvarchar 1 0 --------1
vm5RO7 http://blog.numino.net/
used_time int 4 1 --------1234
adY4Nt http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
qPIWps http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
Zj34Mk http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
v0yGkD http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
J0n2K3 http://blog.numino.net/
Bill_Section int 4 1 --------6
tfEi5N http://blog.numino.net/
Bill_Value int 4 1 --------3
qLoNp4 http://blog.numino.net/
Bill_Hour int 4 1 --------0
Hsqh0W http://blog.numino.net/
Surplus_Point int 4 1 --------0
I36DqO http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
wfXjP0 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
Mu2840 http://blog.numino.net/
7、WEB_ZS
t31LlM http://blog.numino.net/
列名 类型 长 是否空 说明
ZVuAHB http://blog.numino.net/
ID bigint 8 0
j0ipuC http://blog.numino.net/
ACC char 10 1
pJe5Jp http://blog.numino.net/
NAME char 10 1
vN3DnZ http://blog.numino.net/
ZSTIME datetime 8 1
EJN1af http://blog.numino.net/
ZSCLEVEL smallint 2 1
6DqB0q http://blog.numino.net/
ZSCS smallint 2 0
QDrtlu http://blog.numino.net/
CZCS smallint 2 0
nHqdR8 http://blog.numino.net/
CZTIME datetime 8 0
2ezlMX http://blog.numino.net/
ZJZSCS smallint 2 0
rUK8dk http://blog.numino.net/
GJZSCS smallint 2 0
qB81n0 http://blog.numino.net/
CJZSCS smallint 2 0
phU4Y1 http://blog.numino.net/
BSCS smallint 2 0
db5KUA http://blog.numino.net/
BSTIME datetime 8 0
yv9JWp http://blog.numino.net/
LEVELUPPOINT int 4 0
Yvlhg0 http://blog.numino.net/
GDDS int 4 0
|
|