| 奇迹muonline数据库基础库分析 |
一、表的组成：
WNKsmZ http://blog.numino.net/
1、AccountCharacter
6rMkbp http://blog.numino.net/
用来存放帐号的角色。
w1RUti http://blog.numino.net/
2、Character
nr1ek8 http://blog.numino.net/
用来存放每个角色的详细数据。
882kno http://blog.numino.net/
3、MEMB_INFO
Ep8cY0 http://blog.numino.net/
帐号信息
s2t445 http://blog.numino.net/
4、MEMB_STAT
2IPtAO http://blog.numino.net/
帐号状态
sE51UI http://blog.numino.net/
5、warehouse
o7ZHCG http://blog.numino.net/
仓库
21xrs4 http://blog.numino.net/
6、VI_CURR_INFO
wh1TUd http://blog.numino.net/
帐号费用
2W0ISx http://blog.numino.net/
7、WEB_ZS
43I5qh http://blog.numino.net/
PL 网站的转生数据
7flO4H http://blog.numino.net/
二、各表说明
UqH1u3 http://blog.numino.net/
1、AccountCharacter 表
2zMrxN http://blog.numino.net/
列名 类型 长 是否空 说明
XiT32i http://blog.numino.net/
Number int 4 0 自动增加的序数
804IDv http://blog.numino.net/
Id varchar 10 0 帐号
SthB60 http://blog.numino.net/
GameID1 varchar 10 1 角色1
LDfjUt http://blog.numino.net/
GameID2 varchar 10 1 角色2
PXkqyB http://blog.numino.net/
GameID3 varchar 10 1
pb2U7t http://blog.numino.net/
GameID4 varchar 10 1
U6CbK9 http://blog.numino.net/
GameID5 varchar 10 1
ZYllKo http://blog.numino.net/
GameIDC varchar 10 1
9cEN9b http://blog.numino.net/
2、Character 表
YRVRj6 http://blog.numino.net/
列名 类型 长 是否空 说明
6cj8fK http://blog.numino.net/
AccountID varchar 10 0 --------帐号
dx5z67 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
xLkxnZ http://blog.numino.net/
cLevel smallint 2 1 --------等级
y9S4P9 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
DoM0m2 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
3aMV7X http://blog.numino.net/
Experience int 4 1 --------经验
HpvjKt http://blog.numino.net/
Strength smallint 2 1 --------力量
7EM2Qa http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
19h59x http://blog.numino.net/
Vitality smallint 2 1 --------体力
Ld9BRl http://blog.numino.net/
Energy smallint 2 1 --------智力
fZx90U http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
YAktRO http://blog.numino.net/
MagicList varbinary 60 1 --------技能
RMQvsj http://blog.numino.net/
Money int 4 1 --------钱
l9oeeo http://blog.numino.net/
Life real 4 1 --------
3aLLuu http://blog.numino.net/
MaxLife real 4 1 --------
hZnqDF http://blog.numino.net/
Mana real 4 1 --------
H1814X http://blog.numino.net/
MaxMana real 4 1 --------
6H322h http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
O8k0eU http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
Aer54Y http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
hYTH7K http://blog.numino.net/
MapDir tinyint 1 1 --------
w82mbx http://blog.numino.net/
PkCount int 4 1 --------
wUKJxO http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
w6Nx23 http://blog.numino.net/
PkTime int 4 1
C85ZbG http://blog.numino.net/
MDate smalldatetime 4 1
RNJQm9 http://blog.numino.net/
LDate smalldatetime 4 1
2UZ9GV http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
3Fk3h6 http://blog.numino.net/
DbVersion tinyint 1 1
D438fI http://blog.numino.net/
Quest varbinary 50 1
smqUsF http://blog.numino.net/
LINZB bit 1 0
uRIRr7 http://blog.numino.net/
XDTIME datetime 8 0
r5YP1D http://blog.numino.net/
STOPINFO nvarchar 100 1
8KCY14 http://blog.numino.net/
STOPTIME datetime 8 0
x9e694 http://blog.numino.net/
zs_count int 4 1
8zLn42 http://blog.numino.net/
zs_point int 4 1
73HKKD http://blog.numino.net/
bs_count int 4 1
HJTlS5 http://blog.numino.net/
bs_point int 4 1
0xrp58 http://blog.numino.net/
shiji smalldatetime 4 1
X94oMx http://blog.numino.net/
banl nvarchar 10 1
uL2ols http://blog.numino.net/
lv_time datetime 8 1
01TIOl http://blog.numino.net/
ex_ok int 4 1
W4oI2R http://blog.numino.net/
ex_total int 4 1
5n1260 http://blog.numino.net/
rb_count int 4 1
H929c9 http://blog.numino.net/
rb_time datetime 8 1
0l8tnt http://blog.numino.net/
pz_time datetime 8 1
3ZyrPn http://blog.numino.net/
3、MEMB_INFO
YRC1UH http://blog.numino.net/
列名 类型 长 是否空 说明
3g29ge http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
RPqf6C http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
qYbi11 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
xzIIyz http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
32qPS6 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
Feqy83 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
2h87kp http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
qCLxF6 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
cWzvVc http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
s0oyC4 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
YGLR9L http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
Hf9dMi http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
3EEnNz http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
lJUKWw http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
029BxO http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
OxV9PG http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
Oycrdj http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Icq4ps http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
WK9HOn http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
N37WSO http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
SI1UY5 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
uHG41F http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
RnL5bq http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
CfH1ZT http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
u6allV http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
FjsvQ7 http://blog.numino.net/
QX char 1 1 --------B
rs0ILm http://blog.numino.net/
JF int 4 0 --------0
A45NNh http://blog.numino.net/
huiy int 4 1 --------0
0F7Wz4 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
5QnAyX http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
aYKbY0 http://blog.numino.net/
FDB int 4 1 --------0
2xBO7C http://blog.numino.net/
vip tinyint 1 1 --------0
zziUT4 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
sB8xiE http://blog.numino.net/
4、MEMB_STAT
lLbZpB http://blog.numino.net/
列名 类型 长 是否空 说明
yzMAm2 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
wszeuA http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
VvM1H3 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
99guSv http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
uXs9G1 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
S3PV18 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
7E4T1b http://blog.numino.net/
5、warehouse
ShEs9z http://blog.numino.net/
列名 类型 长 是否空 说明
6s7Fln http://blog.numino.net/
AccountID varchar 10 0 --------帐号
xtCP3y http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
oT4UzX http://blog.numino.net/
Money int 4 1 --------钱
c85i2K http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
Q7U2j6 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
b0oJ2a http://blog.numino.net/
pw smallint 2 1 --------密码 0
yFM2IQ http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
ZbVUNI http://blog.numino.net/
ExtCKNum int 4 0 --------0
nkin64 http://blog.numino.net/
NeedExtCK int 4 0 --------0
wHn3LV http://blog.numino.net/
6、VI_CURR_INFO
j86TMl http://blog.numino.net/
列名 类型 长 是否空 说明
P0Gk7r http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
wvSefE http://blog.numino.net/
chek_code nvarchar 1 0 --------1
9q2Faf http://blog.numino.net/
used_time int 4 1 --------1234
NbpaaB http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
bZ29As http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
pQ602C http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
3cWdB3 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
L5Da8B http://blog.numino.net/
Bill_Section int 4 1 --------6
cozsFH http://blog.numino.net/
Bill_Value int 4 1 --------3
UAN0vN http://blog.numino.net/
Bill_Hour int 4 1 --------0
I877zk http://blog.numino.net/
Surplus_Point int 4 1 --------0
7Pt8LP http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
Vi3tva http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
CMjPK6 http://blog.numino.net/
7、WEB_ZS
xEPO21 http://blog.numino.net/
列名 类型 长 是否空 说明
JvD2qF http://blog.numino.net/
ID bigint 8 0
CPssVn http://blog.numino.net/
ACC char 10 1
m1hPPP http://blog.numino.net/
NAME char 10 1
W2b6wM http://blog.numino.net/
ZSTIME datetime 8 1
Xyq8yX http://blog.numino.net/
ZSCLEVEL smallint 2 1
44qFq1 http://blog.numino.net/
ZSCS smallint 2 0
s0SNjx http://blog.numino.net/
CZCS smallint 2 0
b25uH8 http://blog.numino.net/
CZTIME datetime 8 0
BQj0Z6 http://blog.numino.net/
ZJZSCS smallint 2 0
908qAa http://blog.numino.net/
GJZSCS smallint 2 0
jX4Ndf http://blog.numino.net/
CJZSCS smallint 2 0
75P6v1 http://blog.numino.net/
BSCS smallint 2 0
OQoS29 http://blog.numino.net/
BSTIME datetime 8 0
p4Ep3k http://blog.numino.net/
LEVELUPPOINT int 4 0
3q7Fgd http://blog.numino.net/
GDDS int 4 0
|
|