Architecture / Installation

Posted by claborne 10 Feb 2004 18:51 GMT-0000 posts: 26

The fix was to create a second full text index for just 'data'. The create table script below creates a full text index for data and title.

CREATE TABLE tiki_blog_posts (
postId int(8) NOT NULL auto_increment,
blogId int(8) NOT NULL default '0',
data text,
data_size int(11) unsigned NOT NULL default '0',
created int(14) default NULL,
user varchar(200) default NULL,
trackbacks_to text,
trackbacks_from text,
title varchar(80) default NULL,
PRIMARY KEY (postId),
KEY data 255,
KEY blogId (blogId),
KEY created (created),
FULLTEXT KEY ft (data,title)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

2
-- C --