diff options
author | Andrew Dolgov <[email protected]> | 2022-06-19 21:53:57 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2022-06-19 21:53:57 +0300 |
commit | 6d98cc6c800ad2c2190c0ca8136db0aa814c634d (patch) | |
tree | 7af86fabd901324828d12d511c87ec2a11c6f29f /sql/mysql/migrations | |
parent | 9428e2c571a38aed36537d072858d245907341e7 (diff) |
schema: add fulltext indexes for mysql to support af_psql_trgm and possibly future fulltext search
Diffstat (limited to 'sql/mysql/migrations')
-rw-r--r-- | sql/mysql/migrations/147.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/sql/mysql/migrations/147.sql b/sql/mysql/migrations/147.sql new file mode 100644 index 000000000..6bd4b59c9 --- /dev/null +++ b/sql/mysql/migrations/147.sql @@ -0,0 +1,2 @@ +create fulltext index if not exists ttrss_entries_title_search_idx on ttrss_entries(title); +create fulltext index if not exists ttrss_entries_combined_search_idx on ttrss_entries(title, content); |