From 24c0224dd90533bc962d5e1a198cdc464018176c Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Sat, 19 Jul 2025 11:31:07 +0300 Subject: Changed session durations metric to classic histogram, added last_activity to calculate monthly active users --- query/users.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'query') 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 = ?; -- cgit v1.3.1