summaryrefslogtreecommitdiff
path: root/sql/mysql/schema.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2022-06-20 21:49:12 +0300
committerAndrew Dolgov <[email protected]>2022-06-20 21:49:12 +0300
commitb148d2f5153f9711120b3a3ac50ee84509c9cdfb (patch)
treedd231a7fc4843da880d52aeeae9c95f05d21cb42 /sql/mysql/schema.sql
parent0bb72fbb266c8cd5c6ae570c1a2cdb7f8fb79c68 (diff)
schema: don't use 'create index if not exists' syntax because mysql doesn't support it
Diffstat (limited to 'sql/mysql/schema.sql')
-rw-r--r--sql/mysql/schema.sql4
1 files changed, 2 insertions, 2 deletions
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,