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;