X-Git-Url: http://git.squeep.com/?p=squeep-indie-auther;a=blobdiff_plain;f=src%2Fdb%2Fpostgres%2Fsql%2Fauthentication-update-otp-key.sql;fp=src%2Fdb%2Fpostgres%2Fsql%2Fauthentication-update-otp-key.sql;h=98ae3b06302801e7b8bb402fcb2eef4fe8f13d3d;hp=0000000000000000000000000000000000000000;hb=fba42a499fe1af051b0982c1f3e8b3873c9ed2fb;hpb=e8dccf76ec2776f07eddd1ce2f1c4fc150a6f790

diff --git a/src/db/postgres/sql/authentication-update-otp-key.sql b/src/db/postgres/sql/authentication-update-otp-key.sql
new file mode 100644
index 0000000..98ae3b0
--- /dev/null
+++ b/src/db/postgres/sql/authentication-update-otp-key.sql
@@ -0,0 +1,4 @@
+--
+UPDATE authentication
+	SET otp_key = $(otpKey)
+	WHERE identifier = $(identifier)