Skip to main content

max / goingson

279 B · 6 lines History Blame Raw
1 -- Email-to-Task linking: Allow tasks to be created from emails
2
3 -- Add source_email_id to link tasks to their source email
4 ALTER TABLE tasks ADD COLUMN source_email_id TEXT REFERENCES emails(id) ON DELETE SET NULL;
5 CREATE INDEX idx_tasks_source_email ON tasks(source_email_id);
6