From 5eaa03b404b574a7a2719c60eef09dfa48553094 Mon Sep 17 00:00:00 2001 From: Paul Duncan Date: Sat, 19 Feb 2022 16:22:29 -0500 Subject: dbstore/sql/feed: fix misc query typos --- dbstore/sql/feed/insert-cve-problem-desc.sql | 2 +- dbstore/sql/feed/insert-item-cvss-v3.sql | 5 ++--- 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 = ?), - ?, - ? + ?, ? ); -- cgit v1.2.3