Login   Register  
PHP Classes
elePHPant
Icontem

File: db.mysql

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.mysql  >  Download  
File: db.mysql
Role: Auxiliary data
Content type: text/plain
Description: Mysql Install File
Class: Guaranix Full Text
Index text documents for full text searching
Author: By
Last change: To make up an error with the table SQL.
Date: 2006-09-04 08:39
Size: 1,166 bytes
 

Contents

Class file image Download
CREATE TABLE ft_docs (
  id int(11) NOT NULL auto_increment,
  docid int(11) NOT NULL default '0',
  tipo int(2) NOT NULL default '0',
  contenido longtext  NOT NULL,
  PRIMARY KEY  (id),
  KEY `type` (tipo),
  KEY docid (docid)
);


CREATE TABLE ft_index (
  docid int(11) NOT NULL default '0',
  wordid int(11) NOT NULL default '0',
  posicion int(11) NOT NULL default '0',
  ranking float NOT NULL default '0',
  lang int(11) NOT NULL default '0',
  KEY docid (docid,wordid,posicion,ranking),
  KEY lang (lang)
);


CREATE TABLE ft_lang (
  id int(11) NOT NULL auto_increment,
  lang varchar(10)  NOT NULL default '',
  PRIMARY KEY  (id),
  KEY lang (lang)
) ;

CREATE TABLE ft_tipos (
  id int(11) NOT NULL auto_increment,
  titulo varchar(50)  NOT NULL default '',
  PRIMARY KEY  (id),
  KEY titulo (titulo)
) ;

CREATE TABLE `ft_word` (
  `id` int(11) NOT NULL auto_increment,
  `word` varchar(30) NOT NULL default '',
  `stemmed` varchar(50) NOT NULL default '',
  `lang` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `word` (`word`),
  KEY `stemmed` (`stemmed`),
  KEY `lang` (`lang`)
) TYPE=MyISAM