Contents

class AddDefaultsToPeopleTypes < ActiveRecord::Migration
  def up
    change_column_null :people, :type, false, "Individual"
    change_column_default :people, :type, "Individual"

    rename_column :people, :person_type, :subtype
    change_column_null :people, :subtype, false, "Individual"
    change_column_default :people, :subtype, "Individual"

    # Update existing 'other' records to be individuals, to match new defaults.
    execute "UPDATE people SET type='Individual', subtype='Individual' WHERE subtype='Other'"
  end

  def down
    change_column_null :people, :subtype, true
    rename_column :people, :subtype, :person_type
    change_column_null :people, :type, true

    # Default values can't be taken off in rails yet!
  end
end

Version data entries

32 entries across 32 versions & 1 rubygems

Version	Path
artfully_ose-1.3.0.pre4	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.3.0.pre3	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.3.0.pre2	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.3.0.pre1	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.beta.1	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.alpha.2	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.alpha.1	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.27	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.26	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.24	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.23	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.21	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.20	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.19	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.18	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.17	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.16	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.15	db/migrate/20130531180955_add_defaults_to_people_types.rb
artfully_ose-1.2.0.pre.12	db/migrate/20130531180955_add_defaults_to_people_types.rb