From 6d98cc6c800ad2c2190c0ca8136db0aa814c634d Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
Date: Sun, 19 Jun 2022 21:53:57 +0300
Subject: schema: add fulltext indexes for mysql to support af_psql_trgm and
 possibly future fulltext search

---
 sql/mysql/migrations/147.sql | 2 ++
 1 file changed, 2 insertions(+)
 create mode 100644 sql/mysql/migrations/147.sql

(limited to 'sql/mysql/migrations')

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);
-- 
cgit v1.2.3