Rake db:schema:dump doesn't produce composite primary key instructions


#1

Hey there,

I’ve adjusted some of my many to many join tables recently to use a
composite primary key based on the id’s in the two columns - instead
of using a surrogate key.

I just did a db:schema:dump, and it looks something like this:

create_table “class_members”, :id => false, :force => true do |t|
t.integer “user_id”, :default => 0, :null => false
t.integer “class_id”, :default => 0, :null => false
end

So it knows to exclude the id, but it has no information on the
primary key.

Is this a bug, or is there a good reason for it?

Cheers,

Tim.