Contents

require "digest/sha1"
require_relative "migration_helper"

Sequel.migration do
  change do

    PactBroker::MigrationHelper.with_mysql do
      # Needed to make FK pact_version_content_sha match encoding of pact_version_content ID
      run("ALTER TABLE pacts CONVERT TO CHARACTER SET 'utf8';")
    end

    alter_table(:pacts) do
      add_foreign_key :pact_version_content_sha, :pact_version_contents, type: String, null: true, foreign_key_constraint_name: "fk_pact_version_content"
    end
  end
end

Version data entries

48 entries across 48 versions & 1 rubygems

Version	Path
pact_broker-2.114.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.113.2	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.113.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.113.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.112.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.111.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.109.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.109.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.108.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.107.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.107.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.107.0.beta.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.106.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.105.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.104.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.103.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.102.2	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.102.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.102.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.101.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb