text: create table ACT_RU_VARIABLE (
      ID_ varchar(64) not null,
      REV_ integer,
      TYPE_ varchar(255) not null,
      NAME_ varchar(255) not null,
      EXECUTION_ID_ varchar(64),
      PROC_INST_ID_ varchar(64),
      TASK_ID_ varchar(64),
      SCOPE_ID_ varchar(255),
      SUB_SCOPE_ID_ varchar(255),
      SCOPE_TYPE_ varchar(255),
      BYTEARRAY_ID_ varchar(64),
      DOUBLE_ double,
      LONG_ bigint,
      TEXT_ varchar(4000),
      TEXT2_ varchar(4000),
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create index ACT_IDX_RU_VAR_SCOPE_ID_TYPE on ACT_RU_VARIABLE(SCOPE_ID_, SCOPE_TYPE_);
  create index ACT_IDX_RU_VAR_SUB_ID_TYPE on ACT_RU_VARIABLE(SUB_SCOPE_ID_, SCOPE_TYPE_);
  
  alter table ACT_RU_VARIABLE 
      add constraint ACT_FK_VAR_BYTEARRAY 
      foreign key (BYTEARRAY_ID_) 
      references ACT_GE_BYTEARRAY (ID_);
  
  insert into ACT_GE_PROPERTY values ('variable.schema.version', '6.3.0.0', 1);