| 奇迹muonline数据库基础库分析 |
一、表的组成：
UdClyk http://blog.numino.net/
1、AccountCharacter
dISyyv http://blog.numino.net/
用来存放帐号的角色。
pSUt8n http://blog.numino.net/
2、Character
c2rTp3 http://blog.numino.net/
用来存放每个角色的详细数据。
MKSSO1 http://blog.numino.net/
3、MEMB_INFO
2F1KWa http://blog.numino.net/
帐号信息
bim09F http://blog.numino.net/
4、MEMB_STAT
FPIY19 http://blog.numino.net/
帐号状态
0O46v3 http://blog.numino.net/
5、warehouse
vI4qmq http://blog.numino.net/
仓库
81C0E1 http://blog.numino.net/
6、VI_CURR_INFO
r0438l http://blog.numino.net/
帐号费用
jJ5R1f http://blog.numino.net/
7、WEB_ZS
w6Gkro http://blog.numino.net/
PL 网站的转生数据
CnOGXo http://blog.numino.net/
二、各表说明
NwX4hC http://blog.numino.net/
1、AccountCharacter 表
16Yqw9 http://blog.numino.net/
列名 类型 长 是否空 说明
M5lvQ6 http://blog.numino.net/
Number int 4 0 自动增加的序数
E6M4t0 http://blog.numino.net/
Id varchar 10 0 帐号
XUTlP5 http://blog.numino.net/
GameID1 varchar 10 1 角色1
7z1hJY http://blog.numino.net/
GameID2 varchar 10 1 角色2
u3NZKL http://blog.numino.net/
GameID3 varchar 10 1
2h164G http://blog.numino.net/
GameID4 varchar 10 1
lD0TYB http://blog.numino.net/
GameID5 varchar 10 1
NyvWFt http://blog.numino.net/
GameIDC varchar 10 1
Y5W0C6 http://blog.numino.net/
2、Character 表
QneyeF http://blog.numino.net/
列名 类型 长 是否空 说明
41UThx http://blog.numino.net/
AccountID varchar 10 0 --------帐号
RvLi7G http://blog.numino.net/
Name nvarchar 10 0 --------角色名
m41ZWU http://blog.numino.net/
cLevel smallint 2 1 --------等级
3qC7OP http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
JZhP6d http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
wiM7Md http://blog.numino.net/
Experience int 4 1 --------经验
m7YXbZ http://blog.numino.net/
Strength smallint 2 1 --------力量
4ybnir http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
F1Wism http://blog.numino.net/
Vitality smallint 2 1 --------体力
ahDn4E http://blog.numino.net/
Energy smallint 2 1 --------智力
ay8o1f http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
R7Cu7H http://blog.numino.net/
MagicList varbinary 60 1 --------技能
wU2qqI http://blog.numino.net/
Money int 4 1 --------钱
6K0nq0 http://blog.numino.net/
Life real 4 1 --------
gO4RT9 http://blog.numino.net/
MaxLife real 4 1 --------
XO3E8H http://blog.numino.net/
Mana real 4 1 --------
3soHkd http://blog.numino.net/
MaxMana real 4 1 --------
ahE1jr http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
J0Jtx8 http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
SCLvgr http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
E5mvwY http://blog.numino.net/
MapDir tinyint 1 1 --------
k6cG80 http://blog.numino.net/
PkCount int 4 1 --------
EjKJDv http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
yXvg7d http://blog.numino.net/
PkTime int 4 1
Gp911Z http://blog.numino.net/
MDate smalldatetime 4 1
ZlLMCH http://blog.numino.net/
LDate smalldatetime 4 1
3sQ5n2 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
3PFXaN http://blog.numino.net/
DbVersion tinyint 1 1
hg18lZ http://blog.numino.net/
Quest varbinary 50 1
6lmo7o http://blog.numino.net/
LINZB bit 1 0
0pzdB5 http://blog.numino.net/
XDTIME datetime 8 0
ARc4lP http://blog.numino.net/
STOPINFO nvarchar 100 1
6wl6rC http://blog.numino.net/
STOPTIME datetime 8 0
kUIMJJ http://blog.numino.net/
zs_count int 4 1
KuG76E http://blog.numino.net/
zs_point int 4 1
Q4nsg8 http://blog.numino.net/
bs_count int 4 1
D8cQ2K http://blog.numino.net/
bs_point int 4 1
9NmBYm http://blog.numino.net/
shiji smalldatetime 4 1
NpxUj4 http://blog.numino.net/
banl nvarchar 10 1
0D50Fg http://blog.numino.net/
lv_time datetime 8 1
y7szCW http://blog.numino.net/
ex_ok int 4 1
oMU1oK http://blog.numino.net/
ex_total int 4 1
0r32x4 http://blog.numino.net/
rb_count int 4 1
n9Q6IS http://blog.numino.net/
rb_time datetime 8 1
8fjA0k http://blog.numino.net/
pz_time datetime 8 1
4t4EuA http://blog.numino.net/
3、MEMB_INFO
0LpGZb http://blog.numino.net/
列名 类型 长 是否空 说明
ktC0K7 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
45HY6R http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
bm64no http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
wDfKzF http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
fyz656 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
yPSxnn http://blog.numino.net/
post_code nvarchar 6 1 --------1234
72l71V http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
80CwDa http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
Bdig6Z http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
rcQ5jx http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
pOQIJz http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
uNmGca http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
1wV22k http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
aTV0ER http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
VWgV04 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
T0qV13 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
e3Et2E http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Cd6Mop http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
r6R65F http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
tf6171 http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
RQZV9t http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
mr7AN7 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
0NZRkC http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
iaoV96 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
njog64 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
tOJs98 http://blog.numino.net/
QX char 1 1 --------B
7U34s4 http://blog.numino.net/
JF int 4 0 --------0
Zlnazd http://blog.numino.net/
huiy int 4 1 --------0
rqGJP9 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
wxBdHW http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
9X2f1U http://blog.numino.net/
FDB int 4 1 --------0
435fQy http://blog.numino.net/
vip tinyint 1 1 --------0
L9J1Pu http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
MA9DEM http://blog.numino.net/
4、MEMB_STAT
j9SKXC http://blog.numino.net/
列名 类型 长 是否空 说明
nvDG51 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
sRrcoP http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
njNpiM http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
d4TtOi http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
q4uVpa http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
wRk86m http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
PVidpn http://blog.numino.net/
5、warehouse
pVN0S4 http://blog.numino.net/
列名 类型 长 是否空 说明
s6wAFR http://blog.numino.net/
AccountID varchar 10 0 --------帐号
y8Gai7 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
zPbLPq http://blog.numino.net/
Money int 4 1 --------钱
21KJk0 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
JyTqy0 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
S2k7xe http://blog.numino.net/
pw smallint 2 1 --------密码 0
vhco8P http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
pS8vh6 http://blog.numino.net/
ExtCKNum int 4 0 --------0
PH5010 http://blog.numino.net/
NeedExtCK int 4 0 --------0
0iIB9L http://blog.numino.net/
6、VI_CURR_INFO
t4hj74 http://blog.numino.net/
列名 类型 长 是否空 说明
jy6F53 http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
eAU1U5 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
fKRbMu http://blog.numino.net/
used_time int 4 1 --------1234
FvTlNA http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
k7ZWiD http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
g2Ut6s http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
vv44U2 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
0A799u http://blog.numino.net/
Bill_Section int 4 1 --------6
52Je31 http://blog.numino.net/
Bill_Value int 4 1 --------3
8z0grG http://blog.numino.net/
Bill_Hour int 4 1 --------0
f6uIzK http://blog.numino.net/
Surplus_Point int 4 1 --------0
U7WpNG http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
bXByvw http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
m6Veqo http://blog.numino.net/
7、WEB_ZS
0Nv4q9 http://blog.numino.net/
列名 类型 长 是否空 说明
uU8lt2 http://blog.numino.net/
ID bigint 8 0
6gm0Az http://blog.numino.net/
ACC char 10 1
gswCde http://blog.numino.net/
NAME char 10 1
onD06L http://blog.numino.net/
ZSTIME datetime 8 1
6ZKmI9 http://blog.numino.net/
ZSCLEVEL smallint 2 1
2XoZD8 http://blog.numino.net/
ZSCS smallint 2 0
db05gx http://blog.numino.net/
CZCS smallint 2 0
TYkVEC http://blog.numino.net/
CZTIME datetime 8 0
hVTu2P http://blog.numino.net/
ZJZSCS smallint 2 0
Ow9e79 http://blog.numino.net/
GJZSCS smallint 2 0
40Pjv2 http://blog.numino.net/
CJZSCS smallint 2 0
u1Ahll http://blog.numino.net/
BSCS smallint 2 0
43LWGl http://blog.numino.net/
BSTIME datetime 8 0
3uq4Lr http://blog.numino.net/
LEVELUPPOINT int 4 0
90rt8Y http://blog.numino.net/
GDDS int 4 0
|
|