diff options
Diffstat (limited to 'db/migrate/20180420010016_add_pipeline_build_foreign_key.rb')
-rw-r--r-- | db/migrate/20180420010016_add_pipeline_build_foreign_key.rb | 27 |
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 |