Sugar Developer Guide Version 5.1

Indices Array

This array contains a list of arrays that are used to create indexes in the database. The fields in this array are:

o	'name' = The name of the index. This must be unique in most databases.

o	'type' = The type of the index (primary, unique, or index)

o	'fields' = The fields to index. This is an ordered array.

The following example is to create a primary index called 'userspk' on the 'id' column

array('name' =>'userspk', 'type' =>'primary', 'fields'=>array('id')),