Contents

class AddFieldsToUser < ActiveRecord::Migration
  def change
    add_column :users, :first_name, :string
    add_column :users, :last_name, :string
    add_column :users, :middle_initial, :string
    add_column :users, :suffix, :string
    add_column :users, :work_email, :string
    add_column :users, :employee_number, :string
    add_column :users, :employee_id, :string
    add_column :users, :work_address, :string
    add_column :users, :work_city, :string
    add_column :users, :work_state, :string
    add_column :users, :work_postal, :string
    add_column :users, :work_county, :string
    add_column :users, :home_address, :string
    add_column :users, :home_city, :string
    add_column :users, :home_state, :string
    add_column :users, :home_postal, :string
    add_column :users, :home_county, :string
    add_column :users, :work_phone, :string
    add_column :users, :home_phone, :string
    add_column :users, :department_code, :string
    add_column :users, :department_name, :string
    add_column :users, :cost_center_cost, :string
    add_column :users, :user_name, :string
    add_column :users, :job_title, :string
    add_column :users, :date_of_hire, :date
    add_column :users, :date_of_rehire, :date
    add_column :users, :date_of_birth, :date
    add_column :users, :preferred_language, :string
    add_column :users, :user_type, :string
    add_column :users, :employment_type, :string
    add_column :users, :vip_flag, :boolean
    add_column :users, :time_offset, :integer
    add_column :users, :date_of_terminate, :date
    add_column :users, :manager_id, :integer
    add_column :users, :hierarchy_node, :string
    add_column :users, :hierarchy_node_id, :integer
  end
end

Version data entries

1 entries across 1 versions & 1 rubygems

Version	Path
raffle_v1-0.0.5	db/migrate/20130306012135_add_fields_to_user.rb