From 42446fcdcf9d752201414afc7e5c7bcb2fb2ee6e Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Thu, 17 Feb 2022 23:19:55 -0500
Subject: dbstore/sql: add cpe and cpe-match subdirs

---
 dbstore/sql/cpe-match/insert-name.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 dbstore/sql/cpe-match/insert-name.sql

(limited to 'dbstore/sql/cpe-match/insert-name.sql')

diff --git a/dbstore/sql/cpe-match/insert-name.sql b/dbstore/sql/cpe-match/insert-name.sql
new file mode 100644
index 0000000..adc99f4
--- /dev/null
+++ b/dbstore/sql/cpe-match/insert-name.sql
@@ -0,0 +1,5 @@
+INSERT INTO cpe_match_cpes(
+  cpe_match_id,
+  cpe_id,
+  cpe22_uri
+) VALUES (?, (SELECT cpe_id FROM cpes WHERE cpe23 = ?), ?);
-- 
cgit v1.2.3