The following SQL statement produces the error “The used table type
doesn’t support FULLTEXT indexes” when executed in MySQL 5.0 query
browser. The default table type was InnoDB which doesn’t support
FULLTEXT indexes. The FULLTEXT indexes is supported by MyISAM (old
ISAM) table type.DROP TABLE IF EXISTS `asb_articles`;
CREATE TABLE `asb_articles` (
`id` int(255) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`title` longtext NOT NULL,
`author` varchar(200) NOT NULL default '',
`article` longtext NOT NULL,
`resource_box` longtext NOT NULL,
`category` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
FULLTEXT KEY `article` (`article`)
) AUTO_INCREMENT=1;
So when ENGINE for the table is specified as below it was allright. The statement ENGINE=MYISAM is the storage engine for the table here. The older term TYPE is supported (TYPE=ISAM) as a synonym for ENGINE for backward compatibility, but ENGINE is the preferred term and TYPE is deprecated.
DROP TABLE IF EXISTS `asb_articles`;
CREATE TABLE `asb_articles` (
`id` int(255) NOT NULL auto_increment,
`url` varchar(255) NOT NULL default '',
`title` longtext NOT NULL,
`author` varchar(200) NOT NULL default '',
`article` longtext NOT NULL,
`resource_box` longtext NOT NULL,
`category` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
FULLTEXT KEY `article` (`article`)
) AUTO_INCREMENT=1 ENGINE = MYISAM;
For detail please see: http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html