summaryrefslogtreecommitdiff
path: root/db/migrate/20140914113604_add_members_table.rb
blob: 0f76bb0ef7960f4c9918b314a294e2fefc745da6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
# rubocop:disable all
class AddMembersTable < ActiveRecord::Migration
  DOWNTIME = false

  def change
    create_table :members do |t|
      t.integer :access_level, null: false
      t.integer :source_id,    null: false
      t.string  :source_type,  null: false
      t.integer :user_id,      null: false
      t.integer :notification_level, null: false
      t.string  :type

      t.timestamps null: true
    end

    add_index :members, :type
    add_index :members, :user_id
    add_index :members, :access_level
    add_index :members, [:source_id, :source_type]
  end
end