typo3/sysext/indexed_search_mysql/ext_tables.sql

   1 #
   2 # Table structure for table 'index_fulltext'
   3 #
   4 # Differences compared to original definition in EXT:indexed_search are as follows:
   5 # - Add new mediumtext field "metaphonedata"
   6 # - Add new FULLTEXT index "fulltextdata"
   7 # - Add new FULLTEXT index "metaphonedata"
   8 # - Change table engine from InnoDB to MyISAM (required for FULLTEXT indexing)
   9 CREATE TABLE index_fulltext (
  10   phash int(11) DEFAULT '0' NOT NULL,
  11   fulltextdata mediumtext,
  12   metaphonedata mediumtext,
  13   PRIMARY KEY (phash)
  14   FULLTEXT fulltextdata (fulltextdata)
  15   FULLTEXT metaphonedata (metaphonedata)
  16 ) ENGINE=MyISAM;