aboutsummaryrefslogtreecommitdiff
path: root/dbstore/sql
AgeCommit message (Collapse)AuthorFilesLines
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-26dbstore: add dbstore/sql/test/query{,row}Paul Duncan6-0/+46
2022-02-20dbstore: shrink CVE FTS index (test index from 120M to 86M) by removing all ↵Paul Duncan2-102/+84
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 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
generated by cgit v1.2.3 (git 2.39.1) at 2024-11-26 15:50:38 +0000