| 奇迹muonline数据库基础库分析 |
一、表的组成：
5u4Crt http://blog.numino.net/
1、AccountCharacter
cK6N8K http://blog.numino.net/
用来存放帐号的角色。
4jTk7m http://blog.numino.net/
2、Character
FJxbt3 http://blog.numino.net/
用来存放每个角色的详细数据。
Mep39g http://blog.numino.net/
3、MEMB_INFO
7If60R http://blog.numino.net/
帐号信息
Wq8zvF http://blog.numino.net/
4、MEMB_STAT
u6iU5y http://blog.numino.net/
帐号状态
MY9GDk http://blog.numino.net/
5、warehouse
mXV1eB http://blog.numino.net/
仓库
TMJyLC http://blog.numino.net/
6、VI_CURR_INFO
rL43Rs http://blog.numino.net/
帐号费用
oBpJuu http://blog.numino.net/
7、WEB_ZS
eIzmMJ http://blog.numino.net/
PL 网站的转生数据
aAtTB8 http://blog.numino.net/
二、各表说明
686guH http://blog.numino.net/
1、AccountCharacter 表
YUsbZh http://blog.numino.net/
列名 类型 长 是否空 说明
t8C3OY http://blog.numino.net/
Number int 4 0 自动增加的序数
ocFM0l http://blog.numino.net/
Id varchar 10 0 帐号
6uNw2j http://blog.numino.net/
GameID1 varchar 10 1 角色1
tc0haO http://blog.numino.net/
GameID2 varchar 10 1 角色2
jSx1f9 http://blog.numino.net/
GameID3 varchar 10 1
jol63r http://blog.numino.net/
GameID4 varchar 10 1
TQzOLk http://blog.numino.net/
GameID5 varchar 10 1
Eewice http://blog.numino.net/
GameIDC varchar 10 1
tc2x3n http://blog.numino.net/
2、Character 表
59pmY0 http://blog.numino.net/
列名 类型 长 是否空 说明
C0iv70 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
C0yy7B http://blog.numino.net/
Name nvarchar 10 0 --------角色名
1x3XZx http://blog.numino.net/
cLevel smallint 2 1 --------等级
X3xyQe http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
TbnE9k http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
09XGXT http://blog.numino.net/
Experience int 4 1 --------经验
LDSqT8 http://blog.numino.net/
Strength smallint 2 1 --------力量
8o4rNo http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
8Ez61d http://blog.numino.net/
Vitality smallint 2 1 --------体力
dLjiJT http://blog.numino.net/
Energy smallint 2 1 --------智力
1r6J6B http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
9um3gm http://blog.numino.net/
MagicList varbinary 60 1 --------技能
Qjj8Lv http://blog.numino.net/
Money int 4 1 --------钱
kuLzsi http://blog.numino.net/
Life real 4 1 --------
XMhHAS http://blog.numino.net/
MaxLife real 4 1 --------
mv4SIs http://blog.numino.net/
Mana real 4 1 --------
CYglWY http://blog.numino.net/
MaxMana real 4 1 --------
5Y5aRN http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
KkHHIq http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
0CdPaZ http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
s0KJLq http://blog.numino.net/
MapDir tinyint 1 1 --------
6rMzQj http://blog.numino.net/
PkCount int 4 1 --------
91EL3V http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
qPAgRE http://blog.numino.net/
PkTime int 4 1
k3aW2W http://blog.numino.net/
MDate smalldatetime 4 1
Y3Seb0 http://blog.numino.net/
LDate smalldatetime 4 1
9lzH43 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
pmjjjm http://blog.numino.net/
DbVersion tinyint 1 1
H4r1jq http://blog.numino.net/
Quest varbinary 50 1
fFjcPk http://blog.numino.net/
LINZB bit 1 0
szlPyc http://blog.numino.net/
XDTIME datetime 8 0
246y11 http://blog.numino.net/
STOPINFO nvarchar 100 1
xcon35 http://blog.numino.net/
STOPTIME datetime 8 0
aOvuGn http://blog.numino.net/
zs_count int 4 1
nveoYU http://blog.numino.net/
zs_point int 4 1
khNTVY http://blog.numino.net/
bs_count int 4 1
vnQ61F http://blog.numino.net/
bs_point int 4 1
7g95Tw http://blog.numino.net/
shiji smalldatetime 4 1
hdZJ07 http://blog.numino.net/
banl nvarchar 10 1
HTzJdN http://blog.numino.net/
lv_time datetime 8 1
SNqoWZ http://blog.numino.net/
ex_ok int 4 1
j9kY7L http://blog.numino.net/
ex_total int 4 1
6jIvSe http://blog.numino.net/
rb_count int 4 1
932A4m http://blog.numino.net/
rb_time datetime 8 1
gtOQob http://blog.numino.net/
pz_time datetime 8 1
We83aU http://blog.numino.net/
3、MEMB_INFO
qNB3Pv http://blog.numino.net/
列名 类型 长 是否空 说明
8UMPrH http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
8UGR6J http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
PiAvMf http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
92MJ6R http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
Q6MinD http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
i3132c http://blog.numino.net/
post_code nvarchar 6 1 --------1234
WxE19w http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
7x8Z13 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
bZwH4X http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
yX7Z4i http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
2IqUK3 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
0Pmin8 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
O3UZhT http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
6yuSXh http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
4VlTt9 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
i5ReMJ http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
ex18RO http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
AEH98K http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
qp7kO5 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
4rS3gA http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
PCyX0D http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
Ntix5h http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
X5BPRw http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
uwmU0I http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
K1TfRq http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
yEHB33 http://blog.numino.net/
QX char 1 1 --------B
ohFhoZ http://blog.numino.net/
JF int 4 0 --------0
JzOTlH http://blog.numino.net/
huiy int 4 1 --------0
xCYXKc http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
WS83nG http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
mr7Ily http://blog.numino.net/
FDB int 4 1 --------0
mGV8k0 http://blog.numino.net/
vip tinyint 1 1 --------0
Kg88R9 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
uffljc http://blog.numino.net/
4、MEMB_STAT
34cKgJ http://blog.numino.net/
列名 类型 长 是否空 说明
54J8fF http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
0aLjUk http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
m9WgJ3 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
YA2kPO http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
059lUz http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
oy43b5 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
mUylnr http://blog.numino.net/
5、warehouse
ReBV0T http://blog.numino.net/
列名 类型 长 是否空 说明
s7tKxX http://blog.numino.net/
AccountID varchar 10 0 --------帐号
GfW7zX http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
yT99dC http://blog.numino.net/
Money int 4 1 --------钱
eHxZI8 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
kNA342 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
IjmtU0 http://blog.numino.net/
pw smallint 2 1 --------密码 0
48g09r http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
yWltdT http://blog.numino.net/
ExtCKNum int 4 0 --------0
vYRzCn http://blog.numino.net/
NeedExtCK int 4 0 --------0
X6xS90 http://blog.numino.net/
6、VI_CURR_INFO
QxJ72T http://blog.numino.net/
列名 类型 长 是否空 说明
Vl7U10 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
x18Ck3 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
p712Dd http://blog.numino.net/
used_time int 4 1 --------1234
H97246 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
y9d26X http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
LMsBa2 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
b2bjqI http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
xADu2I http://blog.numino.net/
Bill_Section int 4 1 --------6
NSp74m http://blog.numino.net/
Bill_Value int 4 1 --------3
KB0ZX4 http://blog.numino.net/
Bill_Hour int 4 1 --------0
Cpq4TG http://blog.numino.net/
Surplus_Point int 4 1 --------0
lG9Kl0 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
VhhvCT http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
6ZW1Gm http://blog.numino.net/
7、WEB_ZS
aG6nDr http://blog.numino.net/
列名 类型 长 是否空 说明
y23pT8 http://blog.numino.net/
ID bigint 8 0
OTuzlP http://blog.numino.net/
ACC char 10 1
urKNr0 http://blog.numino.net/
NAME char 10 1
U0rioF http://blog.numino.net/
ZSTIME datetime 8 1
h296zk http://blog.numino.net/
ZSCLEVEL smallint 2 1
qBg6NE http://blog.numino.net/
ZSCS smallint 2 0
MHi52x http://blog.numino.net/
CZCS smallint 2 0
8y7Wx2 http://blog.numino.net/
CZTIME datetime 8 0
LC0YYe http://blog.numino.net/
ZJZSCS smallint 2 0
zrd7Ws http://blog.numino.net/
GJZSCS smallint 2 0
5X8q29 http://blog.numino.net/
CJZSCS smallint 2 0
VtKmCh http://blog.numino.net/
BSCS smallint 2 0
Q2Pmw0 http://blog.numino.net/
BSTIME datetime 8 0
h97437 http://blog.numino.net/
LEVELUPPOINT int 4 0
7XAsiO http://blog.numino.net/
GDDS int 4 0
|
|