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