 CREATE TABLE FullTextIndex (
  node_id bigint(20) unsigned NOT NULL DEFAULT "0",
  word varchar(255) NOT NULL DEFAULT "",
  count int(11) DEFAULT "1",
  node bigint(20) unsigned DEFAULT NULL,
  PRIMARY KEY (node_id,word),
  KEY word (word,node_id),
  KEY node_id (node_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT="Custom full text index optimized for word searches"
