summaryrefslogtreecommitdiff
path: root/maintenance/sqlite/archives/searchindex-fts3.sql
diff options
context:
space:
mode:
Diffstat (limited to 'maintenance/sqlite/archives/searchindex-fts3.sql')
-rw-r--r--maintenance/sqlite/archives/searchindex-fts3.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/maintenance/sqlite/archives/searchindex-fts3.sql b/maintenance/sqlite/archives/searchindex-fts3.sql
index 28554c02..2a370940 100644
--- a/maintenance/sqlite/archives/searchindex-fts3.sql
+++ b/maintenance/sqlite/archives/searchindex-fts3.sql
@@ -1,7 +1,7 @@
-- Patch that introduces fulltext search capabilities to SQLite schema
-- Requires that SQLite must be compiled with FTS3 module (comes with core amalgamation).
-- See http://sqlite.org/fts3.html for details of syntax.
--- Will fail if FTS3 is not present,
+-- Will fail if FTS3 is not present,
DROP TABLE IF EXISTS /*_*/searchindex;
CREATE VIRTUAL TABLE /*_*/searchindex USING FTS3(
-- Key to page_id
@@ -10,7 +10,7 @@ CREATE VIRTUAL TABLE /*_*/searchindex USING FTS3(
-- Munged version of title
si_title,
-
+
-- Munged version of body text
si_text
);