summaryrefslogtreecommitdiff
path: root/db/migrate/20170713104829_add_foreign_key_to_merge_requests.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20170713104829_add_foreign_key_to_merge_requests.rb')
-rw-r--r--db/migrate/20170713104829_add_foreign_key_to_merge_requests.rb37
1 files changed, 0 insertions, 37 deletions
diff --git a/db/migrate/20170713104829_add_foreign_key_to_merge_requests.rb b/db/migrate/20170713104829_add_foreign_key_to_merge_requests.rb
deleted file mode 100644
index 908b122c659..00000000000
--- a/db/migrate/20170713104829_add_foreign_key_to_merge_requests.rb
+++ /dev/null
@@ -1,37 +0,0 @@
-class AddForeignKeyToMergeRequests < ActiveRecord::Migration[4.2]
- include Gitlab::Database::MigrationHelpers
-
- DOWNTIME = false
-
- disable_ddl_transaction!
-
- class MergeRequest < ActiveRecord::Base
- self.table_name = 'merge_requests'
- include ::EachBatch
- end
-
- def up
- scope = <<-SQL.strip_heredoc
- head_pipeline_id IS NOT NULL
- AND NOT EXISTS (
- SELECT 1 FROM ci_pipelines
- WHERE ci_pipelines.id = merge_requests.head_pipeline_id
- )
- SQL
-
- MergeRequest.where(scope).each_batch(of: 1000) do |merge_requests|
- merge_requests.update_all(head_pipeline_id: nil)
- end
-
- unless foreign_key_exists?(:merge_requests, column: :head_pipeline_id)
- add_concurrent_foreign_key(:merge_requests, :ci_pipelines,
- column: :head_pipeline_id, on_delete: :nullify)
- end
- end
-
- def down
- if foreign_key_exists?(:merge_requests, column: :head_pipeline_id)
- remove_foreign_key(:merge_requests, column: :head_pipeline_id)
- end
- end
-end