diff options
| author | Andrew Dolgov <[email protected]> | 2022-06-19 21:53:57 +0300 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2022-06-19 21:53:57 +0300 |
| commit | 6d98cc6c800ad2c2190c0ca8136db0aa814c634d (patch) | |
| tree | 7af86fabd901324828d12d511c87ec2a11c6f29f /sql/mysql/schema.sql | |
| parent | 9428e2c571a38aed36537d072858d245907341e7 (diff) | |
schema: add fulltext indexes for mysql to support af_psql_trgm and possibly future fulltext search
Diffstat (limited to 'sql/mysql/schema.sql')
| -rw-r--r-- | sql/mysql/schema.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql index 589d1013a..4f9203ed2 100644 --- a/sql/mysql/schema.sql +++ b/sql/mysql/schema.sql @@ -169,6 +169,9 @@ 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 table ttrss_user_entries ( int_id integer not null primary key auto_increment, ref_id integer not null, |