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

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

diff --git a/forum_modules/mysqlfulltext/fts_install.sql b/forum_modules/mysqlfulltext/fts_install.sql
index c32bc311b91a6f137ae942fde0089cfb451bf7e0..ae67cc0839e5b3629987e6fcdb14fde0dfa95bfd 100644 (file)
--- a/forum_modules/mysqlfulltext/fts_install.sql
+++ b/forum_modules/mysqlfulltext/fts_install.sql
@@ -30,4 +30,11 @@ 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;
+|
+
+delimiter |
+
+ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(body);
+ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(title);
+ALTER TABLE forum_mysqlftsindex ADD FULLTEXT(tagnames);