diff options
author | Yorhel <git@yorhel.nl> | 2014-08-29 10:54:36 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2014-08-29 10:54:36 +0200 |
commit | 9a1bd46a568094ff62cfc85bc488b116042718b8 (patch) | |
tree | e580afad4f318a1c5f4c98047beaa6796b3f14e3 /util/sql | |
parent | c27d4e6b509a655d81e36469bb881afc287596e8 (diff) |
Throttle failed login attempts (10/day)
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/schema.sql | 6 |
1 files changed, 6 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, |