db/migrate/20220708132701_create_vulnerability_merge_request_links.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

# frozen_string_literal: true

class CreateVulnerabilityMergeRequestLinks < Gitlab::Database::Migration[2.0]
  INDEX_NAME = "unique_vuln_merge_request_link_vuln_id_and_mr_id"

  def up
    create_table :vulnerability_merge_request_links do |t|
      t.bigint :vulnerability_id, null: false
      t.integer :merge_request_id, null: false

      t.index :merge_request_id
      t.timestamps_with_timezone null: false
    end

    add_index(
      :vulnerability_merge_request_links,
      %i[vulnerability_id merge_request_id],
      unique: true,
      name: INDEX_NAME
    )
  end

  def down
    drop_table(
      :vulnerability_merge_request_links,
      if_exists: true
    )
  end
end