CREATE TABLE `filter` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `nid` int(10) NOT NULL default '0',
  `pid` int(10) unsigned default NULL,
  `type` int(4) NOT NULL default '0',
  `state` int(1) NOT NULL default '0',
  `source` varchar(10) NOT NULL default '',
  `hostname` varchar(20) NOT NULL default '',
  `changed` timestamp(14) NOT NULL,
  `created` timestamp(14) NOT NULL default '00000000000000',
  `uid` int(10) default NULL,
  `username` varchar(13) NOT NULL default '',
  `comment` int(4) NOT NULL default '0',
  `commentcount` int(10) NOT NULL default '0',
  `subject` varchar(200) NOT NULL default 'null',
  `body` text,
  `access` int(4) NOT NULL default '0',
  `visitcount` int(4) NOT NULL default '0',
  `tid` int(10) NOT NULL default '0',
  `emote` int(2) NOT NULL default '0',
  `htmltag` int(1) NOT NULL default '0',
  `trackback` int(1) NOT NULL default '1',
  `trackbackcount` int(10) NOT NULL default '0',
  `recommend` int(1) NOT NULL default '0',
  `updatetime` timestamp(14) NOT NULL default '00000000000000',
  `nodetype` int(1) NOT NULL default '0',
  `recuser` varchar(12) NOT NULL default '',
  `tbp_url` varchar(255) NOT NULL default '',
  `tbp_art` varchar(255) NOT NULL default '',
  `auto_tbp` int(1) NOT NULL default '0',
  `tbpencoding` varchar(20) NOT NULL default '',
  `theme` varchar(20) NOT NULL default '',
  `publisher` varchar(14) NOT NULL default '',
  PRIMARY KEY  (`fid`),
  KEY `pid` (`pid`),
  KEY `created` (`changed`),
  KEY `changed` (`created`),
  KEY `state` (`state`),
  FULLTEXT KEY `body` (`body`),
  FULLTEXT KEY `publisher` (`publisher`)
) TYPE=MyISAM COMMENT='过滤器';

alter table nodes
  add `recuser` varchar(12) NOT NULL default '',
  add `rectopic` varchar(20) NOT NULL default '0',
  add `theme` varchar(20) NOT NULL default 'others',
  add `publisher` varchar(14) NOT NULL default '',
  add KEY `nodetype` (`nodetype`),
  add KEY `rectopic` (`rectopic`),
  add KEY `commentcount` (`commentcount`),
  add KEY `theme` (`theme`),
  add FULLTEXT KEY `publisher` (`publisher`);

alter table recommend
  add `topic` varchar(20) NOT NULL default '0',
  add KEY `topic` (`topic`);

CREATE TABLE `userfiles` (
  `fid` int(10) unsigned NOT NULL auto_increment,
  `uid` int(10) unsigned NOT NULL default '0',
  `pid` int(10) unsigned NOT NULL default '0',
  `type` int(1) unsigned NOT NULL default '0',
  `filename` varchar(200) NOT NULL default '',
  `filepath` varchar(255) NOT NULL default '',
  `hostname` varchar(15) NOT NULL default '',
  `filetime` timestamp(14) NOT NULL,
  `filesize` int(10) unsigned NOT NULL default '0',
  `filetype` varchar(50) NOT NULL default '',
  `access` int(1) unsigned NOT NULL default '0',
  `remark` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`fid`),
  KEY `uid` (`uid`),
  KEY `pid` (`pid`),
  KEY `type` (`type`),
  KEY `access` (`access`)
) TYPE=MyISAM COMMENT='用户文件夹';

alter table users
  modify `username` varchar(30) NOT NULL default '',
  modify `theme` varchar(10) default NULL,
  modify `indexnodechars` int(4) NOT NULL default '600',
  modify `indexnodes` int(3) NOT NULL default '5',
  add `userfile` int(4) NOT NULL default '0',
  add `filelimit` int(10) NOT NULL default '0',
  add KEY `pctype` (`pctype`),
  add FULLTEXT KEY `corpusname_2` (`corpusname`,`description`);
--
FROM 211.93.167.*