-- Replace the email below with the exact email of an existing university user.
-- Run this after it_support.sql, then confirm the RETURNING query shows one row.
INSERT INTO it_members (user_id, role, added_by)
SELECT u.id, 'manager', u.id
FROM users AS u
WHERE LOWER(u.email) = LOWER('REPLACE_WITH_EXISTING_MANAGER_EMAIL')
ON CONFLICT (user_id)
DO UPDATE SET role = EXCLUDED.role
RETURNING user_id, role;
