-- 002  -  email verification (TGS-style: token + expiry on users)

ALTER TABLE users
    ADD COLUMN email_verified_at DATETIME NULL AFTER status,
    ADD COLUMN email_token VARCHAR(64) NULL AFTER email_verified_at,
    ADD COLUMN email_token_expires_at DATETIME NULL AFTER email_token,
    ADD KEY idx_users_email_token (email_token);
