| 奇迹muonline数据库基础库分析 |
一、表的组成：
UiwR77 http://www.numino.net
1、AccountCharacter
QU2RCM http://www.numino.net
用来存放帐号的角色。
n5HSmX http://www.numino.net
2、Character
3IM4Wd http://www.numino.net
用来存放每个角色的详细数据。
u8QP90 http://www.numino.net
3、MEMB_INFO
3d448D http://www.numino.net
帐号信息
9eDpaQ http://www.numino.net
4、MEMB_STAT
h0n9X8 http://www.numino.net
帐号状态
YoXjYQ http://www.numino.net
5、warehouse
2UAGU6 http://www.numino.net
仓库
1lWQV6 http://www.numino.net
6、VI_CURR_INFO
7HVW9A http://www.numino.net
帐号费用
Gd4i50 http://www.numino.net
7、WEB_ZS
pr022K http://www.numino.net
PL 网站的转生数据
4cvzSL http://www.numino.net
二、各表说明
a5nhHS http://www.numino.net
1、AccountCharacter 表
JRmMTZ http://www.numino.net
列名 类型 长 是否空 说明
3uyYvK http://www.numino.net
Number int 4 0 自动增加的序数
3Ec9yf http://www.numino.net
Id varchar 10 0 帐号
n2LEJ4 http://www.numino.net
GameID1 varchar 10 1 角色1
RwE9H9 http://www.numino.net
GameID2 varchar 10 1 角色2
BQR4nb http://www.numino.net
GameID3 varchar 10 1
Fc3w5X http://www.numino.net
GameID4 varchar 10 1
CytNUT http://www.numino.net
GameID5 varchar 10 1
0xG4Tu http://www.numino.net
GameIDC varchar 10 1
kgRKRR http://www.numino.net
2、Character 表
VhjRj5 http://www.numino.net
列名 类型 长 是否空 说明
ESUhtr http://www.numino.net
AccountID varchar 10 0 --------帐号
gqzLYk http://www.numino.net
Name nvarchar 10 0 --------角色名
E9bAr4 http://www.numino.net
cLevel smallint 2 1 --------等级
1pbpIw http://www.numino.net
LevelUpPoint int 4 1 --------升级点
nYKSQu http://www.numino.net
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
62Sg00 http://www.numino.net
Experience int 4 1 --------经验
0HVapQ http://www.numino.net
Strength smallint 2 1 --------力量
WO7Y0q http://www.numino.net
Dexterity smallint 2 1 --------敏捷
6tbLZf http://www.numino.net
Vitality smallint 2 1 --------体力
SB4Z2H http://www.numino.net
Energy smallint 2 1 --------智力
TBsv8s http://www.numino.net
Inventory varbinary 760 1 --------身上仓库
yHKghu http://www.numino.net
MagicList varbinary 60 1 --------技能
Sx3SEW http://www.numino.net
Money int 4 1 --------钱
3cNMLT http://www.numino.net
Life real 4 1 --------
Hvyy39 http://www.numino.net
MaxLife real 4 1 --------
diWz36 http://www.numino.net
Mana real 4 1 --------
6yA6va http://www.numino.net
MaxMana real 4 1 --------
EsV8XJ http://www.numino.net
MapNumber smallint 2 1 --------所在地图号
tJ236c http://www.numino.net
MapPosX smallint 2 1 --------X坐标
tni92I http://www.numino.net
MapPosY smallint 2 1 --------Y坐标
emiC8E http://www.numino.net
MapDir tinyint 1 1 --------
3B88Ox http://www.numino.net
PkCount int 4 1 --------
C3uDG2 http://www.numino.net
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
dsd5h9 http://www.numino.net
PkTime int 4 1
AUixy4 http://www.numino.net
MDate smalldatetime 4 1
lq1418 http://www.numino.net
LDate smalldatetime 4 1
7DJxSi http://www.numino.net
CtlCode tinyint 1 1 --------0 普通角色 8GM
dU409I http://www.numino.net
DbVersion tinyint 1 1
bwAAjV http://www.numino.net
Quest varbinary 50 1
wlaMee http://www.numino.net
LINZB bit 1 0
7qetXE http://www.numino.net
XDTIME datetime 8 0
ALI2SH http://www.numino.net
STOPINFO nvarchar 100 1
JKr0Pm http://www.numino.net
STOPTIME datetime 8 0
KVsgXF http://www.numino.net
zs_count int 4 1
p4ddgD http://www.numino.net
zs_point int 4 1
0A6Zr6 http://www.numino.net
bs_count int 4 1
lsUWTI http://www.numino.net
bs_point int 4 1
r28SG9 http://www.numino.net
shiji smalldatetime 4 1
jHZ8RF http://www.numino.net
banl nvarchar 10 1
MpTjdq http://www.numino.net
lv_time datetime 8 1
vcIDUQ http://www.numino.net
ex_ok int 4 1
L4MZ2m http://www.numino.net
ex_total int 4 1
Dw4DSX http://www.numino.net
rb_count int 4 1
9XMeyP http://www.numino.net
rb_time datetime 8 1
G1NctR http://www.numino.net
pz_time datetime 8 1
Hc98Jd http://www.numino.net
3、MEMB_INFO
7W8a4m http://www.numino.net
列名 类型 长 是否空 说明
siBjUK http://www.numino.net
memb_guid int 4 0 -------- 1(系统自动生成)
iulFsm http://www.numino.net
memb___id nvarchar 10 0 --------帐号
Hjpav7 http://www.numino.net
memb__pwd nvarchar 10 0 --------密码
uKp3ws http://www.numino.net
memb_name nvarchar 10 0 --------昵称 (1)
Ejczvg http://www.numino.net
sno__numb nvarchar 18 0 --------1
Rj4fq9 http://www.numino.net
post_code nvarchar 6 1 --------1234
qjs0JE http://www.numino.net
addr_info nvarchar 50 1 --------XXXXXXXXXXX
fd2CYK http://www.numino.net
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
5akQiI http://www.numino.net
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
MCh86v http://www.numino.net
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
JaV3yh http://www.numino.net
mail_addr nvarchar 50 1 --------邮件地址
9goWO4 http://www.numino.net
fpas_ques nvarchar 50 1 --------密码提示问题
D6OqO7 http://www.numino.net
fpas_answ nvarchar 50 1 --------答案
A08jnz http://www.numino.net
job__code nvarchar 2 1 --------XXXXXXXXXXXX
w7WZ4C http://www.numino.net
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
528DL1 http://www.numino.net
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
4mDb4K http://www.numino.net
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
Oz1gri http://www.numino.net
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
TMTy27 http://www.numino.net
mail_chek nvarchar 1 1 -------- 0 或 1
NLddn9 http://www.numino.net
bloc_code nvarchar 1 0 --------0 正常 >0封号
k6jM64 http://www.numino.net
ctl1_code nvarchar 1 0 --------0
7vX76D http://www.numino.net
LINZBSJ datetime 8 1 --------NULL
r2cf9Y http://www.numino.net
LGONGZHISJ datetime 8 1 --------NULL
5o66o5 http://www.numino.net
STOPINFO nvarchar 100 1 --------NULL
JcJK32 http://www.numino.net
STOPTIME datetime 8 1 --------NULL
GcN6kA http://www.numino.net
QX char 1 1 --------B
xOlQE4 http://www.numino.net
JF int 4 0 --------0
vbhrJH http://www.numino.net
huiy int 4 1 --------0
1GdtJ4 http://www.numino.net
hysj smalldatetime 4 1 --------NULL
KW2sp7 http://www.numino.net
lqsj smalldatetime 4 1 --------NULL
T6oCH5 http://www.numino.net
FDB int 4 1 --------0
0ukB1P http://www.numino.net
vip tinyint 1 1 --------0
D8A456 http://www.numino.net
Expired datetime 8 1 --------2005-6-6 23:00:05
9fs5vx http://www.numino.net
4、MEMB_STAT
3nEIe4 http://www.numino.net
列名 类型 长 是否空 说明
3b9z8x http://www.numino.net
memb___id nvarchar 10 0 --------帐号
AfPzNx http://www.numino.net
ConnectStat tinyint 1 1 --------是否在线 0：不在线
6eE854 http://www.numino.net
ServerName nvarchar 20 1 --------连接的线名
ReEAGO http://www.numino.net
IP nvarchar 15 1 --------IP地址
u8PAYi http://www.numino.net
ConnectTM smalldatetime 4 1 --------上线日期、时间
B7E0CR http://www.numino.net
DisConnectTM smalldatetime 4 1 --------下线日期、时间
HryUBF http://www.numino.net
5、warehouse
8e8t9a http://www.numino.net
列名 类型 长 是否空 说明
8zUtV5 http://www.numino.net
AccountID varchar 10 0 --------帐号
grL003 http://www.numino.net
Items varbinary 1200 1 --------仓库物品
t5ljba http://www.numino.net
Money int 4 1 --------钱
Q33x1I http://www.numino.net
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
ABa3Mu http://www.numino.net
DbVersion tinyint 1 1 --------1
abQiEO http://www.numino.net
pw smallint 2 1 --------密码 0
Yn2cNx http://www.numino.net
lastpw smallint 2 0 --------最后密码 0
Zk13Q1 http://www.numino.net
ExtCKNum int 4 0 --------0
rAIa4r http://www.numino.net
NeedExtCK int 4 0 --------0
5x5G5i http://www.numino.net
6、VI_CURR_INFO
0igwxu http://www.numino.net
列名 类型 长 是否空 说明
XhhXns http://www.numino.net
ends_days nvarchar 8 1 --------20081111
0KX3kK http://www.numino.net
chek_code nvarchar 1 0 --------1
aP8Awy http://www.numino.net
used_time int 4 1 --------1234
XuOJ76 http://www.numino.net
memb___id nvarchar 10 0 --------帐号
u2Pwb0 http://www.numino.net
memb_name nvarchar 10 0 --------昵称
qF53C6 http://www.numino.net
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
pI0WZw http://www.numino.net
sno__numb nvarchar 18 0 --------123456
eXeFZX http://www.numino.net
Bill_Section int 4 1 --------6
VuupS4 http://www.numino.net
Bill_Value int 4 1 --------3
HXsncy http://www.numino.net
Bill_Hour int 4 1 --------0
CaY02m http://www.numino.net
Surplus_Point int 4 1 --------0
gAv0f9 http://www.numino.net
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
RPt9Q6 http://www.numino.net
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
Xxd7uF http://www.numino.net
7、WEB_ZS
MwmFbG http://www.numino.net
列名 类型 长 是否空 说明
E0mvdy http://www.numino.net
ID bigint 8 0
CCg8Qu http://www.numino.net
ACC char 10 1
mut3w8 http://www.numino.net
NAME char 10 1
fniA0z http://www.numino.net
ZSTIME datetime 8 1
nTwfRq http://www.numino.net
ZSCLEVEL smallint 2 1
LPrur9 http://www.numino.net
ZSCS smallint 2 0
6Asj4h http://www.numino.net
CZCS smallint 2 0
F0GZZq http://www.numino.net
CZTIME datetime 8 0
WsV9yw http://www.numino.net
ZJZSCS smallint 2 0
cb0Js3 http://www.numino.net
GJZSCS smallint 2 0
04oH49 http://www.numino.net
CJZSCS smallint 2 0
Y4EeK5 http://www.numino.net
BSCS smallint 2 0
Bfo63I http://www.numino.net
BSTIME datetime 8 0
Q3X57D http://www.numino.net
LEVELUPPOINT int 4 0
N78fjL http://www.numino.net
GDDS int 4 0
|
|