summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2021-11-15 16:57:25 +0100
committerYorhel <git@yorhel.nl>2021-11-15 16:57:25 +0100
commite4d3f0b8da83a393ab8f975d7025c18cbcff4957 (patch)
tree67e1291d05b894c85c4cfdcabb4461a461620e99 /util
parenta57a5f30c131219f98f4b0ba4ba88d77bdcecc1b (diff)
Discussions::Search: Add reviews & review comment search
Diffstat (limited to 'util')
-rw-r--r--util/updates/2021-11-15-reviews-fulltext-search.sql2
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));