Contents

class CreateUserSiteProfile < ActiveRecord::Migration
  def up
    create_table :user_site_profiles, :force => true do |t|
      t.integer     :user_id
      t.datetime    :last_access_at
      t.datetime    :created_at
      t.datetime    :updated_at
      t.integer     :account_id
    end

    User.all.find_each do |user|
      Account.current = Account.find(user.account_id)
      p = user.user_site_profiles.create
      p.update_attribute(:account_id, user.attributes['account_id']) 
      p.update_attribute(:last_access_at, user.user_profile.attributes['last_access_at'])
      p.update_attribute(:created_at, user.attributes['created_at'])
      p.update_attribute(:updated_at, user.attributes['updated_at'])
    end
    remove_column  :user_profiles, :last_access_at
  end

  def down
    drop_table  :user_site_profiles
    add_column  :user_profiles, :last_access_at, :datetime
  end
end

Version data entries

16 entries across 16 versions & 1 rubygems

Version	Path
dm_core-4.2.3.10	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.9	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.8	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.7	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.6	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.5	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.4	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.3	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.2	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3.1	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.3	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.2.3	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.2.2	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.2.1	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.2	db/migrate/20130628112848_create_user_site_profile.rb
dm_core-4.2.1.5	db/migrate/20130628112848_create_user_site_profile.rb