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 ++-- sql/mysql/schema.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) 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); 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