Index: lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/ForgotPasswordRequest.hbm.xml =================================================================== diff -u -rc7798d2b81a0595194a5e905ef6c33e372ad8007 -rb9ef68053fada854636475569888b97dafbe6e54 --- lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/ForgotPasswordRequest.hbm.xml (.../ForgotPasswordRequest.hbm.xml) (revision c7798d2b81a0595194a5e905ef6c33e372ad8007) +++ lams_common/conf/hibernate/mappings/org/lamsfoundation/lams/usermanagement/ForgotPasswordRequest.hbm.xml (.../ForgotPasswordRequest.hbm.xml) (revision b9ef68053fada854636475569888b97dafbe6e54) @@ -59,7 +59,7 @@ column="request_key" not-null="true" unique="true" - length="32" + length="36" > true Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170628.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170628.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20170628.sql (revision b9ef68053fada854636475569888b97dafbe6e54) @@ -0,0 +1,15 @@ +-- Turn off autocommit, so nothing is committed if there is an error +SET AUTOCOMMIT = 0; +SET FOREIGN_KEY_CHECKS=0; +----------------------Put all sql statements below here------------------------- + +-- LDEV-4184, LDEV-4368 Allow longer ID format for password recovery request key + +ALTER TABLE lams_password_request MODIFY COLUMN request_key CHAR(36); + +----------------------Put all sql statements above here------------------------- + +-- If there were no errors, commit and restore autocommit to on +COMMIT; +SET AUTOCOMMIT = 1; +SET FOREIGN_KEY_CHECKS=1;