START TRANSACTION;

-- Backfill students table for existing users with role 'student'
INSERT INTO students (user_id)
SELECT u.id
FROM users u
LEFT JOIN students s ON s.user_id = u.id
WHERE u.role = 'student'
  AND s.user_id IS NULL;

COMMIT;