summaryrefslogtreecommitdiff
path: root/db/migrate/20190905074652_index_timestamp_columns_for_issue_metrics.rb
blob: e468b2decd9949785b772ff6f54bb531b9da1e16 (plain)
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
# frozen_string_literal: true

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

  DOWNTIME = false

  disable_ddl_transaction!

  def up
    add_concurrent_index(*index_arguments)
  end

  def down
    remove_concurrent_index(*index_arguments)
  end

  private

  def index_arguments
    [
      :issue_metrics,
      [:issue_id, :first_mentioned_in_commit_at, :first_associated_with_milestone_at, :first_added_to_board_at],
      {
        name: 'index_issue_metrics_on_issue_id_and_timestamps'
      }
    ]
  end
end