-- Try using ALTER TABLE to modify the constraint
-- Sometimes you need to drop and recreate the foreign key differently

-- STEP 1: Try to see all constraints
SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'bids';

-- STEP 2: If you see a UNIQUE constraint (not just FOREIGN KEY), try:
-- ALTER TABLE `bids` DROP CONSTRAINT `CONSTRAINT_NAME`;

-- STEP 3: Or try recreating the table structure
-- First, get the CREATE TABLE statement, modify it to remove the unique index,
-- then recreate the table

