summaryrefslogtreecommitdiff
path: root/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20180420010016_add_pipeline_build_foreign_key.rb')
-rw-r--r--db/migrate/20180420010016_add_pipeline_build_foreign_key.rb27
1 files changed, 0 insertions, 27 deletions
diff --git a/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb b/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb
deleted file mode 100644
index 90a908feaee..00000000000
--- a/db/migrate/20180420010016_add_pipeline_build_foreign_key.rb
+++ /dev/null
@@ -1,27 +0,0 @@
-class AddPipelineBuildForeignKey < ActiveRecord::Migration[4.2]
- include Gitlab::Database::MigrationHelpers
-
- DOWNTIME = false
-
- disable_ddl_transaction!
-
- def up
- execute <<~SQL
- DELETE FROM ci_builds WHERE project_id IS NULL OR commit_id IS NULL
- SQL
-
- execute <<~SQL
- DELETE FROM ci_builds WHERE NOT EXISTS
- (SELECT true FROM ci_pipelines WHERE ci_pipelines.id = ci_builds.commit_id)
- AND stage_id IS NULL
- SQL
-
- add_concurrent_foreign_key(:ci_builds, :ci_pipelines, column: :commit_id)
- end
-
- def down
- return unless foreign_key_exists?(:ci_builds, :ci_pipelines, column: :commit_id)
-
- remove_foreign_key(:ci_builds, column: :commit_id)
- end
-end