Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040064.sql =================================================================== diff -u -r8fc48568c579f2b32041d489a8ebf02075847fa3 -r5f1f06a02b0d47d64e75c33fc6d16861c71b5e32 --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040064.sql (.../patch2040064.sql) (revision 8fc48568c579f2b32041d489a8ebf02075847fa3) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040064.sql (.../patch2040064.sql) (revision 5f1f06a02b0d47d64e75c33fc6d16861c71b5e32) @@ -21,7 +21,7 @@ REFERENCES lams_lesson (lesson_id) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT FK_lams_learner_progress_archive_3 FOREIGN KEY (current_activity_id) REFERENCES lams_learning_activity (activity_id) ON UPDATE CASCADE ON DELETE SET NULL -) ENGINE=InnoDB DEFAULT CHARSET utf8mb4; +) ENGINE=InnoDB; CREATE TABLE lams_progress_attempted_archive ( @@ -33,7 +33,7 @@ REFERENCES lams_learner_progress_archive (learner_progress_id) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT FK_lams_progress_current_archive_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON UPDATE CASCADE ON DELETE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET utf8mb4; +) ENGINE=InnoDB; CREATE TABLE lams_progress_completed_archive ( @@ -46,12 +46,12 @@ REFERENCES lams_learner_progress_archive (learner_progress_id) ON UPDATE CASCADE ON DELETE CASCADE, CONSTRAINT FK_lams_progress_completed_archive_2 FOREIGN KEY (activity_id) REFERENCES lams_learning_activity (activity_id) ON UPDATE CASCADE ON DELETE CASCADE -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; +) ENGINE=InnoDB; -- make restart an option ALTER TABLE lams_lesson CHANGE COLUMN learner_restart force_restart tinyint(1) DEFAULT '0', ADD COLUMN allow_restart tinyint(1) DEFAULT '0'; COMMIT; -SET AUTOCOMMIT = 1; \ No newline at end of file +SET AUTOCOMMIT = 1;