diff options
author | Aleksander Machniak <alec@alec.pl> | 2015-11-11 20:53:43 +0300 |
---|---|---|
committer | Aleksander Machniak <alec@alec.pl> | 2015-11-11 20:53:43 +0300 |
commit | a15d877ba8e12ba6659aad69d63b8b73256144ad (patch) | |
tree | 26d8f2f5a0fe9df67d142eed9d67b1e55fa493f0 /SQL/mysql.initial.sql | |
parent | 7caa9f5f505f97565cdac3f82a0b7d3d6df80a46 (diff) |
Added brute-force attack prevention via login rate limit (#1490566)
Diffstat (limited to 'SQL/mysql.initial.sql')
-rw-r--r-- | SQL/mysql.initial.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/SQL/mysql.initial.sql b/SQL/mysql.initial.sql index 721c839c7..df1d015aa 100644 --- a/SQL/mysql.initial.sql +++ b/SQL/mysql.initial.sql @@ -24,6 +24,8 @@ CREATE TABLE `users` ( `mail_host` varchar(128) NOT NULL, `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', `last_login` datetime DEFAULT NULL, + `failed_login` datetime DEFAULT NULL, + `failed_login_counter` int(10) UNSIGNED DEFAULT NULL, `language` varchar(5), `preferences` longtext, PRIMARY KEY(`user_id`), @@ -209,4 +211,4 @@ CREATE TABLE `system` ( /*!40014 SET FOREIGN_KEY_CHECKS=1 */; -INSERT INTO system (name, value) VALUES ('roundcube-version', '2015030800'); +INSERT INTO system (name, value) VALUES ('roundcube-version', '2015111100'); |