DROP TABLE QRTZ_BLOB_TRIGGERS;
DROP TABLE QRTZ_CALENDARS;
DROP TABLE QRTZ_CRON_TRIGGERS;
DROP TABLE QRTZ_FIRED_TRIGGERS;
DROP TABLE QRTZ_JOB_LISTENERS;
DROP TABLE QRTZ_LOCKS;
DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
DROP TABLE QRTZ_SCHEDULER_STATE;
DROP TABLE QRTZ_SIMPLE_TRIGGERS;
DROP TABLE QRTZ_TRIGGER_LISTENERS;
DROP TABLE QRTZ_TRIGGERS;
DROP TABLE QRTZ_JOB_DETAILS;
CREATE TABLE QRTZ_BLOB_TRIGGERS
(
   TRIGGER_NAME varchar(200) NOT NULL,
   TRIGGER_GROUP varchar(200) NOT NULL,
   BLOB_DATA blob,
   CONSTRAINT SYS_C0052027 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP)
)
;
CREATE TABLE QRTZ_CALENDARS
(
   CALENDAR_NAME varchar(200) PRIMARY KEY NOT NULL,
   CALENDAR blob NOT NULL
)
;
CREATE TABLE QRTZ_CRON_TRIGGERS
(
   TRIGGER_NAME varchar(200) NOT NULL,
   TRIGGER_GROUP varchar(200) NOT NULL,
   CRON_EXPRESSION varchar(120) NOT NULL,
   TIME_ZONE_ID varchar(80),
   CONSTRAINT SYS_C0052023 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP)
)
;
CREATE TABLE QRTZ_FIRED_TRIGGERS
(
   ENTRY_ID varchar(95) PRIMARY KEY NOT NULL,
   TRIGGER_NAME varchar(200) NOT NULL,
   TRIGGER_GROUP varchar(200) NOT NULL,
   IS_VOLATILE SMALLINT NOT NULL,
   INSTANCE_NAME varchar(200) NOT NULL,
   FIRED_TIME decimal(13) NOT NULL,
   PRIORITY decimal(13) NOT NULL,
   STATE varchar(16) NOT NULL,
   JOB_NAME varchar(200),
   JOB_GROUP varchar(200),
   IS_STATEFUL SMALLINT,
   REQUESTS_RECOVERY SMALLINT
)
;
CREATE TABLE QRTZ_JOB_DETAILS
(
   JOB_NAME varchar(200) NOT NULL,
   JOB_GROUP varchar(200) NOT NULL,
   DESCRIPTION varchar(250),
   JOB_CLASS_NAME varchar(250) NOT NULL,
   IS_DURABLE SMALLINT NOT NULL,
   IS_VOLATILE SMALLINT NOT NULL,
   IS_STATEFUL SMALLINT NOT NULL,
   REQUESTS_RECOVERY SMALLINT NOT NULL,
   JOB_DATA blob,
   CONSTRAINT SYS_C0051997 PRIMARY KEY (JOB_NAME,JOB_GROUP)
)
;
CREATE TABLE QRTZ_JOB_LISTENERS
(
   JOB_NAME varchar(200) NOT NULL,
   JOB_GROUP varchar(200) NOT NULL,
   JOB_LISTENER varchar(200) NOT NULL,
   CONSTRAINT SYS_C0052001 PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER)
)
;
CREATE TABLE QRTZ_LOCKS
(
   LOCK_NAME varchar(40) PRIMARY KEY NOT NULL
)
;
CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS
(
   TRIGGER_GROUP varchar(200) PRIMARY KEY NOT NULL
)
;
CREATE TABLE QRTZ_SCHEDULER_STATE
(
   INSTANCE_NAME varchar(200) PRIMARY KEY NOT NULL,
   LAST_CHECKIN_TIME decimal(13) NOT NULL,
   CHECKIN_INTERVAL decimal(13) NOT NULL
)
;
CREATE TABLE QRTZ_SIMPLE_TRIGGERS
(
   TRIGGER_NAME varchar(200) NOT NULL,
   TRIGGER_GROUP varchar(200) NOT NULL,
   REPEAT_COUNT decimal(7) NOT NULL,
   REPEAT_INTERVAL decimal(12) NOT NULL,
   TIMES_TRIGGERED decimal(10) NOT NULL,
   CONSTRAINT SYS_C0052018 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP)
)
;
CREATE TABLE QRTZ_TRIGGER_LISTENERS
(
   TRIGGER_NAME varchar(200) NOT NULL,
   TRIGGER_GROUP varchar(200) NOT NULL,
   TRIGGER_LISTENER varchar(200) NOT NULL,
   CONSTRAINT SYS_C0052032 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER)
)
;
CREATE TABLE QRTZ_TRIGGERS
(
   TRIGGER_NAME varchar(200) NOT NULL,
   TRIGGER_GROUP varchar(200) NOT NULL,
   JOB_NAME varchar(200) NOT NULL,
   JOB_GROUP varchar(200) NOT NULL,
   IS_VOLATILE SMALLINT NOT NULL,
   DESCRIPTION varchar(250),
   NEXT_FIRE_TIME decimal(13),
   PREV_FIRE_TIME decimal(13),
   PRIORITY decimal(13),
   TRIGGER_STATE varchar(16) NOT NULL,
   TRIGGER_TYPE varchar(8) NOT NULL,
   START_TIME decimal(13) NOT NULL,
   END_TIME decimal(13),
   CALENDAR_NAME varchar(200),
   MISFIRE_INSTR decimal(2),
   JOB_DATA blob,
   CONSTRAINT SYS_C0052011 PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP)
)
; 
ALTER TABLE QRTZ_BLOB_TRIGGERS
ADD CONSTRAINT SYS_C0052662
FOREIGN KEY
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
REFERENCES QRTZ_TRIGGERS
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
;
ALTER TABLE QRTZ_CRON_TRIGGERS
ADD CONSTRAINT SYS_C0052663
FOREIGN KEY
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
REFERENCES QRTZ_TRIGGERS
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
;
CREATE INDEX IDX_QRTZ_FT_JOB_GROUP ON QRTZ_FIRED_TRIGGERS(JOB_GROUP)
;
CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(INSTANCE_NAME)
;
CREATE INDEX IDX_QRTZ_FT_TRIG_VOLATILE ON QRTZ_FIRED_TRIGGERS(IS_VOLATILE)
;
CREATE INDEX IDX_QRTZ_FT_TRIG_NAME ON QRTZ_FIRED_TRIGGERS(TRIGGER_NAME)
;
CREATE INDEX IDX_QRTZ_FT_JOB_NAME ON QRTZ_FIRED_TRIGGERS(JOB_NAME)
;
CREATE INDEX IDX_QRTZ_FT_JOB_REQ_RECOVERY ON QRTZ_FIRED_TRIGGERS(REQUESTS_RECOVERY)
;
CREATE INDEX IDX_QRTZ_FT_JOB_STATEFUL ON QRTZ_FIRED_TRIGGERS(IS_STATEFUL)
;
CREATE INDEX IDX_QRTZ_FT_TRIG_GROUP ON QRTZ_FIRED_TRIGGERS(TRIGGER_GROUP)
;
CREATE INDEX IDX_QRTZ_FT_TRIG_NM_GP ON QRTZ_FIRED_TRIGGERS
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
;
CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(REQUESTS_RECOVERY)
;
ALTER TABLE QRTZ_JOB_LISTENERS
ADD CONSTRAINT SYS_C0052664
FOREIGN KEY
(
  JOB_NAME,
  JOB_GROUP
)
REFERENCES QRTZ_JOB_DETAILS
(
  JOB_NAME,
  JOB_GROUP
)
;
ALTER TABLE QRTZ_SIMPLE_TRIGGERS
ADD CONSTRAINT SYS_C0052665
FOREIGN KEY
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
REFERENCES QRTZ_TRIGGERS
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
;
ALTER TABLE QRTZ_TRIGGER_LISTENERS
ADD CONSTRAINT SYS_C0052667
FOREIGN KEY
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
REFERENCES QRTZ_TRIGGERS
(
  TRIGGER_NAME,
  TRIGGER_GROUP
)
;
ALTER TABLE QRTZ_TRIGGERS
ADD CONSTRAINT SYS_C0052666
FOREIGN KEY
(
  JOB_NAME,
  JOB_GROUP
)
REFERENCES QRTZ_JOB_DETAILS
(
  JOB_NAME,
  JOB_GROUP
)
;
CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(NEXT_FIRE_TIME)
;
CREATE INDEX IDX_QRTZ_T_VOLATILE ON QRTZ_TRIGGERS(IS_VOLATILE)
;
CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(TRIGGER_STATE)
;
CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS
(
  NEXT_FIRE_TIME,
  TRIGGER_STATE
)
; 
INSERT INTO QRTZ_LOCKS (LOCK_NAME) VALUES ('CALENDAR_ACCESS');
INSERT INTO QRTZ_LOCKS (LOCK_NAME) VALUES ('JOB_ACCESS');
INSERT INTO QRTZ_LOCKS (LOCK_NAME) VALUES ('MISFIRE_ACCESS');
INSERT INTO QRTZ_LOCKS (LOCK_NAME) VALUES ('STATE_ACCESS');
INSERT INTO QRTZ_LOCKS (LOCK_NAME) VALUES ('TRIGGER_ACCESS');