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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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 = ?),
  ?, ?, ?,
  ?, ?, ?,
  ?
);