db/migrate/20190225160301_add_runner_tokens_indexes.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

# 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