aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql/feed/insert-cve.sql
blob: 9e620485d19ffabd9ba00f0fb031bfeeb3842e5d (plain)
1
2
3
4
5
-- add cve
INSERT INTO cves(item_id, cve_year, cve_num, assigner_id) VALUES (
  ?, ?, ?,
  (SELECT assigner_id FROM assigners WHERE assigner = ?)
);