-- 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 = ?),
  ?,
  ?
);