[Dave]

So you only need the "searchcore" table and not "searchcore_text"?
This should work:

CREATE TABLE searchcore (
	searchcoreid INT UNSIGNED NOT NULL AUTO_INCREMENT,
	contenttypeid INT UNSIGNED NOT NULL,
	primaryid INT UNSIGNED  NOT NULL,
	groupcontenttypeid INT UNSIGNED NOT NULL,
	groupid INT UNSIGNED NOT NULL DEFAULT 0,
	dateline INT UNSIGNED NOT NULL DEFAULT 0,
	userid INT UNSIGNED NOT NULL DEFAULT 0,
	username VARCHAR(100) NOT NULL,
	ipaddress INT UNSIGNED NOT NULL,
	searchgroupid INT 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=MyISAM