Skip to content

Remove unique index from `vulnerability_occurrences` table

Subashis Chakraborty requested to merge 351281-remove-index into master

What does this MR do and why?

This MR removes unique index index_vulnerability_occurrences_on_unique_keys from vulnerability_occurrences table. As we already the unique constraint on the uuid we do not need index_vulnerability_occurrences_on_unique_keys unique index anymore.

Migration:


bundle exec rails db:migrate 

== 20220201205300 RemoveIndexForVulnerabilityOccurrences: migrating ===========
-- transaction_open?()
   -> 0.0000s
-- indexes(:vulnerability_occurrences)
   -> 0.0123s
-- execute("SET statement_timeout TO 0")
   -> 0.0011s
-- remove_index(:vulnerability_occurrences, {:algorithm=>:concurrently, :name=>"index_vulnerability_occurrences_on_unique_keys"})
   -> 0.0083s
-- execute("RESET statement_timeout")
   -> 0.0010s
== 20220201205300 RemoveIndexForVulnerabilityOccurrences: migrated (0.0343s) ==

bundle exec rails db:rollback

== 20220201205300 RemoveIndexForVulnerabilityOccurrences: reverting ===========
== 20220201205300 RemoveIndexForVulnerabilityOccurrences: reverted (0.0000s) ==

Related to #351281 (closed)

Edited by Subashis Chakraborty

Merge request reports