Contents

class AddAddressFieldsToStockLocation < ActiveRecord::Migration
  def change
    remove_column :spree_stock_locations, :address_id

    add_column :spree_stock_locations, :address1, :string
    add_column :spree_stock_locations, :address2, :string
    add_column :spree_stock_locations, :city, :string
    add_column :spree_stock_locations, :state_id, :integer
    add_column :spree_stock_locations, :state_name, :string
    add_column :spree_stock_locations, :country_id, :integer
    add_column :spree_stock_locations, :zipcode, :string
    add_column :spree_stock_locations, :phone, :string


    usa = Spree::Country.where(:iso => 'US').first
    # In case USA isn't found.
    # See https://github.com/spree/spree/issues/3115
    country = usa || Spree::Country.first
    Spree::Country.reset_column_information
    Spree::StockLocation.update_all(:country_id => country)
  end
end

Version data entries

7 entries across 7 versions & 1 rubygems

Version	Path
solidus_core-1.2.3	db/migrate/20130306181701_add_address_fields_to_stock_location.rb
solidus_core-1.2.2	db/migrate/20130306181701_add_address_fields_to_stock_location.rb
solidus_core-1.2.1	db/migrate/20130306181701_add_address_fields_to_stock_location.rb
solidus_core-1.2.0	db/migrate/20130306181701_add_address_fields_to_stock_location.rb
solidus_core-1.2.0.rc2	db/migrate/20130306181701_add_address_fields_to_stock_location.rb
solidus_core-1.2.0.rc1	db/migrate/20130306181701_add_address_fields_to_stock_location.rb
solidus_core-1.2.0.beta1	db/migrate/20130306181701_add_address_fields_to_stock_location.rb