1 files changed, 11 insertions, 1 deletions
diff --git a/sql/users.sql b/sql/users.sql
index 2e1d997..e37e782 100644
--- a/sql/users.sql
+++ b/sql/users.sql
@@ -10,4 +10,14 @@ SELECT *
 -- name: GetUserById :one
 SELECT *
   FROM users
- WHERE id = $1;
-\ No newline at end of file
+ WHERE id = $1;
+
+-- name: GetPwdById :one
+ SELECT pwd
+   FROM users
+ WHERE id = $1;
+
+-- name: UpdatePwd :exec
+ UPDATE users
+    SET pwd = $1
+  WHERE id = $2;
+\ No newline at end of file