-- SIMPLE: Just drop the unique index
-- The non-unique index already exists, so we only need to drop the unique one

-- STEP 1: Find the unique index name
SHOW INDEX FROM `bids` WHERE Column_name IN ('inquiryId', 'supplierId');

-- Look at the output:
-- Find the row where Non_unique = 0 (this is the UNIQUE index)
-- Note the Key_name value (e.g., 'bids_inquiry_id_supplier_id')

-- STEP 2: Drop that unique index
-- Replace 'UNIQUE_INDEX_NAME' with the Key_name from Step 1
-- Example:
-- ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;

-- STEP 3: Verify - run this again
SHOW INDEX FROM `bids` WHERE Column_name IN ('inquiryId', 'supplierId`);

-- You should now see:
-- - idx_bids_inquiry_supplier with Non_unique = 1 (allows duplicates) ✅
-- - NO index with Non_unique = 0 (unique constraint removed) ✅

