X-Git-Url: https://git.squeep.com/?p=websub-hub;a=blobdiff_plain;f=src%2Fdb%2Fsqlite%2Fsql%2Fsubscription-delivery-success.sql;h=dba26322081e39a3c6e3d5035efe0cf5e2191f85;hp=02b89e87e65328d25d1d2d83d9b743e36e4f1ebc;hb=d5e7908d3e60ee0cb3149163d4749563cdfafeb3;hpb=a03352195c7ecfde25a8cf9aba6dd9666e1a3fea diff --git a/src/db/sqlite/sql/subscription-delivery-success.sql b/src/db/sqlite/sql/subscription-delivery-success.sql index 02b89e8..dba2632 100644 --- 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