diff options
Diffstat (limited to 'dbstore/sql/cisa/insert-vendor.sql')
-rw-r--r-- | dbstore/sql/cisa/insert-vendor.sql | 3 |
1 files changed, 3 insertions, 0 deletions
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; |