CODEWITHSUNDEEP
ruby-on-rails
RewbieNewbie
RewbieNewbie

Reputation: 299

How to specify :primary_key starting value in rails schema migration?

I have a postgres table and a schema that creates a primary id (sequence) that auto increments by 1. How do I specify the starting value? I am happy with the increment value. Here is my schema migration:

create_table "ServiceProvider", {:primary_key => :ID} do |t|
  t.integer "ID",                       :null => false
end

Thank you

Upvotes: 1

Views: 374

Answers (1)

marcgg
marcgg

Reputation: 66436

Use this option :

create_table "ServiceProvider",:options => "AUTO_INCREMENT = 1234" do |t|
  ...
end

But be carefull, this wouldn't work with ALL database management systems. I know this should work with MySQL but you might want to double check for postgres.

Upvotes: 2

Related Questions