summaryrefslogtreecommitdiff
path: root/db/migrate/20200603073101_change_constraint_name_on_resource_state_events.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20200603073101_change_constraint_name_on_resource_state_events.rb')
-rw-r--r--db/migrate/20200603073101_change_constraint_name_on_resource_state_events.rb16
1 files changed, 16 insertions, 0 deletions
diff --git a/db/migrate/20200603073101_change_constraint_name_on_resource_state_events.rb b/db/migrate/20200603073101_change_constraint_name_on_resource_state_events.rb
new file mode 100644
index 00000000000..d37027bf2fb
--- /dev/null
+++ b/db/migrate/20200603073101_change_constraint_name_on_resource_state_events.rb
@@ -0,0 +1,16 @@
+# frozen_string_literal: true
+
+class ChangeConstraintNameOnResourceStateEvents < ActiveRecord::Migration[6.0]
+ DOWNTIME = false
+
+ NEW_CONSTRAINT_NAME = 'state_events_must_belong_to_issue_or_merge_request_or_epic'
+ OLD_CONSTRAINT_NAME = 'resource_state_events_must_belong_to_issue_or_merge_request_or_'
+
+ def up
+ execute "ALTER TABLE resource_state_events RENAME CONSTRAINT #{OLD_CONSTRAINT_NAME} TO #{NEW_CONSTRAINT_NAME};"
+ end
+
+ def down
+ execute "ALTER TABLE resource_state_events RENAME CONSTRAINT #{NEW_CONSTRAINT_NAME} TO #{OLD_CONSTRAINT_NAME};"
+ end
+end