| 奇迹muonline数据库基础库分析 |
一、表的组成：
JKkjsg http://blog.numino.net/
1、AccountCharacter
IZbQs8 http://blog.numino.net/
用来存放帐号的角色。
aMu95Z http://blog.numino.net/
2、Character
kHZ0Zt http://blog.numino.net/
用来存放每个角色的详细数据。
bZQTp0 http://blog.numino.net/
3、MEMB_INFO
euR3MK http://blog.numino.net/
帐号信息
o9Ed3P http://blog.numino.net/
4、MEMB_STAT
qungTz http://blog.numino.net/
帐号状态
fZ9Qcl http://blog.numino.net/
5、warehouse
3zB9cl http://blog.numino.net/
仓库
DNheg4 http://blog.numino.net/
6、VI_CURR_INFO
J4MBM7 http://blog.numino.net/
帐号费用
24z2md http://blog.numino.net/
7、WEB_ZS
opcojp http://blog.numino.net/
PL 网站的转生数据
XFCykp http://blog.numino.net/
二、各表说明
O3lI7d http://blog.numino.net/
1、AccountCharacter 表
H4wmFh http://blog.numino.net/
列名 类型 长 是否空 说明
25M2F7 http://blog.numino.net/
Number int 4 0 自动增加的序数
P5Q1C6 http://blog.numino.net/
Id varchar 10 0 帐号
2m5nq4 http://blog.numino.net/
GameID1 varchar 10 1 角色1
8hdVbW http://blog.numino.net/
GameID2 varchar 10 1 角色2
PvVofa http://blog.numino.net/
GameID3 varchar 10 1
n75mBe http://blog.numino.net/
GameID4 varchar 10 1
wcW4RR http://blog.numino.net/
GameID5 varchar 10 1
ev8ibO http://blog.numino.net/
GameIDC varchar 10 1
KwY7Fa http://blog.numino.net/
2、Character 表
XQ6ElZ http://blog.numino.net/
列名 类型 长 是否空 说明
p5As1N http://blog.numino.net/
AccountID varchar 10 0 --------帐号
YkLiGp http://blog.numino.net/
Name nvarchar 10 0 --------角色名
YA04di http://blog.numino.net/
cLevel smallint 2 1 --------等级
F16zFR http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
0dyFw8 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
0OU7hI http://blog.numino.net/
Experience int 4 1 --------经验
3buH6n http://blog.numino.net/
Strength smallint 2 1 --------力量
7RcpYc http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
5M5i7l http://blog.numino.net/
Vitality smallint 2 1 --------体力
wU8KyC http://blog.numino.net/
Energy smallint 2 1 --------智力
M9ChWV http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
2jp08A http://blog.numino.net/
MagicList varbinary 60 1 --------技能
kob6DF http://blog.numino.net/
Money int 4 1 --------钱
xlB97Z http://blog.numino.net/
Life real 4 1 --------
cpsR2D http://blog.numino.net/
MaxLife real 4 1 --------
15uLvM http://blog.numino.net/
Mana real 4 1 --------
k38FuS http://blog.numino.net/
MaxMana real 4 1 --------
kgFn1v http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
FOsTri http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
zWsdN6 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
shgD5r http://blog.numino.net/
MapDir tinyint 1 1 --------
lSEa7w http://blog.numino.net/
PkCount int 4 1 --------
NP78Ky http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
6fRVE1 http://blog.numino.net/
PkTime int 4 1
Fl08em http://blog.numino.net/
MDate smalldatetime 4 1
XMu1Yn http://blog.numino.net/
LDate smalldatetime 4 1
cluHwv http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
2FLJ1p http://blog.numino.net/
DbVersion tinyint 1 1
U5g7o5 http://blog.numino.net/
Quest varbinary 50 1
t0S2VU http://blog.numino.net/
LINZB bit 1 0
cz2rVE http://blog.numino.net/
XDTIME datetime 8 0
Az18dB http://blog.numino.net/
STOPINFO nvarchar 100 1
wlhBXq http://blog.numino.net/
STOPTIME datetime 8 0
p0Sal2 http://blog.numino.net/
zs_count int 4 1
qggAVy http://blog.numino.net/
zs_point int 4 1
Uww8L7 http://blog.numino.net/
bs_count int 4 1
ZPLm0t http://blog.numino.net/
bs_point int 4 1
5fbev0 http://blog.numino.net/
shiji smalldatetime 4 1
jDl2tv http://blog.numino.net/
banl nvarchar 10 1
HGyhlL http://blog.numino.net/
lv_time datetime 8 1
T1cXJ8 http://blog.numino.net/
ex_ok int 4 1
qi4ibl http://blog.numino.net/
ex_total int 4 1
HxLIwJ http://blog.numino.net/
rb_count int 4 1
20d09e http://blog.numino.net/
rb_time datetime 8 1
yKL8pW http://blog.numino.net/
pz_time datetime 8 1
e2uVxM http://blog.numino.net/
3、MEMB_INFO
L63NsA http://blog.numino.net/
列名 类型 长 是否空 说明
4eAZnr http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
O1MNdr http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
YqP5oc http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
OOjQHw http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
Z4rM1z http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
64Besb http://blog.numino.net/
post_code nvarchar 6 1 --------1234
Cs26Kc http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
80DRLA http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
rRCE76 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
SimodC http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
Lbbck5 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
5U71bV http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
AUwj8U http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
CR0xBa http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
Ov690C http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
Byb156 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
auzUDT http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
hs9F4J http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
9X3ub2 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
yg8x5n http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
nhnezi http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
42vGDx http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
zHsutB http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
pagIKm http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
O38Nd3 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
kd06af http://blog.numino.net/
QX char 1 1 --------B
j1498E http://blog.numino.net/
JF int 4 0 --------0
Rwnjkh http://blog.numino.net/
huiy int 4 1 --------0
y7K61Q http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
r8859y http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
p9RICM http://blog.numino.net/
FDB int 4 1 --------0
cRCk6o http://blog.numino.net/
vip tinyint 1 1 --------0
NxLaqZ http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
9tNe7o http://blog.numino.net/
4、MEMB_STAT
AyjBn0 http://blog.numino.net/
列名 类型 长 是否空 说明
17EYHR http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
mG1t0O http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
uZm70h http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
909w6k http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
50J2Uk http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
P4J3Kn http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
T958RR http://blog.numino.net/
5、warehouse
1FEAw4 http://blog.numino.net/
列名 类型 长 是否空 说明
1pwoha http://blog.numino.net/
AccountID varchar 10 0 --------帐号
M4RYEb http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
r3wByp http://blog.numino.net/
Money int 4 1 --------钱
2Z9XnE http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
6wfuGH http://blog.numino.net/
DbVersion tinyint 1 1 --------1
cOUKD8 http://blog.numino.net/
pw smallint 2 1 --------密码 0
Dz49w1 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
6X48nx http://blog.numino.net/
ExtCKNum int 4 0 --------0
e2AC0A http://blog.numino.net/
NeedExtCK int 4 0 --------0
9yRh1o http://blog.numino.net/
6、VI_CURR_INFO
ACe51M http://blog.numino.net/
列名 类型 长 是否空 说明
cXZGXE http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
9wq4jA http://blog.numino.net/
chek_code nvarchar 1 0 --------1
RAC1a9 http://blog.numino.net/
used_time int 4 1 --------1234
3v5w1U http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
9wUz86 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
1T7I7M http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
945w2h http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
c2SJmU http://blog.numino.net/
Bill_Section int 4 1 --------6
CEncwj http://blog.numino.net/
Bill_Value int 4 1 --------3
xJ0HN0 http://blog.numino.net/
Bill_Hour int 4 1 --------0
TugBs1 http://blog.numino.net/
Surplus_Point int 4 1 --------0
4Q87SJ http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
0v4J66 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
qcjvdI http://blog.numino.net/
7、WEB_ZS
Qc8eP9 http://blog.numino.net/
列名 类型 长 是否空 说明
2jhi1l http://blog.numino.net/
ID bigint 8 0
14KMDp http://blog.numino.net/
ACC char 10 1
3vFeB9 http://blog.numino.net/
NAME char 10 1
D6ZJ8a http://blog.numino.net/
ZSTIME datetime 8 1
br04xb http://blog.numino.net/
ZSCLEVEL smallint 2 1
jj42Fp http://blog.numino.net/
ZSCS smallint 2 0
2lF1yg http://blog.numino.net/
CZCS smallint 2 0
ufawSj http://blog.numino.net/
CZTIME datetime 8 0
k1zd9I http://blog.numino.net/
ZJZSCS smallint 2 0
9d6o1U http://blog.numino.net/
GJZSCS smallint 2 0
aaHfbK http://blog.numino.net/
CJZSCS smallint 2 0
R848EH http://blog.numino.net/
BSCS smallint 2 0
vQ6wr9 http://blog.numino.net/
BSTIME datetime 8 0
Pkkkaf http://blog.numino.net/
LEVELUPPOINT int 4 0
AM7hdR http://blog.numino.net/
GDDS int 4 0
|
|