max / makenotwork

395 B · 11 lines History Blame Raw

1	-- Issue inbound email: map email Message-ID headers to issues for threading.
2
3	CREATE TABLE issue_message_ids (
4	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
5	message_id TEXT NOT NULL UNIQUE,
6	issue_id UUID NOT NULL REFERENCES issues(id) ON DELETE CASCADE,
7	created_at TIMESTAMPTZ NOT NULL DEFAULT now()
8	);
9
10	CREATE INDEX idx_issue_message_ids_issue ON issue_message_ids(issue_id);
11