From f793203e043aaa2db38823c84500e82756348ac0 Mon Sep 17 00:00:00 2001 From: Kyren223 Date: Thu, 17 Jul 2025 18:45:43 +0300 Subject: Added session duration metrics with device analytics along with device analytics metrics in the DB to aggregate and DeviceID abuse prevention --- .../server/api/migrations/20250717130820_device_analytics.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 internal/server/api/migrations/20250717130820_device_analytics.sql (limited to 'internal/server/api/migrations/20250717130820_device_analytics.sql') diff --git a/internal/server/api/migrations/20250717130820_device_analytics.sql b/internal/server/api/migrations/20250717130820_device_analytics.sql new file mode 100644 index 0000000..b4797a4 --- /dev/null +++ b/internal/server/api/migrations/20250717130820_device_analytics.sql @@ -0,0 +1,11 @@ +-- +goose Up +CREATE TABLE IF NOT EXISTS device_analytics ( + device_id TEXT PRIMARY KEY, + os TEXT, + arch TEXT, + term TEXT, + colorterm TEXT +); + +-- +goose Down +DROP TABLE IF EXISTS device_analytics; -- cgit v1.3.1