Contents

class MoveCnameFromAccountToTheming < ActiveRecord::Migration
  def up
    add_column :pageflow_themings, :cname, :string, null: false, default: ''
    add_index :pageflow_themings, :cname

    execute("UPDATE pageflow_themings SET cname = (SELECT cname FROM pageflow_accounts WHERE pageflow_accounts.default_theming_id = pageflow_themings.id LIMIT 1);")

    remove_index :pageflow_accounts, :cname
    remove_column :pageflow_accounts, :cname
  end

  def down
    add_column :pageflow_accounts, :cname, :string, null: false, default: ''
    add_index :pageflow_accounts, :cname

    execute("UPDATE pageflow_accounts SET cname = (SELECT cname FROM pageflow_themings WHERE pageflow_themings.id = pageflow_accounts.default_theming_id);")

    remove_index :pageflow_themings, :cname
    remove_column :pageflow_themings, :cname
  end
end

Version data entries

40 entries across 40 versions & 1 rubygems

Version	Path
pageflow-12.6.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.5.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.4.1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.4.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.3.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.2.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.1.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.4	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.3	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.2	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0.rc7	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0.rc6	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.11.4	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0.rc5	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0.rc4	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0.rc3	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0.rc2	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-12.0.0.rc1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb