aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPaul Duncan <pabs@pablotron.org>2022-02-19 16:22:29 -0500
committerPaul Duncan <pabs@pablotron.org>2022-02-19 16:22:29 -0500
commit5eaa03b404b574a7a2719c60eef09dfa48553094 (patch)
treedcc3fc675d1865488ed64217088a0caced6a512c
parent4e478d0b49e777bdb61269ec06f36d0c3ee9c68c (diff)
downloadcvez-5eaa03b404b574a7a2719c60eef09dfa48553094.tar.bz2
cvez-5eaa03b404b574a7a2719c60eef09dfa48553094.zip
dbstore/sql/feed: fix misc query typos
-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 = ?),
- ?,
- ?
+ ?, ?
);