From 8b7d6b6c6684a2c6e11191cc0a6e04c6fcab368a Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Mon, 21 Apr 2025 21:41:06 +0500
Subject: upd: use UTC_TIMESTAMP and new format_timestamp

---
 database.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index cff3e93..4840f22 100644
--- a/database.sql
+++ b/database.sql
@@ -3,7 +3,7 @@ CREATE TABLE IF NOT EXISTS users (
     username TEXT NOT NULL UNIQUE,
     password TEXT,
     secret_key TEXT NOT NULL,
-    joined_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+    joined_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
 CREATE TABLE IF NOT EXISTS connections (
@@ -12,7 +12,7 @@ CREATE TABLE IF NOT EXISTS connections (
     alias_id TEXT NOT NULL,
     platform TEXT NOT NULL,
     data TEXT NOT NULL,
-    connected_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+    connected_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
 CREATE TABLE IF NOT EXISTS emotes (
@@ -21,7 +21,7 @@ CREATE TABLE IF NOT EXISTS emotes (
     mime TEXT NOT NULL,
     ext TEXT NOT NULL,
     uploaded_by INTEGER REFERENCES users(id),
-    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+    created_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
 CREATE TABLE IF NOT EXISTS emote_sets (
@@ -38,7 +38,7 @@ CREATE TABLE IF NOT EXISTS emote_set_contents (
     emote_id INTEGER NOT NULL REFERENCES emotes(id),
     name TEXT,
     added_by INTEGER NOT NULL REFERENCES users(id),
-    created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
+    added_at TIMESTAMP NOT NULL DEFAULT UTC_TIMESTAMP
 );
 
 CREATE TABLE IF NOT EXISTS acquired_emote_sets (
-- 
cgit v1.2.3

