maintenance/sqlite/archives/searchindex-no-fts.sql

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