softdelete and mysql unique constraint code example
Example 1: mysql remove unique constraint
ALTER TABLE tbl_name DROP INDEX index_name
Example 2: how to remove unique key constraint in mysql
DROP INDEX index_name ON tbl_name
ALTER TABLE tbl_name DROP INDEX index_name
DROP INDEX index_name ON tbl_name