| 奇迹muonline数据库基础库分析 |
一、表的组成：
0wOyym http://blog.numino.net/
1、AccountCharacter
8Dz0w7 http://blog.numino.net/
用来存放帐号的角色。
Xk3OF7 http://blog.numino.net/
2、Character
8NHkN7 http://blog.numino.net/
用来存放每个角色的详细数据。
841fX8 http://blog.numino.net/
3、MEMB_INFO
nOJoyo http://blog.numino.net/
帐号信息
N9r76k http://blog.numino.net/
4、MEMB_STAT
4bp5Y0 http://blog.numino.net/
帐号状态
19OQEO http://blog.numino.net/
5、warehouse
lsAGb7 http://blog.numino.net/
仓库
N6j6HV http://blog.numino.net/
6、VI_CURR_INFO
hMxUwg http://blog.numino.net/
帐号费用
4BMgY6 http://blog.numino.net/
7、WEB_ZS
RN2xqx http://blog.numino.net/
PL 网站的转生数据
T15dMK http://blog.numino.net/
二、各表说明
hd08EB http://blog.numino.net/
1、AccountCharacter 表
2Fo4PG http://blog.numino.net/
列名 类型 长 是否空 说明
SU4NNK http://blog.numino.net/
Number int 4 0 自动增加的序数
2fM9pn http://blog.numino.net/
Id varchar 10 0 帐号
270Q8h http://blog.numino.net/
GameID1 varchar 10 1 角色1
lOM3Li http://blog.numino.net/
GameID2 varchar 10 1 角色2
U1wg5x http://blog.numino.net/
GameID3 varchar 10 1
Bv32gM http://blog.numino.net/
GameID4 varchar 10 1
j622vj http://blog.numino.net/
GameID5 varchar 10 1
5o1I8e http://blog.numino.net/
GameIDC varchar 10 1
3PSyU3 http://blog.numino.net/
2、Character 表
538dN1 http://blog.numino.net/
列名 类型 长 是否空 说明
psb7Xg http://blog.numino.net/
AccountID varchar 10 0 --------帐号
rLqtx8 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
nSk1Z8 http://blog.numino.net/
cLevel smallint 2 1 --------等级
x8fq0X http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
C7WN5u http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
90ujh0 http://blog.numino.net/
Experience int 4 1 --------经验
Uui6TN http://blog.numino.net/
Strength smallint 2 1 --------力量
TDD9l7 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
i1QN1D http://blog.numino.net/
Vitality smallint 2 1 --------体力
1uD7sV http://blog.numino.net/
Energy smallint 2 1 --------智力
3y1euT http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
8i29UG http://blog.numino.net/
MagicList varbinary 60 1 --------技能
693Xan http://blog.numino.net/
Money int 4 1 --------钱
sWUoZ2 http://blog.numino.net/
Life real 4 1 --------
3EUkjF http://blog.numino.net/
MaxLife real 4 1 --------
ywlCkd http://blog.numino.net/
Mana real 4 1 --------
pAK5zR http://blog.numino.net/
MaxMana real 4 1 --------
JF08I0 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
UKz9ll http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
HAV8TK http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
n2m7n4 http://blog.numino.net/
MapDir tinyint 1 1 --------
p7ue90 http://blog.numino.net/
PkCount int 4 1 --------
F5FJVn http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
edbFUe http://blog.numino.net/
PkTime int 4 1
ub5mS1 http://blog.numino.net/
MDate smalldatetime 4 1
BH52Dg http://blog.numino.net/
LDate smalldatetime 4 1
qC92ji http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
4zmQZ5 http://blog.numino.net/
DbVersion tinyint 1 1
oszOew http://blog.numino.net/
Quest varbinary 50 1
3qltt0 http://blog.numino.net/
LINZB bit 1 0
6T1dd2 http://blog.numino.net/
XDTIME datetime 8 0
ct1RkG http://blog.numino.net/
STOPINFO nvarchar 100 1
mMs8d7 http://blog.numino.net/
STOPTIME datetime 8 0
H0G007 http://blog.numino.net/
zs_count int 4 1
G20ahI http://blog.numino.net/
zs_point int 4 1
aT2da7 http://blog.numino.net/
bs_count int 4 1
EfZuss http://blog.numino.net/
bs_point int 4 1
Q9pSlq http://blog.numino.net/
shiji smalldatetime 4 1
NNIoXq http://blog.numino.net/
banl nvarchar 10 1
U8MnD4 http://blog.numino.net/
lv_time datetime 8 1
KRTUht http://blog.numino.net/
ex_ok int 4 1
y4JeZk http://blog.numino.net/
ex_total int 4 1
eKhlQQ http://blog.numino.net/
rb_count int 4 1
0qgyDG http://blog.numino.net/
rb_time datetime 8 1
CQkpkr http://blog.numino.net/
pz_time datetime 8 1
aQUF66 http://blog.numino.net/
3、MEMB_INFO
3s4n97 http://blog.numino.net/
列名 类型 长 是否空 说明
KFF6UE http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
mlL951 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
kt0Q6U http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
l81mEr http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
5DUE44 http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
VQ9o45 http://blog.numino.net/
post_code nvarchar 6 1 --------1234
c8TewI http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
RSW8yY http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
V8yZ79 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
7i1vn4 http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
OjlZFV http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
27fzf2 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
dvfLP3 http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
y0R9kP http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
Ebv2u0 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
EtX6oM http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
Q9L13d http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
etRBHa http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
AmZE68 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
Wm23st http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
QNBxum http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
xi88mC http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
i67x9B http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
bU2DH4 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
y80tJ1 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
rEPU9B http://blog.numino.net/
QX char 1 1 --------B
tIKQ9w http://blog.numino.net/
JF int 4 0 --------0
QZsQrD http://blog.numino.net/
huiy int 4 1 --------0
6jdj3p http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
0TUnt9 http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
14zqdb http://blog.numino.net/
FDB int 4 1 --------0
Npt5Y4 http://blog.numino.net/
vip tinyint 1 1 --------0
dcYKU1 http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
b3nrI2 http://blog.numino.net/
4、MEMB_STAT
BAYwng http://blog.numino.net/
列名 类型 长 是否空 说明
wsgHDH http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
GJ38sC http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
V6BZ5Q http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
svBb9v http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
Y4YRwV http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
hzl2R5 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
Wm6P72 http://blog.numino.net/
5、warehouse
o64K9E http://blog.numino.net/
列名 类型 长 是否空 说明
H6t3N8 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
33L967 http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
0mHpwK http://blog.numino.net/
Money int 4 1 --------钱
I26KRt http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
0jUY19 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
bu3z8p http://blog.numino.net/
pw smallint 2 1 --------密码 0
T4a6AW http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
aMlhDR http://blog.numino.net/
ExtCKNum int 4 0 --------0
PrAT4m http://blog.numino.net/
NeedExtCK int 4 0 --------0
0oruaU http://blog.numino.net/
6、VI_CURR_INFO
MaO21k http://blog.numino.net/
列名 类型 长 是否空 说明
04G0Zz http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
8ypTe2 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
Avo5yT http://blog.numino.net/
used_time int 4 1 --------1234
4K3Jv9 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
lXOUk0 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
LoVnv3 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
7D4F5f http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
ZcUIFu http://blog.numino.net/
Bill_Section int 4 1 --------6
6k60PT http://blog.numino.net/
Bill_Value int 4 1 --------3
76wN7Y http://blog.numino.net/
Bill_Hour int 4 1 --------0
wd81Pt http://blog.numino.net/
Surplus_Point int 4 1 --------0
hdi8S1 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
PkDH0d http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
rg138a http://blog.numino.net/
7、WEB_ZS
50qJM1 http://blog.numino.net/
列名 类型 长 是否空 说明
qm3H6F http://blog.numino.net/
ID bigint 8 0
a7KKrp http://blog.numino.net/
ACC char 10 1
DQYLuP http://blog.numino.net/
NAME char 10 1
bZt0G5 http://blog.numino.net/
ZSTIME datetime 8 1
Sxq62I http://blog.numino.net/
ZSCLEVEL smallint 2 1
Pfi2J5 http://blog.numino.net/
ZSCS smallint 2 0
fov8Ft http://blog.numino.net/
CZCS smallint 2 0
yNL4Wl http://blog.numino.net/
CZTIME datetime 8 0
lllQT6 http://blog.numino.net/
ZJZSCS smallint 2 0
8TYeV8 http://blog.numino.net/
GJZSCS smallint 2 0
5gLRYc http://blog.numino.net/
CJZSCS smallint 2 0
Mjuody http://blog.numino.net/
BSCS smallint 2 0
XXRnDg http://blog.numino.net/
BSTIME datetime 8 0
T30zoX http://blog.numino.net/
LEVELUPPOINT int 4 0
4i1BGS http://blog.numino.net/
GDDS int 4 0
|
|