diff options
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); + |