Migrations with multi-column indexes


#1

Hey Folks,

I can’t really glean this from the documentation.

Is there a way to do: add_index(table_name, column_name, index_type)
within my migration for an index that spans multiple columns? Ie: A
covering index on FIRST_NAME, LAST_NAME or something like that?

Best,
Brian


Brian C.


#2

Brian

Try

   add_index :people [:id, :first_name, :last_name], :name =>

:people_all, :unique => true

 > Is there a way to do: add_index(table_name, column_name, 

index_type)
> within my migration for an index that spans multiple columns?
Ie: A
> covering index on FIRST_NAME, LAST_NAME or something like that?

Alain