diff options
author | Andrew Dolgov <[email protected]> | 2015-02-20 12:49:58 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2015-02-20 12:49:58 +0300 |
commit | 89e31b9d4e721da222d3fbb5e66b0c6a18961ac9 (patch) | |
tree | 7f120bc01b6a50b754b3180680c2c083e5678ffc /schema/versions/mysql/127.sql | |
parent | 8eee97a8dab93b2f8530f6dc79fb5994103adb5b (diff) |
migration: remove mandatory index drops from 127 because of potential fatal errors; remove unnecessary named indexes from mysql schema for fields with foreign key constraints (mysql should create indexes automatically on table creation for those fields)
Diffstat (limited to 'schema/versions/mysql/127.sql')
-rw-r--r-- | schema/versions/mysql/127.sql | 13 |
1 files changed, 0 insertions, 13 deletions
diff --git a/schema/versions/mysql/127.sql b/schema/versions/mysql/127.sql index 5dcc23b2f..2c521d86c 100644 --- a/schema/versions/mysql/127.sql +++ b/schema/versions/mysql/127.sql @@ -1,18 +1,5 @@ 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; |