db/migrate/20180925200829_create_user_preferences.rb


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

# frozen_string_literal: true

class CreateUserPreferences < ActiveRecord::Migration
  DOWNTIME = false

  class UserPreference < ActiveRecord::Base
    self.table_name = 'user_preferences'

    NOTES_FILTERS = { all_notes: 0, comments: 1 }.freeze
  end

  def change
    create_table :user_preferences do |t|
      t.references :user,
                   null: false,
                   index: { unique: true },
                   foreign_key: { on_delete: :cascade }

      t.integer :issue_notes_filter,
                default: UserPreference::NOTES_FILTERS[:all_notes],
                null: false, limit: 2

      t.integer :merge_request_notes_filter,
                default: UserPreference::NOTES_FILTERS[:all_notes],
                null: false,
                limit: 2

      t.timestamps_with_timezone null: false
    end
  end
end