summaryrefslogtreecommitdiff
path: root/internal/server/api/migrations
diff options
context:
space:
mode:
authorKyren223 <Kyren223@proton.me>2025-07-19 11:31:07 +0300
committerKyren223 <Kyren223@proton.me>2025-07-19 18:32:12 +0300
commit24c0224dd90533bc962d5e1a198cdc464018176c (patch)
tree89f2c400f8158e0ef83918f67d4aeb3867e2f799 /internal/server/api/migrations
parentf793203e043aaa2db38823c84500e82756348ac0 (diff)
Changed session durations metric to classic histogram, added
last_activity to calculate monthly active users
Diffstat (limited to 'internal/server/api/migrations')
-rw-r--r--internal/server/api/migrations/20250718210459_users_last_activity.sql5
1 files changed, 5 insertions, 0 deletions
diff --git a/internal/server/api/migrations/20250718210459_users_last_activity.sql b/internal/server/api/migrations/20250718210459_users_last_activity.sql
new file mode 100644
index 0000000..2fbc2c8
--- /dev/null
+++ b/internal/server/api/migrations/20250718210459_users_last_activity.sql
@@ -0,0 +1,5 @@
+-- +goose Up
+ALTER TABLE users ADD COLUMN last_activity INTEGER;
+
+-- +goose Down
+ALTER TABLE users DROP COLUMN last_activity;