adding an update that creates full text search indexes for the mysqlfulltext module

[osqa.git] / forum_modules / mysqlfulltext / fts_update.sql

diff --git a/forum_modules/mysqlfulltext/fts_update.sql b/forum_modules/mysqlfulltext/fts_update.sql
index a95c827b932c6113123ff16a98874680839e3175..2582554e68166028ef7243513889d410cb461999 100644 (file)
--- a/forum_modules/mysqlfulltext/fts_update.sql
+++ b/forum_modules/mysqlfulltext/fts_update.sql
@@ -24,3 +24,11 @@ CREATE TRIGGER fts_on_update AFTER UPDATE ON forum_node
   END;
 
 |
+
+delimiter |
+
+ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(body);
+ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(title);
+ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(tagnames);
+
+|
\ No newline at end of file