From 55c5c9ca935a9077a1fd4003e93a10c5144a6bce Mon Sep 17 00:00:00 2001 From: ilotterytea 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