You are reading a single comment by @Velocio and its replies.
Click here to read the full conversation.
-
Triggers... because this is data integrity :)
Though that file is for adding forum hierarchies, the commit you want for most of the full text is this one:
https://github.com/microcosm-cc/microcosm/blob/bbdaa6eacbedd830a52b34e97844fd2e88a06e8c/db/migrations/20160224223626_fulltext_search.sqlNote that the weighting varies according to the source table, which is how the profiles and forums get listed higher for exact matches when threads may also match, and also how threads beat comments for exact matches.
Velocio
Guess i know the answer: https://github.com/microcosm-cc/microcosm/blob/bbdaa6eacbedd830a52b34e97844fd2e88a06e8c/db/migrations/20151004160923_parent_microcosms.sql#L158