PHP Classes

File: db.sqlite

Recommend this page to a friend!
  Classes of Cesar D. Rodas   Guaranix Full Text   db.sqlite   Download  
File: db.sqlite
Role: Auxiliary data
Content type: text/plain
Description: SQLite install file
Class: Guaranix Full Text
Index text documents for full text searching
Author: By
Last change:
Date: 17 years ago
Size: 1,003 bytes
 

Contents

Class file image Download
CREATE TABLE ft_docs ( id INTEGER NOT NULL PRIMARY KEY, docid INTEGER NULL, tipo INTEGER NULL, contenido TEXT NULL ); CREATE INDEX IDX_FT_DOCS_ ON ft_docs( id ASC, docid ASC, tipo ASC ); CREATE TABLE ft_index ( docid INTEGER NULL, wordid INTEGER NULL, posicion INTEGER NULL, ranking FLOAT NULL, lang INTEGER NULL ); CREATE INDEX IDX_FT_INDEX_ ON ft_index( posicion ASC, docid ASC, wordid ASC, ranking ASC, lang ASC ); CREATE TABLE ft_lang ( id INTEGER NOT NULL PRIMARY KEY, lang VARCHAR(10) UNIQUE NOT NULL ); CREATE INDEX IDX_FT_LANG_ ON ft_lang( lang ASC ); CREATE TABLE ft_tipos ( id INTEGER NOT NULL PRIMARY KEY, titulo VARCHAR(10) UNIQUE NOT NULL ); CREATE INDEX IDX_FT_TIPOS_ ON ft_tipos( titulo ASC ); CREATE TABLE ft_word ( id INTEGER NOT NULL, word VARCHAR(30) UNIQUE NOT NULL, stemmed VARCHAR(10) NULL, lang INTEGER NULL ); CREATE INDEX IDX_FT_WORD_ ON ft_word( word ASC, stemmed ASC, lang ASC );