1 files changed, 14 insertions, 0 deletions
diff --git a/dbstore/sql/feed/insert-item-cvss-v3.sql b/dbstore/sql/feed/insert-item-cvss-v3.sql
new file mode 100644
index 0000000..c5af1fe
--- /dev/null
+++ b/dbstore/sql/feed/insert-item-cvss-v3.sql
@@ -0,0 +1,14 @@
+-- add item CVSSv2 impact.
+INSERT INTO item_cvss_v3_impacts (
+  item_id,
+  v3_vector,
+  v3_base_score,
+  v2_severity_id,
+  v3_impact_score,
+  v3_expl_score
+) VALUES (
+  ?, ?, ?,
+  (SELECT severity_id FROM severities WHERE name = ?),
+  ?,
+  ?
+);