Rails Migration for ID Column to Start at 1,000 and Autoincrement Up From There?

Question

I'd like the ID's of my Order model to start at 1000, and count up autoincrementally from there.

Can this be done via migration?

complete guess but did you try create_table :whatever_table, :id => 1000 do |t| — Kyle C, Aug 22 '12 at 15:46
Currently using Sqlite3, will be migrating to postgres soon. — Jordan Warbelow-Feldstein, Aug 22 '12 at 16:11

score 25 · Accepted Answer · edited Dec 11 '13 at 22:34

25

In your migration, after table has been created, update the sequence with something like this:

create_table :products do |t|
  t.string  :name
  # other stuff
end

# for Postgres
execute "SELECT setval('products_id_seq', 1000)"

# and for mysql ...
execute "ALTER TABLE products AUTO_INCREMENT = 1000"

edited Dec 11 '13 at 22:34

Vitor Arimitsu

168
2
7

answered Aug 22 '12 at 16:09

Serge Balyuk

3,442
1
23
23

How to assign the product table id < 1000 in this way? – William Hu Mar 26 '15 at 07:29

Kyle C · Answer 2 · 2012-08-22T16:03:58.687

0

This has not been tested and I am not sure what db you are using.

create_table(:order, :id => false) do |t|
   t.integer :id, :options => 'PRIMARY KEY', :default => 1000

or if you already have the table try this migration

def change
  execute "ALTER TABLE orders AUTO_INCREMENT = 1000"
end

edited Aug 22 '12 at 16:03

answered Aug 22 '12 at 15:54

Kyle C

4,077
2
31
34

score 0 · Answer 3 · answered Aug 02 '21 at 11:11

In case if you just need to start the ID of a table from a custom number(lets say 1001).

And you are not sure about writing migration for the same, You can run the following in the rails console:

ActiveRecord::Base.connection.execute("SELECT setval('table_name_id_seq', 1000)"

Tested worked well for me. Hope that helped.

Rails Migration for ID Column to Start at 1,000 and Autoincrement Up From There?

3 Answers3

Linked