Contents

require_relative "migration_helper"

include PactBroker::MigrationHelper

Sequel.migration do
  up do
    if postgres?
      run("CREATE INDEX tags_pacticipant_id_name_version_order_desc_index ON tags (pacticipant_id, name, version_order DESC);")
      run("CREATE INDEX versions_pacticipant_id_order_desc_index ON versions (pacticipant_id, \"order\" DESC);")
    else
      alter_table(:tags) do
        add_index([:pacticipant_id, :name, :version_order], name: "tags_pacticipant_id_name_version_order_index")
      end
    end
  end

  down do
    if postgres?
      run("DROP INDEX tags_pacticipant_id_name_version_order_desc_index")
      run("DROP INDEX versions_pacticipant_id_order_desc_index")
    else
      alter_table(:tags) do
        drop_index([:pacticipant_id, :name, :version_order], name: "tags_pacticipant_id_name_version_order_index")
      end
    end
  end
end

Version data entries

45 entries across 45 versions & 1 rubygems

Version	Path
pact_broker-2.113.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.112.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.111.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.109.1	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.109.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.108.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.107.1	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.107.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.107.0.beta.1	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.106.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.105.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.104.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.103.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.102.2	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.102.1	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.102.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.101.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.100.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.99.0	db/migrations/20210206_add_index_to_tags_and_versions.rb
pact_broker-2.98.0	db/migrations/20210206_add_index_to_tags_and_versions.rb