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.