max / goingson

696 B · 15 lines History Blame Raw

1	-- Add OAuth2 support for email accounts (Fastmail JMAP)
2	-- Supports both password-based (IMAP/SMTP) and OAuth2 (JMAP) authentication
3
4	-- Authentication type: 'password' (IMAP/SMTP) or 'oauth2_fastmail' (JMAP)
5	ALTER TABLE email_accounts ADD COLUMN auth_type TEXT NOT NULL DEFAULT 'password';
6
7	-- OAuth2 token storage
8	ALTER TABLE email_accounts ADD COLUMN oauth2_access_token TEXT;
9	ALTER TABLE email_accounts ADD COLUMN oauth2_refresh_token TEXT;
10	ALTER TABLE email_accounts ADD COLUMN oauth2_token_expires_at TEXT;
11
12	-- JMAP session information (cached from session discovery)
13	ALTER TABLE email_accounts ADD COLUMN jmap_session_url TEXT;
14	ALTER TABLE email_accounts ADD COLUMN jmap_account_id TEXT;
15