Index: lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql =================================================================== diff -u -rd4e4d7009c93b513dbfe99418fdda5ca6f2bdb43 -rc06e2a51a7f8d6cfc4a66b8e1ea618d89876bacd --- lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql (.../patch02040038.sql) (revision d4e4d7009c93b513dbfe99418fdda5ca6f2bdb43) +++ lams_common/src/java/org/lamsfoundation/lams/dbupdates/patch02040038.sql (.../patch02040038.sql) (revision c06e2a51a7f8d6cfc4a66b8e1ea618d89876bacd) @@ -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);