Project

General

Profile

Actions

Bug #1600

open

DB: Cleanup Duplicate User Records and Enforce Phone Uniqueness Constraint

Added by haroon sajjad 3 days ago. Updated 2 days ago.

Status:
Resolved
Priority:
High
Assignee:
Target version:
-
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

Also available in: Atom PDF