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

158 entries across 158 versions & 1 rubygems

Version	Path
pact_broker-2.23.3	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.23.2	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.23.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.23.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.22.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.21.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.20.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.19.2	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.19.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.19.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.18.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.17.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.17.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.16.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.16.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.15.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.14.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.13.1	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.13.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb
pact_broker-2.12.0	db/migrations/000016_add_pact_content_foreign_key_to_pacts.rb