How to change primary key in rails migration file?

ruby-on-rails database-migration rails-migrations
Wint picture Wint · Mar 25, 2013 · Viewed 16.5k times · Source

I need to migrate an old mysql table like this:

Products
  name (string, primary_key)

to this schema:

Products
  id (integer, primary_key, auto_generated)
  name (unique)

I need the Products.id values populated in the new table. How can i write the rails migration file? I am using Rails 3.2.7

I have 2 problems now: 1. I can't find a method to remove primary key in ActiveRecord::Migration 2. I don't know how to generate values for newly added primary key.

Answer

Jordan Allan picture Jordan Allan · Mar 25, 2013

You could execute arbitrary SQL in your migration:

execute "ALTER TABLE `products` DROP PRIMARY KEY"

and then add the new column:

add_column :products, :id, :primary_key

See:

Remove Primary Key in MySQL

how to add a primary key to a table in rails

http://thinkwhere.wordpress.com/2009/05/09/adding-a-primary-key-id-to-table-in-rails/

http://api.rubyonrails.org/classes/ActiveRecord/Migration.html

Related questions

Rails migration does not change schema.rb

I have a rails migration that is not being applied to my schema.rb. The migration should create a table: class CreateUserGraphs < ActiveRecord::Migration def change create_table :user_graphs do |t| t.string :name t.string :content t.…

Read More
Running migrations with Rails in a Docker container with multiple container instances

I've seen lots of examples of making Docker containers for Rails applications. Typically they run a rails server and have a CMD that runs migrations/setup then brings up the Rails server. If I'm spawning 5 of these containers at the …

Read More
Change foreign key column name in rails

I have a Project migration class like this: class CreateProjects < ActiveRecord::Migration def change create_table :projects do |t| t.string :title t.text :description t.boolean :public t.references :user, index: true, foreign_key: true t.timestamps null: …

Read More