| 奇迹muonline数据库基础库分析 |
一、表的组成：
OxAYpe http://blog.numino.net/
1、AccountCharacter
8R2K9p http://blog.numino.net/
用来存放帐号的角色。
j7FrG2 http://blog.numino.net/
2、Character
YA5sBG http://blog.numino.net/
用来存放每个角色的详细数据。
exVyy7 http://blog.numino.net/
3、MEMB_INFO
laMI5o http://blog.numino.net/
帐号信息
bb4C1D http://blog.numino.net/
4、MEMB_STAT
fQLDuB http://blog.numino.net/
帐号状态
LJPCVu http://blog.numino.net/
5、warehouse
1Zbozy http://blog.numino.net/
仓库
BS8C82 http://blog.numino.net/
6、VI_CURR_INFO
lvCoG0 http://blog.numino.net/
帐号费用
lkTUQN http://blog.numino.net/
7、WEB_ZS
3M31Bg http://blog.numino.net/
PL 网站的转生数据
Ek9ZCx http://blog.numino.net/
二、各表说明
KxJxj4 http://blog.numino.net/
1、AccountCharacter 表
4LvMCu http://blog.numino.net/
列名 类型 长 是否空 说明
u1HFvV http://blog.numino.net/
Number int 4 0 自动增加的序数
ecmFZ7 http://blog.numino.net/
Id varchar 10 0 帐号
DrXW9T http://blog.numino.net/
GameID1 varchar 10 1 角色1
Q6r7vo http://blog.numino.net/
GameID2 varchar 10 1 角色2
OXlKnk http://blog.numino.net/
GameID3 varchar 10 1
S4d2V3 http://blog.numino.net/
GameID4 varchar 10 1
7S9Hoo http://blog.numino.net/
GameID5 varchar 10 1
p6Lv3b http://blog.numino.net/
GameIDC varchar 10 1
03AYxl http://blog.numino.net/
2、Character 表
f3FCN6 http://blog.numino.net/
列名 类型 长 是否空 说明
N4AC40 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
C70k89 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
AvzjFm http://blog.numino.net/
cLevel smallint 2 1 --------等级
Td1pCM http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
EIi1d0 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
5ZOEQZ http://blog.numino.net/
Experience int 4 1 --------经验
mut4OD http://blog.numino.net/
Strength smallint 2 1 --------力量
Y5cJwh http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
jQTO40 http://blog.numino.net/
Vitality smallint 2 1 --------体力
KTvKZ7 http://blog.numino.net/
Energy smallint 2 1 --------智力
wZa12P http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
JkjHWJ http://blog.numino.net/
MagicList varbinary 60 1 --------技能
zxx9D6 http://blog.numino.net/
Money int 4 1 --------钱
lMNjcS http://blog.numino.net/
Life real 4 1 --------
G78MO5 http://blog.numino.net/
MaxLife real 4 1 --------
fInY1p http://blog.numino.net/
Mana real 4 1 --------
xhKmVN http://blog.numino.net/
MaxMana real 4 1 --------
dc2MFF http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
t029Aw http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
WASI5F http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
H993ec http://blog.numino.net/
MapDir tinyint 1 1 --------
gs0w28 http://blog.numino.net/
PkCount int 4 1 --------
m4a7J8 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
BcsI7k http://blog.numino.net/
PkTime int 4 1
XaV8IB http://blog.numino.net/
MDate smalldatetime 4 1
JV0f6j http://blog.numino.net/
LDate smalldatetime 4 1
mkNQBR http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
n2OFaV http://blog.numino.net/
DbVersion tinyint 1 1
t3nE59 http://blog.numino.net/
Quest varbinary 50 1
pqn3AR http://blog.numino.net/
LINZB bit 1 0
oRnm2h http://blog.numino.net/
XDTIME datetime 8 0
c40hP1 http://blog.numino.net/
STOPINFO nvarchar 100 1
CcuN95 http://blog.numino.net/
STOPTIME datetime 8 0
G2z5uS http://blog.numino.net/
zs_count int 4 1
8xBoGH http://blog.numino.net/
zs_point int 4 1
8m7ILx http://blog.numino.net/
bs_count int 4 1
j0t2WD http://blog.numino.net/
bs_point int 4 1
laUDrZ http://blog.numino.net/
shiji smalldatetime 4 1
l7wgUS http://blog.numino.net/
banl nvarchar 10 1
W7qs44 http://blog.numino.net/
lv_time datetime 8 1
6x63dg http://blog.numino.net/
ex_ok int 4 1
h2eJZP http://blog.numino.net/
ex_total int 4 1
ftNP8t http://blog.numino.net/
rb_count int 4 1
BjKpPv http://blog.numino.net/
rb_time datetime 8 1
twEs1z http://blog.numino.net/
pz_time datetime 8 1
ZkbkG4 http://blog.numino.net/
3、MEMB_INFO
NgIlSm http://blog.numino.net/
列名 类型 长 是否空 说明
Iww34d http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
zuborc http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
7e65bf http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
3QTmdV http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
AIsC7n http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
79Hwb3 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
sx4SN2 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
RsMz8K http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
KSTAoH http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
6H67Vs http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
78OfTB http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
m6tyaI http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
f1EgI7 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
2pH8XI http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
1q3C0c http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
XY58bg http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
l4NnYj http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
mtxTQd http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
E4GVY5 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
S6iH9N http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
FZ63t9 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
b4F8kn http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
8mQSoL http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
GXbppQ http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
P08672 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
5375z5 http://blog.numino.net/
QX char 1 1 --------B
9Xjknn http://blog.numino.net/
JF int 4 0 --------0
p2Ve5p http://blog.numino.net/
huiy int 4 1 --------0
gj6YY2 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
omKx50 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
p9Kfcl http://blog.numino.net/
FDB int 4 1 --------0
B9P8hQ http://blog.numino.net/
vip tinyint 1 1 --------0
5qtYgQ http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
YQoce4 http://blog.numino.net/
4、MEMB_STAT
PZuj1H http://blog.numino.net/
列名 类型 长 是否空 说明
jTBndv http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
dIl9Bj http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
aSKR3T http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
9O6bS7 http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
3vB1YE http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
q6g3UT http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
d0A25m http://blog.numino.net/
5、warehouse
Ra2pSJ http://blog.numino.net/
列名 类型 长 是否空 说明
6vQOH9 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
VUHGzp http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
1gN5q9 http://blog.numino.net/
Money int 4 1 --------钱
Z2jDA8 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
bk1IZe http://blog.numino.net/
DbVersion tinyint 1 1 --------1
mRloPg http://blog.numino.net/
pw smallint 2 1 --------密码 0
hKYPVK http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
Q0w9Sn http://blog.numino.net/
ExtCKNum int 4 0 --------0
HjT8Yz http://blog.numino.net/
NeedExtCK int 4 0 --------0
K4ZFtn http://blog.numino.net/
6、VI_CURR_INFO
QRt710 http://blog.numino.net/
列名 类型 长 是否空 说明
7RZjKV http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
Ys3h6m http://blog.numino.net/
chek_code nvarchar 1 0 --------1
IUodRT http://blog.numino.net/
used_time int 4 1 --------1234
3hihp2 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
S7fpUk http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
Dlp672 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
TbOJ0O http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
BAwT2n http://blog.numino.net/
Bill_Section int 4 1 --------6
AJRe2r http://blog.numino.net/
Bill_Value int 4 1 --------3
U916xu http://blog.numino.net/
Bill_Hour int 4 1 --------0
XbS3kX http://blog.numino.net/
Surplus_Point int 4 1 --------0
LxCSqE http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
ShxtQU http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
g0tduO http://blog.numino.net/
7、WEB_ZS
qp7FKS http://blog.numino.net/
列名 类型 长 是否空 说明
TEFkU5 http://blog.numino.net/
ID bigint 8 0
DKHw0g http://blog.numino.net/
ACC char 10 1
uRfDUy http://blog.numino.net/
NAME char 10 1
P6iali http://blog.numino.net/
ZSTIME datetime 8 1
zjK118 http://blog.numino.net/
ZSCLEVEL smallint 2 1
MAHTSV http://blog.numino.net/
ZSCS smallint 2 0
B56um1 http://blog.numino.net/
CZCS smallint 2 0
MD5IKT http://blog.numino.net/
CZTIME datetime 8 0
iwXqg4 http://blog.numino.net/
ZJZSCS smallint 2 0
iEx8qs http://blog.numino.net/
GJZSCS smallint 2 0
rr2eih http://blog.numino.net/
CJZSCS smallint 2 0
4H3ntu http://blog.numino.net/
BSCS smallint 2 0
eT52Dp http://blog.numino.net/
BSTIME datetime 8 0
dYsA6K http://blog.numino.net/
LEVELUPPOINT int 4 0
5y6Pwa http://blog.numino.net/
GDDS int 4 0
|
|