flowable-7.0.0.M

create table ACT_GE_PROPERTY ( NAME_ varchar(64), VALUE_ varchar(300), REV_ integer, primary key (NAME_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; create table ACT_GE_BYTEARRAY ( ID_ varchar(64), REV_ integer, NAME_ varchar(255), DEPLOYMENT_ID_ varchar(64), BYTES_ LONGBLOB, GENERATED_ TINYINT, primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; insert into ACT_GE_PROPERTY values ('common.schema.version', '6.8.0.0', 1); insert into ACT_GE_PROPERTY values ('next.dbid', '1', 1); create table ACT_RU_ENTITYLINK ( ID_ varchar(64), REV_ integer, CREATE_TIME_ datetime(3), LINK_TYPE_ varchar(255), SCOPE_ID_ varchar(255), SUB_SCOPE_ID_ varchar(255), SCOPE_TYPE_ varchar(255), SCOPE_DEFINITION_ID_ varchar(255), PARENT_ELEMENT_ID_ varchar(255), REF_SCOPE_ID_ varchar(255), REF_SCOPE_TYPE_ varchar(255), REF_SCOPE_DEFINITION_ID_ varchar(255), ROOT_SCOPE_ID_ varchar(255), ROOT_SCOPE_TYPE_ varchar(255), HIERARCHY_TYPE_ varchar(255), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; create index ACT_IDX_ENT_LNK_SCOPE on ACT_RU_ENTITYLINK(SCOPE_ID_, SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_ENT_LNK_REF_SCOPE on ACT_RU_ENTITYLINK(REF_SCOPE_ID_, REF_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_ENT_LNK_ROOT_SCOPE on ACT_RU_ENTITYLINK(ROOT_SCOPE_ID_, ROOT_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_ENT_LNK_SCOPE_DEF on ACT_RU_ENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_, LINK_TYPE_); insert into ACT_GE_PROPERTY values ('entitylink.schema.version', '6.8.0.0', 1); create table ACT_HI_ENTITYLINK ( ID_ varchar(64), LINK_TYPE_ varchar(255), CREATE_TIME_ datetime(3), SCOPE_ID_ varchar(255), SUB_SCOPE_ID_ varchar(255), SCOPE_TYPE_ varchar(255), SCOPE_DEFINITION_ID_ varchar(255), PARENT_ELEMENT_ID_ varchar(255), REF_SCOPE_ID_ varchar(255), REF_SCOPE_TYPE_ varchar(255), REF_SCOPE_DEFINITION_ID_ varchar(255), ROOT_SCOPE_ID_ varchar(255), ROOT_SCOPE_TYPE_ varchar(255), HIERARCHY_TYPE_ varchar(255), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; create index ACT_IDX_HI_ENT_LNK_SCOPE on ACT_HI_ENTITYLINK(SCOPE_ID_, SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_HI_ENT_LNK_REF_SCOPE on ACT_HI_ENTITYLINK(REF_SCOPE_ID_, REF_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_HI_ENT_LNK_ROOT_SCOPE on ACT_HI_ENTITYLINK(ROOT_SCOPE_ID_, ROOT_SCOPE_TYPE_, LINK_TYPE_); create index ACT_IDX_HI_ENT_LNK_SCOPE_DEF on ACT_HI_ENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_, LINK_TYPE_); create table ACT_RU_IDENTITYLINK ( ID_ varchar(64), REV_ integer, GROUP_ID_ varchar(255), TYPE_ varchar(255), USER_ID_ varchar(255), TASK_ID_ varchar(64), PROC_INST_ID_ varchar(64), PROC_DEF_ID_ varchar(64), SCOPE_ID_ varchar(255), SUB_SCOPE_ID_ varchar(255), SCOPE_TYPE_ varchar(255), SCOPE_DEFINITION_ID_ varchar(255), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; create index ACT_IDX_IDENT_LNK_USER on ACT_RU_IDENTITYLINK(USER_ID_); create index ACT_IDX_IDENT_LNK_GROUP on ACT_RU_IDENTITYLINK(GROUP_ID_); create index ACT_IDX_IDENT_LNK_SCOPE on ACT_RU_IDENTITYLINK(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_IDENT_LNK_SUB_SCOPE on ACT_RU_IDENTITYLINK(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_IDENT_LNK_SCOPE_DEF on ACT_RU_IDENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); insert into ACT_GE_PROPERTY values ('identitylink.schema.version', '6.8.0.0', 1); create table ACT_HI_IDENTITYLINK ( ID_ varchar(64), GROUP_ID_ varchar(255), TYPE_ varchar(255), USER_ID_ varchar(255), TASK_ID_ varchar(64), CREATE_TIME_ datetime(3), PROC_INST_ID_ varchar(64), SCOPE_ID_ varchar(255), SUB_SCOPE_ID_ varchar(255), SCOPE_TYPE_ varchar(255), SCOPE_DEFINITION_ID_ varchar(255), primary key (ID_) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_bin; create index ACT_IDX_HI_IDENT_LNK_USER on ACT_HI_IDENTITYLINK(USER_ID_); create index ACT_IDX_HI_IDENT_LNK_SCOPE on ACT_HI_IDENTITYLINK(SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_HI_IDENT_LNK_SUB_SCOPE on ACT_HI_IDENTITYLINK(SUB_SCOPE_ID_, SCOPE_TYPE_); create index ACT_IDX_HI_IDENT_LNK_SCOPE_DEF on ACT_HI_IDENTITYLINK(SCOPE_DEFINITION_ID_, SCOPE_TYPE_); create table ACT_RU_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), CORRELATION_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 table ACT_RU_TIMER_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), CORRELATION_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 table ACT_RU_SUSPENDED_JOB ( ID_ varchar(64) NOT NULL, REV_ integer, CATEGORY_ varchar(255), TYPE_ varchar(255) NOT NULL, 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), CORRELATION_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 table ACT_RU_DEADLETTER_JOB ( ID_ varchar(64) NOT NULL, REV_ integer, CATEGORY_ varchar(255), TYPE_ varchar(255) NOT NULL, 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), CORRELATION_ID_ varchar(255), 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 '', pr