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-0.11.3	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.11.2	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.11.1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.11.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.10.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.9.2	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.9.1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.9.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.8.2	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.8.1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.8.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.7.2	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.7.1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.7.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.6.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.5.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.4.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.3.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.2.1	db/migrate/20140624135425_move_cname_from_account_to_theming.rb
pageflow-0.2.0	db/migrate/20140624135425_move_cname_from_account_to_theming.rb