diff options
author | GitLab Bot <gitlab-bot@gitlab.com> | 2021-08-19 12:08:42 +0300 |
---|---|---|
committer | GitLab Bot <gitlab-bot@gitlab.com> | 2021-08-19 12:08:42 +0300 |
commit | b76ae638462ab0f673e5915986070518dd3f9ad3 (patch) | |
tree | bdab0533383b52873be0ec0eb4d3c66598ff8b91 /db/migrate/20210721174441_update_escalation_rule_fk_for_pending_alert_escalations.rb | |
parent | 434373eabe7b4be9593d18a585fb763f1e5f1a6f (diff) |
Add latest changes from gitlab-org/gitlab@14-2-stable-eev14.2.0-rc42
Diffstat (limited to 'db/migrate/20210721174441_update_escalation_rule_fk_for_pending_alert_escalations.rb')
-rw-r--r-- | db/migrate/20210721174441_update_escalation_rule_fk_for_pending_alert_escalations.rb | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/db/migrate/20210721174441_update_escalation_rule_fk_for_pending_alert_escalations.rb b/db/migrate/20210721174441_update_escalation_rule_fk_for_pending_alert_escalations.rb new file mode 100644 index 00000000000..cf52a43435f --- /dev/null +++ b/db/migrate/20210721174441_update_escalation_rule_fk_for_pending_alert_escalations.rb @@ -0,0 +1,29 @@ +# frozen_string_literal: true + +class UpdateEscalationRuleFkForPendingAlertEscalations < ActiveRecord::Migration[6.1] + include Gitlab::Database::MigrationHelpers + include Gitlab::Database::PartitioningMigrationHelpers + + disable_ddl_transaction! + + OLD_FOREIGN_KEY_CONSTRAINT = 'fk_rails_057c1e3d87' + + # Swap foreign key contrainst from ON DELETE SET NULL to ON DELETE CASCADE + def up + remove_foreign_key_if_exists :incident_management_pending_alert_escalations, :incident_management_escalation_rules, name: OLD_FOREIGN_KEY_CONSTRAINT + + add_concurrent_partitioned_foreign_key :incident_management_pending_alert_escalations, + :incident_management_escalation_rules, + column: :rule_id + end + + def down + remove_foreign_key_if_exists :incident_management_pending_alert_escalations, :incident_management_escalation_rules, column: :rule_id + + add_concurrent_partitioned_foreign_key :incident_management_pending_alert_escalations, + :incident_management_escalation_rules, + column: :rule_id, + on_delete: :nullify, + name: OLD_FOREIGN_KEY_CONSTRAINT + end +end |