diff options
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 ( |