CREATE TABLE IF NOT EXISTS ubbt_SEARCH_RESULTS (
SEARCH_SESSION_ID varchar(32) NOT NULL DEFAULT '',
SEARCH_WORDS varchar(255) DEFAULT NULL,
SEARCH_EXCLUDED_WORDS varchar(255) DEFAULT NULL,
SEARCH_RESULTS mediumtext,
SEARCH_TIMESTAMP int(11) DEFAULT NULL,
SEARCH_PREVIEW_BODY tinyint(1) DEFAULT NULL,
SEARCH_SQL_LIMIT tinyint(2) DEFAULT NULL,
PRIMARY KEY (SEARCH_SESSION_ID),
KEY time_index (SEARCH_TIMESTAMP)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;