track topic update history

[websub-hub] / src / db / sqlite / sql / topic-set-content-history.sql

diff --git a/src/db/sqlite/sql/topic-set-content-history.sql b/src/db/sqlite/sql/topic-set-content-history.sql
new file mode 100644 (file)
index 0000000..8afe3a4
--- /dev/null
+++ b/src/db/sqlite/sql/topic-set-content-history.sql
@@ -0,0 +1,5 @@
+--
+INSERT INTO topic_content_history
+       (topic_id, content_size, content_hash)
+VALUES
+       (:topicId, :contentSize, :contentHash)