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 [EMAIL PROTECTED]
w phpgroupware.org
j [EMAIL PROTECTED]
sip [EMAIL PROTECTED]
_ ____ __ __
_ __ | |__ _ __ / ___|_ __ ___ _ _ _ _\ \ / /_ _ _ __ ___
| '_ \| '_ \| '_ \| | _| '__/ _ \| | | | '_ \ \ /\ / / _` | '__/ _ \
| |_) | | | | |_) | |_| | | | (_) | |_| | |_) \ V V / (_| | | | __/
| .__/|_| |_| .__/ \____|_| \___/ \__,_| .__/ \_/\_/ \__,_|_| \___|
|_| |_| |_|Web based collaboration platform
_______________________________________________
phpGroupWare-developers mailing list
[email protected]
http://lists.gnu.org/mailman/listinfo/phpgroupware-developers
