| 奇迹muonline数据库基础库分析 |
一、表的组成：
q4jOZL http://blog.numino.net/
1、AccountCharacter
J49Df1 http://blog.numino.net/
用来存放帐号的角色。
qtZ8Aa http://blog.numino.net/
2、Character
m59n85 http://blog.numino.net/
用来存放每个角色的详细数据。
JU0MpT http://blog.numino.net/
3、MEMB_INFO
nw0Fc9 http://blog.numino.net/
帐号信息
5x5WEp http://blog.numino.net/
4、MEMB_STAT
GA1byM http://blog.numino.net/
帐号状态
H88y5a http://blog.numino.net/
5、warehouse
5P5X81 http://blog.numino.net/
仓库
A7151e http://blog.numino.net/
6、VI_CURR_INFO
pZcATh http://blog.numino.net/
帐号费用
eF7j5z http://blog.numino.net/
7、WEB_ZS
3kFc71 http://blog.numino.net/
PL 网站的转生数据
kixyRv http://blog.numino.net/
二、各表说明
ioI66g http://blog.numino.net/
1、AccountCharacter 表
k9ioIF http://blog.numino.net/
列名 类型 长 是否空 说明
6o3P5Z http://blog.numino.net/
Number int 4 0 自动增加的序数
4RO78h http://blog.numino.net/
Id varchar 10 0 帐号
vvWHf6 http://blog.numino.net/
GameID1 varchar 10 1 角色1
Wl8cQB http://blog.numino.net/
GameID2 varchar 10 1 角色2
j2m9yj http://blog.numino.net/
GameID3 varchar 10 1
rE3d20 http://blog.numino.net/
GameID4 varchar 10 1
Wv4O7H http://blog.numino.net/
GameID5 varchar 10 1
4k6a21 http://blog.numino.net/
GameIDC varchar 10 1
WxxX72 http://blog.numino.net/
2、Character 表
v8B7Id http://blog.numino.net/
列名 类型 长 是否空 说明
WYseJu http://blog.numino.net/
AccountID varchar 10 0 --------帐号
vpqWv7 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
19yfoo http://blog.numino.net/
cLevel smallint 2 1 --------等级
P4kVeA http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
u0R4B3 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
ur36e1 http://blog.numino.net/
Experience int 4 1 --------经验
H8jyYm http://blog.numino.net/
Strength smallint 2 1 --------力量
5a5ogj http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
56OYBK http://blog.numino.net/
Vitality smallint 2 1 --------体力
9HEplo http://blog.numino.net/
Energy smallint 2 1 --------智力
EZZ7UO http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
zG5n8C http://blog.numino.net/
MagicList varbinary 60 1 --------技能
6aRm5g http://blog.numino.net/
Money int 4 1 --------钱
viKp3N http://blog.numino.net/
Life real 4 1 --------
m15AEB http://blog.numino.net/
MaxLife real 4 1 --------
U5wr40 http://blog.numino.net/
Mana real 4 1 --------
z6dTga http://blog.numino.net/
MaxMana real 4 1 --------
VSq0h1 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
UQPm1x http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
HklWN7 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
0wPWxB http://blog.numino.net/
MapDir tinyint 1 1 --------
gb9lVM http://blog.numino.net/
PkCount int 4 1 --------
s3XZbV http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
bFB7uF http://blog.numino.net/
PkTime int 4 1
d20mEK http://blog.numino.net/
MDate smalldatetime 4 1
lNlgAD http://blog.numino.net/
LDate smalldatetime 4 1
fvFgAd http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
pKuE8y http://blog.numino.net/
DbVersion tinyint 1 1
wr6DG8 http://blog.numino.net/
Quest varbinary 50 1
YgWK4d http://blog.numino.net/
LINZB bit 1 0
Dj7ZTB http://blog.numino.net/
XDTIME datetime 8 0
IplHlZ http://blog.numino.net/
STOPINFO nvarchar 100 1
b2bVOq http://blog.numino.net/
STOPTIME datetime 8 0
PvowJm http://blog.numino.net/
zs_count int 4 1
J6A6Qa http://blog.numino.net/
zs_point int 4 1
Q62p2D http://blog.numino.net/
bs_count int 4 1
Xztjew http://blog.numino.net/
bs_point int 4 1
hJ2kF7 http://blog.numino.net/
shiji smalldatetime 4 1
5cyB2j http://blog.numino.net/
banl nvarchar 10 1
FDNV88 http://blog.numino.net/
lv_time datetime 8 1
Mz13i7 http://blog.numino.net/
ex_ok int 4 1
W6eVz1 http://blog.numino.net/
ex_total int 4 1
j382r7 http://blog.numino.net/
rb_count int 4 1
qWq8NO http://blog.numino.net/
rb_time datetime 8 1
pOODMy http://blog.numino.net/
pz_time datetime 8 1
3QNCtO http://blog.numino.net/
3、MEMB_INFO
aQ0AtL http://blog.numino.net/
列名 类型 长 是否空 说明
Bj09Ym http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
BZzJND http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
cV8erq http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
tnl6jc http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
YdTJ7Q http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
4nVw86 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
vPc2vi http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
4ht8PD http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
v4lUDh http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
7NEoLZ http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
iEMuV2 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
yQOHLM http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
nUU9cw http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
NsojFa http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
IrjLq8 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
MZghA5 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
0K84qF http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
K1sSSf http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
qT8dty http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
z77ReY http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
Qt5jky http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
cuGvsR http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
87bX2I http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
oXJA9V http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
3DkoLr http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
ClFY4G http://blog.numino.net/
QX char 1 1 --------B
Tqh3Mh http://blog.numino.net/
JF int 4 0 --------0
joPJA6 http://blog.numino.net/
huiy int 4 1 --------0
k82zBW http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
16Mv8N http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
nvlXvH http://blog.numino.net/
FDB int 4 1 --------0
DVNJ9U http://blog.numino.net/
vip tinyint 1 1 --------0
DE851G http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
27G42Y http://blog.numino.net/
4、MEMB_STAT
nY0tVk http://blog.numino.net/
列名 类型 长 是否空 说明
G62cGw http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
4bb7kc http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
HpGnY6 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
baOf2J http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
7sgGlZ http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
1c32Vp http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
C2fT52 http://blog.numino.net/
5、warehouse
Eyctmo http://blog.numino.net/
列名 类型 长 是否空 说明
tJKXak http://blog.numino.net/
AccountID varchar 10 0 --------帐号
v4GI6H http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
dit9G4 http://blog.numino.net/
Money int 4 1 --------钱
0Elfc5 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
oielvW http://blog.numino.net/
DbVersion tinyint 1 1 --------1
Ttu6P8 http://blog.numino.net/
pw smallint 2 1 --------密码 0
VtykD6 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
UiwnAB http://blog.numino.net/
ExtCKNum int 4 0 --------0
2CY3Yq http://blog.numino.net/
NeedExtCK int 4 0 --------0
gx19JI http://blog.numino.net/
6、VI_CURR_INFO
38mpkf http://blog.numino.net/
列名 类型 长 是否空 说明
0h0EsI http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
qHzXE2 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
6H8SUR http://blog.numino.net/
used_time int 4 1 --------1234
9O5p5a http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
r4DiGl http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
We4w02 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
SeJ5X6 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
7M8Ujq http://blog.numino.net/
Bill_Section int 4 1 --------6
dxAMWp http://blog.numino.net/
Bill_Value int 4 1 --------3
YduZBx http://blog.numino.net/
Bill_Hour int 4 1 --------0
BUS7v4 http://blog.numino.net/
Surplus_Point int 4 1 --------0
0FmnZ8 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
Br037T http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
6elkDY http://blog.numino.net/
7、WEB_ZS
6N0726 http://blog.numino.net/
列名 类型 长 是否空 说明
TKmDmV http://blog.numino.net/
ID bigint 8 0
w1MPsX http://blog.numino.net/
ACC char 10 1
8on9Hf http://blog.numino.net/
NAME char 10 1
Z64U72 http://blog.numino.net/
ZSTIME datetime 8 1
33TM7Q http://blog.numino.net/
ZSCLEVEL smallint 2 1
1hrHLg http://blog.numino.net/
ZSCS smallint 2 0
6FTZlU http://blog.numino.net/
CZCS smallint 2 0
uf603r http://blog.numino.net/
CZTIME datetime 8 0
V7KJ51 http://blog.numino.net/
ZJZSCS smallint 2 0
2hJ68c http://blog.numino.net/
GJZSCS smallint 2 0
c4yPQc http://blog.numino.net/
CJZSCS smallint 2 0
0MxBwz http://blog.numino.net/
BSCS smallint 2 0
BRazcX http://blog.numino.net/
BSTIME datetime 8 0
yWlIR3 http://blog.numino.net/
LEVELUPPOINT int 4 0
GqUaWZ http://blog.numino.net/
GDDS int 4 0
|
|