19 July 2010 at 6:54am
(Last edited: 20 July 2010 7:05am),
Simple question: I have added a certain index to a dataobject using the standard spec to make it unique on multiple columns. However, I cannot find how to give the index a name, it seems to default to a number.
static $indexes = array(
'Name' => true, //just make in an index for quick lookups
'Type' => 'Unique', //make it a unique index
'Description' => 'FullText' //full text index for the field for searching
Any field you want to make an index has to be defined in $db - Although theorectically you could also use a field that had been defined via a $has_one / $has_many / etc relationship.
I havent seen your indexes notation (nested arrays) to assign indexes before, but that doesn't mean it isn't right.