how to write a migration to alter a table column from float to bigint in Rails

Question

I have data in a Users table. One column called :provider_user_id of datatype float.

I want to change it to data type bigint.

How should I write this migration in rails 3

The original column was created with the following migration:

class AddFbuidToUsers < ActiveRecord::Migration
  def self.up
    add_column :users, :provider_user_id, :float
  end

  def self.down
    remove_column :users, :provider_user_id
  end
end

Possible duplicate: stackoverflow.com/questions/2799774/…

Simon Perepelitsa
– Simon Perepelitsa

2011-12-14 11:10:28 +00:00
Commented Dec 14, 2011 at 11:10 — Simon Perepelitsa
– Simon Perepelitsa, Commented Dec 14, 2011 at 11:10

sosiouxme · Accepted Answer · 2013-05-19 17:35:17Z

5

change_column :users, :provider_user_id, :bigint

answered May 19, 2013 at 17:35

sosiouxme

1,25616 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MotownJoe · Accepted Answer · 2012-09-21 01:22:27Z

0

Add a new column of type bigint, any name will do.

Write an update loop to update each new bigint column with the value in your current column

Drop the old column (hopefully no RI on it).

Rename the new column to that of the just-dropped old column.

answered Sep 21, 2012 at 1:22

MotownJoe

785 bronze badges

Collectives™ on Stack Overflow

how to write a migration to alter a table column from float to bigint in Rails

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related