| 奇迹muonline数据库基础库分析 |
一、表的组成：
7Csan3 http://blog.numino.net/
1、AccountCharacter
1bjjif http://blog.numino.net/
用来存放帐号的角色。
YQrHXx http://blog.numino.net/
2、Character
vr130L http://blog.numino.net/
用来存放每个角色的详细数据。
qku1z6 http://blog.numino.net/
3、MEMB_INFO
ggHjQ1 http://blog.numino.net/
帐号信息
f54U1i http://blog.numino.net/
4、MEMB_STAT
Ykvugd http://blog.numino.net/
帐号状态
aaYkw4 http://blog.numino.net/
5、warehouse
5USJwv http://blog.numino.net/
仓库
0deOw6 http://blog.numino.net/
6、VI_CURR_INFO
pp0857 http://blog.numino.net/
帐号费用
bA9Ojl http://blog.numino.net/
7、WEB_ZS
pT3vlo http://blog.numino.net/
PL 网站的转生数据
MzTKUB http://blog.numino.net/
二、各表说明
cqCBB7 http://blog.numino.net/
1、AccountCharacter 表
SuQ72U http://blog.numino.net/
列名 类型 长 是否空 说明
6ZOLqV http://blog.numino.net/
Number int 4 0 自动增加的序数
914mJ6 http://blog.numino.net/
Id varchar 10 0 帐号
0boZAu http://blog.numino.net/
GameID1 varchar 10 1 角色1
EJnV7n http://blog.numino.net/
GameID2 varchar 10 1 角色2
rGOGkZ http://blog.numino.net/
GameID3 varchar 10 1
d6iYOY http://blog.numino.net/
GameID4 varchar 10 1
ll1PCG http://blog.numino.net/
GameID5 varchar 10 1
0EhL0e http://blog.numino.net/
GameIDC varchar 10 1
vC6yK9 http://blog.numino.net/
2、Character 表
os62aZ http://blog.numino.net/
列名 类型 长 是否空 说明
HL1A9e http://blog.numino.net/
AccountID varchar 10 0 --------帐号
8SKUnq http://blog.numino.net/
Name nvarchar 10 0 --------角色名
Ghj6PF http://blog.numino.net/
cLevel smallint 2 1 --------等级
4MiIc6 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
NwBLj5 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
nieXin http://blog.numino.net/
Experience int 4 1 --------经验
97fUFe http://blog.numino.net/
Strength smallint 2 1 --------力量
7yM3Cz http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
A5Yu1c http://blog.numino.net/
Vitality smallint 2 1 --------体力
U86j8T http://blog.numino.net/
Energy smallint 2 1 --------智力
Op2nJ2 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
N4obap http://blog.numino.net/
MagicList varbinary 60 1 --------技能
Nhuf8R http://blog.numino.net/
Money int 4 1 --------钱
XZQtSq http://blog.numino.net/
Life real 4 1 --------
HRngsd http://blog.numino.net/
MaxLife real 4 1 --------
fDKI7B http://blog.numino.net/
Mana real 4 1 --------
t9y7NK http://blog.numino.net/
MaxMana real 4 1 --------
E4DDLK http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
4N3L0g http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
bb4mnh http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
1d6lY3 http://blog.numino.net/
MapDir tinyint 1 1 --------
548B8o http://blog.numino.net/
PkCount int 4 1 --------
h113h0 http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
Rh5FwH http://blog.numino.net/
PkTime int 4 1
KUMxCz http://blog.numino.net/
MDate smalldatetime 4 1
TtriOi http://blog.numino.net/
LDate smalldatetime 4 1
M31DQG http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
3oJW3R http://blog.numino.net/
DbVersion tinyint 1 1
77f1xa http://blog.numino.net/
Quest varbinary 50 1
Gq2aXI http://blog.numino.net/
LINZB bit 1 0
Uk0Aeq http://blog.numino.net/
XDTIME datetime 8 0
522brg http://blog.numino.net/
STOPINFO nvarchar 100 1
14fXLD http://blog.numino.net/
STOPTIME datetime 8 0
35ZbQB http://blog.numino.net/
zs_count int 4 1
0d33Bs http://blog.numino.net/
zs_point int 4 1
TV6KVy http://blog.numino.net/
bs_count int 4 1
djAZ4Q http://blog.numino.net/
bs_point int 4 1
SzuTL7 http://blog.numino.net/
shiji smalldatetime 4 1
zbbKXj http://blog.numino.net/
banl nvarchar 10 1
5Q6lBj http://blog.numino.net/
lv_time datetime 8 1
SHfQHA http://blog.numino.net/
ex_ok int 4 1
CiTnLa http://blog.numino.net/
ex_total int 4 1
1JDe4J http://blog.numino.net/
rb_count int 4 1
75VLBr http://blog.numino.net/
rb_time datetime 8 1
kdWXzs http://blog.numino.net/
pz_time datetime 8 1
L3y7yb http://blog.numino.net/
3、MEMB_INFO
PEdJJY http://blog.numino.net/
列名 类型 长 是否空 说明
ArK1ga http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
ul1ke6 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
2pJY1o http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
8uQebo http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
dO2apC http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
0aHx9a http://blog.numino.net/
post_code nvarchar 6 1 --------1234
qsHgN8 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
J52ye6 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
xL5QRT http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
7ejH2m http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
76Zwsi http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
ik6CWl http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
QSuA9x http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
41yZJl http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
E10k3T http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
2JBMOM http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
264I62 http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
njfGY6 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
ewEmWs http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
st7Yqe http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
vna0Iz http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
D610J1 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
C3cMtZ http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
rJVxeM http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
3Y6cTF http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
F2oTnu http://blog.numino.net/
QX char 1 1 --------B
oXI6Ns http://blog.numino.net/
JF int 4 0 --------0
2eV0K1 http://blog.numino.net/
huiy int 4 1 --------0
Tn2zq2 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
92V2wN http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
1SH1Gy http://blog.numino.net/
FDB int 4 1 --------0
I1hVxa http://blog.numino.net/
vip tinyint 1 1 --------0
ih5518 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
9Vx7wl http://blog.numino.net/
4、MEMB_STAT
DuREA6 http://blog.numino.net/
列名 类型 长 是否空 说明
hOpmlS http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
THPSp4 http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
574u8v http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
04B83c http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
DcO6wB http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
vQ76Gy http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
5zajw6 http://blog.numino.net/
5、warehouse
vlSFG1 http://blog.numino.net/
列名 类型 长 是否空 说明
FDSCU9 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
RCsbaR http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
Enc53s http://blog.numino.net/
Money int 4 1 --------钱
PV8bE9 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
0WaKc5 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
afnuNE http://blog.numino.net/
pw smallint 2 1 --------密码 0
e9N2Vr http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
nm8067 http://blog.numino.net/
ExtCKNum int 4 0 --------0
90Fb0m http://blog.numino.net/
NeedExtCK int 4 0 --------0
E2F760 http://blog.numino.net/
6、VI_CURR_INFO
L370s3 http://blog.numino.net/
列名 类型 长 是否空 说明
4hda8j http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
V2bkPR http://blog.numino.net/
chek_code nvarchar 1 0 --------1
Y46mhF http://blog.numino.net/
used_time int 4 1 --------1234
uN081C http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
SGBrws http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
gnjy84 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
u9Lwia http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
9hQztV http://blog.numino.net/
Bill_Section int 4 1 --------6
N0TxMh http://blog.numino.net/
Bill_Value int 4 1 --------3
kTkI9b http://blog.numino.net/
Bill_Hour int 4 1 --------0
Lbp1KR http://blog.numino.net/
Surplus_Point int 4 1 --------0
kxGm54 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
2Zem39 http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
I6q4Ub http://blog.numino.net/
7、WEB_ZS
gq7fGj http://blog.numino.net/
列名 类型 长 是否空 说明
02u9z2 http://blog.numino.net/
ID bigint 8 0
vDz68A http://blog.numino.net/
ACC char 10 1
94WKw3 http://blog.numino.net/
NAME char 10 1
xlTDPl http://blog.numino.net/
ZSTIME datetime 8 1
AMXQPf http://blog.numino.net/
ZSCLEVEL smallint 2 1
05vWua http://blog.numino.net/
ZSCS smallint 2 0
u9KZaI http://blog.numino.net/
CZCS smallint 2 0
syFrNf http://blog.numino.net/
CZTIME datetime 8 0
GPYK3d http://blog.numino.net/
ZJZSCS smallint 2 0
cGKC49 http://blog.numino.net/
GJZSCS smallint 2 0
Irrwns http://blog.numino.net/
CJZSCS smallint 2 0
iSk3Oa http://blog.numino.net/
BSCS smallint 2 0
OC9QYJ http://blog.numino.net/
BSTIME datetime 8 0
Nl3W1r http://blog.numino.net/
LEVELUPPOINT int 4 0
ip2e6h http://blog.numino.net/
GDDS int 4 0
|
|