sql 语句如下

  1. alter table qrtz_calendars rename to QRTZ_CALENDARS ;
  2. alter table qrtz_cron_triggers rename to QRTZ_CRON_TRIGGERS ;
  3. alter table qrtz_fired_triggers rename to QRTZ_FIRED_TRIGGERS ;
  4. alter table qrtz_job_details rename to QRTZ_JOB_DETAILS ;
  5. alter table qrtz_locks rename to QRTZ_LOCKS;
  6. alter table qrtz_paused_trigger_grps rename to QRTZ_PAUSED_TRIGGER_GRPS ;
  7. alter table qrtz_scheduler_state rename to QRTZ_SCHEDULER_STATE ;
  8. alter table qrtz_simple_triggers rename to QRTZ_SIMPLE_TRIGGERS ;
  9. alter table qrtz_simprop_triggers rename to QRTZ_SIMPROP_TRIGGERS ;
  10. alter table qrtz_triggers rename to QRTZ_TRIGGERS ;
  11. ALTER TABLE qrtz_blob_triggers RENAME TO QRTZ_BLOB_TRIGGERS;
  12. alter table qrtz_calendars rename to QRTZ_CALENDARS ;
  13. alter table qrtz_cron_triggers rename to QRTZ_CRON_TRIGGERS ;
  14. alter table qrtz_fired_triggers rename to QRTZ_FIRED_TRIGGERS ;
  15. alter table qrtz_job_details rename to QRTZ_JOB_DETAILS ;
  16. alter table qrtz_locks rename to QRTZ_LOCKS;
  17. alter table qrtz_paused_trigger_grps rename to QRTZ_PAUSED_TRIGGER_GRPS ;
  18. alter table qrtz_scheduler_state rename to QRTZ_SCHEDULER_STATE ;
  19. alter table qrtz_simple_triggers rename to QRTZ_SIMPLE_TRIGGERS ;
  20. alter table qrtz_simprop_triggers rename to QRTZ_SIMPROP_TRIGGERS ;
  21. alter table qrtz_triggers rename to QRTZ_TRIGGERS ;
  22. ALTER TABLE qrtz_blob_triggers RENAME TO QRTZ_BLOB_TRIGGERS;