diff options
| author | Andrew Dolgov <[email protected]> | 2012-07-10 23:49:05 +0400 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2012-07-10 23:49:05 +0400 |
| commit | 8514e925abc8e170b9069e5b2a504519489e8002 (patch) | |
| tree | 88de40a5d5d28863476c4e31db478d17664dc024 /schema | |
| parent | 545ca067895c841e265d1bc79484235b6cf900b3 (diff) | |
mysql schema: add few missing indexes
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/ttrss_schema_mysql.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql index 54f53e85f..378378ed9 100644 --- a/schema/ttrss_schema_mysql.sql +++ b/schema/ttrss_schema_mysql.sql @@ -175,6 +175,9 @@ create table ttrss_user_entries ( index (owner_uid), foreign key (owner_uid) references ttrss_users(id) ON DELETE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=UTF8; +create index ttrss_user_entries_owner_uid_index on ttrss_user_entries(owner_uid); +create index ttrss_user_entries_ref_id_index on ttrss_user_entries(ref_id); +create index ttrss_user_entries_feed_id on ttrss_user_entries(feed_id); create index ttrss_user_entries_unread_idx on ttrss_user_entries(unread); create table ttrss_entry_comments (id integer not null primary key, |