Re: [phpGroupWare-developers] db-index

[Dave Hall]

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
-- 
Dave Hall (aka skwashd)
API Coordinator
phpGroupWare
e address@hidden
w phpgroupware.org
j address@hidden
sip address@hidden
       _            ____                    __        __             
 _ __ | |__  _ __  / ___|_ __ ___  _   _ _ _\ \      / /_ _ _ __ ___ 
| '_ \| '_ \| '_ \| |  _| '__/ _ \| | | | '_ \ \ /\ / / _` | '__/ _ \
| |_) | | | | |_) | |_| | | | (_) | |_| | |_) \ V  V / (_| | | |  __/
| .__/|_| |_| .__/ \____|_|  \___/ \__,_| .__/ \_/\_/ \__,_|_|  \___|
|_|         |_|                         |_|Web based collaboration platform