maintenance/sqlite/archives/searchindex-fts3.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

-- 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, 
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');