| 奇迹muonline数据库基础库分析 |
一、表的组成：
1y06qw http://blog.numino.net/
1、AccountCharacter
tw7yMK http://blog.numino.net/
用来存放帐号的角色。
xF0n8n http://blog.numino.net/
2、Character
cxT8wb http://blog.numino.net/
用来存放每个角色的详细数据。
xt9lcb http://blog.numino.net/
3、MEMB_INFO
Xb0wy3 http://blog.numino.net/
帐号信息
KbxD01 http://blog.numino.net/
4、MEMB_STAT
dxL3RA http://blog.numino.net/
帐号状态
bjVI9p http://blog.numino.net/
5、warehouse
hjXjSX http://blog.numino.net/
仓库
g4xv68 http://blog.numino.net/
6、VI_CURR_INFO
urBMqb http://blog.numino.net/
帐号费用
9ON9T5 http://blog.numino.net/
7、WEB_ZS
Dm9lvj http://blog.numino.net/
PL 网站的转生数据
n3ln6m http://blog.numino.net/
二、各表说明
RdDpaK http://blog.numino.net/
1、AccountCharacter 表
6wrJGm http://blog.numino.net/
列名 类型 长 是否空 说明
z838B6 http://blog.numino.net/
Number int 4 0 自动增加的序数
VJg3wF http://blog.numino.net/
Id varchar 10 0 帐号
86tknr http://blog.numino.net/
GameID1 varchar 10 1 角色1
xcus8j http://blog.numino.net/
GameID2 varchar 10 1 角色2
9rmI98 http://blog.numino.net/
GameID3 varchar 10 1
X99LJN http://blog.numino.net/
GameID4 varchar 10 1
Jvn0d8 http://blog.numino.net/
GameID5 varchar 10 1
whfWZE http://blog.numino.net/
GameIDC varchar 10 1
s0T52E http://blog.numino.net/
2、Character 表
Pvev58 http://blog.numino.net/
列名 类型 长 是否空 说明
pZF4al http://blog.numino.net/
AccountID varchar 10 0 --------帐号
L0mrZs http://blog.numino.net/
Name nvarchar 10 0 --------角色名
z928PC http://blog.numino.net/
cLevel smallint 2 1 --------等级
Ficy1T http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
E2AXVq http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
46uxvL http://blog.numino.net/
Experience int 4 1 --------经验
v3nmVv http://blog.numino.net/
Strength smallint 2 1 --------力量
2NTxv7 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
ckv96I http://blog.numino.net/
Vitality smallint 2 1 --------体力
m85DSX http://blog.numino.net/
Energy smallint 2 1 --------智力
9Z032M http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
Jm8Jt1 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
K7Wyvs http://blog.numino.net/
Money int 4 1 --------钱
tU7TBZ http://blog.numino.net/
Life real 4 1 --------
ldz2mo http://blog.numino.net/
MaxLife real 4 1 --------
Dh0ui6 http://blog.numino.net/
Mana real 4 1 --------
jDUSzY http://blog.numino.net/
MaxMana real 4 1 --------
q9eCoC http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
vg02W4 http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
WQKBo8 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
TcqQ0O http://blog.numino.net/
MapDir tinyint 1 1 --------
Y822YP http://blog.numino.net/
PkCount int 4 1 --------
e4IShc http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
4hhzdS http://blog.numino.net/
PkTime int 4 1
RnIIQU http://blog.numino.net/
MDate smalldatetime 4 1
0WB3I1 http://blog.numino.net/
LDate smalldatetime 4 1
48hi6f http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
4O14GS http://blog.numino.net/
DbVersion tinyint 1 1
cTV586 http://blog.numino.net/
Quest varbinary 50 1
pCKpdB http://blog.numino.net/
LINZB bit 1 0
0tIs33 http://blog.numino.net/
XDTIME datetime 8 0
689PVE http://blog.numino.net/
STOPINFO nvarchar 100 1
7OM0SQ http://blog.numino.net/
STOPTIME datetime 8 0
xOSDCn http://blog.numino.net/
zs_count int 4 1
J43Us9 http://blog.numino.net/
zs_point int 4 1
9ME921 http://blog.numino.net/
bs_count int 4 1
31lh2Z http://blog.numino.net/
bs_point int 4 1
oBsZuI http://blog.numino.net/
shiji smalldatetime 4 1
MUZ9on http://blog.numino.net/
banl nvarchar 10 1
i4qzk9 http://blog.numino.net/
lv_time datetime 8 1
MqUSq4 http://blog.numino.net/
ex_ok int 4 1
5B6RLg http://blog.numino.net/
ex_total int 4 1
J9zx9f http://blog.numino.net/
rb_count int 4 1
03C89K http://blog.numino.net/
rb_time datetime 8 1
eWGZUz http://blog.numino.net/
pz_time datetime 8 1
V743xC http://blog.numino.net/
3、MEMB_INFO
ecE6Zn http://blog.numino.net/
列名 类型 长 是否空 说明
1t1xlS http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
NwDCyP http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
3ED8ps http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
M2nyH9 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
xMqIno http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
6DxSQ4 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
kdwer7 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
w4YZ4u http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
OAzgV3 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
1No2k9 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
19PUku http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
2fYsp6 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
zf10ao http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
P4DfRg http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
8eKyhJ http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
hXcH30 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
R8spMH http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
qRG3Kq http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
AoQ3Vm http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
z63CKa http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
aru6P3 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
e1gzSl http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
0Ilig7 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
BZZEFR http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
9OT8cU http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
TrJ2ue http://blog.numino.net/
QX char 1 1 --------B
8Y6hzp http://blog.numino.net/
JF int 4 0 --------0
bieF62 http://blog.numino.net/
huiy int 4 1 --------0
hvq7tk http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
5CR1dv http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
DINIA2 http://blog.numino.net/
FDB int 4 1 --------0
81Idg8 http://blog.numino.net/
vip tinyint 1 1 --------0
NdUdO8 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
87SJOB http://blog.numino.net/
4、MEMB_STAT
1gG6QR http://blog.numino.net/
列名 类型 长 是否空 说明
K0D3O7 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
HJtn0K http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
9B31ak http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
3L3olI http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
GSi5Cy http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
8CyE26 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
7RqitN http://blog.numino.net/
5、warehouse
I0k4yO http://blog.numino.net/
列名 类型 长 是否空 说明
fMw1MI http://blog.numino.net/
AccountID varchar 10 0 --------帐号
ZQoOAe http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
ylNuFw http://blog.numino.net/
Money int 4 1 --------钱
Bs6A0c http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
r8Is94 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
7Kz7y2 http://blog.numino.net/
pw smallint 2 1 --------密码 0
o4rWi0 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
9uFfwy http://blog.numino.net/
ExtCKNum int 4 0 --------0
qOZwEg http://blog.numino.net/
NeedExtCK int 4 0 --------0
2G47ud http://blog.numino.net/
6、VI_CURR_INFO
l0553x http://blog.numino.net/
列名 类型 长 是否空 说明
xzU4eB http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
d2ktv3 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
Lwqc77 http://blog.numino.net/
used_time int 4 1 --------1234
bgpWhp http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Wz1sCT http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
2m9DdY http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
VBFK72 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
CVluzX http://blog.numino.net/
Bill_Section int 4 1 --------6
LPwE5l http://blog.numino.net/
Bill_Value int 4 1 --------3
2uJ7Ge http://blog.numino.net/
Bill_Hour int 4 1 --------0
JhRpRI http://blog.numino.net/
Surplus_Point int 4 1 --------0
P0xJwI http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
sd6Tzj http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
Xk0VPH http://blog.numino.net/
7、WEB_ZS
0d85bI http://blog.numino.net/
列名 类型 长 是否空 说明
8x5xfZ http://blog.numino.net/
ID bigint 8 0
DNu5NL http://blog.numino.net/
ACC char 10 1
fYlvs9 http://blog.numino.net/
NAME char 10 1
8kPtZm http://blog.numino.net/
ZSTIME datetime 8 1
H7vW3p http://blog.numino.net/
ZSCLEVEL smallint 2 1
FU2LwX http://blog.numino.net/
ZSCS smallint 2 0
jUUXQL http://blog.numino.net/
CZCS smallint 2 0
X0TRa9 http://blog.numino.net/
CZTIME datetime 8 0
uJZj7x http://blog.numino.net/
ZJZSCS smallint 2 0
9KRT06 http://blog.numino.net/
GJZSCS smallint 2 0
KOVr4f http://blog.numino.net/
CJZSCS smallint 2 0
VNt261 http://blog.numino.net/
BSCS smallint 2 0
4lqfWC http://blog.numino.net/
BSTIME datetime 8 0
oICIyy http://blog.numino.net/
LEVELUPPOINT int 4 0
LJT8DA http://blog.numino.net/
GDDS int 4 0
|
|