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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25

-- Searchindex table definition for cases when no full-text search SQLite module is present
-- (currently, only FTS3 is supported).
-- Use it if you are moving your database from environment with FTS support
-- to environment without it.

DROP TABLE IF EXISTS /*_*/searchindex;

-- These are pieces of FTS3-enabled searchindex
DROP TABLE IF EXISTS /*_*/searchindex_content;
DROP TABLE IF EXISTS /*_*/searchindex_segdir;
DROP TABLE IF EXISTS /*_*/searchindex_segments;

CREATE TABLE /*_*/searchindex (
  -- Key to page_id
  -- Disabled, instead we use the built-in rowid column
  -- si_page INTEGER NOT NULL,

  -- Munged version of title
  si_title TEXT,

  -- Munged version of body text
  si_text TEXT
);

DELETE FROM /*_*/updatelog WHERE ul_key='fts3';