max / makenotwork

533 B · 13 lines History Blame Raw

1	-- Patch inbound email: map email Message-ID headers to MT thread IDs for multi-part patch threading.
2
3	CREATE TABLE patch_message_ids (
4	id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
5	message_id TEXT NOT NULL UNIQUE,
6	project_id UUID NOT NULL REFERENCES projects(id) ON DELETE CASCADE,
7	thread_id UUID NOT NULL,
8	created_at TIMESTAMPTZ NOT NULL DEFAULT now()
9	);
10
11	CREATE INDEX idx_patch_message_ids_message ON patch_message_ids(message_id);
12	CREATE INDEX idx_patch_message_ids_project ON patch_message_ids(project_id);
13