| 奇迹muonline数据库基础库分析 |
一、表的组成：
WbJ7aZ http://blog.numino.net/
1、AccountCharacter
BSK1Vy http://blog.numino.net/
用来存放帐号的角色。
587J6L http://blog.numino.net/
2、Character
rWWKRA http://blog.numino.net/
用来存放每个角色的详细数据。
a8f165 http://blog.numino.net/
3、MEMB_INFO
3G9821 http://blog.numino.net/
帐号信息
W5155b http://blog.numino.net/
4、MEMB_STAT
khV67n http://blog.numino.net/
帐号状态
1jZ6H4 http://blog.numino.net/
5、warehouse
qVAXIb http://blog.numino.net/
仓库
GBFmK0 http://blog.numino.net/
6、VI_CURR_INFO
go333A http://blog.numino.net/
帐号费用
UgJ8e5 http://blog.numino.net/
7、WEB_ZS
WAWdH4 http://blog.numino.net/
PL 网站的转生数据
XK58h0 http://blog.numino.net/
二、各表说明
3VwCwZ http://blog.numino.net/
1、AccountCharacter 表
nyHymf http://blog.numino.net/
列名 类型 长 是否空 说明
JVA2h3 http://blog.numino.net/
Number int 4 0 自动增加的序数
XBV2QY http://blog.numino.net/
Id varchar 10 0 帐号
Mwlo9u http://blog.numino.net/
GameID1 varchar 10 1 角色1
F2g93X http://blog.numino.net/
GameID2 varchar 10 1 角色2
wrdCy0 http://blog.numino.net/
GameID3 varchar 10 1
c93T7g http://blog.numino.net/
GameID4 varchar 10 1
xlWcUa http://blog.numino.net/
GameID5 varchar 10 1
pqQd9O http://blog.numino.net/
GameIDC varchar 10 1
hN1OVv http://blog.numino.net/
2、Character 表
1J50Dq http://blog.numino.net/
列名 类型 长 是否空 说明
BjH6uU http://blog.numino.net/
AccountID varchar 10 0 --------帐号
8NmKuE http://blog.numino.net/
Name nvarchar 10 0 --------角色名
E30RGL http://blog.numino.net/
cLevel smallint 2 1 --------等级
elZbQ3 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
Uvx6eB http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
858aqC http://blog.numino.net/
Experience int 4 1 --------经验
g86486 http://blog.numino.net/
Strength smallint 2 1 --------力量
ZwnYQg http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
hZ644v http://blog.numino.net/
Vitality smallint 2 1 --------体力
0n39eN http://blog.numino.net/
Energy smallint 2 1 --------智力
ha6O5I http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
aJAyNg http://blog.numino.net/
MagicList varbinary 60 1 --------技能
fRkZmp http://blog.numino.net/
Money int 4 1 --------钱
9di2r1 http://blog.numino.net/
Life real 4 1 --------
9yi42Q http://blog.numino.net/
MaxLife real 4 1 --------
kWF9wL http://blog.numino.net/
Mana real 4 1 --------
ZYBDxG http://blog.numino.net/
MaxMana real 4 1 --------
31xA8A http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
9Vx8IS http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
ZVoxwi http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
YeZ54C http://blog.numino.net/
MapDir tinyint 1 1 --------
HxBuL6 http://blog.numino.net/
PkCount int 4 1 --------
aMLs4O http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
n2oiS5 http://blog.numino.net/
PkTime int 4 1
XXhCTp http://blog.numino.net/
MDate smalldatetime 4 1
D3Bz0d http://blog.numino.net/
LDate smalldatetime 4 1
wsk7T7 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
IpU0Sa http://blog.numino.net/
DbVersion tinyint 1 1
Iuz085 http://blog.numino.net/
Quest varbinary 50 1
a7YEay http://blog.numino.net/
LINZB bit 1 0
DQN9LA http://blog.numino.net/
XDTIME datetime 8 0
3raYFk http://blog.numino.net/
STOPINFO nvarchar 100 1
A3Vg9c http://blog.numino.net/
STOPTIME datetime 8 0
88u3iL http://blog.numino.net/
zs_count int 4 1
yO0f3y http://blog.numino.net/
zs_point int 4 1
wbe54q http://blog.numino.net/
bs_count int 4 1
vVJ2q9 http://blog.numino.net/
bs_point int 4 1
8ia9NA http://blog.numino.net/
shiji smalldatetime 4 1
6UEEFQ http://blog.numino.net/
banl nvarchar 10 1
s7rl4d http://blog.numino.net/
lv_time datetime 8 1
rxaL6c http://blog.numino.net/
ex_ok int 4 1
Nh6eyz http://blog.numino.net/
ex_total int 4 1
sZO8YO http://blog.numino.net/
rb_count int 4 1
rMSY0J http://blog.numino.net/
rb_time datetime 8 1
El9MpU http://blog.numino.net/
pz_time datetime 8 1
0TJVH6 http://blog.numino.net/
3、MEMB_INFO
fK33oA http://blog.numino.net/
列名 类型 长 是否空 说明
3o7LLU http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
sy7d5t http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Up7OHn http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
xBopr2 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
gU2AS8 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
O3tTOZ http://blog.numino.net/
post_code nvarchar 6 1 --------1234
Kj45e3 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
uU3IdN http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
q24fRF http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
vTKPI3 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
h3WP5q http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
ObmYTB http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
A9vPnH http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
zNe1hE http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
h7sakr http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
ZTymjO http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
yE0NO8 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
p6fAx8 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
9wW327 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
3xDC7n http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
C9EyRJ http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
Yz9nlY http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
WHM25v http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
76eP96 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
st57qR http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
Go13Bj http://blog.numino.net/
QX char 1 1 --------B
a6pgKY http://blog.numino.net/
JF int 4 0 --------0
TxfM2I http://blog.numino.net/
huiy int 4 1 --------0
pVv42z http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
riQ6s5 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
xedDmD http://blog.numino.net/
FDB int 4 1 --------0
NAhm7s http://blog.numino.net/
vip tinyint 1 1 --------0
VF7jFM http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
2eZPah http://blog.numino.net/
4、MEMB_STAT
v1kXAl http://blog.numino.net/
列名 类型 长 是否空 说明
WQgxVf http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
0LrqPV http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
pRyxj5 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
VcpsyC http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
KUJr7G http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
LFvo39 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
CdKC0i http://blog.numino.net/
5、warehouse
bNWI13 http://blog.numino.net/
列名 类型 长 是否空 说明
WJjG4L http://blog.numino.net/
AccountID varchar 10 0 --------帐号
06yw28 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
VyTrzH http://blog.numino.net/
Money int 4 1 --------钱
hJ7f8a http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
mvjy8C http://blog.numino.net/
DbVersion tinyint 1 1 --------1
66l1pu http://blog.numino.net/
pw smallint 2 1 --------密码 0
630ZkG http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
DV81Ac http://blog.numino.net/
ExtCKNum int 4 0 --------0
g6t7jY http://blog.numino.net/
NeedExtCK int 4 0 --------0
A24wlh http://blog.numino.net/
6、VI_CURR_INFO
1K0rCL http://blog.numino.net/
列名 类型 长 是否空 说明
c6UY3i http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
4Fd0J4 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
wOg881 http://blog.numino.net/
used_time int 4 1 --------1234
y58d9V http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
63rKse http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
DyHf0P http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
9BRdeC http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
Pdjj9d http://blog.numino.net/
Bill_Section int 4 1 --------6
pfoXBd http://blog.numino.net/
Bill_Value int 4 1 --------3
0ejMS1 http://blog.numino.net/
Bill_Hour int 4 1 --------0
147JoD http://blog.numino.net/
Surplus_Point int 4 1 --------0
bGzQH0 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
k0qh46 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
5e4H2C http://blog.numino.net/
7、WEB_ZS
EFjJD7 http://blog.numino.net/
列名 类型 长 是否空 说明
xR5G1H http://blog.numino.net/
ID bigint 8 0
jsWaV9 http://blog.numino.net/
ACC char 10 1
R9P7h0 http://blog.numino.net/
NAME char 10 1
OqN7N1 http://blog.numino.net/
ZSTIME datetime 8 1
YJ8hz3 http://blog.numino.net/
ZSCLEVEL smallint 2 1
0ErJrm http://blog.numino.net/
ZSCS smallint 2 0
VW19OH http://blog.numino.net/
CZCS smallint 2 0
FNcZAF http://blog.numino.net/
CZTIME datetime 8 0
9GSFi5 http://blog.numino.net/
ZJZSCS smallint 2 0
xSso6t http://blog.numino.net/
GJZSCS smallint 2 0
1W7EzF http://blog.numino.net/
CJZSCS smallint 2 0
YJyX43 http://blog.numino.net/
BSCS smallint 2 0
3PA2hQ http://blog.numino.net/
BSTIME datetime 8 0
ARgKdQ http://blog.numino.net/
LEVELUPPOINT int 4 0
cq6KIe http://blog.numino.net/
GDDS int 4 0
|
|