X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/83182bda24af3b7e755eb0dd2c877ec17e1ab411..39649e5b8ecb59ca9fb37cd0c614372481b25f4a:/forum_modules/mysqlfulltext/fts_install.sql

diff --git a/forum_modules/mysqlfulltext/fts_install.sql b/forum_modules/mysqlfulltext/fts_install.sql
index ae67cc0..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;
@@ -31,10 +34,4 @@ 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;
-|
-
-delimiter |
 
-ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(body);
-ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(title);
-ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(tagnames);
