Contents

Sequel.migration do
  up do
    # removing this as it has been replaced by materialized_head_matrix
    drop_table(:materialized_latest_matrix)
  end

  down do
    create_table(:materialized_latest_matrix, charset: 'utf8') do
      Integer :consumer_id, null: false
      String :consumer_name, null: false
      Integer :consumer_version_id, null: false
      String :consumer_version_number, null: false
      Integer :consumer_version_order, null: false
      Integer :pact_publication_id, null: false
      Integer :pact_version_id, null: false
      String :pact_version_sha, null: false
      Integer :pact_revision_number, null: false
      DateTime :pact_created_at, null: false
      Integer :provider_id, null: false
      String :provider_name, null: false
      Integer :provider_version_id
      String :provider_version_number
      Integer :provider_version_order
      Integer :verification_id
      Boolean :success
      Integer :verification_number
      DateTime :verification_executed_at
      String :verification_build_url
      index [:consumer_id], name: 'ndx_mlm_consumer_id'
      index [:provider_id], name: 'ndx_mlm_provider_id'
      index [:consumer_version_order], name: 'ndx_mlm_cv_ord'
    end

    from(:materialized_latest_matrix).insert(from(:latest_matrix).select_all)
  end
end

Version data entries

95 entries across 95 versions & 1 rubygems

Version	Path
pact_broker-2.79.1	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.79.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.78.1	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.78.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.77.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.76.2	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.76.1	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.76.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.75.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.74.1	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.74.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.73.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.72.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.71.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.70.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.69.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.68.1	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.68.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.67.0	db/migrations/20180205_drop_materialized_latest_matrix.rb
pact_broker-2.66.0	db/migrations/20180205_drop_materialized_latest_matrix.rb