aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql
AgeCommit message (Collapse)AuthorFilesLines
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 Duncan2-3/+5
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: add CveSearch() and test (but not test data)Paul Duncan1-0/+32
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-19add dbstore/sql/feed/insert-assigner.sqlPaul Duncan1-0/+13
2022-02-19dbstore: store cve year and number instead of CVE ID, add and use assigners ↵Paul Duncan2-7/+30
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/feed: fix misc query typosPaul Duncan2-4/+3
2022-02-19add dbstore/sql/feedPaul Duncan11-0/+52
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-18dbstore: refactor sqlfs and tx, add tx testsPaul Duncan1-0/+3
2022-02-17dbstore: add DbStore#CpeMatchSearch() and backing queryPaul Duncan1-0/+11
2022-02-17dbstore/sql: add cpe and cpe-match subdirsPaul Duncan11-0/+20
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 Duncan10-0/+405