-- Check if it's a UNIQUE constraint (not just a foreign key)
-- Run this:

SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'bids'
  AND CONSTRAINT_TYPE = 'UNIQUE';

-- If this returns a constraint name, try dropping it as a constraint:
-- ALTER TABLE `bids` DROP CONSTRAINT `CONSTRAINT_NAME`;

-- Also check for FOREIGN KEY constraints:
SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'bids'
  AND CONSTRAINT_TYPE = 'FOREIGN KEY';

