织梦dede5.7数据表及其注释

朱雀 2022-12-29 06:52 148阅读 0赞

Dedecms5.7数据结构说明文档

1、dede\_addonarticle：附加文章表

表名：dede\_addonarticle(ENGINE=MyISAM/CHARSET=utf8)|说明：附加文章表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>文章ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>body</td> 
   <td>内容</td> 
   <td>mediumtext</td> 
  </tr> 
  <tr> 
   <td>redirecturl</td> 
   <td>跳转URL</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>templet</td> 
   <td>自定义模板</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>userip</td> 
   <td>用户IP</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `typeid` (`typeid`)

2、dede\_addonimages： 附加图集表  
表名：dede\_addonimages  
(ENGINE=MyISAM/CHARSET=utf8)|说明：附加图集表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>图集ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>pagestyle</td> 
   <td>显示列表样式</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>maxwidth</td> 
   <td>最大宽度</td> 
   <td>smallint(6) NOT NULL default ‘600’</td> 
  </tr> 
  <tr> 
   <td>imgurls</td> 
   <td>图片地址</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>row</td> 
   <td>行数</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>col</td> 
   <td>列数</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isrm</td> 
   <td>特殊选项（下载远程图片、从ZIP压缩包中解压图片、网上复制图片)</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>ddmaxwidth</td> 
   <td>缩略图最大宽度</td> 
   <td>smallint(6) NOT NULL default ‘200’</td> 
  </tr> 
  <tr> 
   <td>pagepicnum</td> 
   <td>每页显示图片数量</td> 
   <td>smallint(6) NOT NULL default ‘12’</td> 
  </tr> 
  <tr> 
   <td>templet</td> 
   <td>自定义模板</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>userip</td> 
   <td>用户IP</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>redirecturl</td> 
   <td>跳转地址</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>body</td> 
   <td>图集详细说明</td> 
   <td>mediumtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `imagesMain` (`typeid`)  
3、dede\_addoninfos： 附加分类表  
表名：dede\_addoninfos  
(ENGINE=MyISAM/CHARSET=gbk)|说明：附加分类表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>内容ID</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>channel</td> 
   <td>频道类型</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>arcrank</td> 
   <td>内容排序</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>click</td> 
   <td>点击次数</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>标题</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>litpic</td> 
   <td>缩略图</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>userip</td> 
   <td>用户IP</td> 
   <td>varchar(15) NOT NULL default ’ ’</td> 
  </tr> 
  <tr> 
   <td>senddate</td> 
   <td>发布时间</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>flag</td> 
   <td>属性</td> 
   <td>set(‘c’,‘h’,‘p’,‘f’,‘s’,‘j’,‘a’,‘b’) default NULL</td> 
  </tr> 
  <tr> 
   <td>lastpost</td> 
   <td>最后回复</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>scores</td> 
   <td>分数</td> 
   <td>mediumint(8) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>goodpost</td> 
   <td>好评</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>badpost</td> 
   <td>差评</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>nativeplace</td> 
   <td>联动,地址</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>infotype</td> 
   <td>信息类型</td> 
   <td>char(20) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>body</td> 
   <td>内容</td> 
   <td>mediumtext</td> 
  </tr> 
  <tr> 
   <td>endtime</td> 
   <td>结束时间</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tel</td> 
   <td>电话号码</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>email</td> 
   <td>电子邮箱</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>address</td> 
   <td>地址</td> 
   <td>varchar(100) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>linkman</td> 
   <td>联系人</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `typeid` (`typeid`,`nativeplace`,`infotype`),  
KEY `channel` (`channel`,`arcrank`,`mid`,`click`,`title`,`litpic`,`senddate`,`flag`,`endtime`)

4、dede\_addonshop： 附加商品表  
表名：dede\_addonshop  
(ENGINE=MyISAM/CHARSET=gbk)|说明：附加商品表

索引：  
PRIMARY KEY (`aid`),  
KEY `typeid` (`typeid`)

5、dede\_addonsoft ： 附加软件表  
表名：dede\_addonsoft  
(ENGINE=MyISAM/CHARSET=gbk)|说明：附加软件表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>内容ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>filetype</td> 
   <td>文件类型</td> 
   <td>varchar(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>language</td> 
   <td>语言</td> 
   <td>varchar(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>softtype</td> 
   <td>软件类别</td> 
   <td>varchar(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>accredit</td> 
   <td>授权方式</td> 
   <td>varchar(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>os</td> 
   <td>操作系统</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>softrank</td> 
   <td>文章排序</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>officialUrl</td> 
   <td>官方网址</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>officialDemo</td> 
   <td>演示网址</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>softsize</td> 
   <td>软件大小</td> 
   <td>varchar(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>softlinks</td> 
   <td>软件地址</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>introduce</td> 
   <td>详细介绍</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>daccess</td> 
   <td>下载级别</td> 
   <td>smallint(5) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>needmoney</td> 
   <td>需要金币</td> 
   <td>smallint(5) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>templet</td> 
   <td>自定义模板</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>userip</td> 
   <td>用户IP</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>redirecturl</td> 
   <td>跳转地址</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `softMain` (`typeid`)

6、dede\_addonspec： 附加专题表  
表名：dede\_addonspec  
(ENGINE=MyISAM/CHARSET=gbk)|说明：附加专题表

索引：  
PRIMARY KEY (`aid`),  
KEY `typeid` (`typeid`)

7、dede\_admin： 管理员信息表  
表名：dede\_admin  
(ENGINE=MyISAM/CHARSET=gbk)|说明：管理员信息表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>管理ID</td> 
   <td>int(10) unsigned NOT NULL</td> 
  </tr> 
  <tr> 
   <td>usertype</td> 
   <td>管理员类别</td> 
   <td>float unsigned default ‘0’</td> 
  </tr> 
  <tr> 
   <td>userid</td> 
   <td>管理员ID</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>pwd</td> 
   <td>密码</td> 
   <td>char(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uname</td> 
   <td>用户名</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>tname</td> 
   <td>真实姓名</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>email</td> 
   <td>电子邮箱</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>授权管理栏目ID</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>logintime</td> 
   <td>登陆时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>loginip</td> 
   <td>登陆IP</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

8、dede\_admintype：系统用户组管理表  
表名：dede\_admintype  
(ENGINE=MyISAM/CHARSET=gbk)|说明：系统用户组管理表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>rank</td> 
   <td>权限值</td> 
   <td>float NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>typename</td> 
   <td>管理组名称</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>system</td> 
   <td>是否为系统管理员</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>purviews</td> 
   <td>权限</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`rank`)

9、dede\_advancedsearch：高级搜索表  
表名：dede\_advancedsearch  
(ENGINE=MyISAM/CHARSET=gbk)|说明：高级搜索表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mid</td> 
   <td>id</td> 
   <td>int(11) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>maintable</td> 
   <td>主表</td> 
   <td>varchar(256) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>mainfields</td> 
   <td>主表字段</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>addontable</td> 
   <td>附加表</td> 
   <td>varchar(256) default NULL</td> 
  </tr> 
  <tr> 
   <td>addonfields</td> 
   <td>附加表字段</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>forms</td> 
   <td>表单</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>template</td> 
   <td>自定义模板</td> 
   <td>varchar(256) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
UNIQUE KEY `mid` (`mid`)

10、dede\_arcatt：文档自定义属性表  
表名：dede\_arcatt  
(ENGINE=MyISAM/CHARSET=gbk)|说明：文档自定义属性表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>sortid</td> 
   <td>排序ID</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>att</td> 
   <td>属性标志</td> 
   <td>char(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>attname</td> 
   <td>属性名称</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`att`)

11、dede\_arccache：文档缓存表  
表名：dede\_arccache  
(ENGINE=MyISAM/CHARSET=gbk)|说明：文档缓存表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>md5hash</td> 
   <td>缓存hash码</td> 
   <td>char(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>更新时间</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>cachedata</td> 
   <td>缓存数据</td> 
   <td>mediumtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`md5hash`)

12、dede\_archives：文档主表  
表名：dede\_archives  
(ENGINE=MyISAM/CHARSET=gbk)|说明：文档主表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>内容ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid2</td> 
   <td>副栏目ID</td> 
   <td>varchar(90) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>sortrank</td> 
   <td>文档排序</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>flag</td> 
   <td>属性</td> 
   <td>set(‘c’,‘h’,‘p’,‘f’,‘s’,‘j’,‘a’,‘b’) default NULL</td> 
  </tr> 
  <tr> 
   <td>ismake</td> 
   <td>是否生成HTML</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>channel</td> 
   <td>频道模型</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>arcrank</td> 
   <td>浏览权限</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>click</td> 
   <td>点击次数</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>需要消耗金币</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>文档标题</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>shorttitle</td> 
   <td>短标题</td> 
   <td>char(36) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>color</td> 
   <td>标题颜色</td> 
   <td>char(7) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>writer</td> 
   <td>作者</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>source</td> 
   <td>来源</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>litpic</td> 
   <td>缩略图</td> 
   <td>char(100) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>pubdate</td> 
   <td>发布日期</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>senddate</td> 
   <td>投稿日期</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>keywords</td> 
   <td>文档关键词</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>lastpost</td> 
   <td>最后回复</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>scores</td> 
   <td>消耗积分</td> 
   <td>mediumint(8) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>goodpost</td> 
   <td>好评</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>badpost</td> 
   <td>差评</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>notpost</td> 
   <td>不允许回复</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>deｓｃｒｉｐｔion</td> 
   <td>描述</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>filename</td> 
   <td>自定义文件名</td> 
   <td>varchar(40) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>dutyadmin</td> 
   <td>负责审核管理员的ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tackid</td> 
   <td></td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mtype</td> 
   <td>自定义类别</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>weight</td> 
   <td>权重</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `sortrank` (`sortrank`),  
KEY `mainindex` (`arcrank`,`typeid`,`channel`,`flag`,`mid`),  
KEY `lastpost` (`lastpost`,`scores`,`goodpost`,`badpost`,`notpost`)

13、dede\_arcmulti：多页标记存储数据表  
表名：dede\_arcmulti  
(ENGINE=MyISAM/CHARSET=gbk)|说明：多页标记存储数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>id</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>tagid</td> 
   <td>标签ID</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>更新日期</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>innertext</td> 
   <td>底层模板</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>pagesize</td> 
   <td>分页列表</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>arcids</td> 
   <td>文档id</td> 
   <td>text NOT NULL</td> 
  </tr> 
  <tr> 
   <td>ordersql</td> 
   <td>排序SQL</td> 
   <td>varchar(255) default NULL</td> 
  </tr> 
  <tr> 
   <td>addfieldsSql</td> 
   <td>附加字段SQL</td> 
   <td>varchar(255) default NULL</td> 
  </tr> 
  <tr> 
   <td>addfieldsSqlJoin</td> 
   <td>附加字段SQLjoin</td> 
   <td>varchar(255) default NULL</td> 
  </tr> 
  <tr> 
   <td>attstr</td> 
   <td>属性字符串</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

14、dede\_arcrank：文档阅读权限表  
表名：dede\_arcrank  
(ENGINE=MyISAM/CHARSET=gbk)|说明：文档阅读权限表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>权限ID</td> 
   <td>smallint(5) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>rank</td> 
   <td>权限值</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>membername</td> 
   <td>会员名称</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>adminrank</td> 
   <td>管理员权限</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>需要金币</td> 
   <td>smallint(8) unsigned NOT NULL default ‘500’</td> 
  </tr> 
  <tr> 
   <td>scores</td> 
   <td>需要积分</td> 
   <td>mediumint(8) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>purviews</td> 
   <td>权限</td> 
   <td>mediumtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

15、dede\_arctiny：文档微表  
表名：dede\_arctiny  
(ENGINE=MyISAM/CHARSET=gbk)|说明：文档微表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>主栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid2</td> 
   <td>副栏目ID</td> 
   <td>varchar(90) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>arcrank</td> 
   <td>文档权限</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>channel</td> 
   <td>频道类型</td> 
   <td>smallint(5) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>senddate</td> 
   <td>投稿日期</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>sortrank</td> 
   <td>文档排序</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `sortrank` (`sortrank`)

16、dede\_arctype：栏目管理表  
表名：dede\_arctype  
(ENGINE=MyISAM/CHARSET=gbk)|说明：栏目管理表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>reid</td> 
   <td>上级栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>topid</td> 
   <td>顶级栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>sortrank</td> 
   <td>排序</td> 
   <td>smallint(5) unsigned NOT NULL default ‘50’</td> 
  </tr> 
  <tr> 
   <td>typename</td> 
   <td>栏目名称</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>typedir</td> 
   <td>栏目目录</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>isdefault</td> 
   <td>是否默认</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>defaultname</td> 
   <td>默认名称</td> 
   <td>char(15) NOT NULL default ‘index.html’</td> 
  </tr> 
  <tr> 
   <td>issend</td> 
   <td>是否支持投稿</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>channeltype</td> 
   <td>栏目频道类型</td> 
   <td>smallint(6) default ‘1’</td> 
  </tr> 
  <tr> 
   <td>maxpage</td> 
   <td>最大页面数</td> 
   <td>smallint(6) NOT NULL default ‘-1’</td> 
  </tr> 
  <tr> 
   <td>ispart</td> 
   <td>栏目属性</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>corank</td> 
   <td>浏览权限</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tempindex</td> 
   <td>频道页模板</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>templist</td> 
   <td>列表页模板</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>temparticle</td> 
   <td>内容页模板</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>namerule</td> 
   <td>文章命名规则</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>namerule2</td> 
   <td>列表命名规则</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>modname</td> 
   <td>模型名称</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>deｓｃｒｉｐｔion</td> 
   <td>栏目描述</td> 
   <td>char(150) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>keywords</td> 
   <td>栏目关键词</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>seotitle</td> 
   <td>SEO标题</td> 
   <td>varchar(80) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>moresite</td> 
   <td>多站点支持</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>sitepath</td> 
   <td>站点根目录</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>siteurl</td> 
   <td>绑定域名</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>ishidden</td> 
   <td>是否隐藏</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>cross</td> 
   <td>交叉栏目</td> 
   <td>tinyint(1) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>crossid</td> 
   <td>交叉ID</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>content</td> 
   <td>栏目内容</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>smalltypes</td> 
   <td>栏目小分类</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `reid` (`reid`,`isdefault`,`channeltype`,`ispart`,`corank`,`topid`,`ishidden`),  
KEY `sortrank` (`sortrank`)

17、dede\_area： 地区表  
表名：dede\_area  
(ENGINE=MyISAM/CHARSET=gbk)|说明：地区表

索引：  
PRIMARY KEY (`id`)

18、dede\_channeltype：自定义模型(频道)表  
表名：dede\_channeltype  
(ENGINE=MyISAM/CHARSET=gbk)|说明：自定义模型(频道)表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>ID</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>nid</td> 
   <td>模型ID</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>typename</td> 
   <td>栏目名称</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>maintable</td> 
   <td>主表</td> 
   <td>varchar(50) NOT NULL default ‘dede_archives’</td> 
  </tr> 
  <tr> 
   <td>addtable</td> 
   <td>附加表</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>addcon</td> 
   <td>发布器</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>mancon</td> 
   <td>管理器</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>editcon</td> 
   <td>编辑器</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>useraddcon</td> 
   <td>会员发布器</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>usermancon</td> 
   <td>会员管理器</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>usereditcon</td> 
   <td>会员编辑器</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>fieldset</td> 
   <td>字段设置</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>listfields</td> 
   <td>列表页显示字段</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>allfields</td> 
   <td>所有字段</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>issystem</td> 
   <td>是否为系统模型</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isshow</td> 
   <td>是否显示</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>issend</td> 
   <td>是否支持投稿</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>arcsta</td> 
   <td>文档默认状态</td> 
   <td>smallint(6) NOT NULL default ‘-1’</td> 
  </tr> 
  <tr> 
   <td>usertype</td> 
   <td>支持查看会员级别</td> 
   <td>char(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>sendrank</td> 
   <td>支持投稿会员级别</td> 
   <td>smallint(6) NOT NULL default ‘10’</td> 
  </tr> 
  <tr> 
   <td>isdefault</td> 
   <td></td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>needdes</td> 
   <td>需要描述</td> 
   <td>tinyint(1) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>needpic</td> 
   <td>需要缩略图</td> 
   <td>tinyint(1) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>titlename</td> 
   <td>标题名称</td> 
   <td>varchar(20) NOT NULL default ‘标题’</td> 
  </tr> 
  <tr> 
   <td>onlyone</td> 
   <td>投稿具有唯一性</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>dfcid</td> 
   <td>默认栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `nid` (`nid`,`isshow`,`arcsta`,`sendrank`)

19、dede\_co\_htmls：采集表  
表名：dede\_co\_htmls  
(ENGINE=MyISAM/CHARSET=gbk)|说明：采集表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>编号</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>nid</td> 
   <td>采集点ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>标题</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>litpic</td> 
   <td>链接所含图片</td> 
   <td>varchar(100) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>url</td> 
   <td>网址</td> 
   <td>varchar(100) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>dtime</td> 
   <td>获取日期</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isdown</td> 
   <td>是否采集</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isexport</td> 
   <td>是否导出</td> 
   <td>tinyint(1) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>result</td> 
   <td>采集内容</td> 
   <td>mediumtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `nid` (`nid`),  
KEY `typeid` (`typeid`,`title`,`url`,`dtime`,`isdown`,`isexport`)

20、dede\_co\_mediaurls：采集路径设置表  
表名：dede\_co\_mediaurls  
(ENGINE=MyISAM/CHARSET=gbk)|说明：采集路径设置表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>nid</td> 
   <td>采集点ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>hash</td> 
   <td>打开地址</td> 
   <td>char(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>tofile</td> 
   <td>存放路径</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
KEY `hash` (`hash`)

21、dede\_co\_note：采集节点设置表  
表名：dede\_co\_note  
(ENGINE=MyISAM/CHARSET=gbk)|说明：采集节点设置表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>nid</td> 
   <td>节点ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>channelid</td> 
   <td>内容模型</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>notename</td> 
   <td>节点名称</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>sourcelang</td> 
   <td>编码</td> 
   <td>varchar(10) NOT NULL default ‘gb2312’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>采集时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>cotime</td> 
   <td>导出时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>pnum</td> 
   <td></td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isok</td> 
   <td>是否设置规则</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>usemore</td> 
   <td>是否启用多栏目通配</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>listconfig</td> 
   <td>列表匹配规则</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>itemconfig</td> 
   <td>内容匹配规则</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`nid`),  
KEY `isok` (`isok`,`channelid`,`cotime`)

22、dede\_co\_onepage：单页表  
表名：dede\_co\_onepage  
(ENGINE=MyISAM/CHARSET=gbk)|说明：单页表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>网站ID</td> 
   <td>int(11) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>url</td> 
   <td>网站地址</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>网站名称</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>issource</td> 
   <td>是否用做文章来源</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>lang</td> 
   <td>编码</td> 
   <td>varchar(10) NOT NULL default ‘gb2312’</td> 
  </tr> 
  <tr> 
   <td>rule</td> 
   <td>采集规则</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `url` (`url`)

23、dede\_co\_urls：url连接表  
表名：dede\_co\_urls  
(ENGINE=MyISAM/CHARSET=gbk)|说明：url连接表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>编号</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>hash</td> 
   <td>链接地址</td> 
   <td>varchar(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>nid</td> 
   <td>采集点ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

24、dede\_diyforms：自定义表单数据表  
表名：dede\_diyforms  
(ENGINE=MyISAM/CHARSET=gbk)|说明：自定义表单数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>diyid</td> 
   <td>自定义表单ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>name</td> 
   <td>表单名称</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>posttemplate</td> 
   <td>发布模板</td> 
   <td>varchar(50) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>viewtemplate</td> 
   <td>查看模板</td> 
   <td>varchar(50) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>listtemplate</td> 
   <td>列表模板</td> 
   <td>varchar(50) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>table</td> 
   <td>数据表</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>info</td> 
   <td>信息</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>public</td> 
   <td>前台列表和内容页公开</td> 
   <td>tinyint(1) NOT NULL default ‘1’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`diyid`)

25、dede\_dl\_log：  
26、dede\_downloads：文件下载表  
表名：dede\_downloads  
(ENGINE=MyISAM/CHARSET=gbk)|说明：文件下载表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>hash</td> 
   <td>下载hash码</td> 
   <td>char(32) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>id</td> 
   <td>下载ID</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>downloads</td> 
   <td>下载次数</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`hash`)

27、dede\_erradd：挑错数据表  
表名：dede\_erradd  
(ENGINE=MyISAM/CHARSET=gbk)|说明：挑错数据表

索引：  
KEY `id` (`id`)

28、dede\_feedback：评论数据表  
表名：dede\_feedback  
(ENGINE=MyISAM/CHARSET=gbk)|说明：评论数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>aid</td> 
   <td>文档ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>username</td> 
   <td>用户名称</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>arctitle</td> 
   <td>文档标题</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>ip</td> 
   <td>评论IP</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>ischeck</td> 
   <td>是否审核</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>dtime</td> 
   <td>评论时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>bad</td> 
   <td>踩</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>good</td> 
   <td>顶</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>ftype</td> 
   <td>论评类型</td> 
   <td>set(‘feedback’,‘good’,‘bad’) NOT NULL default ‘feedback’</td> 
  </tr> 
  <tr> 
   <td>face</td> 
   <td>会员表情</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>msg</td> 
   <td>信息内容</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `aid` (`aid`,`ischeck`,`mid`)

29、dede\_flink：友情链接数据表  
表名：dede\_flink  
(ENGINE=MyISAM/CHARSET=gbk)|说明：友情链接数据表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>ID</td> 
   <td>smallint(5) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>sortrank</td> 
   <td>排序</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>url</td> 
   <td>地址</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>webname</td> 
   <td>网站名称</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>msg</td> 
   <td>消息</td> 
   <td>char(200) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>email</td> 
   <td>电子邮件</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>logo</td> 
   <td>图标</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>dtime</td> 
   <td>申请时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>ischeck</td> 
   <td>是否审核</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

30、dede\_flinktype：友情链接类型  
表名：dede\_flinktype  
(ENGINE=MyISAM/CHARSET=gbk)|说明：友情链接类型

索引：  
PRIMARY KEY (`id`)

31、dede\_freelist：自由列表  
表名：dede\_freelist  
(ENGINE=MyISAM/CHARSET=gbk)|说明：自由列表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>文档ID</td> 
   <td>int(11) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>标题</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>namerule</td> 
   <td>命名规则</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>listdir</td> 
   <td>列表HTML存放目录</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>defaultpage</td> 
   <td>目录默认页名称</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>nodefault</td> 
   <td>不使用目录默认主页</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>templet</td> 
   <td>列表模板</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>edtime</td> 
   <td>编辑时间</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>maxpage</td> 
   <td>最大列出页数</td> 
   <td>smallint(5) unsigned NOT NULL default ‘100’</td> 
  </tr> 
  <tr> 
   <td>click</td> 
   <td>点击次数</td> 
   <td>int(11) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>listtag</td> 
   <td>列表标签</td> 
   <td>mediumtext</td> 
  </tr> 
  <tr> 
   <td>keywords</td> 
   <td>关键词</td> 
   <td>varchar(100) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>deｓｃｒｉｐｔion</td> 
   <td>描述</td> 
   <td>varchar(250) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`)

32、dede\_homepageset：更新首页  
表名：dede\_homepageset  
(ENGINE=MyISAM/CHARSET=gbk)|说明：更新首页

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>templet</td> 
   <td>模板</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>position</td> 
   <td>位置</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：

33、dede\_keywords：关键词表  
表名：dede\_keywords  
(ENGINE=MyISAM/CHARSET=gbk)|说明：关键词表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>关键词ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>keyword</td> 
   <td>关键词</td> 
   <td>char(16) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>rank</td> 
   <td>频率</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>sta</td> 
   <td>管理</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>rpurl</td> 
   <td>链接网址</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `keyword` (`keyword`,`rank`,`sta`)

34、dede\_log：操作日志表  
表名：dede\_log  
(ENGINE=MyISAM/CHARSET=gbk)|说明：操作日志表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>lid</td> 
   <td>日志ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>adminid</td> 
   <td>管理员</td> 
   <td>smallint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>filename</td> 
   <td>访问文件</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>method</td> 
   <td>方式</td> 
   <td>char(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>query</td> 
   <td>query参数</td> 
   <td>char(200) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>cip</td> 
   <td>访问IP</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>dtime</td> 
   <td>时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`lid`)

35、dede\_member：用户表  
表名：dede\_member  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>mtype</td> 
   <td>会员类型</td> 
   <td>varchar(20) NOT NULL default ‘个人’</td> 
  </tr> 
  <tr> 
   <td>userid</td> 
   <td>注册用户名</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>pwd</td> 
   <td>用户密码</td> 
   <td>char(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uname</td> 
   <td>昵称</td> 
   <td>char(36) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>sex</td> 
   <td>性别</td> 
   <td>enum(‘男’,‘女’,‘保密’) NOT NULL default ‘保密’</td> 
  </tr> 
  <tr> 
   <td>rank</td> 
   <td>会员级别值</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>更新时间</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>exptime</td> 
   <td>过期时间</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>会员金币</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>email</td> 
   <td>邮箱</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>scores</td> 
   <td>积分</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>matt</td> 
   <td>推荐</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>spacesta</td> 
   <td>会员空间状况</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>face</td> 
   <td>头像</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>safequestion</td> 
   <td>安全提示问题</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>safeanswer</td> 
   <td>安全问题答案</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>jointime</td> 
   <td>注册时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>joinip</td> 
   <td>注册IP</td> 
   <td>char(16) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>logintime</td> 
   <td>登录时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>loginip</td> 
   <td>登录IP</td> 
   <td>char(16) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`mid`),  
KEY `userid` (`userid`,`sex`),  
KEY `logintime` (`logintime`)

36、dede\_member\_company：企业用户表  
表名：dede\_member\_company  
(ENGINE=MyISAM/CHARSET=gbk)|说明：企业用户表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>company</td> 
   <td>公司名称</td> 
   <td>varchar(36) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>product</td> 
   <td>产品</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>place</td> 
   <td>地址</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>vocation</td> 
   <td>行业</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>cosize</td> 
   <td>公司规模</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tel</td> 
   <td>电话</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>fax</td> 
   <td>传真</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>linkman</td> 
   <td>联系人</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>address</td> 
   <td>地址</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>mobile</td> 
   <td>手机</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>email</td> 
   <td>邮箱</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>url</td> 
   <td>网址</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>更新时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>checked</td> 
   <td>是否审核</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>introduce</td> 
   <td>公司简介</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>comface</td> 
   <td>公司标志</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`mid`)

37、dede\_member\_feed：动态表  
表名：dede\_member\_feed  
(ENGINE=MyISAM/CHARSET=gbk)|说明：动态表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>fid</td> 
   <td>动态ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>smallint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>userid</td> 
   <td>登录ID</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uname</td> 
   <td>用户名</td> 
   <td>char(36) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>type</td> 
   <td>类型</td> 
   <td>char(20) character set gb2312 NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>aid</td> 
   <td>处理ID</td> 
   <td>mediumint(8) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>dtime</td> 
   <td>时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>标题</td> 
   <td>char(253) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>note</td> 
   <td>日志</td> 
   <td>char(200) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>ischeck</td> 
   <td>是否审核</td> 
   <td>smallint(6) NOT NULL</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`fid`)

38、dede\_member\_flink：用户友情链接表  
表名：dede\_member\_flink  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户友情链接表

索引：  
PRIMARY KEY (`aid`)

39、dede\_member\_friends：好友表  
表名：dede\_member\_friends  
(ENGINE=MyISAM/CHARSET=gbk)|说明：好友表

索引：  
PRIMARY KEY (`id`),  
KEY `fid` (`fid`,`mid`)

40、dede\_member\_group：用户分类表  
表名：dede\_member\_group  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户分类表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>分类ID</td> 
   <td>int(10) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>groupname</td> 
   <td>分类名称</td> 
   <td>varchar(50) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>int(8) NOT NULL</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `id` (`id`)

41、dede\_member\_guestbook：用户留言本  
表名：dede\_member\_guestbook  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户留言本

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>留言ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>好友ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>gid</td> 
   <td>公司名称</td> 
   <td>varchar(20) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>留言标题</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uname</td> 
   <td>留言者用户名</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>email</td> 
   <td>邮箱</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>qq</td> 
   <td>qq</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>tel</td> 
   <td>手机</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>ip</td> 
   <td>IP</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>dtime</td> 
   <td>留言时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>msg</td> 
   <td>内容</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `mid` (`mid`)

42、dede\_member\_model：用户自定义模型表  
表名：dede\_member\_model  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户自定义模型表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>模型ID</td> 
   <td>int(10) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>name</td> 
   <td>模型名称</td> 
   <td>varchar(20) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>table</td> 
   <td>数据表</td> 
   <td>varchar(30) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>deｓｃｒｉｐｔion</td> 
   <td>模型描述</td> 
   <td>varchar(50) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>state</td> 
   <td>是否启用</td> 
   <td>int(2) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>issystem</td> 
   <td>是否系统内置</td> 
   <td>int(2) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>info</td> 
   <td>内容</td> 
   <td>text NOT NULL</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

43、dede\_member\_msg：用户信息表  
表名：dede\_member\_msg  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户信息表

索引：  
PRIMARY KEY (`id`),  
KEY `id` (`ischeck`,`mid`)

44、dede\_member\_operation：用户产品表  
表名：dede\_member\_operation  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户产品表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>产品ID</td> 
   <td>int(11) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>buyid</td> 
   <td>订单号</td> 
   <td>varchar(80) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>pname</td> 
   <td>产品名称</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>product</td> 
   <td>产品</td> 
   <td>varchar(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>价格</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mtime</td> 
   <td>购买时间</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>pid</td> 
   <td>会员产品</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>sta</td> 
   <td>状态</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>oldinfo</td> 
   <td>操作</td> 
   <td>varchar(200) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `buyid` (`buyid`),  
KEY `pid` (`pid`,`mid`,`sta`)

45、dede\_member\_person：个人用户表  
表名：dede\_member\_person  
(ENGINE=MyISAM/CHARSET=gbk)|说明：个人用户表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>onlynet</td> 
   <td>联系方式限制</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>sex</td> 
   <td>性别</td> 
   <td>enum(‘男’,‘女’,‘保密’) NOT NULL default ‘男’</td> 
  </tr> 
  <tr> 
   <td>uname</td> 
   <td>昵称</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>qq</td> 
   <td>QQ号</td> 
   <td>char(12) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>msn</td> 
   <td>msn</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>tel</td> 
   <td>电话号</td> 
   <td>varchar(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>mobile</td> 
   <td>手机</td> 
   <td>varchar(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>place</td> 
   <td>目前所在地</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>oldplace</td> 
   <td>家乡</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>birthday</td> 
   <td>生日</td> 
   <td>date NOT NULL default ‘1980-01-01’</td> 
  </tr> 
  <tr> 
   <td>star</td> 
   <td>星座</td> 
   <td>smallint(6) unsigned NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>income</td> 
   <td>收入</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>education</td> 
   <td>教育程度</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>height</td> 
   <td>身高</td> 
   <td>smallint(5) unsigned NOT NULL default ‘160’</td> 
  </tr> 
  <tr> 
   <td>bodytype</td> 
   <td>体型</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>blood</td> 
   <td>血型</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>vocation</td> 
   <td>行业</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>smoke</td> 
   <td>是否抽烟</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>marital</td> 
   <td>婚姻</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>house</td> 
   <td>住房</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>drink</td> 
   <td>是否饮酒</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>datingtype</td> 
   <td>交友</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>language</td> 
   <td>语言</td> 
   <td>set(‘普通话’,‘上海话’,‘广东话’,‘英语’,‘日语’,‘韩语’,‘法语’,‘意大利语’,‘德语’,‘西班牙语’,‘俄语’,‘阿拉伯语’) default NULL</td> 
  </tr> 
  <tr> 
   <td>nature</td> 
   <td>性格</td> 
   <td>set(‘性格外向’,‘性格内向’,‘活泼开朗’,‘豪放不羁’,‘患得患失’,‘冲动’,‘幽默’,‘稳重’,‘轻浮’,‘沉默寡言’,‘多愁善感’,‘时喜时悲’,‘附庸风雅’,‘能说会道’,‘坚强’,‘脆弱’,‘幼稚’,‘成熟’,‘快言快语’,‘损人利己’,‘狡猾善变’,‘交际广泛’,‘优柔寡断’,‘自私’,‘真诚’,‘独立’,‘依赖’,‘难以琢磨’,‘悲观消极’,‘郁郁寡欢’,‘胆小怕事’,‘乐观向上’,‘任性’,‘自负’,‘自卑’,‘拜金’,‘温柔体贴’,‘小心翼翼’,‘暴力倾向’,‘逆来顺受’,‘不拘小节’,‘暴躁’,‘倔强’,‘豪爽’,‘害羞’,‘婆婆妈妈’,‘敢做敢当’,‘助人为乐’,‘耿直’,‘虚伪’,‘孤僻’,‘老实’,‘守旧’,‘敏感’,‘迟钝’,‘婆婆妈妈’,‘武断’,‘果断’,‘刻薄’) default NULL</td> 
  </tr> 
  <tr> 
   <td>lovemsg</td> 
   <td>人生格言</td> 
   <td>varchar(100) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>address</td> 
   <td>家庭住址</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>更新时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`mid`)

46、dede\_member\_pms：用户消息表  
表名：dede\_member\_pms  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户消息表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>信息ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>floginid</td> 
   <td>发信人</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>fromid</td> 
   <td>发信人ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>toid</td> 
   <td>收信人ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tologinid</td> 
   <td>收信人</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>folder</td> 
   <td>信箱类型</td> 
   <td>enum(‘inbox’,‘outbox’) default ‘inbox’</td> 
  </tr> 
  <tr> 
   <td>subject</td> 
   <td>信息标题</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>sendtime</td> 
   <td>发送时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>writetime</td> 
   <td>写信时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>hasview</td> 
   <td>阅读状态</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isadmin</td> 
   <td>是否为系统信息</td> 
   <td>tinyint(1) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>message</td> 
   <td>信息内容</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `sendtime` (`sendtime`)

47、dede\_member\_snsmsg：用户短信息表  
表名：dede\_member\_snsmsg  
(ENGINE=MyISAM/CHARSET=latin1)|说明：用户短信息表

索引：  
PRIMARY KEY (`id`)

48、dede\_member\_space：用户空间表  
表名：dede\_member\_space  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户空间表

索引：  
PRIMARY KEY (`mid`)

49、dede\_member\_stow：用户收藏表  
表名：dede\_member\_stow  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户收藏表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>收藏ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>aid</td> 
   <td>文章ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>文章标题</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>addtime</td> 
   <td>收藏时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>type</td> 
   <td>类型</td> 
   <td>varchar(20) NOT NULL default ‘sys’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `uid` (`mid`)

50、dede\_member\_stowtype：用户收藏类型表  
表名：dede\_member\_stowtype  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户收藏类型表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>stowname</td> 
   <td>收藏类型</td> 
   <td>varchar(30) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>indexname</td> 
   <td>收藏名称</td> 
   <td>varchar(30) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>indexurl</td> 
   <td>收藏地址</td> 
   <td>varchar(50) NOT NULL</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`stowname`)

51、dede\_member\_tj：  
表名：dede\_member\_tj  
(ENGINE=MyISAM/CHARSET=gbk)|说明：Top

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>article</td> 
   <td>文章数目</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>album</td> 
   <td>相册数目</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>archives</td> 
   <td>档案数目</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>homecount</td> 
   <td>空间访问次数</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>pagecount</td> 
   <td>页面访问</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>feedback</td> 
   <td>评论数目</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>friend</td> 
   <td>好友数目</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>stow</td> 
   <td>收藏数目</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>soft</td> 
   <td>软件数目</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>info</td> 
   <td>分类信息数目</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>shop</td> 
   <td>商品数目</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`mid`)

52、dede\_member\_type：会员类型表  
表名：dede\_member\_type  
(ENGINE=MyISAM/CHARSET=gbk)|说明：会员类型表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>ID</td> 
   <td>int(11) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>rank</td> 
   <td>会员级别</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>pname</td> 
   <td>产品名称</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>价格</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>exptime</td> 
   <td>会员期限</td> 
   <td>int(11) NOT NULL default ‘30’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`)

53、dede\_member\_vhistory：会员历史访问表  
表名：dede\_member\_vhistory  
(ENGINE=MyISAM/CHARSET=gbk)|说明：会员历史访问表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>访问ID</td> 
   <td>int(10) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>loginid</td> 
   <td>登录名</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>vid</td> 
   <td>被访问者ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>vloginid</td> 
   <td>被访问者用户名</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>count</td> 
   <td>访问次数</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>vip</td> 
   <td>登录IP</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>vtime</td> 
   <td>访问时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `vtime` (`vtime`),  
KEY `mid` (`mid`,`vid`)

54、dede\_moneycard\_record：用户点卡表  
表名：dede\_moneycard\_record  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户点卡表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>点卡ID</td> 
   <td>int(11) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>ctid</td> 
   <td>点卡类型</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>cardid</td> 
   <td>点卡</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uid</td> 
   <td>使用会员ID</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isexp</td> 
   <td>状态</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mtime</td> 
   <td>生成时间</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>utime</td> 
   <td>使用日期</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>价格</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>num</td> 
   <td>点数</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `ctid` (`ctid`),  
KEY `cardid` (`cardid`),  
KEY `uid` (`uid`)

55、dede\_moneycard\_type：点卡类型表  
表名：dede\_moneycard\_type  
(ENGINE=MyISAM/CHARSET=gbk)|说明：点卡类型表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>tid</td> 
   <td>点卡类型ID</td> 
   <td>int(11) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>num</td> 
   <td>点数</td> 
   <td>int(11) NOT NULL default ‘500’</td> 
  </tr> 
  <tr> 
   <td>money</td> 
   <td>价格</td> 
   <td>int(11) NOT NULL default ‘50’</td> 
  </tr> 
  <tr> 
   <td>pname</td> 
   <td>类型名称</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`tid`)

56、dede\_mtypes：  
表名：dede\_mtypes  
(ENGINE=MyISAM/CHARSET=gbk)|说明：Top

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mtypeid</td> 
   <td>分类ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>mtypename</td> 
   <td>分类名称</td> 
   <td>char(40) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>channelid</td> 
   <td>内容模型</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`mtypeid`)

57、dede\_multiserv\_config：远程配置表  
表名：dede\_multiserv\_config  
(ENGINE=MyISAM/CHARSET=gbk)|说明：远程配置表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>remoteuploads</td> 
   <td>是否启用附件服务器</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>remoteupUrl</td> 
   <td>附件服务器域名</td> 
   <td>text NOT NULL</td> 
  </tr> 
  <tr> 
   <td>rminfo</td> 
   <td>远程服务器</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>servinfo</td> 
   <td>远程服务器列表</td> 
   <td>mediumtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`remoteuploads`)

58、dede\_myad：我的广告表  
表名：dede\_myad  
(ENGINE=MyISAM/CHARSET=gbk)|说明：我的广告表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>编号</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>广告位标识</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tagname</td> 
   <td>广告范围</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>adname</td> 
   <td>广告名称</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>timeset</td> 
   <td>时间限制</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>starttime</td> 
   <td>广告投放开始时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>endtime</td> 
   <td>广告投放结束时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>normbody</td> 
   <td>正常显示内容</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>expbody</td> 
   <td>过期显示内容</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`)

59、dede\_myadtype：我的广告类型表  
表名：dede\_myad  
(ENGINE=MyISAM/CHARSET=gbk)|说明：我的广告类型表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>编号</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>typename</td> 
   <td>类型名称</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),

60、dede\_mytag：我的标签表  
表名：dede\_mytag  
(ENGINE=MyISAM/CHARSET=gbk)|说明：我的标签表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>标记ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tagname</td> 
   <td>标记名称</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>timeset</td> 
   <td>时间限制</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>starttime</td> 
   <td>开始时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>endtime</td> 
   <td>结束时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>normbody</td> 
   <td>正常显示内容</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>expbody</td> 
   <td>过期显示内容</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`)

61、dede\_payment：支付表  
表名：dede\_payment  
(ENGINE=MyISAM/CHARSET=gbk)|说明：支付表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>编号</td> 
   <td>tinyint(3) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>code</td> 
   <td>接口类型</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>name</td> 
   <td>接口名称</td> 
   <td>varchar(120) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>fee</td> 
   <td></td> 
   <td>varchar(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>description</td> 
   <td>描述</td> 
   <td>text NOT NULL</td> 
  </tr> 
  <tr> 
   <td>rank</td> 
   <td></td> 
   <td>tinyint(3) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>config</td> 
   <td></td> 
   <td>text NOT NULL</td> 
  </tr> 
  <tr> 
   <td>enabled</td> 
   <td></td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>cod</td> 
   <td></td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>online</td> 
   <td></td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
UNIQUE KEY `code` (`code`)

62、dede\_plus：插件表  
表名：dede\_plus  
(ENGINE=MyISAM/CHARSET=gbk)|说明：插件表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>插件ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>plusname</td> 
   <td>插件名称</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>menustring</td> 
   <td>菜单配置</td> 
   <td>varchar(200) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>mainurl</td> 
   <td>目标框架</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>writer</td> 
   <td>作者</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>isshow</td> 
   <td>是否启用</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>filelist</td> 
   <td>文件列表</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`)

63、dede\_purview：  
表名：dede\_purview  
(ENGINE=MyISAM/CHARSET=gbk)|说明：插件表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mid</td> 
   <td></td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td></td> 
   <td>smallint(5) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>rank</td> 
   <td></td> 
   <td>smallint(6) NOT NULL default NULL</td> 
  </tr> 
  <tr> 
   <td>pkey</td> 
   <td></td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>pvalue</td> 
   <td></td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`mid`)

64、dede\_pwd\_tmp：  
表名：dede\_pwd\_tmp  
(ENGINE=MyISAM/CHARSET=gbk)|说明：Top

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>membername</td> 
   <td>会员名称</td> 
   <td>char(16) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>pwd</td> 
   <td>密码</td> 
   <td>char(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>mailtime</td> 
   <td>邮件发送时间</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`mid`)

65、dede\_ratings：  
表名：dede\_ratings  
(ENGINE=MyISAM/CHARSET=gbk)|说明：Top

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>编号</td> 
   <td>varchar(11) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>total_votes</td> 
   <td>投票总数</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>total_value</td> 
   <td>投票总数的值</td> 
   <td>int(11) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>used_ips</td> 
   <td>投票的IP</td> 
   <td>longtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

66、dede\_scores：级别表  
表名：dede\_scores  
(ENGINE=MyISAM/CHARSET=gbk)|说明：级别表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>编号</td> 
   <td>int(11) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>titles</td> 
   <td>级别头衔</td> 
   <td>char(15) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>icon</td> 
   <td>星星数</td> 
   <td>smallint(6) unsigned default ‘0’</td> 
  </tr> 
  <tr> 
   <td>integral</td> 
   <td>积分</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>isdefault</td> 
   <td>是否默认</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`),  
KEY `integral` (`integral`)

67、dede\_search\_cache：搜索缓存表  
表名：dede\_search\_cache  
(ENGINE=MyISAM/CHARSET=gbk)|说明：搜索缓存表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>hash</td> 
   <td>hash值</td> 
   <td>char(32) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>lasttime</td> 
   <td>最后查询时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>rsnum</td> 
   <td>查询结果的数量</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>ids</td> 
   <td>返回的ID值</td> 
   <td>mediumtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`hash`)

68、dede\_search\_keywords：搜索关键词表  
表名：dede\_search\_keywords  
(ENGINE=MyISAM/CHARSET=gbk)|说明：搜索关键词表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>搜索ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>keyword</td> 
   <td>关键词</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>spwords</td> 
   <td>分词结果</td> 
   <td>char(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>count</td> 
   <td>频率</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>result</td> 
   <td>搜索结果条数</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>lasttime</td> 
   <td>最后搜索时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>channelid</td> 
   <td>频道ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`)

69、dede\_sgpage：  
表名：dede\_sgpage  
(ENGINE=MyISAM/CHARSET=gbk)|说明：Top

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>单页ID</td> 
   <td>smallint(5) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>页面标题</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>ismake</td> 
   <td>是否编译内容</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>filename</td> 
   <td>文件名</td> 
   <td>varchar(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>keywords</td> 
   <td>关键词</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>template</td> 
   <td>模板文件名</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>likeid</td> 
   <td>关联标识</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>deｓｃｒｉｐｔion</td> 
   <td>页面摘要信息</td> 
   <td>varchar(250) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>添加时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>body</td> 
   <td>内容</td> 
   <td>mediumtext</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `ismake` (`ismake`,`uptime`),  
KEY `likeid` (`likeid`)

70、dede\_shops\_delivery：商品配送表  
表名：dede\_shops\_delivery  
(ENGINE=MyISAM/CHARSET=gbk)|说明：商品配送表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>pid</td> 
   <td>编号</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>dname</td> 
   <td>配送方式</td> 
   <td>char(80) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>price</td> 
   <td>价格</td> 
   <td>float(13,2) NOT NULL default ‘0.00’</td> 
  </tr> 
  <tr> 
   <td>des</td> 
   <td>说明</td> 
   <td>char(255) default NULL</td> 
  </tr> 
  <tr> 
   <td>orders</td> 
   <td>订单次数</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`pid`),  
KEY `orders` (`orders`)

71、dede\_shops\_orders：商品订单表  
表名：dede\_shops\_orders  
(ENGINE=MyISAM/CHARSET=gbk)|说明：商品订单表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>oid</td> 
   <td>订单号</td> 
   <td>varchar(80) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>userid</td> 
   <td>消费者ID</td> 
   <td>int(10) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>pid</td> 
   <td>配送方式</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>paytype</td> 
   <td>支付方式</td> 
   <td>tinyint(2) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>cartcount</td> 
   <td>购买数量</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>dprice</td> 
   <td>配送费用</td> 
   <td>float(13,2) NOT NULL default ‘0.00’</td> 
  </tr> 
  <tr> 
   <td>price</td> 
   <td>订单价格</td> 
   <td>float(13,2) NOT NULL default ‘0.00’</td> 
  </tr> 
  <tr> 
   <td>priceCount</td> 
   <td>总价格</td> 
   <td>float(13,2) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>state</td> 
   <td>状态</td> 
   <td>tinyint(1) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>ip</td> 
   <td>登录IP</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>stime</td> 
   <td>下单时间</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
KEY `stime` (`stime`),  
KEY `userid` (`userid`),  
KEY `oid` (`oid`)

72、dede\_shops\_products：商品产品表  
表名：dede\_shops\_products  
(ENGINE=MyISAM/CHARSET=gbk)|说明：商品产品表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>产品ID</td> 
   <td>mediumint(8) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>oid</td> 
   <td>订单号</td> 
   <td>varchar(80) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>userid</td> 
   <td>消费者ID</td> 
   <td>int(10) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>产品名称</td> 
   <td>varchar(80) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>price</td> 
   <td>价格</td> 
   <td>float(13,2) NOT NULL default ‘0.00’</td> 
  </tr> 
  <tr> 
   <td>buynum</td> 
   <td>购买数量</td> 
   <td>int(10) NOT NULL default ‘9’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
KEY `oid` (`oid`),  
KEY `userid` (`userid`)

73、dede\_shops\_userinfo：商品用户信息表  
表名：dede\_shops\_userinfo  
(ENGINE=MyISAM/CHARSET=gbk)|说明：商品用户信息表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>userid</td> 
   <td>编号</td> 
   <td>int(10) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>oid</td> 
   <td>订单号</td> 
   <td>varchar(80) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>consignee</td> 
   <td>收货人</td> 
   <td>char(15) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>address</td> 
   <td>街道地址</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>zip</td> 
   <td>邮编</td> 
   <td>int(10) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tel</td> 
   <td>电话</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>email</td> 
   <td>邮箱</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>des</td> 
   <td>购买留言</td> 
   <td>varchar(255) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
KEY `oid` (`oid`),  
KEY `userid` (`userid`)

74、dede\_softconfig：软件配置表  
表名：dede\_softconfig  
(ENGINE=MyISAM/CHARSET=gbk)|说明：软件配置表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>downtype</td> 
   <td>链接显示方式</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>ismoresite</td> 
   <td>是否启用镜像站点</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>gotojump</td> 
   <td>附件下载方式</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>islocal</td> 
   <td>启用镜像站点后是否保留本地下载</td> 
   <td>smallint(5) unsigned NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>sites</td> 
   <td>镜像服务器列表</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>downmsg</td> 
   <td>下载说明</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>moresitedo</td> 
   <td>镜像处理方式</td> 
   <td>smallint(5) unsigned NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>dfrank</td> 
   <td>下载默认等级</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>dfywboy</td> 
   <td>下载默认金币</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>argrange</td> 
   <td>参数限制方式</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`downtype`)

75、dede\_sphinx：  
表名：dede\_sphinx  
(ENGINE=MyISAM/CHARSET=gbk)|说明：

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>countid</td> 
   <td></td> 
   <td>Int(11) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>maxaid</td> 
   <td></td> 
   <td>Int(11) unsigned NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`countid`)

76、dede\_stepselect：  
表名：dede\_stepselect  
(ENGINE=MyISAM/CHARSET=gbk)|说明：

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>参数ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>itemname</td> 
   <td>参数名</td> 
   <td>char(30) NOT NULL default NULL</td> 
  </tr> 
  <tr> 
   <td>egroup</td> 
   <td>变量说明</td> 
   <td>char(20) NOT NULL default NULL</td> 
  </tr> 
  <tr> 
   <td>issign</td> 
   <td>变量类型ID</td> 
   <td>tinyint(1) UNSIGNED NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>issystem</td> 
   <td>变量类型</td> 
   <td>tinyint(1) UNSIGNED NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

77、dede\_sysconfig：系统配置表  
表名：dede\_sysconfig  
(ENGINE=MyISAM/CHARSET=gbk)|说明：系统配置表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>参数ID</td> 
   <td>smallint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>varname</td> 
   <td>参数名</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>info</td> 
   <td>变量说明</td> 
   <td>varchar(100) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>groupid</td> 
   <td>变量类型ID</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>type</td> 
   <td>变量类型</td> 
   <td>varchar(10) NOT NULL default ‘string’</td> 
  </tr> 
  <tr> 
   <td>value</td> 
   <td>值</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`varname`)

78、dede\_sys\_enum：  
表名：dede\_sys\_enum  
(ENGINE=MyISAM/CHARSET=gbk)|说明：Top

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>编号ID</td> 
   <td>smallint(5) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>ename</td> 
   <td>枚举名</td> 
   <td>char(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>evalue</td> 
   <td>枚举值</td> 
   <td>char(20) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>egroup</td> 
   <td>类别组名</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>disorder</td> 
   <td>组内排序</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>issign</td> 
   <td>是否系统内置</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘1’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

79、dede\_sys\_module：系统模块表  
表名：dede\_sys\_module  
(ENGINE=MyISAM/CHARSET=gbk)|说明：系统模块表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>编号</td> 
   <td>int(11) NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>hashcode</td> 
   <td>模块识别码</td> 
   <td>char(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>modname</td> 
   <td>插件名称</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>indexname</td> 
   <td>导航使用名称</td> 
   <td>varchar(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>indexurl</td> 
   <td>导航链接地址</td> 
   <td>varchar(30) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>ismember</td> 
   <td>是否涉及会员系统</td> 
   <td>tinyint(4) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>menustring</td> 
   <td>后台管理菜单</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

80、dede\_sys\_set：系统设置表  
表名：dede\_sys\_set  
(ENGINE=MyISAM/CHARSET=gbk)|说明：系统设置表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>设置ID</td> 
   <td>smallint(5) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>sname</td> 
   <td>设置名称</td> 
   <td>char(20) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>items</td> 
   <td>设置条目</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

81、dede\_sys\_task：计划任务表  
表名：dede\_sys\_task  
(ENGINE=MyISAM/CHARSET=gbk)|说明：计划任务表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>计划ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>taskname</td> 
   <td>任务名称</td> 
   <td>varchar(50) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>dourl</td> 
   <td>运行程序</td> 
   <td>varchar(100) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>islock</td> 
   <td>是否启用</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>runtype</td> 
   <td>循环方式</td> 
   <td>tinyint(1) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>runtime</td> 
   <td>运行时间</td> 
   <td>varchar(10) default ‘0000’</td> 
  </tr> 
  <tr> 
   <td>starttime</td> 
   <td>开始时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>endtime</td> 
   <td>结束时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>freq</td> 
   <td>周期</td> 
   <td>tinyint(2) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>lastrun</td> 
   <td>上次运行时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>deｓｃｒｉｐｔion</td> 
   <td>任务说明</td> 
   <td>varchar(250) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>parameter</td> 
   <td>附加参数</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td>settime</td> 
   <td>设置时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>sta</td> 
   <td>运行状态</td> 
   <td>enum(‘运行’,‘成功’,‘失败’) default NULL</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

82、dede\_tagindex：标签索引表  
表名：dede\_tagindex  
(ENGINE=MyISAM/CHARSET=gbk)|说明：标签索引表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>tagid</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>tag</td> 
   <td>tag内容</td> 
   <td>char(12) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>count</td> 
   <td>点击</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>total</td> 
   <td>文档数</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>weekcc</td> 
   <td>周统计</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>monthcc</td> 
   <td>月统计</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>weekup</td> 
   <td>每周更新</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>monthup</td> 
   <td>每月更新</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>addtime</td> 
   <td>添加时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`id`)

83、dede\_taglist：文章标签表  
表名：dede\_taglist  
(ENGINE=MyISAM/CHARSET=gbk)|说明：文章标签表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>tid</td> 
   <td>tagid</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>aid</td> 
   <td>文章ID</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>arcrank</td> 
   <td>时间限制</td> 
   <td>smallint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>栏目ID</td> 
   <td>smallint(5) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>tag</td> 
   <td>tag内容</td> 
   <td>varchar(12) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`tid`,`aid`)

84、dede\_uploads：附件上传表  
表名：dede\_uploads  
(ENGINE=MyISAM/CHARSET=gbk)|说明：附件上传表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>arcid</td> 
   <td>文章ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>文章标题</td> 
   <td>char(60) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>url</td> 
   <td>文件存储路径</td> 
   <td>char(80) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>mediatype</td> 
   <td>媒体类型</td> 
   <td>smallint(6) NOT NULL default ‘1’</td> 
  </tr> 
  <tr> 
   <td>width</td> 
   <td>图片宽度</td> 
   <td>char(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>height</td> 
   <td>图片高度</td> 
   <td>char(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>playtime</td> 
   <td>播放时间</td> 
   <td>char(10) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>filesize</td> 
   <td>文件大小</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>上传时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>上传者会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`),  
KEY `memberid` (`mid`),  
KEY `arcid` (`arcid`)

85、dede\_verifies：安全检验表  
表名：dede\_verifies  
(ENGINE=MyISAM/CHARSET=gbk)|说明：安全检验表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>nameid</td> 
   <td>编号</td> 
   <td>char(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>cthash</td> 
   <td>文件HASH</td> 
   <td>varchar(32) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>method</td> 
   <td>校验方式</td> 
   <td>enum(‘local’,‘official’) NOT NULL default ‘official’</td> 
  </tr> 
  <tr> 
   <td>filename</td> 
   <td>文件名</td> 
   <td>varchar(254) NOT NULL default ‘’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`nameid`)

86、dede\_vote：投票表  
表名：dede\_vote  
(ENGINE=MyISAM/CHARSET=gbk)|说明：投票表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>aid</td> 
   <td>投票ID</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>votename</td> 
   <td>投票题目</td> 
   <td>varchar(50) NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>starttime</td> 
   <td>开始时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>endtime</td> 
   <td>结束时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>totalcount</td> 
   <td>总票数</td> 
   <td>mediumint(8) unsigned NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>ismore</td> 
   <td>是否多选</td> 
   <td>tinyint(6) NOT NULL default ‘0’</td> 
  </tr> 
  <tr> 
   <td>votenote</td> 
   <td>投票选项</td> 
   <td>text</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`)

87、dede\_vote\_member：用户投票表  
表名：dede\_vote  
(ENGINE=MyISAM/CHARSET=gbk)|说明：用户投票表

<table> 
 <thead> 
  <tr> 
   <th>字段名</th> 
   <th>说明描述</th> 
   <th>具体参数</th> 
  </tr> 
 </thead> 
 <tbody> 
  <tr> 
   <td>id</td> 
   <td>用户投票的id</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>voteid</td> 
   <td>投票id号</td> 
   <td>int(10) unsigned NOT NULL default '0</td> 
  </tr> 
  <tr> 
   <td>userid</td> 
   <td>用户id号</td> 
   <td>varchar(50)NOT NULL default ‘’</td> 
  </tr> 
  <tr> 
   <td>uptime</td> 
   <td>更新时间</td> 
   <td>int(10) unsigned NOT NULL default ‘0’</td> 
  </tr> 
 </tbody> 
</table>

索引：  
PRIMARY KEY (`aid`)  
|