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

diff --git a/src/db/postgres/sql/subscription-delivery-success.sql b/src/db/postgres/sql/subscription-delivery-success.sql
index 9ff01e0395ef7c689b3ae6d1af33d586d77b683a..b19b376593f54405e2a6ef7532bcef912d0f1ebe 100644 (file)
--- a/src/db/postgres/sql/subscription-delivery-success.sql
+++ b/src/db/postgres/sql/subscription-delivery-success.sql
@@ -1,6 +1,7 @@
 --
 UPDATE subscription SET
        content_delivered = now(),
+       latest_content_delivered = $(topicContentUpdated),
        delivery_attempts_since_success = 0,
        delivery_next_attempt = '-infinity'::timestamptz
 WHERE