-- Adds an `email_is_relay` flag to `user_oauth_identity`.
--
-- Apple Sign-In lets the user hide their real email behind an alias
-- `<random>@privaterelay.appleid.com` that forwards mail to their real
-- inbox. Apple guarantees uniqueness and delivery so the alias behaves
-- like a normal email for our purposes — but downstream features (e.g.
-- "send a friend invite from this account") may want to know whether
-- the address is a relay or a direct mailbox.
--
-- Default 0 — existing Google rows are direct emails by definition.

ALTER TABLE `user_oauth_identity`
    ADD COLUMN `email_is_relay` TINYINT(1) NOT NULL DEFAULT 0 AFTER `email_at_link`;
