Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch2040052.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql	15 Dec 2015 18:06:06 -0000	1.1.2.1
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch2040052.sql	18 Dec 2015 04:40:32 -0000	1.1.2.2
@@ -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;