From a1a37bbc35ac1f793f05254edd142d0673c14c94 Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
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(-)

(limited to 'dbstore/sql')

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