[Summary view] [Print] [Text view]

   1  -- Patch that introduces fulltext search capabilities to SQLite schema
   2  -- Requires that SQLite must be compiled with FTS3 module (comes with core amalgamation).
   3  -- See http://sqlite.org/fts3.html for details of syntax.
   4  -- Will fail if FTS3 is not present,
   5  DROP TABLE IF EXISTS /*_*/searchindex;
   6  CREATE VIRTUAL TABLE /*_*/searchindex USING FTS3(
   7    -- Key to page_id
   8    -- Disabled, instead we use the built-in rowid column
   9    -- si_page INTEGER NOT NULL,
  10  
  11    -- Munged version of title
  12    si_title,
  13  
  14    -- Munged version of body text
  15    si_text
  16  );
  17  
  18  INSERT INTO /*_*/updatelog (ul_key) VALUES ('fts3');