| 奇迹muonline数据库基础库分析 |
一、表的组成：
xR6v4M http://blog.numino.net/
1、AccountCharacter
3FXQhA http://blog.numino.net/
用来存放帐号的角色。
fWP4lc http://blog.numino.net/
2、Character
b0T5ON http://blog.numino.net/
用来存放每个角色的详细数据。
R1pGxP http://blog.numino.net/
3、MEMB_INFO
BZkZC4 http://blog.numino.net/
帐号信息
Z1zL4e http://blog.numino.net/
4、MEMB_STAT
0ACCm3 http://blog.numino.net/
帐号状态
lsQ6ey http://blog.numino.net/
5、warehouse
w517CE http://blog.numino.net/
仓库
v3f76s http://blog.numino.net/
6、VI_CURR_INFO
t8uC8Y http://blog.numino.net/
帐号费用
3Z4kIu http://blog.numino.net/
7、WEB_ZS
0ELazo http://blog.numino.net/
PL 网站的转生数据
svEYSJ http://blog.numino.net/
二、各表说明
79YuIb http://blog.numino.net/
1、AccountCharacter 表
1nVfAk http://blog.numino.net/
列名 类型 长 是否空 说明
D2gfAp http://blog.numino.net/
Number int 4 0 自动增加的序数
B9OtJk http://blog.numino.net/
Id varchar 10 0 帐号
2HnD7E http://blog.numino.net/
GameID1 varchar 10 1 角色1
y6FY0f http://blog.numino.net/
GameID2 varchar 10 1 角色2
PWnIMW http://blog.numino.net/
GameID3 varchar 10 1
yE8P66 http://blog.numino.net/
GameID4 varchar 10 1
2SrhKy http://blog.numino.net/
GameID5 varchar 10 1
skyq1n http://blog.numino.net/
GameIDC varchar 10 1
2HoRZN http://blog.numino.net/
2、Character 表
LWW8gM http://blog.numino.net/
列名 类型 长 是否空 说明
4xdNN6 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
0siYkD http://blog.numino.net/
Name nvarchar 10 0 --------角色名
MC0i9D http://blog.numino.net/
cLevel smallint 2 1 --------等级
F9mvOA http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
QzQw7Y http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
ddg88Z http://blog.numino.net/
Experience int 4 1 --------经验
2cQVYm http://blog.numino.net/
Strength smallint 2 1 --------力量
W0dxvD http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
m2SGPB http://blog.numino.net/
Vitality smallint 2 1 --------体力
71bLz8 http://blog.numino.net/
Energy smallint 2 1 --------智力
ladAvr http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
6K9ib2 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
0uLI3S http://blog.numino.net/
Money int 4 1 --------钱
Yf6STz http://blog.numino.net/
Life real 4 1 --------
3qLM7Z http://blog.numino.net/
MaxLife real 4 1 --------
asen3A http://blog.numino.net/
Mana real 4 1 --------
c3g320 http://blog.numino.net/
MaxMana real 4 1 --------
Z31IuA http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
xHNz9W http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
H8A0U8 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
x7q14n http://blog.numino.net/
MapDir tinyint 1 1 --------
bZjNYW http://blog.numino.net/
PkCount int 4 1 --------
O6JgO4 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
E3uLZe http://blog.numino.net/
PkTime int 4 1
pLHbUM http://blog.numino.net/
MDate smalldatetime 4 1
YGaxj1 http://blog.numino.net/
LDate smalldatetime 4 1
Ef5RZd http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
67IT19 http://blog.numino.net/
DbVersion tinyint 1 1
nZmzvF http://blog.numino.net/
Quest varbinary 50 1
7034La http://blog.numino.net/
LINZB bit 1 0
kp9EGC http://blog.numino.net/
XDTIME datetime 8 0
P3NDWV http://blog.numino.net/
STOPINFO nvarchar 100 1
yK6wCs http://blog.numino.net/
STOPTIME datetime 8 0
fVrrf9 http://blog.numino.net/
zs_count int 4 1
65w0gI http://blog.numino.net/
zs_point int 4 1
Qhsj3R http://blog.numino.net/
bs_count int 4 1
aMrtTN http://blog.numino.net/
bs_point int 4 1
aI6l94 http://blog.numino.net/
shiji smalldatetime 4 1
Dc995Y http://blog.numino.net/
banl nvarchar 10 1
2k5iZG http://blog.numino.net/
lv_time datetime 8 1
uJQSnl http://blog.numino.net/
ex_ok int 4 1
UDmSAu http://blog.numino.net/
ex_total int 4 1
zEtFEc http://blog.numino.net/
rb_count int 4 1
ZLzWr8 http://blog.numino.net/
rb_time datetime 8 1
u595ZG http://blog.numino.net/
pz_time datetime 8 1
xD0xOh http://blog.numino.net/
3、MEMB_INFO
AlxC21 http://blog.numino.net/
列名 类型 长 是否空 说明
T6DDs4 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
aOkHVf http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
DotGiY http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
69s4d3 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
un6Pdx http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
v6iwvd http://blog.numino.net/
post_code nvarchar 6 1 --------1234
HDx8a0 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
FFOO6S http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
qVbz55 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
HPt4L2 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
OrE8VM http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
bhPkl0 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
Y3Jk6p http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
OgklnX http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
Ut1x3P http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
w44Ic1 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
zv8Rz9 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
IQwV5T http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
Mih405 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
9yVltg http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
FUIY7Q http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
9J83Ay http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
8x6YN1 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
8eE0t3 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
6Rwkk0 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
2HDqh7 http://blog.numino.net/
QX char 1 1 --------B
IJL2Y3 http://blog.numino.net/
JF int 4 0 --------0
Km6Fmv http://blog.numino.net/
huiy int 4 1 --------0
tnR3M3 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
5nPOmH http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
ldV0vw http://blog.numino.net/
FDB int 4 1 --------0
cdGB7i http://blog.numino.net/
vip tinyint 1 1 --------0
CBR60K http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
6F6rRF http://blog.numino.net/
4、MEMB_STAT
pqoS7r http://blog.numino.net/
列名 类型 长 是否空 说明
FidA2J http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
tTLDDp http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
qt3286 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
7904Ea http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
enkr9L http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
n1mD87 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
mqTQK6 http://blog.numino.net/
5、warehouse
KgBGxl http://blog.numino.net/
列名 类型 长 是否空 说明
IJNs9C http://blog.numino.net/
AccountID varchar 10 0 --------帐号
aps8g1 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
CCoIk1 http://blog.numino.net/
Money int 4 1 --------钱
paMYGb http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
KX1Rah http://blog.numino.net/
DbVersion tinyint 1 1 --------1
r4r22V http://blog.numino.net/
pw smallint 2 1 --------密码 0
63k0FC http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
0m498x http://blog.numino.net/
ExtCKNum int 4 0 --------0
bBgW9J http://blog.numino.net/
NeedExtCK int 4 0 --------0
h2p1Z9 http://blog.numino.net/
6、VI_CURR_INFO
0gq1r4 http://blog.numino.net/
列名 类型 长 是否空 说明
U5XSKu http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
ld51oA http://blog.numino.net/
chek_code nvarchar 1 0 --------1
0ZHk50 http://blog.numino.net/
used_time int 4 1 --------1234
7Db1IH http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
2l6lTw http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
QPpG9D http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
qa40wj http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
626Uf1 http://blog.numino.net/
Bill_Section int 4 1 --------6
58fRnE http://blog.numino.net/
Bill_Value int 4 1 --------3
QLrCL0 http://blog.numino.net/
Bill_Hour int 4 1 --------0
6VjBZ8 http://blog.numino.net/
Surplus_Point int 4 1 --------0
wS63nx http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
s9KkMo http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
AxR2CP http://blog.numino.net/
7、WEB_ZS
7S3sFw http://blog.numino.net/
列名 类型 长 是否空 说明
I73mTm http://blog.numino.net/
ID bigint 8 0
21iXiG http://blog.numino.net/
ACC char 10 1
7H9h1y http://blog.numino.net/
NAME char 10 1
BQqSaX http://blog.numino.net/
ZSTIME datetime 8 1
bxjsG2 http://blog.numino.net/
ZSCLEVEL smallint 2 1
eQjpuS http://blog.numino.net/
ZSCS smallint 2 0
M8dRM7 http://blog.numino.net/
CZCS smallint 2 0
0Qz4J2 http://blog.numino.net/
CZTIME datetime 8 0
m58s9u http://blog.numino.net/
ZJZSCS smallint 2 0
LmqkYC http://blog.numino.net/
GJZSCS smallint 2 0
07Rb0x http://blog.numino.net/
CJZSCS smallint 2 0
bAM6SF http://blog.numino.net/
BSCS smallint 2 0
34Oo0N http://blog.numino.net/
BSTIME datetime 8 0
dIAJlu http://blog.numino.net/
LEVELUPPOINT int 4 0
l8Ol3d http://blog.numino.net/
GDDS int 4 0
|
|