Initial release

[websub-hub] / src / db / sqlite / sql / topic-content-fetch-requested.sql

diff --git a/src/db/sqlite/sql/topic-content-fetch-requested.sql b/src/db/sqlite/sql/topic-content-fetch-requested.sql
new file mode 100644 (file)
index 0000000..90eac80
--- /dev/null
+++ b/src/db/sqlite/sql/topic-content-fetch-requested.sql
@@ -0,0 +1,6 @@
+-- update topic that a new publish notification occurred
+UPDATE topic
+SET
+       last_publish = strftime('%s', 'now'),
+       content_fetch_next_attempt = strftime('%s', 'now')
+WHERE id = :topicId