summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--util/dump.sql4
-rw-r--r--util/updates/update_2.6.sql4
2 files changed, 4 insertions, 4 deletions
diff --git a/util/dump.sql b/util/dump.sql
index bdff5c6b..3a470102 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -26,7 +26,7 @@ CREATE TABLE anime (
type smallint,
title_romaji,
title_kanji,
- lastfetch timestamp
+ lastfetch timestamptz
);
-- changes
@@ -165,7 +165,7 @@ CREATE TABLE screenshots (
CREATE TABLE sessions (
uid integer NOT NULL,
token bytea NOT NULL,
- expiration timestamp NOT NULL DEFAULT (now() + '1 year'::interval),
+ expiration timestamptz NOT NULL DEFAULT (now() + '1 year'::interval),
PRIMARY KEY (uid, token)
);
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index a5ae03f6..06722cc2 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -4,7 +4,7 @@
CREATE TABLE sessions (
uid integer NOT NULL REFERENCES users(id),
token bytea NOT NULL,
- expiration timestamp NOT NULL DEFAULT (NOW() + '1 year'::interval),
+ expiration timestamptz NOT NULL DEFAULT (NOW() + '1 year'::interval),
PRIMARY KEY (uid, token)
);
@@ -19,7 +19,7 @@ ALTER TABLE users ADD COLUMN salt character(9) NOT NULL DEFAULT ''::bpchar;
ALTER TABLE anime ALTER COLUMN lastfetch DROP NOT NULL;
ALTER TABLE anime ALTER COLUMN lastfetch DROP DEFAULT;
UPDATE anime SET lastfetch = NULL WHERE lastfetch <= 0;
-ALTER TABLE anime ALTER COLUMN lastfetch TYPE timestamp USING timestamp 'epoch' + lastfetch * interval '1 second';
+ALTER TABLE anime ALTER COLUMN lastfetch TYPE timestamptz USING 'epoch'::timestamptz + lastfetch * interval '1 second';
ALTER TABLE anime ALTER COLUMN ann_id DROP NOT NULL;
ALTER TABLE anime ALTER COLUMN ann_id DROP DEFAULT;