db migration 1.0.2, now stores and indexes date of content delivered to subscriber...

[websub-hub] / src / db / postgres / sql / subscription-delivery-success.sql

--
UPDATE subscription SET
        content_delivered = now(),
        latest_content_delivered = $(topicContentUpdated),
        delivery_attempts_since_success = 0,
        delivery_next_attempt = '-infinity'::timestamptz
WHERE
        topic_id = $(topicId) AND callback = $(callback)