upd: use UTC_TIMESTAMP and new format_timestamp

1 files changed, 4 insertions, 4 deletions

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 (