summaryrefslogtreecommitdiff
path: root/db/migrate/20210127152613_add_iterations_cadence_date_range_constraint.rb
diff options
context:
space:
mode:
Diffstat (limited to 'db/migrate/20210127152613_add_iterations_cadence_date_range_constraint.rb')
-rw-r--r--db/migrate/20210127152613_add_iterations_cadence_date_range_constraint.rb30
1 files changed, 0 insertions, 30 deletions
diff --git a/db/migrate/20210127152613_add_iterations_cadence_date_range_constraint.rb b/db/migrate/20210127152613_add_iterations_cadence_date_range_constraint.rb
deleted file mode 100644
index 95ecd167076..00000000000
--- a/db/migrate/20210127152613_add_iterations_cadence_date_range_constraint.rb
+++ /dev/null
@@ -1,30 +0,0 @@
-# frozen_string_literal: true
-
-class AddIterationsCadenceDateRangeConstraint < ActiveRecord::Migration[6.0]
- include Gitlab::Database::MigrationHelpers
-
- DOWNTIME = false
-
- def up
- with_lock_retries do
- execute <<~SQL
- ALTER TABLE sprints
- ADD CONSTRAINT iteration_start_and_due_date_iterations_cadence_id_constraint
- EXCLUDE USING gist
- ( iterations_cadence_id WITH =,
- daterange(start_date, due_date, '[]') WITH &&
- )
- WHERE (group_id IS NOT NULL)
- SQL
- end
- end
-
- def down
- with_lock_retries do
- execute <<~SQL
- ALTER TABLE sprints
- DROP CONSTRAINT IF EXISTS iteration_start_and_due_date_iterations_cadence_id_constraint
- SQL
- end
- end
-end