| 奇迹muonline数据库基础库分析 |
一、表的组成：
34Yx8B http://blog.numino.net/
1、AccountCharacter
PeFvaJ http://blog.numino.net/
用来存放帐号的角色。
Pe3v1q http://blog.numino.net/
2、Character
7B8Y50 http://blog.numino.net/
用来存放每个角色的详细数据。
zO7mj5 http://blog.numino.net/
3、MEMB_INFO
6MnU47 http://blog.numino.net/
帐号信息
6hN4zw http://blog.numino.net/
4、MEMB_STAT
0on6Eh http://blog.numino.net/
帐号状态
FXKHr6 http://blog.numino.net/
5、warehouse
zGYK22 http://blog.numino.net/
仓库
tP39CU http://blog.numino.net/
6、VI_CURR_INFO
3Pqvvp http://blog.numino.net/
帐号费用
9S0N0R http://blog.numino.net/
7、WEB_ZS
hD9Q1N http://blog.numino.net/
PL 网站的转生数据
6BxjQH http://blog.numino.net/
二、各表说明
4Io2bn http://blog.numino.net/
1、AccountCharacter 表
iVgJYH http://blog.numino.net/
列名 类型 长 是否空 说明
Am117U http://blog.numino.net/
Number int 4 0 自动增加的序数
X3C4Qz http://blog.numino.net/
Id varchar 10 0 帐号
cl3Q5X http://blog.numino.net/
GameID1 varchar 10 1 角色1
7E58G9 http://blog.numino.net/
GameID2 varchar 10 1 角色2
tM15x9 http://blog.numino.net/
GameID3 varchar 10 1
JcmqvQ http://blog.numino.net/
GameID4 varchar 10 1
6cwbrp http://blog.numino.net/
GameID5 varchar 10 1
31KMkC http://blog.numino.net/
GameIDC varchar 10 1
xJ7sZJ http://blog.numino.net/
2、Character 表
NkT9UI http://blog.numino.net/
列名 类型 长 是否空 说明
fDd8hQ http://blog.numino.net/
AccountID varchar 10 0 --------帐号
cW296Z http://blog.numino.net/
Name nvarchar 10 0 --------角色名
j9y174 http://blog.numino.net/
cLevel smallint 2 1 --------等级
JHwFtg http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
RU0Pmw http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
Aw84va http://blog.numino.net/
Experience int 4 1 --------经验
mSrQjK http://blog.numino.net/
Strength smallint 2 1 --------力量
47MEcd http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
32Cxfo http://blog.numino.net/
Vitality smallint 2 1 --------体力
IImIIl http://blog.numino.net/
Energy smallint 2 1 --------智力
NtiHl6 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
Uu4c8k http://blog.numino.net/
MagicList varbinary 60 1 --------技能
n9tJtM http://blog.numino.net/
Money int 4 1 --------钱
00cpmL http://blog.numino.net/
Life real 4 1 --------
R6TtbX http://blog.numino.net/
MaxLife real 4 1 --------
o4nCcA http://blog.numino.net/
Mana real 4 1 --------
Y5ICOB http://blog.numino.net/
MaxMana real 4 1 --------
Kr5TFy http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
7K5Y8G http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
CBxj86 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
4YeoE5 http://blog.numino.net/
MapDir tinyint 1 1 --------
xUzR1Z http://blog.numino.net/
PkCount int 4 1 --------
avq6x6 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
JB4073 http://blog.numino.net/
PkTime int 4 1
34CgZ2 http://blog.numino.net/
MDate smalldatetime 4 1
NuRwTJ http://blog.numino.net/
LDate smalldatetime 4 1
77Tctx http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
79xEd8 http://blog.numino.net/
DbVersion tinyint 1 1
7j2va7 http://blog.numino.net/
Quest varbinary 50 1
P3nAOq http://blog.numino.net/
LINZB bit 1 0
E7ZLJq http://blog.numino.net/
XDTIME datetime 8 0
k7G3H8 http://blog.numino.net/
STOPINFO nvarchar 100 1
nwgW7E http://blog.numino.net/
STOPTIME datetime 8 0
5YBY84 http://blog.numino.net/
zs_count int 4 1
a9vd7P http://blog.numino.net/
zs_point int 4 1
csPt6s http://blog.numino.net/
bs_count int 4 1
IKBAgI http://blog.numino.net/
bs_point int 4 1
GQfx8R http://blog.numino.net/
shiji smalldatetime 4 1
XhPful http://blog.numino.net/
banl nvarchar 10 1
66ICI8 http://blog.numino.net/
lv_time datetime 8 1
yA5wBv http://blog.numino.net/
ex_ok int 4 1
rmCDYQ http://blog.numino.net/
ex_total int 4 1
ht80f0 http://blog.numino.net/
rb_count int 4 1
kHktI6 http://blog.numino.net/
rb_time datetime 8 1
y1f48n http://blog.numino.net/
pz_time datetime 8 1
5JA5IP http://blog.numino.net/
3、MEMB_INFO
664313 http://blog.numino.net/
列名 类型 长 是否空 说明
9ji2fz http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
dF0nF2 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
QF4fqc http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
oMwyGq http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
Iclw2Z http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
8a7TYh http://blog.numino.net/
post_code nvarchar 6 1 --------1234
a6pc9F http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
0e1Y8T http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
7Gf2OK http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
4v0e45 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
yNXX9w http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
m7F9g4 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
zhh7WM http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
cL6goC http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
O93AQ9 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
Qbi5Ev http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
9edAag http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
f1kcHm http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
LQw32z http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
yZKokJ http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
r0OIbb http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
s3murF http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
kka25C http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
L7D50H http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
dt84yw http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
0bRvjM http://blog.numino.net/
QX char 1 1 --------B
1yew77 http://blog.numino.net/
JF int 4 0 --------0
VM4ru6 http://blog.numino.net/
huiy int 4 1 --------0
0PW9Mo http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
v4ioFX http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
8uOe5D http://blog.numino.net/
FDB int 4 1 --------0
iJtIB9 http://blog.numino.net/
vip tinyint 1 1 --------0
3l8dXM http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
EhnLs7 http://blog.numino.net/
4、MEMB_STAT
D3b9mh http://blog.numino.net/
列名 类型 长 是否空 说明
HNX6dj http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
U3bpKP http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
Zt6tn1 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
sCm1DI http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
69S52j http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
ok99SF http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
W3XzqN http://blog.numino.net/
5、warehouse
JvUf38 http://blog.numino.net/
列名 类型 长 是否空 说明
fo86bH http://blog.numino.net/
AccountID varchar 10 0 --------帐号
sH2DX0 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
hDlBxC http://blog.numino.net/
Money int 4 1 --------钱
f7xH8u http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
EQdWgG http://blog.numino.net/
DbVersion tinyint 1 1 --------1
67EGz4 http://blog.numino.net/
pw smallint 2 1 --------密码 0
Lz2jlw http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
Sa18h7 http://blog.numino.net/
ExtCKNum int 4 0 --------0
8vcEfJ http://blog.numino.net/
NeedExtCK int 4 0 --------0
1H5bZ1 http://blog.numino.net/
6、VI_CURR_INFO
G2NpKp http://blog.numino.net/
列名 类型 长 是否空 说明
u1Vbpx http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
7PvnjZ http://blog.numino.net/
chek_code nvarchar 1 0 --------1
THihT0 http://blog.numino.net/
used_time int 4 1 --------1234
xEME42 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
3vAT69 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
Guxbdj http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
aC74rK http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
9TzKWh http://blog.numino.net/
Bill_Section int 4 1 --------6
r5mRkP http://blog.numino.net/
Bill_Value int 4 1 --------3
D3OXWB http://blog.numino.net/
Bill_Hour int 4 1 --------0
7EDKl2 http://blog.numino.net/
Surplus_Point int 4 1 --------0
dBrEae http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
kEXJO2 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
04g7U5 http://blog.numino.net/
7、WEB_ZS
7ifRA4 http://blog.numino.net/
列名 类型 长 是否空 说明
u5FKey http://blog.numino.net/
ID bigint 8 0
77C6RR http://blog.numino.net/
ACC char 10 1
Rr0UOO http://blog.numino.net/
NAME char 10 1
SwdAz5 http://blog.numino.net/
ZSTIME datetime 8 1
DOzzKo http://blog.numino.net/
ZSCLEVEL smallint 2 1
M2FZMr http://blog.numino.net/
ZSCS smallint 2 0
NpNiZ6 http://blog.numino.net/
CZCS smallint 2 0
PI38tT http://blog.numino.net/
CZTIME datetime 8 0
OcUQxp http://blog.numino.net/
ZJZSCS smallint 2 0
juem16 http://blog.numino.net/
GJZSCS smallint 2 0
mM561f http://blog.numino.net/
CJZSCS smallint 2 0
W43qPK http://blog.numino.net/
BSCS smallint 2 0
wFIOgR http://blog.numino.net/
BSTIME datetime 8 0
ly1hQR http://blog.numino.net/
LEVELUPPOINT int 4 0
FF2654 http://blog.numino.net/
GDDS int 4 0
|
|