Contents

class CreateAddresses < ActiveRecord::Migration
  def self.up
    create_table :addresses do |t|
      t.string :street1
      t.string :street2
      t.string :city,    limit: 64
      t.string :state,   limit: 64
      t.string :zipcode, limit: 16
      t.string :country, limit: 64
      t.string :full_address
      t.string :address_type, limit: 16

      t.references :addressable, polymorphic: true

      t.timestamps
      t.datetime :deleted_at
    end

    add_index :addresses, [:addressable_id, :addressable_type]

    # Migrate data from assets to Address table into full_address blob
    Contact.all.each do |asset|
      Address.create(street1: asset.address, full_address: asset.address, address_type: "Business", addressable: asset)
    end

    Account.all.each do |asset|
      Address.create(street1: asset.billing_address, full_address: asset.billing_address, address_type: "Billing", addressable: asset)
      Address.create(street1: asset.shipping_address, full_address: asset.shipping_address, address_type: "Shipping", addressable: asset)
    end

    Lead.all.each do |asset|
      Address.create(street1: asset.address, full_address: asset.address, address_type: "Business", addressable: asset)
    end

    # Remove addresses columns from assets allready migrated
    remove_column(:contacts, :address)
    remove_column(:accounts, :billing_address)
    remove_column(:accounts, :shipping_address)
    remove_column(:leads,    :address)
  end

  def self.down
    drop_table :addresses
    add_column(:contacts, :address, :string)
    add_column(:accounts, :billing_address, :string)
    add_column(:accounts, :shipping_address, :string)
    add_column(:leads,    :address, :string)
  end
end

Version data entries

7 entries across 7 versions & 2 rubygems

Version	Path
fat_free_crm-0.14.2	db/migrate/20100928030623_create_addresses.rb
fat_free_crm-0.14.1	db/migrate/20100928030623_create_addresses.rb
fat_free_crm-0.15.0.beta.2	db/migrate/20100928030623_create_addresses.rb
fat_free_crm-0.15.0.beta	db/migrate/20100928030623_create_addresses.rb
fat_free_crm-0.14.0	db/migrate/20100928030623_create_addresses.rb
reduced_fat_crm-0.15.0.beta	db/migrate/20100928030623_create_addresses.rb
reduced_fat_crm-0.14.0	db/migrate/20100928030623_create_addresses.rb