1 files changed, 0 insertions, 32 deletions
diff --git a/db/migrate/20160603180330_remove_duplicated_notification_settings.rb b/db/migrate/20160603180330_remove_duplicated_notification_settings.rb
deleted file mode 100644
index 0d8c4bf011c..00000000000
--- a/db/migrate/20160603180330_remove_duplicated_notification_settings.rb
+++ /dev/null
@@ -1,32 +0,0 @@
-class RemoveDuplicatedNotificationSettings < ActiveRecord::Migration[4.2]
-  def up
-    duplicates = exec_query(%Q{
-      SELECT user_id, source_type, source_id
-      FROM notification_settings
-      GROUP BY user_id, source_type, source_id
-      HAVING COUNT(*) > 1
-    })
-
-    duplicates.each do |row|
-      uid = row['user_id']
-      stype = connection.quote(row['source_type'])
-      sid = row['source_id']
-
-      execute(%Q{
-        DELETE FROM notification_settings
-        WHERE user_id = #{uid}
-        AND source_type = #{stype}
-        AND source_id = #{sid}
-        AND id != (
-          SELECT id FROM (
-            SELECT min(id) AS id
-            FROM notification_settings
-            WHERE user_id = #{uid}
-            AND source_type = #{stype}
-            AND source_id = #{sid}
-          ) min_ids
-        )
-      })
-    end
-  end
-end