Primary Keys enforcement vanishes in test database

[alan]

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

[alan]

On 10/16/07, Alan [email protected] wrote:

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?

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

[alan]

That’s the ticket!

rake db:test:clone_structure
is the successful workaround

Thanks!