-- Alternative: Maybe we can work around this
-- If there's no foreign key showing up, try these approaches:

-- APPROACH 1: Try to modify the index to be non-unique (MySQL doesn't support this directly)
-- So we need to drop and recreate, but first we need to handle the FK

-- APPROACH 2: Check if the index name itself is the constraint
-- Try dropping it as a constraint:
ALTER TABLE `bids` DROP CONSTRAINT `bids_inquiry_id_supplier_id`;

-- APPROACH 3: If the CREATE TABLE shows foreign keys at the end, 
-- they might be inline with the column definitions
-- Look for: FOREIGN KEY (`inquiryId`) REFERENCES `inquiries` (`id`)
-- The constraint name might be implicit or auto-generated

-- APPROACH 4: Try to see if we can disable foreign key checks temporarily
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `bids` DROP INDEX `bids_inquiry_id_supplier_id`;
SET FOREIGN_KEY_CHECKS = 1;

-- Then recreate foreign keys if needed:
ALTER TABLE `bids` 
  ADD CONSTRAINT `bids_inquiryId_fk` FOREIGN KEY (`inquiryId`) REFERENCES `inquiries` (`id`) ON DELETE CASCADE;

ALTER TABLE `bids` 
  ADD CONSTRAINT `bids_supplierId_fk` FOREIGN KEY (`supplierId`) REFERENCES `suppliers` (`id`) ON DELETE CASCADE;

