[Erp5-dev] Creating a new index

[Jean-Paul Smets]

Le Mardi 6 Décembre 2005 21:09, Rafael Monnerat a écrit :
> How can I create a new index on portal_catalog? (The index is the
> SearchableText....)
>
> Anyone?
>

The SearchableText index is provided by a table named "Compatibility" which 
is not set by default. If you set up ("properties" tab) the catalog in such 
way that this table is used for indexing, then the index will be available. 

The compatibility table is used to provide compatibility with CMF. I suggest 
that you use  full text search index (which requires MyISAM on that table 
only with MySQL) on the SearchableText column.

>
> --
> Rafael M. Monnerat
> http://monnerat.objectis.net


FYI: here is the description of that table:

# Host:
# Database: test
# Table: 'compatibility'
#
CREATE TABLE `compatibility` (
  `uid` BIGINT UNSIGNED NOT NULL,
  `Creator` varchar(255) default '',
  `Date` datetime default '0000-00-00 00:00:00',
  `PrincipiaSearchSource` text,
  `SearchableText` text,
  `CreationDate` datetime default '0000-00-00 00:00:00',
  `EffectiveDate` datetime default '0000-00-00 00:00:00',
  `ExpiresDate` datetime default '0000-00-00 00:00:00',
  `ModificationDate` datetime default '0000-00-00 00:00:00',
  `Type` varchar(255) default '',
  `bobobase_modification_time` datetime default '0000-00-00 00:00:00',
  `created` datetime default '0000-00-00 00:00:00',
  `effective` datetime default '0000-00-00 00:00:00',
  `expires` datetime default '0000-00-00 00:00:00',
  `getIcon` varchar(255) default '',
  `in_reply_to` varchar(255) default '',
  `modified` datetime default '0000-00-00 00:00:00',
  `review_state` varchar(255) default '',
  `summary` text,
  PRIMARY KEY  (`uid`),
  KEY `Type` (`Type`),
  KEY `review_state` (`review_state`)
) TYPE=InnoDB;


-- 
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 62 05 76 14
Nexedi: Consulting and Development of Libre / Open Source Software
http://www.nexedi.com
ERP5: Libre/ Open Source ERP Software for small and medium companies
http://www.erp5.org
Rentalinux: Desktop Linux Server
http://www.rentalinux.com