Tim Haines
2009-May-26 05:42 UTC
rake db:schema:dump doesn''t produce composite primary key instructions
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.
