dbstore/sql/cisa/insert-vuln.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

-- insert CISA catalog vulnerability
INSERT INTO cisa_vulns (
  cat_id,
  cve_year,
  cve_num,
  vendor_id,
  product_id,
  name,
  added_at,
  description,
  action,
  due_at
) VALUES (
  ?, -- cat id
  ?, -- cve year
  ?, -- cve num
  (SELECT vendor_id FROM cisa_vendors WHERE name = ?), -- vendor ID
  (SELECT product_id FROM cisa_products WHERE name = ?), -- product ID
  ?, -- name
  ?, -- added at
  ?, -- description
  ?, -- action
  ?  -- due at
);