Throttle failed login attempts (10/day)

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