25 lines
844 B
SQL
Executable File
25 lines
844 B
SQL
Executable File
--- 2012-01-24 thorick: separate mysql script to drop the quartz 2.1.2 tables
|
|
|
|
#
|
|
# Quartz seems to work best with the driver mm.mysql-2.0.7-bin.jar
|
|
#
|
|
# PLEASE consider using mysql with innodb tables to avoid locking issues
|
|
#
|
|
# In your Quartz properties file, you'll need to set
|
|
# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.StdJDBCDelegate
|
|
#
|
|
|
|
DROP TABLE IF EXISTS QRTZ_FIRED_TRIGGERS;
|
|
DROP TABLE IF EXISTS QRTZ_PAUSED_TRIGGER_GRPS;
|
|
DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;
|
|
DROP TABLE IF EXISTS QRTZ_LOCKS;
|
|
DROP TABLE IF EXISTS QRTZ_SIMPLE_TRIGGERS;
|
|
DROP TABLE IF EXISTS QRTZ_SIMPROP_TRIGGERS;
|
|
DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;
|
|
DROP TABLE IF EXISTS QRTZ_BLOB_TRIGGERS;
|
|
DROP TABLE IF EXISTS QRTZ_TRIGGERS;
|
|
DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;
|
|
DROP TABLE IF EXISTS QRTZ_CALENDARS;
|
|
|
|
|