Initial release

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

-- Resetting verification attempts happens on publisher validation.
UPDATE verification SET
        next_attempt = now(),
        attempts = 0
WHERE id = $(verificationId)