From b148d2f5153f9711120b3a3ac50ee84509c9cdfb Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
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/schema.sql | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

(limited to 'sql/mysql/schema.sql')

diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql
index 4f9203ed2..ffabab669 100644
--- a/sql/mysql/schema.sql
+++ b/sql/mysql/schema.sql
@@ -169,8 +169,8 @@ create table ttrss_entries (id integer not null primary key auto_increment,
 create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
 create index ttrss_entries_updated_idx on ttrss_entries(updated);
 
-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);
 
 create table ttrss_user_entries (
 	int_id integer not null primary key auto_increment,
-- 
cgit v1.2.3

