diff options
author | Yorhel <git@yorhel.nl> | 2014-10-11 09:09:21 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2014-10-11 09:09:21 +0200 |
commit | 8d5c9edc3d9576e647b4915cba10cdcbb5fab1fe (patch) | |
tree | cc321a4c4c49f0cf3d7a1a2f2f536ff5c7d7edb6 /util | |
parent | 1b590ccab6e11202e069ebed1024569e33ea7173 (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.sql | 2 | ||||
-rw-r--r-- | util/updates/update_2.23.sql | 4 |
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); + |