[Summary view] [Print] [Text view]

   1  -- Searchindex table definition for cases when no full-text search SQLite module is present
   2  -- (currently, only FTS3 is supported).
   3  -- Use it if you are moving your database from environment with FTS support
   4  -- to environment without it.
   5  
   6  DROP TABLE IF EXISTS /*_*/searchindex;
   7  
   8  -- These are pieces of FTS3-enabled searchindex
   9  DROP TABLE IF EXISTS /*_*/searchindex_content;
  10  DROP TABLE IF EXISTS /*_*/searchindex_segdir;
  11  DROP TABLE IF EXISTS /*_*/searchindex_segments;
  12  
  13  CREATE TABLE /*_*/searchindex (
  14    -- Key to page_id
  15    -- Disabled, instead we use the built-in rowid column
  16    -- si_page INTEGER NOT NULL,
  17  
  18    -- Munged version of title
  19    si_title TEXT,
  20  
  21    -- Munged version of body text
  22    si_text TEXT
  23  );
  24  
  25  DELETE FROM /*_*/updatelog WHERE ul_key='fts3';