##add cloumn to rails
rails g migration AddStatusToUsers
class AddStatusToUser < ActiveRecord::Migration
def change
#add_column :table_name, :column_name, :type, default: "Your value"
add_cloumn :users,:status,:string
end
end
###############change column names to rails
rails g migration ChangeNameToUsers
class RenameStatusToUser < ActiveRecord::Migration
def change
#rename_column :table_name, :old_column1, :new_column1
rename_column :users,:name,:full_name
end
end
(or)
class RenameStatusToUser < ActiveRecord::Migration
def change
change_table :table_name do |t|
t.rename :old_column1, :new_column1
t.rename :old_column2, :new_column2
end
end
########ROR migration change a column type from Date to DateTime
rails g migration change_date_format_in_my_table
class ChangeFormatInUser< ActiveRecord::Migration
def change
#change_column :my_table, :my_column, :my_new_type
change_column :users
end
end
##for rails2 adding column
ruby script/generate migration AddIsAdminToUsers
class AddIsAdminToUser < ActiveRecord::Migration
def self.up
add_column :users, :is_admin, :boolean, :default=>false, :null=>false
end
def self.down
remove_column :users, :is_admin
end
end
rails g migration AddStatusToUsers
class AddStatusToUser < ActiveRecord::Migration
def change
#add_column :table_name, :column_name, :type, default: "Your value"
add_cloumn :users,:status,:string
end
end
###############change column names to rails
rails g migration ChangeNameToUsers
class RenameStatusToUser < ActiveRecord::Migration
def change
#rename_column :table_name, :old_column1, :new_column1
rename_column :users,:name,:full_name
end
end
(or)
class RenameStatusToUser < ActiveRecord::Migration
def change
change_table :table_name do |t|
t.rename :old_column1, :new_column1
t.rename :old_column2, :new_column2
end
end
########ROR migration change a column type from Date to DateTime
rails g migration change_date_format_in_my_table
class ChangeFormatInUser< ActiveRecord::Migration
def change
#change_column :my_table, :my_column, :my_new_type
change_column :users
end
end
##for rails2 adding column
ruby script/generate migration AddIsAdminToUsers
class AddIsAdminToUser < ActiveRecord::Migration
def self.up
add_column :users, :is_admin, :boolean, :default=>false, :null=>false
end
def self.down
remove_column :users, :is_admin
end
end
Comments
Post a Comment