Sha256: af1d6aa01f76ba2ca40a4c5909f0b1336d5b4c86b8e37daf22b366c5d3420bc8

Contents?: true

Size: 501 Bytes

Versions: 22

Compression:

Stored size: 501 Bytes

Contents

# frozen_string_literal: true

class AddUniqueNameIndexes < ActiveRecord::Migration[4.2]
  def change
    add_index :switchman_shards, [:database_server_id, :name], unique: true
    add_index :switchman_shards, :database_server_id, unique: true, where: "name IS NULL", name: 'index_switchman_shards_unique_primary_shard'
    add_index :switchman_shards, "(true)", unique: true, where: "database_server_id IS NULL AND name IS NULL", name: 'index_switchman_shards_unique_primary_db_and_shard'
  end
end

Version data entries

22 entries across 22 versions & 1 rubygems

Version Path
switchman-2.2.3 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.2.2 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.2.1 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.2.0 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.1.6 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.1.5 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.1.4 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.1.3 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.1.2 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.1.1 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.1.0 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.13 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.12 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.11 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.10 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.9 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.8 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.7 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.6 db/migrate/20190114212900_add_unique_name_indexes.rb
switchman-2.0.5 db/migrate/20190114212900_add_unique_name_indexes.rb