problem with auto increment in rails 3

hi,

     i am tried to use auto increment field for user_id field but it fails to do it     create_table :users,:id => false,:primary_key => 'user_id', :force => true do |t|       t.integer :user_id,:auto_increment => true, :null => false       t.string :name       t.string :email       t.timestamps     end

   is there any syntax to do auto increment in rails 3 ?

thanks, -Pab

i am tried to use auto increment field for user\_id field but it

fails to do it create_table :users,:id => false,:primary_key => 'user_id', :force => true do |t|

I strongly advise against doing this, your life will be much simpler if you stick with the Rails conventions and have id as the primary key.

The one reason for doing it is to use Rails with a legacy db, in which case you do not need to create the table of course.

Colin