清空人人开源框架的有关于定时任务的表数据

在数据库里面执行下面的SQL语句

SET foreign_key_checks = 0;
truncate table QRTZ_BLOB_TRIGGERS;
truncate table QRTZ_CALENDARS;
truncate table QRTZ_CRON_TRIGGERS;
truncate table QRTZ_FIRED_TRIGGERS;
truncate table QRTZ_TRIGGERS;
truncate table QRTZ_JOB_DETAILS;
truncate table QRTZ_LOCKS;
truncate table QRTZ_PAUSED_TRIGGER_GRPS;
truncate table QRTZ_SCHEDULER_STATE;
truncate table QRTZ_SIMPLE_TRIGGERS;
truncate table QRTZ_SIMPROP_TRIGGERS;
truncate table schedule_job;
truncate table schedule_job_log;
SET foreign_key_checks = 1;

禁用外键约束：SET FOREIGN_KEY_CHECKS=0;

启动外键约束：SET FOREIGN_KEY_CHECKS=1;

清空表XXX的数据：truncate table XXX;