diff options
| author | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-17 21:58:02 +0200 |
|---|---|---|
| committer | René 'Necoro' Neumann <necoro@necoro.eu> | 2024-10-17 21:58:02 +0200 |
| commit | 88fa53fb9e2f45f47b33d5edef43e7338d5c4f03 (patch) | |
| tree | 736a07623feb6b07a045d053ca1e296c0207b5fb /sql/users.sql | |
| parent | bdce74729c3529d7b5b1465bd23a079a3ec0caab (diff) | |
| download | gosten-88fa53fb9e2f45f47b33d5edef43e7338d5c4f03.tar.gz gosten-88fa53fb9e2f45f47b33d5edef43e7338d5c4f03.tar.bz2 gosten-88fa53fb9e2f45f47b33d5edef43e7338d5c4f03.zip | |
Introduce change password functionality
Diffstat (limited to 'sql/users.sql')
| -rw-r--r-- | sql/users.sql | 12 |
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 |