text: create table ACT_RU_JOB (
      ID_ nvarchar(64) NOT NULL,
      REV_ int,
      CATEGORY_ varchar(255),
      TYPE_ nvarchar(255) NOT NULL,
      LOCK_EXP_TIME_ datetime,
      LOCK_OWNER_ nvarchar(255),
      EXCLUSIVE_ bit,
      EXECUTION_ID_ nvarchar(64),
      PROCESS_INSTANCE_ID_ nvarchar(64),
      PROC_DEF_ID_ nvarchar(64),
      ELEMENT_ID_ nvarchar(255),
      ELEMENT_NAME_ nvarchar(255),
      SCOPE_ID_ nvarchar(255),
      SUB_SCOPE_ID_ nvarchar(255),
      SCOPE_TYPE_ nvarchar(255),
      SCOPE_DEFINITION_ID_ nvarchar(255),
      RETRIES_ int,
      EXCEPTION_STACK_ID_ nvarchar(64),
      EXCEPTION_MSG_ nvarchar(4000),
      DUEDATE_ datetime NULL,
      REPEAT_ nvarchar(255),
      HANDLER_TYPE_ nvarchar(255),
      HANDLER_CFG_ nvarchar(4000),
      CUSTOM_VALUES_ID_ nvarchar(64),
      CREATE_TIME_ datetime2 NULL,
      TENANT_ID_ nvarchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_TIMER_JOB (
      ID_ nvarchar(64) NOT NULL,
      REV_ int,
      CATEGORY_ varchar(255),
      TYPE_ nvarchar(255) NOT NULL,
      LOCK_EXP_TIME_ datetime,
      LOCK_OWNER_ nvarchar(255),
      EXCLUSIVE_ bit,
      EXECUTION_ID_ nvarchar(64),
      PROCESS_INSTANCE_ID_ nvarchar(64),
      PROC_DEF_ID_ nvarchar(64),
      ELEMENT_ID_ nvarchar(255),
      ELEMENT_NAME_ nvarchar(255),
      SCOPE_ID_ nvarchar(255),
      SUB_SCOPE_ID_ nvarchar(255),
      SCOPE_TYPE_ nvarchar(255),
      SCOPE_DEFINITION_ID_ nvarchar(255),
      RETRIES_ int,
      EXCEPTION_STACK_ID_ nvarchar(64),
      EXCEPTION_MSG_ nvarchar(4000),
      DUEDATE_ datetime NULL,
      REPEAT_ nvarchar(255),
      HANDLER_TYPE_ nvarchar(255),
      HANDLER_CFG_ nvarchar(4000),
      CUSTOM_VALUES_ID_ nvarchar(64),
      CREATE_TIME_ datetime2 NULL,
      TENANT_ID_ nvarchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_SUSPENDED_JOB (
      ID_ nvarchar(64) NOT NULL,
      REV_ int,
      CATEGORY_ varchar(255),
      TYPE_ nvarchar(255) NOT NULL,
      EXCLUSIVE_ bit,
      EXECUTION_ID_ nvarchar(64),
      PROCESS_INSTANCE_ID_ nvarchar(64),
      PROC_DEF_ID_ nvarchar(64),
      ELEMENT_ID_ nvarchar(255),
      ELEMENT_NAME_ nvarchar(255),
      SCOPE_ID_ nvarchar(255),
      SUB_SCOPE_ID_ nvarchar(255),
      SCOPE_TYPE_ nvarchar(255),
      SCOPE_DEFINITION_ID_ nvarchar(255),
      RETRIES_ int,
      EXCEPTION_STACK_ID_ nvarchar(64),
      EXCEPTION_MSG_ nvarchar(4000),
      DUEDATE_ datetime NULL,
      REPEAT_ nvarchar(255),
      HANDLER_TYPE_ nvarchar(255),
      HANDLER_CFG_ nvarchar(4000),
      CUSTOM_VALUES_ID_ nvarchar(64),
      CREATE_TIME_ datetime2 NULL,
      TENANT_ID_ nvarchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_DEADLETTER_JOB (
      ID_ nvarchar(64) NOT NULL,
      REV_ int,
      CATEGORY_ varchar(255),
      TYPE_ nvarchar(255) NOT NULL,
      EXCLUSIVE_ bit,
      EXECUTION_ID_ nvarchar(64),
      PROCESS_INSTANCE_ID_ nvarchar(64),
      PROC_DEF_ID_ nvarchar(64),
      ELEMENT_ID_ nvarchar(255),
      ELEMENT_NAME_ nvarchar(255),
      SCOPE_ID_ nvarchar(255),
      SUB_SCOPE_ID_ nvarchar(255),
      SCOPE_TYPE_ nvarchar(255),
      SCOPE_DEFINITION_ID_ nvarchar(255),
      EXCEPTION_STACK_ID_ nvarchar(64),
      EXCEPTION_MSG_ nvarchar(4000),
      DUEDATE_ datetime NULL,
      REPEAT_ nvarchar(255),
      HANDLER_TYPE_ nvarchar(255),
      HANDLER_CFG_ nvarchar(4000),
      CUSTOM_VALUES_ID_ nvarchar(64),
      CREATE_TIME_ datetime2 NULL,
      TENANT_ID_ nvarchar(255) default '',
      primary key (ID_)
  );
  
  create table ACT_RU_HISTORY_JOB (
      ID_ nvarchar(64) NOT NULL,
      REV_ int,
      LOCK_EXP_TIME_ datetime NULL,
      LOCK_OWNER_ nvarchar(255),
      RETRIES_ int,
      EXCEPTION_STACK_ID_ nvarchar(64),
      EXCEPTION_MSG_ nvarchar(4000),
      HANDLER_TYPE_ nvarchar(255),
      HANDLER_CFG_ nvarchar(4000),
      CUSTOM_VALUES_ID_ nvarchar(64),
      ADV_HANDLER_CFG_ID_ nvarchar(64),
      CREATE_TIME_ datetime2 NULL,
      SCOPE_TYPE_ nvarchar(255),
      TENANT_ID_ nvarchar(255) default '',
      primary key (ID_)
  );
  
  create index ACT_IDX_JOB_EXCEPTION_STACK_ID on ACT_RU_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_JOB_CUSTOM_VALUES_ID on ACT_RU_JOB(CUSTOM_VALUES_ID_);
  
  create index ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID on ACT_RU_TIMER_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID on ACT_RU_TIMER_JOB(CUSTOM_VALUES_ID_);
  
  create index ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID on ACT_RU_SUSPENDED_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID on ACT_RU_SUSPENDED_JOB(CUSTOM_VALUES_ID_);
  
  create index ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID on ACT_RU_DEADLETTER_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_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_VALUES
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_TIMER_JOB
      add constraint ACT_FK_TIMER_JOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_TIMER_JOB
      add constraint ACT_FK_TIMER_JOB_CUSTOM_VALUES
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_SUSPENDED_JOB
      add constraint ACT_FK_SUSPENDED_JOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_SUSPENDED_JOB
      add constraint ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_DEADLETTER_JOB
      add constraint ACT_FK_DEADLETTER_JOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_DEADLETTER_JOB
      add constraint ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES
      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.5.1.2', 1);