-- 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
);
