Actions
Bug #1600
openDB: Cleanup Duplicate User Records and Enforce Phone Uniqueness Constraint
Start date:
04/13/2026
Due date:
% Done:
100%
Estimated time:
Description
Due to the lack of a UNIQUE constraint on the phone column in the users table, the database has accumulated multiple redundant records sharing the same phone number. Some of these are "Ghost" records with missing metadata or 0000-00-00 timestamps.
Requirements:
Perform a manual cleanup of 101 identified duplicate records (IDs already verified as having no subscription, Bridge ID, or PayCrypto ID).
Apply a UNIQUE constraint (index) to the phone column in the users table to provide a hard safety net against future duplicates.
Ensure the migration is only run after the data is clean to avoid "Duplicate Entry" errors during the ALTER TABLE operation.
Actions