Skip to main content

max / goingson

331 B · 7 lines History Blame Raw
1 -- Add contact linking to tasks and events
2 ALTER TABLE tasks ADD COLUMN contact_id TEXT REFERENCES contacts(id) ON DELETE SET NULL;
3 CREATE INDEX idx_tasks_contact ON tasks(contact_id);
4
5 ALTER TABLE events ADD COLUMN contact_id TEXT REFERENCES contacts(id) ON DELETE SET NULL;
6 CREATE INDEX idx_events_contact ON events(contact_id);
7