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