[最新]织梦dedecms5.7数据库结构详细说明-附表名与字段名

你的名字 2022-04-18 01:50 493阅读 0赞

织梦dedecms-v5.7数据表结构详细说明-附表名与字段名，新手入门学习必备。

**1、dede\_addonarticle：附加文章表 **

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_addonarticle(ENGINE=MyISAM/CHARSET=utf8) 说明：附加文章表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</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>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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `typeid` (`typeid`)</td> 
  </tr> 
 </tbody> 
</table>

**2、dede\_addonimages： 附加图集表 **

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_addonimages(ENGINE=MyISAM/CHARSET=utf8) 说明：附加图集表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</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>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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `imagesMain` (`typeid`)</td> 
  </tr> 
 </tbody> 
</table>

**3、dede\_addoninfos： 附加分类表**

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_addoninfos(ENGINE=MyISAM/CHARSET=gbk) 说明：附加分类表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `typeid` (`typeid`,`nativeplace`,`infotype`),<br> KEY `channel` (`channel`,`arcrank`,`mid`,`click`,`title`,`litpic`,`senddate`,`flag`,`endtime`)</td> 
  </tr> 
 </tbody> 
</table>

**   
4、dede\_addonshop： 附加商品表**

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_addonshop(ENGINE=MyISAM/CHARSET=gbk) 说明：附加商品表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</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>body</td> 
   <td>商品简介</td> 
   <td>mediumtext</td> 
  </tr> 
  <tr> 
   <td>price</td> 
   <td>市场价</td> 
   <td>float NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>trueprice</td> 
   <td>优惠价</td> 
   <td>float NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>brand</td> 
   <td>品牌</td> 
   <td>varchar(250) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>units</td> 
   <td>计量单位</td> 
   <td>varchar(250) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>templet</td> 
   <td>自定义模板</td> 
   <td>varchar(30) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>userip</td> 
   <td>用户ip</td> 
   <td>char(15) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>redirecturl</td> 
   <td>跳转地址</td> 
   <td>varchar(255) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>vocation</td> 
   <td>&nbsp;</td> 
   <td>char(20) NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>infotype</td> 
   <td>&nbsp;</td> 
   <td>char(20) NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `typeid` (`typeid`)</td> 
  </tr> 
 </tbody> 
</table>

**5、dede\_addonsoft ： 附加软件表**

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_addonsoft(ENGINE=MyISAM/CHARSET=gbk) 说明：附加软件表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</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>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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `softMain` (`typeid`)</td> 
  </tr> 
 </tbody> 
</table>

**6、dede\_addonspec： 附加专题表**

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_addonspec(ENGINE=MyISAM/CHARSET=gbk) 说明：附加专题表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</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>note</td> 
   <td>专题记录字段</td> 
   <td>text</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 colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `typeid` (`typeid`)</td> 
  </tr> 
 </tbody> 
</table>

**7、dede\_admin： 管理员信息表 **

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_admin(ENGINE=MyISAM/CHARSET=gbk) 说明：管理员信息表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

**8、dede\_admintype：系统用户组管理表 **

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_admintype(ENGINE=MyISAM/CHARSET=gbk) 说明：系统用户组管理表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`rank`)</td> 
  </tr> 
 </tbody> 
</table>

**9、dede\_advancedsearch：高级搜索表**

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_advancedsearch(ENGINE=MyISAM/CHARSET=gbk) 说明：高级搜索表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> UNIQUE KEY `mid` (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

**10、dede\_arcatt：文档自定义属性表 **

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_arcatt(ENGINE=MyISAM/CHARSET=gbk) 说明：文档自定义属性表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`att`)</td> 
  </tr> 
 </tbody> 
</table>

**11、dede\_arccache：文档缓存表**

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_arccache(ENGINE=MyISAM/CHARSET=gbk) 说明：文档缓存表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`md5hash`)</td> 
  </tr> 
 </tbody> 
</table>

12、dede\_archives：文档主表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_archives(ENGINE=MyISAM/CHARSET=gbk) 说明：文档主表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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>&nbsp;</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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `sortrank` (`sortrank`),<br> KEY `mainindex` (`arcrank`,`typeid`,`channel`,`flag`,`mid`),<br> KEY `lastpost` (`lastpost`,`scores`,`goodpost`,`badpost`,`notpost`)</td> 
  </tr> 
 </tbody> 
</table>

13、dede\_arcmulti：多页标记存储数据表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_arcmulti(ENGINE=MyISAM/CHARSET=gbk) 说明：多页标记存储数据表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

14、dede\_arcrank：文档阅读权限表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_arcrank(ENGINE=MyISAM/CHARSET=gbk) 说明：文档阅读权限表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

15、dede\_arctiny：文档微表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_arctiny(ENGINE=MyISAM/CHARSET=gbk) 说明：文档微表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `sortrank` (`sortrank`)</td> 
  </tr> 
 </tbody> 
</table>

16、dede\_arctype：栏目管理表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_arctype(ENGINE=MyISAM/CHARSET=gbk) 说明：栏目管理表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `reid` (`reid`,`isdefault`,`channeltype`,`ispart`,`corank`,`topid`,`ishidden`),<br> KEY `sortrank` (`sortrank`)</td> 
  </tr> 
 </tbody> 
</table>

17、dede\_area： 地区表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_area(ENGINE=MyISAM/CHARSET=gbk) 说明：地区表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <tr> 
   <td>id</td> 
   <td>ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>name</td> 
   <td>名称</td> 
   <td>varchar(20) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>reid</td> 
   <td>所属ID</td> 
   <td>int(10) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>disorder</td> 
   <td>排序ID</td> 
   <td>int(10) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

18、dede\_channeltype：自定义模型(频道)表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_channeltype(ENGINE=MyISAM/CHARSET=gbk) 说明：自定义模型(频道)表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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>&nbsp;</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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `nid` (`nid`,`isshow`,`arcsta`,`sendrank`)</td> 
  </tr> 
 </tbody> 
</table>

19、dede\_co\_htmls：采集表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_co_htmls(ENGINE=MyISAM/CHARSET=gbk) 说明：采集表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `nid` (`nid`),<br> KEY `typeid` (`typeid`,`title`,`url`,`dtime`,`isdown`,`isexport`)</td> 
  </tr> 
 </tbody> 
</table>

20、dede\_co\_mediaurls：采集路径设置表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_co_mediaurls(ENGINE=MyISAM/CHARSET=gbk) 说明：采集路径设置表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> KEY `hash` (`hash`)</td> 
  </tr> 
 </tbody> 
</table>

21、dede\_co\_note：采集节点设置表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_co_note(ENGINE=MyISAM/CHARSET=gbk) 说明：采集节点设置表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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>&nbsp;</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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`nid`),<br> KEY `isok` (`isok`,`channelid`,`cotime`)</td> 
  </tr> 
 </tbody> 
</table>

22、dede\_co\_onepage：单页表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_co_onepage(ENGINE=MyISAM/CHARSET=gbk) 说明：单页表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `url` (`url`)</td> 
  </tr> 
 </tbody> 
</table>

23、dede\_co\_urls：url连接表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_co_urls(ENGINE=MyISAM/CHARSET=gbk) 说明：url连接表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

24、dede\_diyforms：自定义表单数据表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_diyforms(ENGINE=MyISAM/CHARSET=gbk) 说明：自定义表单数据表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`diyid`)</td> 
  </tr> 
 </tbody> 
</table>

25、dede\_dl\_log：  
26、dede\_downloads：文件下载表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_downloads(ENGINE=MyISAM/CHARSET=gbk) 说明：文件下载表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`hash`)</td> 
  </tr> 
 </tbody> 
</table>

27、dede\_erradd：挑错数据表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_erradd(ENGINE=MyISAM/CHARSET=gbk) 说明：挑错数据表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned default NULL</td> 
  </tr> 
  <tr> 
   <td>title</td> 
   <td>标题</td> 
   <td>char(60) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>type</td> 
   <td>类型</td> 
   <td>smallint(6) NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>errtxt</td> 
   <td>错误信息</td> 
   <td>mediumtext</td> 
  </tr> 
  <tr> 
   <td>oktxt</td> 
   <td>正确信息</td> 
   <td>mediumtext</td> 
  </tr> 
  <tr> 
   <td>sendtime</td> 
   <td>发布时间</td> 
   <td>int(10) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> KEY `id` (`id`)</td> 
  </tr> 
 </tbody> 
</table>

28、dede\_feedback：评论数据表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_feedback(ENGINE=MyISAM/CHARSET=gbk) 说明：评论数据表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `aid` (`aid`,`ischeck`,`mid`)</td> 
  </tr> 
 </tbody> 
</table>

29、dede\_flink：友情链接数据表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_flink(ENGINE=MyISAM/CHARSET=gbk) 说明：友情链接数据表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

30、dede\_flinktype：友情链接类型

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_flinktype(ENGINE=MyISAM/CHARSET=gbk) 说明：友情链接类型 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <tr> 
   <td>id</td> 
   <td>ID</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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

31、dede\_freelist：自由列表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_freelist(ENGINE=MyISAM/CHARSET=gbk) 说明：自由列表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`)</td> 
  </tr> 
 </tbody> 
</table>

32、dede\_homepageset：更新首页

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_homepageset(ENGINE=MyISAM/CHARSET=gbk) 说明：更新首页 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：</td> 
  </tr> 
 </tbody> 
</table>

33、dede\_keywords：关键词表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_keywords(ENGINE=MyISAM/CHARSET=gbk) 说明：关键词表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `keyword` (`keyword`,`rank`,`sta`)</td> 
  </tr> 
 </tbody> 
</table>

34、dede\_log：操作日志表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_log(ENGINE=MyISAM/CHARSET=gbk) 说明：操作日志表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`lid`)</td> 
  </tr> 
 </tbody> 
</table>

35、dede\_member：用户表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member(ENGINE=MyISAM/CHARSET=gbk) 说明：用户表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mid`),<br> KEY `userid` (`userid`,`sex`),<br> KEY `logintime` (`logintime`)</td> 
  </tr> 
 </tbody> 
</table>

36、dede\_member\_company：企业用户表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_company(ENGINE=MyISAM/CHARSET=gbk) 说明：企业用户表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

37、dede\_member\_feed：动态表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_feed(ENGINE=MyISAM/CHARSET=gbk) 说明：动态表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`fid`)</td> 
  </tr> 
 </tbody> 
</table>

38、dede\_member\_flink：用户友情链接表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_flink(ENGINE=MyISAM/CHARSET=gbk) 说明：用户友情链接表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <tr> 
   <td>aid</td> 
   <td>ID</td> 
   <td>mediumint(8) 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>title</td> 
   <td>链接标题</td> 
   <td>varchar(30) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>url</td> 
   <td>链接地址</td> 
   <td>varchar(100) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`)</td> 
  </tr> 
 </tbody> 
</table>

39、dede\_member\_friends：好友表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_friends(ENGINE=MyISAM/CHARSET=gbk) 说明：好友表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <tr> 
   <td>id</td> 
   <td>ID</td> 
   <td>int(10) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>fid</td> 
   <td>好友的会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>floginid</td> 
   <td>好友的登录名</td> 
   <td>char(20) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>funame</td> 
   <td>公司名</td> 
   <td>char(36) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>addtime</td> 
   <td>时间</td> 
   <td>int(10) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>ftype</td> 
   <td>朋友类型</td> 
   <td>tinyint(4) NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>groupid</td> 
   <td>分组ID</td> 
   <td>int(8) NOT NULL default '1'</td> 
  </tr> 
  <tr> 
   <td>deｓｃｒｉｐｔion</td> 
   <td>描述</td> 
   <td>varchar(200) default NULL</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `fid` (`fid`,`mid`)</td> 
  </tr> 
 </tbody> 
</table>

40、dede\_member\_group：用户分类表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_group(ENGINE=MyISAM/CHARSET=gbk) 说明：用户分类表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `id` (`id`)</td> 
  </tr> 
 </tbody> 
</table>

41、dede\_member\_guestbook：用户留言本

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_guestbook(ENGINE=MyISAM/CHARSET=gbk) 说明：用户留言本 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `mid` (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

42、dede\_member\_model：用户自定义模型表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_model(ENGINE=MyISAM/CHARSET=gbk) 说明：用户自定义模型表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

43、dede\_member\_msg：用户信息表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_msg(ENGINE=MyISAM/CHARSET=gbk) 说明：用户信息表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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>userid</td> 
   <td>用户名</td> 
   <td>char(20) 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>msg</td> 
   <td>内容</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `id` (`ischeck`,`mid`)</td> 
  </tr> 
 </tbody> 
</table>

44、dede\_member\_operation：用户产品表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_operation(ENGINE=MyISAM/CHARSET=gbk) 说明：用户产品表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `buyid` (`buyid`),<br> KEY `pid` (`pid`,`mid`,`sta`)</td> 
  </tr> 
 </tbody> 
</table>

45、dede\_member\_person：个人用户表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_person(ENGINE=MyISAM/CHARSET=gbk) 说明：个人用户表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

46、dede\_member\_pms：用户消息表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_pms(ENGINE=MyISAM/CHARSET=gbk) 说明：用户消息表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `sendtime` (`sendtime`)</td> 
  </tr> 
 </tbody> 
</table>

47、dede\_member\_snsmsg：用户短信息表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_snsmsg(ENGINE=MyISAM/CHARSET=latin1) 说明：用户短信息表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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>userid</td> 
   <td>会员用户名</td> 
   <td>varchar(20) NOT NULL</td> 
  </tr> 
  <tr> 
   <td>sendtime</td> 
   <td>发送时间</td> 
   <td>int(10) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>msg</td> 
   <td>信息内容</td> 
   <td>varchar(250) NOT NULL</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

48、dede\_member\_space：用户空间表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_space(ENGINE=MyISAM/CHARSET=gbk) 说明：用户空间表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>会员ID</td> 
   <td>mediumint(8) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>pagesize</td> 
   <td>每页文档数</td> 
   <td>smallint(5) unsigned NOT NULL default '10'</td> 
  </tr> 
  <tr> 
   <td>matt</td> 
   <td>会员属性</td> 
   <td>smallint(6) NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>spacename</td> 
   <td>空间名</td> 
   <td>varchar(50) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>spacelogo</td> 
   <td>空间logo</td> 
   <td>varchar(50) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>spacestyle</td> 
   <td>空间风格</td> 
   <td>varchar(20) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>sign</td> 
   <td>签名</td> 
   <td>varchar(100) NOT NULL default '没签名'</td> 
  </tr> 
  <tr> 
   <td>spacenews</td> 
   <td>空间动态</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

49、dede\_member\_stow：用户收藏表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_stow(ENGINE=MyISAM/CHARSET=gbk) 说明：用户收藏表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `uid` (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

50、dede\_member\_stowtype：用户收藏类型表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_stowtype(ENGINE=MyISAM/CHARSET=gbk) 说明：用户收藏类型表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`stowname`)</td> 
  </tr> 
 </tbody> 
</table>

51、dede\_member\_tj：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_tj(ENGINE=MyISAM/CHARSET=gbk) 说明：Top <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

52、dede\_member\_type：会员类型表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_type(ENGINE=MyISAM/CHARSET=gbk) 说明：会员类型表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`)</td> 
  </tr> 
 </tbody> 
</table>

53、dede\_member\_vhistory：会员历史访问表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_member_vhistory(ENGINE=MyISAM/CHARSET=gbk) 说明：会员历史访问表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `vtime` (`vtime`),<br> KEY `mid` (`mid`,`vid`)</td> 
  </tr> 
 </tbody> 
</table>

54、dede\_moneycard\_record：用户点卡表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_moneycard_record(ENGINE=MyISAM/CHARSET=gbk) 说明：用户点卡表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `ctid` (`ctid`),<br> KEY `cardid` (`cardid`),<br> KEY `uid` (`uid`)</td> 
  </tr> 
 </tbody> 
</table>

55、dede\_moneycard\_type：点卡类型表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_moneycard_type(ENGINE=MyISAM/CHARSET=gbk) 说明：点卡类型表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`tid`)</td> 
  </tr> 
 </tbody> 
</table>

56、dede\_mtypes：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_mtypes(ENGINE=MyISAM/CHARSET=gbk) 说明：Top <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mtypeid`)</td> 
  </tr> 
 </tbody> 
</table>

57、dede\_multiserv\_config：远程配置表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_multiserv_config(ENGINE=MyISAM/CHARSET=gbk) 说明：远程配置表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`remoteuploads`)</td> 
  </tr> 
 </tbody> 
</table>

58、dede\_myad：我的广告表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_myad(ENGINE=MyISAM/CHARSET=gbk) 说明：我的广告表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`)</td> 
  </tr> 
 </tbody> 
</table>

59、dede\_myadtype：我的广告类型表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_myad(ENGINE=MyISAM/CHARSET=gbk) 说明：我的广告类型表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),</td> 
  </tr> 
 </tbody> 
</table>

60、dede\_mytag：我的标签表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_mytag(ENGINE=MyISAM/CHARSET=gbk) 说明：我的标签表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `tagname` (`tagname`,`typeid`,`timeset`,`endtime`,`starttime`)</td> 
  </tr> 
 </tbody> 
</table>

61、dede\_payment：支付表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_payment(ENGINE=MyISAM/CHARSET=gbk) 说明：支付表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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>&nbsp;</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>&nbsp;</td> 
   <td>tinyint(3) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>config</td> 
   <td>&nbsp;</td> 
   <td>text NOT NULL</td> 
  </tr> 
  <tr> 
   <td>enabled</td> 
   <td>&nbsp;</td> 
   <td>tinyint(1) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>cod</td> 
   <td>&nbsp;</td> 
   <td>tinyint(1) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>online</td> 
   <td>&nbsp;</td> 
   <td>tinyint(1) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> UNIQUE KEY `code` (`code`)</td> 
  </tr> 
 </tbody> 
</table>

62、dede\_plus：插件表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_plus(ENGINE=MyISAM/CHARSET=gbk) 说明：插件表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`)</td> 
  </tr> 
 </tbody> 
</table>

63、dede\_purview：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_purview(ENGINE=MyISAM/CHARSET=gbk) 说明：插件表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <tr> 
   <td>mid</td> 
   <td>&nbsp;</td> 
   <td>mediumint(8) unsigned NOT NULL auto_increment</td> 
  </tr> 
  <tr> 
   <td>typeid</td> 
   <td>&nbsp;</td> 
   <td>smallint(5) NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>rank</td> 
   <td>&nbsp;</td> 
   <td>smallint(6) NOT NULL default NULL</td> 
  </tr> 
  <tr> 
   <td>pkey</td> 
   <td>&nbsp;</td> 
   <td>varchar(30) NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td>pvalue</td> 
   <td>&nbsp;</td> 
   <td>text</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

64、dede\_pwd\_tmp：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_pwd_tmp(ENGINE=MyISAM/CHARSET=gbk) 说明：Top <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`mid`)</td> 
  </tr> 
 </tbody> 
</table>

65、dede\_ratings：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_ratings(ENGINE=MyISAM/CHARSET=gbk) 说明：Top <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

66、dede\_scores：级别表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_scores(ENGINE=MyISAM/CHARSET=gbk) 说明：级别表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`),<br> KEY `integral` (`integral`)</td> 
  </tr> 
 </tbody> 
</table>

67、dede\_search\_cache：搜索缓存表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_search_cache(ENGINE=MyISAM/CHARSET=gbk) 说明：搜索缓存表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`hash`)</td> 
  </tr> 
 </tbody> 
</table>

68、dede\_search\_keywords：搜索关键词表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_search_keywords(ENGINE=MyISAM/CHARSET=gbk) 说明：搜索关键词表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`)</td> 
  </tr> 
 </tbody> 
</table>

69、dede\_sgpage：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_sgpage(ENGINE=MyISAM/CHARSET=gbk) 说明：Top <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `ismake` (`ismake`,`uptime`),<br> KEY `likeid` (`likeid`)</td> 
  </tr> 
 </tbody> 
</table>

70、dede\_shops\_delivery：商品配送表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_shops_delivery(ENGINE=MyISAM/CHARSET=gbk) 说明：商品配送表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`pid`),<br> KEY `orders` (`orders`)</td> 
  </tr> 
 </tbody> 
</table>

71、dede\_shops\_orders：商品订单表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_shops_orders(ENGINE=MyISAM/CHARSET=gbk) 说明：商品订单表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> KEY `stime` (`stime`),<br> KEY `userid` (`userid`),<br> KEY `oid` (`oid`)</td> 
  </tr> 
 </tbody> 
</table>

72、dede\_shops\_products：商品产品表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_shops_products(ENGINE=MyISAM/CHARSET=gbk) 说明：商品产品表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> KEY `oid` (`oid`),<br> KEY `userid` (`userid`)</td> 
  </tr> 
 </tbody> 
</table>

73、dede\_shops\_userinfo：商品用户信息表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_shops_userinfo(ENGINE=MyISAM/CHARSET=gbk) 说明：商品用户信息表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> KEY `oid` (`oid`),<br> KEY `userid` (`userid`)</td> 
  </tr> 
 </tbody> 
</table>

74、dede\_softconfig：软件配置表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_softconfig(ENGINE=MyISAM/CHARSET=gbk) 说明：软件配置表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`downtype`)</td> 
  </tr> 
 </tbody> 
</table>

75、dede\_sphinx：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_sphinx(ENGINE=MyISAM/CHARSET=gbk) 说明： <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <tr> 
   <td>countid</td> 
   <td>&nbsp;</td> 
   <td>Int(11) unsigned NOT NULL default '0'</td> 
  </tr> 
  <tr> 
   <td>maxaid</td> 
   <td>&nbsp;</td> 
   <td>Int(11) unsigned NOT NULL default ''</td> 
  </tr> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`countid&nbsp;`)</td> 
  </tr> 
 </tbody> 
</table>

76、dede\_stepselect：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_stepselect(ENGINE=MyISAM/CHARSET=gbk) 说明： <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id&nbsp;`)</td> 
  </tr> 
 </tbody> 
</table>

77、dede\_sysconfig：系统配置表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_sysconfig(ENGINE=MyISAM/CHARSET=gbk) 说明：系统配置表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`varname`)</td> 
  </tr> 
 </tbody> 
</table>

78、dede\_sys\_enum：

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_sys_enum(ENGINE=MyISAM/CHARSET=gbk) 说明：Top <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

79、dede\_sys\_module：系统模块表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_sys_module(ENGINE=MyISAM/CHARSET=gbk) 说明：系统模块表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

80、dede\_sys\_set：系统设置表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_sys_set(ENGINE=MyISAM/CHARSET=gbk) 说明：系统设置表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

81、dede\_sys\_task：计划任务表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_sys_task(ENGINE=MyISAM/CHARSET=gbk) 说明：计划任务表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

82、dede\_tagindex：标签索引表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_tagindex(ENGINE=MyISAM/CHARSET=gbk) 说明：标签索引表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`id`)</td> 
  </tr> 
 </tbody> 
</table>

83、dede\_taglist：文章标签表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_taglist(ENGINE=MyISAM/CHARSET=gbk) 说明：文章标签表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`tid`,`aid`)</td> 
  </tr> 
 </tbody> 
</table>

84、dede\_uploads：附件上传表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_uploads(ENGINE=MyISAM/CHARSET=gbk) 说明：附件上传表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`),<br> KEY `memberid` (`mid`),<br> KEY `arcid` (`arcid`)</td> 
  </tr> 
 </tbody> 
</table>

85、dede\_verifies：安全检验表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_verifies(ENGINE=MyISAM/CHARSET=gbk) 说明：安全检验表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`nameid`)</td> 
  </tr> 
 </tbody> 
</table>

86、dede\_vote：投票表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_vote(ENGINE=MyISAM/CHARSET=gbk) 说明：投票表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`)</td> 
  </tr> 
 </tbody> 
</table>

87、dede\_vote\_member：用户投票表

<table> 
 <tbody> 
  <tr> 
   <td colspan="3">表名：dede_vote(ENGINE=MyISAM/CHARSET=gbk) 说明：用户投票表 <p>&nbsp;</p> </td> 
  </tr> 
  <tr> 
   <td>字段名</td> 
   <td>说明描述</td> 
   <td>具体参数</td> 
  </tr> 
  <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> 
  <tr> 
   <td colspan="3">索引：<br> PRIMARY KEY (`aid`)</td> 
  </tr> 
 </tbody> 
</table>