require 'migrate'

class AddJoinTableBetweenUsersAndChangesets < ActiveRecord::Migration
  def change
    create_table :changesets_subscribers, id: false do |t|
      t.column :subscriber_id, :bigint, null: false
      t.column :changeset_id, :bigint, null: false
    end

    add_foreign_key :changesets_subscribers, [:subscriber_id], :users, [:id]
    add_foreign_key :changesets_subscribers, [:changeset_id], :changesets, [:id]

    add_index :changesets_subscribers, [:subscriber_id, :changeset_id], :unique => true
    add_index :changesets_subscribers, [:changeset_id]
  end
end