Initial release

[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
new file mode 100644 (file)
index 0000000..02b89e8
--- /dev/null
+++ b/src/db/sqlite/sql/subscription-delivery-success.sql
@@ -0,0 +1,7 @@
+--
+UPDATE subscription SET
+       content_delivered = strftime('%s', 'now'),
+       delivery_attempts_since_success = 0,
+       delivery_next_attempt = 0
+WHERE
+       topic_id = :topicId AND callback = :callback