text: CREATE SEQUENCE SEQ_OS_WFENTRY INCREMENT 2 START 10;
  CREATE SEQUENCE SEQ_OS_CURRENTSTEPS INCREMENT 2 START 10;
  
  CREATE TABLE OS_WFENTRY
  (
      ID int,
      NAME varchar(128),
      STATE smallint,
      primary key (ID)
  );
  
  CREATE TABLE OS_CURRENTSTEP
  (
      ID int,
      ENTRY_ID int,
      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 int,
      ENTRY_ID int,
      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 int,
      PREVIOUS_ID int,
      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 int,
      PREVIOUS_ID int,
      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 BLOB 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');
  