| 奇迹muonline数据库基础库分析 |
一、表的组成：
d6ou4A http://blog.numino.net/
1、AccountCharacter
dpmS6W http://blog.numino.net/
用来存放帐号的角色。
l6tSXd http://blog.numino.net/
2、Character
2L05Y2 http://blog.numino.net/
用来存放每个角色的详细数据。
KL85Tw http://blog.numino.net/
3、MEMB_INFO
ejfP9H http://blog.numino.net/
帐号信息
I2Baka http://blog.numino.net/
4、MEMB_STAT
bayhg2 http://blog.numino.net/
帐号状态
RYDbnQ http://blog.numino.net/
5、warehouse
Fpl565 http://blog.numino.net/
仓库
5B42xk http://blog.numino.net/
6、VI_CURR_INFO
M3IP9f http://blog.numino.net/
帐号费用
Yq5Rad http://blog.numino.net/
7、WEB_ZS
qPeJ7D http://blog.numino.net/
PL 网站的转生数据
Eiv2bk http://blog.numino.net/
二、各表说明
KQ4dG5 http://blog.numino.net/
1、AccountCharacter 表
V8HTw1 http://blog.numino.net/
列名 类型 长 是否空 说明
866UDW http://blog.numino.net/
Number int 4 0 自动增加的序数
4jg5pZ http://blog.numino.net/
Id varchar 10 0 帐号
lmB3bk http://blog.numino.net/
GameID1 varchar 10 1 角色1
cET56c http://blog.numino.net/
GameID2 varchar 10 1 角色2
91GCiu http://blog.numino.net/
GameID3 varchar 10 1
Z2bS47 http://blog.numino.net/
GameID4 varchar 10 1
UyB4Ec http://blog.numino.net/
GameID5 varchar 10 1
Fz1WZC http://blog.numino.net/
GameIDC varchar 10 1
AJ5CF7 http://blog.numino.net/
2、Character 表
jFHr2I http://blog.numino.net/
列名 类型 长 是否空 说明
Dit4BX http://blog.numino.net/
AccountID varchar 10 0 --------帐号
NW63CP http://blog.numino.net/
Name nvarchar 10 0 --------角色名
Pk790m http://blog.numino.net/
cLevel smallint 2 1 --------等级
JbxT2t http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
LtW4zP http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
h1TdCh http://blog.numino.net/
Experience int 4 1 --------经验
C25nf7 http://blog.numino.net/
Strength smallint 2 1 --------力量
ayhqP0 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
Q7bPJP http://blog.numino.net/
Vitality smallint 2 1 --------体力
ZFIdLB http://blog.numino.net/
Energy smallint 2 1 --------智力
XWlsvY http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
8R4Qj3 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
2HfmQZ http://blog.numino.net/
Money int 4 1 --------钱
61mWtR http://blog.numino.net/
Life real 4 1 --------
3Gt4yO http://blog.numino.net/
MaxLife real 4 1 --------
1u17HD http://blog.numino.net/
Mana real 4 1 --------
7vLN9U http://blog.numino.net/
MaxMana real 4 1 --------
u51y2X http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
nxm7yI http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
VJHFvZ http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
EK1ZAL http://blog.numino.net/
MapDir tinyint 1 1 --------
5tmR6T http://blog.numino.net/
PkCount int 4 1 --------
xaNV2l http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
LjfaPl http://blog.numino.net/
PkTime int 4 1
cz2l5y http://blog.numino.net/
MDate smalldatetime 4 1
y6U4xg http://blog.numino.net/
LDate smalldatetime 4 1
8Y0I3F http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
4qmnt1 http://blog.numino.net/
DbVersion tinyint 1 1
NRfrwz http://blog.numino.net/
Quest varbinary 50 1
LZB9o7 http://blog.numino.net/
LINZB bit 1 0
Y7l2tM http://blog.numino.net/
XDTIME datetime 8 0
xyp6m1 http://blog.numino.net/
STOPINFO nvarchar 100 1
2hNLY1 http://blog.numino.net/
STOPTIME datetime 8 0
TomxBo http://blog.numino.net/
zs_count int 4 1
r0SXlQ http://blog.numino.net/
zs_point int 4 1
S632I7 http://blog.numino.net/
bs_count int 4 1
J5SMUf http://blog.numino.net/
bs_point int 4 1
3J3rT6 http://blog.numino.net/
shiji smalldatetime 4 1
Q0mKQ9 http://blog.numino.net/
banl nvarchar 10 1
zLlwMM http://blog.numino.net/
lv_time datetime 8 1
8ifzC0 http://blog.numino.net/
ex_ok int 4 1
T27Dqs http://blog.numino.net/
ex_total int 4 1
Hc2Et3 http://blog.numino.net/
rb_count int 4 1
3Rygmx http://blog.numino.net/
rb_time datetime 8 1
Wu0pn7 http://blog.numino.net/
pz_time datetime 8 1
cy1Lm1 http://blog.numino.net/
3、MEMB_INFO
q5YQPU http://blog.numino.net/
列名 类型 长 是否空 说明
n95uin http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
t44NXE http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
FYuhDX http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
DNuwiB http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
vpzsfL http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
29058z http://blog.numino.net/
post_code nvarchar 6 1 --------1234
kzf8Zl http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
TP6gp3 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
hAOUZS http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
qrRdFf http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
Pjva9y http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
csLAKD http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
6UVxtK http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
g0Dhyv http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
r3CdER http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
K7Xkkn http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
p79msI http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
G6YsHd http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
fqDFgk http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
7ygYWp http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
17x95t http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
G8xDJZ http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
r0Mf1R http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
nB9N7I http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
3IGtYd http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
U7Pk6q http://blog.numino.net/
QX char 1 1 --------B
61z6P7 http://blog.numino.net/
JF int 4 0 --------0
30Ip4b http://blog.numino.net/
huiy int 4 1 --------0
QKS2qw http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
nnwrug http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
DP2mN6 http://blog.numino.net/
FDB int 4 1 --------0
y13WNM http://blog.numino.net/
vip tinyint 1 1 --------0
jI6UmQ http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
ZDLNpa http://blog.numino.net/
4、MEMB_STAT
t4Dox0 http://blog.numino.net/
列名 类型 长 是否空 说明
NcjARs http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
ODsjcR http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
6qg5rX http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
gWqOh9 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
r3292l http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
Y5O23t http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
RQ8371 http://blog.numino.net/
5、warehouse
jgR58r http://blog.numino.net/
列名 类型 长 是否空 说明
Kqy3Ra http://blog.numino.net/
AccountID varchar 10 0 --------帐号
OeiGPq http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
2z8uD8 http://blog.numino.net/
Money int 4 1 --------钱
Xw6NoK http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
72gWzX http://blog.numino.net/
DbVersion tinyint 1 1 --------1
1X8YeF http://blog.numino.net/
pw smallint 2 1 --------密码 0
zd0uA0 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
8K8n5T http://blog.numino.net/
ExtCKNum int 4 0 --------0
8uhio6 http://blog.numino.net/
NeedExtCK int 4 0 --------0
CKP0wn http://blog.numino.net/
6、VI_CURR_INFO
ShQIuI http://blog.numino.net/
列名 类型 长 是否空 说明
lBzbCd http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
ndl5xx http://blog.numino.net/
chek_code nvarchar 1 0 --------1
x9nwoT http://blog.numino.net/
used_time int 4 1 --------1234
d09pSS http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
9Ak44i http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
7amNZ0 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
Shn9v2 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
mZi13N http://blog.numino.net/
Bill_Section int 4 1 --------6
nQtaqz http://blog.numino.net/
Bill_Value int 4 1 --------3
C3N0W5 http://blog.numino.net/
Bill_Hour int 4 1 --------0
hkdu99 http://blog.numino.net/
Surplus_Point int 4 1 --------0
h9VQx9 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
zU2EJr http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
pAgpAO http://blog.numino.net/
7、WEB_ZS
XURLJW http://blog.numino.net/
列名 类型 长 是否空 说明
s3r9ge http://blog.numino.net/
ID bigint 8 0
7G7OOa http://blog.numino.net/
ACC char 10 1
awLZ0d http://blog.numino.net/
NAME char 10 1
nO60vE http://blog.numino.net/
ZSTIME datetime 8 1
o16hwn http://blog.numino.net/
ZSCLEVEL smallint 2 1
sV0143 http://blog.numino.net/
ZSCS smallint 2 0
247SKL http://blog.numino.net/
CZCS smallint 2 0
LLWxj4 http://blog.numino.net/
CZTIME datetime 8 0
v2hkza http://blog.numino.net/
ZJZSCS smallint 2 0
UA1jlU http://blog.numino.net/
GJZSCS smallint 2 0
wVFD9C http://blog.numino.net/
CJZSCS smallint 2 0
039bss http://blog.numino.net/
BSCS smallint 2 0
LD42Ql http://blog.numino.net/
BSTIME datetime 8 0
Y34coX http://blog.numino.net/
LEVELUPPOINT int 4 0
OPnZ91 http://blog.numino.net/
GDDS int 4 0
|
|