| 奇迹muonline数据库基础库分析 |
一、表的组成：
aM4R2d http://blog.numino.net/
1、AccountCharacter
6SsA1i http://blog.numino.net/
用来存放帐号的角色。
1fTkrF http://blog.numino.net/
2、Character
J2I4Ld http://blog.numino.net/
用来存放每个角色的详细数据。
3ZsM07 http://blog.numino.net/
3、MEMB_INFO
bf418A http://blog.numino.net/
帐号信息
c1QBG3 http://blog.numino.net/
4、MEMB_STAT
rCIM0R http://blog.numino.net/
帐号状态
bp5BwX http://blog.numino.net/
5、warehouse
u2Hauj http://blog.numino.net/
仓库
yk9TjJ http://blog.numino.net/
6、VI_CURR_INFO
30d2IL http://blog.numino.net/
帐号费用
283mzi http://blog.numino.net/
7、WEB_ZS
7th1JV http://blog.numino.net/
PL 网站的转生数据
iM3g0V http://blog.numino.net/
二、各表说明
8zFGog http://blog.numino.net/
1、AccountCharacter 表
s42oEK http://blog.numino.net/
列名 类型 长 是否空 说明
14a0bt http://blog.numino.net/
Number int 4 0 自动增加的序数
HeVV4A http://blog.numino.net/
Id varchar 10 0 帐号
o0w7mZ http://blog.numino.net/
GameID1 varchar 10 1 角色1
rpfqo6 http://blog.numino.net/
GameID2 varchar 10 1 角色2
xIX7Q1 http://blog.numino.net/
GameID3 varchar 10 1
i7Yku0 http://blog.numino.net/
GameID4 varchar 10 1
F2k0i3 http://blog.numino.net/
GameID5 varchar 10 1
480231 http://blog.numino.net/
GameIDC varchar 10 1
q3vwSy http://blog.numino.net/
2、Character 表
WS94O8 http://blog.numino.net/
列名 类型 长 是否空 说明
Ei8lJ0 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
dAPXoz http://blog.numino.net/
Name nvarchar 10 0 --------角色名
rhl849 http://blog.numino.net/
cLevel smallint 2 1 --------等级
JoNZ6T http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
za9j2Z http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
p5752K http://blog.numino.net/
Experience int 4 1 --------经验
RtZa5C http://blog.numino.net/
Strength smallint 2 1 --------力量
l3BaUj http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
S9FBk6 http://blog.numino.net/
Vitality smallint 2 1 --------体力
e6gncF http://blog.numino.net/
Energy smallint 2 1 --------智力
pvqDGT http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
QJ3CO0 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
1WpySl http://blog.numino.net/
Money int 4 1 --------钱
916C8S http://blog.numino.net/
Life real 4 1 --------
CE72iG http://blog.numino.net/
MaxLife real 4 1 --------
WY1AQD http://blog.numino.net/
Mana real 4 1 --------
QFq7W2 http://blog.numino.net/
MaxMana real 4 1 --------
5ACVwn http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
uYb9Dd http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
nzDaeB http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
kBXLaa http://blog.numino.net/
MapDir tinyint 1 1 --------
jA9KxU http://blog.numino.net/
PkCount int 4 1 --------
vciLY3 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
oagBwb http://blog.numino.net/
PkTime int 4 1
svm3wK http://blog.numino.net/
MDate smalldatetime 4 1
7qMAIK http://blog.numino.net/
LDate smalldatetime 4 1
8exTV1 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
CaGK83 http://blog.numino.net/
DbVersion tinyint 1 1
u7sPbj http://blog.numino.net/
Quest varbinary 50 1
Hz5sT2 http://blog.numino.net/
LINZB bit 1 0
ioG66k http://blog.numino.net/
XDTIME datetime 8 0
iZ4qdE http://blog.numino.net/
STOPINFO nvarchar 100 1
JEMajp http://blog.numino.net/
STOPTIME datetime 8 0
6EZebw http://blog.numino.net/
zs_count int 4 1
B2U25o http://blog.numino.net/
zs_point int 4 1
lDyLwY http://blog.numino.net/
bs_count int 4 1
p45S8z http://blog.numino.net/
bs_point int 4 1
042i48 http://blog.numino.net/
shiji smalldatetime 4 1
QOIVTm http://blog.numino.net/
banl nvarchar 10 1
qQ8iDK http://blog.numino.net/
lv_time datetime 8 1
hY0UPS http://blog.numino.net/
ex_ok int 4 1
5X1h21 http://blog.numino.net/
ex_total int 4 1
QD4d4z http://blog.numino.net/
rb_count int 4 1
RGkGqn http://blog.numino.net/
rb_time datetime 8 1
JAbnS8 http://blog.numino.net/
pz_time datetime 8 1
6HoY6f http://blog.numino.net/
3、MEMB_INFO
CH91OF http://blog.numino.net/
列名 类型 长 是否空 说明
22z5oE http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
ua78ns http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
85DgsC http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
4oneoy http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
219Gn6 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
LOKNLK http://blog.numino.net/
post_code nvarchar 6 1 --------1234
Cbmu6Q http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
g5FTJ8 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
4c9QgD http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
hluS6c http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
XBU9Kl http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
REsRo2 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
6h068w http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
pih1PI http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
5lty8u http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
Vh0g9V http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
IIhcKa http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
0wNciZ http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
s2FQ23 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
Zl1Oap http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
j4M15z http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
DH00QG http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
KDDZQ3 http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
7Gnx03 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
pktQCT http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
kO7RdA http://blog.numino.net/
QX char 1 1 --------B
n6osYR http://blog.numino.net/
JF int 4 0 --------0
8FpOGI http://blog.numino.net/
huiy int 4 1 --------0
6Z1FrO http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
ReN8XH http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
a2EI2Z http://blog.numino.net/
FDB int 4 1 --------0
Rq8db1 http://blog.numino.net/
vip tinyint 1 1 --------0
4I1fFu http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
a2W6x9 http://blog.numino.net/
4、MEMB_STAT
mj4IUi http://blog.numino.net/
列名 类型 长 是否空 说明
9k1HZI http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
onNgh1 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
a5svX6 http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
tb0Qrx http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
2PU008 http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
PH9iED http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
M4iPXc http://blog.numino.net/
5、warehouse
1jJ51H http://blog.numino.net/
列名 类型 长 是否空 说明
1NkCSL http://blog.numino.net/
AccountID varchar 10 0 --------帐号
s1KxcJ http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
8eWB7k http://blog.numino.net/
Money int 4 1 --------钱
uzBusN http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
6KoMwI http://blog.numino.net/
DbVersion tinyint 1 1 --------1
aVy3y8 http://blog.numino.net/
pw smallint 2 1 --------密码 0
9oGT5b http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
702GIK http://blog.numino.net/
ExtCKNum int 4 0 --------0
q2ohLv http://blog.numino.net/
NeedExtCK int 4 0 --------0
Dy6z74 http://blog.numino.net/
6、VI_CURR_INFO
OQ2S4v http://blog.numino.net/
列名 类型 长 是否空 说明
tyiJ0H http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
80dXS3 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
l66S6e http://blog.numino.net/
used_time int 4 1 --------1234
8trj0v http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
TwP5F6 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
xp2HPP http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
38S0OP http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
bc9RM4 http://blog.numino.net/
Bill_Section int 4 1 --------6
MAC0TI http://blog.numino.net/
Bill_Value int 4 1 --------3
z33GsK http://blog.numino.net/
Bill_Hour int 4 1 --------0
uWQ0yZ http://blog.numino.net/
Surplus_Point int 4 1 --------0
2AUZsx http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
z9D1GN http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
Ad8abG http://blog.numino.net/
7、WEB_ZS
r2QvIq http://blog.numino.net/
列名 类型 长 是否空 说明
w491QF http://blog.numino.net/
ID bigint 8 0
7C6wu9 http://blog.numino.net/
ACC char 10 1
nu5sBK http://blog.numino.net/
NAME char 10 1
mYrPZ1 http://blog.numino.net/
ZSTIME datetime 8 1
95ardv http://blog.numino.net/
ZSCLEVEL smallint 2 1
Kkx3wH http://blog.numino.net/
ZSCS smallint 2 0
N7O4up http://blog.numino.net/
CZCS smallint 2 0
t6xS3P http://blog.numino.net/
CZTIME datetime 8 0
R92h0A http://blog.numino.net/
ZJZSCS smallint 2 0
62j92W http://blog.numino.net/
GJZSCS smallint 2 0
JoqVl0 http://blog.numino.net/
CJZSCS smallint 2 0
jg7PDQ http://blog.numino.net/
BSCS smallint 2 0
GZx4v5 http://blog.numino.net/
BSTIME datetime 8 0
HYcL4b http://blog.numino.net/
LEVELUPPOINT int 4 0
H3CTU6 http://blog.numino.net/
GDDS int 4 0
|
|