Login   Register  
PHP Classes
elePHPant
Icontem

File: db.sqlite

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  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: 8 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
);