| 奇迹muonline数据库基础库分析 |
一、表的组成：
VCyjrU http://blog.numino.net/
1、AccountCharacter
MYWI51 http://blog.numino.net/
用来存放帐号的角色。
ByyuC1 http://blog.numino.net/
2、Character
hsB73u http://blog.numino.net/
用来存放每个角色的详细数据。
exNN6p http://blog.numino.net/
3、MEMB_INFO
j7KXCl http://blog.numino.net/
帐号信息
frI3uj http://blog.numino.net/
4、MEMB_STAT
E9FTta http://blog.numino.net/
帐号状态
4wiLE2 http://blog.numino.net/
5、warehouse
Bj4f3J http://blog.numino.net/
仓库
LzL8rU http://blog.numino.net/
6、VI_CURR_INFO
Q8eddN http://blog.numino.net/
帐号费用
DX22re http://blog.numino.net/
7、WEB_ZS
o31etw http://blog.numino.net/
PL 网站的转生数据
in7ymA http://blog.numino.net/
二、各表说明
6l6nqj http://blog.numino.net/
1、AccountCharacter 表
L2qWoA http://blog.numino.net/
列名 类型 长 是否空 说明
Ajpovg http://blog.numino.net/
Number int 4 0 自动增加的序数
TRH2mA http://blog.numino.net/
Id varchar 10 0 帐号
URMfgc http://blog.numino.net/
GameID1 varchar 10 1 角色1
i3p3Yi http://blog.numino.net/
GameID2 varchar 10 1 角色2
ipTcK2 http://blog.numino.net/
GameID3 varchar 10 1
0q1dna http://blog.numino.net/
GameID4 varchar 10 1
bZ1zq2 http://blog.numino.net/
GameID5 varchar 10 1
0MX9KG http://blog.numino.net/
GameIDC varchar 10 1
1KNSrC http://blog.numino.net/
2、Character 表
l08iOf http://blog.numino.net/
列名 类型 长 是否空 说明
07Fq68 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
2iL6xV http://blog.numino.net/
Name nvarchar 10 0 --------角色名
uKrya9 http://blog.numino.net/
cLevel smallint 2 1 --------等级
CZQ657 http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
hRgimb http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
tbzJBE http://blog.numino.net/
Experience int 4 1 --------经验
2IaKLJ http://blog.numino.net/
Strength smallint 2 1 --------力量
ldxAJC http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
kkb1yH http://blog.numino.net/
Vitality smallint 2 1 --------体力
PE6uae http://blog.numino.net/
Energy smallint 2 1 --------智力
a5X67P http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
BWQdl8 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
oSCt6g http://blog.numino.net/
Money int 4 1 --------钱
nRQFNa http://blog.numino.net/
Life real 4 1 --------
pRiHAG http://blog.numino.net/
MaxLife real 4 1 --------
2jnR9H http://blog.numino.net/
Mana real 4 1 --------
267I1J http://blog.numino.net/
MaxMana real 4 1 --------
Wds9rt http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
9liTwj http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
7ALEl5 http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
E10me6 http://blog.numino.net/
MapDir tinyint 1 1 --------
L247t8 http://blog.numino.net/
PkCount int 4 1 --------
ssLk2G http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
p9mjp6 http://blog.numino.net/
PkTime int 4 1
AliKWn http://blog.numino.net/
MDate smalldatetime 4 1
J6uOjP http://blog.numino.net/
LDate smalldatetime 4 1
uKL4nN http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
6UH95z http://blog.numino.net/
DbVersion tinyint 1 1
ZP6BRp http://blog.numino.net/
Quest varbinary 50 1
fPTQ3a http://blog.numino.net/
LINZB bit 1 0
25RwSq http://blog.numino.net/
XDTIME datetime 8 0
BSkwfd http://blog.numino.net/
STOPINFO nvarchar 100 1
C432A7 http://blog.numino.net/
STOPTIME datetime 8 0
o06ZQh http://blog.numino.net/
zs_count int 4 1
4uZZRt http://blog.numino.net/
zs_point int 4 1
hF6IU6 http://blog.numino.net/
bs_count int 4 1
9ZD3vV http://blog.numino.net/
bs_point int 4 1
jstj00 http://blog.numino.net/
shiji smalldatetime 4 1
1Uupo1 http://blog.numino.net/
banl nvarchar 10 1
5xu4kx http://blog.numino.net/
lv_time datetime 8 1
3cuUTg http://blog.numino.net/
ex_ok int 4 1
RQw73B http://blog.numino.net/
ex_total int 4 1
RIMP92 http://blog.numino.net/
rb_count int 4 1
phUP21 http://blog.numino.net/
rb_time datetime 8 1
1dcalv http://blog.numino.net/
pz_time datetime 8 1
moDlRm http://blog.numino.net/
3、MEMB_INFO
b6Mwc3 http://blog.numino.net/
列名 类型 长 是否空 说明
Ly574x http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
MCykmq http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
1xxPm1 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
FHt0uU http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
Rx9tsv http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
IbaN9L http://blog.numino.net/
post_code nvarchar 6 1 --------1234
j54baK http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
98zN42 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
Oe6QfH http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
GPI97D http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
ON1bsH http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
G15URa http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
Tpqt0m http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
yOYnBw http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
8feGgC http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
m0VT7g http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
4UtLJH http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
W51As7 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
1J931I http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
69Q71H http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
Mop9C2 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
X2I3vn http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
J5w9MW http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
kSutka http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
G55LcT http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
5G0DHL http://blog.numino.net/
QX char 1 1 --------B
5wpps5 http://blog.numino.net/
JF int 4 0 --------0
K5wX35 http://blog.numino.net/
huiy int 4 1 --------0
4ta3v5 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
Kb7grL http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
Ki319D http://blog.numino.net/
FDB int 4 1 --------0
KI0MGU http://blog.numino.net/
vip tinyint 1 1 --------0
c3A79P http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
fytrpO http://blog.numino.net/
4、MEMB_STAT
8aK6M4 http://blog.numino.net/
列名 类型 长 是否空 说明
XyJ392 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
3YV9gv http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
Wg5v7d http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
nbwfqR http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
cq26LI http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
Rk1PeQ http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
Y7sucX http://blog.numino.net/
5、warehouse
G2Y4X9 http://blog.numino.net/
列名 类型 长 是否空 说明
JFS7R5 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
dCoz6b http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
jNNB22 http://blog.numino.net/
Money int 4 1 --------钱
GgUny2 http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
20kCp9 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
Gj5MIh http://blog.numino.net/
pw smallint 2 1 --------密码 0
67qHX3 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
lUI5LC http://blog.numino.net/
ExtCKNum int 4 0 --------0
N1oqSk http://blog.numino.net/
NeedExtCK int 4 0 --------0
oBK6AA http://blog.numino.net/
6、VI_CURR_INFO
7VtOO4 http://blog.numino.net/
列名 类型 长 是否空 说明
hEPplI http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
7O1Yj2 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
02GBq5 http://blog.numino.net/
used_time int 4 1 --------1234
l3rI93 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
Vg1Bm9 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
Z2tpIl http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
6G7fRJ http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
5eCIkK http://blog.numino.net/
Bill_Section int 4 1 --------6
VjHuM3 http://blog.numino.net/
Bill_Value int 4 1 --------3
Sgj09c http://blog.numino.net/
Bill_Hour int 4 1 --------0
w16aPH http://blog.numino.net/
Surplus_Point int 4 1 --------0
CPahMz http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
Jk9uPP http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
0lWNo2 http://blog.numino.net/
7、WEB_ZS
jz94jS http://blog.numino.net/
列名 类型 长 是否空 说明
7trx6H http://blog.numino.net/
ID bigint 8 0
OK4YuO http://blog.numino.net/
ACC char 10 1
1q7E5r http://blog.numino.net/
NAME char 10 1
k7ob1P http://blog.numino.net/
ZSTIME datetime 8 1
ol2CBI http://blog.numino.net/
ZSCLEVEL smallint 2 1
43WPOj http://blog.numino.net/
ZSCS smallint 2 0
kJFrFQ http://blog.numino.net/
CZCS smallint 2 0
NI5RHz http://blog.numino.net/
CZTIME datetime 8 0
T1i1Wv http://blog.numino.net/
ZJZSCS smallint 2 0
Vu4pdn http://blog.numino.net/
GJZSCS smallint 2 0
qEBu6s http://blog.numino.net/
CJZSCS smallint 2 0
pfbi2t http://blog.numino.net/
BSCS smallint 2 0
203nnN http://blog.numino.net/
BSTIME datetime 8 0
Ib9k7L http://blog.numino.net/
LEVELUPPOINT int 4 0
sTb6xW http://blog.numino.net/
GDDS int 4 0
|
|