CODE EXAMPLE FOR SQL

mysql unique constraint

ALTER TABLE users
ADD UNIQUE (username, delete_date, ...);