From 7d5c7a1c09c2d6f3ee05294360a3ab7a4b90f9cb Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Wed, 16 Mar 2022 06:50:10 -0400
Subject: dbstore/sql/init.sql: fix misc typos

---
 dbstore/sql/init.sql | 12 ++++++------
 1 file changed, 6 insertions(+), 6 deletions(-)

(limited to 'dbstore/sql/init.sql')

diff --git a/dbstore/sql/init.sql b/dbstore/sql/init.sql
index 662893e..1e9ec15 100644
--- a/dbstore/sql/init.sql
+++ b/dbstore/sql/init.sql
@@ -368,7 +368,7 @@ CREATE TABLE cves (
                     ),
 
   -- number of NVD CVE ID, (e.g. the "YYYY" in "CVE-XXXX-YYYY")
-  cve_num           SMALLINT NOT NULL CHECK (
+  cve_num           INT NOT NULL CHECK (
                       -- there is no upper bound, but let's pick
                       -- something sane
                       cve_num BETWEEN 1 AND 33554432
@@ -685,7 +685,7 @@ CREATE TRIGGER tr_cve_fts_refresh_before_insert
   END;
 
 --
--- create insert trigger on item_cvss_v3_impacts
+-- create insert trigger on cve_fts_refresh
 --
 -- Notes:
 -- * test sizes:
@@ -839,7 +839,7 @@ CREATE TABLE cisa_vulns (
                     ),
 
   -- number of NVD CVE ID, (e.g. the "YYYY" in "CVE-XXXX-YYYY")
-  cve_num           SMALLINT NOT NULL CHECK (
+  cve_num           INT NOT NULL CHECK (
                       -- there is no upper bound, but let's pick
                       -- something sane
                       cve_num BETWEEN 1 AND 33554432
@@ -945,17 +945,17 @@ CREATE TRIGGER tr_cisa_vulns_fts_refresh_after_insert
       description
     )
       SELECT a.vuln_id, -- vuln ID
-             b.cve_id, -- NVD cve id
+             b.nvd_id, -- NVD cve id
              c.name, -- vendor name
              d.name, -- product name
              a.name, -- vuln name
              a.description -- vuln description
 
         FROM cisa_vulns a
-        JOIN cve_vuln_cve_ids b
+        JOIN cisa_vuln_cve_ids b
           ON (b.vuln_id = a.vuln_id)
         JOIN cisa_vendors c
           ON (c.vendor_id = a.vendor_id)
         JOIN cisa_products d
-          ON (c.product_id = a.product_id);
+          ON (d.product_id = a.product_id);
   END;
-- 
cgit v1.2.3

