[openstreetmap-website] Changeset discussion feature (#772)

[Paul Norman]

> @@ -0,0 +1,11 @@
> +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

My understanding is you want the more selective first in composite indexes, which probably means a unique index on ``[:changeset_id, :subscriber_id]`` and ``[:subscriber_id]`` for the other.

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/openstreetmap-website/pull/772/files#r15546822
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/rails-dev/attachments/20140729/c8117a8d/attachment.html>