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
_______________________________________________
phpGroupWare-developers mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
