1 files changed, 24 insertions, 0 deletions
diff --git a/dbstore/sql/cisa/insert-vuln.sql b/dbstore/sql/cisa/insert-vuln.sql
new file mode 100644
index 0000000..8d3d448
--- /dev/null
+++ b/dbstore/sql/cisa/insert-vuln.sql
@@ -0,0 +1,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
+);