From 55c5c9ca935a9077a1fd4003e93a10c5144a6bce Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Mon, 21 Apr 2025 22:53:09 +0500
Subject: feat: log user's last activity

---
 database.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 4840f22..5585a93 100644
--- a/database.sql
+++ b/database.sql
@@ -3,7 +3,8 @@ CREATE TABLE IF NOT EXISTS users (
     username TEXT NOT NULL UNIQUE,
     password TEXT,
     secret_key TEXT NOT NULL,
-    joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
+    joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP,
+    last_active_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
 CREATE TABLE IF NOT EXISTS connections (
-- 
cgit v1.2.3

