Refactor sign-up email index management in ProjectUser model

- Removed the existing index for signUpEmailNormalized from the finalize_signup_fraud_protection migration. - Created a new migration to add the signUpEmailNormalized index, ensuring better organization and clarity in the migration history. - This change enhances the database schema by maintaining a clear separation of index creation across migrations.
stack-auth · mantrakp04 · Apr 12, 2026 · Mar 28, 2026 · Mar 28, 2026 · Apr 4, 2026
commit 526e5eba6d4a3b6ab076a8a81d4ad323cfca2a86
diff --git a/apps/backend/prisma/migrations/20260308000002_finalize_signup_fraud_protection/migration.sql b/apps/backend/prisma/migrations/20260308000002_finalize_signup_fraud_protection/migration.sql
@@ -17,12 +17,6 @@ CREATE INDEX CONCURRENTLY IF NOT EXISTS "ProjectUser_signUpIp_recent_idx"
 CREATE INDEX CONCURRENTLY IF NOT EXISTS "ProjectUser_signUpEmailBase_recent_idx"
   ON "ProjectUser"("tenancyId", "isAnonymous", "signUpEmailBase", "signedUpAt");
 
--- SPLIT_STATEMENT_SENTINEL
--- SINGLE_STATEMENT_SENTINEL
--- RUN_OUTSIDE_TRANSACTION_SENTINEL
-CREATE INDEX CONCURRENTLY IF NOT EXISTS "ProjectUser_signUpEmailNormalized_recent_idx"
-  ON "ProjectUser"("tenancyId", "isAnonymous", "signUpEmailNormalized", "signedUpAt");
-
 -- Validate the risk score bounds once every row has the new columns.
 -- SPLIT_STATEMENT_SENTINEL
 -- SINGLE_STATEMENT_SENTINEL

diff --git a/...end/prisma/migrations/20260406000000_add_signup_email_normalized_recent_idx/migration.sql b/...end/prisma/migrations/20260406000000_add_signup_email_normalized_recent_idx/migration.sql
@@ -0,0 +1,5 @@
+-- SPLIT_STATEMENT_SENTINEL
+-- SINGLE_STATEMENT_SENTINEL
+-- RUN_OUTSIDE_TRANSACTION_SENTINEL
+CREATE INDEX CONCURRENTLY IF NOT EXISTS "ProjectUser_signUpEmailNormalized_recent_idx"
+  ON "ProjectUser"("tenancyId", "isAnonymous", "signUpEmailNormalized", "signedUpAt");