From f75b95d2d15d3affe1232aa1577e8e4c692adb87 Mon Sep 17 00:00:00 2001 From: Giorgio Ravera Date: Wed, 27 May 2026 14:53:26 +0200 Subject: [PATCH] Update timestamp format --- backend/db/aliases.py | 2 +- backend/db/hosts.py | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/backend/db/aliases.py b/backend/db/aliases.py index c998643..c64b811 100644 --- a/backend/db/aliases.py +++ b/backend/db/aliases.py @@ -183,7 +183,7 @@ def init_db_alias_table(cur: sqlite3.Cursor) -> None: description TEXT, ssl_enabled INTEGER NOT NULL DEFAULT 0, visibility INTEGER NOT NULL DEFAULT 0, - last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP + last_updated TEXT DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ','now')) ); """ ) diff --git a/backend/db/hosts.py b/backend/db/hosts.py index 6c64015..cf9bc09 100644 --- a/backend/db/hosts.py +++ b/backend/db/hosts.py @@ -231,7 +231,7 @@ def init_db_hosts_table(cur: sqlite3.Cursor) -> None: description TEXT, ssl_enabled INTEGER NOT NULL DEFAULT 0, visibility INTEGER NOT NULL DEFAULT 0, - last_updated TIMESTAMP DEFAULT CURRENT_TIMESTAMP + last_updated TEXT DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ','now')) ); """ ) -- 2.47.3