Contents

Sequel.migration do
  up do
    create_table(:pact_version_provider_tag_successful_verifications, charset: "utf8") do
      primary_key :id
      foreign_key :pact_version_id, :pact_versions, null: false, on_delete: :cascade, foreign_key_constraint_name: "pact_version_provider_tag_successful_verifications_pv_id_fk"
      String :provider_version_tag_name, null: false
      Boolean :wip, null: false
      Integer :verification_id
      DateTime :execution_date, null: false
      index([:pact_version_id, :provider_version_tag_name, :wip], unique: true, name: "pact_version_provider_tag_verifications_pv_pvtn_wip_unique")
      # The implication of the on_delete: :set_null for verification_id is
      # that even if the verification result is deleted from the broker,
      # the wip/pending status stays the same.
      # We may or may not want this. Will have to wait and see.
      # Have made the foreign key a separate declaration so it can more easily be remade.
      foreign_key([:verification_id], :verifications, on_delete: :set_null, name: "pact_version_provider_tag_successful_verifications_v_id_fk")
    end
  end

  down do
    drop_table(:pact_version_provider_tag_successful_verifications)
  end
end

Version data entries

30 entries across 30 versions & 1 rubygems

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