diff options
author | Paul Duncan <pabs@pablotron.org> | 2022-02-04 18:52:04 -0500 |
---|---|---|
committer | Paul Duncan <pabs@pablotron.org> | 2022-02-04 18:52:04 -0500 |
commit | 2c10f51c09f56c19dfd1306340102963476bd03e (patch) | |
tree | 51e91c1ac6a6b406ca70aa8a864c79073e6cfaa1 /internal/dbstore/testdata/sql/fill-fts.sql | |
parent | dd04d8fa0d12afcbfe54b8ad273f55ad0750e553 (diff) | |
download | cvez-2c10f51c09f56c19dfd1306340102963476bd03e.tar.bz2 cvez-2c10f51c09f56c19dfd1306340102963476bd03e.zip |
re-add internal/dbstore
Diffstat (limited to 'internal/dbstore/testdata/sql/fill-fts.sql')
-rw-r--r-- | internal/dbstore/testdata/sql/fill-fts.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/internal/dbstore/testdata/sql/fill-fts.sql b/internal/dbstore/testdata/sql/fill-fts.sql new file mode 100644 index 0000000..5329ca7 --- /dev/null +++ b/internal/dbstore/testdata/sql/fill-fts.sql @@ -0,0 +1,10 @@ +-- populate fts table +INSERT INTO cpe_fts(rowid, title) + SELECT a.cpe_id, + COALESCE(b.val, '') + + FROM cpes a + LEFT JOIN cpe_titles b + ON (b.cpe_id = a.cpe_id) + + WHERE b.lang = 'en-US'; |