-- First, find the exact unique index name on the bids table
-- Run this query to see all indexes on inquiryId and supplierId columns

SHOW INDEX FROM `bids` WHERE Column_name IN ('inquiryId', 'supplierId');

-- Look at the output:
-- - Column_name: Should show 'inquiryId' and 'supplierId'
-- - Key_name: This is the index name you need to drop
-- - Non_unique: If this is 0, it's a UNIQUE index (this is what we want to drop)
-- - Seq_in_index: Shows the order (1 for first column, 2 for second column)

-- You're looking for an index where:
-- - Both inquiryId and supplierId are in the same Key_name
-- - Non_unique = 0 (meaning it's UNIQUE)

-- Once you find the Key_name, use it in the DROP INDEX command below:
-- ALTER TABLE `bids` DROP INDEX `KEY_NAME_FROM_OUTPUT`;

