CREATE TABLE `searchcore` (
  `searchcoreid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `contenttypeid` int(10) unsigned NOT NULL,
  `primaryid` int(10) unsigned NOT NULL,
  `groupcontenttypeid` int(10) unsigned NOT NULL,
  `groupid` int(10) unsigned NOT NULL DEFAULT '0',
  `dateline` int(10) unsigned NOT NULL DEFAULT '0',
  `userid` int(10) unsigned NOT NULL DEFAULT '0',
  `username` varchar(100) NOT NULL,
  `ipaddress` int(10) unsigned NOT NULL,
  `searchgroupid` int(10) unsigned NOT NULL,
  PRIMARY KEY (`searchcoreid`),
  UNIQUE KEY `contentunique` (`contenttypeid`,`primaryid`),
  KEY `groupid` (`groupcontenttypeid`,`groupid`),
  KEY `ipaddress` (`ipaddress`),
  KEY `dateline` (`dateline`),
  KEY `userid` (`userid`),
  KEY `searchgroupid` (`searchgroupid`)
) ENGINE=InnoDB AUTO_INCREMENT=4194434 DEFAULT CHARSET=utf8


CREATE TABLE `searchcore_text` (
  `searchcoreid` int(10) unsigned NOT NULL,
  `keywordtext` mediumtext,
  `title` varchar(254) NOT NULL DEFAULT '',
  PRIMARY KEY (`searchcoreid`),
  FULLTEXT KEY `text` (`title`,`keywordtext`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

CREATE TABLE `thread` (
  `threadid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(250) NOT NULL DEFAULT '',
  `firstpostid` int(10) unsigned NOT NULL DEFAULT '0',
  `lastpost` int(10) unsigned NOT NULL DEFAULT '0',
  `forumid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `pollid` int(10) unsigned NOT NULL DEFAULT '0',
  `open` smallint(6) NOT NULL DEFAULT '0',
  `replycount` int(10) unsigned NOT NULL DEFAULT '0',
  `postusername` varchar(100) NOT NULL DEFAULT '',
  `postuserid` int(10) unsigned NOT NULL DEFAULT '0',
  `lastposter` varchar(100) NOT NULL DEFAULT '',
  `dateline` int(10) unsigned NOT NULL DEFAULT '0',
  `views` int(10) unsigned NOT NULL DEFAULT '0',
  `iconid` smallint(5) unsigned NOT NULL DEFAULT '0',
  `notes` varchar(250) NOT NULL DEFAULT '',
  `visible` smallint(6) NOT NULL DEFAULT '0',
  `sticky` smallint(6) NOT NULL DEFAULT '0',
  `votenum` smallint(5) unsigned NOT NULL DEFAULT '0',
  `votetotal` smallint(5) unsigned NOT NULL DEFAULT '0',
  `attach` smallint(5) unsigned NOT NULL DEFAULT '0',
  `similar` varchar(55) NOT NULL DEFAULT '',
  `importthreadid` bigint(20) NOT NULL DEFAULT '0',
  `importforumid` bigint(20) NOT NULL DEFAULT '0',
  `hiddencount` int(10) unsigned NOT NULL DEFAULT '0',
  `deletedcount` smallint(5) unsigned NOT NULL DEFAULT '0',
  `lastpostid` int(10) unsigned NOT NULL DEFAULT '0',
  `threadweight` int(10) NOT NULL DEFAULT '0',
  `prefixid` varchar(25) NOT NULL DEFAULT '',
  `taglist` longtext,
  `isurlredirect` varchar(250) NOT NULL DEFAULT '',
  `wrdate` mediumtext NOT NULL,
  `lastposterid` int(10) unsigned NOT NULL DEFAULT '0',
  `keywords` longtext,
  `firstpoststicked` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`threadid`),
  KEY `postuserid` (`postuserid`),
  KEY `pollid` (`pollid`),
  KEY `forumid` (`forumid`,`visible`,`sticky`,`lastpost`),
  KEY `dateline` (`dateline`),
  KEY `views` (`views`),
  KEY `prefixid` (`prefixid`,`forumid`),
  KEY `lastpost` (`lastpost`),
  KEY `forumid_lastpost` (`forumid`,`lastpost`)
) ENGINE=InnoDB AUTO_INCREMENT=374316 DEFAULT CHARSET=utf8




show table status like 'searchcore%' \G
*************************** 1. row ***************************
           Name: searchcore
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 3612103
 Avg_row_length: 69
    Data_length: 252428288
Max_data_length: 0
   Index_length: 631259136
      Data_free: 7340032
 Auto_increment: 4198996
    Create_time: 2010-07-03 05:53:18
    Update_time: NULL
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options: 
        Comment: 
*************************** 2. row ***************************
           Name: searchcore_text
         Engine: MyISAM
        Version: 10
     Row_format: Dynamic
           Rows: 3609832
 Avg_row_length: 709
    Data_length: 2560618640
Max_data_length: 281474976710655
   Index_length: 1666941952
      Data_free: 0
 Auto_increment: NULL
    Create_time: 2010-06-18 14:56:44
    Update_time: 2010-07-06 16:29:32
     Check_time: 2010-07-03 06:30:12
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options: 
        Comment: 
2 rows in set (0.47 sec)

show table status like 'thread' \G
*************************** 1. row ***************************
           Name: thread
         Engine: InnoDB
        Version: 10
     Row_format: Compact
           Rows: 151139
 Avg_row_length: 448
    Data_length: 67715072
Max_data_length: 0
   Index_length: 37830656
      Data_free: 7340032
 Auto_increment: 374317
    Create_time: 2010-07-05 12:27:01
    Update_time: NULL
     Check_time: NULL
      Collation: utf8_general_ci
       Checksum: NULL
 Create_options: 
        Comment: 
1 row in set (1.64 sec)