-- First, let's check the current structure of the _userfollows table
SHOW CREATE TABLE _userfollows;

-- Now, let's check the foreign key constraints
SELECT * FROM information_schema.KEY_COLUMN_USAGE 
WHERE TABLE_NAME = '_userfollows' AND CONSTRAINT_NAME != 'PRIMARY';

-- Let's check the structure of the User table to ensure the foreign keys will be valid
SHOW INDEX FROM User WHERE Key_name = 'PRIMARY';