Schema update failure: Duplicated key name

[almeidarobertop]

When upgrading module from 1.2.9.1 to 2.0.0 we faced an error with duplicate key name.

Preconditions

Adobe Cloud

Magento Version : Commerce 2.4.6-p3

Module Retailer Version : 1.2.9.1

Environment : Production

Third party modules : no

Steps to reproduce

**1. Composer update smile/module-retailer

2. bin/magento setup:upgrade**

Expected result

1. Complete setup with no error

Actual result

1. SQLSTATE[42000]: Syntax error or access violation: 1061 Duplicate key name 'SMILE_RETAILER_ADDRESS_RETAILER_ID', query was: ALTER TABLE smile_retailer_address ADD CONSTRAINT SMILE_RETAILER_ADDRESS_RETAILER_ID UNIQUE KEY (retailer_id)

2. 

[sylvester-c]

I faced this same issue, any solution for this?

[sylvesterdacosta]

The solution for this is before upgrade use this command:

ALTER TABLE smile_retailer_address DROP FOREIGN KEY SMILE_RETAILER_ADDRESS_RETAILER_ID_SMILE_SELLER_ENTITY_ENTITY_ID, DROP INDEX SMILE_RETAILER_ADDRESS_RETAILER_ID;