diff options
author | Andrew Dolgov <[email protected]> | 2014-12-18 11:55:36 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2014-12-18 11:55:36 +0300 |
commit | 06f328a31b599d08e13781d97726cc04c114b17c (patch) | |
tree | d1b4a30390f28a6f909af4a5b3eebe6feadfe1f9 /schema/versions/mysql/127.sql | |
parent | 945ecd7db66203ce117c1818b49e8204e92ceabe (diff) | |
parent | bd40827b737464ea2de8857fded057122543990a (diff) |
Merge pull request #427 from andersk/duplicate-indexes
Drop duplicate database indexes
Diffstat (limited to 'schema/versions/mysql/127.sql')
-rw-r--r-- | schema/versions/mysql/127.sql | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/schema/versions/mysql/127.sql b/schema/versions/mysql/127.sql new file mode 100644 index 000000000..5dcc23b2f --- /dev/null +++ b/schema/versions/mysql/127.sql @@ -0,0 +1,18 @@ +BEGIN; + +ALTER TABLE ttrss_enclosures DROP INDEX post_id; +ALTER TABLE ttrss_entries DROP INDEX ttrss_entries_guid_index; +ALTER TABLE ttrss_feeds DROP INDEX owner_uid; +ALTER TABLE ttrss_feeds DROP INDEX cat_id; +ALTER TABLE ttrss_prefs DROP INDEX ttrss_prefs_pref_name_idx; +ALTER TABLE ttrss_sessions DROP INDEX id_2; +ALTER TABLE ttrss_sessions DROP INDEX id; +ALTER TABLE ttrss_user_entries DROP INDEX ref_id; +ALTER TABLE ttrss_user_entries DROP INDEX owner_uid; +ALTER TABLE ttrss_user_entries DROP INDEX feed_id; +ALTER TABLE ttrss_user_prefs DROP INDEX pref_name; +ALTER TABLE ttrss_user_prefs DROP INDEX owner_uid; + +UPDATE ttrss_version SET schema_version = 127; + +COMMIT; |