1 files changed, 24 insertions, 0 deletions
diff --git a/db/post_migrate/20211130165043_backfill_sequence_column_for_sprints_table.rb b/db/post_migrate/20211130165043_backfill_sequence_column_for_sprints_table.rb
new file mode 100644
index 00000000000..420bfb8bcbc
--- /dev/null
+++ b/db/post_migrate/20211130165043_backfill_sequence_column_for_sprints_table.rb
@@ -0,0 +1,24 @@
+# frozen_string_literal: true
+
+class BackfillSequenceColumnForSprintsTable < Gitlab::Database::Migration[1.0]
+  enable_lock_retries!
+
+  def up
+    execute(
+      <<-SQL
+        UPDATE sprints
+        SET sequence=t.row_number
+        FROM (
+          SELECT id, row_number() OVER (PARTITION BY iterations_cadence_id ORDER BY start_date)
+          FROM sprints as s1
+          WHERE s1.iterations_cadence_id IS NOT NULL
+        ) as t
+        WHERE t.id=sprints.id AND (sprints.sequence IS NULL OR sprints.sequence <> t.row_number)
+      SQL
+    )
+  end
+
+  def down
+    # no-op
+  end
+end