-- Try all possible methods to drop the unique index
-- Run these one by one:

-- METHOD 1: Try dropping as a constraint
ALTER TABLE `bids` DROP CONSTRAINT `bids_inquiry_id_supplier_id`;

-- METHOD 2: Disable FK checks and drop index
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;
SET FOREIGN_KEY_CHECKS = 1;

-- METHOD 3: Try with both FK checks off and constraint drop
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `bids` DROP CONSTRAINT `bids_inquiry_id_supplier_id`;
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;
SET FOREIGN_KEY_CHECKS = 1;

-- If none of these work, we need the full CREATE TABLE statement
-- to see exactly how the constraint is defined

