I think there's a bug in rake db:schema:dump.
Try to add in your migration
execute 'ALTER TABLE posts ADD UNIQUE (description(15))'
and rake db:schema:load : it just converts it to
add_index "posts", ["description"], :name => "description", :unique =>
The point is that MySQL will crash when you'll try rake your tests.
Assuming description is a 'text', you need to specify length of the
Am I wrong? Does someone can reproduce the bug?