diff options
Diffstat (limited to 'util')
-rw-r--r-- | util/sql/schema.sql | 6 | ||||
-rw-r--r-- | util/updates/update_2.23.sql | 6 |
2 files changed, 12 insertions, 0 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 8cc4956e..b8bc7de7 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -86,6 +86,12 @@ CREATE TABLE chars_vns ( role char_role NOT NULL DEFAULT 'main' ); +-- login_throttle +CREATE TABLE login_throttle ( + ip inet NOT NULL PRIMARY KEY, + timeout bigint NOT NULL +); + -- notifications CREATE TABLE notifications ( id serial PRIMARY KEY NOT NULL, diff --git a/util/updates/update_2.23.sql b/util/updates/update_2.23.sql index 9327e074..1de44e14 100644 --- a/util/updates/update_2.23.sql +++ b/util/updates/update_2.23.sql @@ -73,3 +73,9 @@ UPDATE releases_rev SET resolution = resolution + 1 WHERE resolution >= 8 AND NO -- New language: Romanian ALTER TYPE language ADD VALUE 'ro' AFTER 'pt-br'; + +-- Login attempt throttling +CREATE TABLE login_throttle ( + ip inet NOT NULL PRIMARY KEY, + timeout bigint NOT NULL +); |