From 3b926f0deed58f197b466203fe591224fbce885d Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Sat, 19 Feb 2022 12:06:00 -0500
Subject: add dbstore/sql/feed

---
 dbstore/sql/feed/insert-item-cvss-v2.sql | 20 ++++++++++++++++++++
 1 file changed, 20 insertions(+)
 create mode 100644 dbstore/sql/feed/insert-item-cvss-v2.sql

(limited to 'dbstore/sql/feed/insert-item-cvss-v2.sql')

diff --git a/dbstore/sql/feed/insert-item-cvss-v2.sql b/dbstore/sql/feed/insert-item-cvss-v2.sql
new file mode 100644
index 0000000..01d91f8
--- /dev/null
+++ b/dbstore/sql/feed/insert-item-cvss-v2.sql
@@ -0,0 +1,20 @@
+-- add item CVSSv2 impact.
+INSERT INTO item_cvss_v2_impacts (
+  item_id,
+  v2_vector,
+  v2_base_score,
+  v2_severity_id,
+  v2_impact_score,
+  v2_expl_score,
+  v2_insufficient_info,
+  v2_obtain_all_priv,
+  v2_obtain_user_priv,
+  v2_obtain_other_priv,
+  v2_ui_req
+) VALUES (
+  ?, ?, ?,
+  (SELECT severity_id FROM severities WHERE name = ?),
+  ?, ?, ?,
+  ?, ?, ?,
+  ?
+);
-- 
cgit v1.2.3

