initial commit

[squeep-indie-auther] / src / db / sqlite / sql / token-refresh-revoke-by-code-id.sql

diff --git a/src/db/sqlite/sql/token-refresh-revoke-by-code-id.sql b/src/db/sqlite/sql/token-refresh-revoke-by-code-id.sql
new file mode 100644 (file)
index 0000000..52a851c
--- /dev/null
+++ b/src/db/sqlite/sql/token-refresh-revoke-by-code-id.sql
@@ -0,0 +1,5 @@
+-- Revoke the refreshability for a token
+UPDATE token SET
+       refresh_expires = NULL,
+       refresh_duration = NULL
+WHERE code_id = :codeId