db/migrate/20210730194555_create_incident_management_pending_issue_escalations.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
32
33

# frozen_string_literal: true

class CreateIncidentManagementPendingIssueEscalations < ActiveRecord::Migration[6.1]
  include Gitlab::Database::MigrationHelpers

  def up
    with_lock_retries do
      execute(<<~SQL)
        CREATE TABLE incident_management_pending_issue_escalations (
          id bigserial NOT NULL,
          rule_id bigint  NOT NULL,
          issue_id bigint NOT NULL,
          process_at timestamp with time zone NOT NULL,
          created_at timestamp with time zone NOT NULL,
          updated_at timestamp with time zone NOT NULL,
          PRIMARY KEY (id, process_at)
        ) PARTITION BY RANGE (process_at);

        CREATE INDEX index_incident_management_pending_issue_escalations_on_issue_id
          ON incident_management_pending_issue_escalations USING btree (issue_id);

        CREATE INDEX index_incident_management_pending_issue_escalations_on_rule_id
          ON incident_management_pending_issue_escalations USING btree (rule_id);
      SQL
    end
  end

  def down
    with_lock_retries do
      drop_table :incident_management_pending_issue_escalations
    end
  end
end