diff options
Diffstat (limited to 'db/migrate/20220708132701_create_vulnerability_merge_request_links.rb')
-rw-r--r-- | db/migrate/20220708132701_create_vulnerability_merge_request_links.rb | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/db/migrate/20220708132701_create_vulnerability_merge_request_links.rb b/db/migrate/20220708132701_create_vulnerability_merge_request_links.rb new file mode 100644 index 00000000000..51fe15bee6e --- /dev/null +++ b/db/migrate/20220708132701_create_vulnerability_merge_request_links.rb @@ -0,0 +1,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 |