debian-mirror-gitlab/db/post_migrate/20220531024143_remove_clusters_deployments_cluster_id_fk.rb
2022-07-23 20:15:48 +02:00

30 lines
552 B
Ruby

# frozen_string_literal: true
class RemoveClustersDeploymentsClusterIdFk < Gitlab::Database::Migration[2.0]
FK_NAME = 'fk_289bba3222'
disable_ddl_transaction!
def up
with_lock_retries do
remove_foreign_key_if_exists(
:deployments,
:clusters,
name: FK_NAME,
reverse_lock_order: true
)
end
end
def down
add_concurrent_foreign_key(
:deployments,
:clusters,
name: FK_NAME,
column: :cluster_id,
target_column: :id,
on_delete: :nullify
)
end
end