CREATE TABLE IF NOT EXISTS room_pin (
    room UUID NOT NULL REFERENCES room(id),
    message UUID NOT NULL,
    seq BIGINT NOT NULL,
    pinned_by UUID NOT NULL,
    created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
    PRIMARY KEY (room, message)
);