Hi all,
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 => true
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 index.
Am I wrong? Does someone can reproduce the bug?