| 奇迹muonline数据库基础库分析 |
一、表的组成：
1Sv6Xp http://blog.numino.net/
1、AccountCharacter
Nk0Mwg http://blog.numino.net/
用来存放帐号的角色。
iHHfhS http://blog.numino.net/
2、Character
L3O9YM http://blog.numino.net/
用来存放每个角色的详细数据。
484H9b http://blog.numino.net/
3、MEMB_INFO
IJT53t http://blog.numino.net/
帐号信息
RZHM6h http://blog.numino.net/
4、MEMB_STAT
2uNZM2 http://blog.numino.net/
帐号状态
p3t036 http://blog.numino.net/
5、warehouse
07UbXL http://blog.numino.net/
仓库
3rNM34 http://blog.numino.net/
6、VI_CURR_INFO
GgpjBw http://blog.numino.net/
帐号费用
Ftld9f http://blog.numino.net/
7、WEB_ZS
10xRX1 http://blog.numino.net/
PL 网站的转生数据
8Q3w0E http://blog.numino.net/
二、各表说明
msALXO http://blog.numino.net/
1、AccountCharacter 表
DJ9W7b http://blog.numino.net/
列名 类型 长 是否空 说明
r09nn7 http://blog.numino.net/
Number int 4 0 自动增加的序数
3u1TmM http://blog.numino.net/
Id varchar 10 0 帐号
ddQha5 http://blog.numino.net/
GameID1 varchar 10 1 角色1
45125H http://blog.numino.net/
GameID2 varchar 10 1 角色2
1ukY2d http://blog.numino.net/
GameID3 varchar 10 1
1FajvT http://blog.numino.net/
GameID4 varchar 10 1
6Y52Pm http://blog.numino.net/
GameID5 varchar 10 1
F2ZAXE http://blog.numino.net/
GameIDC varchar 10 1
H3uyua http://blog.numino.net/
2、Character 表
J88Nf9 http://blog.numino.net/
列名 类型 长 是否空 说明
IOuCcl http://blog.numino.net/
AccountID varchar 10 0 --------帐号
3bv46F http://blog.numino.net/
Name nvarchar 10 0 --------角色名
fsD5Vd http://blog.numino.net/
cLevel smallint 2 1 --------等级
R924cC http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
2u227m http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
dUB3UD http://blog.numino.net/
Experience int 4 1 --------经验
WAP38c http://blog.numino.net/
Strength smallint 2 1 --------力量
t18R7D http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
MuNFTJ http://blog.numino.net/
Vitality smallint 2 1 --------体力
09I51u http://blog.numino.net/
Energy smallint 2 1 --------智力
Dz3dKE http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
TnjNB7 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
4qd8B4 http://blog.numino.net/
Money int 4 1 --------钱
xG5g6v http://blog.numino.net/
Life real 4 1 --------
hYB5c1 http://blog.numino.net/
MaxLife real 4 1 --------
ixt4LK http://blog.numino.net/
Mana real 4 1 --------
8RA1jC http://blog.numino.net/
MaxMana real 4 1 --------
O79qM2 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
7WM7Kz http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
o13M7e http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
YwFeix http://blog.numino.net/
MapDir tinyint 1 1 --------
Xd8FGH http://blog.numino.net/
PkCount int 4 1 --------
YlnuG8 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
1rrZWu http://blog.numino.net/
PkTime int 4 1
s5YfF1 http://blog.numino.net/
MDate smalldatetime 4 1
6e6FvO http://blog.numino.net/
LDate smalldatetime 4 1
wW33Lr http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
fYVR7o http://blog.numino.net/
DbVersion tinyint 1 1
A13GZd http://blog.numino.net/
Quest varbinary 50 1
TMRLGG http://blog.numino.net/
LINZB bit 1 0
X5UG58 http://blog.numino.net/
XDTIME datetime 8 0
kKA50V http://blog.numino.net/
STOPINFO nvarchar 100 1
5XpfG0 http://blog.numino.net/
STOPTIME datetime 8 0
m515Ao http://blog.numino.net/
zs_count int 4 1
hM6Q2u http://blog.numino.net/
zs_point int 4 1
Wq4Npn http://blog.numino.net/
bs_count int 4 1
K7N0vt http://blog.numino.net/
bs_point int 4 1
UyKwgm http://blog.numino.net/
shiji smalldatetime 4 1
yff9bV http://blog.numino.net/
banl nvarchar 10 1
0gu5sM http://blog.numino.net/
lv_time datetime 8 1
g9TESo http://blog.numino.net/
ex_ok int 4 1
t08nF3 http://blog.numino.net/
ex_total int 4 1
e8xTJY http://blog.numino.net/
rb_count int 4 1
WnXKwr http://blog.numino.net/
rb_time datetime 8 1
ScMdNY http://blog.numino.net/
pz_time datetime 8 1
kh4hS6 http://blog.numino.net/
3、MEMB_INFO
PH1F3I http://blog.numino.net/
列名 类型 长 是否空 说明
MNV3Z7 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
B9mzAv http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
YPaWl0 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
Qxbk2D http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
19xtyx http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
s8I5p8 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
dqb6Eq http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
cEs2J8 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
281ZpF http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
FFd7vh http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
8OkKTD http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
37qH1J http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
fdOIW4 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
fxYb6Y http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
z5p3O8 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
lw4Bec http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
10miuF http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Rh3DH8 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
90YPGY http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
xx7owr http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
MZNTT2 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
K8411c http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
Rj1Xor http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
DRG6O9 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
kxX44D http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
9fEpzi http://blog.numino.net/
QX char 1 1 --------B
D8R6Ft http://blog.numino.net/
JF int 4 0 --------0
wr0Hen http://blog.numino.net/
huiy int 4 1 --------0
ai7i33 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
b4oh13 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
c3p4Jv http://blog.numino.net/
FDB int 4 1 --------0
0C1Ixr http://blog.numino.net/
vip tinyint 1 1 --------0
l9i00w http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
MhxNyk http://blog.numino.net/
4、MEMB_STAT
S8fZ0X http://blog.numino.net/
列名 类型 长 是否空 说明
Y3nvq9 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Qq3bGA http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
9bRqhE http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
oy04u8 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
LN9GUE http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
yrtJTI http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
yBd2gJ http://blog.numino.net/
5、warehouse
2uURbe http://blog.numino.net/
列名 类型 长 是否空 说明
nSckJ0 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
m4kl44 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
3vIg36 http://blog.numino.net/
Money int 4 1 --------钱
KXoq4u http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
a7vpjk http://blog.numino.net/
DbVersion tinyint 1 1 --------1
SZfgfc http://blog.numino.net/
pw smallint 2 1 --------密码 0
KDEght http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
CYO4c4 http://blog.numino.net/
ExtCKNum int 4 0 --------0
6pJs3Q http://blog.numino.net/
NeedExtCK int 4 0 --------0
jf5fn6 http://blog.numino.net/
6、VI_CURR_INFO
A5DFY8 http://blog.numino.net/
列名 类型 长 是否空 说明
1v0y10 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
wOhL23 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
6bwqgt http://blog.numino.net/
used_time int 4 1 --------1234
Uc6Z8B http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
fg4Z50 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
hDHdPP http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
XTJhDr http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
brhjEj http://blog.numino.net/
Bill_Section int 4 1 --------6
R9mV8i http://blog.numino.net/
Bill_Value int 4 1 --------3
gyI25y http://blog.numino.net/
Bill_Hour int 4 1 --------0
I7wpTn http://blog.numino.net/
Surplus_Point int 4 1 --------0
k2zU3d http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
D042Zw http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
gV686h http://blog.numino.net/
7、WEB_ZS
6hCTou http://blog.numino.net/
列名 类型 长 是否空 说明
4ln84K http://blog.numino.net/
ID bigint 8 0
JWxn64 http://blog.numino.net/
ACC char 10 1
LEJYbf http://blog.numino.net/
NAME char 10 1
8V5tA3 http://blog.numino.net/
ZSTIME datetime 8 1
COIRbl http://blog.numino.net/
ZSCLEVEL smallint 2 1
XEmU5t http://blog.numino.net/
ZSCS smallint 2 0
EKZ45W http://blog.numino.net/
CZCS smallint 2 0
5RA9hB http://blog.numino.net/
CZTIME datetime 8 0
1mZHF5 http://blog.numino.net/
ZJZSCS smallint 2 0
4x83Si http://blog.numino.net/
GJZSCS smallint 2 0
MN9Z7p http://blog.numino.net/
CJZSCS smallint 2 0
G2Owm5 http://blog.numino.net/
BSCS smallint 2 0
3OapL4 http://blog.numino.net/
BSTIME datetime 8 0
OT0FdH http://blog.numino.net/
LEVELUPPOINT int 4 0
FqDGCg http://blog.numino.net/
GDDS int 4 0
|
|