20161113184239_create_user_chat_names_table.rb 644 Bytes
Newer Older
1
# rubocop:disable Migration/Timestamps
2
class CreateUserChatNamesTable < ActiveRecord::Migration[4.2]
3 4 5 6 7 8
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  def change
    create_table :chat_names do |t|
9 10 11 12 13 14
      t.integer :user_id, null: false
      t.integer :service_id, null: false
      t.string :team_id, null: false
      t.string :team_domain
      t.string :chat_id, null: false
      t.string :chat_name
15
      t.datetime :last_used_at
16
      t.timestamps null: false
17 18 19 20 21 22
    end

    add_index :chat_names, [:user_id, :service_id], unique: true
    add_index :chat_names, [:service_id, :team_id, :chat_id], unique: true
  end
end