Primary Keys enforcement vanishes in test database

rubyonrails-talk
1

I use this naming convention for primary keys:

ActiveRecord::Base.primary_key_prefix_type = :table_name_with_underscore

I generate the MySQL test database: rake db:test:prepare, and although the column is there there is no primary key enforcement/index and no autoincrement (so activerecord saves fail). Is this a bug? What is the best workaround?

Alan

2

Looks like a bug: http://dev.rubyonrails.org/ticket/7085

Does using rake db:test:clone_structure do the job? see http://brighter.net/2007/8/15/keeping-your-test-db-in-sync

3

That's the ticket!

rake db:test:clone_structure is the successful workaround

Thanks!