20190225160301_add_runner_tokens_indexes.rb 723 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
# frozen_string_literal: true

class AddRunnerTokensIndexes < ActiveRecord::Migration[5.0]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false

  disable_ddl_transaction!

  # It seems that `ci_runners.token_encrypted` and `projects.runners_token_encrypted`
  # are non-unique

  def up
    add_concurrent_index :ci_runners, :token_encrypted
    add_concurrent_index :projects, :runners_token_encrypted
    add_concurrent_index :namespaces, :runners_token_encrypted, unique: true
  end

  def down
    remove_concurrent_index :ci_runners, :token_encrypted
    remove_concurrent_index :projects, :runners_token_encrypted
    remove_concurrent_index :namespaces, :runners_token_encrypted, unique: true
  end
end