X-Git-Url: https://git.openstreetmap.org./osqa.git/blobdiff_plain/55eea8d5a3f8fcc3a509f2eaf45005bba20fc76a..7be81dfc799101c3d7e646d76b07ac30fc39bf61:/forum_modules/mysqlfulltext/fts_update.sql?ds=sidebyside 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