| 奇迹muonline数据库基础库分析 |
一、表的组成：
WvqzB5 http://blog.numino.net/
1、AccountCharacter
T7rxeG http://blog.numino.net/
用来存放帐号的角色。
SQRK6z http://blog.numino.net/
2、Character
H820Wq http://blog.numino.net/
用来存放每个角色的详细数据。
kiNK2t http://blog.numino.net/
3、MEMB_INFO
Ogh8BM http://blog.numino.net/
帐号信息
r2g42w http://blog.numino.net/
4、MEMB_STAT
s2Dzh6 http://blog.numino.net/
帐号状态
6KO7OE http://blog.numino.net/
5、warehouse
G11F6C http://blog.numino.net/
仓库
WbadyA http://blog.numino.net/
6、VI_CURR_INFO
h1z0Dd http://blog.numino.net/
帐号费用
r3C7I0 http://blog.numino.net/
7、WEB_ZS
JALVfD http://blog.numino.net/
PL 网站的转生数据
3X7ZaY http://blog.numino.net/
二、各表说明
KYY0N6 http://blog.numino.net/
1、AccountCharacter 表
0Jb38v http://blog.numino.net/
列名 类型 长 是否空 说明
4z54PJ http://blog.numino.net/
Number int 4 0 自动增加的序数
t2Ql8V http://blog.numino.net/
Id varchar 10 0 帐号
R9jFAa http://blog.numino.net/
GameID1 varchar 10 1 角色1
El3THJ http://blog.numino.net/
GameID2 varchar 10 1 角色2
YIy2lh http://blog.numino.net/
GameID3 varchar 10 1
9N9rlo http://blog.numino.net/
GameID4 varchar 10 1
q3ynPb http://blog.numino.net/
GameID5 varchar 10 1
cXc2Sr http://blog.numino.net/
GameIDC varchar 10 1
RuzYJU http://blog.numino.net/
2、Character 表
77ig7V http://blog.numino.net/
列名 类型 长 是否空 说明
296P60 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
6c0G18 http://blog.numino.net/
Name nvarchar 10 0 --------角色名
Jn8uil http://blog.numino.net/
cLevel smallint 2 1 --------等级
yEIGhU http://blog.numino.net/
LevelUpPoint int 4 1 --------升级点
nBhRJ1 http://blog.numino.net/
Class tinyint 1 1 --------职业 0法 1魔导 32精 33圣 16战 17骑 48魔 64圣导
iFH6q0 http://blog.numino.net/
Experience int 4 1 --------经验
27WF0D http://blog.numino.net/
Strength smallint 2 1 --------力量
URhR79 http://blog.numino.net/
Dexterity smallint 2 1 --------敏捷
dN0F6m http://blog.numino.net/
Vitality smallint 2 1 --------体力
tC78wG http://blog.numino.net/
Energy smallint 2 1 --------智力
b5evNw http://blog.numino.net/
Inventory varbinary 760 1 --------身上仓库
LOuP89 http://blog.numino.net/
MagicList varbinary 60 1 --------技能
RjWdBP http://blog.numino.net/
Money int 4 1 --------钱
Mo2rQ9 http://blog.numino.net/
Life real 4 1 --------
2H3kzj http://blog.numino.net/
MaxLife real 4 1 --------
J0jWEA http://blog.numino.net/
Mana real 4 1 --------
m1A9aT http://blog.numino.net/
MaxMana real 4 1 --------
05y72o http://blog.numino.net/
MapNumber smallint 2 1 --------所在地图号
j0JYW9 http://blog.numino.net/
MapPosX smallint 2 1 --------X坐标
7QVxdH http://blog.numino.net/
MapPosY smallint 2 1 --------Y坐标
458A3d http://blog.numino.net/
MapDir tinyint 1 1 --------
UhVDB8 http://blog.numino.net/
PkCount int 4 1 --------
VRv1bn http://blog.numino.net/
PkLevel int 4 1 --------PK状态：0大侠 1英雄 2好人 3普 4无赖 5魔头
2pMPXg http://blog.numino.net/
PkTime int 4 1
aRDPUK http://blog.numino.net/
MDate smalldatetime 4 1
V1Q3F3 http://blog.numino.net/
LDate smalldatetime 4 1
rhEARC http://blog.numino.net/
CtlCode tinyint 1 1 --------0 普通角色 8GM
tS1MuU http://blog.numino.net/
DbVersion tinyint 1 1
C5vK7E http://blog.numino.net/
Quest varbinary 50 1
hf2Gb0 http://blog.numino.net/
LINZB bit 1 0
0uajTv http://blog.numino.net/
XDTIME datetime 8 0
0RNGgV http://blog.numino.net/
STOPINFO nvarchar 100 1
LjD5mG http://blog.numino.net/
STOPTIME datetime 8 0
V50OhW http://blog.numino.net/
zs_count int 4 1
FQ5NaN http://blog.numino.net/
zs_point int 4 1
BrahA1 http://blog.numino.net/
bs_count int 4 1
C7e83n http://blog.numino.net/
bs_point int 4 1
O7tK52 http://blog.numino.net/
shiji smalldatetime 4 1
CTrY5g http://blog.numino.net/
banl nvarchar 10 1
t0js1Z http://blog.numino.net/
lv_time datetime 8 1
F8EBv4 http://blog.numino.net/
ex_ok int 4 1
Y6YUUi http://blog.numino.net/
ex_total int 4 1
95Cp2z http://blog.numino.net/
rb_count int 4 1
W8L4W9 http://blog.numino.net/
rb_time datetime 8 1
U77TTE http://blog.numino.net/
pz_time datetime 8 1
6Y3Rtu http://blog.numino.net/
3、MEMB_INFO
B9zJbw http://blog.numino.net/
列名 类型 长 是否空 说明
ep74f1 http://blog.numino.net/
memb_guid int 4 0 -------- 1(系统自动生成)
w5GknC http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
L1aK0e http://blog.numino.net/
memb__pwd nvarchar 10 0 --------密码
92JRRe http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称 (1)
BulENk http://blog.numino.net/
sno__numb nvarchar 18 0 --------1
56U3bC http://blog.numino.net/
post_code nvarchar 6 1 --------1234
gQKRDd http://blog.numino.net/
addr_info nvarchar 50 1 --------XXXXXXXXXXX
XXxsV6 http://blog.numino.net/
addr_deta nvarchar 50 1 --------XXXXXXXXXXX
qQI9RL http://blog.numino.net/
tel__numb nvarchar 20 1 --------XXXXXXXXXXX
Ii6eDJ http://blog.numino.net/
phon_numb nvarchar 15 1 --------XXXXXXXXXXX
LzrD4A http://blog.numino.net/
mail_addr nvarchar 50 1 --------邮件地址
YGE6El http://blog.numino.net/
fpas_ques nvarchar 50 1 --------密码提示问题
V0H3vP http://blog.numino.net/
fpas_answ nvarchar 50 1 --------答案
f8aA1v http://blog.numino.net/
job__code nvarchar 2 1 --------XXXXXXXXXXXX
K5FMyS http://blog.numino.net/
appl_days smalldatetime 4 1 --------2005-6-6 23:00:00
9ZG2h1 http://blog.numino.net/
modi_days smalldatetime 4 1 --------2005-6-6 23:00:00
OC6ziP http://blog.numino.net/
out__days smalldatetime 4 1 --------2005-6-6 23:00:00
jKPes3 http://blog.numino.net/
true_days smalldatetime 4 1 --------2005-6-6 23:00:00
VOMZH5 http://blog.numino.net/
mail_chek nvarchar 1 1 -------- 0 或 1
QgjjAb http://blog.numino.net/
bloc_code nvarchar 1 0 --------0 正常 >0封号
Fv6AT8 http://blog.numino.net/
ctl1_code nvarchar 1 0 --------0
QrW8bV http://blog.numino.net/
LINZBSJ datetime 8 1 --------NULL
Fd550k http://blog.numino.net/
LGONGZHISJ datetime 8 1 --------NULL
4Pt17i http://blog.numino.net/
STOPINFO nvarchar 100 1 --------NULL
b5gHO8 http://blog.numino.net/
STOPTIME datetime 8 1 --------NULL
0eTzUh http://blog.numino.net/
QX char 1 1 --------B
Se7Hyj http://blog.numino.net/
JF int 4 0 --------0
XH5A7t http://blog.numino.net/
huiy int 4 1 --------0
FWIeSD http://blog.numino.net/
hysj smalldatetime 4 1 --------NULL
gs8z9K http://blog.numino.net/
lqsj smalldatetime 4 1 --------NULL
m31oA3 http://blog.numino.net/
FDB int 4 1 --------0
p1PraI http://blog.numino.net/
vip tinyint 1 1 --------0
8h6B1w http://blog.numino.net/
Expired datetime 8 1 --------2005-6-6 23:00:05
WGm3MN http://blog.numino.net/
4、MEMB_STAT
t65zNi http://blog.numino.net/
列名 类型 长 是否空 说明
bP7B77 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
351Bfz http://blog.numino.net/
ConnectStat tinyint 1 1 --------是否在线 0：不在线
dsmxmv http://blog.numino.net/
ServerName nvarchar 20 1 --------连接的线名
AVxAgD http://blog.numino.net/
IP nvarchar 15 1 --------IP地址
Gs1MmN http://blog.numino.net/
ConnectTM smalldatetime 4 1 --------上线日期、时间
k79z2k http://blog.numino.net/
DisConnectTM smalldatetime 4 1 --------下线日期、时间
eq5439 http://blog.numino.net/
5、warehouse
7Xu9j1 http://blog.numino.net/
列名 类型 长 是否空 说明
8Qk9d5 http://blog.numino.net/
AccountID varchar 10 0 --------帐号
E3aWTY http://blog.numino.net/
Items varbinary 1200 1 --------仓库物品
08l4gb http://blog.numino.net/
Money int 4 1 --------钱
d0oo0e http://blog.numino.net/
EndUseDate smalldatetime 4 1 --------最后使用日期、时间
7zKKna http://blog.numino.net/
DbVersion tinyint 1 1 --------1
5a9SVK http://blog.numino.net/
pw smallint 2 1 --------密码 0
J2fucS http://blog.numino.net/
lastpw smallint 2 0 --------最后密码 0
nH8Ndx http://blog.numino.net/
ExtCKNum int 4 0 --------0
rekmaI http://blog.numino.net/
NeedExtCK int 4 0 --------0
oYhB0z http://blog.numino.net/
6、VI_CURR_INFO
X1OScR http://blog.numino.net/
列名 类型 长 是否空 说明
hZ1Uaf http://blog.numino.net/
ends_days nvarchar 8 1 --------20081111
GxQPxz http://blog.numino.net/
chek_code nvarchar 1 0 --------1
HGpUN2 http://blog.numino.net/
used_time int 4 1 --------1234
qcRLg7 http://blog.numino.net/
memb___id nvarchar 10 0 --------帐号
yhkIJK http://blog.numino.net/
memb_name nvarchar 10 0 --------昵称
dH5PTo http://blog.numino.net/
memb_guid int 4 0 --------GUID 与 MEMB_INFO 里的对应
VcgKJ3 http://blog.numino.net/
sno__numb nvarchar 18 0 --------123456
lsgPkv http://blog.numino.net/
Bill_Section int 4 1 --------6
3w9MlB http://blog.numino.net/
Bill_Value int 4 1 --------3
jfBX4h http://blog.numino.net/
Bill_Hour int 4 1 --------0
MfXTt3 http://blog.numino.net/
Surplus_Point int 4 1 --------0
SsRao8 http://blog.numino.net/
Surplus_Minute datetime 8 1 --------2005-6-6 23:00:05
zgtC2U http://blog.numino.net/
Increase_Days datetime 8 1 --------2005-6-6 23:00:05
CDo01N http://blog.numino.net/
7、WEB_ZS
Xb0mFE http://blog.numino.net/
列名 类型 长 是否空 说明
Aqy4V3 http://blog.numino.net/
ID bigint 8 0
pfJbyN http://blog.numino.net/
ACC char 10 1
bljX13 http://blog.numino.net/
NAME char 10 1
VV2BY4 http://blog.numino.net/
ZSTIME datetime 8 1
5Xnrn3 http://blog.numino.net/
ZSCLEVEL smallint 2 1
d4WhDm http://blog.numino.net/
ZSCS smallint 2 0
N1MzEr http://blog.numino.net/
CZCS smallint 2 0
kT0r92 http://blog.numino.net/
CZTIME datetime 8 0
fo7hnI http://blog.numino.net/
ZJZSCS smallint 2 0
CdEBfe http://blog.numino.net/
GJZSCS smallint 2 0
eUMSwR http://blog.numino.net/
CJZSCS smallint 2 0
c41R08 http://blog.numino.net/
BSCS smallint 2 0
vn8FqO http://blog.numino.net/
BSTIME datetime 8 0
d8BWgl http://blog.numino.net/
LEVELUPPOINT int 4 0
0S92eF http://blog.numino.net/
GDDS int 4 0
|
|