Initial release

[websub-hub] / src / db / postgres / sql / verification-attempts.sql

diff --git a/src/db/postgres/sql/verification-attempts.sql b/src/db/postgres/sql/verification-attempts.sql
new file mode 100644 (file)
index 0000000..6e883ee
--- /dev/null
+++ b/src/db/postgres/sql/verification-attempts.sql
@@ -0,0 +1,5 @@
+--
+SELECT attempts
+FROM verification
+WHERE id = $(verificationId)
+