Re: [phpGroupWare-developers] db-index

[Sigurd Nes]

Dave Hall wrote:
> On Mon, 2007-12-24 at 23:39 +0100, Sigurd Nes wrote:
>> For proper index definitions - one needs one array of columns per index - 
>> right ?
>>
>> As it is currently implemented - it looks like only one index is supported 
>> by the setup process.
>> example from the table 'phpgw_contact_comm':
>>
>> 'ix' => array('comm_data','preferred','comm_descr_id','contact_id')
> 
> It does allow multiple indexes with groupings.  It works like this
> 
> 'ix' => array('col1', array('col2', 'col3'), 'col5')
> 
> In this example 3 indexes will be created
> 
> col1 by itself
> col2 and col3 together
> col5 by itself
> 
> see phpgwapi_schema_proc::_GetIX for how it works :)
> 
> Cheers
> 
> Dave
Ah - thanks

Sigurd