aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql
diff options
context:
space:
mode:
Diffstat (limited to 'dbstore/sql')
-rw-r--r--dbstore/sql/feed/insert-cve-problem-desc.sql2
-rw-r--r--dbstore/sql/feed/insert-item-cvss-v3.sql5
2 files changed, 3 insertions, 4 deletions
diff --git a/dbstore/sql/feed/insert-cve-problem-desc.sql b/dbstore/sql/feed/insert-cve-problem-desc.sql
index 5c7afad..f5f4fd9 100644
--- a/dbstore/sql/feed/insert-cve-problem-desc.sql
+++ b/dbstore/sql/feed/insert-cve-problem-desc.sql
@@ -1,2 +1,2 @@
-- add description for cve problem type
-INSERT INTO cve_problem_descriptions(cve_id, desc_id) VALUES (?, ?);
+INSERT INTO cve_problem_descriptions(pt_id, desc_id) VALUES (?, ?);
diff --git a/dbstore/sql/feed/insert-item-cvss-v3.sql b/dbstore/sql/feed/insert-item-cvss-v3.sql
index c5af1fe..73dfafa 100644
--- a/dbstore/sql/feed/insert-item-cvss-v3.sql
+++ b/dbstore/sql/feed/insert-item-cvss-v3.sql
@@ -3,12 +3,11 @@ INSERT INTO item_cvss_v3_impacts (
item_id,
v3_vector,
v3_base_score,
- v2_severity_id,
+ v3_severity_id,
v3_impact_score,
v3_expl_score
) VALUES (
?, ?, ?,
(SELECT severity_id FROM severities WHERE name = ?),
- ?,
- ?
+ ?, ?
);