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