max / goingson

387 B · 8 lines History Blame Raw

1	-- Real email drafts: flag + stored compose state
2	ALTER TABLE emails ADD COLUMN is_draft INTEGER NOT NULL DEFAULT 0;
3	ALTER TABLE emails ADD COLUMN cc_address TEXT;
4	ALTER TABLE emails ADD COLUMN bcc_address TEXT;
5	ALTER TABLE emails ADD COLUMN draft_account_id TEXT REFERENCES email_accounts(id) ON DELETE SET NULL;
6
7	CREATE INDEX idx_emails_is_draft ON emails(is_draft) WHERE is_draft = 1;
8