summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2014-10-11 09:09:21 +0200
committerYorhel <git@yorhel.nl>2014-10-11 09:09:21 +0200
commit8d5c9edc3d9576e647b4915cba10cdcbb5fab1fe (patch)
treecc321a4c4c49f0cf3d7a1a2f2f536ff5c7d7edb6 /util
parent1b590ccab6e11202e069ebed1024569e33ea7173 (diff)
SQL: Convert login_throttle.timeout to a timestamptz
Easier to work with in custom queries.
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);
+