dbstore/sql/feed/insert-item-cvss-v3.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

-- add item CVSSv2 impact.
INSERT INTO item_cvss_v3_impacts (
  item_id,
  v3_vector,
  v3_base_score,
  v2_severity_id,
  v3_impact_score,
  v3_expl_score
) VALUES (
  ?, ?, ?,
  (SELECT severity_id FROM severities WHERE name = ?),
  ?,
  ?
);