| 奇迹muonline数据库基础库分析 |
一、表的组成：
bgrqpX http://blog.numino.net/
1、AccountCharacter
KA3HZh http://blog.numino.net/
用来存放帐号的角色。
69drni http://blog.numino.net/
2、Character
Z5mF1q http://blog.numino.net/
用来存放每个角色的详细数据。
icp307 http://blog.numino.net/
3、MEMB_INFO
T4Z6zu http://blog.numino.net/
帐号信息
SIoU5R http://blog.numino.net/
4、MEMB_STAT
OsRgkP http://blog.numino.net/
帐号状态
ne75t6 http://blog.numino.net/
5、warehouse
N48d6Y http://blog.numino.net/
仓库
46Sz5f http://blog.numino.net/
6、VI_CURR_INFO
6PqQ40 http://blog.numino.net/
帐号费用
nUa4GA http://blog.numino.net/
7、WEB_ZS
xGR2Wp http://blog.numino.net/
PL 网站的转生数据
vTqvpc http://blog.numino.net/
二、各表说明
RV7TFx http://blog.numino.net/
1、AccountCharacter 表
DRUrTi http://blog.numino.net/
列名 类型 长 是否空 说明
cfd5x7 http://blog.numino.net/
Number int 4 0 自动增加的序数
LoyssT http://blog.numino.net/
Id varchar 10 0 帐号
qXGdkL http://blog.numino.net/
GameID1 varchar 10 1 角色1
l8mkdk http://blog.numino.net/
GameID2 varchar 10 1 角色2
WOfARJ http://blog.numino.net/
GameID3 varchar 10 1
pnS4ZO http://blog.numino.net/
GameID4 varchar 10 1
aUq8Kc http://blog.numino.net/
GameID5 varchar 10 1
8Xf71r http://blog.numino.net/
GameIDC varchar 10 1
UVI9lh http://blog.numino.net/
2、Character 表
pjnrjN http://blog.numino.net/
列名 类型 长 是否空 说明
2WHTT0 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
w70eU4 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
dl1QBT http://blog.numino.net/
cLevel smallint 2 1 --------等级
HSyXg4 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
50Y30l http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
VV90j6 http://blog.numino.net/
Experience int 4 1 --------经验
6U1kBU http://blog.numino.net/
Strength smallint 2 1 --------力量
TzaSgK http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
MAjLG4 http://blog.numino.net/
Vitality smallint 2 1 --------体力
3Q9LM1 http://blog.numino.net/
Energy smallint 2 1 --------智力
Pu582X http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
s8rB6O http://blog.numino.net/
MagicList varbinary 60 1 --------技能
1q2dXP http://blog.numino.net/
Money int 4 1 --------钱
5ECUrF http://blog.numino.net/
Life real 4 1 --------
tgXXXE http://blog.numino.net/
MaxLife real 4 1 --------
3BH8da http://blog.numino.net/
Mana real 4 1 --------
WTg3yp http://blog.numino.net/
MaxMana real 4 1 --------
4sz3o7 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
4b4rKf http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
FGdaXL http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
u97958 http://blog.numino.net/
MapDir tinyint 1 1 --------
O8DKbl http://blog.numino.net/
PkCount int 4 1 --------
A98nh4 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
ernkR1 http://blog.numino.net/
PkTime int 4 1
JDMleY http://blog.numino.net/
MDate smalldatetime 4 1
NJfPsp http://blog.numino.net/
LDate smalldatetime 4 1
p6k9o9 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
HLb0j2 http://blog.numino.net/
DbVersion tinyint 1 1
LP7Kj0 http://blog.numino.net/
Quest varbinary 50 1
Vkgp11 http://blog.numino.net/
LINZB bit 1 0
uWgW73 http://blog.numino.net/
XDTIME datetime 8 0
Ieorqk http://blog.numino.net/
STOPINFO nvarchar 100 1
nenkWc http://blog.numino.net/
STOPTIME datetime 8 0
WvEGS0 http://blog.numino.net/
zs_count int 4 1
6O2rlJ http://blog.numino.net/
zs_point int 4 1
xZ8bM8 http://blog.numino.net/
bs_count int 4 1
F6cHN3 http://blog.numino.net/
bs_point int 4 1
yW4MTN http://blog.numino.net/
shiji smalldatetime 4 1
SybhnR http://blog.numino.net/
banl nvarchar 10 1
t39inA http://blog.numino.net/
lv_time datetime 8 1
9hvn8t http://blog.numino.net/
ex_ok int 4 1
uvTvl7 http://blog.numino.net/
ex_total int 4 1
f5R99c http://blog.numino.net/
rb_count int 4 1
MMm6Nz http://blog.numino.net/
rb_time datetime 8 1
L8eD4B http://blog.numino.net/
pz_time datetime 8 1
5J8oZG http://blog.numino.net/
3、MEMB_INFO
GJz8z3 http://blog.numino.net/
列名 类型 长 是否空 说明
GSlhhC http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
zNxqNP http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Xor2jh http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
49Q6kf http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
L5kfi2 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
iSJptp http://blog.numino.net/
post_code nvarchar 6 1 --------1234
1fTw2P http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
w7Yn3A http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
8lEdf6 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
GT9f3D http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
k46j9V http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
HQ36p9 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
m93L92 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
wxDzwQ http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
07XGvt http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
0yfnN0 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
c6vBj5 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Yew2DA http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
JE4CD6 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
hnUDvX http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
39ty8y http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
nD26Rd http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
w8HPy9 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
sHk4FY http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
tCNOqF http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
Xf5CPP http://blog.numino.net/
QX char 1 1 --------B
qeX7Iu http://blog.numino.net/
JF int 4 0 --------0
SLTbJE http://blog.numino.net/
huiy int 4 1 --------0
ULfgy8 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
9BG0i9 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
U6J7WA http://blog.numino.net/
FDB int 4 1 --------0
r3MIHi http://blog.numino.net/
vip tinyint 1 1 --------0
TvX5Fo http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
ip0T1A http://blog.numino.net/
4、MEMB_STAT
a1UbNs http://blog.numino.net/
列名 类型 长 是否空 说明
a96vAX http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
AyX9Xv http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
QL9xNh http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
iFehw3 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
4I9V7V http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
s7LIL9 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
L9Z0fg http://blog.numino.net/
5、warehouse
wT0ATZ http://blog.numino.net/
列名 类型 长 是否空 说明
hiyCSb http://blog.numino.net/
AccountID varchar 10 0 --------帐号
nQ8p2S http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
QlwaOY http://blog.numino.net/
Money int 4 1 --------钱
D7E4l9 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
i50Ubo http://blog.numino.net/
DbVersion tinyint 1 1 --------1
CbaJJU http://blog.numino.net/
pw smallint 2 1 --------密码 0
0x86rY http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
Egsp5s http://blog.numino.net/
ExtCKNum int 4 0 --------0
NAwY6N http://blog.numino.net/
NeedExtCK int 4 0 --------0
4XXffW http://blog.numino.net/
6、VI_CURR_INFO
JMzL4o http://blog.numino.net/
列名 类型 长 是否空 说明
6I2ogT http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
OMEOnd http://blog.numino.net/
chek_code nvarchar 1 0 --------1
5CXu4J http://blog.numino.net/
used_time int 4 1 --------1234
67To2N http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
489SIS http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
59UbcB http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
65ptbG http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
W2lQyd http://blog.numino.net/
Bill_Section int 4 1 --------6
3l3A8e http://blog.numino.net/
Bill_Value int 4 1 --------3
yL2LXw http://blog.numino.net/
Bill_Hour int 4 1 --------0
0xp71v http://blog.numino.net/
Surplus_Point int 4 1 --------0
6y959A http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
pQ5ldf http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
igj8iA http://blog.numino.net/
7、WEB_ZS
4IJ2nq http://blog.numino.net/
列名 类型 长 是否空 说明
pJwRpa http://blog.numino.net/
ID bigint 8 0
Cnyra9 http://blog.numino.net/
ACC char 10 1
f97D9J http://blog.numino.net/
NAME char 10 1
gD6lCU http://blog.numino.net/
ZSTIME datetime 8 1
B8kVSz http://blog.numino.net/
ZSCLEVEL smallint 2 1
C7F3R4 http://blog.numino.net/
ZSCS smallint 2 0
2b8JrG http://blog.numino.net/
CZCS smallint 2 0
DivV4y http://blog.numino.net/
CZTIME datetime 8 0
HY6u77 http://blog.numino.net/
ZJZSCS smallint 2 0
oZadv4 http://blog.numino.net/
GJZSCS smallint 2 0
Cu2iDm http://blog.numino.net/
CJZSCS smallint 2 0
957we9 http://blog.numino.net/
BSCS smallint 2 0
LRTMi7 http://blog.numino.net/
BSTIME datetime 8 0
ng91Aq http://blog.numino.net/
LEVELUPPOINT int 4 0
DfvEaw http://blog.numino.net/
GDDS int 4 0
|
|