From fea7af49a9da16574646b8e307115f9c65d23489 Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Wed, 16 Mar 2022 08:07:26 -0400
Subject: add dbstore/sql/cisa

---
 dbstore/sql/cisa/insert-vendor.sql | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 dbstore/sql/cisa/insert-vendor.sql

(limited to 'dbstore/sql/cisa/insert-vendor.sql')

diff --git a/dbstore/sql/cisa/insert-vendor.sql b/dbstore/sql/cisa/insert-vendor.sql
new file mode 100644
index 0000000..a5f1a12
--- /dev/null
+++ b/dbstore/sql/cisa/insert-vendor.sql
@@ -0,0 +1,3 @@
+-- insert vendor/project if it does not exist, or do nothing if the the
+-- name is already present.
+INSERT INTO cisa_vendors(name) VALUES (?) ON CONFLICT(name) DO NOTHING;
-- 
cgit v1.2.3