text: create table ACT_RU_JOB (
      ID_ varchar(64) not null,
      REV_ integer,
      TYPE_ varchar(255) not null,
      LOCK_EXP_TIME_ timestamp,
      LOCK_OWNER_ varchar(255),
      EXCLUSIVE_ smallint check(EXCLUSIVE_ in (1,0)),
      EXECUTION_ID_ varchar(64),
      PROCESS_INSTANCE_ID_ varchar(64),
      PROC_DEF_ID_ varchar(64),
      SCOPE_ID_ varchar(255),
      SUB_SCOPE_ID_ varchar(255),
      SCOPE_TYPE_ varchar(255),
      SCOPE_DEFINITION_ID_ varchar(255),
      RETRIES_ integer,
      EXCEPTION_STACK_ID_ varchar(64),
      EXCEPTION_MSG_ varchar(4000),
      DUEDATE_ timestamp,
      REPEAT_ varchar(255),
      HANDLER_TYPE_ varchar(255),
      HANDLER_CFG_ varchar(4000),
      CUSTOM_VALUES_ID_ varchar(64),
      CREATE_TIME_ timestamp,
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_TIMER_JOB (
      ID_ varchar(64) not null,
      REV_ integer,
      TYPE_ varchar(255) not null,
      LOCK_EXP_TIME_ timestamp,
      LOCK_OWNER_ varchar(255),
      EXCLUSIVE_ smallint check(EXCLUSIVE_ in (1,0)),
      EXECUTION_ID_ varchar(64),
      PROCESS_INSTANCE_ID_ varchar(64),
      PROC_DEF_ID_ varchar(64),
      SCOPE_ID_ varchar(255),
      SUB_SCOPE_ID_ varchar(255),
      SCOPE_TYPE_ varchar(255),
      SCOPE_DEFINITION_ID_ varchar(255),
      RETRIES_ integer,
      EXCEPTION_STACK_ID_ varchar(64),
      EXCEPTION_MSG_ varchar(4000),
      DUEDATE_ timestamp,
      REPEAT_ varchar(255),
      HANDLER_TYPE_ varchar(255),
      HANDLER_CFG_ varchar(4000),
      CUSTOM_VALUES_ID_ varchar(64),
      CREATE_TIME_ timestamp,
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_SUSPENDED_JOB (
      ID_ varchar(64) not null,
      REV_ integer,
      TYPE_ varchar(255) not null,
      EXCLUSIVE_ smallint check(EXCLUSIVE_ in (1,0)),
      EXECUTION_ID_ varchar(64),
      PROCESS_INSTANCE_ID_ varchar(64),
      PROC_DEF_ID_ varchar(64),
      SCOPE_ID_ varchar(255),
      SUB_SCOPE_ID_ varchar(255),
      SCOPE_TYPE_ varchar(255),
      SCOPE_DEFINITION_ID_ varchar(255),
      RETRIES_ integer,
      EXCEPTION_STACK_ID_ varchar(64),
      EXCEPTION_MSG_ varchar(4000),
      DUEDATE_ timestamp,
      REPEAT_ varchar(255),
      HANDLER_TYPE_ varchar(255),
      HANDLER_CFG_ varchar(4000),
      CUSTOM_VALUES_ID_ varchar(64),
      CREATE_TIME_ timestamp,
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_DEADLETTER_JOB (
      ID_ varchar(64) not null,
      REV_ integer,
      TYPE_ varchar(255) not null,
      EXCLUSIVE_ smallint check(EXCLUSIVE_ in (1,0)),
      EXECUTION_ID_ varchar(64),
      PROCESS_INSTANCE_ID_ varchar(64),
      PROC_DEF_ID_ varchar(64),
      SCOPE_ID_ varchar(255),
      SUB_SCOPE_ID_ varchar(255),
      SCOPE_TYPE_ varchar(255),
      SCOPE_DEFINITION_ID_ varchar(255),
      EXCEPTION_STACK_ID_ varchar(64),
      EXCEPTION_MSG_ varchar(4000),
      DUEDATE_ timestamp,
      REPEAT_ varchar(255),
      HANDLER_TYPE_ varchar(255),
      HANDLER_CFG_ varchar(4000),
      CUSTOM_VALUES_ID_ varchar(64),
      CREATE_TIME_ timestamp,
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_HISTORY_JOB (
      ID_ varchar(64) NOT NULL,
      REV_ integer,
      LOCK_EXP_TIME_ timestamp,
      LOCK_OWNER_ varchar(255),
      RETRIES_ integer,
      EXCEPTION_STACK_ID_ varchar(64),
      EXCEPTION_MSG_ varchar(4000),
      HANDLER_TYPE_ varchar(255),
      HANDLER_CFG_ varchar(4000),
      CUSTOM_VALUES_ID_ varchar(64),
      ADV_HANDLER_CFG_ID_ varchar(64),
      CREATE_TIME_ timestamp,
      SCOPE_TYPE_ varchar(255),
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  );
  
  create index ACT_IDX_JOB_EXCEPTION_ID on ACT_RU_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_JOB_CUSTOM_VAL_ID on ACT_RU_JOB(CUSTOM_VALUES_ID_);
  
  create index ACT_IDX_TJOB_EXCEPTION_ID on ACT_RU_TIMER_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_TJOB_CUSTOM_VAL_ID on ACT_RU_TIMER_JOB(CUSTOM_VALUES_ID_);
  
  create index ACT_IDX_SJOB_EXCEPTION_ID on ACT_RU_SUSPENDED_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_SJOB_CUSTOM_VAL_ID on ACT_RU_SUSPENDED_JOB(CUSTOM_VALUES_ID_);
  
  create index ACT_IDX_DJOB_EXCEPTION_ID on ACT_RU_DEADLETTER_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_DJOB_CUSTOM_VAL_ID on ACT_RU_DEADLETTER_JOB(CUSTOM_VALUES_ID_);
  
  alter table ACT_RU_JOB
      add constraint ACT_FK_JOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_JOB
      add constraint ACT_FK_JOB_CUSTOM_VAL
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_TIMER_JOB
      add constraint ACT_FK_TJOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_TIMER_JOB
      add constraint ACT_FK_TJOB_CUSTOM_VAL
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_SUSPENDED_JOB
      add constraint ACT_FK_SJOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_SUSPENDED_JOB
      add constraint ACT_FK_SJOB_CUSTOM_VAL
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_DEADLETTER_JOB
      add constraint ACT_FK_DJOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_DEADLETTER_JOB
      add constraint ACT_FK_DJOB_CUSTOM_VAL
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  create index ACT_IDX_JOB_SCOPE on ACT_RU_JOB(SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_JOB_SUB_SCOPE on ACT_RU_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_JOB_SCOPE_DEF on ACT_RU_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_);
  
  create index ACT_IDX_TJOB_SCOPE on ACT_RU_TIMER_JOB(SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_TJOB_SUB_SCOPE on ACT_RU_TIMER_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_TJOB_SCOPE_DEF on ACT_RU_TIMER_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); 
  
  create index ACT_IDX_SJOB_SCOPE on ACT_RU_SUSPENDED_JOB(SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_SJOB_SUB_SCOPE on ACT_RU_SUSPENDED_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_SJOB_SCOPE_DEF on ACT_RU_SUSPENDED_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_);   
  
  create index ACT_IDX_DJOB_SCOPE on ACT_RU_DEADLETTER_JOB(SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_DJOB_SUB_SCOPE on ACT_RU_DEADLETTER_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_DJOB_SCOPE_DEF on ACT_RU_DEADLETTER_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); 
  
  insert into ACT_GE_PROPERTY values ('job.schema.version', '6.4.1.1', 1);