From 22fd269069b8e47bc40fbd8681243bdd4bd61a47 Mon Sep 17 00:00:00 2001
From: Paul Duncan <pabs@pablotron.org>
Date: Sat, 5 Feb 2022 02:37:00 -0500
Subject: mv internal/dbstore dbstore

---
 dbstore/testdata/sql/fill-fts.sql | 10 ++++++++++
 1 file changed, 10 insertions(+)
 create mode 100644 dbstore/testdata/sql/fill-fts.sql

(limited to 'dbstore/testdata/sql/fill-fts.sql')

diff --git a/dbstore/testdata/sql/fill-fts.sql b/dbstore/testdata/sql/fill-fts.sql
new file mode 100644
index 0000000..5329ca7
--- /dev/null
+++ b/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';
-- 
cgit v1.2.3

