| 奇迹muonline数据库基础库分析 |
一、表的组成：
3nJ7sQ http://blog.numino.net/
1、AccountCharacter
9G23DD http://blog.numino.net/
用来存放帐号的角色。
VG3R0k http://blog.numino.net/
2、Character
7NeiSi http://blog.numino.net/
用来存放每个角色的详细数据。
j26UMM http://blog.numino.net/
3、MEMB_INFO
U8TE1j http://blog.numino.net/
帐号信息
2f22lt http://blog.numino.net/
4、MEMB_STAT
rSuKd9 http://blog.numino.net/
帐号状态
MD8GY7 http://blog.numino.net/
5、warehouse
a09NEp http://blog.numino.net/
仓库
W5eZ2c http://blog.numino.net/
6、VI_CURR_INFO
eonypv http://blog.numino.net/
帐号费用
1p2Lgc http://blog.numino.net/
7、WEB_ZS
77RYPJ http://blog.numino.net/
PL 网站的转生数据
VfS1xe http://blog.numino.net/
二、各表说明
FG4Tb7 http://blog.numino.net/
1、AccountCharacter 表
AB8JPN http://blog.numino.net/
列名 类型 长 是否空 说明
gweHLX http://blog.numino.net/
Number int 4 0 自动增加的序数
8ggDCr http://blog.numino.net/
Id varchar 10 0 帐号
kiY1j2 http://blog.numino.net/
GameID1 varchar 10 1 角色1
dIbP2C http://blog.numino.net/
GameID2 varchar 10 1 角色2
rFZewc http://blog.numino.net/
GameID3 varchar 10 1
Z98yfh http://blog.numino.net/
GameID4 varchar 10 1
Wj7i78 http://blog.numino.net/
GameID5 varchar 10 1
wO1Q6L http://blog.numino.net/
GameIDC varchar 10 1
8TDWC2 http://blog.numino.net/
2、Character 表
2hYl7c http://blog.numino.net/
列名 类型 长 是否空 说明
LLx4Ek http://blog.numino.net/
AccountID varchar 10 0 --------帐号
MCiIYh http://blog.numino.net/
Name nvarchar 10 0 --------角色名
4XlIAs http://blog.numino.net/
cLevel smallint 2 1 --------等级
synicf http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
HtSmaD http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
ksc3MW http://blog.numino.net/
Experience int 4 1 --------经验
X3jk9m http://blog.numino.net/
Strength smallint 2 1 --------力量
dVa571 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
v8CouR http://blog.numino.net/
Vitality smallint 2 1 --------体力
HMl1r2 http://blog.numino.net/
Energy smallint 2 1 --------智力
20P0IG http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
sBF4P7 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
V89TAp http://blog.numino.net/
Money int 4 1 --------钱
7A52o6 http://blog.numino.net/
Life real 4 1 --------
YlS0Yv http://blog.numino.net/
MaxLife real 4 1 --------
r7RhWG http://blog.numino.net/
Mana real 4 1 --------
nfer66 http://blog.numino.net/
MaxMana real 4 1 --------
jHJYIp http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
hYD0PF http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
uZVKxr http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
7q8501 http://blog.numino.net/
MapDir tinyint 1 1 --------
q9jdr4 http://blog.numino.net/
PkCount int 4 1 --------
Fn71t3 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
5UQi93 http://blog.numino.net/
PkTime int 4 1
z0Y9n7 http://blog.numino.net/
MDate smalldatetime 4 1
cf98Gm http://blog.numino.net/
LDate smalldatetime 4 1
7eXmPi http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
779y5o http://blog.numino.net/
DbVersion tinyint 1 1
TyVzm2 http://blog.numino.net/
Quest varbinary 50 1
qAZ3s0 http://blog.numino.net/
LINZB bit 1 0
rjWahQ http://blog.numino.net/
XDTIME datetime 8 0
6tFeVs http://blog.numino.net/
STOPINFO nvarchar 100 1
H1iH9u http://blog.numino.net/
STOPTIME datetime 8 0
3QPqc8 http://blog.numino.net/
zs_count int 4 1
HZQBS2 http://blog.numino.net/
zs_point int 4 1
3QJf7o http://blog.numino.net/
bs_count int 4 1
vyp0a0 http://blog.numino.net/
bs_point int 4 1
ADk7KV http://blog.numino.net/
shiji smalldatetime 4 1
Oy2Stt http://blog.numino.net/
banl nvarchar 10 1
OcYd7o http://blog.numino.net/
lv_time datetime 8 1
Uzyrat http://blog.numino.net/
ex_ok int 4 1
1r1twG http://blog.numino.net/
ex_total int 4 1
y6xoLu http://blog.numino.net/
rb_count int 4 1
Ey68oQ http://blog.numino.net/
rb_time datetime 8 1
Dmq9Hv http://blog.numino.net/
pz_time datetime 8 1
ZPyMPA http://blog.numino.net/
3、MEMB_INFO
p5z126 http://blog.numino.net/
列名 类型 长 是否空 说明
v64xEU http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
839vns http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
U6SGDX http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
y0r2kQ http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
5Sa3o3 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
24WYC0 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
nqKOWO http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
UN4Ck5 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
m8F7uv http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
DYKpnR http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
4I8oNs http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
7yOf7z http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
legSiM http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
y5Dwez http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
7iwNQ1 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
Os6G6I http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
v4eQ52 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Cc7bQX http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
7RaZFp http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
0pTolP http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
vynmiO http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
YJchQx http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
AOsTU5 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
0ckM37 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
lc2H2U http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
EDZaXR http://blog.numino.net/
QX char 1 1 --------B
LSEI6i http://blog.numino.net/
JF int 4 0 --------0
cPyjf5 http://blog.numino.net/
huiy int 4 1 --------0
K70SXV http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
FCX5Y1 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
Ls95lf http://blog.numino.net/
FDB int 4 1 --------0
X779a3 http://blog.numino.net/
vip tinyint 1 1 --------0
QrsiMY http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
aXtlx6 http://blog.numino.net/
4、MEMB_STAT
XY0495 http://blog.numino.net/
列名 类型 长 是否空 说明
zd95Wb http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
u665J4 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
2UWTr7 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
6lGIek http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
8Lep43 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
QRIE52 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
kH5IyE http://blog.numino.net/
5、warehouse
jSG3GY http://blog.numino.net/
列名 类型 长 是否空 说明
F9u5Vr http://blog.numino.net/
AccountID varchar 10 0 --------帐号
626w1o http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
z31x57 http://blog.numino.net/
Money int 4 1 --------钱
W8A10c http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
Q64CMT http://blog.numino.net/
DbVersion tinyint 1 1 --------1
s4oNxi http://blog.numino.net/
pw smallint 2 1 --------密码 0
r63vRF http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
gBKPV3 http://blog.numino.net/
ExtCKNum int 4 0 --------0
JaV3Y6 http://blog.numino.net/
NeedExtCK int 4 0 --------0
0TZPmO http://blog.numino.net/
6、VI_CURR_INFO
xIakZS http://blog.numino.net/
列名 类型 长 是否空 说明
R5tF6R http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
dI5cHd http://blog.numino.net/
chek_code nvarchar 1 0 --------1
oT2C0f http://blog.numino.net/
used_time int 4 1 --------1234
g9Lr5g http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
8dJGFg http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
1tLRk5 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
63eq7B http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
Orx7W6 http://blog.numino.net/
Bill_Section int 4 1 --------6
XCFfiO http://blog.numino.net/
Bill_Value int 4 1 --------3
xn1Yqf http://blog.numino.net/
Bill_Hour int 4 1 --------0
Wd50r6 http://blog.numino.net/
Surplus_Point int 4 1 --------0
r4baPy http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
AYMCXR http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
DFCz9N http://blog.numino.net/
7、WEB_ZS
37P340 http://blog.numino.net/
列名 类型 长 是否空 说明
15QV3P http://blog.numino.net/
ID bigint 8 0
0N932C http://blog.numino.net/
ACC char 10 1
0l6Vdd http://blog.numino.net/
NAME char 10 1
NaCHux http://blog.numino.net/
ZSTIME datetime 8 1
h9Uhh9 http://blog.numino.net/
ZSCLEVEL smallint 2 1
G9dVH7 http://blog.numino.net/
ZSCS smallint 2 0
0893l1 http://blog.numino.net/
CZCS smallint 2 0
76WVW8 http://blog.numino.net/
CZTIME datetime 8 0
xurPr1 http://blog.numino.net/
ZJZSCS smallint 2 0
D8XqkD http://blog.numino.net/
GJZSCS smallint 2 0
cb2Bsq http://blog.numino.net/
CJZSCS smallint 2 0
TkVKl1 http://blog.numino.net/
BSCS smallint 2 0
wu8tAK http://blog.numino.net/
BSTIME datetime 8 0
w9pxoY http://blog.numino.net/
LEVELUPPOINT int 4 0
8azQ7u http://blog.numino.net/
GDDS int 4 0
|
|