1 files changed, 18 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/searchindex-fts3.sql b/www/wiki/maintenance/sqlite/archives/searchindex-fts3.sql
new file mode 100644
index 00000000..38cdfcfc
--- /dev/null
+++ b/www/wiki/maintenance/sqlite/archives/searchindex-fts3.sql
@@ -0,0 +1,18 @@
+-- Patch that introduces fulltext search capabilities to SQLite schema
+-- Requires that SQLite must be compiled with FTS3 module (comes with core amalgamation).
+-- See https://sqlite.org/fts3.html for details of syntax.
+-- Will fail if FTS3 is not present,
+DROP TABLE IF EXISTS /*_*/searchindex;
+CREATE VIRTUAL TABLE /*_*/searchindex USING FTS3(
+  -- Key to page_id
+  -- Disabled, instead we use the built-in rowid column
+  -- si_page INTEGER NOT NULL,
+
+  -- Munged version of title
+  si_title,
+
+  -- Munged version of body text
+  si_text
+);
+
+INSERT INTO /*_*/updatelog (ul_key) VALUES ('fts3');