max / goingson

422 B · 10 lines History Blame Raw

1	-- Add IMAP UID and source folder tracking to emails table (SQLite)
2	ALTER TABLE emails ADD COLUMN imap_uid INTEGER;
3	ALTER TABLE emails ADD COLUMN source_folder TEXT;
4
5	-- Index for efficient lookups when syncing
6	CREATE INDEX idx_emails_imap_uid ON emails(email_account_id, imap_uid, source_folder);
7
8	-- Track archive folder name per account
9	ALTER TABLE email_accounts ADD COLUMN archive_folder_name TEXT DEFAULT 'Archive';
10