| Index: branches/sqlite/maintenance/sqlite/archives/patch-fts3-searchindex.sql |
| — | — | @@ -0,0 +1,15 @@ |
| | 2 | +-- Patch that introduces fulltext search capabilities to SQLite schema |
| | 3 | +-- Requires that SQLite must be compiled with FTS3 module (comes with core amalgamation). |
| | 4 | +-- See http://www.sqlite.org/cvstrac/wiki?p=FtsUsage for details of syntax. |
| | 5 | +-- Will fail if FTS3 is not present, |
| | 6 | +DROP TABLE IF EXISTS /*_*/searchindex; |
| | 7 | +CREATE VIRTUAL TABLE /*_*/searchindex USING FTS3( |
| | 8 | + -- Key to page_id |
| | 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 | +); |
| Property changes on: branches/sqlite/maintenance/sqlite/archives/patch-fts3-searchindex.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 17 | + native |
| Index: branches/sqlite/maintenance/sqlite/archives/patch-searchindex-no-fts.sql |
| — | — | @@ -0,0 +1,16 @@ |
| | 2 | +-- Searchindex table definition for cases when no full-text search SQLite module is present |
| | 3 | +-- (currently, only FTS3 is supported). |
| | 4 | +-- Use it if you are moving your database from environment with FTS support |
| | 5 | +-- to environment without it. |
| | 6 | + |
| | 7 | +DROP TABLE IF EXISTS /*_*/searchindex; |
| | 8 | +CREATE TABLE /*_*/searchindex ( |
| | 9 | + -- Key to page_id |
| | 10 | + si_page INTEGER NOT NULL, |
| | 11 | + |
| | 12 | + -- Munged version of title |
| | 13 | + si_title TEXT, |
| | 14 | + |
| | 15 | + -- Munged version of body text |
| | 16 | + si_text TEXT |
| | 17 | +); |
| \ No newline at end of file |
| Property changes on: branches/sqlite/maintenance/sqlite/archives/patch-searchindex-no-fts.sql |
| ___________________________________________________________________ |
| Name: svn:eol-style |
| 1 | 18 | + native |