summaryrefslogtreecommitdiff
path: root/db/migrate/20191205060723_add_index_to_keys.rb
blob: 8e8c725f62e3326f897440fcf2c2a25fe50b6a7b (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
# frozen_string_literal: true

class AddIndexToKeys < ActiveRecord::Migration[5.2]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  disable_ddl_transaction!

  def up
    add_concurrent_index :keys, :last_used_at, order: { last_used_at: 'DESC NULLS LAST' }
  end

  def down
    remove_concurrent_index :keys, :last_used_at
  end
end