insert-vendor.sql « cisa « sql « dbstore - cvez - Unnamed repository; edit this file 'description' to name the repository.

about summary refs log tree commit diff

path: root/dbstore/sql/cisa/insert-vendor.sql

blob: a5f1a12a2f042f87507d66df002c1c70fcab1947 (plain)

1
2
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;