| 奇迹muonline数据库基础库分析 |
一、表的组成：
86Ag85 http://blog.numino.net/
1、AccountCharacter
R2y497 http://blog.numino.net/
用来存放帐号的角色。
t4s36r http://blog.numino.net/
2、Character
cFXGPD http://blog.numino.net/
用来存放每个角色的详细数据。
jb8KA1 http://blog.numino.net/
3、MEMB_INFO
m431Gh http://blog.numino.net/
帐号信息
AGerm7 http://blog.numino.net/
4、MEMB_STAT
idaymO http://blog.numino.net/
帐号状态
mT1hvf http://blog.numino.net/
5、warehouse
e1xuFg http://blog.numino.net/
仓库
F9PXJI http://blog.numino.net/
6、VI_CURR_INFO
1OPEtY http://blog.numino.net/
帐号费用
zMZgj4 http://blog.numino.net/
7、WEB_ZS
mb00zD http://blog.numino.net/
PL 网站的转生数据
1XeRrf http://blog.numino.net/
二、各表说明
sWDiiM http://blog.numino.net/
1、AccountCharacter 表
mZ48cU http://blog.numino.net/
列名 类型 长 是否空 说明
H2CY7v http://blog.numino.net/
Number int 4 0 自动增加的序数
o805Et http://blog.numino.net/
Id varchar 10 0 帐号
LK489m http://blog.numino.net/
GameID1 varchar 10 1 角色1
l6kuEE http://blog.numino.net/
GameID2 varchar 10 1 角色2
G9Bbyn http://blog.numino.net/
GameID3 varchar 10 1
IbO4u9 http://blog.numino.net/
GameID4 varchar 10 1
SQQ35Z http://blog.numino.net/
GameID5 varchar 10 1
9y2634 http://blog.numino.net/
GameIDC varchar 10 1
U51y80 http://blog.numino.net/
2、Character 表
al1w2S http://blog.numino.net/
列名 类型 长 是否空 说明
47a7n1 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
0jxhng http://blog.numino.net/
Name nvarchar 10 0 --------角色名
TY5VJ3 http://blog.numino.net/
cLevel smallint 2 1 --------等级
qNtjhl http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
BON49G http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
S6xw02 http://blog.numino.net/
Experience int 4 1 --------经验
2lVN4H http://blog.numino.net/
Strength smallint 2 1 --------力量
ssD38d http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
WI8vhm http://blog.numino.net/
Vitality smallint 2 1 --------体力
3mo5vK http://blog.numino.net/
Energy smallint 2 1 --------智力
QWSETn http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
YGxOxG http://blog.numino.net/
MagicList varbinary 60 1 --------技能
NfH2S7 http://blog.numino.net/
Money int 4 1 --------钱
GrGcmN http://blog.numino.net/
Life real 4 1 --------
k3IE8w http://blog.numino.net/
MaxLife real 4 1 --------
2rm3ef http://blog.numino.net/
Mana real 4 1 --------
3MzQHr http://blog.numino.net/
MaxMana real 4 1 --------
SVbAXt http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
1j6tye http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
emVI1z http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
9Pl297 http://blog.numino.net/
MapDir tinyint 1 1 --------
04WmKf http://blog.numino.net/
PkCount int 4 1 --------
be1o02 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
989PNM http://blog.numino.net/
PkTime int 4 1
C89jwk http://blog.numino.net/
MDate smalldatetime 4 1
UZSM7W http://blog.numino.net/
LDate smalldatetime 4 1
K2bV1n http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
SfJuX7 http://blog.numino.net/
DbVersion tinyint 1 1
9RdEw6 http://blog.numino.net/
Quest varbinary 50 1
Rgchod http://blog.numino.net/
LINZB bit 1 0
5x41Bc http://blog.numino.net/
XDTIME datetime 8 0
F9j5MV http://blog.numino.net/
STOPINFO nvarchar 100 1
WcCK1Z http://blog.numino.net/
STOPTIME datetime 8 0
nKITi7 http://blog.numino.net/
zs_count int 4 1
pAn37z http://blog.numino.net/
zs_point int 4 1
48sUu3 http://blog.numino.net/
bs_count int 4 1
ufP56A http://blog.numino.net/
bs_point int 4 1
cwbz1U http://blog.numino.net/
shiji smalldatetime 4 1
vI8l52 http://blog.numino.net/
banl nvarchar 10 1
8U6QMm http://blog.numino.net/
lv_time datetime 8 1
ym2t48 http://blog.numino.net/
ex_ok int 4 1
R9OD29 http://blog.numino.net/
ex_total int 4 1
7OGqSx http://blog.numino.net/
rb_count int 4 1
lkjHpC http://blog.numino.net/
rb_time datetime 8 1
Dmz8A7 http://blog.numino.net/
pz_time datetime 8 1
er47O9 http://blog.numino.net/
3、MEMB_INFO
RgEbD0 http://blog.numino.net/
列名 类型 长 是否空 说明
x4m1WP http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
kP95ev http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
17L6Hm http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
G3tWKE http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
Y7Le6f http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
hXWvSk http://blog.numino.net/
post_code nvarchar 6 1 --------1234
U61r9A http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
jefNbT http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
R25kph http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
rlXOOY http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
j945Dj http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
ECGteK http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
09NOkz http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
BXwaAc http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
445wPB http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
aQTfBn http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
IqRsJR http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
urw5yV http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
bVq7qJ http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
mLMDgL http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
UPpDVt http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
KVgw39 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
fq8ijW http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
7jUDWP http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
2q3ZH8 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
mUGJX6 http://blog.numino.net/
QX char 1 1 --------B
46L4rt http://blog.numino.net/
JF int 4 0 --------0
g196rl http://blog.numino.net/
huiy int 4 1 --------0
4b51A8 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
EqzpyC http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
h1bmar http://blog.numino.net/
FDB int 4 1 --------0
5nv28v http://blog.numino.net/
vip tinyint 1 1 --------0
8iqEAQ http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
NN4D93 http://blog.numino.net/
4、MEMB_STAT
xK0JP5 http://blog.numino.net/
列名 类型 长 是否空 说明
M5Gw61 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
3EOQCy http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
FrmDo2 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
lchn1d http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
6awr6G http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
oa3H6R http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
V5K7Zz http://blog.numino.net/
5、warehouse
qxx17K http://blog.numino.net/
列名 类型 长 是否空 说明
sBc69T http://blog.numino.net/
AccountID varchar 10 0 --------帐号
AEtHI6 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
Ip7veM http://blog.numino.net/
Money int 4 1 --------钱
jg4ew7 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
7L789i http://blog.numino.net/
DbVersion tinyint 1 1 --------1
Mp0XNi http://blog.numino.net/
pw smallint 2 1 --------密码 0
dPUdkM http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
9h2oua http://blog.numino.net/
ExtCKNum int 4 0 --------0
FBmekd http://blog.numino.net/
NeedExtCK int 4 0 --------0
41vM99 http://blog.numino.net/
6、VI_CURR_INFO
P513XE http://blog.numino.net/
列名 类型 长 是否空 说明
9y4IsF http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
ZLq9Nx http://blog.numino.net/
chek_code nvarchar 1 0 --------1
pYH8Yj http://blog.numino.net/
used_time int 4 1 --------1234
CWNmOa http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Xbnira http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
uP7H4B http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
0Zd3jC http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
FlX1My http://blog.numino.net/
Bill_Section int 4 1 --------6
82rR4J http://blog.numino.net/
Bill_Value int 4 1 --------3
Yeo9Ya http://blog.numino.net/
Bill_Hour int 4 1 --------0
r8jj65 http://blog.numino.net/
Surplus_Point int 4 1 --------0
KOBXjL http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
nrIbgx http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
GmOQ2R http://blog.numino.net/
7、WEB_ZS
C63JZT http://blog.numino.net/
列名 类型 长 是否空 说明
MiE0tY http://blog.numino.net/
ID bigint 8 0
zU9oY1 http://blog.numino.net/
ACC char 10 1
N3gzjx http://blog.numino.net/
NAME char 10 1
fn4R9k http://blog.numino.net/
ZSTIME datetime 8 1
bOi05d http://blog.numino.net/
ZSCLEVEL smallint 2 1
1190fy http://blog.numino.net/
ZSCS smallint 2 0
CTe52x http://blog.numino.net/
CZCS smallint 2 0
aSMc1r http://blog.numino.net/
CZTIME datetime 8 0
HL5JHK http://blog.numino.net/
ZJZSCS smallint 2 0
DfYlFx http://blog.numino.net/
GJZSCS smallint 2 0
Rm1nAP http://blog.numino.net/
CJZSCS smallint 2 0
7TUpMi http://blog.numino.net/
BSCS smallint 2 0
gp8bLi http://blog.numino.net/
BSTIME datetime 8 0
9B4TOH http://blog.numino.net/
LEVELUPPOINT int 4 0
dhyEP2 http://blog.numino.net/
GDDS int 4 0
|
|