From b148d2f5153f9711120b3a3ac50ee84509c9cdfb Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 20 Jun 2022 21:49:12 +0300 Subject: schema: don't use 'create index if not exists' syntax because mysql doesn't support it --- sql/mysql/migrations/147.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'sql/mysql/migrations/147.sql') diff --git a/sql/mysql/migrations/147.sql b/sql/mysql/migrations/147.sql index 6bd4b59c9..93b754f6b 100644 --- a/sql/mysql/migrations/147.sql +++ b/sql/mysql/migrations/147.sql @@ -1,2 +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); +create fulltext index ttrss_entries_title_search_idx on ttrss_entries(title); +create fulltext index ttrss_entries_combined_search_idx on ttrss_entries(title, content); -- cgit v1.2.3