summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/sql/schema.sql2
-rw-r--r--util/updates/update_2.23.sql4
2 files changed, 5 insertions, 1 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index b8bc7de7..0c9f0404 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -89,7 +89,7 @@ CREATE TABLE chars_vns (
-- login_throttle
CREATE TABLE login_throttle (
ip inet NOT NULL PRIMARY KEY,
- timeout bigint NOT NULL
+ timeout timestamptz NOT NULL
);
-- notifications
diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql
index 1de44e14..e3b32a11 100644
--- a/util/updates/update_2.23.sql
+++ b/util/updates/update_2.23.sql
@@ -79,3 +79,7 @@ CREATE TABLE login_throttle (
ip inet NOT NULL PRIMARY KEY,
timeout bigint NOT NULL
);
+
+-- timeout is a timestamp...
+ALTER TABLE login_throttle ALTER COLUMN timeout TYPE timestamptz USING to_timestamp(timeout);
+