-- Check current users and their roles
SELECT id, email, role, display_name, created_at 
FROM StudyBuddy_users 
ORDER BY created_at DESC;

-- To make a user an admin, uncomment and run one of these:
-- (Replace <email> or <id> with your actual values)

-- Option 1: Update by email
-- UPDATE StudyBuddy_users SET role = 'admin' WHERE email = '<your-email@example.com>';

-- Option 2: Update by ID
-- UPDATE StudyBuddy_users SET role = 'admin' WHERE id = <user-id>;

-- Verify the change
-- SELECT id, email, role FROM StudyBuddy_users WHERE email = '<your-email@example.com>';