db/migrate/20211126042235_add_sequence_column_to_sprints_table.rb


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