Contents

class AddZoneTypeToSpreeZoneMembers < ActiveRecord::Migration
  def up
    add_column :spree_zone_members, :zone_type, :text unless column_exists?(:spree_zone_members, :zone_type)

    unless index_exists?(:spree_zone_members, %i[zone_id zone_type])
      add_index :spree_zone_members, %i[zone_id zone_type],
                name: "index_spree_zone_members_on_zone_id_and_zone_type", using: :btree
    end

    if index_exists?(:spree_zone_members, name: "index_spree_zone_members_on_zone_id")
      remove_index :spree_zone_members, name: "index_spree_zone_members_on_zone_id"
    end
  end

  def down
    add_index :spree_zone_members, :zone_id unless index_exists?(:spree_zone_members, :zone_id)

    if index_exists?(:spree_zone_members, %i[zone_id zone_type])
      remove_index :spree_zone_members, name: "index_spree_zone_members_on_zone_id_and_zone_type"
    end

    remove_column :spree_zone_members, :zone_type if column_exists?(:spree_zone_members, :zone_type)
  end
end

Version data entries

22 entries across 22 versions & 1 rubygems

Version	Path
flowcommerce_spree-0.0.22	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.21	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.20	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.19	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.18	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.17	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.16	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.15	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.14	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.13	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.12	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.11	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.10	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.9	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.8	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.7	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.6	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.5	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.4	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb
flowcommerce_spree-0.0.3	db/migrate/20201022173210_add_zone_type_to_spree_zone_members.rb