| 奇迹muonline数据库基础库分析 |
一、表的组成：
baj1mD http://blog.numino.net/
1、AccountCharacter
Baeha1 http://blog.numino.net/
用来存放帐号的角色。
nAa8Qp http://blog.numino.net/
2、Character
t0KO6q http://blog.numino.net/
用来存放每个角色的详细数据。
A94U5i http://blog.numino.net/
3、MEMB_INFO
DddLi8 http://blog.numino.net/
帐号信息
mJj9zC http://blog.numino.net/
4、MEMB_STAT
TAu4md http://blog.numino.net/
帐号状态
Qx887i http://blog.numino.net/
5、warehouse
JGMq3U http://blog.numino.net/
仓库
MDpuC9 http://blog.numino.net/
6、VI_CURR_INFO
24S6ga http://blog.numino.net/
帐号费用
yQqIEW http://blog.numino.net/
7、WEB_ZS
CVsnFp http://blog.numino.net/
PL 网站的转生数据
w99KH4 http://blog.numino.net/
二、各表说明
VgRl62 http://blog.numino.net/
1、AccountCharacter 表
Ar12o1 http://blog.numino.net/
列名 类型 长 是否空 说明
24x47J http://blog.numino.net/
Number int 4 0 自动增加的序数
6fe8eN http://blog.numino.net/
Id varchar 10 0 帐号
naO10s http://blog.numino.net/
GameID1 varchar 10 1 角色1
5Couo4 http://blog.numino.net/
GameID2 varchar 10 1 角色2
U91tTR http://blog.numino.net/
GameID3 varchar 10 1
0cKZfp http://blog.numino.net/
GameID4 varchar 10 1
i676C2 http://blog.numino.net/
GameID5 varchar 10 1
hyPeZB http://blog.numino.net/
GameIDC varchar 10 1
w6niUi http://blog.numino.net/
2、Character 表
SL3KPh http://blog.numino.net/
列名 类型 长 是否空 说明
1JI8fC http://blog.numino.net/
AccountID varchar 10 0 --------帐号
99BAHX http://blog.numino.net/
Name nvarchar 10 0 --------角色名
am9Jhq http://blog.numino.net/
cLevel smallint 2 1 --------等级
XRvzqJ http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
W3qc6E http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
i5735G http://blog.numino.net/
Experience int 4 1 --------经验
TbhMtG http://blog.numino.net/
Strength smallint 2 1 --------力量
w2zLm9 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
O1OpYk http://blog.numino.net/
Vitality smallint 2 1 --------体力
3BwonF http://blog.numino.net/
Energy smallint 2 1 --------智力
wKeQ65 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
390H7y http://blog.numino.net/
MagicList varbinary 60 1 --------技能
8B8o8x http://blog.numino.net/
Money int 4 1 --------钱
IEkEv1 http://blog.numino.net/
Life real 4 1 --------
XBf4Vh http://blog.numino.net/
MaxLife real 4 1 --------
M6Z0c3 http://blog.numino.net/
Mana real 4 1 --------
T0jI4d http://blog.numino.net/
MaxMana real 4 1 --------
jYtuFT http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
vBWJh8 http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
Gltaro http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
IYEdpb http://blog.numino.net/
MapDir tinyint 1 1 --------
mDs991 http://blog.numino.net/
PkCount int 4 1 --------
71Y7i6 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
232k5s http://blog.numino.net/
PkTime int 4 1
t466zp http://blog.numino.net/
MDate smalldatetime 4 1
a4LK5L http://blog.numino.net/
LDate smalldatetime 4 1
wXoUsa http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
15yTJl http://blog.numino.net/
DbVersion tinyint 1 1
ANkid7 http://blog.numino.net/
Quest varbinary 50 1
Kg5Fk0 http://blog.numino.net/
LINZB bit 1 0
QNNJTL http://blog.numino.net/
XDTIME datetime 8 0
AmeASy http://blog.numino.net/
STOPINFO nvarchar 100 1
R0ml9u http://blog.numino.net/
STOPTIME datetime 8 0
nj9fLk http://blog.numino.net/
zs_count int 4 1
wOTIW3 http://blog.numino.net/
zs_point int 4 1
b61tSV http://blog.numino.net/
bs_count int 4 1
Vy5f53 http://blog.numino.net/
bs_point int 4 1
40VYlF http://blog.numino.net/
shiji smalldatetime 4 1
d91wym http://blog.numino.net/
banl nvarchar 10 1
85tDTC http://blog.numino.net/
lv_time datetime 8 1
RwxyNf http://blog.numino.net/
ex_ok int 4 1
oj7auT http://blog.numino.net/
ex_total int 4 1
xmyRbA http://blog.numino.net/
rb_count int 4 1
aW2Aq4 http://blog.numino.net/
rb_time datetime 8 1
jEBDBf http://blog.numino.net/
pz_time datetime 8 1
zlM8By http://blog.numino.net/
3、MEMB_INFO
15MQ6c http://blog.numino.net/
列名 类型 长 是否空 说明
b784VR http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
6H50Bw http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
crJyXc http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
k3v75e http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
8rv3cV http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
m9z4H5 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
8sq5yg http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
WG0h5U http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
bY7ZsI http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
O36h6r http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
4xnUQ4 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
954sU2 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
162gTb http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
53yh65 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
3V5DC9 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
fu8a8L http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
4n6LiV http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
mabCj5 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
3zb22k http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
3mZDxS http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
JB0xJy http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
CJ4hzk http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
Z7y5R4 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
2fM98u http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
1JgO2x http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
h3qP32 http://blog.numino.net/
QX char 1 1 --------B
lW5OpX http://blog.numino.net/
JF int 4 0 --------0
N609gO http://blog.numino.net/
huiy int 4 1 --------0
atJPa6 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
5t3Bvq http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
aJ4Dnm http://blog.numino.net/
FDB int 4 1 --------0
9gGQCr http://blog.numino.net/
vip tinyint 1 1 --------0
Po7QWX http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
t6J46x http://blog.numino.net/
4、MEMB_STAT
t9r3w0 http://blog.numino.net/
列名 类型 长 是否空 说明
QdR9S4 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Gq5K9f http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
yFvQNQ http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
4XhMSQ http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
Dge6xK http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
ojthH4 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
1SE6g4 http://blog.numino.net/
5、warehouse
12WaIu http://blog.numino.net/
列名 类型 长 是否空 说明
F82zp3 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
302FCp http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
dQm9zR http://blog.numino.net/
Money int 4 1 --------钱
Z29Cye http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
ZxcK4N http://blog.numino.net/
DbVersion tinyint 1 1 --------1
heIery http://blog.numino.net/
pw smallint 2 1 --------密码 0
PjC316 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
lQ4hKn http://blog.numino.net/
ExtCKNum int 4 0 --------0
Tfu7GC http://blog.numino.net/
NeedExtCK int 4 0 --------0
a79VlE http://blog.numino.net/
6、VI_CURR_INFO
ZPBh4G http://blog.numino.net/
列名 类型 长 是否空 说明
IZMwRf http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
3v5WtS http://blog.numino.net/
chek_code nvarchar 1 0 --------1
5IlVQN http://blog.numino.net/
used_time int 4 1 --------1234
LG7J7q http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
K11LfR http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
Dfd86w http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
BgeDIY http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
LV3x5C http://blog.numino.net/
Bill_Section int 4 1 --------6
2A4au2 http://blog.numino.net/
Bill_Value int 4 1 --------3
uB4Je0 http://blog.numino.net/
Bill_Hour int 4 1 --------0
TZPd0m http://blog.numino.net/
Surplus_Point int 4 1 --------0
sI67D9 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
X7uJ4X http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
VGT1gc http://blog.numino.net/
7、WEB_ZS
9e0B2e http://blog.numino.net/
列名 类型 长 是否空 说明
7mIwZc http://blog.numino.net/
ID bigint 8 0
k7lkxl http://blog.numino.net/
ACC char 10 1
9Gw60h http://blog.numino.net/
NAME char 10 1
D6427t http://blog.numino.net/
ZSTIME datetime 8 1
X3nazr http://blog.numino.net/
ZSCLEVEL smallint 2 1
k49A65 http://blog.numino.net/
ZSCS smallint 2 0
cG17W7 http://blog.numino.net/
CZCS smallint 2 0
t11m4t http://blog.numino.net/
CZTIME datetime 8 0
o5PTb3 http://blog.numino.net/
ZJZSCS smallint 2 0
3jYNKX http://blog.numino.net/
GJZSCS smallint 2 0
Ekl4Lr http://blog.numino.net/
CJZSCS smallint 2 0
fBC22Y http://blog.numino.net/
BSCS smallint 2 0
pbEVPz http://blog.numino.net/
BSTIME datetime 8 0
yRDnRF http://blog.numino.net/
LEVELUPPOINT int 4 0
cAo934 http://blog.numino.net/
GDDS int 4 0
|
|