| 奇迹muonline数据库基础库分析 |
一、表的组成：
d7Xflo http://blog.numino.net/
1、AccountCharacter
Gk13le http://blog.numino.net/
用来存放帐号的角色。
nIMrE1 http://blog.numino.net/
2、Character
yK41Pg http://blog.numino.net/
用来存放每个角色的详细数据。
fT7ziB http://blog.numino.net/
3、MEMB_INFO
4VHQlv http://blog.numino.net/
帐号信息
F8e0MM http://blog.numino.net/
4、MEMB_STAT
9uT44B http://blog.numino.net/
帐号状态
8J9Si1 http://blog.numino.net/
5、warehouse
YS1OuA http://blog.numino.net/
仓库
C3IFZj http://blog.numino.net/
6、VI_CURR_INFO
8gJPLx http://blog.numino.net/
帐号费用
BlC050 http://blog.numino.net/
7、WEB_ZS
dKjxL1 http://blog.numino.net/
PL 网站的转生数据
ACFIIq http://blog.numino.net/
二、各表说明
wb7gLw http://blog.numino.net/
1、AccountCharacter 表
v1KX36 http://blog.numino.net/
列名 类型 长 是否空 说明
qSjuj0 http://blog.numino.net/
Number int 4 0 自动增加的序数
l80C9C http://blog.numino.net/
Id varchar 10 0 帐号
h4nL1F http://blog.numino.net/
GameID1 varchar 10 1 角色1
Qt8Hcp http://blog.numino.net/
GameID2 varchar 10 1 角色2
p83M6b http://blog.numino.net/
GameID3 varchar 10 1
G4R4Uy http://blog.numino.net/
GameID4 varchar 10 1
N33fNz http://blog.numino.net/
GameID5 varchar 10 1
W1rOyY http://blog.numino.net/
GameIDC varchar 10 1
JvPw8T http://blog.numino.net/
2、Character 表
Wr9Jc0 http://blog.numino.net/
列名 类型 长 是否空 说明
C1GnzG http://blog.numino.net/
AccountID varchar 10 0 --------帐号
ZfZf8t http://blog.numino.net/
Name nvarchar 10 0 --------角色名
ElBBQb http://blog.numino.net/
cLevel smallint 2 1 --------等级
Ws6CI3 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
na8mC1 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
G4J7mq http://blog.numino.net/
Experience int 4 1 --------经验
34JrMb http://blog.numino.net/
Strength smallint 2 1 --------力量
FF00w4 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
6kixta http://blog.numino.net/
Vitality smallint 2 1 --------体力
XH2AbX http://blog.numino.net/
Energy smallint 2 1 --------智力
3S5518 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
IQWd3N http://blog.numino.net/
MagicList varbinary 60 1 --------技能
zVLHzh http://blog.numino.net/
Money int 4 1 --------钱
i4e9xZ http://blog.numino.net/
Life real 4 1 --------
GKTD8v http://blog.numino.net/
MaxLife real 4 1 --------
0DSHbm http://blog.numino.net/
Mana real 4 1 --------
0PyVjs http://blog.numino.net/
MaxMana real 4 1 --------
7Re9p5 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
o2MFxH http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
OPXj40 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
kGmnNs http://blog.numino.net/
MapDir tinyint 1 1 --------
kfD1gP http://blog.numino.net/
PkCount int 4 1 --------
BW02dY http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
o203oR http://blog.numino.net/
PkTime int 4 1
7ZyZLn http://blog.numino.net/
MDate smalldatetime 4 1
0ktTgX http://blog.numino.net/
LDate smalldatetime 4 1
cY74Iu http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
5ufpUB http://blog.numino.net/
DbVersion tinyint 1 1
c67b3Z http://blog.numino.net/
Quest varbinary 50 1
YPb3cE http://blog.numino.net/
LINZB bit 1 0
4WcbQ9 http://blog.numino.net/
XDTIME datetime 8 0
V98I7W http://blog.numino.net/
STOPINFO nvarchar 100 1
IH7AQQ http://blog.numino.net/
STOPTIME datetime 8 0
alBP6K http://blog.numino.net/
zs_count int 4 1
f85yrE http://blog.numino.net/
zs_point int 4 1
H25rfA http://blog.numino.net/
bs_count int 4 1
HuR1Bj http://blog.numino.net/
bs_point int 4 1
97LlVt http://blog.numino.net/
shiji smalldatetime 4 1
lyN4jZ http://blog.numino.net/
banl nvarchar 10 1
Nr58ka http://blog.numino.net/
lv_time datetime 8 1
k70hDb http://blog.numino.net/
ex_ok int 4 1
QCXWBf http://blog.numino.net/
ex_total int 4 1
UuVQkg http://blog.numino.net/
rb_count int 4 1
OAb8qh http://blog.numino.net/
rb_time datetime 8 1
h3aZtC http://blog.numino.net/
pz_time datetime 8 1
2XD7P0 http://blog.numino.net/
3、MEMB_INFO
2zC8lK http://blog.numino.net/
列名 类型 长 是否空 说明
OOyHAX http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
mNXRJf http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
JZY0RD http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
ZxUHjx http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
cz9m82 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
C49TBN http://blog.numino.net/
post_code nvarchar 6 1 --------1234
dup8sY http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
M4IQ11 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
M8PC8e http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
741sfN http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
Rcs5h8 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
jEcL3U http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
nPDo29 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
zYwtCA http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
yblBkc http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
e108zF http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
bLhbQP http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Fr6UIB http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
3ufXSL http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
kpy9Ck http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
2cRGFO http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
qa4924 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
BZ6X6x http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
aqb5Ue http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
6CdBH9 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
pq6Q66 http://blog.numino.net/
QX char 1 1 --------B
pZ0Ef0 http://blog.numino.net/
JF int 4 0 --------0
mQVeT6 http://blog.numino.net/
huiy int 4 1 --------0
0020bk http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
vobGZh http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
FYJgE3 http://blog.numino.net/
FDB int 4 1 --------0
o7BmXL http://blog.numino.net/
vip tinyint 1 1 --------0
jCP2VQ http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
eBfXa7 http://blog.numino.net/
4、MEMB_STAT
f4z4LN http://blog.numino.net/
列名 类型 长 是否空 说明
SHp54m http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
SO07wW http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
tEEOYH http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
f31m7P http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
6GB7s7 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
fPrCP6 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
42aP66 http://blog.numino.net/
5、warehouse
zO21N4 http://blog.numino.net/
列名 类型 长 是否空 说明
E9BiIT http://blog.numino.net/
AccountID varchar 10 0 --------帐号
FG11P9 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
gN66ES http://blog.numino.net/
Money int 4 1 --------钱
8bS93H http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
bc2910 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
2NpqXU http://blog.numino.net/
pw smallint 2 1 --------密码 0
X1LAPI http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
etFhr0 http://blog.numino.net/
ExtCKNum int 4 0 --------0
8mc6Q6 http://blog.numino.net/
NeedExtCK int 4 0 --------0
qVn8qw http://blog.numino.net/
6、VI_CURR_INFO
3nO9bh http://blog.numino.net/
列名 类型 长 是否空 说明
Fkor05 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
b8qMPq http://blog.numino.net/
chek_code nvarchar 1 0 --------1
iGtuEA http://blog.numino.net/
used_time int 4 1 --------1234
D88f6P http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
GC7aUZ http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
GI42iX http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
03Eq5j http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
7L6Np2 http://blog.numino.net/
Bill_Section int 4 1 --------6
039jl6 http://blog.numino.net/
Bill_Value int 4 1 --------3
fWC2SR http://blog.numino.net/
Bill_Hour int 4 1 --------0
ka6A3H http://blog.numino.net/
Surplus_Point int 4 1 --------0
dE14AO http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
wa0Ckt http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
6Rh1K9 http://blog.numino.net/
7、WEB_ZS
l2Xa9N http://blog.numino.net/
列名 类型 长 是否空 说明
kJf6nw http://blog.numino.net/
ID bigint 8 0
8PHG7u http://blog.numino.net/
ACC char 10 1
7fkP3G http://blog.numino.net/
NAME char 10 1
UrCiQ8 http://blog.numino.net/
ZSTIME datetime 8 1
7aE46H http://blog.numino.net/
ZSCLEVEL smallint 2 1
DLzd6a http://blog.numino.net/
ZSCS smallint 2 0
pq1K05 http://blog.numino.net/
CZCS smallint 2 0
lowYz9 http://blog.numino.net/
CZTIME datetime 8 0
W4SwfA http://blog.numino.net/
ZJZSCS smallint 2 0
iAi63I http://blog.numino.net/
GJZSCS smallint 2 0
V6OaOe http://blog.numino.net/
CJZSCS smallint 2 0
UoyHev http://blog.numino.net/
BSCS smallint 2 0
r1i3M1 http://blog.numino.net/
BSTIME datetime 8 0
7mV3pU http://blog.numino.net/
LEVELUPPOINT int 4 0
m9ghlq http://blog.numino.net/
GDDS int 4 0
|
|