1 files changed, 0 insertions, 39 deletions
diff --git a/db/migrate/20171114160005_merge_requests_assignee_id_foreign_key.rb b/db/migrate/20171114160005_merge_requests_assignee_id_foreign_key.rb
deleted file mode 100644
index 73c177c44f9..00000000000
--- a/db/migrate/20171114160005_merge_requests_assignee_id_foreign_key.rb
+++ /dev/null
@@ -1,39 +0,0 @@
-# See http://doc.gitlab.com/ce/development/migration_style_guide.html
-# for more information on how to write migrations for GitLab.
-
-class MergeRequestsAssigneeIdForeignKey < ActiveRecord::Migration[4.2]
-  include Gitlab::Database::MigrationHelpers
-
-  # Set this constant to true if this migration requires downtime.
-  DOWNTIME = false
-
-  disable_ddl_transaction!
-
-  class MergeRequest < ActiveRecord::Base
-    include EachBatch
-
-    self.table_name = 'merge_requests'
-
-    def self.with_orphaned_assignees
-      where('NOT EXISTS (SELECT true FROM users WHERE merge_requests.assignee_id = users.id)')
-        .where('assignee_id IS NOT NULL')
-    end
-  end
-
-  def up
-    MergeRequest.with_orphaned_assignees.each_batch(of: 100) do |batch|
-      batch.update_all(assignee_id: nil)
-    end
-
-    add_concurrent_foreign_key(
-      :merge_requests,
-      :users,
-      column: :assignee_id,
-      on_delete: :nullify
-    )
-  end
-
-  def down
-    remove_foreign_key(:merge_requests, column: :assignee_id)
-  end
-end