diff options
| author | Kyren223 <Kyren223@proton.me> | 2025-07-19 11:31:07 +0300 |
|---|---|---|
| committer | Kyren223 <Kyren223@proton.me> | 2025-07-19 18:32:12 +0300 |
| commit | 24c0224dd90533bc962d5e1a198cdc464018176c (patch) | |
| tree | 89f2c400f8158e0ef83918f67d4aeb3867e2f799 /query/users.sql | |
| parent | f793203e043aaa2db38823c84500e82756348ac0 (diff) | |
Changed session durations metric to classic histogram, added
last_activity to calculate monthly active users
Diffstat (limited to 'query/users.sql')
| -rw-r--r-- | query/users.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/query/users.sql b/query/users.sql index d2a4a92..50ec9af 100644 --- a/query/users.sql +++ b/query/users.sql @@ -44,3 +44,6 @@ WHERE user_id = ?; -- name: GetUsersByIds :many SELECT * FROM users WHERE id IN (sqlc.slice('ids')); + +-- name: UpdateUserLastActivity :exec +UPDATE users SET last_activity = ? WHERE id = ?; |