aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql
diff options
context:
space:
mode:
Diffstat (limited to 'dbstore/sql')
-rw-r--r--dbstore/sql/init.sql12
1 files changed, 6 insertions, 6 deletions
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;