Index: win_installer/updater/src/sql/removeConfigs.sql =================================================================== diff -u -rde355f2f9e24e128a14b3bf995c815841b9120e4 -rce527ca7142b00c27f254eba5e868c3712cedd06 --- win_installer/updater/src/sql/removeConfigs.sql (.../removeConfigs.sql) (revision de355f2f9e24e128a14b3bf995c815841b9120e4) +++ win_installer/updater/src/sql/removeConfigs.sql (.../removeConfigs.sql) (revision ce527ca7142b00c27f254eba5e868c3712cedd06) @@ -18,16 +18,16 @@ delete from lams_qtz_JOB_DETAILS; -- From 2.2 onwards. WINDOWS ONLY. Make sure quatz tables are set as capitals -Replace lams_qtz_blob_triggers with lams_qtz_BLOB_TRIGGERS -Replace lams_qtz_calendars with lams_qtz_CALENDARS -Replace lams_qtz_cron_triggers with lams_qtz_CRON_TRIGGERS -Replace lams_qtz_fired_triggers with lams_qtz_FIRED_TRIGGERS -Replace lams_qtz_job_details with lams_qtz_JOB_DETAILS -Replace lams_qtz_job_listeners with lams_qtz_JOB_LISTENERS -Replace lams_qtz_locks with ams_qtz_LOCKS -Replace lams_qtz_paused_trigger_grps with lams_qtz_PAUSED_TRIGGER_GRPS -Replace lams_qtz_scheduler_state with lams_qtz_SCHEDULER_STATE -Replace lams_qtz_simple_triggers with lams_qtz_SIMPLE_TRIGGERS -Replace lams_qtz_triggers with lams_qtz_TRIGGERS -Replace lams_qtz_trigger_listeners with lams_qtz_TRIGGER_LISTENERS +rename table lams_qtz_blob_triggers to lams_qtz_BLOB_TRIGGERS; +rename table lams_qtz_calendars to lams_qtz_CALENDARS; +rename table lams_qtz_cron_triggers to lams_qtz_CRON_TRIGGERS; +rename table lams_qtz_fired_triggers to lams_qtz_FIRED_TRIGGERS; +rename table lams_qtz_job_details to lams_qtz_JOB_DETAILS; +rename table lams_qtz_job_listeners to lams_qtz_JOB_LISTENERS; +rename table lams_qtz_locks to ams_qtz_LOCKS; +rename table lams_qtz_paused_trigger_grps to lams_qtz_PAUSED_TRIGGER_GRPS; +rename table lams_qtz_scheduler_state to lams_qtz_SCHEDULER_STATE; +rename table lams_qtz_simple_triggers to lams_qtz_SIMPLE_TRIGGERS; +rename table lams_qtz_triggers to lams_qtz_TRIGGERS; +rename table lams_qtz_trigger_listeners to lams_qtz_TRIGGER_LISTENERS;