ClaperCo
diff --git a/‎priv/repo/migrations/20260807052500_allow_reusing_deleted_user_emails.exs‎
Lines changed: 1 addition & 1 deletion b/‎priv/repo/migrations/20260807052500_allow_reusing_deleted_user_emails.exs‎
Lines changed: 1 addition & 1 deletion
@@ -8,7 +8,7 @@ defmodule Claper.Repo.Migrations.AllowReusingDeletedUserEmails do
  WITH ranked_users AS (
  SELECT
  id,
- ROW_NUMBER() OVER (PARTITION BY email ORDER BY inserted_at, id) AS email_position
+ ROW_NUMBER() OVER (PARTITION BY email ORDER BY inserted_at DESC, id DESC) AS email_position
  FROM users
  WHERE deleted_at IS NULL
  )
Original file line number	Diff line number	Diff line change
`@@ -8,7 +8,7 @@ defmodule Claper.Repo.Migrations.AllowReusingDeletedUserEmails do`
`8`	`8`	`WITH ranked_users AS (`
`9`	`9`	`SELECT`
`10`	`10`	`id,`
`11`		`- ROW_NUMBER() OVER (PARTITION BY email ORDER BY inserted_at, id) AS email_position`
	`11`	`+ ROW_NUMBER() OVER (PARTITION BY email ORDER BY inserted_at DESC, id DESC) AS email_position`
`12`	`12`	`FROM users`
`13`	`13`	`WHERE deleted_at IS NULL`
`14`	`14`	`)`