| 奇迹muonline数据库基础库分析 |
一、表的组成：
G8Bz80 http://blog.numino.net/
1、AccountCharacter
A4Rm6u http://blog.numino.net/
用来存放帐号的角色。
2z1TF7 http://blog.numino.net/
2、Character
q7S4cR http://blog.numino.net/
用来存放每个角色的详细数据。
yiacp9 http://blog.numino.net/
3、MEMB_INFO
Zp3dIt http://blog.numino.net/
帐号信息
6ToU49 http://blog.numino.net/
4、MEMB_STAT
eZ6raW http://blog.numino.net/
帐号状态
R5xIJ5 http://blog.numino.net/
5、warehouse
wh4oYG http://blog.numino.net/
仓库
5EEeyk http://blog.numino.net/
6、VI_CURR_INFO
xw86o7 http://blog.numino.net/
帐号费用
gwlDn9 http://blog.numino.net/
7、WEB_ZS
igp0v5 http://blog.numino.net/
PL 网站的转生数据
DLQxLi http://blog.numino.net/
二、各表说明
nxTey9 http://blog.numino.net/
1、AccountCharacter 表
8b0d5k http://blog.numino.net/
列名 类型 长 是否空 说明
go9cI5 http://blog.numino.net/
Number int 4 0 自动增加的序数
9mWT3I http://blog.numino.net/
Id varchar 10 0 帐号
3Jl6RV http://blog.numino.net/
GameID1 varchar 10 1 角色1
NQLFFN http://blog.numino.net/
GameID2 varchar 10 1 角色2
06D6rX http://blog.numino.net/
GameID3 varchar 10 1
6bQULC http://blog.numino.net/
GameID4 varchar 10 1
PjCOL0 http://blog.numino.net/
GameID5 varchar 10 1
0xL0to http://blog.numino.net/
GameIDC varchar 10 1
f6NOVk http://blog.numino.net/
2、Character 表
Y543ds http://blog.numino.net/
列名 类型 长 是否空 说明
D3CT4b http://blog.numino.net/
AccountID varchar 10 0 --------帐号
52K93y http://blog.numino.net/
Name nvarchar 10 0 --------角色名
1rhh7o http://blog.numino.net/
cLevel smallint 2 1 --------等级
EDuw6J http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
80pC0D http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
91RA8v http://blog.numino.net/
Experience int 4 1 --------经验
yW0VHq http://blog.numino.net/
Strength smallint 2 1 --------力量
5VSHbr http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
4KfWLA http://blog.numino.net/
Vitality smallint 2 1 --------体力
00dmF3 http://blog.numino.net/
Energy smallint 2 1 --------智力
aO7mgm http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
66Gbx4 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
7YwE1D http://blog.numino.net/
Money int 4 1 --------钱
6xXe11 http://blog.numino.net/
Life real 4 1 --------
h1UaVa http://blog.numino.net/
MaxLife real 4 1 --------
gEF9JT http://blog.numino.net/
Mana real 4 1 --------
T90Awo http://blog.numino.net/
MaxMana real 4 1 --------
74ial3 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
HxUrVn http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
GPBy1A http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
Bn37ib http://blog.numino.net/
MapDir tinyint 1 1 --------
45k2XV http://blog.numino.net/
PkCount int 4 1 --------
URP3qo http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
9VAIsF http://blog.numino.net/
PkTime int 4 1
Nq434S http://blog.numino.net/
MDate smalldatetime 4 1
uBx8O9 http://blog.numino.net/
LDate smalldatetime 4 1
Q0Px6C http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
5jxSbJ http://blog.numino.net/
DbVersion tinyint 1 1
zf0Oip http://blog.numino.net/
Quest varbinary 50 1
323H1Y http://blog.numino.net/
LINZB bit 1 0
sZxtI1 http://blog.numino.net/
XDTIME datetime 8 0
YGeDxq http://blog.numino.net/
STOPINFO nvarchar 100 1
WyB0OR http://blog.numino.net/
STOPTIME datetime 8 0
rZUrDf http://blog.numino.net/
zs_count int 4 1
X5o3UJ http://blog.numino.net/
zs_point int 4 1
pNNb4J http://blog.numino.net/
bs_count int 4 1
YG1pU7 http://blog.numino.net/
bs_point int 4 1
0s7Egl http://blog.numino.net/
shiji smalldatetime 4 1
z9u903 http://blog.numino.net/
banl nvarchar 10 1
j9p3mn http://blog.numino.net/
lv_time datetime 8 1
b9Dq9O http://blog.numino.net/
ex_ok int 4 1
y26zJl http://blog.numino.net/
ex_total int 4 1
KY6r4k http://blog.numino.net/
rb_count int 4 1
2aRvGE http://blog.numino.net/
rb_time datetime 8 1
Xh33Kp http://blog.numino.net/
pz_time datetime 8 1
m0mLbp http://blog.numino.net/
3、MEMB_INFO
to5080 http://blog.numino.net/
列名 类型 长 是否空 说明
guS0YI http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
z445Hc http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
TyGBw0 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
K32Gou http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
T6z8lB http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
PKTf9P http://blog.numino.net/
post_code nvarchar 6 1 --------1234
M4Wb99 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
LH1030 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
qXRros http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
NfMpGS http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
q7p10E http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
7b2PDB http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
5vbeLG http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
bhYyyW http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
pv88G2 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
Z1GCW0 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
hCvAmb http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
6gPo9X http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
M8eA0i http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
v0ciog http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
lsq3XU http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
J5Klh7 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
kEp2lf http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
5aG6Zw http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
h6KC0T http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
ptWsYx http://blog.numino.net/
QX char 1 1 --------B
1qZtN4 http://blog.numino.net/
JF int 4 0 --------0
i39IEf http://blog.numino.net/
huiy int 4 1 --------0
0eexuG http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
2fx73w http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
sYPF9f http://blog.numino.net/
FDB int 4 1 --------0
qHOXaq http://blog.numino.net/
vip tinyint 1 1 --------0
5OH79R http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
Nnimq6 http://blog.numino.net/
4、MEMB_STAT
Xz4Izu http://blog.numino.net/
列名 类型 长 是否空 说明
vXwCqN http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
nnq3LG http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
bQCwln http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
vQh691 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
0BKr0F http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
E5og4D http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
6MaiiL http://blog.numino.net/
5、warehouse
1bHM5W http://blog.numino.net/
列名 类型 长 是否空 说明
0zT4gZ http://blog.numino.net/
AccountID varchar 10 0 --------帐号
okd1pK http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
3rPVXc http://blog.numino.net/
Money int 4 1 --------钱
RDmIz1 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
A8qYsV http://blog.numino.net/
DbVersion tinyint 1 1 --------1
4Uo5Y1 http://blog.numino.net/
pw smallint 2 1 --------密码 0
2u5tgM http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
hhF0Cs http://blog.numino.net/
ExtCKNum int 4 0 --------0
7lbN5a http://blog.numino.net/
NeedExtCK int 4 0 --------0
WbZt7y http://blog.numino.net/
6、VI_CURR_INFO
pUOI7f http://blog.numino.net/
列名 类型 长 是否空 说明
L0RnTl http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
2BxGUy http://blog.numino.net/
chek_code nvarchar 1 0 --------1
7Qi5cb http://blog.numino.net/
used_time int 4 1 --------1234
gPwut1 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
fES0gh http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
L0B0z9 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
8NfjY2 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
S02xcx http://blog.numino.net/
Bill_Section int 4 1 --------6
pxaX89 http://blog.numino.net/
Bill_Value int 4 1 --------3
2xloI0 http://blog.numino.net/
Bill_Hour int 4 1 --------0
be2dc7 http://blog.numino.net/
Surplus_Point int 4 1 --------0
PNk3rm http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
kAWmah http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
KYoCrg http://blog.numino.net/
7、WEB_ZS
coR0qA http://blog.numino.net/
列名 类型 长 是否空 说明
r1p7lf http://blog.numino.net/
ID bigint 8 0
sGZU5Q http://blog.numino.net/
ACC char 10 1
B270FW http://blog.numino.net/
NAME char 10 1
YKHUym http://blog.numino.net/
ZSTIME datetime 8 1
QCSJyR http://blog.numino.net/
ZSCLEVEL smallint 2 1
rP2cnh http://blog.numino.net/
ZSCS smallint 2 0
8rB1D3 http://blog.numino.net/
CZCS smallint 2 0
zj6roj http://blog.numino.net/
CZTIME datetime 8 0
X0c0N8 http://blog.numino.net/
ZJZSCS smallint 2 0
7SqOf0 http://blog.numino.net/
GJZSCS smallint 2 0
YIYfa3 http://blog.numino.net/
CJZSCS smallint 2 0
2du07A http://blog.numino.net/
BSCS smallint 2 0
lIK45a http://blog.numino.net/
BSTIME datetime 8 0
S5Cc08 http://blog.numino.net/
LEVELUPPOINT int 4 0
YEA14y http://blog.numino.net/
GDDS int 4 0
|
|