diff options
author | Paul Duncan <pabs@pablotron.org> | 2022-02-19 12:06:00 -0500 |
---|---|---|
committer | Paul Duncan <pabs@pablotron.org> | 2022-02-19 12:06:00 -0500 |
commit | 3b926f0deed58f197b466203fe591224fbce885d (patch) | |
tree | 359dd5e295ff831a95520c60998425405746af87 /dbstore/sql/feed/insert-item-cvss-v2.sql | |
parent | d4d9a43e49b5746a55af665078b24a6b92d7d8c4 (diff) | |
download | cvez-3b926f0deed58f197b466203fe591224fbce885d.tar.bz2 cvez-3b926f0deed58f197b466203fe591224fbce885d.zip |
add dbstore/sql/feed
Diffstat (limited to 'dbstore/sql/feed/insert-item-cvss-v2.sql')
-rw-r--r-- | dbstore/sql/feed/insert-item-cvss-v2.sql | 20 |
1 files changed, 20 insertions, 0 deletions
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 = ?), + ?, ?, ?, + ?, ?, ?, + ? +); |