diff options
author | Yorhel <git@yorhel.nl> | 2021-11-15 16:57:25 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2021-11-15 16:57:25 +0100 |
commit | e4d3f0b8da83a393ab8f975d7025c18cbcff4957 (patch) | |
tree | 67e1291d05b894c85c4cfdcabb4461a461620e99 /util | |
parent | a57a5f30c131219f98f4b0ba4ba88d77bdcecc1b (diff) |
Discussions::Search: Add reviews & review comment search
Diffstat (limited to 'util')
-rw-r--r-- | util/updates/2021-11-15-reviews-fulltext-search.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/util/updates/2021-11-15-reviews-fulltext-search.sql b/util/updates/2021-11-15-reviews-fulltext-search.sql new file mode 100644 index 00000000..c6f60211 --- /dev/null +++ b/util/updates/2021-11-15-reviews-fulltext-search.sql @@ -0,0 +1,2 @@ +CREATE INDEX reviews_ts ON reviews USING gin(bb_tsvector(text)); +CREATE INDEX reviews_posts_ts ON reviews_posts USING gin(bb_tsvector(msg)); |