YourWBB

DROP TABLE IF EXISTS bb1_wordmatch;
CREATE TABLE bb1_wordmatch (
  wordid int(11) unsigned NOT NULL default '0',
  postid int(11) unsigned NOT NULL default '0',
  intopic tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (wordid,postid)
) TYPE=MyISAM;

DROP TABLE IF EXISTS bb1_wordlist;
CREATE TABLE bb1_wordlist (
  wordid int(11) unsigned NOT NULL auto_increment,
  word varchar(50) NOT NULL default '',
  PRIMARY KEY  (wordid),
  UNIQUE KEY word (word)
) TYPE=MyISAM;