| 奇迹muonline数据库基础库分析 |
一、表的组成：
WrO0tZ http://blog.numino.net/
1、AccountCharacter
42WrXS http://blog.numino.net/
用来存放帐号的角色。
Hw3sTq http://blog.numino.net/
2、Character
192ey5 http://blog.numino.net/
用来存放每个角色的详细数据。
O5lQ8i http://blog.numino.net/
3、MEMB_INFO
hE52eJ http://blog.numino.net/
帐号信息
4zZ4xv http://blog.numino.net/
4、MEMB_STAT
l0XzVF http://blog.numino.net/
帐号状态
cS43mG http://blog.numino.net/
5、warehouse
BNTq3A http://blog.numino.net/
仓库
6QMVJ7 http://blog.numino.net/
6、VI_CURR_INFO
WHSoqh http://blog.numino.net/
帐号费用
7h39I0 http://blog.numino.net/
7、WEB_ZS
N2HVeS http://blog.numino.net/
PL 网站的转生数据
34b3FA http://blog.numino.net/
二、各表说明
7M4FDc http://blog.numino.net/
1、AccountCharacter 表
3S7v7a http://blog.numino.net/
列名 类型 长 是否空 说明
Mc4JG0 http://blog.numino.net/
Number int 4 0 自动增加的序数
E5tSEk http://blog.numino.net/
Id varchar 10 0 帐号
Q6BroY http://blog.numino.net/
GameID1 varchar 10 1 角色1
f4dBY5 http://blog.numino.net/
GameID2 varchar 10 1 角色2
FqiIZg http://blog.numino.net/
GameID3 varchar 10 1
9ZYJ08 http://blog.numino.net/
GameID4 varchar 10 1
G2h9F8 http://blog.numino.net/
GameID5 varchar 10 1
HUvrzk http://blog.numino.net/
GameIDC varchar 10 1
374GTv http://blog.numino.net/
2、Character 表
BDmLSh http://blog.numino.net/
列名 类型 长 是否空 说明
gr36G3 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
1HX60a http://blog.numino.net/
Name nvarchar 10 0 --------角色名
hEXAnp http://blog.numino.net/
cLevel smallint 2 1 --------等级
e3N1bW http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
N2JfT5 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
F0Ov9S http://blog.numino.net/
Experience int 4 1 --------经验
u7hcOv http://blog.numino.net/
Strength smallint 2 1 --------力量
ymdLIf http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
UgTfXT http://blog.numino.net/
Vitality smallint 2 1 --------体力
5b2Vhw http://blog.numino.net/
Energy smallint 2 1 --------智力
aJ7T7j http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
YK0spa http://blog.numino.net/
MagicList varbinary 60 1 --------技能
Cd73ao http://blog.numino.net/
Money int 4 1 --------钱
Dk8gKm http://blog.numino.net/
Life real 4 1 --------
WLNn6x http://blog.numino.net/
MaxLife real 4 1 --------
LPO567 http://blog.numino.net/
Mana real 4 1 --------
W0I20K http://blog.numino.net/
MaxMana real 4 1 --------
AY3WR3 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
Xgp65M http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
kEqN52 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
QOSZw4 http://blog.numino.net/
MapDir tinyint 1 1 --------
0zW7cZ http://blog.numino.net/
PkCount int 4 1 --------
lErxMJ http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
2DW4k1 http://blog.numino.net/
PkTime int 4 1
g5g6Pv http://blog.numino.net/
MDate smalldatetime 4 1
cW50Az http://blog.numino.net/
LDate smalldatetime 4 1
G4huHk http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
bz8h5j http://blog.numino.net/
DbVersion tinyint 1 1
uKMBQR http://blog.numino.net/
Quest varbinary 50 1
Wkh4Ub http://blog.numino.net/
LINZB bit 1 0
9nC1LJ http://blog.numino.net/
XDTIME datetime 8 0
dnyOX0 http://blog.numino.net/
STOPINFO nvarchar 100 1
nXJ763 http://blog.numino.net/
STOPTIME datetime 8 0
6a12a4 http://blog.numino.net/
zs_count int 4 1
9BUZxn http://blog.numino.net/
zs_point int 4 1
Ruo851 http://blog.numino.net/
bs_count int 4 1
17j4Th http://blog.numino.net/
bs_point int 4 1
8jBC5x http://blog.numino.net/
shiji smalldatetime 4 1
CFv6jL http://blog.numino.net/
banl nvarchar 10 1
ZjW4Zj http://blog.numino.net/
lv_time datetime 8 1
qT736K http://blog.numino.net/
ex_ok int 4 1
C4Jov6 http://blog.numino.net/
ex_total int 4 1
U3C6xL http://blog.numino.net/
rb_count int 4 1
Fms3ln http://blog.numino.net/
rb_time datetime 8 1
9YbfWQ http://blog.numino.net/
pz_time datetime 8 1
CUkrL2 http://blog.numino.net/
3、MEMB_INFO
xs2KBX http://blog.numino.net/
列名 类型 长 是否空 说明
5zH7y6 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
1Q2Rwm http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
R1g76S http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
rUWcdB http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
cm2Zjv http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
PRJsj8 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
403HL0 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
27BoB7 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
qC0p0T http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
Hk8Cr8 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
MRJ6M7 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
llFn20 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
SEBBJ9 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
mXvHo9 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
X9C8Lk http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
3iL9iQ http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
L8ioUK http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
0LkgK3 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
DADW23 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
L2yA17 http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
iRhdDa http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
rTggsb http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
a3tp6L http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
x2KQOJ http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
i5Lw2K http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
kE1i24 http://blog.numino.net/
QX char 1 1 --------B
8Z5wSF http://blog.numino.net/
JF int 4 0 --------0
Q3vM8u http://blog.numino.net/
huiy int 4 1 --------0
06j4YV http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
K1Qg1F http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
UH8yGv http://blog.numino.net/
FDB int 4 1 --------0
uMQp6T http://blog.numino.net/
vip tinyint 1 1 --------0
2UM34N http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
e42o02 http://blog.numino.net/
4、MEMB_STAT
56pBbl http://blog.numino.net/
列名 类型 长 是否空 说明
c3X0N8 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
64WN0I http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
0Zj7T7 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
v9F882 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
LA01Y5 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
sVAqKP http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
JDyIpP http://blog.numino.net/
5、warehouse
3fRI2j http://blog.numino.net/
列名 类型 长 是否空 说明
YSOL9C http://blog.numino.net/
AccountID varchar 10 0 --------帐号
XLoAhH http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
ABr827 http://blog.numino.net/
Money int 4 1 --------钱
VQQJUl http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
S6nO3P http://blog.numino.net/
DbVersion tinyint 1 1 --------1
E5Sinx http://blog.numino.net/
pw smallint 2 1 --------密码 0
dylMNa http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
C2QH5R http://blog.numino.net/
ExtCKNum int 4 0 --------0
27Kesv http://blog.numino.net/
NeedExtCK int 4 0 --------0
0oPGjn http://blog.numino.net/
6、VI_CURR_INFO
R5z3lj http://blog.numino.net/
列名 类型 长 是否空 说明
Oq8Ffo http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
l28IQU http://blog.numino.net/
chek_code nvarchar 1 0 --------1
68qnwq http://blog.numino.net/
used_time int 4 1 --------1234
EaeIy8 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
9J2YIw http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
B9S70z http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
65a0o3 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
sf34lk http://blog.numino.net/
Bill_Section int 4 1 --------6
9OlZr8 http://blog.numino.net/
Bill_Value int 4 1 --------3
o6VGGm http://blog.numino.net/
Bill_Hour int 4 1 --------0
jLyi2w http://blog.numino.net/
Surplus_Point int 4 1 --------0
i7tuci http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
UXn7CR http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
dn22wN http://blog.numino.net/
7、WEB_ZS
4u75h7 http://blog.numino.net/
列名 类型 长 是否空 说明
8AFeUc http://blog.numino.net/
ID bigint 8 0
k3I0lL http://blog.numino.net/
ACC char 10 1
H9ODKu http://blog.numino.net/
NAME char 10 1
s1es4u http://blog.numino.net/
ZSTIME datetime 8 1
NjhzYd http://blog.numino.net/
ZSCLEVEL smallint 2 1
YvEW90 http://blog.numino.net/
ZSCS smallint 2 0
Njmxp3 http://blog.numino.net/
CZCS smallint 2 0
mm4i84 http://blog.numino.net/
CZTIME datetime 8 0
DYeVz2 http://blog.numino.net/
ZJZSCS smallint 2 0
MBpYOP http://blog.numino.net/
GJZSCS smallint 2 0
HUoJ3I http://blog.numino.net/
CJZSCS smallint 2 0
5CfGNZ http://blog.numino.net/
BSCS smallint 2 0
9UG1BF http://blog.numino.net/
BSTIME datetime 8 0
VakL10 http://blog.numino.net/
LEVELUPPOINT int 4 0
SszuTQ http://blog.numino.net/
GDDS int 4 0
|
|