debian-mirror-gitlab/db/migrate/20220819162852_add_sbom_component_version_foreign_key_to_sbom_vulnerable_component_versions.rb
2022-10-11 01:57:18 +05:30

20 lines
520 B
Ruby

# frozen_string_literal: true
class AddSbomComponentVersionForeignKeyToSbomVulnerableComponentVersions < Gitlab::Database::Migration[2.0]
SOURCE_TABLE = :sbom_vulnerable_component_versions
TARGET_TABLE = :sbom_component_versions
COLUMN = :sbom_component_version_id
disable_ddl_transaction!
def up
add_concurrent_foreign_key SOURCE_TABLE, TARGET_TABLE, column: COLUMN, on_delete: :cascade
end
def down
with_lock_retries do
remove_foreign_key SOURCE_TABLE, column: COLUMN
end
end
end