max / goingson

481 B · 10 lines History Blame Raw

1	-- Lazy-load full email body for JMAP accounts.
2	--
3	-- JMAP sync fetches bodies with maxBodyValueBytes=100000; larger bodies are
4	-- truncated. We record the provider email id (jmap_id) so the full body can be
5	-- re-fetched on demand, and a flag marking which rows were truncated at sync.
6	-- Both are additive; existing rows default to "not truncated, no jmap id".
7
8	ALTER TABLE emails ADD COLUMN jmap_id TEXT;
9	ALTER TABLE emails ADD COLUMN body_truncated INTEGER NOT NULL DEFAULT 0;
10