| 奇迹muonline数据库基础库分析 |
一、表的组成：
FxHjje http://blog.numino.net/
1、AccountCharacter
J4mLaJ http://blog.numino.net/
用来存放帐号的角色。
JinNY5 http://blog.numino.net/
2、Character
Ceo2ZQ http://blog.numino.net/
用来存放每个角色的详细数据。
vWz47r http://blog.numino.net/
3、MEMB_INFO
92YFuM http://blog.numino.net/
帐号信息
mOBnlR http://blog.numino.net/
4、MEMB_STAT
5ppceG http://blog.numino.net/
帐号状态
xn18O8 http://blog.numino.net/
5、warehouse
ubH13m http://blog.numino.net/
仓库
9l3UHG http://blog.numino.net/
6、VI_CURR_INFO
9jUXvi http://blog.numino.net/
帐号费用
hfoPw1 http://blog.numino.net/
7、WEB_ZS
ItnfEV http://blog.numino.net/
PL 网站的转生数据
2lxXs9 http://blog.numino.net/
二、各表说明
zGeXvL http://blog.numino.net/
1、AccountCharacter 表
3GM1Yu http://blog.numino.net/
列名 类型 长 是否空 说明
l4k6dG http://blog.numino.net/
Number int 4 0 自动增加的序数
YbI2ZH http://blog.numino.net/
Id varchar 10 0 帐号
x4jKKE http://blog.numino.net/
GameID1 varchar 10 1 角色1
loLQ1X http://blog.numino.net/
GameID2 varchar 10 1 角色2
hoeLqJ http://blog.numino.net/
GameID3 varchar 10 1
5861S7 http://blog.numino.net/
GameID4 varchar 10 1
FwBjPq http://blog.numino.net/
GameID5 varchar 10 1
hCb2S6 http://blog.numino.net/
GameIDC varchar 10 1
6YlLtP http://blog.numino.net/
2、Character 表
V6JRo2 http://blog.numino.net/
列名 类型 长 是否空 说明
2LqQ9Q http://blog.numino.net/
AccountID varchar 10 0 --------帐号
t3Is9H http://blog.numino.net/
Name nvarchar 10 0 --------角色名
BVUI5D http://blog.numino.net/
cLevel smallint 2 1 --------等级
F1ur5i http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
dl6Dw9 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
WoHMfW http://blog.numino.net/
Experience int 4 1 --------经验
o87RpW http://blog.numino.net/
Strength smallint 2 1 --------力量
nSqObg http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
PFmv7p http://blog.numino.net/
Vitality smallint 2 1 --------体力
BXF8Np http://blog.numino.net/
Energy smallint 2 1 --------智力
Hvr5hD http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
9VOdRU http://blog.numino.net/
MagicList varbinary 60 1 --------技能
aPY8pR http://blog.numino.net/
Money int 4 1 --------钱
dfctAx http://blog.numino.net/
Life real 4 1 --------
z5Ux1t http://blog.numino.net/
MaxLife real 4 1 --------
RrTFXG http://blog.numino.net/
Mana real 4 1 --------
TOKIGU http://blog.numino.net/
MaxMana real 4 1 --------
007eJU http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
dWCUEz http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
atL437 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
s8iac5 http://blog.numino.net/
MapDir tinyint 1 1 --------
MyGaAr http://blog.numino.net/
PkCount int 4 1 --------
QZ07E8 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
ahma93 http://blog.numino.net/
PkTime int 4 1
Q7qv1g http://blog.numino.net/
MDate smalldatetime 4 1
3Wv0pX http://blog.numino.net/
LDate smalldatetime 4 1
INp61N http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
KWg887 http://blog.numino.net/
DbVersion tinyint 1 1
m1F0B1 http://blog.numino.net/
Quest varbinary 50 1
lPUnZK http://blog.numino.net/
LINZB bit 1 0
0Sa5hT http://blog.numino.net/
XDTIME datetime 8 0
bXO3a5 http://blog.numino.net/
STOPINFO nvarchar 100 1
xbElh5 http://blog.numino.net/
STOPTIME datetime 8 0
46hq66 http://blog.numino.net/
zs_count int 4 1
n5V9g3 http://blog.numino.net/
zs_point int 4 1
Or6r4D http://blog.numino.net/
bs_count int 4 1
ZjW03w http://blog.numino.net/
bs_point int 4 1
He1Yrc http://blog.numino.net/
shiji smalldatetime 4 1
fVX7dO http://blog.numino.net/
banl nvarchar 10 1
MSaL8i http://blog.numino.net/
lv_time datetime 8 1
67Na5d http://blog.numino.net/
ex_ok int 4 1
nkI6vU http://blog.numino.net/
ex_total int 4 1
jaC2Wn http://blog.numino.net/
rb_count int 4 1
pfa124 http://blog.numino.net/
rb_time datetime 8 1
3A2K0h http://blog.numino.net/
pz_time datetime 8 1
60Q9aS http://blog.numino.net/
3、MEMB_INFO
EmT9c1 http://blog.numino.net/
列名 类型 长 是否空 说明
ExYNPM http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
lO64tO http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
3C4aNg http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
4BkEfA http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
l8emkq http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
m62HMv http://blog.numino.net/
post_code nvarchar 6 1 --------1234
OJY7Bq http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
fCwhra http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
mpKXaK http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
EvWjbn http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
lqy6mD http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
CAyt8Z http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
tsg51A http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
EStxRo http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
iGoMjF http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
4RdACk http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
7uX996 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
p8Gnrt http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
9MxGXn http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
jEN6xi http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
SzIG7E http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
LezBWI http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
JeBsMn http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
eXIPu1 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
Jnk4dE http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
RUg6Qu http://blog.numino.net/
QX char 1 1 --------B
Vqe8Oy http://blog.numino.net/
JF int 4 0 --------0
47Dv3w http://blog.numino.net/
huiy int 4 1 --------0
5yXR9u http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
a523gB http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
UmsQnU http://blog.numino.net/
FDB int 4 1 --------0
ikWU91 http://blog.numino.net/
vip tinyint 1 1 --------0
C7VMn5 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
dS4qnA http://blog.numino.net/
4、MEMB_STAT
7w1x0H http://blog.numino.net/
列名 类型 长 是否空 说明
1cjqfJ http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
yK5abl http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
M4BC18 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
QGZwgr http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
6IXY3y http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
wqMa94 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
QZ9t51 http://blog.numino.net/
5、warehouse
IcBgf0 http://blog.numino.net/
列名 类型 长 是否空 说明
TeM9HZ http://blog.numino.net/
AccountID varchar 10 0 --------帐号
f7dU0j http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
K67st8 http://blog.numino.net/
Money int 4 1 --------钱
9Q185k http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
p17d9V http://blog.numino.net/
DbVersion tinyint 1 1 --------1
z3hm32 http://blog.numino.net/
pw smallint 2 1 --------密码 0
9uE35H http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
9gSUFT http://blog.numino.net/
ExtCKNum int 4 0 --------0
00Nj30 http://blog.numino.net/
NeedExtCK int 4 0 --------0
ybLwa6 http://blog.numino.net/
6、VI_CURR_INFO
7Xu1gC http://blog.numino.net/
列名 类型 长 是否空 说明
Cfzy00 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
6046rY http://blog.numino.net/
chek_code nvarchar 1 0 --------1
fiTx35 http://blog.numino.net/
used_time int 4 1 --------1234
6CbSj8 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
lli68L http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
N1zz39 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
I9tTz2 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
FNfZZW http://blog.numino.net/
Bill_Section int 4 1 --------6
OIu2e9 http://blog.numino.net/
Bill_Value int 4 1 --------3
3ETy91 http://blog.numino.net/
Bill_Hour int 4 1 --------0
Mi9K2D http://blog.numino.net/
Surplus_Point int 4 1 --------0
6HR1g8 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
7zduNE http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
Zj3852 http://blog.numino.net/
7、WEB_ZS
39S77r http://blog.numino.net/
列名 类型 长 是否空 说明
Amf0t7 http://blog.numino.net/
ID bigint 8 0
i8n4c1 http://blog.numino.net/
ACC char 10 1
Lr4x7p http://blog.numino.net/
NAME char 10 1
gBssMV http://blog.numino.net/
ZSTIME datetime 8 1
HuL5e3 http://blog.numino.net/
ZSCLEVEL smallint 2 1
Y73Fo2 http://blog.numino.net/
ZSCS smallint 2 0
jJyyRd http://blog.numino.net/
CZCS smallint 2 0
U598m3 http://blog.numino.net/
CZTIME datetime 8 0
1R727D http://blog.numino.net/
ZJZSCS smallint 2 0
YIEvaS http://blog.numino.net/
GJZSCS smallint 2 0
1oUq30 http://blog.numino.net/
CJZSCS smallint 2 0
T3T47n http://blog.numino.net/
BSCS smallint 2 0
iaCWfG http://blog.numino.net/
BSTIME datetime 8 0
se4TvR http://blog.numino.net/
LEVELUPPOINT int 4 0
w7DeE0 http://blog.numino.net/
GDDS int 4 0
|
|