text: create table ACT_RU_EXTERNAL_JOB (
      ID_ varchar(64) NOT NULL,
      REV_ integer,
      CATEGORY_ varchar(255),
      TYPE_ varchar(255) NOT NULL,
      LOCK_EXP_TIME_ timestamp(3) NULL,
      LOCK_OWNER_ varchar(255),
      EXCLUSIVE_ boolean,
      EXECUTION_ID_ varchar(64),
      PROCESS_INSTANCE_ID_ varchar(64),
      PROC_DEF_ID_ varchar(64),
      ELEMENT_ID_ varchar(255),
      ELEMENT_NAME_ varchar(255),
      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(3) NULL,
      REPEAT_ varchar(255),
      HANDLER_TYPE_ varchar(255),
      HANDLER_CFG_ varchar(4000),
      CUSTOM_VALUES_ID_ varchar(64),
      CREATE_TIME_ timestamp(3) NULL,
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create index ACT_IDX_EXTERNAL_JOB_EXCEPTION_STACK_ID on ACT_RU_EXTERNAL_JOB(EXCEPTION_STACK_ID_);
  create index ACT_IDX_EXTERNAL_JOB_CUSTOM_VALUES_ID on ACT_RU_EXTERNAL_JOB(CUSTOM_VALUES_ID_);
  
  alter table ACT_RU_EXTERNAL_JOB
      add constraint ACT_FK_EXTERNAL_JOB_EXCEPTION
      foreign key (EXCEPTION_STACK_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RU_EXTERNAL_JOB
      add constraint ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES
      foreign key (CUSTOM_VALUES_ID_)
      references ACT_GE_BYTEARRAY (ID_);
  
  create index ACT_IDX_EJOB_SCOPE on ACT_RU_EXTERNAL_JOB(SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_EJOB_SUB_SCOPE on ACT_RU_EXTERNAL_JOB(SUB_SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_EJOB_SCOPE_DEF on ACT_RU_EXTERNAL_JOB(SCOPE_DEFINITION_ID_, SCOPE_TYPE_);
  
  update ACT_GE_PROPERTY set VALUE_ = '6.5.1.3' where NAME_ = 'job.schema.version';
  