| 奇迹muonline数据库基础库分析 |
一、表的组成：
MByya1 http://blog.numino.net/
1、AccountCharacter
2yCcHE http://blog.numino.net/
用来存放帐号的角色。
K65i7k http://blog.numino.net/
2、Character
uYdmNE http://blog.numino.net/
用来存放每个角色的详细数据。
ZTU4ZJ http://blog.numino.net/
3、MEMB_INFO
bD2SFi http://blog.numino.net/
帐号信息
Mltjuf http://blog.numino.net/
4、MEMB_STAT
DAtVfL http://blog.numino.net/
帐号状态
b9VbKR http://blog.numino.net/
5、warehouse
swXl9M http://blog.numino.net/
仓库
ZuV8Sg http://blog.numino.net/
6、VI_CURR_INFO
vct7Xj http://blog.numino.net/
帐号费用
mfuGi0 http://blog.numino.net/
7、WEB_ZS
VsoT9Q http://blog.numino.net/
PL 网站的转生数据
jj0JYA http://blog.numino.net/
二、各表说明
76cvC9 http://blog.numino.net/
1、AccountCharacter 表
EF81YK http://blog.numino.net/
列名 类型 长 是否空 说明
6S02zl http://blog.numino.net/
Number int 4 0 自动增加的序数
0aO5d6 http://blog.numino.net/
Id varchar 10 0 帐号
xRbLBS http://blog.numino.net/
GameID1 varchar 10 1 角色1
L5KTpr http://blog.numino.net/
GameID2 varchar 10 1 角色2
JnDrkt http://blog.numino.net/
GameID3 varchar 10 1
uLX26t http://blog.numino.net/
GameID4 varchar 10 1
TqlFUn http://blog.numino.net/
GameID5 varchar 10 1
40Xt55 http://blog.numino.net/
GameIDC varchar 10 1
S7kMOw http://blog.numino.net/
2、Character 表
wl8Sp2 http://blog.numino.net/
列名 类型 长 是否空 说明
2ee26A http://blog.numino.net/
AccountID varchar 10 0 --------帐号
51sh44 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
uS2lV3 http://blog.numino.net/
cLevel smallint 2 1 --------等级
2j55T2 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
4Msv5m http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
zHZaoO http://blog.numino.net/
Experience int 4 1 --------经验
N2Ke76 http://blog.numino.net/
Strength smallint 2 1 --------力量
n8l8SV http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
ILF197 http://blog.numino.net/
Vitality smallint 2 1 --------体力
cWV3d9 http://blog.numino.net/
Energy smallint 2 1 --------智力
3GVs9N http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
OcKKBU http://blog.numino.net/
MagicList varbinary 60 1 --------技能
8V37y5 http://blog.numino.net/
Money int 4 1 --------钱
8bKr2y http://blog.numino.net/
Life real 4 1 --------
PuG6cp http://blog.numino.net/
MaxLife real 4 1 --------
Kf0953 http://blog.numino.net/
Mana real 4 1 --------
4YfScV http://blog.numino.net/
MaxMana real 4 1 --------
b5r0zC http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
2QL1XG http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
P8Yk2I http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
639i09 http://blog.numino.net/
MapDir tinyint 1 1 --------
U30p58 http://blog.numino.net/
PkCount int 4 1 --------
91yS4r http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
DvnrjG http://blog.numino.net/
PkTime int 4 1
TBDfNJ http://blog.numino.net/
MDate smalldatetime 4 1
fGIbQK http://blog.numino.net/
LDate smalldatetime 4 1
U8Rc89 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
sm0bEV http://blog.numino.net/
DbVersion tinyint 1 1
YSzitm http://blog.numino.net/
Quest varbinary 50 1
G159Js http://blog.numino.net/
LINZB bit 1 0
PSk7nV http://blog.numino.net/
XDTIME datetime 8 0
F927xM http://blog.numino.net/
STOPINFO nvarchar 100 1
4T7nmB http://blog.numino.net/
STOPTIME datetime 8 0
Osv5Tg http://blog.numino.net/
zs_count int 4 1
aucEJ7 http://blog.numino.net/
zs_point int 4 1
SkpPJS http://blog.numino.net/
bs_count int 4 1
L4A6lr http://blog.numino.net/
bs_point int 4 1
B6We70 http://blog.numino.net/
shiji smalldatetime 4 1
DEx0iS http://blog.numino.net/
banl nvarchar 10 1
CXuPN7 http://blog.numino.net/
lv_time datetime 8 1
j7AXN8 http://blog.numino.net/
ex_ok int 4 1
43r61z http://blog.numino.net/
ex_total int 4 1
gT5qn3 http://blog.numino.net/
rb_count int 4 1
jj8ilr http://blog.numino.net/
rb_time datetime 8 1
czid2v http://blog.numino.net/
pz_time datetime 8 1
P6TRUp http://blog.numino.net/
3、MEMB_INFO
YKP56c http://blog.numino.net/
列名 类型 长 是否空 说明
B4m02Q http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
5l83g5 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Frsuuk http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
k4E8vE http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
9vY1ed http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
Ro15WN http://blog.numino.net/
post_code nvarchar 6 1 --------1234
V4L69G http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
wdM0Hw http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
TR9lLS http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
E0LQM6 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
UO4gJD http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
07Ux7H http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
QI1To8 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
8z5a99 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
07ulD0 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
HRz5F6 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
W2hH2c http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
U322eO http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
2o55xy http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
ztTZ07 http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
nDTa6L http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
1mZ4ps http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
b9dkXg http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
54OrXn http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
W65s2L http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
0porpB http://blog.numino.net/
QX char 1 1 --------B
5tpYCQ http://blog.numino.net/
JF int 4 0 --------0
6yVy6H http://blog.numino.net/
huiy int 4 1 --------0
pm9MSY http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
9gD2aW http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
cEAmL9 http://blog.numino.net/
FDB int 4 1 --------0
tn4jdR http://blog.numino.net/
vip tinyint 1 1 --------0
L9Tco7 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
pjS95J http://blog.numino.net/
4、MEMB_STAT
a024IQ http://blog.numino.net/
列名 类型 长 是否空 说明
XuHd0v http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
cJi6Et http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
2BbTDs http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
aFGD9j http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
3naClc http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
bjTw4d http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
ybgapH http://blog.numino.net/
5、warehouse
poHt40 http://blog.numino.net/
列名 类型 长 是否空 说明
73IuP9 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
gPdG80 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
Kt1gS0 http://blog.numino.net/
Money int 4 1 --------钱
p7wwGx http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
sw4IC4 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
BDxMNu http://blog.numino.net/
pw smallint 2 1 --------密码 0
8wt2aG http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
36QbMO http://blog.numino.net/
ExtCKNum int 4 0 --------0
k9QR4k http://blog.numino.net/
NeedExtCK int 4 0 --------0
tQdhrq http://blog.numino.net/
6、VI_CURR_INFO
8KVV6b http://blog.numino.net/
列名 类型 长 是否空 说明
gAk042 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
9GtsUq http://blog.numino.net/
chek_code nvarchar 1 0 --------1
ck36ig http://blog.numino.net/
used_time int 4 1 --------1234
kFHJYp http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
OkYD7j http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
K9WGjm http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
38vV5P http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
yb9FgQ http://blog.numino.net/
Bill_Section int 4 1 --------6
owhyKH http://blog.numino.net/
Bill_Value int 4 1 --------3
7Mgtdf http://blog.numino.net/
Bill_Hour int 4 1 --------0
aszEcd http://blog.numino.net/
Surplus_Point int 4 1 --------0
7o9NlD http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
04b0Kd http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
N92599 http://blog.numino.net/
7、WEB_ZS
tQ0J2t http://blog.numino.net/
列名 类型 长 是否空 说明
00tOVp http://blog.numino.net/
ID bigint 8 0
2ChgPR http://blog.numino.net/
ACC char 10 1
u00yoS http://blog.numino.net/
NAME char 10 1
12O6Gm http://blog.numino.net/
ZSTIME datetime 8 1
H6cIXJ http://blog.numino.net/
ZSCLEVEL smallint 2 1
8VfaTm http://blog.numino.net/
ZSCS smallint 2 0
H4yyl0 http://blog.numino.net/
CZCS smallint 2 0
44VcM9 http://blog.numino.net/
CZTIME datetime 8 0
84OAWD http://blog.numino.net/
ZJZSCS smallint 2 0
N9e4J2 http://blog.numino.net/
GJZSCS smallint 2 0
p8eZs3 http://blog.numino.net/
CJZSCS smallint 2 0
qb22ms http://blog.numino.net/
BSCS smallint 2 0
81J7f5 http://blog.numino.net/
BSTIME datetime 8 0
a4u2vu http://blog.numino.net/
LEVELUPPOINT int 4 0
9E1003 http://blog.numino.net/
GDDS int 4 0
|
|