Peter M. Groen / knowledgetree

searchable_text.sql 462 Bytes
1 2 3 4 5 6 7 8 9 10 11 12 13 
CREATE TABLE `document_searchable_text` (
  `document_id` int(11) default NULL,
  `document_text` mediumtext,
  KEY `document_text_document_id_indx` (`document_id`),
  FULLTEXT KEY `document_text` (`document_text`)
) TYPE=MyISAM;

CREATE TABLE `document_transaction_text` (
  `document_id` int(11) default NULL,
  `document_text` mediumtext,
  KEY `document_text_document_id_indx` (`document_id`),
  FULLTEXT KEY `document_text` (`document_text`)
) TYPE=MyISAM;