| phpbb_search_wordmatch | CREATE TABLE `phpbb_search_wordmatch` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `post_id` (`post_id`),
  KEY `word_id` (`word_id`),
  KEY `post_id_2` (`post_id`),
  KEY `word_id_2` (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |