diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 8 |
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 ( |