Updated stats 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..eae65e6528e67b4027eb23ac539c81b64feebe46 100644 (file)
--- 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,
        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;
 ) 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;
+