| 奇迹muonline数据库基础库分析 |
一、表的组成：
MZLyKA http://blog.numino.net/
1、AccountCharacter
3SZ6tI http://blog.numino.net/
用来存放帐号的角色。
fCSG38 http://blog.numino.net/
2、Character
AhTO1a http://blog.numino.net/
用来存放每个角色的详细数据。
K5tOY4 http://blog.numino.net/
3、MEMB_INFO
fyiWRI http://blog.numino.net/
帐号信息
7FbDE6 http://blog.numino.net/
4、MEMB_STAT
1buY4i http://blog.numino.net/
帐号状态
yKGSDF http://blog.numino.net/
5、warehouse
4pz7LC http://blog.numino.net/
仓库
g2r9YH http://blog.numino.net/
6、VI_CURR_INFO
3NTo6j http://blog.numino.net/
帐号费用
s9nMd5 http://blog.numino.net/
7、WEB_ZS
VZEq7Z http://blog.numino.net/
PL 网站的转生数据
686T09 http://blog.numino.net/
二、各表说明
HH6RwP http://blog.numino.net/
1、AccountCharacter 表
6Ba8rQ http://blog.numino.net/
列名 类型 长 是否空 说明
GBsrXz http://blog.numino.net/
Number int 4 0 自动增加的序数
o858rC http://blog.numino.net/
Id varchar 10 0 帐号
h7wH6l http://blog.numino.net/
GameID1 varchar 10 1 角色1
gx6XHg http://blog.numino.net/
GameID2 varchar 10 1 角色2
0ZcVI2 http://blog.numino.net/
GameID3 varchar 10 1
5FutYC http://blog.numino.net/
GameID4 varchar 10 1
a8Ljq9 http://blog.numino.net/
GameID5 varchar 10 1
sav5R1 http://blog.numino.net/
GameIDC varchar 10 1
w91z7q http://blog.numino.net/
2、Character 表
WGqxdS http://blog.numino.net/
列名 类型 长 是否空 说明
pE7V8Y http://blog.numino.net/
AccountID varchar 10 0 --------帐号
lopC4W http://blog.numino.net/
Name nvarchar 10 0 --------角色名
IO7uh3 http://blog.numino.net/
cLevel smallint 2 1 --------等级
z5VN2d http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
90Ffwf http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
4H15GH http://blog.numino.net/
Experience int 4 1 --------经验
C3LnQu http://blog.numino.net/
Strength smallint 2 1 --------力量
P3M90l http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
tcqvLl http://blog.numino.net/
Vitality smallint 2 1 --------体力
OqZN62 http://blog.numino.net/
Energy smallint 2 1 --------智力
tem4Vv http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
Xm4UPA http://blog.numino.net/
MagicList varbinary 60 1 --------技能
OfuMNl http://blog.numino.net/
Money int 4 1 --------钱
R55wcS http://blog.numino.net/
Life real 4 1 --------
88ga6z http://blog.numino.net/
MaxLife real 4 1 --------
u33alv http://blog.numino.net/
Mana real 4 1 --------
1Fn42p http://blog.numino.net/
MaxMana real 4 1 --------
vvoHqa http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
4C8APr http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
sVL5dd http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
3V2995 http://blog.numino.net/
MapDir tinyint 1 1 --------
01TdCw http://blog.numino.net/
PkCount int 4 1 --------
OeicYV http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
tfb7Pa http://blog.numino.net/
PkTime int 4 1
566s3n http://blog.numino.net/
MDate smalldatetime 4 1
QIGu75 http://blog.numino.net/
LDate smalldatetime 4 1
U99FMo http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
89P70g http://blog.numino.net/
DbVersion tinyint 1 1
lGgFbU http://blog.numino.net/
Quest varbinary 50 1
hdS4Tk http://blog.numino.net/
LINZB bit 1 0
K75uXi http://blog.numino.net/
XDTIME datetime 8 0
1ZEk84 http://blog.numino.net/
STOPINFO nvarchar 100 1
45628n http://blog.numino.net/
STOPTIME datetime 8 0
0Gv4JD http://blog.numino.net/
zs_count int 4 1
MnQLYj http://blog.numino.net/
zs_point int 4 1
XpU84Z http://blog.numino.net/
bs_count int 4 1
R7Mweb http://blog.numino.net/
bs_point int 4 1
qgOeyF http://blog.numino.net/
shiji smalldatetime 4 1
T5IeQu http://blog.numino.net/
banl nvarchar 10 1
PksT5B http://blog.numino.net/
lv_time datetime 8 1
iIF485 http://blog.numino.net/
ex_ok int 4 1
yRv0v7 http://blog.numino.net/
ex_total int 4 1
Z8UkVr http://blog.numino.net/
rb_count int 4 1
2lijvp http://blog.numino.net/
rb_time datetime 8 1
GCRIi7 http://blog.numino.net/
pz_time datetime 8 1
Put26k http://blog.numino.net/
3、MEMB_INFO
BDCzkq http://blog.numino.net/
列名 类型 长 是否空 说明
A6xHJV http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
78YPPC http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
e6gcZi http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
7dckJW http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
TefdhO http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
43jZJv http://blog.numino.net/
post_code nvarchar 6 1 --------1234
99QNDp http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
79E6BR http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
17GG4P http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
23ZETY http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
lxONEz http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
AQHxmp http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
p4G2B6 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
Dg59Fy http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
MbUaOF http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
L61TVD http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
S8CNXQ http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
a8O3D4 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
Vjqt04 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
9z4BxP http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
5B10FD http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
6J6QQT http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
YETvT4 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
254L8b http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
UuC3zf http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
qaXxmU http://blog.numino.net/
QX char 1 1 --------B
yBFsHl http://blog.numino.net/
JF int 4 0 --------0
pv9cjI http://blog.numino.net/
huiy int 4 1 --------0
gjT9M5 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
Qlls90 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
cWakP5 http://blog.numino.net/
FDB int 4 1 --------0
upBUpw http://blog.numino.net/
vip tinyint 1 1 --------0
ZDG8Zp http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
rGa8PJ http://blog.numino.net/
4、MEMB_STAT
I4JUb5 http://blog.numino.net/
列名 类型 长 是否空 说明
8VPr4b http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
zEb7Ti http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
pzI7of http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
WLw8ki http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
Zv1Mgi http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
3D2333 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
9Vwg7R http://blog.numino.net/
5、warehouse
p6kdm5 http://blog.numino.net/
列名 类型 长 是否空 说明
qs5SNF http://blog.numino.net/
AccountID varchar 10 0 --------帐号
CakvQg http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
V36Rl1 http://blog.numino.net/
Money int 4 1 --------钱
03pQL6 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
PwB6Hg http://blog.numino.net/
DbVersion tinyint 1 1 --------1
7o7kUe http://blog.numino.net/
pw smallint 2 1 --------密码 0
atN8Gl http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
HUIG7L http://blog.numino.net/
ExtCKNum int 4 0 --------0
eAi61n http://blog.numino.net/
NeedExtCK int 4 0 --------0
ywf48Y http://blog.numino.net/
6、VI_CURR_INFO
oL8L46 http://blog.numino.net/
列名 类型 长 是否空 说明
VW2CHj http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
iU48sW http://blog.numino.net/
chek_code nvarchar 1 0 --------1
389AlE http://blog.numino.net/
used_time int 4 1 --------1234
fWc3W6 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
1gmpX5 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
fx7F51 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
r0Eqkk http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
muiu4n http://blog.numino.net/
Bill_Section int 4 1 --------6
erx7A9 http://blog.numino.net/
Bill_Value int 4 1 --------3
GrasZZ http://blog.numino.net/
Bill_Hour int 4 1 --------0
e0OG14 http://blog.numino.net/
Surplus_Point int 4 1 --------0
YckEtm http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
Bz7n17 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
kpTu4X http://blog.numino.net/
7、WEB_ZS
D4zBZ3 http://blog.numino.net/
列名 类型 长 是否空 说明
PvQ32l http://blog.numino.net/
ID bigint 8 0
S3MXrX http://blog.numino.net/
ACC char 10 1
xRDnMv http://blog.numino.net/
NAME char 10 1
nDObsv http://blog.numino.net/
ZSTIME datetime 8 1
b6C4LK http://blog.numino.net/
ZSCLEVEL smallint 2 1
ofS1jg http://blog.numino.net/
ZSCS smallint 2 0
XBMA3R http://blog.numino.net/
CZCS smallint 2 0
11YUJg http://blog.numino.net/
CZTIME datetime 8 0
Zfr6Cm http://blog.numino.net/
ZJZSCS smallint 2 0
GYiZfd http://blog.numino.net/
GJZSCS smallint 2 0
kptC9L http://blog.numino.net/
CJZSCS smallint 2 0
A6ck01 http://blog.numino.net/
BSCS smallint 2 0
7DUi21 http://blog.numino.net/
BSTIME datetime 8 0
BCu34E http://blog.numino.net/
LEVELUPPOINT int 4 0
ZXxnPp http://blog.numino.net/
GDDS int 4 0
|
|