1 files changed, 23 insertions, 0 deletions
diff --git a/sources/master/search.sql b/sources/master/search.sql
new file mode 100644
index 0000000..6c45182
--- /dev/null
+++ b/sources/master/search.sql
@@ -0,0 +1,23 @@
+-- ============================================================================
+--
+--  Taginfo
+--
+--  search.sql
+--
+-- ============================================================================
+
+.bail ON
+
+ATTACH DATABASE '__DIR__/db/taginfo-db.db' AS db;
+
+DROP TABLE IF EXISTS ftsearch;
+CREATE VIRTUAL TABLE ftsearch USING fts3 (
+    key       TEXT,
+    value     TEXT,
+    count_all INTEGER
+);
+
+INSERT INTO ftsearch (key, value, count_all) SELECT key, value, count_all FROM db.tags;
+
+ANALYZE;
+