aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql/feed/insert-item-cvss-v3.sql
blob: 73dfafaf963cfb5c4e39e257bf788fe0184febaa (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
-- add item CVSSv2 impact.
INSERT INTO item_cvss_v3_impacts (
  item_id,
  v3_vector,
  v3_base_score,
  v3_severity_id,
  v3_impact_score,
  v3_expl_score
) VALUES (
  ?, ?, ?,
  (SELECT severity_id FROM severities WHERE name = ?),
  ?, ?
);