summaryrefslogtreecommitdiff
path: root/db/migrate/20211126042235_add_sequence_column_to_sprints_table.rb
blob: cbe5dbf99fc6a99f36868190d805f6e5fb0275d7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
# frozen_string_literal: true

class AddSequenceColumnToSprintsTable < Gitlab::Database::Migration[1.0]
  enable_lock_retries!

  def up
    add_column :sprints, :sequence, :integer
    execute "ALTER TABLE sprints ADD CONSTRAINT sequence_is_unique_per_iterations_cadence_id UNIQUE (iterations_cadence_id, sequence) DEFERRABLE INITIALLY DEFERRED"
  end

  def down
    remove_column :sprints, :sequence
  end
end