File: version-023.sql

package info (click to toggle)
geary 46.0-10
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 15,092 kB
  • sloc: javascript: 972; ansic: 722; sql: 247; xml: 183; python: 30; makefile: 28; sh: 24
file content (21 lines) | stat: -rw-r--r-- 479 bytes parent folder | download | duplicates (7) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
 
--
-- Database upgrade to add FTS tokenize virtual table, which allows for querying the tokenizer
-- directly for stemmed words, and dropping the stemmed FTS table for an unstemmed one.  We now
-- use the stemmer manually to generate search queries.
--

DROP TABLE MessageSearchTable;

CREATE VIRTUAL TABLE MessageSearchTable USING fts4(
    body,
    attachment,
    subject,
    from_field,
    receivers,
    cc,
    bcc,
    
    tokenize=simple,
    prefix="2,4,6,8,10"
);