Refactor sign-up email index management in ProjectUser model

mantrakp04 · mantrakp04 · commit 526e5eba6d4a · 2026-04-06T10:00:14.000-07:00
- 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.
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/apps/backend/prisma/migrations/20260406000000_add_signup_email_normalized_recent_idx/migration.sql b/apps/backend/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");
