db/post_migrate/20230705142241_drop_vulnerable_component_versions.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22

# frozen_string_literal: true

class DropVulnerableComponentVersions < Gitlab::Database::Migration[2.1]
  ADVISORY_INDEX_NAME = "index_vulnerable_component_versions_on_vulnerability_advisory"
  SBOM_COMPONENT_INDEX_NAME = "index_vulnerable_component_versions_on_sbom_component_version"

  def up
    drop_table :sbom_vulnerable_component_versions
  end

  def down
    create_table :sbom_vulnerable_component_versions do |t|
      t.references :vulnerability_advisory,
        index: { name: ADVISORY_INDEX_NAME }

      t.references :sbom_component_version,
        index: { name: SBOM_COMPONENT_INDEX_NAME }

      t.timestamps_with_timezone null: false
    end
  end
end