| 奇迹muonline数据库基础库分析 |
一、表的组成：
1DOMGP http://blog.numino.net/
1、AccountCharacter
LMkPWY http://blog.numino.net/
用来存放帐号的角色。
pj271n http://blog.numino.net/
2、Character
zKb5vB http://blog.numino.net/
用来存放每个角色的详细数据。
sPM1G9 http://blog.numino.net/
3、MEMB_INFO
6Y4hvK http://blog.numino.net/
帐号信息
2UzEC0 http://blog.numino.net/
4、MEMB_STAT
omLN4Y http://blog.numino.net/
帐号状态
sIhysj http://blog.numino.net/
5、warehouse
rZ3s85 http://blog.numino.net/
仓库
j10njK http://blog.numino.net/
6、VI_CURR_INFO
q1p3IW http://blog.numino.net/
帐号费用
18Odoc http://blog.numino.net/
7、WEB_ZS
j3uMNA http://blog.numino.net/
PL 网站的转生数据
Exz2Ce http://blog.numino.net/
二、各表说明
Oit6bW http://blog.numino.net/
1、AccountCharacter 表
Y1Lk9z http://blog.numino.net/
列名 类型 长 是否空 说明
HCtJkO http://blog.numino.net/
Number int 4 0 自动增加的序数
DqTYQb http://blog.numino.net/
Id varchar 10 0 帐号
Wc7r0d http://blog.numino.net/
GameID1 varchar 10 1 角色1
Yrm7D3 http://blog.numino.net/
GameID2 varchar 10 1 角色2
qWQI36 http://blog.numino.net/
GameID3 varchar 10 1
o92I13 http://blog.numino.net/
GameID4 varchar 10 1
lNWPNJ http://blog.numino.net/
GameID5 varchar 10 1
9zc5Ac http://blog.numino.net/
GameIDC varchar 10 1
Yl4onc http://blog.numino.net/
2、Character 表
XX82cB http://blog.numino.net/
列名 类型 长 是否空 说明
27j3SN http://blog.numino.net/
AccountID varchar 10 0 --------帐号
kZ3Djr http://blog.numino.net/
Name nvarchar 10 0 --------角色名
v6WZ5c http://blog.numino.net/
cLevel smallint 2 1 --------等级
d8JoYY http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
O26F1J http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
Buj458 http://blog.numino.net/
Experience int 4 1 --------经验
yZ0q4Z http://blog.numino.net/
Strength smallint 2 1 --------力量
j7h8Gy http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
GEce8J http://blog.numino.net/
Vitality smallint 2 1 --------体力
iJWVZx http://blog.numino.net/
Energy smallint 2 1 --------智力
OSqb81 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
q2nM7N http://blog.numino.net/
MagicList varbinary 60 1 --------技能
C8W38W http://blog.numino.net/
Money int 4 1 --------钱
R8nU2R http://blog.numino.net/
Life real 4 1 --------
ONVyhp http://blog.numino.net/
MaxLife real 4 1 --------
cemEv0 http://blog.numino.net/
Mana real 4 1 --------
340STs http://blog.numino.net/
MaxMana real 4 1 --------
02iFdV http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
PrbuqK http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
jXLC36 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
162Vq7 http://blog.numino.net/
MapDir tinyint 1 1 --------
F56lgj http://blog.numino.net/
PkCount int 4 1 --------
v7PtnY http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
r0gMeG http://blog.numino.net/
PkTime int 4 1
KVLi1n http://blog.numino.net/
MDate smalldatetime 4 1
OlQNGT http://blog.numino.net/
LDate smalldatetime 4 1
N2W72A http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
ry82q5 http://blog.numino.net/
DbVersion tinyint 1 1
DbMchI http://blog.numino.net/
Quest varbinary 50 1
MthM9J http://blog.numino.net/
LINZB bit 1 0
t3B1t2 http://blog.numino.net/
XDTIME datetime 8 0
07CYhe http://blog.numino.net/
STOPINFO nvarchar 100 1
L741rC http://blog.numino.net/
STOPTIME datetime 8 0
CZ05MQ http://blog.numino.net/
zs_count int 4 1
cLe5P4 http://blog.numino.net/
zs_point int 4 1
9aR4fZ http://blog.numino.net/
bs_count int 4 1
BZl3Z8 http://blog.numino.net/
bs_point int 4 1
BBu6PX http://blog.numino.net/
shiji smalldatetime 4 1
5Oc4lP http://blog.numino.net/
banl nvarchar 10 1
x7FzQk http://blog.numino.net/
lv_time datetime 8 1
kUpj0B http://blog.numino.net/
ex_ok int 4 1
k5VHDs http://blog.numino.net/
ex_total int 4 1
ujWMH3 http://blog.numino.net/
rb_count int 4 1
WPlt7a http://blog.numino.net/
rb_time datetime 8 1
r5X94n http://blog.numino.net/
pz_time datetime 8 1
sGHQ4T http://blog.numino.net/
3、MEMB_INFO
YcdH70 http://blog.numino.net/
列名 类型 长 是否空 说明
FwuPWJ http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
v801cB http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
HR1mNV http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
oy0ZWY http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
6pVg2U http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
5M49CQ http://blog.numino.net/
post_code nvarchar 6 1 --------1234
N7U2Gn http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
RVCN50 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
9g63q2 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
DQ65DB http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
TTf8ku http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
2Vq6Pq http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
L9lF5N http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
74ECmI http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
M8yWfF http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
aWi4QZ http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
e7PzeC http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
yU4dTR http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
Da192C http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
IKiQd2 http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
1S1asN http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
zYn3P0 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
0q57jV http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
zvzj10 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
JzAOtT http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
N0Fw2d http://blog.numino.net/
QX char 1 1 --------B
99YlH8 http://blog.numino.net/
JF int 4 0 --------0
514N4h http://blog.numino.net/
huiy int 4 1 --------0
1Rm100 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
KPj1qB http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
eNGmFz http://blog.numino.net/
FDB int 4 1 --------0
uZ8oQS http://blog.numino.net/
vip tinyint 1 1 --------0
LcrGIH http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
gIsOTf http://blog.numino.net/
4、MEMB_STAT
7Q9MpT http://blog.numino.net/
列名 类型 长 是否空 说明
3nVtPN http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
h10788 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
j2r525 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
2WGpj6 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
Jak2fY http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
o6V65m http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
n6XwUf http://blog.numino.net/
5、warehouse
su23z9 http://blog.numino.net/
列名 类型 长 是否空 说明
8jkP6U http://blog.numino.net/
AccountID varchar 10 0 --------帐号
fVuZAb http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
MTc1Z4 http://blog.numino.net/
Money int 4 1 --------钱
f6t9hI http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
UTH28Q http://blog.numino.net/
DbVersion tinyint 1 1 --------1
GOjasD http://blog.numino.net/
pw smallint 2 1 --------密码 0
ajFSuQ http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
sGwWsH http://blog.numino.net/
ExtCKNum int 4 0 --------0
kTbTL1 http://blog.numino.net/
NeedExtCK int 4 0 --------0
p0StT3 http://blog.numino.net/
6、VI_CURR_INFO
lh84De http://blog.numino.net/
列名 类型 长 是否空 说明
aplOFI http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
KS9eXc http://blog.numino.net/
chek_code nvarchar 1 0 --------1
2sYaUq http://blog.numino.net/
used_time int 4 1 --------1234
W9Q195 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
90GrmH http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
NsC4Of http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
nZ1SbU http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
0oUaiH http://blog.numino.net/
Bill_Section int 4 1 --------6
pOq73l http://blog.numino.net/
Bill_Value int 4 1 --------3
d0e5Sf http://blog.numino.net/
Bill_Hour int 4 1 --------0
1409xP http://blog.numino.net/
Surplus_Point int 4 1 --------0
x3sw3r http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
2lpj8L http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
9tebh2 http://blog.numino.net/
7、WEB_ZS
cg4MJp http://blog.numino.net/
列名 类型 长 是否空 说明
zAjZIM http://blog.numino.net/
ID bigint 8 0
f11Khy http://blog.numino.net/
ACC char 10 1
TwYR5T http://blog.numino.net/
NAME char 10 1
x8AKzy http://blog.numino.net/
ZSTIME datetime 8 1
fc1B6l http://blog.numino.net/
ZSCLEVEL smallint 2 1
7I0xKZ http://blog.numino.net/
ZSCS smallint 2 0
iWT9xx http://blog.numino.net/
CZCS smallint 2 0
nj50ZP http://blog.numino.net/
CZTIME datetime 8 0
1bGuUA http://blog.numino.net/
ZJZSCS smallint 2 0
0xSpV0 http://blog.numino.net/
GJZSCS smallint 2 0
VSyzdS http://blog.numino.net/
CJZSCS smallint 2 0
KGlRy9 http://blog.numino.net/
BSCS smallint 2 0
u6Zq92 http://blog.numino.net/
BSTIME datetime 8 0
8nKutY http://blog.numino.net/
LEVELUPPOINT int 4 0
AP9sRS http://blog.numino.net/
GDDS int 4 0
|
|