Contents

class AddStockItemUniqueIndex < ActiveRecord::Migration
  def change
    # Add a database-level uniqueness constraint for databases that support it
    # (postgres & sqlite)
    if connection.adapter_name =~ /postgres|sqlite/i
      add_index 'spree_stock_items', ['variant_id', 'stock_location_id'], where: 'deleted_at is null', unique: true
    end
  end
end

Version data entries

8 entries across 8 versions & 1 rubygems

Version	Path
solidus_core-1.2.3	db/migrate/20151219020209_add_stock_item_unique_index.rb
solidus_core-1.3.0.beta1	db/migrate/20151219020209_add_stock_item_unique_index.rb
solidus_core-1.2.2	db/migrate/20151219020209_add_stock_item_unique_index.rb
solidus_core-1.2.1	db/migrate/20151219020209_add_stock_item_unique_index.rb
solidus_core-1.2.0	db/migrate/20151219020209_add_stock_item_unique_index.rb
solidus_core-1.2.0.rc2	db/migrate/20151219020209_add_stock_item_unique_index.rb
solidus_core-1.2.0.rc1	db/migrate/20151219020209_add_stock_item_unique_index.rb
solidus_core-1.2.0.beta1	db/migrate/20151219020209_add_stock_item_unique_index.rb