| 奇迹muonline数据库基础库分析 |
一、表的组成：
4gErjv http://blog.numino.net/
1、AccountCharacter
GD0rQ7 http://blog.numino.net/
用来存放帐号的角色。
ku4xzz http://blog.numino.net/
2、Character
fxRAfB http://blog.numino.net/
用来存放每个角色的详细数据。
zp0F09 http://blog.numino.net/
3、MEMB_INFO
wuA4u5 http://blog.numino.net/
帐号信息
vO29sq http://blog.numino.net/
4、MEMB_STAT
3csoin http://blog.numino.net/
帐号状态
G12coF http://blog.numino.net/
5、warehouse
P7s85n http://blog.numino.net/
仓库
gy5Biw http://blog.numino.net/
6、VI_CURR_INFO
c2ZO2P http://blog.numino.net/
帐号费用
WYeW2R http://blog.numino.net/
7、WEB_ZS
42iFZR http://blog.numino.net/
PL 网站的转生数据
L6cU6t http://blog.numino.net/
二、各表说明
uT6xu6 http://blog.numino.net/
1、AccountCharacter 表
4RN8TY http://blog.numino.net/
列名 类型 长 是否空 说明
z36hE2 http://blog.numino.net/
Number int 4 0 自动增加的序数
ZyV95l http://blog.numino.net/
Id varchar 10 0 帐号
YML658 http://blog.numino.net/
GameID1 varchar 10 1 角色1
Ie9e72 http://blog.numino.net/
GameID2 varchar 10 1 角色2
9guhJl http://blog.numino.net/
GameID3 varchar 10 1
3P9obd http://blog.numino.net/
GameID4 varchar 10 1
2Fl17J http://blog.numino.net/
GameID5 varchar 10 1
j2uP7e http://blog.numino.net/
GameIDC varchar 10 1
SQ9Evc http://blog.numino.net/
2、Character 表
bxR5h6 http://blog.numino.net/
列名 类型 长 是否空 说明
WVNteI http://blog.numino.net/
AccountID varchar 10 0 --------帐号
72Gbwf http://blog.numino.net/
Name nvarchar 10 0 --------角色名
x1AK7l http://blog.numino.net/
cLevel smallint 2 1 --------等级
na886F http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
9Txt68 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
nSKLxw http://blog.numino.net/
Experience int 4 1 --------经验
TltIzS http://blog.numino.net/
Strength smallint 2 1 --------力量
9AxK00 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
86iFPn http://blog.numino.net/
Vitality smallint 2 1 --------体力
MWHPUA http://blog.numino.net/
Energy smallint 2 1 --------智力
078044 http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
w78JH1 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
OAYrnm http://blog.numino.net/
Money int 4 1 --------钱
1wK5Ua http://blog.numino.net/
Life real 4 1 --------
5u4xvP http://blog.numino.net/
MaxLife real 4 1 --------
rc5EQz http://blog.numino.net/
Mana real 4 1 --------
79Pbhs http://blog.numino.net/
MaxMana real 4 1 --------
3p97J0 http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
1ZQuOy http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
5se78U http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
KSqbjd http://blog.numino.net/
MapDir tinyint 1 1 --------
rwU2VC http://blog.numino.net/
PkCount int 4 1 --------
u8YsDe http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
6QaIv3 http://blog.numino.net/
PkTime int 4 1
TZ99ae http://blog.numino.net/
MDate smalldatetime 4 1
MpgC8Z http://blog.numino.net/
LDate smalldatetime 4 1
70eaf0 http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
Crifs6 http://blog.numino.net/
DbVersion tinyint 1 1
I1Gmr4 http://blog.numino.net/
Quest varbinary 50 1
RYQBWz http://blog.numino.net/
LINZB bit 1 0
iv3Zc7 http://blog.numino.net/
XDTIME datetime 8 0
1OJz4s http://blog.numino.net/
STOPINFO nvarchar 100 1
dbl7EO http://blog.numino.net/
STOPTIME datetime 8 0
qK50bs http://blog.numino.net/
zs_count int 4 1
I4R4PU http://blog.numino.net/
zs_point int 4 1
BWHjNn http://blog.numino.net/
bs_count int 4 1
7qXJvy http://blog.numino.net/
bs_point int 4 1
PT68Q9 http://blog.numino.net/
shiji smalldatetime 4 1
91Tq77 http://blog.numino.net/
banl nvarchar 10 1
Um6Snk http://blog.numino.net/
lv_time datetime 8 1
5Y2MNz http://blog.numino.net/
ex_ok int 4 1
QhJCG6 http://blog.numino.net/
ex_total int 4 1
AO0oI6 http://blog.numino.net/
rb_count int 4 1
5ZkPuk http://blog.numino.net/
rb_time datetime 8 1
bFy49b http://blog.numino.net/
pz_time datetime 8 1
2kchwi http://blog.numino.net/
3、MEMB_INFO
rdngkX http://blog.numino.net/
列名 类型 长 是否空 说明
5QWV7Y http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
k6l4Rb http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
w2PyD0 http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
PjKWbg http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
G9n39N http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
1TIbne http://blog.numino.net/
post_code nvarchar 6 1 --------1234
9Vl3bu http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
zKyAzq http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
0zWlz0 http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
oe1AFa http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
O7itV9 http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
N7rbzi http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
z701BJ http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
6LjpYI http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
6SB1x4 http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
eNAk8A http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
QR0dsL http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
S6NdYX http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
62JSEl http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
w9JaBe http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
qwKD73 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
vIzgR1 http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
1pOLZP http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
8khG27 http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
9Hv1xa http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
9269dz http://blog.numino.net/
QX char 1 1 --------B
G26A9w http://blog.numino.net/
JF int 4 0 --------0
1FkQCX http://blog.numino.net/
huiy int 4 1 --------0
9FN4I1 http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
8O3E0l http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
m8W0pL http://blog.numino.net/
FDB int 4 1 --------0
cx628l http://blog.numino.net/
vip tinyint 1 1 --------0
i2C6gq http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
6JHno3 http://blog.numino.net/
4、MEMB_STAT
x21QAt http://blog.numino.net/
列名 类型 长 是否空 说明
ho08LR http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
M1q3WH http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
mT555A http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
jkA1kn http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
EmfL7c http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
0z4YC8 http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
23uDZv http://blog.numino.net/
5、warehouse
54HX6c http://blog.numino.net/
列名 类型 长 是否空 说明
vtKPk0 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
fkZ2RH http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
9J471r http://blog.numino.net/
Money int 4 1 --------钱
2mEo4k http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
OBw365 http://blog.numino.net/
DbVersion tinyint 1 1 --------1
0Z8LBI http://blog.numino.net/
pw smallint 2 1 --------密码 0
uQgQgE http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
mBN9e9 http://blog.numino.net/
ExtCKNum int 4 0 --------0
GeNG76 http://blog.numino.net/
NeedExtCK int 4 0 --------0
USgQ8l http://blog.numino.net/
6、VI_CURR_INFO
AUw8vm http://blog.numino.net/
列名 类型 长 是否空 说明
4cg19o http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
YeXey0 http://blog.numino.net/
chek_code nvarchar 1 0 --------1
4J2asl http://blog.numino.net/
used_time int 4 1 --------1234
h8SJkg http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
AhG3v8 http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
Xi3bs0 http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
LTxJMK http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
12A44v http://blog.numino.net/
Bill_Section int 4 1 --------6
BEQ4PD http://blog.numino.net/
Bill_Value int 4 1 --------3
p5IhLN http://blog.numino.net/
Bill_Hour int 4 1 --------0
M16dfB http://blog.numino.net/
Surplus_Point int 4 1 --------0
vyhiRR http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
Mj8OwA http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
JED6M3 http://blog.numino.net/
7、WEB_ZS
mDCCdt http://blog.numino.net/
列名 类型 长 是否空 说明
Avr8aV http://blog.numino.net/
ID bigint 8 0
jJ5ceM http://blog.numino.net/
ACC char 10 1
sQa4GL http://blog.numino.net/
NAME char 10 1
NgUrnb http://blog.numino.net/
ZSTIME datetime 8 1
5BbY5u http://blog.numino.net/
ZSCLEVEL smallint 2 1
x31vGK http://blog.numino.net/
ZSCS smallint 2 0
N62zpx http://blog.numino.net/
CZCS smallint 2 0
2h09xS http://blog.numino.net/
CZTIME datetime 8 0
xKo0d0 http://blog.numino.net/
ZJZSCS smallint 2 0
3Hb77r http://blog.numino.net/
GJZSCS smallint 2 0
u7Dv6I http://blog.numino.net/
CJZSCS smallint 2 0
HDzv9w http://blog.numino.net/
BSCS smallint 2 0
p7iRb2 http://blog.numino.net/
BSTIME datetime 8 0
42WKhB http://blog.numino.net/
LEVELUPPOINT int 4 0
i31YR8 http://blog.numino.net/
GDDS int 4 0
|
|