From 46a9e3561c9bf3641e9a2d2f4453f54da0abf310 Mon Sep 17 00:00:00 2001 From: jordan Date: Wed, 1 Jun 2011 11:53:18 +0000 Subject: [PATCH] add the fts indexes during the table creation git-svn-id: http://svn.osqa.net/svnroot/osqa/trunk@1056 0cfe37f9-358a-4d5e-be75-b63607b5c754 --- forum_modules/mysqlfulltext/fts_install.sql | 11 ++++------- forum_modules/mysqlfulltext/startup.py | 2 +- 2 files changed, 5 insertions(+), 8 deletions(-) diff --git a/forum_modules/mysqlfulltext/fts_install.sql b/forum_modules/mysqlfulltext/fts_install.sql index ae67cc0..e444158 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; @@ -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 387019a..e5d4849 100644 --- 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 -- 2.45.1