CREATE TABLE incoming_webmention_queue (
       id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
       source TEXT NOT NULL,
       target TEXT NOT NULL,
       recv_timestamp TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE RULE notify_incoming_webmention AS
ON INSERT TO incoming_webmention_queue
DO ALSO NOTIFY incoming_webmention;
