Index: lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171011.sql =================================================================== diff -u -rb84f4507a85a8c50ffcce01b5c5a988ac56f0849 -raea751ae9517099f166c6b5804071659710a925b --- lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171011.sql (.../patch20171011.sql) (revision b84f4507a85a8c50ffcce01b5c5a988ac56f0849) +++ lams_tool_assessment/src/java/org/lamsfoundation/lams/tool/assessment/dbupdates/patch20171011.sql (.../patch20171011.sql) (revision aea751ae9517099f166c6b5804071659710a925b) @@ -21,6 +21,9 @@ --add unique constraint ALTER TABLE tl_laasse10_assessment_result ADD UNIQUE KEY UQ_tl_laasse10_assessment_result_5 (assessment_uid, user_uid, latest); +--remove unique constraint previously added in patch20170822.sql (LDEV-4410 Add unique index to prevent duplicate result copied from leader) +ALTER TABLE tl_laasse10_assessment_result DROP INDEX UQ_tl_laasse10_assessment_result_4; + UPDATE lams_tool SET tool_version='20171011' WHERE tool_signature='laasse10'; ----------------------Put all sql statements above here-------------------------