summaryrefslogtreecommitdiff
path: root/db/migrate/20220511090324_add_last_consistency_check_cursors_to_vsa_aggregations.rb
blob: 53c09597be50e2eabb551b3f471eecef4c7b8aeb (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
# frozen_string_literal: true

class AddLastConsistencyCheckCursorsToVsaAggregations < Gitlab::Database::Migration[2.0]
  def up
    change_table(:analytics_cycle_analytics_aggregations, bulk: true) do |t|
      t.column :last_consistency_check_issues_stage_event_hash_id, :bigint, null: true
      t.column :last_consistency_check_issues_start_event_timestamp, :datetime_with_timezone, null: true
      t.column :last_consistency_check_issues_end_event_timestamp, :datetime_with_timezone, null: true
      t.column :last_consistency_check_issues_issuable_id, :bigint, null: true

      t.column :last_consistency_check_merge_requests_stage_event_hash_id, :bigint, null: true
      t.column :last_consistency_check_merge_requests_start_event_timestamp, :datetime_with_timezone, null: true
      t.column :last_consistency_check_merge_requests_end_event_timestamp, :datetime_with_timezone, null: true
      t.column :last_consistency_check_merge_requests_issuable_id, :bigint, null: true
    end
  end

  def down
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_issues_stage_event_hash_id
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_issues_start_event_timestamp
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_issues_end_event_timestamp
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_issues_issuable_id
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_merge_requests_stage_event_hash_id
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_merge_requests_start_event_timestamp
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_merge_requests_end_event_timestamp
    remove_column :analytics_cycle_analytics_aggregations, :last_consistency_check_merge_requests_issuable_id
  end
end