X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/55eea8d5a3f8fcc3a509f2eaf45005bba20fc76a..b56393ea42b95c827c572b212406d83df1ec37b2:/forum_modules/mysqlfulltext/fts_install.sql?ds=sidebyside

diff --git a/forum_modules/mysqlfulltext/fts_install.sql b/forum_modules/mysqlfulltext/fts_install.sql
index c32bc31..eae65e6 100644
--- a/forum_modules/mysqlfulltext/fts_install.sql
+++ b/forum_modules/mysqlfulltext/fts_install.sql
@@ -6,7 +6,10 @@ CREATE TABLE forum_mysqlftsindex (
 	tagnames varchar(255),
 	PRIMARY KEY (id),
 	FOREIGN KEY (node_id) REFERENCES forum_node (id)   ON UPDATE CASCADE ON DELETE CASCADE,
-	FULLTEXT (body, title, tagnames)
+	FULLTEXT (body, title, tagnames),
+	FULLTEXT(body),
+	FULLTEXT(title),
+	FULLTEXT(tagnames)
 ) ENGINE=`MyISAM`;
 
 ALTER TABLE forum_mysqlftsindex CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
@@ -30,4 +33,5 @@ CREATE TRIGGER fts_on_update AFTER UPDATE ON forum_node
 
 |
 
-INSERT INTO forum_mysqlftsindex (node_id, title, body, tagnames) SELECT id, UPPER(title), UPPER(body), UPPER(tagnames) FROM forum_node;
\ No newline at end of file
+INSERT INTO forum_mysqlftsindex (node_id, title, body, tagnames) SELECT id, UPPER(title), UPPER(body), UPPER(tagnames) FROM forum_node;
+
