Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql
===================================================================
RCS file: /usr/local/cvsroot/lams_common/src/java/org/lamsfoundation/lams/dbupdates/Attic/patch02040038.sql,v
diff -u -r1.1.2.4 -r1.1.2.5
--- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql	19 Dec 2014 09:51:12 -0000	1.1.2.4
+++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql	20 Dec 2014 20:39:06 -0000	1.1.2.5
@@ -73,18 +73,19 @@
 
 -- drop all primary and foreign key constraints, so that we can define new ones
 
-ALTER TABLE lams_qtz_TRIGGERS DROP FOREIGN KEY lams_qtz_triggers_ibfk_1;
+ALTER TABLE lams_qtz_TRIGGERS DROP FOREIGN KEY lams_qtz_TRIGGERS_ibfk_1;
 ALTER TABLE lams_qtz_TRIGGERS DROP INDEX job_name;
-ALTER TABLE lams_qtz_BLOB_TRIGGERS DROP FOREIGN KEY lams_qtz_blob_triggers_ibfk_1;
+ALTER TABLE lams_qtz_BLOB_TRIGGERS DROP FOREIGN KEY lams_qtz_BLOB_TRIGGERS_ibfk_1;
 ALTER TABLE lams_qtz_BLOB_TRIGGERS DROP PRIMARY KEY;
-ALTER TABLE lams_qtz_SIMPLE_TRIGGERS DROP FOREIGN KEY lams_qtz_simple_triggers_ibfk_1;
+ALTER TABLE lams_qtz_SIMPLE_TRIGGERS DROP FOREIGN KEY lams_qtz_SIMPLE_TRIGGERS_ibfk_1;
 ALTER TABLE lams_qtz_SIMPLE_TRIGGERS DROP PRIMARY KEY;
-ALTER TABLE lams_qtz_CRON_TRIGGERS DROP FOREIGN KEY lams_qtz_cron_triggers_ibfk_1;
+ALTER TABLE lams_qtz_CRON_TRIGGERS DROP FOREIGN KEY lams_qtz_CRON_TRIGGERS_ibfk_1;
 ALTER TABLE lams_qtz_CRON_TRIGGERS DROP PRIMARY KEY;
 ALTER TABLE lams_qtz_JOB_DETAILS DROP PRIMARY KEY;
 ALTER TABLE lams_qtz_JOB_DETAILS ADD PRIMARY KEY (sched_name, job_name, job_group);
 ALTER TABLE lams_qtz_TRIGGERS DROP PRIMARY KEY;
 
+
 -- add all primary and foreign key constraints, based on new columns
 
 ALTER TABLE lams_qtz_TRIGGERS ADD PRIMARY KEY (sched_name, trigger_name, trigger_group);