Initial release

[websub-hub] / src / db / sqlite / sql / verification-insert.sql

diff --git a/src/db/sqlite/sql/verification-insert.sql b/src/db/sqlite/sql/verification-insert.sql
new file mode 100644 (file)
index 0000000..af76cc1
--- /dev/null
+++ b/src/db/sqlite/sql/verification-insert.sql
@@ -0,0 +1,6 @@
+--
+INSERT INTO verification
+       (topic_id, callback, mode, secret, lease_seconds, http_remote_addr, http_from, is_publisher_validated, request_id)
+VALUES
+       (:topicId, :callback, :mode, :secret, :leaseSeconds, :httpRemoteAddr, :httpFrom, :isPublisherValidated, :requestId)
+RETURNING id