From a1a37bbc35ac1f793f05254edd142d0673c14c94 Mon Sep 17 00:00:00 2001 From: Paul Duncan Date: Sun, 20 Feb 2022 10:46:01 -0500 Subject: dbstore/sql/init.sql: fix printf() in cve_nvd_ids --- dbstore/sql/init.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/dbstore/sql/init.sql b/dbstore/sql/init.sql index a54f278..b8f56e9 100644 --- a/dbstore/sql/init.sql +++ b/dbstore/sql/init.sql @@ -387,7 +387,7 @@ CREATE INDEX in_cves_item_id ON cves(item_id); -- CREATE VIEW cve_nvd_ids AS SELECT cve_id, - printf('CVE-%04-%04d', cve_year, cve_num) AS nvd_id + printf('CVE-%04d-%04d', cve_year, cve_num) AS nvd_id FROM cves; -- -- cgit v1.2.3