text: create table ACT_RE_DEPLOYMENT (
      ID_ varchar(64),
      NAME_ varchar(255),
      CATEGORY_ varchar(255),
      KEY_ varchar(255),
      TENANT_ID_ varchar(255) default '',
      DEPLOY_TIME_ timestamp(3) NULL,
      DERIVED_FROM_ varchar(64),
      DERIVED_FROM_ROOT_ varchar(64),
      PARENT_DEPLOYMENT_ID_ varchar(255),
      ENGINE_VERSION_ varchar(255),
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_RE_MODEL (
      ID_ varchar(64) not null,
      REV_ integer,
      NAME_ varchar(255),
      KEY_ varchar(255),
      CATEGORY_ varchar(255),
      CREATE_TIME_ timestamp(3) null,
      LAST_UPDATE_TIME_ timestamp(3) null,
      VERSION_ integer,
      META_INFO_ varchar(4000),
      DEPLOYMENT_ID_ varchar(64),
      EDITOR_SOURCE_VALUE_ID_ varchar(64),
      EDITOR_SOURCE_EXTRA_VALUE_ID_ varchar(64),
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_RU_EXECUTION (
      ID_ varchar(64),
      REV_ integer,
      PROC_INST_ID_ varchar(64),
      BUSINESS_KEY_ varchar(255),
      PARENT_ID_ varchar(64),
      PROC_DEF_ID_ varchar(64),
      SUPER_EXEC_ varchar(64),
      ROOT_PROC_INST_ID_ varchar(64),
      ACT_ID_ varchar(255),
      IS_ACTIVE_ TINYINT,
      IS_CONCURRENT_ TINYINT,
      IS_SCOPE_ TINYINT,
      IS_EVENT_SCOPE_ TINYINT,
      IS_MI_ROOT_ TINYINT,
      SUSPENSION_STATE_ integer,
      CACHED_ENT_STATE_ integer,
      TENANT_ID_ varchar(255) default '',
      NAME_ varchar(255),
      START_ACT_ID_ varchar(255),
      START_TIME_ datetime(3),
      START_USER_ID_ varchar(255),
      LOCK_TIME_ timestamp(3) NULL,
      IS_COUNT_ENABLED_ TINYINT,
      EVT_SUBSCR_COUNT_ integer, 
      TASK_COUNT_ integer, 
      JOB_COUNT_ integer, 
      TIMER_JOB_COUNT_ integer,
      SUSP_JOB_COUNT_ integer,
      DEADLETTER_JOB_COUNT_ integer,
      VAR_COUNT_ integer, 
      ID_LINK_COUNT_ integer,
      CALLBACK_ID_ varchar(255),
      CALLBACK_TYPE_ varchar(255),
      REFERENCE_ID_ varchar(255),
      REFERENCE_TYPE_ varchar(255),
      PROPAGATED_STAGE_INST_ID_ varchar(255),
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_RE_PROCDEF (
      ID_ varchar(64) not null,
      REV_ integer,
      CATEGORY_ varchar(255),
      NAME_ varchar(255),
      KEY_ varchar(255) not null,
      VERSION_ integer not null,
      DEPLOYMENT_ID_ varchar(64),
      RESOURCE_NAME_ varchar(4000),
      DGRM_RESOURCE_NAME_ varchar(4000),
      DESCRIPTION_ varchar(4000),
      HAS_START_FORM_KEY_ TINYINT,
      HAS_GRAPHICAL_NOTATION_ TINYINT,
      SUSPENSION_STATE_ integer,
      TENANT_ID_ varchar(255) default '',
      ENGINE_VERSION_ varchar(255),
      DERIVED_FROM_ varchar(64),
      DERIVED_FROM_ROOT_ varchar(64),
      DERIVED_VERSION_ integer not null default 0,
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_EVT_LOG (
      LOG_NR_ bigint auto_increment,
      TYPE_ varchar(64),
      PROC_DEF_ID_ varchar(64),
      PROC_INST_ID_ varchar(64),
      EXECUTION_ID_ varchar(64),
      TASK_ID_ varchar(64),
      TIME_STAMP_ timestamp(3) not null,
      USER_ID_ varchar(255),
      DATA_ LONGBLOB,
      LOCK_OWNER_ varchar(255),
      LOCK_TIME_ timestamp(3) null,
      IS_PROCESSED_ tinyint default 0,
      primary key (LOG_NR_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_PROCDEF_INFO (
  	ID_ varchar(64) not null,
      PROC_DEF_ID_ varchar(64) not null,
      REV_ integer,
      INFO_JSON_ID_ varchar(64),
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_RU_ACTINST (
      ID_ varchar(64) not null,
      REV_ integer default 1,
      PROC_DEF_ID_ varchar(64) not null,
      PROC_INST_ID_ varchar(64) not null,
      EXECUTION_ID_ varchar(64) not null,
      ACT_ID_ varchar(255) not null,
      TASK_ID_ varchar(64),
      CALL_PROC_INST_ID_ varchar(64),
      ACT_NAME_ varchar(255),
      ACT_TYPE_ varchar(255) not null,
      ASSIGNEE_ varchar(255),
      START_TIME_ datetime(3) not null,
      END_TIME_ datetime(3),
      DURATION_ bigint,
      DELETE_REASON_ varchar(4000),
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create index ACT_IDX_EXEC_BUSKEY on ACT_RU_EXECUTION(BUSINESS_KEY_);
  create index ACT_IDC_EXEC_ROOT on ACT_RU_EXECUTION(ROOT_PROC_INST_ID_);
  create index ACT_IDX_VARIABLE_TASK_ID on ACT_RU_VARIABLE(TASK_ID_);
  create index ACT_IDX_ATHRZ_PROCEDEF on ACT_RU_IDENTITYLINK(PROC_DEF_ID_);
  create index ACT_IDX_INFO_PROCDEF on ACT_PROCDEF_INFO(PROC_DEF_ID_);
  
  create index ACT_IDX_RU_ACTI_START on ACT_RU_ACTINST(START_TIME_);
  create index ACT_IDX_RU_ACTI_END on ACT_RU_ACTINST(END_TIME_);
  create index ACT_IDX_RU_ACTI_PROC on ACT_RU_ACTINST(PROC_INST_ID_);
  create index ACT_IDX_RU_ACTI_PROC_ACT on ACT_RU_ACTINST(PROC_INST_ID_, ACT_ID_);
  create index ACT_IDX_RU_ACTI_EXEC on ACT_RU_ACTINST(EXECUTION_ID_);
  create index ACT_IDX_RU_ACTI_EXEC_ACT on ACT_RU_ACTINST(EXECUTION_ID_, ACT_ID_);
  
  alter table ACT_GE_BYTEARRAY
      add constraint ACT_FK_BYTEARR_DEPL 
      foreign key (DEPLOYMENT_ID_) 
      references ACT_RE_DEPLOYMENT (ID_);
  
  alter table ACT_RE_PROCDEF
      add constraint ACT_UNIQ_PROCDEF
      unique (KEY_,VERSION_, DERIVED_VERSION_, TENANT_ID_);
      
  alter table ACT_RU_EXECUTION
      add constraint ACT_FK_EXE_PROCINST 
      foreign key (PROC_INST_ID_) 
      references ACT_RU_EXECUTION (ID_) on delete cascade on update cascade;
  
  alter table ACT_RU_EXECUTION
      add constraint ACT_FK_EXE_PARENT 
      foreign key (PARENT_ID_) 
      references ACT_RU_EXECUTION (ID_) on delete cascade;
      
  alter table ACT_RU_EXECUTION
      add constraint ACT_FK_EXE_SUPER 
      foreign key (SUPER_EXEC_) 
      references ACT_RU_EXECUTION (ID_) on delete cascade;
      
  alter table ACT_RU_EXECUTION
      add constraint ACT_FK_EXE_PROCDEF 
      foreign key (PROC_DEF_ID_) 
      references ACT_RE_PROCDEF (ID_);
      
  alter table ACT_RU_IDENTITYLINK
      add constraint ACT_FK_TSKASS_TASK 
      foreign key (TASK_ID_) 
      references ACT_RU_TASK (ID_);
      
  alter table ACT_RU_IDENTITYLINK
      add constraint ACT_FK_ATHRZ_PROCEDEF 
      foreign key (PROC_DEF_ID_) 
      references ACT_RE_PROCDEF(ID_);
      
  alter table ACT_RU_IDENTITYLINK
      add constraint ACT_FK_IDL_PROCINST
      foreign key (PROC_INST_ID_) 
      references ACT_RU_EXECUTION (ID_);       
      
  alter table ACT_RU_TASK
      add constraint ACT_FK_TASK_EXE
      foreign key (EXECUTION_ID_)
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_TASK
      add constraint ACT_FK_TASK_PROCINST
      foreign key (PROC_INST_ID_)
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_TASK
    	add constraint ACT_FK_TASK_PROCDEF
    	foreign key (PROC_DEF_ID_)
    	references ACT_RE_PROCDEF (ID_);
    
  alter table ACT_RU_VARIABLE 
      add constraint ACT_FK_VAR_EXE 
      foreign key (EXECUTION_ID_) 
      references ACT_RU_EXECUTION (ID_);
  
  alter table ACT_RU_VARIABLE
      add constraint ACT_FK_VAR_PROCINST
      foreign key (PROC_INST_ID_)
      references ACT_RU_EXECUTION(ID_);
  
  alter table ACT_RU_JOB 
      add constraint ACT_FK_JOB_EXECUTION 
      foreign key (EXECUTION_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_JOB 
      add constraint ACT_FK_JOB_PROCESS_INSTANCE 
      foreign key (PROCESS_INSTANCE_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_JOB 
      add constraint ACT_FK_JOB_PROC_DEF
      foreign key (PROC_DEF_ID_) 
      references ACT_RE_PROCDEF (ID_);
  
  alter table ACT_RU_TIMER_JOB 
      add constraint ACT_FK_TIMER_JOB_EXECUTION 
      foreign key (EXECUTION_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_TIMER_JOB 
      add constraint ACT_FK_TIMER_JOB_PROCESS_INSTANCE 
      foreign key (PROCESS_INSTANCE_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_TIMER_JOB 
      add constraint ACT_FK_TIMER_JOB_PROC_DEF
      foreign key (PROC_DEF_ID_) 
      references ACT_RE_PROCDEF (ID_);
      
  alter table ACT_RU_SUSPENDED_JOB 
      add constraint ACT_FK_SUSPENDED_JOB_EXECUTION 
      foreign key (EXECUTION_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_SUSPENDED_JOB 
      add constraint ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE 
      foreign key (PROCESS_INSTANCE_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_SUSPENDED_JOB 
      add constraint ACT_FK_SUSPENDED_JOB_PROC_DEF
      foreign key (PROC_DEF_ID_) 
      references ACT_RE_PROCDEF (ID_);
      
  alter table ACT_RU_DEADLETTER_JOB 
      add constraint ACT_FK_DEADLETTER_JOB_EXECUTION 
      foreign key (EXECUTION_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_DEADLETTER_JOB 
      add constraint ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE 
      foreign key (PROCESS_INSTANCE_ID_) 
      references ACT_RU_EXECUTION (ID_);
      
  alter table ACT_RU_DEADLETTER_JOB 
      add constraint ACT_FK_DEADLETTER_JOB_PROC_DEF
      foreign key (PROC_DEF_ID_) 
      references ACT_RE_PROCDEF (ID_);
      
  alter table ACT_RU_EVENT_SUBSCR
      add constraint ACT_FK_EVENT_EXEC
      foreign key (EXECUTION_ID_)
      references ACT_RU_EXECUTION(ID_);
      
  alter table ACT_RE_MODEL 
      add constraint ACT_FK_MODEL_SOURCE 
      foreign key (EDITOR_SOURCE_VALUE_ID_) 
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_RE_MODEL 
      add constraint ACT_FK_MODEL_SOURCE_EXTRA 
      foreign key (EDITOR_SOURCE_EXTRA_VALUE_ID_) 
      references ACT_GE_BYTEARRAY (ID_);
      
  alter table ACT_RE_MODEL 
      add constraint ACT_FK_MODEL_DEPLOYMENT 
      foreign key (DEPLOYMENT_ID_) 
      references ACT_RE_DEPLOYMENT (ID_);        
  
  alter table ACT_PROCDEF_INFO 
      add constraint ACT_FK_INFO_JSON_BA 
      foreign key (INFO_JSON_ID_) 
      references ACT_GE_BYTEARRAY (ID_);
  
  alter table ACT_PROCDEF_INFO 
      add constraint ACT_FK_INFO_PROCDEF 
      foreign key (PROC_DEF_ID_) 
      references ACT_RE_PROCDEF (ID_);
      
  alter table ACT_PROCDEF_INFO
      add constraint ACT_UNIQ_INFO_PROCDEF
      unique (PROC_DEF_ID_);
  
  insert into ACT_GE_PROPERTY
  values ('schema.version', '6.5.1.0', 1);
  
  insert into ACT_GE_PROPERTY
  values ('schema.history', 'create(6.5.1.0)', 1);
  
  
  create table ACT_HI_PROCINST (
      ID_ varchar(64) not null,
      REV_ integer default 1,
      PROC_INST_ID_ varchar(64) not null,
      BUSINESS_KEY_ varchar(255),
      PROC_DEF_ID_ varchar(64) not null,
      START_TIME_ datetime(3) not null,
      END_TIME_ datetime(3),
      DURATION_ bigint,
      START_USER_ID_ varchar(255),
      START_ACT_ID_ varchar(255),
      END_ACT_ID_ varchar(255),
      SUPER_PROCESS_INSTANCE_ID_ varchar(64),
      DELETE_REASON_ varchar(4000),
      TENANT_ID_ varchar(255) default '',
      NAME_ varchar(255),
      CALLBACK_ID_ varchar(255),
      CALLBACK_TYPE_ varchar(255),
      REFERENCE_ID_ varchar(255),
      REFERENCE_TYPE_ varchar(255),
      primary key (ID_),
      unique (PROC_INST_ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_HI_ACTINST (
      ID_ varchar(64) not null,
      REV_ integer default 1,
      PROC_DEF_ID_ varchar(64) not null,
      PROC_INST_ID_ varchar(64) not null,
      EXECUTION_ID_ varchar(64) not null,
      ACT_ID_ varchar(255) not null,
      TASK_ID_ varchar(64),
      CALL_PROC_INST_ID_ varchar(64),
      ACT_NAME_ varchar(255),
      ACT_TYPE_ varchar(255) not null,
      ASSIGNEE_ varchar(255),
      START_TIME_ datetime(3) not null,
      END_TIME_ datetime(3),
      DURATION_ bigint,
      DELETE_REASON_ varchar(4000),
      TENANT_ID_ varchar(255) default '',
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_HI_DETAIL (
      ID_ varchar(64) not null,
      TYPE_ varchar(255) not null,
      PROC_INST_ID_ varchar(64),
      EXECUTION_ID_ varchar(64),
      TASK_ID_ varchar(64),
      ACT_INST_ID_ varchar(64),
      NAME_ varchar(255) not null,
      VAR_TYPE_ varchar(255),
      REV_ integer,
      TIME_ datetime(3) not null,
      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 table ACT_HI_COMMENT (
      ID_ varchar(64) not null,
      TYPE_ varchar(255),
      TIME_ datetime(3) not null,
      USER_ID_ varchar(255),
      TASK_ID_ varchar(64),
      PROC_INST_ID_ varchar(64),
      ACTION_ varchar(255),
      MESSAGE_ varchar(4000),
      FULL_MSG_ LONGBLOB,
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  create table ACT_HI_ATTACHMENT (
      ID_ varchar(64) not null,
      REV_ integer,
      USER_ID_ varchar(255),
      NAME_ varchar(255),
      DESCRIPTION_ varchar(4000),
      TYPE_ varchar(255),
      TASK_ID_ varchar(64),
      PROC_INST_ID_ varchar(64),
      URL_ varchar(4000),
      CONTENT_ID_ varchar(64),
      TIME_ datetime(3),
      primary key (ID_)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin;
  
  
  create index ACT_IDX_HI_PRO_INST_END on ACT_HI_PROCINST(END_TIME_);
  create index ACT_IDX_HI_PRO_I_BUSKEY on ACT_HI_PROCINST(BUSINESS_KEY_);
  create index ACT_IDX_HI_ACT_INST_START on ACT_HI_ACTINST(START_TIME_);
  create index ACT_IDX_HI_ACT_INST_END on ACT_HI_ACTINST(END_TIME_);
  create index ACT_IDX_HI_DETAIL_PROC_INST on ACT_HI_DETAIL(PROC_INST_ID_);
  create index ACT_IDX_HI_DETAIL_ACT_INST on ACT_HI_DETAIL(ACT_INST_ID_);
  create index ACT_IDX_HI_DETAIL_TIME on ACT_HI_DETAIL(TIME_);
  create index ACT_IDX_HI_DETAIL_NAME on ACT_HI_DETAIL(NAME_);
  create index ACT_IDX_HI_DETAIL_TASK_ID on ACT_HI_DETAIL(TASK_ID_);
  create index ACT_IDX_HI_PROCVAR_PROC_INST on ACT_HI_VARINST(PROC_INST_ID_);
  create index ACT_IDX_HI_PROCVAR_TASK_ID on ACT_HI_VARINST(TASK_ID_);
  create index ACT_IDX_HI_PROCVAR_EXE on ACT_HI_VARINST(EXECUTION_ID_);
  create index ACT_IDX_HI_ACT_INST_PROCINST on ACT_HI_ACTINST(PROC_INST_ID_, ACT_ID_);
  create index ACT_IDX_HI_ACT_INST_EXEC on ACT_HI_ACTINST(EXECUTION_ID_, ACT_ID_);
  create index ACT_IDX_HI_IDENT_LNK_TASK on ACT_HI_IDENTITYLINK(TASK_ID_);
  create index ACT_IDX_HI_IDENT_LNK_PROCINST on ACT_HI_IDENTITYLINK(PROC_INST_ID_);
  create index ACT_IDX_HI_TASK_INST_PROCINST on ACT_HI_TASKINST(PROC_INST_ID_);
  