| 奇迹muonline数据库基础库分析 |
一、表的组成：
S1IKd4 http://blog.numino.net/
1、AccountCharacter
MrV8OP http://blog.numino.net/
用来存放帐号的角色。
vaNaGp http://blog.numino.net/
2、Character
CTPVBt http://blog.numino.net/
用来存放每个角色的详细数据。
1545nt http://blog.numino.net/
3、MEMB_INFO
xCN1ZR http://blog.numino.net/
帐号信息
3O387o http://blog.numino.net/
4、MEMB_STAT
qTgyKo http://blog.numino.net/
帐号状态
rII6ui http://blog.numino.net/
5、warehouse
inXUUZ http://blog.numino.net/
仓库
nhq9Ic http://blog.numino.net/
6、VI_CURR_INFO
8jBU47 http://blog.numino.net/
帐号费用
Af0ovb http://blog.numino.net/
7、WEB_ZS
V6MG75 http://blog.numino.net/
PL 网站的转生数据
4WjV6h http://blog.numino.net/
二、各表说明
GF6Fu8 http://blog.numino.net/
1、AccountCharacter 表
HJr3tz http://blog.numino.net/
列名 类型 长 是否空 说明
WJrk6V http://blog.numino.net/
Number int 4 0 自动增加的序数
4192Mg http://blog.numino.net/
Id varchar 10 0 帐号
0Ml5un http://blog.numino.net/
GameID1 varchar 10 1 角色1
yMzK3a http://blog.numino.net/
GameID2 varchar 10 1 角色2
QWJucC http://blog.numino.net/
GameID3 varchar 10 1
vX8K9F http://blog.numino.net/
GameID4 varchar 10 1
6PPhBg http://blog.numino.net/
GameID5 varchar 10 1
dpYEk5 http://blog.numino.net/
GameIDC varchar 10 1
wMhZ33 http://blog.numino.net/
2、Character 表
2ab5Tf http://blog.numino.net/
列名 类型 长 是否空 说明
SHoo5p http://blog.numino.net/
AccountID varchar 10 0 --------帐号
Q1N1RC http://blog.numino.net/
Name nvarchar 10 0 --------角色名
yxC99B http://blog.numino.net/
cLevel smallint 2 1 --------等级
9qxawG http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
je5Tn1 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
OU1f35 http://blog.numino.net/
Experience int 4 1 --------经验
EGrIZd http://blog.numino.net/
Strength smallint 2 1 --------力量
Zw93On http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
b81o4r http://blog.numino.net/
Vitality smallint 2 1 --------体力
lvF8qy http://blog.numino.net/
Energy smallint 2 1 --------智力
VRYC0t http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
AP5S4m http://blog.numino.net/
MagicList varbinary 60 1 --------技能
JKRO4w http://blog.numino.net/
Money int 4 1 --------钱
MjhzAz http://blog.numino.net/
Life real 4 1 --------
CZF3vQ http://blog.numino.net/
MaxLife real 4 1 --------
V8a86Q http://blog.numino.net/
Mana real 4 1 --------
UlK4aX http://blog.numino.net/
MaxMana real 4 1 --------
CQ792P http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
1Z7dUV http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
3Ww63h http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
O4GN3I http://blog.numino.net/
MapDir tinyint 1 1 --------
zLvYlk http://blog.numino.net/
PkCount int 4 1 --------
eKWffh http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
LO8I32 http://blog.numino.net/
PkTime int 4 1
7L49Ox http://blog.numino.net/
MDate smalldatetime 4 1
sZBJSR http://blog.numino.net/
LDate smalldatetime 4 1
u1hl2t http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
5byN5C http://blog.numino.net/
DbVersion tinyint 1 1
p8Yo44 http://blog.numino.net/
Quest varbinary 50 1
9V03yu http://blog.numino.net/
LINZB bit 1 0
CMJT2n http://blog.numino.net/
XDTIME datetime 8 0
0uLQIK http://blog.numino.net/
STOPINFO nvarchar 100 1
w3rXmq http://blog.numino.net/
STOPTIME datetime 8 0
2TQBw6 http://blog.numino.net/
zs_count int 4 1
zsjfsP http://blog.numino.net/
zs_point int 4 1
1tq2GZ http://blog.numino.net/
bs_count int 4 1
1Hq4dJ http://blog.numino.net/
bs_point int 4 1
0GFsIU http://blog.numino.net/
shiji smalldatetime 4 1
28rLgV http://blog.numino.net/
banl nvarchar 10 1
yr39Q4 http://blog.numino.net/
lv_time datetime 8 1
AvG2z5 http://blog.numino.net/
ex_ok int 4 1
TD2gAp http://blog.numino.net/
ex_total int 4 1
w2eR6y http://blog.numino.net/
rb_count int 4 1
TY7xMF http://blog.numino.net/
rb_time datetime 8 1
tCZzCP http://blog.numino.net/
pz_time datetime 8 1
suUv0Z http://blog.numino.net/
3、MEMB_INFO
Bq0TD2 http://blog.numino.net/
列名 类型 长 是否空 说明
z1AfDV http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
dxFB9N http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
OrPCDh http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
Z11yCX http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
8sT1QK http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
xTsYfw http://blog.numino.net/
post_code nvarchar 6 1 --------1234
SGG5U8 http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
7hwhqI http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
2zJyl2 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
Tzzsp0 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
tV14po http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
0627A7 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
JJnqEy http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
t8ULel http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
uzHmm1 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
a1on3S http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
KwgLzX http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
oqRQrC http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
wipi7p http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
oQqv3Q http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
pzLPZx http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
PmeqYS http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
SaVPEv http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
4r6fCK http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
2x20o0 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
gAoDE2 http://blog.numino.net/
QX char 1 1 --------B
F4VBUv http://blog.numino.net/
JF int 4 0 --------0
o4Nd3v http://blog.numino.net/
huiy int 4 1 --------0
8dCr4C http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
fxI51F http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
kYPG46 http://blog.numino.net/
FDB int 4 1 --------0
WBB3pS http://blog.numino.net/
vip tinyint 1 1 --------0
Z7F29e http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
1Uu1LU http://blog.numino.net/
4、MEMB_STAT
ffuD6m http://blog.numino.net/
列名 类型 长 是否空 说明
vme7aK http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
spvZGK http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
uz00wP http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
0yhtfU http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
43FUov http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
kuaDiS http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
iX07H9 http://blog.numino.net/
5、warehouse
MsYn0A http://blog.numino.net/
列名 类型 长 是否空 说明
kv1ht3 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
LIJKUt http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
s4uNG9 http://blog.numino.net/
Money int 4 1 --------钱
1eIU5L http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
JCpYo4 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
obb7TL http://blog.numino.net/
pw smallint 2 1 --------密码 0
drtEY4 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
JG3myU http://blog.numino.net/
ExtCKNum int 4 0 --------0
ktBwyB http://blog.numino.net/
NeedExtCK int 4 0 --------0
l0koOs http://blog.numino.net/
6、VI_CURR_INFO
YdEOLW http://blog.numino.net/
列名 类型 长 是否空 说明
724ylb http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
88z4Ss http://blog.numino.net/
chek_code nvarchar 1 0 --------1
40Bg4E http://blog.numino.net/
used_time int 4 1 --------1234
fRIoT3 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
CK1Q0m http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
VQDA5d http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
wO2G4E http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
Soc5nK http://blog.numino.net/
Bill_Section int 4 1 --------6
427T3W http://blog.numino.net/
Bill_Value int 4 1 --------3
lmsFUG http://blog.numino.net/
Bill_Hour int 4 1 --------0
Uaj7oN http://blog.numino.net/
Surplus_Point int 4 1 --------0
FCfEBr http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
jm7l7P http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
Ux73QU http://blog.numino.net/
7、WEB_ZS
wwCpcU http://blog.numino.net/
列名 类型 长 是否空 说明
6vUsLF http://blog.numino.net/
ID bigint 8 0
sgOo90 http://blog.numino.net/
ACC char 10 1
o08grL http://blog.numino.net/
NAME char 10 1
5kg8bj http://blog.numino.net/
ZSTIME datetime 8 1
YhTNqk http://blog.numino.net/
ZSCLEVEL smallint 2 1
8UICTV http://blog.numino.net/
ZSCS smallint 2 0
PPiE7O http://blog.numino.net/
CZCS smallint 2 0
c055Nt http://blog.numino.net/
CZTIME datetime 8 0
2Q6t0B http://blog.numino.net/
ZJZSCS smallint 2 0
5TrM0v http://blog.numino.net/
GJZSCS smallint 2 0
nnspwa http://blog.numino.net/
CJZSCS smallint 2 0
GKqwl4 http://blog.numino.net/
BSCS smallint 2 0
Pk1VoC http://blog.numino.net/
BSTIME datetime 8 0
zO22yB http://blog.numino.net/
LEVELUPPOINT int 4 0
N9VFND http://blog.numino.net/
GDDS int 4 0
|
|