| 奇迹muonline数据库基础库分析 |
一、表的组成：
DbvJR5 http://www.numino.net
1、AccountCharacter
yzkXT7 http://www.numino.net
用来存放帐号的角色。
LrIcFW http://www.numino.net
2、Character
dt8f4S http://www.numino.net
用来存放每个角色的详细数据。
mjj0dq http://www.numino.net
3、MEMB_INFO
7M0kYy http://www.numino.net
帐号信息
4SLIrX http://www.numino.net
4、MEMB_STAT
AgA2pr http://www.numino.net
帐号状态
DQLawQ http://www.numino.net
5、warehouse
Je2SCC http://www.numino.net
仓库
qWh8jV http://www.numino.net
6、VI_CURR_INFO
Fbw1Pz http://www.numino.net
帐号费用
n4W3mU http://www.numino.net
7、WEB_ZS
sS05E2 http://www.numino.net
PL 网站的转生数据
xgtzT4 http://www.numino.net
二、各表说明
Y0oYV9 http://www.numino.net
1、AccountCharacter 表
d54P34 http://www.numino.net
列名 类型 长 是否空 说明
6Q7Iao http://www.numino.net
Number int 4 0 自动增加的序数
bT34Y3 http://www.numino.net
Id varchar 10 0 帐号
3b4yU4 http://www.numino.net
GameID1 varchar 10 1 角色1
vVZ4va http://www.numino.net
GameID2 varchar 10 1 角色2
R1x4IF http://www.numino.net
GameID3 varchar 10 1
p9n7oy http://www.numino.net
GameID4 varchar 10 1
95QO3q http://www.numino.net
GameID5 varchar 10 1
WS1MsF http://www.numino.net
GameIDC varchar 10 1
WMXPZ1 http://www.numino.net
2、Character 表
lv59AQ http://www.numino.net
列名 类型 长 是否空 说明
Ay12D4 http://www.numino.net
AccountID varchar 10 0 --------帐号
nlKLtb http://www.numino.net
Name nvarchar 10 0 --------角色名
lutHEn http://www.numino.net
cLevel smallint 2 1 --------等级
T8zzaJ http://www.numino.net
LevelUpPoint int 4 1 --------升级点
4pqVUY http://www.numino.net
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
4aAgrj http://www.numino.net
Experience int 4 1 --------经验
oZwM5t http://www.numino.net
Strength smallint 2 1 --------力量
A6PJy2 http://www.numino.net
Dexterity smallint 2 1 --------敏捷
A8Fbpa http://www.numino.net
Vitality smallint 2 1 --------体力
5hbTzI http://www.numino.net
Energy smallint 2 1 --------智力
15t65y http://www.numino.net
Inventory varbinary 760 1 --------身上仓库
jbu6vG http://www.numino.net
MagicList varbinary 60 1 --------技能
4GyNb1 http://www.numino.net
Money int 4 1 --------钱
j7l93r http://www.numino.net
Life real 4 1 --------
SA8HSW http://www.numino.net
MaxLife real 4 1 --------
30w09O http://www.numino.net
Mana real 4 1 --------
0CWBM0 http://www.numino.net
MaxMana real 4 1 --------
DU5ChU http://www.numino.net
MapNumber smallint 2 1 --------所在地图号
uGoJ44 http://www.numino.net
MapPosX smallint 2 1 --------X坐标
4LMrFq http://www.numino.net
MapPosY smallint 2 1 --------Y坐标
Bq1tda http://www.numino.net
MapDir tinyint 1 1 --------
BNi7DJ http://www.numino.net
PkCount int 4 1 --------
y76E7T http://www.numino.net
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
ihL6Ip http://www.numino.net
PkTime int 4 1
C1yGA2 http://www.numino.net
MDate smalldatetime 4 1
xrohZD http://www.numino.net
LDate smalldatetime 4 1
W6021o http://www.numino.net
CtlCode tinyint 1 1 --------0 普通角色 8GM
zG5YLn http://www.numino.net
DbVersion tinyint 1 1
k5P8OG http://www.numino.net
Quest varbinary 50 1
Ob2yuA http://www.numino.net
LINZB bit 1 0
T4q9HI http://www.numino.net
XDTIME datetime 8 0
h7v15W http://www.numino.net
STOPINFO nvarchar 100 1
tryBaY http://www.numino.net
STOPTIME datetime 8 0
vr450C http://www.numino.net
zs_count int 4 1
13bSqZ http://www.numino.net
zs_point int 4 1
Y104TP http://www.numino.net
bs_count int 4 1
ou0LJa http://www.numino.net
bs_point int 4 1
Zzs80p http://www.numino.net
shiji smalldatetime 4 1
BqQFh3 http://www.numino.net
banl nvarchar 10 1
eFOLTC http://www.numino.net
lv_time datetime 8 1
1GuA9i http://www.numino.net
ex_ok int 4 1
2569jF http://www.numino.net
ex_total int 4 1
0Uw9F8 http://www.numino.net
rb_count int 4 1
00abYA http://www.numino.net
rb_time datetime 8 1
dxociz http://www.numino.net
pz_time datetime 8 1
803sir http://www.numino.net
3、MEMB_INFO
zNB51o http://www.numino.net
列名 类型 长 是否空 说明
RDRgZC http://www.numino.net
memb_guid int 4 0 -------- 1(系统自动生成)
0NkZ18 http://www.numino.net
memb___id nvarchar 10 0 --------帐号
Pdngco http://www.numino.net
memb__pwd nvarchar 10 0 --------密码
s9nDhh http://www.numino.net
memb_name nvarchar 10 0 --------昵称 (1)
nISkOV http://www.numino.net
sno__numb nvarchar 18 0 --------1
rs8s1Q http://www.numino.net
post_code nvarchar 6 1 --------1234
Fymdw9 http://www.numino.net
addr_info nvarchar 50 1 --------XXXXXXXXXXX
TN4iZ4 http://www.numino.net
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
9YSNyI http://www.numino.net
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
sV5pNL http://www.numino.net
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
q9c1Ea http://www.numino.net
mail_addr nvarchar 50 1 --------邮件地址
4AMMA9 http://www.numino.net
fpas_ques nvarchar 50 1 --------密码提示问题
5GtEwm http://www.numino.net
fpas_answ nvarchar 50 1 --------答案
Xjd7vi http://www.numino.net
job__code nvarchar 2 1 --------XXXXXXXXXXXX
1tW89f http://www.numino.net
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
ox0R1K http://www.numino.net
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
d47i8o http://www.numino.net
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
8985LA http://www.numino.net
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
B5a8e1 http://www.numino.net
mail_chek nvarchar 1 1 -------- 0 或 1
kA4TrJ http://www.numino.net
bloc_code nvarchar 1 0 --------0 正常 >0封号
u69Quj http://www.numino.net
ctl1_code nvarchar 1 0 --------0
Uyn9QB http://www.numino.net
LINZBSJ datetime 8 1 --------NULL
E82t81 http://www.numino.net
LGONGZHISJ datetime 8 1 --------NULL
B50kWw http://www.numino.net
STOPINFO nvarchar 100 1 --------NULL
05ngEl http://www.numino.net
STOPTIME datetime 8 1 --------NULL
yN32ms http://www.numino.net
QX char 1 1 --------B
QXiD5D http://www.numino.net
JF int 4 0 --------0
fPbTXq http://www.numino.net
huiy int 4 1 --------0
LHjQ4Q http://www.numino.net
hysj smalldatetime 4 1 --------NULL
D67945 http://www.numino.net
lqsj smalldatetime 4 1 --------NULL
i403ST http://www.numino.net
FDB int 4 1 --------0
YQqx3c http://www.numino.net
vip tinyint 1 1 --------0
a0OFqX http://www.numino.net
Expired datetime 8 1 --------2005-6-6 23:00:05
7bzeeZ http://www.numino.net
4、MEMB_STAT
6VdByy http://www.numino.net
列名 类型 长 是否空 说明
3VzioF http://www.numino.net
memb___id nvarchar 10 0 --------帐号
026v1n http://www.numino.net
ConnectStat tinyint 1 1 --------是否在线 0：不在线
s091g6 http://www.numino.net
ServerName nvarchar 20 1 --------连接的线名
V6Joe3 http://www.numino.net
IP nvarchar 15 1 --------IP地址
QYN7nr http://www.numino.net
ConnectTM smalldatetime 4 1 --------上线日期、时间
p8ZeL1 http://www.numino.net
DisConnectTM smalldatetime 4 1 --------下线日期、时间
ybILpp http://www.numino.net
5、warehouse
BFVLq7 http://www.numino.net
列名 类型 长 是否空 说明
v439YE http://www.numino.net
AccountID varchar 10 0 --------帐号
xQToxL http://www.numino.net
Items varbinary 1200 1 --------仓库物品
1nAeOa http://www.numino.net
Money int 4 1 --------钱
G4wuQE http://www.numino.net
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
n12Hqn http://www.numino.net
DbVersion tinyint 1 1 --------1
nklprO http://www.numino.net
pw smallint 2 1 --------密码 0
SKWcXP http://www.numino.net
lastpw smallint 2 0 --------最后密码 0
IDwg0W http://www.numino.net
ExtCKNum int 4 0 --------0
UOaKJZ http://www.numino.net
NeedExtCK int 4 0 --------0
aDN1t9 http://www.numino.net
6、VI_CURR_INFO
TE2DH4 http://www.numino.net
列名 类型 长 是否空 说明
xFeqK5 http://www.numino.net
ends_days nvarchar 8 1 --------20081111
P78H0t http://www.numino.net
chek_code nvarchar 1 0 --------1
8rl7W0 http://www.numino.net
used_time int 4 1 --------1234
2lltsW http://www.numino.net
memb___id nvarchar 10 0 --------帐号
L99dtZ http://www.numino.net
memb_name nvarchar 10 0 --------昵称
1wp8o2 http://www.numino.net
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
IrFKsc http://www.numino.net
sno__numb nvarchar 18 0 --------123456
gUXo8b http://www.numino.net
Bill_Section int 4 1 --------6
8Bm6gQ http://www.numino.net
Bill_Value int 4 1 --------3
2DBl28 http://www.numino.net
Bill_Hour int 4 1 --------0
1ub2Ti http://www.numino.net
Surplus_Point int 4 1 --------0
MUGh46 http://www.numino.net
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
AD1sqh http://www.numino.net
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
O1nqI6 http://www.numino.net
7、WEB_ZS
UCwFt7 http://www.numino.net
列名 类型 长 是否空 说明
c76Woy http://www.numino.net
ID bigint 8 0
zaSB5c http://www.numino.net
ACC char 10 1
GUw9II http://www.numino.net
NAME char 10 1
jw95G7 http://www.numino.net
ZSTIME datetime 8 1
pAwaz7 http://www.numino.net
ZSCLEVEL smallint 2 1
888sMl http://www.numino.net
ZSCS smallint 2 0
D5xj1R http://www.numino.net
CZCS smallint 2 0
74K8ya http://www.numino.net
CZTIME datetime 8 0
O8d5eM http://www.numino.net
ZJZSCS smallint 2 0
KXY97T http://www.numino.net
GJZSCS smallint 2 0
XWRyU4 http://www.numino.net
CJZSCS smallint 2 0
aOdGrV http://www.numino.net
BSCS smallint 2 0
xlkcMn http://www.numino.net
BSTIME datetime 8 0
w0t8Rp http://www.numino.net
LEVELUPPOINT int 4 0
e1Q7s7 http://www.numino.net
GDDS int 4 0
|
|