1 files changed, 11 insertions, 0 deletions
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;