Runtime

--

-- In your Quartz properties file, you'll need to set 

-- org.quartz.jobStore.driverDelegateClass = org.quartz.impl.jdbcjobstore.HSQLDBDelegate

--

​

DROP TABLE qrtz_locks IF EXISTS;

DROP TABLE qrtz_scheduler_state IF EXISTS;

DROP TABLE qrtz_fired_triggers IF EXISTS;

DROP TABLE qrtz_paused_trigger_grps IF EXISTS;

DROP TABLE qrtz_calendars IF EXISTS;

DROP TABLE qrtz_blob_triggers IF EXISTS;

DROP TABLE qrtz_cron_triggers IF EXISTS;

DROP TABLE qrtz_simple_triggers IF EXISTS;

DROP TABLE qrtz_simprop_triggers IF EXISTS;

DROP TABLE qrtz_triggers IF EXISTS;

DROP TABLE qrtz_job_details IF EXISTS;

​

CREATE TABLE qrtz_job_details

(

SCHED_NAME VARCHAR(120) NOT NULL,

JOB_NAME VARCHAR(200) NOT NULL,

JOB_GROUP VARCHAR(200) NOT NULL,

DESCRIPTION VARCHAR(250) NULL,

JOB_CLASS_NAME VARCHAR(250) NOT NULL,

IS_DURABLE BOOLEAN NOT NULL,

IS_NONCONCURRENT BOOLEAN NOT NULL,

IS_UPDATE_DATA BOOLEAN NOT NULL,

REQUESTS_RECOVERY BOOLEAN NOT NULL,

JOB_DATA BLOB NULL,

PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)

);

​

CREATE TABLE qrtz_triggers

(

SCHED_NAME VARCHAR(120) NOT NULL,

TRIGGER_NAME VARCHAR(200) NOT NULL,

TRIGGER_GROUP VARCHAR(200) NOT NULL,

JOB_NAME VARCHAR(200) NOT NULL,

JOB_GROUP VARCHAR(200) NOT NULL,

DESCRIPTION VARCHAR(250) NULL,

NEXT_FIRE_TIME NUMERIC(13) NULL,

PREV_FIRE_TIME NUMERIC(13) NULL,

PRIORITY INTEGER NULL,

TRIGGER_STATE VARCHAR(16) NOT NULL,

TRIGGER_TYPE VARCHAR(8) NOT NULL,

START_TIME NUMERIC(13) NOT NULL,

END_TIME NUMERIC(13) NULL,

CALENDAR_NAME VARCHAR(200) NULL,

MISFIRE_INSTR NUMERIC(2) NULL,

JOB_DATA BLOB NULL,

PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),

FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)

REFERENCES QRTZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)

);

​

CREATE TABLE qrtz_simple_triggers

(

SCHED_NAME VARCHAR(120) NOT NULL,

TRIGGER_NAME VARCHAR(200) NOT NULL,

TRIGGER_GROUP VARCHAR(200) NOT NULL,

REPEAT_COUNT NUMERIC(7) NOT NULL,

REPEAT_INTERVAL NUMERIC(12) NOT NULL,

TIMES_TRIGGERED NUMERIC(10) NOT NULL,