DROP TABLE IF EXISTS QRTZ_JOB_LISTENERS;DROP TABLE IF EXISTS QRTZ_TRIGGER_LISTENERS;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_BLOB_TRIGGERS;DROP TABLE IF EXISTS QRTZ_CRON_TRIGGERS;DROP TABLE IF EXISTS QRTZ_TRIGGERS;DROP TABLE IF EXISTS QRTZ_JOB_DETAILS;DROP TABLE IF EXISTS QRTZ_CALENDARS;DROP TABLE IF EXISTS QRTZ_SCHEDULER_STATE;DROP TABLE IF EXISTS OS_PROPERTYENTRY;DROP TABLE IF EXISTS OS_CURRENTSTEP_PREV;DROP TABLE IF EXISTS OS_HISTORYSTEP_PREV;DROP TABLE IF EXISTS OS_CURRENTSTEP;DROP TABLE IF EXISTS OS_HISTORYSTEP;DROP TABLE IF EXISTS OS_WFENTRY;CREATE TABLE OS_WFENTRY(    ID int,    NAME varchar(128),    STATE smallint,    primary key (ID));CREATE TABLE OS_CURRENTSTEP(    ID bigint,    ENTRY_ID bigint,    STEP_ID smallint,    ACTION_ID smallint,    OWNER varchar(20),    START_DATE TIMESTAMP ,    FINISH_DATE TIMESTAMP ,    DUE_DATE TIMESTAMP ,    STATUS varchar(20),    CALLER varchar(20),    primary key (ID),    foreign key (ENTRY_ID) references OS_WFENTRY(ID));CREATE TABLE OS_HISTORYSTEP(    ID bigint,    ENTRY_ID bigint,    STEP_ID smallint,    ACTION_ID smallint,    OWNER varchar(20),    START_DATE TIMESTAMP ,    FINISH_DATE TIMESTAMP ,    DUE_DATE TIMESTAMP ,    STATUS varchar(20),    CALLER varchar(20),    primary key (ID),    foreign key (ENTRY_ID) references OS_WFENTRY(ID));CREATE TABLE OS_CURRENTSTEP_PREV(    ID bigint,    PREVIOUS_ID bigint,    primary key (ID, PREVIOUS_ID),    foreign key (ID) references OS_CURRENTSTEP(ID),    foreign key (PREVIOUS_ID) references OS_HISTORYSTEP(ID));CREATE TABLE OS_HISTORYSTEP_PREV(    ID bigint,    PREVIOUS_ID bigint,    primary key (ID, PREVIOUS_ID),    foreign key (ID) references OS_HISTORYSTEP(ID),    foreign key (PREVIOUS_ID) references OS_HISTORYSTEP(ID));CREATE TABLE OS_PROPERTYENTRY(  GLOBAL_KEY varchar(255),  ITEM_KEY varchar(255),  ITEM_TYPE smallint,  STRING_VALUE varchar(255),  DATE_VALUE TIMESTAMP ,  DATA_VALUE varbinary(2000),  FLOAT_VALUE float,  NUMBER_VALUE numeric,  primary key (GLOBAL_KEY, ITEM_KEY));CREATE TABLE QRTZ_JOB_DETAILS  (    JOB_NAME  VARCHAR(80) NOT NULL,    JOB_GROUP VARCHAR(80) NOT NULL,    DESCRIPTION VARCHAR(120) NULL,    JOB_CLASS_NAME   VARCHAR(128) NOT NULL,    IS_DURABLE VARCHAR(1) NOT NULL,    IS_VOLATILE VARCHAR(1) NOT NULL,    IS_STATEFUL VARCHAR(1) NOT NULL,    REQUESTS_RECOVERY VARCHAR(1) NOT NULL,    JOB_DATA varbinary(2000) NULL,    PRIMARY KEY (JOB_NAME,JOB_GROUP));CREATE TABLE QRTZ_JOB_LISTENERS  (      JOB_NAME  VARCHAR(80) NOT NULL,      JOB_GROUP VARCHAR(80) NOT NULL,      JOB_LISTENER VARCHAR(80) NOT NULL,      PRIMARY KEY (JOB_NAME,JOB_GROUP,JOB_LISTENER),      FOREIGN KEY (JOB_NAME,JOB_GROUP)      REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP));CREATE TABLE QRTZ_TRIGGERS  (    TRIGGER_NAME VARCHAR(80) NOT NULL,    TRIGGER_GROUP VARCHAR(80) NOT NULL,    JOB_NAME  VARCHAR(80) NOT NULL,    JOB_GROUP VARCHAR(80) NOT NULL,    IS_VOLATILE VARCHAR(1) NOT NULL,    DESCRIPTION VARCHAR(120) NULL,    NEXT_FIRE_TIME numeric NULL,    PREV_FIRE_TIME numeric NULL,    TRIGGER_STATE VARCHAR(16) NOT NULL,    TRIGGER_TYPE VARCHAR(8) NOT NULL,    START_TIME numeric NOT NULL,    END_TIME numeric NULL,    CALENDAR_NAME VARCHAR(80) NULL,    MISFIRE_INSTR smallint NULL,    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),    FOREIGN KEY (JOB_NAME,JOB_GROUP)    REFERENCES QRTZ_JOB_DETAILS(JOB_NAME,JOB_GROUP));CREATE TABLE QRTZ_SIMPLE_TRIGGERS  (    TRIGGER_NAME VARCHAR(80) NOT NULL,    TRIGGER_GROUP VARCHAR(80) NOT NULL,    REPEAT_COUNT numeric NOT NULL,    REPEAT_INTERVAL numeric NOT NULL,    TIMES_TRIGGERED numeric NOT NULL,    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)    REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE QRTZ_CRON_TRIGGERS  (    TRIGGER_NAME VARCHAR(80) NOT NULL,    TRIGGER_GROUP VARCHAR(80) NOT NULL,    CRON_EXPRESSION VARCHAR(80) NOT NULL,    TIME_ZONE_ID VARCHAR(80),    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE QRTZ_BLOB_TRIGGERS  (    TRIGGER_NAME VARCHAR(80) NOT NULL,    TRIGGER_GROUP VARCHAR(80) NOT NULL,    BLOB_DATA VARBINARY NULL,    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP),    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)        REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE QRTZ_TRIGGER_LISTENERS  (    TRIGGER_NAME  VARCHAR(80) NOT NULL,    TRIGGER_GROUP VARCHAR(80) NOT NULL,    TRIGGER_LISTENER VARCHAR(80) NOT NULL,    PRIMARY KEY (TRIGGER_NAME,TRIGGER_GROUP,TRIGGER_LISTENER),    FOREIGN KEY (TRIGGER_NAME,TRIGGER_GROUP)    REFERENCES QRTZ_TRIGGERS(TRIGGER_NAME,TRIGGER_GROUP));CREATE TABLE QRTZ_FIRED_TRIGGERS  (    ENTRY_ID VARCHAR(95) NOT NULL,    TRIGGER_NAME VARCHAR(80) NOT NULL,    TRIGGER_GROUP VARCHAR(80) NOT NULL,    IS_VOLATILE VARCHAR(1) NOT NULL,    INSTANCE_NAME VARCHAR(80) NOT NULL,    FIRED_TIME numeric NOT NULL,    STATE VARCHAR(16) NOT NULL,    JOB_NAME VARCHAR(80) NULL,    JOB_GROUP VARCHAR(80) NULL,    IS_STATEFUL VARCHAR(1) NULL,    REQUESTS_RECOVERY VARCHAR(1) NULL,    PRIMARY KEY (ENTRY_ID));CREATE TABLE QRTZ_CALENDARS  (    CALENDAR_NAME  VARCHAR(80) NOT NULL,    CALENDAR varbinary(2000) NOT NULL,    PRIMARY KEY (CALENDAR_NAME));CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS  (    TRIGGER_GROUP  VARCHAR(80) NOT NULL,    PRIMARY KEY (TRIGGER_GROUP));CREATE TABLE QRTZ_SCHEDULER_STATE  (    INSTANCE_NAME VARCHAR(80) NOT NULL,    LAST_CHECKIN_TIME numeric NOT NULL,    CHECKIN_INTERVAL numeric NOT NULL,    RECOVERER VARCHAR(80) NULL,    PRIMARY KEY (INSTANCE_NAME));CREATE TABLE QRTZ_LOCKS  (    LOCK_NAME  VARCHAR(40) NOT NULL,    PRIMARY KEY (LOCK_NAME));INSERT INTO QRTZ_LOCKS values('TRIGGER_ACCESS');INSERT INTO QRTZ_LOCKS values('JOB_ACCESS');INSERT INTO QRTZ_LOCKS values('CALENDAR_ACCESS');INSERT INTO QRTZ_LOCKS values('STATE_ACCESS');INSERT INTO QRTZ_LOCKS values('MISFIRE_ACCESS');