SQLite CVSTrac

*** 8,14 ****
  
  _: _tokenizer_ ::= *SIMPLE* | *PORTER* | _user-defined_
  
! If no tokenizer is requested, then the simple tokenizer is used.  Additional user-defined tokenizers may be built into a particular SQLite library, *SIMPLE* and *PORTER* are the only tokenizers provided by default.  If no column names are requested, then the single column *content* is used.  Thus, the following statements all create the same table:
  
    CREATE VIRTUAL TABLE t USING fts3;
    CREATE VIRTUAL TABLE t USING fts3();
--- 8,14 ----
  
  _: _tokenizer_ ::= *SIMPLE* | *PORTER* | _user-defined_
  
! If no tokenizer is requested, then the simple tokenizer is used.  Additional user-defined tokenizers may be built into a particular SQLite library, *SIMPLE* and *PORTER* are the only tokenizers provided by default.  If no column names are requested, then the single column *content* is used.  Thus, the following statements all create a table with a single column *content* using tokenizer *simple*:
  
    CREATE VIRTUAL TABLE t USING fts3;
    CREATE VIRTUAL TABLE t USING fts3();
***************
*** 16,22 ****
    CREATE VIRTUAL TABLE t USING fts3(TOKENIZE simple);
    CREATE VIRTUAL TABLE t USING fts3(content, TOKENIZE simple);
  
! The column names 'docid' and 'tokenize' are reserved and should not be used.  Multiple column names can be provided:
  
    CREATE VIRTUAL TABLE t USING fts3(name, address);
  
--- 16,22 ----
    CREATE VIRTUAL TABLE t USING fts3(TOKENIZE simple);
    CREATE VIRTUAL TABLE t USING fts3(content, TOKENIZE simple);
  
! The column names 'docid' and 'tokenize' are reserved and should not be used in fts create statements.  Multiple column names can be provided:
  
    CREATE VIRTUAL TABLE t USING fts3(name, address);
  
***************
*** 27,30 ****
  
  In other words, any additional information, including constraints and type information, is ignored.
  
! Destroying an fts table uses the standard SQLite {link: http://www.sqlite.org/lang_droptable.html DROP TABLE} syntax.  For example:
--- 27,30 ----
  
  In other words, any additional information, including constraints and type information, is ignored.
  
! Destroying an fts table uses the standard SQLite {link: http://www.sqlite.org/lang_droptable.html DROP TABLE} syntax.

sqlite - Fts Usage