Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040077.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040077.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040077.sql (revision d7ff7c15474d827c7b65a65b36a02c4eef9bf58d) @@ -0,0 +1,12 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; + +-- LDEV-4030 Disable login for a few minutes after X number of attempts +ALTER TABLE lams_user +ADD COLUMN failed_attempts TINYINT DEFAULT NULL, +ADD COLUMN lock_out_time DATETIME DEFAULT NULL; + +COMMIT; +SET AUTOCOMMIT = 1; + +