multiple field unique indexes about ruckusing-migrations HOT 3 CLOSED

Looks like a standard create index. So in SQL it would be:

CREATE UNIQUE INDEX my_index_name ON tablename(columnname, id2);

Which in Ruckusing translates to:

$this->add_index('tablename', array('columnname', 'id2'), array('unique' => true));

So you were very close - you just needed the array() around the 2nd argument to encapsulate that its a multi-column index.

On May 28, 2013, at 12:07 PM, Andrew Colchagoff [email protected] wrote:

I need to do something like this:

alter table tablename add unique index(columnname, id2);

but I can't seem to figure out how to do it without using an execute..

maybe something like this?

$this->add_index("customers", "columnname, id2", array("unique" => true));

—
Reply to this email directly or view it on GitHub.

from ruckusing-migrations.

okay, cool, Is this in the documentation? i couldn't seem to find it.

from ruckusing-migrations.

Sort of, its a combo of Example B & D from:

https://github.com/ruckus/ruckusing-migrations#adding-a-new-index

from ruckusing-migrations.