diff options
| author | ilotterytea <iltsu@alright.party> | 2025-04-21 22:53:09 +0500 |
|---|---|---|
| committer | ilotterytea <iltsu@alright.party> | 2025-04-21 22:53:09 +0500 |
| commit | 55c5c9ca935a9077a1fd4003e93a10c5144a6bce (patch) | |
| tree | 9bb587e3be395e5d6f4f4a8be8dcf981517ddab7 /database.sql | |
| parent | 8b7d6b6c6684a2c6e11191cc0a6e04c6fcab368a (diff) | |
feat: log user's last activity
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 3 |
1 files changed, 2 insertions, 1 deletions
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 ( |