Index: lams_admin/src/java/org/lamsfoundation/lams/admin/web/controller/ExtServerManagementController.java =================================================================== diff -u -r8c86b938e95d7e4081ddcba08a23012c813d936d -ra371801d3c9c3da48ba13bbf6fbfe9997dda5aeb --- lams_admin/src/java/org/lamsfoundation/lams/admin/web/controller/ExtServerManagementController.java (.../ExtServerManagementController.java) (revision 8c86b938e95d7e4081ddcba08a23012c813d936d) +++ lams_admin/src/java/org/lamsfoundation/lams/admin/web/controller/ExtServerManagementController.java (.../ExtServerManagementController.java) (revision a371801d3c9c3da48ba13bbf6fbfe9997dda5aeb) @@ -127,21 +127,6 @@ } } } - - List listPrefix = userManagementService.findByProperty(ExtServer.class, "prefix", - extServerForm.getPrefix()); - if (listPrefix != null && listPrefix.size() > 0) { - if (sid.equals(0)) {//new map - errorMap.add("prefix", messageService.getMessage("error.not.unique", - new Object[] { messageService.getMessage("sysadmin.prefix") })); - } else { - ExtServer map = listPrefix.get(0); - if (!map.getSid().equals(sid)) { - errorMap.add("prefix", messageService.getMessage("error.not.unique", - new Object[] { messageService.getMessage("sysadmin.prefix") })); - } - } - } } if (errorMap.isEmpty()) { Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230324.sql =================================================================== diff -u --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230324.sql (revision 0) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20230324.sql (revision a371801d3c9c3da48ba13bbf6fbfe9997dda5aeb) @@ -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-5277 Remove prefix uniqueness as sometimes duplicate feature becomes an useful feature + +ALTER TABLE lams_ext_server_org_map DROP KEY prefix; + +-- 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;