aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql/init.sql
AgeCommit message (Collapse)AuthorFilesLines
2022-03-19dbstore: lots of small fixesPaul Duncan1-118/+67
2022-03-16dbstore/sql/init.sql: fix cisa field limitsPaul Duncan1-7/+18
2022-03-16dbstore/sql/init.sql: fix misc typosPaul Duncan1-6/+6
2022-03-15dbstore/sql/init.sql: add cisa kev tables and ftsPaul Duncan1-0/+189
2022-02-20dbstore: shrink CVE FTS index (test index from 120M to 86M) by removing all ↵Paul Duncan1-90/+70
IDs except cve_id, concatenating reference tags, and removing severities
2022-02-20dbstore/sql/init.sql: remove per-table cve fts triggers, add size notes and ↵Paul Duncan1-486/+12
TODO to cve fts refresh table
2022-02-20dbstore/sql/init.sql: fix printf() in cve_nvd_idsPaul Duncan1-1/+1
2022-02-20dbstore: add AddCveFeeds(), fix bugs, fix TestAddCveFeedPaul Duncan1-3/+3
2022-02-20dbstore/sql/init.sql: add cve_nvd_ids, remove existing cve_all triggers, add ↵Paul Duncan1-417/+512
cve_fts_refresh with triggers
2022-02-19dbstore/sql/init.sql: add cve_fts_all (note: 10x test db size increase, from ↵Paul Duncan1-0/+556
31M to 320M)
2022-02-19dbstore: store cve year and number instead of CVE ID, add and use assigners ↵Paul Duncan1-6/+26
table
2022-02-19dbstore/sql/init.sql: s/severeties/severities/, tighten cpe23, lang, and cve ↵Paul Duncan1-13/+11
ID constraints
2022-02-19dbstore/sql/init.sql: clean up indentation, add item v2 and v3 impactsPaul Duncan1-99/+234
2022-02-19dbstore/sql/init.sql: add initial cve tablesPaul Duncan1-3/+182
2022-02-17dbstore/sql/init.sql: add cpe_match* tablesPaul Duncan1-4/+99
2022-02-05dbstore/sql/init.sql: constrain text colsPaul Duncan1-4/+12
2022-02-05mv internal/dbstore dbstorePaul Duncan1-0/+180