diff options
author | Andrew Dolgov <[email protected]> | 2022-06-20 21:49:12 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2022-06-20 21:49:12 +0300 |
commit | b148d2f5153f9711120b3a3ac50ee84509c9cdfb (patch) | |
tree | dd231a7fc4843da880d52aeeae9c95f05d21cb42 /sql/mysql/migrations | |
parent | 0bb72fbb266c8cd5c6ae570c1a2cdb7f8fb79c68 (diff) |
schema: don't use 'create index if not exists' syntax because mysql doesn't support it
Diffstat (limited to 'sql/mysql/migrations')
-rw-r--r-- | sql/mysql/migrations/147.sql | 4 |
1 files changed, 2 insertions, 2 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); |