| 奇迹muonline数据库基础库分析 |
一、表的组成：
9ifkpU http://blog.numino.net/
1、AccountCharacter
XeTEOB http://blog.numino.net/
用来存放帐号的角色。
458rsQ http://blog.numino.net/
2、Character
5dauP2 http://blog.numino.net/
用来存放每个角色的详细数据。
CJhOma http://blog.numino.net/
3、MEMB_INFO
c4O1hj http://blog.numino.net/
帐号信息
kX7umL http://blog.numino.net/
4、MEMB_STAT
O6YF8u http://blog.numino.net/
帐号状态
k4GKX5 http://blog.numino.net/
5、warehouse
r2qBN9 http://blog.numino.net/
仓库
uaWi6w http://blog.numino.net/
6、VI_CURR_INFO
57oK0v http://blog.numino.net/
帐号费用
eD9US6 http://blog.numino.net/
7、WEB_ZS
Y8cvU0 http://blog.numino.net/
PL 网站的转生数据
VT9QD1 http://blog.numino.net/
二、各表说明
OS75tu http://blog.numino.net/
1、AccountCharacter 表
3yNudg http://blog.numino.net/
列名 类型 长 是否空 说明
UQRKZ0 http://blog.numino.net/
Number int 4 0 自动增加的序数
IlJmSu http://blog.numino.net/
Id varchar 10 0 帐号
eW7Pn9 http://blog.numino.net/
GameID1 varchar 10 1 角色1
0FaWyj http://blog.numino.net/
GameID2 varchar 10 1 角色2
TvIk4V http://blog.numino.net/
GameID3 varchar 10 1
1Tk6Li http://blog.numino.net/
GameID4 varchar 10 1
l831AC http://blog.numino.net/
GameID5 varchar 10 1
ZjFs1e http://blog.numino.net/
GameIDC varchar 10 1
b8h2hN http://blog.numino.net/
2、Character 表
CQk9Od http://blog.numino.net/
列名 类型 长 是否空 说明
y8Vbl2 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
gDMdm2 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
SbW6m1 http://blog.numino.net/
cLevel smallint 2 1 --------等级
fkB8QV http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
8CoGQd http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
tNgw0d http://blog.numino.net/
Experience int 4 1 --------经验
Kl0g7N http://blog.numino.net/
Strength smallint 2 1 --------力量
7gJuzl http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
F012QL http://blog.numino.net/
Vitality smallint 2 1 --------体力
JqlCGg http://blog.numino.net/
Energy smallint 2 1 --------智力
jaMdsG http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
GRqtWL http://blog.numino.net/
MagicList varbinary 60 1 --------技能
XHxu5s http://blog.numino.net/
Money int 4 1 --------钱
31Mh2j http://blog.numino.net/
Life real 4 1 --------
D64cJ5 http://blog.numino.net/
MaxLife real 4 1 --------
yPT83u http://blog.numino.net/
Mana real 4 1 --------
dp95v5 http://blog.numino.net/
MaxMana real 4 1 --------
1eusDN http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
VTUJ69 http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
z5F8Up http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
C9QfqA http://blog.numino.net/
MapDir tinyint 1 1 --------
KCv2G7 http://blog.numino.net/
PkCount int 4 1 --------
vuPOcq http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
6umXx2 http://blog.numino.net/
PkTime int 4 1
7HESzO http://blog.numino.net/
MDate smalldatetime 4 1
4ctnrd http://blog.numino.net/
LDate smalldatetime 4 1
07eOSp http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
X3a6q1 http://blog.numino.net/
DbVersion tinyint 1 1
9u6tNt http://blog.numino.net/
Quest varbinary 50 1
935Ub0 http://blog.numino.net/
LINZB bit 1 0
IPhEzU http://blog.numino.net/
XDTIME datetime 8 0
8pmW5f http://blog.numino.net/
STOPINFO nvarchar 100 1
EVMoJg http://blog.numino.net/
STOPTIME datetime 8 0
vymG4B http://blog.numino.net/
zs_count int 4 1
1H36y0 http://blog.numino.net/
zs_point int 4 1
a93qB0 http://blog.numino.net/
bs_count int 4 1
n1c64p http://blog.numino.net/
bs_point int 4 1
1yUcdV http://blog.numino.net/
shiji smalldatetime 4 1
Z80Ig4 http://blog.numino.net/
banl nvarchar 10 1
atB546 http://blog.numino.net/
lv_time datetime 8 1
ukrw3F http://blog.numino.net/
ex_ok int 4 1
yxI6dl http://blog.numino.net/
ex_total int 4 1
7Ft28b http://blog.numino.net/
rb_count int 4 1
5286PM http://blog.numino.net/
rb_time datetime 8 1
FgFr62 http://blog.numino.net/
pz_time datetime 8 1
3JdyhO http://blog.numino.net/
3、MEMB_INFO
h47aVV http://blog.numino.net/
列名 类型 长 是否空 说明
zIWEqS http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
eg05GD http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
d5A1kp http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
XfA9KR http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
1QG3lq http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
374TCn http://blog.numino.net/
post_code nvarchar 6 1 --------1234
4Zw9yt http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
Gmd4cE http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
uWCqWh http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
v9Z56t http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
6BSCIY http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
4E7Jz2 http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
M1N2fq http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
68DmNo http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
f2Sv65 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
R0qE1r http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
6s102T http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
uSSF1o http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
M1hBRw http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
xSQYVL http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
S0G2mE http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
yD8de2 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
i7DF7i http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
3k8G5J http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
br08fs http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
dcYeKm http://blog.numino.net/
QX char 1 1 --------B
VJ6H9p http://blog.numino.net/
JF int 4 0 --------0
Z5571D http://blog.numino.net/
huiy int 4 1 --------0
9Z3LdB http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
NX6kJp http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
G1fGoV http://blog.numino.net/
FDB int 4 1 --------0
gXgYvO http://blog.numino.net/
vip tinyint 1 1 --------0
6I2n7V http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
F4F931 http://blog.numino.net/
4、MEMB_STAT
YRSJD3 http://blog.numino.net/
列名 类型 长 是否空 说明
3yme5T http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
7tp9Wu http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
os34gi http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
HNRKyL http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
csFfvJ http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
67HfRt http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
lTrT01 http://blog.numino.net/
5、warehouse
2r4eSZ http://blog.numino.net/
列名 类型 长 是否空 说明
UoGE7z http://blog.numino.net/
AccountID varchar 10 0 --------帐号
71n6yo http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
8F8F89 http://blog.numino.net/
Money int 4 1 --------钱
N4QToF http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
vCFJZ3 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
eu59T4 http://blog.numino.net/
pw smallint 2 1 --------密码 0
tmYu76 http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
b3z7LS http://blog.numino.net/
ExtCKNum int 4 0 --------0
6sVt4Q http://blog.numino.net/
NeedExtCK int 4 0 --------0
a77GxL http://blog.numino.net/
6、VI_CURR_INFO
xAZt5p http://blog.numino.net/
列名 类型 长 是否空 说明
9cg7CD http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
aYwyCH http://blog.numino.net/
chek_code nvarchar 1 0 --------1
Js0YGN http://blog.numino.net/
used_time int 4 1 --------1234
i55WJf http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
9kqk58 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
pkbPZD http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
9v3n4T http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
XcJK2E http://blog.numino.net/
Bill_Section int 4 1 --------6
hRx5fY http://blog.numino.net/
Bill_Value int 4 1 --------3
AgA13e http://blog.numino.net/
Bill_Hour int 4 1 --------0
y3G46R http://blog.numino.net/
Surplus_Point int 4 1 --------0
l0dr4E http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
wqRmzg http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
25M2Uv http://blog.numino.net/
7、WEB_ZS
798KZD http://blog.numino.net/
列名 类型 长 是否空 说明
4Pjhdw http://blog.numino.net/
ID bigint 8 0
QSzbDf http://blog.numino.net/
ACC char 10 1
a7F3Mz http://blog.numino.net/
NAME char 10 1
Ccv486 http://blog.numino.net/
ZSTIME datetime 8 1
S2L2QH http://blog.numino.net/
ZSCLEVEL smallint 2 1
Lu9qY6 http://blog.numino.net/
ZSCS smallint 2 0
0WEF44 http://blog.numino.net/
CZCS smallint 2 0
UYY2tq http://blog.numino.net/
CZTIME datetime 8 0
A7A4pI http://blog.numino.net/
ZJZSCS smallint 2 0
4XqPzJ http://blog.numino.net/
GJZSCS smallint 2 0
4WWam5 http://blog.numino.net/
CJZSCS smallint 2 0
cx88Iv http://blog.numino.net/
BSCS smallint 2 0
gA57id http://blog.numino.net/
BSTIME datetime 8 0
17QDJN http://blog.numino.net/
LEVELUPPOINT int 4 0
l8F0xP http://blog.numino.net/
GDDS int 4 0
|
|