diff options
author | Paul Duncan <pabs@pablotron.org> | 2022-03-16 06:50:10 -0400 |
---|---|---|
committer | Paul Duncan <pabs@pablotron.org> | 2022-03-16 06:50:10 -0400 |
commit | 7d5c7a1c09c2d6f3ee05294360a3ab7a4b90f9cb (patch) | |
tree | 735dbd1d88f8efcb21a5d37882c8df99e237139f /dbstore/sql | |
parent | 99b10fbdeb97717337622e1e6a93f94a4b906a0c (diff) | |
download | cvez-7d5c7a1c09c2d6f3ee05294360a3ab7a4b90f9cb.tar.bz2 cvez-7d5c7a1c09c2d6f3ee05294360a3ab7a4b90f9cb.zip |
dbstore/sql/init.sql: fix misc typos
Diffstat (limited to 'dbstore/sql')
-rw-r--r-- | dbstore/sql/init.sql | 12 |
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; |