add the fts indexes during the table creation

git-svn-id: http://svn.osqa.net/svnroot/osqa/trunk@1056 0cfe37f9-358a-4d5e-be75-b63607b5c754

diff --git a/forum_modules/mysqlfulltext/fts_install.sql b/forum_modules/mysqlfulltext/fts_install.sql
index ae67cc0839e5b3629987e6fcdb14fde0dfa95bfd..e444158e69aaac7c3108d05af163c08defa6db71 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,
-       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;
@@ -32,9 +35,3 @@ 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);

diff --git a/forum_modules/mysqlfulltext/startup.py b/forum_modules/mysqlfulltext/startup.py
index 387019adb03dd66202ca651d1ffcb2e4e7dc80c6..e5d4849ed4469e4eeae2b518baa66aaf7784dc10 100644 (file)
--- a/forum_modules/mysqlfulltext/startup.py
+++ b/forum_modules/mysqlfulltext/startup.py
@@ -8,7 +8,7 @@ from forum.models.question import Question, QuestionManager
 from forum.models.node import Node
 from forum.modules import decorate
 
-VERSION = 3
+VERSION = 4
 
 f_name = None