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
|