1 files changed, 22 insertions, 0 deletions
diff --git a/db/post_migrate/20230705142241_drop_vulnerable_component_versions.rb b/db/post_migrate/20230705142241_drop_vulnerable_component_versions.rb
new file mode 100644
index 00000000000..10432f6b515
--- /dev/null
+++ b/db/post_migrate/20230705142241_drop_vulnerable_component_versions.rb
@@ -0,0 +1,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