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

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

diff --git a/src/db/sqlite/sql/subscription-delivery-success.sql b/src/db/sqlite/sql/subscription-delivery-success.sql
index 02b89e87e65328d25d1d2d83d9b743e36e4f1ebc..dba26322081e39a3c6e3d5035efe0cf5e2191f85 100644 (file)
--- a/src/db/sqlite/sql/subscription-delivery-success.sql
+++ b/src/db/sqlite/sql/subscription-delivery-success.sql
@@ -1,6 +1,7 @@
 --
 UPDATE subscription SET
        content_delivered = strftime('%s', 'now'),
+       latest_content_delivered = :topicContentUpdated,
        delivery_attempts_since_success = 0,
        delivery_next_attempt = 0
 WHERE