searchindex表的创建SQL 7.0 gbk
- CREATE TABLE IF NOT EXISTS `cdb_searchindex` (
- `searchid` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `keywords` varchar(255) NOT NULL DEFAULT '',
- `searchstring` text NOT NULL,
- `useip` varchar(15) NOT NULL DEFAULT '',
- `uid` mediumint(10) unsigned NOT NULL DEFAULT '0',
- `dateline` int(10) unsigned NOT NULL DEFAULT '0',
- `expiration` int(10) unsigned NOT NULL DEFAULT '0',
- `threads` smallint(6) unsigned NOT NULL DEFAULT '0',
- `threadtypeid` smallint(6) unsigned NOT NULL DEFAULT '0',
- `tids` text NOT NULL,
- PRIMARY KEY (`searchid`)
- ) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=1 ;
复制代码 默认没有cdb_pushedthreads 这个表 |