Contents

Sequel.migration do
  up do
    # Have not created indexes on the consumer_id or provider_id because the table is likely to be small
    # (in the 10s or 100s) and it would probably just do a full table scan anyway.
    create_table(:temp_integrations, charset: "utf8") do
      primary_key :id, primary_key_constraint_name: "integrations_pkey"
      foreign_key(:consumer_id, :pacticipants, null: false, on_delete: :cascade, foreign_key_constraint_name: "integrations_consumer_id_foreign_key")
      foreign_key(:provider_id, :pacticipants, null: false, on_delete: :cascade, foreign_key_constraint_name: "integrations_provider_id_foreign_key")
      String :consumer_name
      String :provider_name
      DateTime :created_at, null: false
      index([:consumer_id, :provider_id], unique: true, name: "integrations_consumer_id_provider_id_unique")
    end

    # TODO drop these columns
    # They are just for backwards compatiblity during schema migrations
    # alter_table(:integrations) do
    #   drop_column(:consumer_name)
    #   drop_column(:provider_name)
    # end
  end

  down do
    drop_table(:temp_integrations)
  end
end

Version data entries

33 entries across 33 versions & 1 rubygems

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