Contents

Sequel.migration do
  change do
    create_table(:branches, charset: "utf8") do
      primary_key :id
      String :name
      foreign_key :pacticipant_id, :pacticipants, null: false, on_delete: :cascade
      DateTime :created_at, null: false
      DateTime :updated_at, null: false
      index [:pacticipant_id, :name], unique: true, name: :branches_pacticipant_id_name_index
    end

    create_table(:branch_versions, charset: "utf8") do
      primary_key :id
      foreign_key :branch_id, :branches, null: false, foreign_key_constraint_name: :branch_versions_branches_fk, on_delete: :cascade
      foreign_key :version_id, :versions, null: false, foreign_key_constraint_name: :branch_versions_versions_fk, on_delete: :cascade
      Integer :version_order, null: false
      Integer :pacticipant_id, null: false
      String :branch_name, null: false
      DateTime :created_at, null: false
      DateTime :updated_at, null: false
      index [:branch_id, :version_id], unique: true, name: :branch_versions_branch_id_version_id_index
      index [:version_id], name: :branch_versions_version_id_index
      index [:branch_name], name: :branch_versions_branch_name_index
      # Can probably drop this index when the "latest pact" logic changes
      index [:pacticipant_id, :branch_id, :version_order], name: :branch_versions_pacticipant_id_branch_id_version_order_index
    end

    create_table(:branch_heads) do
      foreign_key :branch_id, :branches, null: false, on_delete: :cascade
      foreign_key :branch_version_id, :branch_versions, null: false, on_delete: :cascade
      Integer :version_id, null: false
      Integer :pacticipant_id, null: false
      String :branch_name, null: false
      index [:branch_id], unique: true, name: :branch_heads_branch_id_index
      index [:branch_name], name: :branch_heads_branch_name_index
      index [:pacticipant_id], name: :branch_heads_pacticipant_id_index
      index [:version_id], name: :branch_heads_version_id_index
    end
  end
end

Version data entries

41 entries across 41 versions & 1 rubygems

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