Rails Ruby on Rails → 2.x

I use Rails 2.2.2 with sqlite3 3.5.6 under Vista.

Firstly I created a table without id, but later I found it wasn't good idea and I wanted to add id column with migration:

class AddIdToPersonRelation < ActiveRecord::Migration def self.up

add_column :person_relations, :id, :integer

end

def self.down

remove_column :person_relations, :id

end end

Then I run migration: rake db:migrate And I found that Rails didn't set id field as primary key, so when I added something to the table, id was set to nil. It wasn't what I expected.

Then I run: rake db:schema:load And it created all tables again and person_relations table had correct primary key.

I think that both methods (db:migrate and db:schema:load) should give the same results.

Maybe I am wrong (I am new in ruby and rails).