Index key length in migration

[pelle]

Index key length in migration

[wakiki]

This is the way to do it in ruby (It maintains the token length as 1024 but restricts the index to 767.

create_table "consumer_tokens", :force => true do |t|
t.integer "person_id"
t.string "type", :limit => 30
t.string "token", :limit => 1024
t.string "secret"
t.datetime "created_at"
t.datetime "updated_at"
t.string "account"
end

add_index "consumer_tokens", ["token"], :name => "index_consumer_tokens_on_token", :length => {"token"=>"767"}

[hainesr]

I know this is very old, but I came across issue while searching for the solution to the same problem.

I see this problem when I develop using SQLite and use MySQL in production. A schema dumped via the sqlite gem doesn't include the :length option but a schema dumped with the mysql gem does, so moving between the two shows this issue up.