| 奇迹muonline数据库基础库分析 |
一、表的组成：
lA4LMP http://blog.numino.net/
1、AccountCharacter
blO1zQ http://blog.numino.net/
用来存放帐号的角色。
03A5Yv http://blog.numino.net/
2、Character
9K9sDv http://blog.numino.net/
用来存放每个角色的详细数据。
1CZSe4 http://blog.numino.net/
3、MEMB_INFO
gC203s http://blog.numino.net/
帐号信息
K0M6c2 http://blog.numino.net/
4、MEMB_STAT
z1Tnqu http://blog.numino.net/
帐号状态
TH8Zv1 http://blog.numino.net/
5、warehouse
vLDuIt http://blog.numino.net/
仓库
1H8LIB http://blog.numino.net/
6、VI_CURR_INFO
ZT8k3X http://blog.numino.net/
帐号费用
tgsc45 http://blog.numino.net/
7、WEB_ZS
mGxafO http://blog.numino.net/
PL 网站的转生数据
6NOvL0 http://blog.numino.net/
二、各表说明
QCi23G http://blog.numino.net/
1、AccountCharacter 表
q7oYoC http://blog.numino.net/
列名 类型 长 是否空 说明
6YRh61 http://blog.numino.net/
Number int 4 0 自动增加的序数
3Y4L59 http://blog.numino.net/
Id varchar 10 0 帐号
W58rBI http://blog.numino.net/
GameID1 varchar 10 1 角色1
2z3lvk http://blog.numino.net/
GameID2 varchar 10 1 角色2
b7O4Bd http://blog.numino.net/
GameID3 varchar 10 1
YgPl2i http://blog.numino.net/
GameID4 varchar 10 1
dszbdL http://blog.numino.net/
GameID5 varchar 10 1
K1FLn5 http://blog.numino.net/
GameIDC varchar 10 1
R0aZXn http://blog.numino.net/
2、Character 表
wGfAbw http://blog.numino.net/
列名 类型 长 是否空 说明
X716qK http://blog.numino.net/
AccountID varchar 10 0 --------帐号
oJ8OmB http://blog.numino.net/
Name nvarchar 10 0 --------角色名
yoSi73 http://blog.numino.net/
cLevel smallint 2 1 --------等级
i164Xd http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
TcDgSe http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
2BK78Q http://blog.numino.net/
Experience int 4 1 --------经验
69tca3 http://blog.numino.net/
Strength smallint 2 1 --------力量
Abi4lK http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
GkrEvY http://blog.numino.net/
Vitality smallint 2 1 --------体力
zq4zmF http://blog.numino.net/
Energy smallint 2 1 --------智力
s7g5W3 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
ERTn0J http://blog.numino.net/
MagicList varbinary 60 1 --------技能
G2nggv http://blog.numino.net/
Money int 4 1 --------钱
M77A3i http://blog.numino.net/
Life real 4 1 --------
kWxxAW http://blog.numino.net/
MaxLife real 4 1 --------
DK9Q67 http://blog.numino.net/
Mana real 4 1 --------
8WxF08 http://blog.numino.net/
MaxMana real 4 1 --------
dc77iT http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
f7YADb http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
668mM3 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
lonhC5 http://blog.numino.net/
MapDir tinyint 1 1 --------
q1PD6j http://blog.numino.net/
PkCount int 4 1 --------
wDaBX3 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
5RU0fv http://blog.numino.net/
PkTime int 4 1
sk7rVu http://blog.numino.net/
MDate smalldatetime 4 1
265Zea http://blog.numino.net/
LDate smalldatetime 4 1
T5Ot1j http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
UE8mI7 http://blog.numino.net/
DbVersion tinyint 1 1
Q4wpV0 http://blog.numino.net/
Quest varbinary 50 1
J5Y5O0 http://blog.numino.net/
LINZB bit 1 0
tK63H0 http://blog.numino.net/
XDTIME datetime 8 0
uu27X9 http://blog.numino.net/
STOPINFO nvarchar 100 1
yQKqmV http://blog.numino.net/
STOPTIME datetime 8 0
YITp66 http://blog.numino.net/
zs_count int 4 1
zkuJvj http://blog.numino.net/
zs_point int 4 1
6sC7LH http://blog.numino.net/
bs_count int 4 1
zyoEjB http://blog.numino.net/
bs_point int 4 1
vXLW0z http://blog.numino.net/
shiji smalldatetime 4 1
40833k http://blog.numino.net/
banl nvarchar 10 1
3dyaze http://blog.numino.net/
lv_time datetime 8 1
idpGJt http://blog.numino.net/
ex_ok int 4 1
9u6BR6 http://blog.numino.net/
ex_total int 4 1
oZBAT7 http://blog.numino.net/
rb_count int 4 1
Xu47ek http://blog.numino.net/
rb_time datetime 8 1
H3VORp http://blog.numino.net/
pz_time datetime 8 1
IvtwNk http://blog.numino.net/
3、MEMB_INFO
209n64 http://blog.numino.net/
列名 类型 长 是否空 说明
ZSU3gE http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
9pwo5Y http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Z0MhhY http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
6mAzQM http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
770601 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
2k6D4t http://blog.numino.net/
post_code nvarchar 6 1 --------1234
3H7ZCv http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
o5U168 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
A0RTkf http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
MIu1r5 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
OGuCD4 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
Cw3O0o http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
B1hhoa http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
68PUi8 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
sX0TEZ http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
5ksPU8 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
VBrWZ0 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
XbfUeX http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
slv3i6 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
HgNzmM http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
onOhn9 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
5kD03j http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
cwOyQJ http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
mdgc25 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
EfXZPw http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
4zdTZv http://blog.numino.net/
QX char 1 1 --------B
605UDa http://blog.numino.net/
JF int 4 0 --------0
k7c3GE http://blog.numino.net/
huiy int 4 1 --------0
3a16Ch http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
HazQjx http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
0f2L4u http://blog.numino.net/
FDB int 4 1 --------0
Dc8yI2 http://blog.numino.net/
vip tinyint 1 1 --------0
TGbRLX http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
Pc0dVR http://blog.numino.net/
4、MEMB_STAT
Zj71Rw http://blog.numino.net/
列名 类型 长 是否空 说明
IE7HQ5 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
AuB5Iy http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
8469O6 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
EmWIR1 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
nLAdaD http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
VklE0x http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
hoee1O http://blog.numino.net/
5、warehouse
Iwr0ts http://blog.numino.net/
列名 类型 长 是否空 说明
3eDU2J http://blog.numino.net/
AccountID varchar 10 0 --------帐号
j5ojIR http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
xvz8i7 http://blog.numino.net/
Money int 4 1 --------钱
pgrH9b http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
mAT3C3 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
wwBe3o http://blog.numino.net/
pw smallint 2 1 --------密码 0
pCFT7h http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
e72pLZ http://blog.numino.net/
ExtCKNum int 4 0 --------0
tE78Zv http://blog.numino.net/
NeedExtCK int 4 0 --------0
TOayRv http://blog.numino.net/
6、VI_CURR_INFO
3xaRm5 http://blog.numino.net/
列名 类型 长 是否空 说明
Les4Hx http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
qqQNZW http://blog.numino.net/
chek_code nvarchar 1 0 --------1
lo9LhO http://blog.numino.net/
used_time int 4 1 --------1234
T4rZ0G http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
oIyoci http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
Vdf4uS http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
6Qnxxm http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
TqYC83 http://blog.numino.net/
Bill_Section int 4 1 --------6
vDvjRv http://blog.numino.net/
Bill_Value int 4 1 --------3
NYg6P9 http://blog.numino.net/
Bill_Hour int 4 1 --------0
fhY5ym http://blog.numino.net/
Surplus_Point int 4 1 --------0
wwdrA2 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
h36PHU http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
xbT7FI http://blog.numino.net/
7、WEB_ZS
A5cWG9 http://blog.numino.net/
列名 类型 长 是否空 说明
t9FA14 http://blog.numino.net/
ID bigint 8 0
K1m2P0 http://blog.numino.net/
ACC char 10 1
qYp4hO http://blog.numino.net/
NAME char 10 1
mKFBs4 http://blog.numino.net/
ZSTIME datetime 8 1
K4a1f8 http://blog.numino.net/
ZSCLEVEL smallint 2 1
4zkwPh http://blog.numino.net/
ZSCS smallint 2 0
wYBSj9 http://blog.numino.net/
CZCS smallint 2 0
DCi0qX http://blog.numino.net/
CZTIME datetime 8 0
31c2sG http://blog.numino.net/
ZJZSCS smallint 2 0
e3SmFd http://blog.numino.net/
GJZSCS smallint 2 0
7057EI http://blog.numino.net/
CJZSCS smallint 2 0
1765Pg http://blog.numino.net/
BSCS smallint 2 0
cxf9qp http://blog.numino.net/
BSTIME datetime 8 0
Rd9PD7 http://blog.numino.net/
LEVELUPPOINT int 4 0
5OZXKG http://blog.numino.net/
GDDS int 4 0
|
|