| 奇迹muonline数据库基础库分析 |
一、表的组成：
bUUE1i http://blog.numino.net/
1、AccountCharacter
eHcriD http://blog.numino.net/
用来存放帐号的角色。
pcdU0s http://blog.numino.net/
2、Character
SHkVBf http://blog.numino.net/
用来存放每个角色的详细数据。
omuyut http://blog.numino.net/
3、MEMB_INFO
6PbE7i http://blog.numino.net/
帐号信息
ISlQ4U http://blog.numino.net/
4、MEMB_STAT
6JmKiV http://blog.numino.net/
帐号状态
E22pXu http://blog.numino.net/
5、warehouse
1gWLPS http://blog.numino.net/
仓库
NXtaFB http://blog.numino.net/
6、VI_CURR_INFO
RjRx86 http://blog.numino.net/
帐号费用
vlnh2c http://blog.numino.net/
7、WEB_ZS
nfhu31 http://blog.numino.net/
PL 网站的转生数据
27qGYb http://blog.numino.net/
二、各表说明
3Mo4oV http://blog.numino.net/
1、AccountCharacter 表
3OQ5cK http://blog.numino.net/
列名 类型 长 是否空 说明
QuvTC7 http://blog.numino.net/
Number int 4 0 自动增加的序数
c7Txf6 http://blog.numino.net/
Id varchar 10 0 帐号
HJsedE http://blog.numino.net/
GameID1 varchar 10 1 角色1
qCxvn5 http://blog.numino.net/
GameID2 varchar 10 1 角色2
ipryxy http://blog.numino.net/
GameID3 varchar 10 1
32jsri http://blog.numino.net/
GameID4 varchar 10 1
XjDH51 http://blog.numino.net/
GameID5 varchar 10 1
wT4W6x http://blog.numino.net/
GameIDC varchar 10 1
eM9QdM http://blog.numino.net/
2、Character 表
WS2rqY http://blog.numino.net/
列名 类型 长 是否空 说明
oz52CJ http://blog.numino.net/
AccountID varchar 10 0 --------帐号
4PYeCH http://blog.numino.net/
Name nvarchar 10 0 --------角色名
9KxzQK http://blog.numino.net/
cLevel smallint 2 1 --------等级
7s45Ls http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
k2P035 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
ihUiNW http://blog.numino.net/
Experience int 4 1 --------经验
5ksv19 http://blog.numino.net/
Strength smallint 2 1 --------力量
O1OmLF http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
20YrDN http://blog.numino.net/
Vitality smallint 2 1 --------体力
RhJqlc http://blog.numino.net/
Energy smallint 2 1 --------智力
ZAhf1G http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
w38BFW http://blog.numino.net/
MagicList varbinary 60 1 --------技能
JtToaU http://blog.numino.net/
Money int 4 1 --------钱
47JDcT http://blog.numino.net/
Life real 4 1 --------
URXmIo http://blog.numino.net/
MaxLife real 4 1 --------
Maz559 http://blog.numino.net/
Mana real 4 1 --------
kqfXZ2 http://blog.numino.net/
MaxMana real 4 1 --------
60qO32 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
LvE9rS http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
cDwxPx http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
3fi78M http://blog.numino.net/
MapDir tinyint 1 1 --------
wIOQw6 http://blog.numino.net/
PkCount int 4 1 --------
6KDnAM http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
2mllGs http://blog.numino.net/
PkTime int 4 1
jv9qm8 http://blog.numino.net/
MDate smalldatetime 4 1
ry3PwS http://blog.numino.net/
LDate smalldatetime 4 1
S1Vl49 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
M2v9wp http://blog.numino.net/
DbVersion tinyint 1 1
Jef8Bl http://blog.numino.net/
Quest varbinary 50 1
B0VC9r http://blog.numino.net/
LINZB bit 1 0
u5elqC http://blog.numino.net/
XDTIME datetime 8 0
VoPv4k http://blog.numino.net/
STOPINFO nvarchar 100 1
UyWkdo http://blog.numino.net/
STOPTIME datetime 8 0
lA6c3X http://blog.numino.net/
zs_count int 4 1
plpJTQ http://blog.numino.net/
zs_point int 4 1
uPaC4E http://blog.numino.net/
bs_count int 4 1
6HjmSp http://blog.numino.net/
bs_point int 4 1
ojUXxk http://blog.numino.net/
shiji smalldatetime 4 1
dYFV4r http://blog.numino.net/
banl nvarchar 10 1
zgwKO0 http://blog.numino.net/
lv_time datetime 8 1
9ie8Q2 http://blog.numino.net/
ex_ok int 4 1
UYCPLn http://blog.numino.net/
ex_total int 4 1
98TPku http://blog.numino.net/
rb_count int 4 1
93zQZz http://blog.numino.net/
rb_time datetime 8 1
ecYbXq http://blog.numino.net/
pz_time datetime 8 1
FiG4xF http://blog.numino.net/
3、MEMB_INFO
f0IQ9Y http://blog.numino.net/
列名 类型 长 是否空 说明
2l71B0 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
kPyNX5 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
2TBuuU http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
8bmYIc http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
VjQPh9 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
Dw48U6 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
hh29T8 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
0TgXt4 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
WVfcrn http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
76R95f http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
p41DTB http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
5LVJdO http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
FYK05g http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
33cH98 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
Kdx87S http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
2dVawk http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
NC2he3 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
JLmZqx http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
0q43P5 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
yE5HJo http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
t5LvQb http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
PrULTn http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
uqR6BR http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
tFzMK0 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
DYQo0D http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
WFb2wK http://blog.numino.net/
QX char 1 1 --------B
1F5dcF http://blog.numino.net/
JF int 4 0 --------0
5AWHY5 http://blog.numino.net/
huiy int 4 1 --------0
ychW9I http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
V4170U http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
4P6xj3 http://blog.numino.net/
FDB int 4 1 --------0
28lz4v http://blog.numino.net/
vip tinyint 1 1 --------0
62Aby6 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
7iLX5p http://blog.numino.net/
4、MEMB_STAT
wHn52b http://blog.numino.net/
列名 类型 长 是否空 说明
xeX76P http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
3231Gs http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
Zba311 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
fzAi86 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
jTmcw0 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
4CO7i4 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
BgGWfr http://blog.numino.net/
5、warehouse
YxJO0q http://blog.numino.net/
列名 类型 长 是否空 说明
LfOi19 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
V46U0S http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
rzjAw8 http://blog.numino.net/
Money int 4 1 --------钱
dG67fs http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
lhxF9I http://blog.numino.net/
DbVersion tinyint 1 1 --------1
ktx8h9 http://blog.numino.net/
pw smallint 2 1 --------密码 0
z4SH2F http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
RRq9hK http://blog.numino.net/
ExtCKNum int 4 0 --------0
akMzeX http://blog.numino.net/
NeedExtCK int 4 0 --------0
fXdPV2 http://blog.numino.net/
6、VI_CURR_INFO
q9l2wE http://blog.numino.net/
列名 类型 长 是否空 说明
Nc99nm http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
9uXD0D http://blog.numino.net/
chek_code nvarchar 1 0 --------1
0k5377 http://blog.numino.net/
used_time int 4 1 --------1234
PK2RaB http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
e5M9VX http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
J2dBJ6 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
2ko4o3 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
itNO7t http://blog.numino.net/
Bill_Section int 4 1 --------6
sW8hWm http://blog.numino.net/
Bill_Value int 4 1 --------3
Yd56SW http://blog.numino.net/
Bill_Hour int 4 1 --------0
L13L63 http://blog.numino.net/
Surplus_Point int 4 1 --------0
UWzilT http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
wq0qlR http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
YWreV0 http://blog.numino.net/
7、WEB_ZS
BckqLb http://blog.numino.net/
列名 类型 长 是否空 说明
YQl4mY http://blog.numino.net/
ID bigint 8 0
LVE45a http://blog.numino.net/
ACC char 10 1
AcO36V http://blog.numino.net/
NAME char 10 1
Zx3WAX http://blog.numino.net/
ZSTIME datetime 8 1
HI8G8B http://blog.numino.net/
ZSCLEVEL smallint 2 1
H6fo50 http://blog.numino.net/
ZSCS smallint 2 0
9dISHy http://blog.numino.net/
CZCS smallint 2 0
R8Y5dW http://blog.numino.net/
CZTIME datetime 8 0
I0wqO4 http://blog.numino.net/
ZJZSCS smallint 2 0
qsQ0T2 http://blog.numino.net/
GJZSCS smallint 2 0
TAdveP http://blog.numino.net/
CJZSCS smallint 2 0
fEFxLo http://blog.numino.net/
BSCS smallint 2 0
8xie8M http://blog.numino.net/
BSTIME datetime 8 0
PkVICM http://blog.numino.net/
LEVELUPPOINT int 4 0
mCtzzn http://blog.numino.net/
GDDS int 4 0
|
|