• 0 Posts
  • 9 Comments
Joined 1 year ago
cake
Cake day: July 12th, 2023

help-circle








  • If you wanted to do it in one query I think you could do something like

    UPDATE local_user AS u
      SET u.totp_2fa_url = null,
          u.totp_2fa_secret = null
     FROM person AS p
    WHERE p.id = u.person_id
      AND p.local
      AND p.name = 'guineapig';
    

    I assume the p.local is optional, too, because the id match against the local_user table will presumably limit it to only local users. 🤷