Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql
===================================================================
diff -u -r03765383e301d957bbc82fa40d0c3612646d7e4b -r0ce4c64de6f6fbf1eaea18a62b89143d2fa05fe0
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql	(.../patch2040052.sql)	(revision 03765383e301d957bbc82fa40d0c3612646d7e4b)
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql	(.../patch2040052.sql)	(revision 0ce4c64de6f6fbf1eaea18a62b89143d2fa05fe0)
@@ -78,35 +78,35 @@
 ALTER TABLE lams_privilege CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 ALTER TABLE lams_progress_attempted CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
 ALTER TABLE lams_progress_completed CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-ALTER TABLE lams_qtz_blob_triggers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_BLOB_TRIGGERS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 								   MODIFY COLUMN TRIGGER_NAME varchar(191) NOT NULL,
 								   MODIFY COLUMN TRIGGER_GROUP varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_calendars CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_CALENDARS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 							   MODIFY COLUMN CALENDAR_NAME varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_cron_triggers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_CRON_TRIGGERS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 								   MODIFY COLUMN TRIGGER_NAME varchar(191) NOT NULL,
 								   MODIFY COLUMN TRIGGER_GROUP varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_fired_triggers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_FIRED_TRIGGERS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 								    MODIFY COLUMN TRIGGER_NAME varchar(191) NOT NULL,
 								    MODIFY COLUMN TRIGGER_GROUP varchar(191) NOT NULL,
 								    MODIFY COLUMN INSTANCE_NAME varchar(191) NOT NULL,
 								    MODIFY COLUMN JOB_NAME varchar(191) DEFAULT NULL,
 								    MODIFY COLUMN JOB_GROUP varchar(191) DEFAULT NULL;
-ALTER TABLE lams_qtz_job_details CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_JOB_DETAILS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 								 MODIFY COLUMN JOB_NAME varchar(191) NOT NULL,
 								 MODIFY COLUMN JOB_GROUP varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_locks CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
-ALTER TABLE lams_qtz_paused_trigger_grps CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_LOCKS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
+ALTER TABLE lams_qtz_PAUSED_TRIGGER_GRPS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 								   		 MODIFY COLUMN TRIGGER_GROUP varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_scheduler_state CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_SCHEDULER_STATE CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 		   						     MODIFY COLUMN INSTANCE_NAME varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_simple_triggers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_SIMPLE_TRIGGERS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 								     MODIFY COLUMN TRIGGER_NAME varchar(191) NOT NULL,
 								     MODIFY COLUMN TRIGGER_GROUP varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_simprop_triggers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_SIMPROP_TRIGGERS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 								      MODIFY COLUMN TRIGGER_NAME varchar(191) NOT NULL,
 								      MODIFY COLUMN TRIGGER_GROUP varchar(191) NOT NULL;
-ALTER TABLE lams_qtz_triggers CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
+ALTER TABLE lams_qtz_TRIGGERS CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
 							  MODIFY COLUMN TRIGGER_NAME varchar(191) NOT NULL,
 							  MODIFY COLUMN TRIGGER_GROUP varchar(191) NOT NULL,
 							  MODIFY COLUMN JOB_NAME varchar(191) NOT NULL,
@@ -613,4 +613,4 @@
 -- If there were no errors, commit and restore autocommit to on
 SET FOREIGN_KEY_CHECKS=0;
 COMMIT;
-SET AUTOCOMMIT = 1;
\ No newline at end of file
+SET AUTOCOMMIT = 1;