How to turn off auto_increment in Rails Active Record

Question

Is it possible to create primary key without auto_increment flag in ActiveRecord?

I can't do

create table :blah, :id => false

because I want to have primary key index on the column. I looked up documentation but didn't find anything useful.

Is it possible to create primary key without auto_increment?

Answer 1

Try this?

create_table(:table_name, :id => false) do |t|
  t.integer :id, :options => 'PRIMARY KEY'
end

Answer 2

That didn't work for me, but the following did:

create_table(:table_name, :id => false) do |t|
  t.column :id, 'int(11) PRIMARY KEY'
end

Only problem is that you lose it in the schema.rb.