| 奇迹muonline数据库基础库分析 |
一、表的组成：
iwk4Du http://blog.numino.net/
1、AccountCharacter
aO02ns http://blog.numino.net/
用来存放帐号的角色。
e41486 http://blog.numino.net/
2、Character
l5WX6b http://blog.numino.net/
用来存放每个角色的详细数据。
wOwjyS http://blog.numino.net/
3、MEMB_INFO
3F7pbq http://blog.numino.net/
帐号信息
i2o4om http://blog.numino.net/
4、MEMB_STAT
IXT202 http://blog.numino.net/
帐号状态
UV371c http://blog.numino.net/
5、warehouse
x2jXtl http://blog.numino.net/
仓库
nod7tA http://blog.numino.net/
6、VI_CURR_INFO
JW682W http://blog.numino.net/
帐号费用
G5DScg http://blog.numino.net/
7、WEB_ZS
XWnZL8 http://blog.numino.net/
PL 网站的转生数据
mL5dpv http://blog.numino.net/
二、各表说明
V39Dct http://blog.numino.net/
1、AccountCharacter 表
ti227y http://blog.numino.net/
列名 类型 长 是否空 说明
9sAnIk http://blog.numino.net/
Number int 4 0 自动增加的序数
806767 http://blog.numino.net/
Id varchar 10 0 帐号
OOMb2g http://blog.numino.net/
GameID1 varchar 10 1 角色1
8DCJc3 http://blog.numino.net/
GameID2 varchar 10 1 角色2
tjMux6 http://blog.numino.net/
GameID3 varchar 10 1
3U8ySh http://blog.numino.net/
GameID4 varchar 10 1
5YPPmD http://blog.numino.net/
GameID5 varchar 10 1
H5MHJB http://blog.numino.net/
GameIDC varchar 10 1
SLbKMu http://blog.numino.net/
2、Character 表
GtZe1P http://blog.numino.net/
列名 类型 长 是否空 说明
60nJa5 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
5gOjeX http://blog.numino.net/
Name nvarchar 10 0 --------角色名
0I1KmC http://blog.numino.net/
cLevel smallint 2 1 --------等级
0oL4Jh http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
V52eJ4 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
AvU74H http://blog.numino.net/
Experience int 4 1 --------经验
j34WUV http://blog.numino.net/
Strength smallint 2 1 --------力量
v0gq7L http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
br8nF7 http://blog.numino.net/
Vitality smallint 2 1 --------体力
Z4VBLi http://blog.numino.net/
Energy smallint 2 1 --------智力
nXKW5p http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
6oaqPy http://blog.numino.net/
MagicList varbinary 60 1 --------技能
rj4LRJ http://blog.numino.net/
Money int 4 1 --------钱
2T7NX7 http://blog.numino.net/
Life real 4 1 --------
p31ooO http://blog.numino.net/
MaxLife real 4 1 --------
cPgJcX http://blog.numino.net/
Mana real 4 1 --------
85BRbk http://blog.numino.net/
MaxMana real 4 1 --------
f0LHvW http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
95o3BS http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
IX2e2h http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
01M9VE http://blog.numino.net/
MapDir tinyint 1 1 --------
BVJcTT http://blog.numino.net/
PkCount int 4 1 --------
CFJ7s5 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
1gvvAj http://blog.numino.net/
PkTime int 4 1
R64Zdl http://blog.numino.net/
MDate smalldatetime 4 1
hl5nLt http://blog.numino.net/
LDate smalldatetime 4 1
gyi9V7 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
3RQrI2 http://blog.numino.net/
DbVersion tinyint 1 1
5zS0EH http://blog.numino.net/
Quest varbinary 50 1
ZmpTxM http://blog.numino.net/
LINZB bit 1 0
fE4znL http://blog.numino.net/
XDTIME datetime 8 0
NgHq1q http://blog.numino.net/
STOPINFO nvarchar 100 1
y9Zmg0 http://blog.numino.net/
STOPTIME datetime 8 0
62k657 http://blog.numino.net/
zs_count int 4 1
x46ER2 http://blog.numino.net/
zs_point int 4 1
dfQHuX http://blog.numino.net/
bs_count int 4 1
cObpO5 http://blog.numino.net/
bs_point int 4 1
XY4lVs http://blog.numino.net/
shiji smalldatetime 4 1
j8BEav http://blog.numino.net/
banl nvarchar 10 1
HMXdgZ http://blog.numino.net/
lv_time datetime 8 1
BNEB7a http://blog.numino.net/
ex_ok int 4 1
XqnL7Y http://blog.numino.net/
ex_total int 4 1
OvySn9 http://blog.numino.net/
rb_count int 4 1
Pqrbvq http://blog.numino.net/
rb_time datetime 8 1
u6z9av http://blog.numino.net/
pz_time datetime 8 1
Q10Ve3 http://blog.numino.net/
3、MEMB_INFO
dC326x http://blog.numino.net/
列名 类型 长 是否空 说明
cTR3lz http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
2DMn4l http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
081SrB http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
gEcwm3 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
8SudhU http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
Q29l1M http://blog.numino.net/
post_code nvarchar 6 1 --------1234
KIKN4C http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
5sEz6I http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
TJMrWK http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
NVFI3h http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
S59vEP http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
wm42Nb http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
uqmaWy http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
6S8M34 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
lCF7Jv http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
wKxcG2 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
V0egG9 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
gh1q09 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
P72OJ6 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
dS4jNA http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
4UBzTg http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
j5c650 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
nHI0P5 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
fN6rxG http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
9SbGM5 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
5vw4xu http://blog.numino.net/
QX char 1 1 --------B
aGwUWX http://blog.numino.net/
JF int 4 0 --------0
6USTxA http://blog.numino.net/
huiy int 4 1 --------0
f08Qxh http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
sSbEV4 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
qv1irP http://blog.numino.net/
FDB int 4 1 --------0
L42geW http://blog.numino.net/
vip tinyint 1 1 --------0
5lv7Np http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
4QdNCC http://blog.numino.net/
4、MEMB_STAT
CNvvQT http://blog.numino.net/
列名 类型 长 是否空 说明
71btE4 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
6rTwV4 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
9xXfh5 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
34muC0 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
aF85iC http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
hX5QPq http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
8YR2nI http://blog.numino.net/
5、warehouse
fm8I02 http://blog.numino.net/
列名 类型 长 是否空 说明
7Fb2DG http://blog.numino.net/
AccountID varchar 10 0 --------帐号
OYnU7K http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
ZamAZp http://blog.numino.net/
Money int 4 1 --------钱
98kVo8 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
JP1KJq http://blog.numino.net/
DbVersion tinyint 1 1 --------1
5QuOFd http://blog.numino.net/
pw smallint 2 1 --------密码 0
fvKm49 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
tXZhkB http://blog.numino.net/
ExtCKNum int 4 0 --------0
J8iPbB http://blog.numino.net/
NeedExtCK int 4 0 --------0
4U6cK5 http://blog.numino.net/
6、VI_CURR_INFO
dLicx9 http://blog.numino.net/
列名 类型 长 是否空 说明
QxoIBZ http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
YgBa4T http://blog.numino.net/
chek_code nvarchar 1 0 --------1
6vdbXo http://blog.numino.net/
used_time int 4 1 --------1234
17Old5 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
LLkHAY http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
YYXXbY http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
fzCyCq http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
I2j58n http://blog.numino.net/
Bill_Section int 4 1 --------6
nXV1t8 http://blog.numino.net/
Bill_Value int 4 1 --------3
r11r0h http://blog.numino.net/
Bill_Hour int 4 1 --------0
9f78Gp http://blog.numino.net/
Surplus_Point int 4 1 --------0
BWrp0G http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
ER3228 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
7916x7 http://blog.numino.net/
7、WEB_ZS
R67w4P http://blog.numino.net/
列名 类型 长 是否空 说明
wjN1Cb http://blog.numino.net/
ID bigint 8 0
DS73Pu http://blog.numino.net/
ACC char 10 1
NCO5Hc http://blog.numino.net/
NAME char 10 1
K39S3H http://blog.numino.net/
ZSTIME datetime 8 1
ewvr91 http://blog.numino.net/
ZSCLEVEL smallint 2 1
yr8vxR http://blog.numino.net/
ZSCS smallint 2 0
ppodc4 http://blog.numino.net/
CZCS smallint 2 0
si4l8u http://blog.numino.net/
CZTIME datetime 8 0
InRD44 http://blog.numino.net/
ZJZSCS smallint 2 0
79508R http://blog.numino.net/
GJZSCS smallint 2 0
2xwneI http://blog.numino.net/
CJZSCS smallint 2 0
X6d9gr http://blog.numino.net/
BSCS smallint 2 0
uuo32Q http://blog.numino.net/
BSTIME datetime 8 0
PKqTX6 http://blog.numino.net/
LEVELUPPOINT int 4 0
l7llmk http://blog.numino.net/
GDDS int 4 0
|
|