Contents

require_relative "migration_helper"

include PactBroker::MigrationHelper

Sequel.migration do
  up do
    # MySQL automatically creates indexes for foreign keys then complains if you
    # re-create it with a different name and try to drop it.

    # https://stackoverflow.com/a/52274628/832671 - "When there is only one index that can be used
    # for the foreign key, it can't be dropped. If you really wan't to drop it, you either have to drop
    # the foreign key constraint or to create another index for it first."
    if !mysql?
      alter_table(:verifications) do
        add_index([:provider_version_id], name: "verifications_provider_version_id_index")
      end
    end

  end

  down do
    if !mysql?
      alter_table(:verifications) do
        drop_index([:provider_version_id], name: "verifications_provider_version_id_index")
      end
    end
  end
end

Version data entries

13 entries across 13 versions & 1 rubygems

Version	Path
pact_broker-2.114.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.113.2	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.113.1	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.113.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.112.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.111.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.109.1	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.109.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.108.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.107.1	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.107.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.107.0.beta.1	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb
pact_broker-2.106.0	db/migrations/20221130_add_provider_version_id_index_to_verifications.rb