-- Check the current column definition
SHOW COLUMNS FROM users LIKE 'userType';

-- Check for any null or empty values
SELECT COUNT(*) as empty_user_type_count FROM users WHERE userType = '' OR userType IS NULL;

-- Show distinct userType values and their counts
SELECT userType, COUNT(*) as count FROM users GROUP BY userType;