| 奇迹muonline数据库基础库分析 |
一、表的组成：
1CYWk3 http://blog.numino.net/
1、AccountCharacter
c35559 http://blog.numino.net/
用来存放帐号的角色。
afdHdG http://blog.numino.net/
2、Character
RhLTry http://blog.numino.net/
用来存放每个角色的详细数据。
LGh4A7 http://blog.numino.net/
3、MEMB_INFO
8zMd9K http://blog.numino.net/
帐号信息
LNmju7 http://blog.numino.net/
4、MEMB_STAT
Nv0Lbe http://blog.numino.net/
帐号状态
d3rU0K http://blog.numino.net/
5、warehouse
xPol6f http://blog.numino.net/
仓库
W7iSGS http://blog.numino.net/
6、VI_CURR_INFO
KFLnH9 http://blog.numino.net/
帐号费用
aiUzX0 http://blog.numino.net/
7、WEB_ZS
ZwqEKP http://blog.numino.net/
PL 网站的转生数据
9wHk68 http://blog.numino.net/
二、各表说明
TAn554 http://blog.numino.net/
1、AccountCharacter 表
nFMfzN http://blog.numino.net/
列名 类型 长 是否空 说明
jcF52a http://blog.numino.net/
Number int 4 0 自动增加的序数
iF2i66 http://blog.numino.net/
Id varchar 10 0 帐号
nxkjOu http://blog.numino.net/
GameID1 varchar 10 1 角色1
FUrDht http://blog.numino.net/
GameID2 varchar 10 1 角色2
NNk6vJ http://blog.numino.net/
GameID3 varchar 10 1
y313bu http://blog.numino.net/
GameID4 varchar 10 1
b3qVbN http://blog.numino.net/
GameID5 varchar 10 1
FeqCQk http://blog.numino.net/
GameIDC varchar 10 1
wH91qM http://blog.numino.net/
2、Character 表
sk08ph http://blog.numino.net/
列名 类型 长 是否空 说明
OzvzlM http://blog.numino.net/
AccountID varchar 10 0 --------帐号
2m1BFi http://blog.numino.net/
Name nvarchar 10 0 --------角色名
2I3vO0 http://blog.numino.net/
cLevel smallint 2 1 --------等级
0b0pFG http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
JauvgN http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
YYGA4U http://blog.numino.net/
Experience int 4 1 --------经验
Qd99Hr http://blog.numino.net/
Strength smallint 2 1 --------力量
CeCLO6 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
02164X http://blog.numino.net/
Vitality smallint 2 1 --------体力
KiGXpT http://blog.numino.net/
Energy smallint 2 1 --------智力
Y33cQ5 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
U9x1CD http://blog.numino.net/
MagicList varbinary 60 1 --------技能
bGgA2C http://blog.numino.net/
Money int 4 1 --------钱
tIuDSt http://blog.numino.net/
Life real 4 1 --------
9By85N http://blog.numino.net/
MaxLife real 4 1 --------
C26EmK http://blog.numino.net/
Mana real 4 1 --------
xqKnvW http://blog.numino.net/
MaxMana real 4 1 --------
QNBFnt http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
3L6Syw http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
O8xTBP http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
xZduX6 http://blog.numino.net/
MapDir tinyint 1 1 --------
1c95rV http://blog.numino.net/
PkCount int 4 1 --------
rvO7Y6 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
15bhCA http://blog.numino.net/
PkTime int 4 1
xcPbeN http://blog.numino.net/
MDate smalldatetime 4 1
6noSUx http://blog.numino.net/
LDate smalldatetime 4 1
Y0Ik30 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
q5QMZE http://blog.numino.net/
DbVersion tinyint 1 1
U5Qins http://blog.numino.net/
Quest varbinary 50 1
F8nuSq http://blog.numino.net/
LINZB bit 1 0
4iv70Z http://blog.numino.net/
XDTIME datetime 8 0
T35MIS http://blog.numino.net/
STOPINFO nvarchar 100 1
xNGk0M http://blog.numino.net/
STOPTIME datetime 8 0
XZYA4a http://blog.numino.net/
zs_count int 4 1
ntB0MG http://blog.numino.net/
zs_point int 4 1
4ydv0e http://blog.numino.net/
bs_count int 4 1
Kq6u3s http://blog.numino.net/
bs_point int 4 1
d7kRd3 http://blog.numino.net/
shiji smalldatetime 4 1
fRyxcV http://blog.numino.net/
banl nvarchar 10 1
9TPPw1 http://blog.numino.net/
lv_time datetime 8 1
6z4phE http://blog.numino.net/
ex_ok int 4 1
HRDSo0 http://blog.numino.net/
ex_total int 4 1
gZThJj http://blog.numino.net/
rb_count int 4 1
H7N431 http://blog.numino.net/
rb_time datetime 8 1
N7H3gh http://blog.numino.net/
pz_time datetime 8 1
g4V52g http://blog.numino.net/
3、MEMB_INFO
aPfTQj http://blog.numino.net/
列名 类型 长 是否空 说明
w0KQc6 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
5jaTcr http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
cKE56t http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
9POBi7 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
T4Z450 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
F1JXpn http://blog.numino.net/
post_code nvarchar 6 1 --------1234
tA3BNZ http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
9RGn54 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
TLzqbV http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
8ktDIL http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
Y1PqUR http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
v8CXH3 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
B6R3g4 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
5CSd2B http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
Fy6R88 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
QacZly http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
770kv7 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
luc0lo http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
5cX7Mr http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
90iGeC http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
x8PEKa http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
IZ2bnM http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
N4J37k http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
qCJzVT http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
PwpgB4 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
0cQwX4 http://blog.numino.net/
QX char 1 1 --------B
u56lFc http://blog.numino.net/
JF int 4 0 --------0
Fp6VRU http://blog.numino.net/
huiy int 4 1 --------0
428FF6 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
Ia00cY http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
4KIsd9 http://blog.numino.net/
FDB int 4 1 --------0
mEJWiE http://blog.numino.net/
vip tinyint 1 1 --------0
hSRCO4 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
yEM0Bu http://blog.numino.net/
4、MEMB_STAT
D1XAt7 http://blog.numino.net/
列名 类型 长 是否空 说明
5dBA8h http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
AMdAsp http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
85AZbe http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
95IwDq http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
Qe8VhD http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
x3i23V http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
QkoFrm http://blog.numino.net/
5、warehouse
4EA9JB http://blog.numino.net/
列名 类型 长 是否空 说明
uGzYp0 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
jakh4C http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
Hs79uB http://blog.numino.net/
Money int 4 1 --------钱
mloaaR http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
Tk0dLU http://blog.numino.net/
DbVersion tinyint 1 1 --------1
vjXw3U http://blog.numino.net/
pw smallint 2 1 --------密码 0
rfAH4P http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
0CARh7 http://blog.numino.net/
ExtCKNum int 4 0 --------0
74lapJ http://blog.numino.net/
NeedExtCK int 4 0 --------0
X4lZbZ http://blog.numino.net/
6、VI_CURR_INFO
aUklHn http://blog.numino.net/
列名 类型 长 是否空 说明
tv8Cgm http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
695iby http://blog.numino.net/
chek_code nvarchar 1 0 --------1
4nU8bM http://blog.numino.net/
used_time int 4 1 --------1234
5BDXGe http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
vCmz0d http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
vd9NnS http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
7YJ1Fd http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
o2PuZG http://blog.numino.net/
Bill_Section int 4 1 --------6
euChap http://blog.numino.net/
Bill_Value int 4 1 --------3
V5NDH2 http://blog.numino.net/
Bill_Hour int 4 1 --------0
Jiw2PV http://blog.numino.net/
Surplus_Point int 4 1 --------0
F7tE6t http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
x110wx http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
iXB50v http://blog.numino.net/
7、WEB_ZS
18RP8t http://blog.numino.net/
列名 类型 长 是否空 说明
76qXwW http://blog.numino.net/
ID bigint 8 0
BhCUal http://blog.numino.net/
ACC char 10 1
o29jZT http://blog.numino.net/
NAME char 10 1
dNu5Dt http://blog.numino.net/
ZSTIME datetime 8 1
TkUTPJ http://blog.numino.net/
ZSCLEVEL smallint 2 1
buNQMP http://blog.numino.net/
ZSCS smallint 2 0
r6W9g8 http://blog.numino.net/
CZCS smallint 2 0
JAuNB7 http://blog.numino.net/
CZTIME datetime 8 0
1en0Ri http://blog.numino.net/
ZJZSCS smallint 2 0
tX8Pcx http://blog.numino.net/
GJZSCS smallint 2 0
67q5FW http://blog.numino.net/
CJZSCS smallint 2 0
H4Qs2f http://blog.numino.net/
BSCS smallint 2 0
7YTb2a http://blog.numino.net/
BSTIME datetime 8 0
nWE3C9 http://blog.numino.net/
LEVELUPPOINT int 4 0
jHQD7B http://blog.numino.net/
GDDS int 4 0
|
|