text: -- add JOBDEF table --
  
  create table ACT_RU_JOBDEF (
      ID_ varchar(64) not null,
      REV_ integer,
      PROC_DEF_ID_ varchar(64) not null,
      PROC_DEF_KEY_ varchar(255) not null,
      ACT_ID_ varchar(255) not null,
      JOB_TYPE_ varchar(255) not null,
      JOB_CONFIGURATION_ varchar(255),
      SUSPENSION_STATE_ integer,
      primary key (ID_)
  );
  
  -- add new columns to job table -- 
  alter table ACT_RU_JOB
      add PROCESS_DEF_ID_ varchar(64);
  
  alter table ACT_RU_JOB
      add PROCESS_DEF_KEY_ varchar(64);
  
  alter table ACT_RU_JOB
      add SUSPENSION_STATE_ integer;
  
  alter table ACT_RU_JOB
      add JOB_DEF_ID_ varchar(64);
  
  -- update job table with values from execution table --
  
  UPDATE
      ACT_RU_JOB J
  SET
      PROCESS_DEF_ID_  = (
          SELECT
              PI.PROC_DEF_ID_
          FROM
              ACT_RU_EXECUTION PI
          WHERE
              PI.ID_ = J.PROCESS_INSTANCE_ID_
      ),
      SUSPENSION_STATE_  = (
          SELECT
              PI.SUSPENSION_STATE_
          FROM
              ACT_RU_EXECUTION PI
          WHERE
              PI.ID_ = J.PROCESS_INSTANCE_ID_
      );
  
  UPDATE
      ACT_RU_JOB J
  SET
      PROCESS_DEF_KEY_  = (
          SELECT
              PD.KEY_
          FROM
              ACT_RE_PROCDEF PD
          WHERE
              PD.ID_ = J.PROCESS_DEF_ID_
      );