X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/55eea8d5a3f8fcc3a509f2eaf45005bba20fc76a..6ebde88b50458c1ba0d81d42ab3bc59e131537b1:/forum_modules/mysqlfulltext/fts_update.sql diff --git a/forum_modules/mysqlfulltext/fts_update.sql b/forum_modules/mysqlfulltext/fts_update.sql index a95c827..2582554 100644 --- 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