summaryrefslogtreecommitdiff
path: root/db/migrate/20140914113604_add_members_table.rb
blob: 312ea1b94df6c8ae09e1775b83f7a0a9d3068222 (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[4.2]
  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