diff options
| author | Paul Duncan <pabs@pablotron.org> | 2022-02-17 23:19:55 -0500 |
|---|---|---|
| committer | Paul Duncan <pabs@pablotron.org> | 2022-02-17 23:19:55 -0500 |
| commit | 42446fcdcf9d752201414afc7e5c7bcb2fb2ee6e (patch) | |
| tree | 2c633a39b51c8323f859653dc89dd53c6be78861 | |
| parent | 103dbf934637d80e9624702d039ed2f7a153548d (diff) | |
| download | cvez-42446fcdcf9d752201414afc7e5c7bcb2fb2ee6e.tar.bz2 cvez-42446fcdcf9d752201414afc7e5c7bcb2fb2ee6e.zip | |
dbstore/sql: add cpe and cpe-match subdirs
| -rw-r--r-- | dbstore/sql/cpe-match/insert-name.sql | 5 | ||||
| -rw-r--r-- | dbstore/sql/cpe-match/insert-version-max.sql | 5 | ||||
| -rw-r--r-- | dbstore/sql/cpe-match/insert-version-min.sql | 5 | ||||
| -rw-r--r-- | dbstore/sql/cpe-match/insert-vulnerable.sql | 4 | ||||
| -rw-r--r-- | dbstore/sql/cpe-match/insert.sql | 1 | ||||
| -rw-r--r-- | dbstore/sql/cpe/insert-ref.sql (renamed from dbstore/sql/insert-ref.sql) | 0 | ||||
| -rw-r--r-- | dbstore/sql/cpe/insert-title.sql (renamed from dbstore/sql/insert-title.sql) | 0 | ||||
| -rw-r--r-- | dbstore/sql/cpe/insert.sql (renamed from dbstore/sql/insert-cpe.sql) | 0 | ||||
| -rw-r--r-- | dbstore/sql/cpe/search-all.sql (renamed from dbstore/sql/cpe-search-all.sql) | 0 | ||||
| -rw-r--r-- | dbstore/sql/cpe/search-ref.sql (renamed from dbstore/sql/cpe-search-ref.sql) | 0 | ||||
| -rw-r--r-- | dbstore/sql/cpe/search-title.sql (renamed from dbstore/sql/cpe-search-title.sql) | 0 |
11 files changed, 20 insertions, 0 deletions
diff --git a/dbstore/sql/cpe-match/insert-name.sql b/dbstore/sql/cpe-match/insert-name.sql new file mode 100644 index 0000000..adc99f4 --- /dev/null +++ b/dbstore/sql/cpe-match/insert-name.sql @@ -0,0 +1,5 @@ +INSERT INTO cpe_match_cpes( + cpe_match_id, + cpe_id, + cpe22_uri +) VALUES (?, (SELECT cpe_id FROM cpes WHERE cpe23 = ?), ?); diff --git a/dbstore/sql/cpe-match/insert-version-max.sql b/dbstore/sql/cpe-match/insert-version-max.sql new file mode 100644 index 0000000..b39944f --- /dev/null +++ b/dbstore/sql/cpe-match/insert-version-max.sql @@ -0,0 +1,5 @@ +INSERT INTO cpe_match_version_maxs( + cpe_match_id, + is_inclusive, + max_version +) VALUES (?, ?, ?); diff --git a/dbstore/sql/cpe-match/insert-version-min.sql b/dbstore/sql/cpe-match/insert-version-min.sql new file mode 100644 index 0000000..a7e8643 --- /dev/null +++ b/dbstore/sql/cpe-match/insert-version-min.sql @@ -0,0 +1,5 @@ +INSERT INTO cpe_match_version_mins( + cpe_match_id, + is_inclusive, + min_version +) VALUES (?, ?, ?); diff --git a/dbstore/sql/cpe-match/insert-vulnerable.sql b/dbstore/sql/cpe-match/insert-vulnerable.sql new file mode 100644 index 0000000..062c95b --- /dev/null +++ b/dbstore/sql/cpe-match/insert-vulnerable.sql @@ -0,0 +1,4 @@ +INSERT INTO cpe_match_vulnerables ( + cpe_match_id, + is_vulnerable +) VALUES (?, ?) diff --git a/dbstore/sql/cpe-match/insert.sql b/dbstore/sql/cpe-match/insert.sql new file mode 100644 index 0000000..bc5d2c0 --- /dev/null +++ b/dbstore/sql/cpe-match/insert.sql @@ -0,0 +1 @@ +INSERT INTO cpe_matches(cpe23, cpe22_uri) VALUES (?, ?); diff --git a/dbstore/sql/insert-ref.sql b/dbstore/sql/cpe/insert-ref.sql index a39ab1c..a39ab1c 100644 --- a/dbstore/sql/insert-ref.sql +++ b/dbstore/sql/cpe/insert-ref.sql diff --git a/dbstore/sql/insert-title.sql b/dbstore/sql/cpe/insert-title.sql index 5045d95..5045d95 100644 --- a/dbstore/sql/insert-title.sql +++ b/dbstore/sql/cpe/insert-title.sql diff --git a/dbstore/sql/insert-cpe.sql b/dbstore/sql/cpe/insert.sql index dca1c2b..dca1c2b 100644 --- a/dbstore/sql/insert-cpe.sql +++ b/dbstore/sql/cpe/insert.sql diff --git a/dbstore/sql/cpe-search-all.sql b/dbstore/sql/cpe/search-all.sql index 3260902..3260902 100644 --- a/dbstore/sql/cpe-search-all.sql +++ b/dbstore/sql/cpe/search-all.sql diff --git a/dbstore/sql/cpe-search-ref.sql b/dbstore/sql/cpe/search-ref.sql index a2d3be6..a2d3be6 100644 --- a/dbstore/sql/cpe-search-ref.sql +++ b/dbstore/sql/cpe/search-ref.sql diff --git a/dbstore/sql/cpe-search-title.sql b/dbstore/sql/cpe/search-title.sql index 7421ffc..7421ffc 100644 --- a/dbstore/sql/cpe-search-title.sql +++ b/dbstore/sql/cpe/search-title.sql |