aboutsummaryrefslogtreecommitdiff
path: root/dbstore
diff options
context:
space:
mode:
authorPaul Duncan <pabs@pablotron.org>2022-02-17 23:19:55 -0500
committerPaul Duncan <pabs@pablotron.org>2022-02-17 23:19:55 -0500
commit42446fcdcf9d752201414afc7e5c7bcb2fb2ee6e (patch)
tree2c633a39b51c8323f859653dc89dd53c6be78861 /dbstore
parent103dbf934637d80e9624702d039ed2f7a153548d (diff)
downloadcvez-42446fcdcf9d752201414afc7e5c7bcb2fb2ee6e.tar.bz2
cvez-42446fcdcf9d752201414afc7e5c7bcb2fb2ee6e.zip
dbstore/sql: add cpe and cpe-match subdirs
Diffstat (limited to 'dbstore')
-rw-r--r--dbstore/sql/cpe-match/insert-name.sql5
-rw-r--r--dbstore/sql/cpe-match/insert-version-max.sql5
-rw-r--r--dbstore/sql/cpe-match/insert-version-min.sql5
-rw-r--r--dbstore/sql/cpe-match/insert-vulnerable.sql4
-rw-r--r--dbstore/sql/cpe-match/insert.sql1
-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