| 奇迹muonline数据库基础库分析 |
一、表的组成：
4Yly7d http://blog.numino.net/
1、AccountCharacter
AH1o9M http://blog.numino.net/
用来存放帐号的角色。
0ngAUJ http://blog.numino.net/
2、Character
G2laDs http://blog.numino.net/
用来存放每个角色的详细数据。
50vrR2 http://blog.numino.net/
3、MEMB_INFO
9S07cN http://blog.numino.net/
帐号信息
p573Ls http://blog.numino.net/
4、MEMB_STAT
LqSnjY http://blog.numino.net/
帐号状态
6uIJ2d http://blog.numino.net/
5、warehouse
90HpwG http://blog.numino.net/
仓库
CTP23E http://blog.numino.net/
6、VI_CURR_INFO
e5Sh1k http://blog.numino.net/
帐号费用
kgXhvr http://blog.numino.net/
7、WEB_ZS
9aAO67 http://blog.numino.net/
PL 网站的转生数据
4uXKq9 http://blog.numino.net/
二、各表说明
4iR7RN http://blog.numino.net/
1、AccountCharacter 表
4IuFfV http://blog.numino.net/
列名 类型 长 是否空 说明
KksstD http://blog.numino.net/
Number int 4 0 自动增加的序数
pXdpxC http://blog.numino.net/
Id varchar 10 0 帐号
ZTOOzW http://blog.numino.net/
GameID1 varchar 10 1 角色1
6r7Gq4 http://blog.numino.net/
GameID2 varchar 10 1 角色2
1oExBy http://blog.numino.net/
GameID3 varchar 10 1
nIUCla http://blog.numino.net/
GameID4 varchar 10 1
HUo5Q7 http://blog.numino.net/
GameID5 varchar 10 1
liRm1a http://blog.numino.net/
GameIDC varchar 10 1
i12N6e http://blog.numino.net/
2、Character 表
ee3TuT http://blog.numino.net/
列名 类型 长 是否空 说明
nzzlOj http://blog.numino.net/
AccountID varchar 10 0 --------帐号
qHxZNq http://blog.numino.net/
Name nvarchar 10 0 --------角色名
5MNCQk http://blog.numino.net/
cLevel smallint 2 1 --------等级
xxt50A http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
edyISC http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
kGsYtv http://blog.numino.net/
Experience int 4 1 --------经验
Pr5il0 http://blog.numino.net/
Strength smallint 2 1 --------力量
p6670t http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
Q0tFo3 http://blog.numino.net/
Vitality smallint 2 1 --------体力
hWCu3y http://blog.numino.net/
Energy smallint 2 1 --------智力
CtoyLt http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
d00S4Q http://blog.numino.net/
MagicList varbinary 60 1 --------技能
uy04PG http://blog.numino.net/
Money int 4 1 --------钱
vUDs0H http://blog.numino.net/
Life real 4 1 --------
M59Ln1 http://blog.numino.net/
MaxLife real 4 1 --------
GwML93 http://blog.numino.net/
Mana real 4 1 --------
cb615f http://blog.numino.net/
MaxMana real 4 1 --------
1t1sj6 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
Ghe8s3 http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
AGPdlJ http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
OvnB4r http://blog.numino.net/
MapDir tinyint 1 1 --------
2bV9XT http://blog.numino.net/
PkCount int 4 1 --------
EC4DU1 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
Jx5ols http://blog.numino.net/
PkTime int 4 1
V129uH http://blog.numino.net/
MDate smalldatetime 4 1
30KaLd http://blog.numino.net/
LDate smalldatetime 4 1
75lL87 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
0Ceh20 http://blog.numino.net/
DbVersion tinyint 1 1
OHg416 http://blog.numino.net/
Quest varbinary 50 1
7Ykxeq http://blog.numino.net/
LINZB bit 1 0
25H0FV http://blog.numino.net/
XDTIME datetime 8 0
LFM0m5 http://blog.numino.net/
STOPINFO nvarchar 100 1
zq1XUB http://blog.numino.net/
STOPTIME datetime 8 0
y1oKYc http://blog.numino.net/
zs_count int 4 1
0o8cit http://blog.numino.net/
zs_point int 4 1
DGwNr7 http://blog.numino.net/
bs_count int 4 1
4N7LkK http://blog.numino.net/
bs_point int 4 1
4I5tqu http://blog.numino.net/
shiji smalldatetime 4 1
3Yf9gO http://blog.numino.net/
banl nvarchar 10 1
PU6EWz http://blog.numino.net/
lv_time datetime 8 1
1XS3nZ http://blog.numino.net/
ex_ok int 4 1
mRpHE8 http://blog.numino.net/
ex_total int 4 1
7fDiWf http://blog.numino.net/
rb_count int 4 1
ioJE9I http://blog.numino.net/
rb_time datetime 8 1
XrMN89 http://blog.numino.net/
pz_time datetime 8 1
0wrx27 http://blog.numino.net/
3、MEMB_INFO
Y33yES http://blog.numino.net/
列名 类型 长 是否空 说明
TRlAhu http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
8Uf9XP http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
33dy65 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
xLYv6g http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
3i8lDU http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
IBX7dN http://blog.numino.net/
post_code nvarchar 6 1 --------1234
Qk9Vmt http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
aGZTjs http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
qRCyrK http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
z4sJPU http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
2l69NV http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
0U2bmP http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
V9ni3X http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
2W6UdB http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
MXkz7C http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
MTG9Br http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
cuwsuc http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
24pocj http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
Kf9ZQU http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
M5M765 http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
zImUc9 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
nbrD82 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
UCHpFV http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
g1LRo7 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
atvq5b http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
bx7Wpi http://blog.numino.net/
QX char 1 1 --------B
hmN0dG http://blog.numino.net/
JF int 4 0 --------0
G4uZFo http://blog.numino.net/
huiy int 4 1 --------0
izmBU8 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
eeCU4b http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
917OeT http://blog.numino.net/
FDB int 4 1 --------0
HfWX4p http://blog.numino.net/
vip tinyint 1 1 --------0
5Rx63k http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
YnOpEm http://blog.numino.net/
4、MEMB_STAT
8RM74F http://blog.numino.net/
列名 类型 长 是否空 说明
PtQKba http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
dQdj0D http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
GGqvcW http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
Y2O3sj http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
0l9Y7M http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
WKSolT http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
88B09a http://blog.numino.net/
5、warehouse
tcl4UW http://blog.numino.net/
列名 类型 长 是否空 说明
z2dTBd http://blog.numino.net/
AccountID varchar 10 0 --------帐号
F7LeI7 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
6YWqlP http://blog.numino.net/
Money int 4 1 --------钱
xqti2E http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
jmVJi6 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
1PPFgy http://blog.numino.net/
pw smallint 2 1 --------密码 0
8xZXd3 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
249ljA http://blog.numino.net/
ExtCKNum int 4 0 --------0
6jL44d http://blog.numino.net/
NeedExtCK int 4 0 --------0
4JDR5A http://blog.numino.net/
6、VI_CURR_INFO
24c0mB http://blog.numino.net/
列名 类型 长 是否空 说明
46ImuS http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
xYsIpt http://blog.numino.net/
chek_code nvarchar 1 0 --------1
E6GOe4 http://blog.numino.net/
used_time int 4 1 --------1234
PC5X71 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
ardu72 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
a93nE6 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
00k33Z http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
7DVy9O http://blog.numino.net/
Bill_Section int 4 1 --------6
d58YWP http://blog.numino.net/
Bill_Value int 4 1 --------3
3Mry8Q http://blog.numino.net/
Bill_Hour int 4 1 --------0
ohgp66 http://blog.numino.net/
Surplus_Point int 4 1 --------0
a76cKM http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
PwWJKB http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
NzHWF8 http://blog.numino.net/
7、WEB_ZS
2DwSMQ http://blog.numino.net/
列名 类型 长 是否空 说明
iff9Tx http://blog.numino.net/
ID bigint 8 0
8fg5kI http://blog.numino.net/
ACC char 10 1
YyPt4U http://blog.numino.net/
NAME char 10 1
918C79 http://blog.numino.net/
ZSTIME datetime 8 1
1tQC8V http://blog.numino.net/
ZSCLEVEL smallint 2 1
t38DZj http://blog.numino.net/
ZSCS smallint 2 0
APrt2u http://blog.numino.net/
CZCS smallint 2 0
5Ye1mg http://blog.numino.net/
CZTIME datetime 8 0
jv0b64 http://blog.numino.net/
ZJZSCS smallint 2 0
2QI93Z http://blog.numino.net/
GJZSCS smallint 2 0
cF6drT http://blog.numino.net/
CJZSCS smallint 2 0
9VrE4X http://blog.numino.net/
BSCS smallint 2 0
G80e0f http://blog.numino.net/
BSTIME datetime 8 0
ivFTUD http://blog.numino.net/
LEVELUPPOINT int 4 0
am39lI http://blog.numino.net/
GDDS int 4 0
|
|