db/migrate/20200820204041_create_ci_platform_metrics.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
25
26
27
28
29
30
31

# frozen_string_literal: true

class CreateCiPlatformMetrics < ActiveRecord::Migration[6.0]
  include Gitlab::Database::MigrationHelpers

  DOWNTIME = false
  CI_VARIABLES_KEY_INDEX_NAME = "index_ci_variables_on_key"

  disable_ddl_transaction!

  def up
    unless table_exists?(:ci_platform_metrics)
      create_table :ci_platform_metrics do |t|
        t.datetime_with_timezone :recorded_at, null: false
        t.text :platform_target, null: false
        t.integer :count, null: false
      end
    end

    add_text_limit :ci_platform_metrics, :platform_target, 255
    add_concurrent_index :ci_variables, :key, name: CI_VARIABLES_KEY_INDEX_NAME
  end

  def down
    if table_exists?(:ci_platform_metrics)
      drop_table :ci_platform_metrics
    end

    remove_concurrent_index :ci_variables, :key, name: CI_VARIABLES_KEY_INDEX_NAME
  end
end