[Erp5-dev] Creating a new index

[Rafael Monnerat]

How can I create a new index on portal_catalog? (The index is the
SearchableText....)

Anyone?


--
Rafael M. Monnerat
http://monnerat.objectis.net
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20051206/7169ab70/attachment.htm>

[Jean-Paul Smets]

Post by Rafael Monnerat
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.

Post by Rafael Monnerat
--
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]

Post by Rafael Monnerat
How can I create a new index on portal_catalog? (The index is the
SearchableText....)
Anyone?

BTW, another solution is to change Z SQL Method such as z_create_catalog as
well as all associated methods to include that column
(z_catalog_object_list, z_uncatalog_object)

Post by Rafael Monnerat
--
Rafael M. Monnerat
http://monnerat.objectis.net