CREATE TABLE `isc_category_search` (
  `categorysearchid` int(11) auto_increment,
  `categoryid` int(11) DEFAULT '0',
  `catname` varchar(250) DEFAULT '',
  `catdesc` text,
  `catsearchkeywords` varchar(255) DEFAULT '',
  PRIMARY KEY (`categorysearchid`),
  KEY `i_category_search_categoryid` (`categoryid`),
  KEY `catname` (`catname`,`catdesc`,`catsearchkeywords`(767)),
  KEY `catname2` (`catname`)
)/*! engine=MyISAM */