Initial release

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

diff --git a/src/db/postgres/sql/topic-set-content.sql b/src/db/postgres/sql/topic-set-content.sql
new file mode 100644 (file)
index 0000000..c14258b
--- /dev/null
+++ b/src/db/postgres/sql/topic-set-content.sql
@@ -0,0 +1,9 @@
+-- 
+UPDATE topic
+SET
+       is_active = true,
+       content_updated = now(),
+       content = $(content),
+       content_hash = $(contentHash),
+       content_type = $(contentType)
+WHERE id = $(topicId)