From 89e31b9d4e721da222d3fbb5e66b0c6a18961ac9 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 20 Feb 2015 12:49:58 +0300 Subject: 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) --- schema/versions/mysql/127.sql | 13 ------------- 1 file changed, 13 deletions(-) (limited to 'schema/versions') 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; -- cgit v1.2.3-54-g00ecf