Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20200129.sql =================================================================== diff -u -rbe35a3f2bf2414f299ca74f4ea8c3e2555b16d8e -r02136d4df9af6be16c536db6c22ba26bce92ac2e --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20200129.sql (.../patch20200129.sql) (revision be35a3f2bf2414f299ca74f4ea8c3e2555b16d8e) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch20200129.sql (.../patch20200129.sql) (revision 02136d4df9af6be16c536db6c22ba26bce92ac2e) @@ -3,17 +3,17 @@ -- LDEV-4959 Prevent leader and non-leader from creating two GradebookUserLessons at the same time ---Take care about potential duplicates. For this move all entries to tmp table first. +-- Take care about potential duplicates. For this move all entries to tmp table first. CREATE TABLE tmp_table SELECT * FROM lams_gradebook_user_lesson; TRUNCATE TABLE lams_gradebook_user_lesson; ---Change key to unique +-- Change key to unique ALTER TABLE `lams_gradebook_user_lesson` DROP FOREIGN KEY `FK_lams_gradebook_user_lesson_1`, DROP INDEX `lesson_id`; ALTER TABLE `lams_gradebook_user_lesson` ADD UNIQUE INDEX `lesson_id` (`lesson_id`,`user_id`), ADD CONSTRAINT `FK_lams_gradebook_user_lesson_1` FOREIGN KEY (`lesson_id`) REFERENCES `lams_lesson` (`lesson_id`); ---Move entries back to lams_gradebook_user_lesson +-- Move entries back to lams_gradebook_user_lesson INSERT IGNORE INTO lams_gradebook_user_lesson SELECT * from tmp_table; DROP TABLE tmp_table;