1# Taken from candlepin-0.9.54.7/code/schema/quartz/tables_hsqldb.sql 2# ------------------------------------------------------------------ 3# 4# In your Quartz properties file, you'll need to set 5# org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate 6# 7 8DROP TABLE qrtz_locks IF EXISTS; 9DROP TABLE qrtz_scheduler_state IF EXISTS; 10DROP TABLE qrtz_fired_triggers IF EXISTS; 11DROP TABLE qrtz_paused_trigger_grps IF EXISTS; 12DROP TABLE qrtz_calendars IF EXISTS; 13DROP TABLE qrtz_trigger_listeners IF EXISTS; 14DROP TABLE qrtz_blob_triggers IF EXISTS; 15DROP TABLE qrtz_cron_triggers IF EXISTS; 16DROP TABLE qrtz_simple_triggers IF EXISTS; 17DROP TABLE qrtz_triggers IF EXISTS; 18DROP TABLE qrtz_job_listeners IF EXISTS; 19DROP TABLE qrtz_job_details IF EXISTS; 20 21CREATE TABLE qrtz_job_details 22( 23JOB_NAME VARCHAR(200) NOT NULL, 24JOB_GROUP VARCHAR(200) NOT NULL, 25DESCRIPTION VARCHAR(250) NULL, 26JOB_CLASS_NAME VARCHAR(250) NOT NULL, 27IS_DURABLE BOOLEAN NOT NULL, 28IS_VOLATILE BOOLEAN NOT NULL, 29IS_STATEFUL BOOLEAN NOT NULL, 30REQUESTS_RECOVERY BOOLEAN NOT NULL, 31JOB_DATA BINARY NULL, 32PRIMARY KEY (JOB_NAME,JOB_GROUP) 33); 34