diff options
Diffstat (limited to 'dbstore/sql')
-rw-r--r-- | dbstore/sql/feed/insert-cve-problem-desc.sql | 2 | ||||
-rw-r--r-- | 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 = ?), - ?, - ? + ?, ? ); |