| 奇迹muonline数据库基础库分析 |
一、表的组成：
63AeK1 http://blog.numino.net/
1、AccountCharacter
ptG99H http://blog.numino.net/
用来存放帐号的角色。
0rDm97 http://blog.numino.net/
2、Character
QNu3l9 http://blog.numino.net/
用来存放每个角色的详细数据。
Fhuwt8 http://blog.numino.net/
3、MEMB_INFO
IS5c3d http://blog.numino.net/
帐号信息
tHV6tu http://blog.numino.net/
4、MEMB_STAT
LHIdUU http://blog.numino.net/
帐号状态
EtUNXw http://blog.numino.net/
5、warehouse
UUifRr http://blog.numino.net/
仓库
r0aOML http://blog.numino.net/
6、VI_CURR_INFO
a4VBW7 http://blog.numino.net/
帐号费用
HBuh3m http://blog.numino.net/
7、WEB_ZS
wAcBz5 http://blog.numino.net/
PL 网站的转生数据
5oKZ25 http://blog.numino.net/
二、各表说明
3flvkj http://blog.numino.net/
1、AccountCharacter 表
c9gou1 http://blog.numino.net/
列名 类型 长 是否空 说明
5wI5Wh http://blog.numino.net/
Number int 4 0 自动增加的序数
PBysBA http://blog.numino.net/
Id varchar 10 0 帐号
AP9wwf http://blog.numino.net/
GameID1 varchar 10 1 角色1
lWsGVL http://blog.numino.net/
GameID2 varchar 10 1 角色2
52YeMW http://blog.numino.net/
GameID3 varchar 10 1
PgD63W http://blog.numino.net/
GameID4 varchar 10 1
QBS0R6 http://blog.numino.net/
GameID5 varchar 10 1
TzNtZ9 http://blog.numino.net/
GameIDC varchar 10 1
72vQjd http://blog.numino.net/
2、Character 表
x13hyp http://blog.numino.net/
列名 类型 长 是否空 说明
czOvZo http://blog.numino.net/
AccountID varchar 10 0 --------帐号
1wcER8 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
0tYRoQ http://blog.numino.net/
cLevel smallint 2 1 --------等级
9IxH86 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
5ylVMk http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
yeZL35 http://blog.numino.net/
Experience int 4 1 --------经验
7pp0xj http://blog.numino.net/
Strength smallint 2 1 --------力量
y1Bln8 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
JYS7qY http://blog.numino.net/
Vitality smallint 2 1 --------体力
1acmvo http://blog.numino.net/
Energy smallint 2 1 --------智力
G3YOak http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
euG2p4 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
F2jPwp http://blog.numino.net/
Money int 4 1 --------钱
WvkFoI http://blog.numino.net/
Life real 4 1 --------
ZOq2eK http://blog.numino.net/
MaxLife real 4 1 --------
H5k2i2 http://blog.numino.net/
Mana real 4 1 --------
3TmD2X http://blog.numino.net/
MaxMana real 4 1 --------
b9M6sK http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
WBtfLn http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
H5cvPH http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
gU7n2d http://blog.numino.net/
MapDir tinyint 1 1 --------
6gZJBD http://blog.numino.net/
PkCount int 4 1 --------
47TI8F http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
Wwk3IW http://blog.numino.net/
PkTime int 4 1
wMr3Hf http://blog.numino.net/
MDate smalldatetime 4 1
KKCmgG http://blog.numino.net/
LDate smalldatetime 4 1
xmns27 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
2C6QAK http://blog.numino.net/
DbVersion tinyint 1 1
52y8Ka http://blog.numino.net/
Quest varbinary 50 1
P3eDf6 http://blog.numino.net/
LINZB bit 1 0
9yg1A4 http://blog.numino.net/
XDTIME datetime 8 0
fbS2F1 http://blog.numino.net/
STOPINFO nvarchar 100 1
Sd2s2i http://blog.numino.net/
STOPTIME datetime 8 0
bpyfO5 http://blog.numino.net/
zs_count int 4 1
E41Ups http://blog.numino.net/
zs_point int 4 1
09H59G http://blog.numino.net/
bs_count int 4 1
CGLo6W http://blog.numino.net/
bs_point int 4 1
zE1eac http://blog.numino.net/
shiji smalldatetime 4 1
mBy21f http://blog.numino.net/
banl nvarchar 10 1
91d9D3 http://blog.numino.net/
lv_time datetime 8 1
Pyq05X http://blog.numino.net/
ex_ok int 4 1
43BLaq http://blog.numino.net/
ex_total int 4 1
56Cg6x http://blog.numino.net/
rb_count int 4 1
2JYmq2 http://blog.numino.net/
rb_time datetime 8 1
1O70Md http://blog.numino.net/
pz_time datetime 8 1
8xlzF0 http://blog.numino.net/
3、MEMB_INFO
v6B72c http://blog.numino.net/
列名 类型 长 是否空 说明
x6nkoa http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
i940C8 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
1B37I2 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
vdDWJC http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
MszVUe http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
5BCB7N http://blog.numino.net/
post_code nvarchar 6 1 --------1234
o4Cia1 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
DEYT5G http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
U7N1fc http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
5JG9nd http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
a3lwj3 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
9el2bX http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
kXr5lw http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
oUbsos http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
r58BGy http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
SQMK3m http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
Vip2W4 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
7dQV4x http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
L0noC8 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
oO7fL6 http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
TZ55bj http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
jlBkCA http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
I1OTaP http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
lUAu9P http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
6a4f55 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
UZ5oM4 http://blog.numino.net/
QX char 1 1 --------B
rMw2wN http://blog.numino.net/
JF int 4 0 --------0
bEtCcZ http://blog.numino.net/
huiy int 4 1 --------0
fBcvuv http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
rbRakk http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
mCOo5N http://blog.numino.net/
FDB int 4 1 --------0
9mt2WP http://blog.numino.net/
vip tinyint 1 1 --------0
pQfm40 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
46qPFq http://blog.numino.net/
4、MEMB_STAT
36cJn9 http://blog.numino.net/
列名 类型 长 是否空 说明
5C48w3 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
App54U http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
pITndz http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
55QSaD http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
YyRVCc http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
vle6M3 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
Wi2dWO http://blog.numino.net/
5、warehouse
Ovb7jQ http://blog.numino.net/
列名 类型 长 是否空 说明
6SSY7u http://blog.numino.net/
AccountID varchar 10 0 --------帐号
6Hc45u http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
N79Oph http://blog.numino.net/
Money int 4 1 --------钱
B020Xr http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
gtwk7Y http://blog.numino.net/
DbVersion tinyint 1 1 --------1
4x1DY1 http://blog.numino.net/
pw smallint 2 1 --------密码 0
0pD67p http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
449Gx4 http://blog.numino.net/
ExtCKNum int 4 0 --------0
bq65pC http://blog.numino.net/
NeedExtCK int 4 0 --------0
H4UY56 http://blog.numino.net/
6、VI_CURR_INFO
1PYsam http://blog.numino.net/
列名 类型 长 是否空 说明
23hBUT http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
xKzs9F http://blog.numino.net/
chek_code nvarchar 1 0 --------1
sJ40ku http://blog.numino.net/
used_time int 4 1 --------1234
CyIkX4 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
8m6Tm0 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
yuq9I2 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
LFPn8C http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
uLmne3 http://blog.numino.net/
Bill_Section int 4 1 --------6
15B40n http://blog.numino.net/
Bill_Value int 4 1 --------3
6ZIL85 http://blog.numino.net/
Bill_Hour int 4 1 --------0
ryls7T http://blog.numino.net/
Surplus_Point int 4 1 --------0
HGLh6c http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
54a6Aw http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
IJsVd6 http://blog.numino.net/
7、WEB_ZS
pq69c0 http://blog.numino.net/
列名 类型 长 是否空 说明
f2t3MH http://blog.numino.net/
ID bigint 8 0
lLGwxo http://blog.numino.net/
ACC char 10 1
fdv64T http://blog.numino.net/
NAME char 10 1
8nnBAq http://blog.numino.net/
ZSTIME datetime 8 1
7UIB3m http://blog.numino.net/
ZSCLEVEL smallint 2 1
hDVp04 http://blog.numino.net/
ZSCS smallint 2 0
t6IBH2 http://blog.numino.net/
CZCS smallint 2 0
OR0CY8 http://blog.numino.net/
CZTIME datetime 8 0
G9W088 http://blog.numino.net/
ZJZSCS smallint 2 0
3VEJgH http://blog.numino.net/
GJZSCS smallint 2 0
Y1yE6y http://blog.numino.net/
CJZSCS smallint 2 0
DIf48j http://blog.numino.net/
BSCS smallint 2 0
vWK0aY http://blog.numino.net/
BSTIME datetime 8 0
wcsdS5 http://blog.numino.net/
LEVELUPPOINT int 4 0
5MpSs3 http://blog.numino.net/
GDDS int 4 0
|
|