| 奇迹muonline数据库基础库分析 |
一、表的组成：
Td3suT http://blog.numino.net/
1、AccountCharacter
9Zq2kJ http://blog.numino.net/
用来存放帐号的角色。
Rn5hwN http://blog.numino.net/
2、Character
2kqVig http://blog.numino.net/
用来存放每个角色的详细数据。
2gOQlg http://blog.numino.net/
3、MEMB_INFO
3co4Gg http://blog.numino.net/
帐号信息
IhWa6Q http://blog.numino.net/
4、MEMB_STAT
vl8Y54 http://blog.numino.net/
帐号状态
bUUZk6 http://blog.numino.net/
5、warehouse
PS7xFN http://blog.numino.net/
仓库
HOeaA4 http://blog.numino.net/
6、VI_CURR_INFO
YshrtJ http://blog.numino.net/
帐号费用
5LLu1t http://blog.numino.net/
7、WEB_ZS
01cM33 http://blog.numino.net/
PL 网站的转生数据
UC8m1p http://blog.numino.net/
二、各表说明
Hdg4WU http://blog.numino.net/
1、AccountCharacter 表
GIgxmC http://blog.numino.net/
列名 类型 长 是否空 说明
6zBBN8 http://blog.numino.net/
Number int 4 0 自动增加的序数
LQ5rZ3 http://blog.numino.net/
Id varchar 10 0 帐号
xh5a1A http://blog.numino.net/
GameID1 varchar 10 1 角色1
05zmrB http://blog.numino.net/
GameID2 varchar 10 1 角色2
j07q05 http://blog.numino.net/
GameID3 varchar 10 1
CcP3Pb http://blog.numino.net/
GameID4 varchar 10 1
xqGAHB http://blog.numino.net/
GameID5 varchar 10 1
W2cgCj http://blog.numino.net/
GameIDC varchar 10 1
hPPB37 http://blog.numino.net/
2、Character 表
wT03j8 http://blog.numino.net/
列名 类型 长 是否空 说明
WL7OHN http://blog.numino.net/
AccountID varchar 10 0 --------帐号
eVNCEU http://blog.numino.net/
Name nvarchar 10 0 --------角色名
9I6XZ2 http://blog.numino.net/
cLevel smallint 2 1 --------等级
3ysbmk http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
yE36fm http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
PfWl35 http://blog.numino.net/
Experience int 4 1 --------经验
WadcMG http://blog.numino.net/
Strength smallint 2 1 --------力量
f7I2Zm http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
AIEUmB http://blog.numino.net/
Vitality smallint 2 1 --------体力
F4cTF9 http://blog.numino.net/
Energy smallint 2 1 --------智力
lp2ik8 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
13rg5E http://blog.numino.net/
MagicList varbinary 60 1 --------技能
gFPJ2m http://blog.numino.net/
Money int 4 1 --------钱
9Ynenx http://blog.numino.net/
Life real 4 1 --------
gHfY8A http://blog.numino.net/
MaxLife real 4 1 --------
dkiD89 http://blog.numino.net/
Mana real 4 1 --------
i39WS6 http://blog.numino.net/
MaxMana real 4 1 --------
txc974 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
hxJUNc http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
Qc69kT http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
O1umSW http://blog.numino.net/
MapDir tinyint 1 1 --------
JPhp23 http://blog.numino.net/
PkCount int 4 1 --------
i9Rb31 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
NmDARK http://blog.numino.net/
PkTime int 4 1
71dwp5 http://blog.numino.net/
MDate smalldatetime 4 1
3ZHu2i http://blog.numino.net/
LDate smalldatetime 4 1
7tA4x1 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
ne7dX5 http://blog.numino.net/
DbVersion tinyint 1 1
ef5Fy8 http://blog.numino.net/
Quest varbinary 50 1
Gmcv02 http://blog.numino.net/
LINZB bit 1 0
piYN5W http://blog.numino.net/
XDTIME datetime 8 0
Ss9HCg http://blog.numino.net/
STOPINFO nvarchar 100 1
6L2Ev9 http://blog.numino.net/
STOPTIME datetime 8 0
z0YDag http://blog.numino.net/
zs_count int 4 1
3SDiKj http://blog.numino.net/
zs_point int 4 1
bRnvlv http://blog.numino.net/
bs_count int 4 1
gyP809 http://blog.numino.net/
bs_point int 4 1
mZW2Vk http://blog.numino.net/
shiji smalldatetime 4 1
Ku4Yuk http://blog.numino.net/
banl nvarchar 10 1
DWG1Jm http://blog.numino.net/
lv_time datetime 8 1
MUw7mQ http://blog.numino.net/
ex_ok int 4 1
aoDRT8 http://blog.numino.net/
ex_total int 4 1
59ycmZ http://blog.numino.net/
rb_count int 4 1
C19CY8 http://blog.numino.net/
rb_time datetime 8 1
z49r8p http://blog.numino.net/
pz_time datetime 8 1
r36r4A http://blog.numino.net/
3、MEMB_INFO
P4v1vt http://blog.numino.net/
列名 类型 长 是否空 说明
N9wPG7 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
2zOm2U http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
5p7j88 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
9rYbpc http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
GhlL1R http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
Knqr6T http://blog.numino.net/
post_code nvarchar 6 1 --------1234
5wpinR http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
4GD11Q http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
R6tn64 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
vUIAer http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
3j4lhN http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
F80bd8 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
G56E54 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
Hd71U4 http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
sFqnmP http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
MkHXu5 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
mimPC5 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
fWO4KP http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
B9dBMp http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
OTzyvI http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
4cwp23 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
cm4cS9 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
pvwGa6 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
AtAbmA http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
zIKtZ0 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
7A5E12 http://blog.numino.net/
QX char 1 1 --------B
751Wgj http://blog.numino.net/
JF int 4 0 --------0
TB443l http://blog.numino.net/
huiy int 4 1 --------0
gIm2Z9 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
m9DRsU http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
D0AN37 http://blog.numino.net/
FDB int 4 1 --------0
hj89lm http://blog.numino.net/
vip tinyint 1 1 --------0
yW41sx http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
CIFfm2 http://blog.numino.net/
4、MEMB_STAT
MiWDXv http://blog.numino.net/
列名 类型 长 是否空 说明
PfCPdK http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
WPJ4KH http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
vdg2bZ http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
1hQEaw http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
ER5bSx http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
Wt4VCO http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
IDTiLU http://blog.numino.net/
5、warehouse
jKr0J5 http://blog.numino.net/
列名 类型 长 是否空 说明
jdR55W http://blog.numino.net/
AccountID varchar 10 0 --------帐号
vO51n6 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
jc9ukY http://blog.numino.net/
Money int 4 1 --------钱
d4J778 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
tKA0Cm http://blog.numino.net/
DbVersion tinyint 1 1 --------1
hmpcXE http://blog.numino.net/
pw smallint 2 1 --------密码 0
Z1gjI5 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
hB1PS1 http://blog.numino.net/
ExtCKNum int 4 0 --------0
nW11cQ http://blog.numino.net/
NeedExtCK int 4 0 --------0
18n5pD http://blog.numino.net/
6、VI_CURR_INFO
6gT83j http://blog.numino.net/
列名 类型 长 是否空 说明
9kb270 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
bjC5rd http://blog.numino.net/
chek_code nvarchar 1 0 --------1
FG97G2 http://blog.numino.net/
used_time int 4 1 --------1234
MY4H8h http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
c7SRk7 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
js105u http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
603VBx http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
A7x6lh http://blog.numino.net/
Bill_Section int 4 1 --------6
4dwto4 http://blog.numino.net/
Bill_Value int 4 1 --------3
pwCieB http://blog.numino.net/
Bill_Hour int 4 1 --------0
E8l7Oj http://blog.numino.net/
Surplus_Point int 4 1 --------0
ZyRs6j http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
696pGv http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
9zTlHV http://blog.numino.net/
7、WEB_ZS
R82j47 http://blog.numino.net/
列名 类型 长 是否空 说明
s19k12 http://blog.numino.net/
ID bigint 8 0
EPd6KX http://blog.numino.net/
ACC char 10 1
2El5xI http://blog.numino.net/
NAME char 10 1
W7zP98 http://blog.numino.net/
ZSTIME datetime 8 1
23LpUP http://blog.numino.net/
ZSCLEVEL smallint 2 1
rYEfP6 http://blog.numino.net/
ZSCS smallint 2 0
2U40OD http://blog.numino.net/
CZCS smallint 2 0
Df2QES http://blog.numino.net/
CZTIME datetime 8 0
029rka http://blog.numino.net/
ZJZSCS smallint 2 0
pCwZYR http://blog.numino.net/
GJZSCS smallint 2 0
OzZKXa http://blog.numino.net/
CJZSCS smallint 2 0
mo9M38 http://blog.numino.net/
BSCS smallint 2 0
GBfKhL http://blog.numino.net/
BSTIME datetime 8 0
JFEGEs http://blog.numino.net/
LEVELUPPOINT int 4 0
Sfd0p3 http://blog.numino.net/
GDDS int 4 0
|
|