-- ---------------------------- -- 这里包含流程引擎自带的数据表，以及橙单工作流模块内置的zz_flow开头的数据表。 -- ---------------------------- SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for ACT_EVT_LOG -- ---------------------------- DROP TABLE IF EXISTS `ACT_EVT_LOG`; CREATE TABLE `ACT_EVT_LOG` ( `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DATA_` longblob, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `IS_PROCESSED_` tinyint(4) DEFAULT '0', PRIMARY KEY (`LOG_NR_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_GE_BYTEARRAY -- ---------------------------- DROP TABLE IF EXISTS `ACT_GE_BYTEARRAY`; CREATE TABLE `ACT_GE_BYTEARRAY` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `BYTES_` longblob, `GENERATED_` tinyint(4) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`), CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_GE_PROPERTY -- ---------------------------- DROP TABLE IF EXISTS `ACT_GE_PROPERTY`; CREATE TABLE `ACT_GE_PROPERTY` ( `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, PRIMARY KEY (`NAME_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Records of ACT_GE_PROPERTY -- ---------------------------- BEGIN; INSERT INTO `ACT_GE_PROPERTY` VALUES ('batch.schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('cfg.execution-related-entities-count', 'true', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('cfg.task-related-entities-count', 'true', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('common.schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('entitylink.schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('eventsubscription.schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('identitylink.schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('job.schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('next.dbid', '1', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.history', 'create(6.6.0.0)', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('task.schema.version', '6.6.0.0', 1); INSERT INTO `ACT_GE_PROPERTY` VALUES ('variable.schema.version', '6.6.0.0', 1); COMMIT; -- ---------------------------- -- Table structure for ACT_HI_ACTINST -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_ACTINST`; CREATE TABLE `ACT_HI_ACTINST` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `TRANSACTION_ORDER_` int(11) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`), KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`), KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`, `ACT_ID_`), KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`, `ACT_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_ATTACHMENT -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_ATTACHMENT`; CREATE TABLE `ACT_HI_ATTACHMENT` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_COMMENT -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_COMMENT`; CREATE TABLE `ACT_HI_COMMENT` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TIME_` datetime(3) NOT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `FULL_MSG_` longblob, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_DETAIL -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_DETAIL`; CREATE TABLE `ACT_HI_DETAIL` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, `TIME_` datetime(3) NOT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`), KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`), KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`), KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_ENTITYLINK -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_ENTITYLINK`; CREATE TABLE `ACT_HI_ENTITYLINK` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_ENT_LNK_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`, `LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`, `ROOT_SCOPE_TYPE_`, `LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`, `LINK_TYPE_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_IDENTITYLINK -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_IDENTITYLINK`; CREATE TABLE `ACT_HI_IDENTITYLINK` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`), KEY `ACT_IDX_HI_IDENT_LNK_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`), KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_PROCINST -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_PROCINST`; CREATE TABLE `ACT_HI_PROCINST` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`), KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_TASKINST -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_TASKINST`; CREATE TABLE `ACT_HI_TASKINST` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `CLAIM_TIME_` datetime(3) DEFAULT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `PRIORITY_` int(11) DEFAULT NULL, `DUE_DATE_` datetime(3) DEFAULT NULL, `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_TASK_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_TSK_LOG -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_TSK_LOG`; CREATE TABLE `ACT_HI_TSK_LOG` ( `ID_` bigint(20) NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DATA_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_HI_VARINST -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_VARINST`; CREATE TABLE `ACT_HI_VARINST` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`, `VAR_TYPE_`), KEY `ACT_IDX_HI_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`), KEY `ACT_IDX_HI_PROCVAR_EXE` (`EXECUTION_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_BYTEARRAY -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_BYTEARRAY`; CREATE TABLE `ACT_ID_BYTEARRAY` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTES_` longblob, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_GROUP -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_GROUP`; CREATE TABLE `ACT_ID_GROUP` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_INFO -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_INFO`; CREATE TABLE `ACT_ID_INFO` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PASSWORD_` longblob, `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_MEMBERSHIP -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_MEMBERSHIP`; CREATE TABLE `ACT_ID_MEMBERSHIP` ( `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`USER_ID_`, `GROUP_ID_`), KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`), CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`), CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_PRIV -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_PRIV`; CREATE TABLE `ACT_ID_PRIV` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_PRIV_NAME` (`NAME_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_PRIV_MAPPING -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_PRIV_MAPPING`; CREATE TABLE `ACT_ID_PRIV_MAPPING` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PRIV_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_FK_PRIV_MAPPING` (`PRIV_ID_`), KEY `ACT_IDX_PRIV_USER` (`USER_ID_`), KEY `ACT_IDX_PRIV_GROUP` (`GROUP_ID_`), CONSTRAINT `ACT_FK_PRIV_MAPPING` FOREIGN KEY (`PRIV_ID_`) REFERENCES `ACT_ID_PRIV` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_PROPERTY -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_PROPERTY`; CREATE TABLE `ACT_ID_PROPERTY` ( `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, PRIMARY KEY (`NAME_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Records of ACT_ID_PROPERTY -- ---------------------------- BEGIN; INSERT INTO `ACT_ID_PROPERTY` VALUES ('schema.version', '6.6.0.0', 1); COMMIT; -- ---------------------------- -- Table structure for ACT_ID_TOKEN -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_TOKEN`; CREATE TABLE `ACT_ID_TOKEN` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TOKEN_VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TOKEN_DATE_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), `IP_ADDRESS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_AGENT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TOKEN_DATA_` varchar(2000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_ID_USER -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_USER`; CREATE TABLE `ACT_ID_USER` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DISPLAY_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_PROCDEF_INFO -- ---------------------------- DROP TABLE IF EXISTS `ACT_PROCDEF_INFO`; CREATE TABLE `ACT_PROCDEF_INFO` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`), KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`), KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`), CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RE_DEPLOYMENT -- ---------------------------- DROP TABLE IF EXISTS `ACT_RE_DEPLOYMENT`; CREATE TABLE `ACT_RE_DEPLOYMENT` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL, `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PARENT_DEPLOYMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RE_MODEL -- ---------------------------- DROP TABLE IF EXISTS `ACT_RE_MODEL`; CREATE TABLE `ACT_RE_MODEL` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`), KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`), KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`), CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`), CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RE_PROCDEF -- ---------------------------- DROP TABLE IF EXISTS `ACT_RE_PROCDEF`; CREATE TABLE `ACT_RE_PROCDEF` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin NOT NULL, `VERSION_` int(11) NOT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL, `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_VERSION_` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`, `VERSION_`, `DERIVED_VERSION_`, `TENANT_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_ACTINST -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_ACTINST`; CREATE TABLE `ACT_RU_ACTINST` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `TRANSACTION_ORDER_` int(11) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_RU_ACTI_START` (`START_TIME_`), KEY `ACT_IDX_RU_ACTI_END` (`END_TIME_`), KEY `ACT_IDX_RU_ACTI_PROC` (`PROC_INST_ID_`), KEY `ACT_IDX_RU_ACTI_PROC_ACT` (`PROC_INST_ID_`, `ACT_ID_`), KEY `ACT_IDX_RU_ACTI_EXEC` (`EXECUTION_ID_`), KEY `ACT_IDX_RU_ACTI_EXEC_ACT` (`EXECUTION_ID_`, `ACT_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_DEADLETTER_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_DEADLETTER_JOB`; CREATE TABLE `ACT_RU_DEADLETTER_JOB` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_DEADLETTER_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_DJOB_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_DJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_DJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_ENTITYLINK -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_ENTITYLINK`; CREATE TABLE `ACT_RU_ENTITYLINK` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_ENT_LNK_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`, `LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`, `ROOT_SCOPE_TYPE_`, `LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`, `LINK_TYPE_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_EVENT_SUBSCR -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_EVENT_SUBSCR`; CREATE TABLE `ACT_RU_EVENT_SUBSCR` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`), KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`), CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_EXECUTION -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_EXECUTION`; CREATE TABLE `ACT_RU_EXECUTION` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ROOT_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `IS_ACTIVE_` tinyint(4) DEFAULT NULL, `IS_CONCURRENT_` tinyint(4) DEFAULT NULL, `IS_SCOPE_` tinyint(4) DEFAULT NULL, `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL, `IS_MI_ROOT_` tinyint(4) DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `CACHED_ENT_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) DEFAULT NULL, `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL, `EVT_SUBSCR_COUNT_` int(11) DEFAULT NULL, `TASK_COUNT_` int(11) DEFAULT NULL, `JOB_COUNT_` int(11) DEFAULT NULL, `TIMER_JOB_COUNT_` int(11) DEFAULT NULL, `SUSP_JOB_COUNT_` int(11) DEFAULT NULL, `DEADLETTER_JOB_COUNT_` int(11) DEFAULT NULL, `EXTERNAL_WORKER_JOB_COUNT_` int(11) DEFAULT NULL, `VAR_COUNT_` int(11) DEFAULT NULL, `ID_LINK_COUNT_` int(11) DEFAULT NULL, `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`), KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`), KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`), KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`), KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`), KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE, CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_EXTERNAL_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_EXTERNAL_JOB`; CREATE TABLE `ACT_RU_EXTERNAL_JOB` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_EXTERNAL_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_EXTERNAL_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_EXTERNAL_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_EJOB_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_EJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_EJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), CONSTRAINT `ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_EXTERNAL_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_HISTORY_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_HISTORY_JOB`; CREATE TABLE `ACT_RU_HISTORY_JOB` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ADV_HANDLER_CFG_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_IDENTITYLINK -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_IDENTITYLINK`; CREATE TABLE `ACT_RU_IDENTITYLINK` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`), KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`), KEY `ACT_IDX_IDENT_LNK_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`), KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`), KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`), CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_JOB`; CREATE TABLE `ACT_RU_JOB` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_JOB_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_JOB_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_JOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_SUSPENDED_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_SUSPENDED_JOB`; CREATE TABLE `ACT_RU_SUSPENDED_JOB` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_SUSPENDED_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_SJOB_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_SJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_SJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_TASK -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_TASK`; CREATE TABLE `ACT_RU_TASK` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PRIORITY_` int(11) DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `DUE_DATE_` datetime(3) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CLAIM_TIME_` datetime(3) DEFAULT NULL, `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL, `VAR_COUNT_` int(11) DEFAULT NULL, `ID_LINK_COUNT_` int(11) DEFAULT NULL, `SUB_TASK_COUNT_` int(11) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`), KEY `ACT_IDX_TASK_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`), KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`), KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`), CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_TIMER_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_TIMER_JOB`; CREATE TABLE `ACT_RU_TIMER_JOB` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_TIMER_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_TJOB_SCOPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_TJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_TJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`, `SCOPE_TYPE_`), KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for ACT_RU_VARIABLE -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_VARIABLE`; CREATE TABLE `ACT_RU_VARIABLE` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_RU_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_IDX_RU_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`, `SCOPE_TYPE_`), KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`), KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`), KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`), KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`), CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`), CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`), CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for FLW_CHANNEL_DEFINITION -- ---------------------------- DROP TABLE IF EXISTS `FLW_CHANNEL_DEFINITION`; CREATE TABLE `FLW_CHANNEL_DEFINITION` ( `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `RESOURCE_NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `DESCRIPTION_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_IDX_CHANNEL_DEF_UNIQ` (`KEY_`, `VERSION_`, `TENANT_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin; -- ---------------------------- -- Table structure for FLW_EV_DATABASECHANGELOG -- ---------------------------- DROP TABLE IF EXISTS `FLW_EV_DATABASECHANGELOG`; CREATE TABLE `FLW_EV_DATABASECHANGELOG` ( `ID` varchar(255) COLLATE utf8mb4_bin NOT NULL, `AUTHOR` varchar(255) COLLATE utf8mb4_bin NOT NULL, `FILENAME` varchar(255) COLLATE utf8mb4_bin NOT NULL, `DATEEXECUTED` datetime NOT NULL, `ORDEREXECUTED` int(11) NOT NULL, `EXECTYPE` varchar(10) COLLATE utf8mb4_bin NOT NULL, `MD5SUM` varchar(35) COLLATE utf8mb4_bin DEFAULT NULL, `DESCRIPTION` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `COMMENTS` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `TAG` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `LIQUIBASE` varchar(20) COLLATE utf8mb4_bin DEFAULT NULL, `CONTEXTS` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `LABELS` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `DEPLOYMENT_ID` varchar(10) COLLATE utf8mb4_bin DEFAULT NULL ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin; -- ---------------------------- -- Records of FLW_EV_DATABASECHANGELOG -- ---------------------------- BEGIN; INSERT INTO `FLW_EV_DATABASECHANGELOG` VALUES ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2021-08-22 15:01:56', 1, 'EXECUTED', '8:1b0c48c9cf7945be799d868a2626d687', 'createTable tableName=FLW_EVENT_DEPLOYMENT; createTable tableName=FLW_EVENT_RESOURCE; createTable tableName=FLW_EVENT_DEFINITION; createIndex indexName=ACT_IDX_EVENT_DEF_UNIQ, tableName=FLW_EVENT_DEFINITION; createTable tableName=FLW_CHANNEL_DEFIN...', '', NULL, '3.8.9', NULL, NULL, '9615716437'); COMMIT; -- ---------------------------- -- Table structure for FLW_EV_DATABASECHANGELOGLOCK -- ---------------------------- DROP TABLE IF EXISTS `FLW_EV_DATABASECHANGELOGLOCK`; CREATE TABLE `FLW_EV_DATABASECHANGELOGLOCK` ( `ID` int(11) NOT NULL, `LOCKED` bit(1) NOT NULL, `LOCKGRANTED` datetime DEFAULT NULL, `LOCKEDBY` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin; -- ---------------------------- -- Records of FLW_EV_DATABASECHANGELOGLOCK -- ---------------------------- BEGIN; INSERT INTO `FLW_EV_DATABASECHANGELOGLOCK` VALUES (1, b'0', NULL, NULL); COMMIT; -- ---------------------------- -- Table structure for FLW_EVENT_DEFINITION -- ---------------------------- DROP TABLE IF EXISTS `FLW_EVENT_DEFINITION`; CREATE TABLE `FLW_EVENT_DEFINITION` ( `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `RESOURCE_NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `DESCRIPTION_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_IDX_EVENT_DEF_UNIQ` (`KEY_`, `VERSION_`, `TENANT_ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin; -- ---------------------------- -- Table structure for FLW_EVENT_DEPLOYMENT -- ---------------------------- DROP TABLE IF EXISTS `FLW_EVENT_DEPLOYMENT`; CREATE TABLE `FLW_EVENT_DEPLOYMENT` ( `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `DEPLOY_TIME_` datetime(3) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `PARENT_DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin; -- ---------------------------- -- Table structure for FLW_EVENT_RESOURCE -- ---------------------------- DROP TABLE IF EXISTS `FLW_EVENT_RESOURCE`; CREATE TABLE `FLW_EVENT_RESOURCE` ( `ID_` varchar(255) COLLATE utf8mb4_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL, `RESOURCE_BYTES_` longblob, PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin; -- ---------------------------- -- Table structure for FLW_RU_BATCH -- ---------------------------- DROP TABLE IF EXISTS `FLW_RU_BATCH`; CREATE TABLE `FLW_RU_BATCH` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL, `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) NOT NULL, `COMPLETE_TIME_` datetime(3) DEFAULT NULL, `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BATCH_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- Table structure for FLW_RU_BATCH_PART -- ---------------------------- DROP TABLE IF EXISTS `FLW_RU_BATCH_PART`; CREATE TABLE `FLW_RU_BATCH_PART` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `BATCH_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL, `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) NOT NULL, `COMPLETE_TIME_` datetime(3) DEFAULT NULL, `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RESULT_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `FLW_IDX_BATCH_PART` (`BATCH_ID_`), CONSTRAINT `FLW_FK_BATCH_PART_PARENT` FOREIGN KEY (`BATCH_ID_`) REFERENCES `FLW_RU_BATCH` (`ID_`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8 COLLATE = utf8_bin; -- ---------------------------- -- 流程分类表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_category`; CREATE TABLE `zz_flow_category` ( `category_id` bigint(20) NOT NULL COMMENT '主键Id', `name` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '显示名称', `code` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '分类编码', `show_order` int(11) NOT NULL COMMENT '实现顺序', `update_time` datetime NOT NULL COMMENT '更新时间', `update_user_id` bigint(20) NOT NULL COMMENT '更新者Id', `create_time` datetime NOT NULL COMMENT '创建时间', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', PRIMARY KEY (`category_id`) USING BTREE, UNIQUE KEY `uk_code` (`code`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程分类表'; -- ---------------------------- -- 流程管理表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_entry`; CREATE TABLE `zz_flow_entry` ( `entry_id` bigint(20) NOT NULL COMMENT '主键', `process_definition_name` varchar(200) NOT NULL COMMENT '流程名称', `process_definition_key` varchar(150) NOT NULL COMMENT '流程标识Key', `category_id` bigint(20) NOT NULL COMMENT '流程分类', `main_entry_publish_id` bigint(20) DEFAULT NULL COMMENT '工作流部署的发布主版本Id', `latest_publish_time` datetime DEFAULT NULL COMMENT '最新发布时间', `status` int(11) NOT NULL COMMENT '流程状态', `bpmn_xml` longtext COMMENT '流程定义的xml', `bind_form_type` int(11) NOT NULL COMMENT '绑定表单类型', `page_id` bigint(20) DEFAULT NULL COMMENT '在线表单的页面Id', `default_form_id` bigint(20) DEFAULT NULL COMMENT '在线表单Id', `default_router_name` varchar(255) DEFAULT NULL COMMENT '静态表单的缺省路由名称', `encoded_rule` varchar(255) DEFAULT NULL COMMENT '工单表编码字段的编码规则', `extension_data` varchar(3000) DEFAULT NULL COMMENT '流程的自定义扩展数据', `update_time` datetime NOT NULL COMMENT '更新时间', `update_user_id` bigint(20) NOT NULL COMMENT '更新者Id', `create_time` datetime NOT NULL COMMENT '创建时间', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', PRIMARY KEY (`entry_id`) USING BTREE, UNIQUE KEY `uk_process_definition_key` (`process_definition_key`) USING BTREE, KEY `idx_category_id` (`category_id`) USING BTREE, KEY `idx_status` (`status`) USING BTREE, KEY `idx_process_definition_name` (`process_definition_name`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT ='流程管理表'; -- ---------------------------- -- 流程发布表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_entry_publish`; CREATE TABLE `zz_flow_entry_publish` ( `entry_publish_id` bigint(20) NOT NULL COMMENT '主键Id', `entry_id` bigint(20) NOT NULL COMMENT '流程Id', `process_definition_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的定义Id', `deploy_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的部署Id', `publish_version` int(11) NOT NULL COMMENT '发布版本', `active_status` bit(1) NOT NULL COMMENT '激活状态', `main_version` bit(1) NOT NULL COMMENT '是否为主版本', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', `publish_time` datetime NOT NULL COMMENT '发布时间', `init_task_info` text CHARACTER SET utf8mb4 COMMENT '第一个非开始节点任务的附加信息', PRIMARY KEY (`entry_publish_id`) USING BTREE, UNIQUE KEY `uk_process_definition_id` (`process_definition_id`) USING BTREE, KEY `idx_entry_id` (`entry_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程发布表'; -- ---------------------------- -- 流程发布变量表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_entry_publish_variable`; CREATE TABLE `zz_flow_entry_publish_variable` ( `variable_id` bigint(20) NOT NULL COMMENT '主键Id', `entry_publish_id` bigint(20) NOT NULL COMMENT '流程Id', `variable_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '变量名', `show_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '显示名', `variable_type` int(11) NOT NULL COMMENT '变量类型', `bind_datasource_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源Id', `bind_relation_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源关联Id', `bind_column_id` bigint(20) DEFAULT NULL COMMENT '绑定字段Id', `builtin` bit(1) NOT NULL COMMENT '是否内置', PRIMARY KEY (`variable_id`) USING BTREE, KEY `idx_entry_publish_id` (`entry_publish_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程发布变量表'; -- ---------------------------- -- 流程变量表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_entry_variable`; CREATE TABLE `zz_flow_entry_variable` ( `variable_id` bigint(20) NOT NULL COMMENT '主键Id', `entry_id` bigint(20) NOT NULL COMMENT '流程Id', `variable_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '变量名', `show_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '显示名', `variable_type` int(11) NOT NULL COMMENT '变量类型', `bind_datasource_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源Id', `bind_relation_id` bigint(20) DEFAULT NULL COMMENT '绑定数据源关联Id', `bind_column_id` bigint(20) DEFAULT NULL COMMENT '绑定字段Id', `builtin` bit(1) NOT NULL COMMENT '是否内置', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`variable_id`) USING BTREE, UNIQUE KEY `uk_entry_id_variable_name` (`entry_id`, `variable_name`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程变量表'; -- ---------------------------- -- 流程任务审批表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_task_comment`; CREATE TABLE `zz_flow_task_comment` ( `id` bigint(20) NOT NULL COMMENT '主键Id', `process_instance_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id', `task_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '任务Id', `task_key` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '任务标识', `task_name` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务名称', `execution_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务的执行Id', `multi_instance_exec_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '会签任务的执行Id', `approval_type` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '审批类型', `task_comment` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '批注内容', `delegate_assignee` varchar(512) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '委托指定人，比如加签、转办等', `custom_business_data` longtext COLLATE utf8mb4_bin COMMENT '自定义数据。开发者可自行扩展，推荐使用JSON格式数据', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', `create_login_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者登录名', `create_username` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者用户名', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`) USING BTREE, KEY `idx_multi_instance_exec_id` (`multi_instance_exec_id`) USING BTREE, KEY `idx_process_instance_id` (`process_instance_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程任务审批表'; -- ---------------------------- -- 流程多实例任务审批流水表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_multi_instance_trans`; CREATE TABLE `zz_flow_multi_instance_trans` ( `id` bigint NOT NULL COMMENT '主键Id', `process_instance_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id', `task_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务Id', `task_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '任务标识', `multi_instance_exec_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '会签任务的执行Id', `execution_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '任务的执行Id', `assignee_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '会签指派人列表', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', `create_login_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者登录名', `create_username` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者用户名', `create_time` datetime NOT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_execution_id` (`execution_id`) USING BTREE, KEY `idx_multi_instance_exec_id` (`multi_instance_exec_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程多实例任务审批流水表'; -- ---------------------------- -- 流程流程图任务扩展表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_task_ext`; CREATE TABLE `zz_flow_task_ext` ( `process_definition_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的定义Id', `task_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎任务Id', `operation_list_json` longtext COLLATE utf8mb4_bin COMMENT '操作列表JSON', `variable_list_json` longtext COLLATE utf8mb4_bin COMMENT '变量列表JSON', `assignee_list_json` text COLLATE utf8mb4_bin COMMENT '存储多实例的assigneeList的JSON', `group_type` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '分组类型', `dept_post_list_json` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存岗位相关的数据', `role_ids` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存角色Id数据', `dept_ids` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存部门Id数据', `candidate_usernames` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '保存候选组用户名数据', `copy_list_json` varchar(4000) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '抄送相关的数据', `extra_data_json` text COLLATE utf8mb4_bin COMMENT '用户任务的扩展属性，存储为JSON的字符串格式', PRIMARY KEY (`process_definition_id`, `task_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程流程图任务扩展表'; -- ---------------------------- -- 流程工单表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_work_order`; CREATE TABLE `zz_flow_work_order` ( `work_order_id` bigint(20) NOT NULL COMMENT '主键Id', `work_order_code` varchar(255) COLLATE utf8mb4_bin COMMENT '工单编码字段', `process_definition_key` varchar(128) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义标识', `process_definition_name` varchar(200) CHARACTER SET utf8mb4 NOT NULL COMMENT '流程名称', `process_definition_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程引擎的定义Id', `process_instance_id` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '流程实例Id', `online_table_id` bigint(20) DEFAULT NULL COMMENT '在线表单的主表Id', `table_name` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '用于静态表单的表名', `business_key` varchar(128) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '业务主键值', `task_id` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '未完成的任务Id', `task_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '未完成的任务名称', `task_definition_key` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '未完成的任务标识', `latest_approval_status` int(11) COMMENT '最近的审批状态', `flow_status` int(11) NOT NULL DEFAULT 0 COMMENT '流程状态', `submit_username` varchar(64) COLLATE utf8mb4_bin NOT NULL COMMENT '提交用户登录名称', `dept_id` bigint(20) NOT NULL COMMENT '提交用户所在部门Id', `update_time` datetime NOT NULL COMMENT '更新时间', `update_user_id` bigint(20) NOT NULL COMMENT '更新者Id', `create_time` datetime NOT NULL COMMENT '创建时间', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', `deleted_flag` int(11) NOT NULL COMMENT '删除标记(1: 正常 -1: 已删除)', PRIMARY KEY (`work_order_id`) USING BTREE, UNIQUE KEY `uk_process_instance_id` (`process_instance_id`) USING BTREE, KEY `idx_process_definition_key` (`process_definition_key`) USING BTREE, KEY `idx_create_user_id` (`create_user_id`) USING BTREE, KEY `idx_create_time` (`create_time`) USING BTREE, KEY `idx_dept_id` (`dept_id`) USING BTREE, KEY `idx_table_name` (`table_name`) USING BTREE, KEY `idx_business_key` (`business_key`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程工单表'; -- ---------------------------- -- 流程工单扩展表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_work_order_ext`; CREATE TABLE `zz_flow_work_order_ext` ( `id` bigint NOT NULL COMMENT '主键Id', `work_order_id` bigint NOT NULL COMMENT '工单Id', `draft_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '草稿数据', `business_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin COMMENT '业务数据', `update_time` datetime NOT NULL COMMENT '更新时间', `update_user_id` bigint(20) NOT NULL COMMENT '更新者Id', `create_time` datetime NOT NULL COMMENT '创建时间', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', `deleted_flag` int(11) NOT NULL COMMENT '删除标记(1: 正常 -1: 已删除)', PRIMARY KEY (`id`) USING BTREE, KEY `idx_work_order_id` (`work_order_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程工单扩展表'; -- ---------------------------- -- 流程消息通知表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_message`; CREATE TABLE `zz_flow_message` ( `message_id` bigint(20) NOT NULL COMMENT '主键Id', `message_type` tinyint(4) NOT NULL COMMENT '消息类型', `message_content` varchar(1024) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '消息内容', `remind_count` int(11) DEFAULT 0 COMMENT '催办次数', `work_order_id` bigint(20) DEFAULT NULL COMMENT '工单Id', `process_definition_id` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义Id', `process_definition_key` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义标识', `process_definition_name` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '流程定义名称', `process_instance_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程实例Id', `process_instance_initiator` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程实例发起者', `task_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程任务Id', `task_definition_key` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程任务定义标识', `task_name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '流程任务名称', `task_start_time` datetime DEFAULT NULL COMMENT '任务开始时间', `task_finished` bit(1) NOT NULL DEFAULT b'0' COMMENT '任务是否已完成', `task_assignee` varchar(64) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任务指派人登录名', `business_data_shot` longtext COLLATE utf8mb4_bin COMMENT '业务数据快照', `online_form_data` bit(1) COMMENT '是否为在线表单消息数据', `update_time` datetime NOT NULL COMMENT '更新时间', `update_user_id` bigint(20) NOT NULL COMMENT '更新者Id', `create_time` datetime NOT NULL COMMENT '创建时间', `create_user_id` bigint(20) NOT NULL COMMENT '创建者Id', `create_username` varchar(255) COLLATE utf8mb4_bin NOT NULL COMMENT '创建者显示名', PRIMARY KEY (`message_id`) USING BTREE, KEY `idx_notified_username` (`task_assignee`) USING BTREE, KEY `idx_process_instance_id` (`process_instance_id`) USING BTREE, KEY `idx_message_type` (`message_type`) USING BTREE, KEY `idx_task_id` (`task_id`) USING BTREE, KEY `idx_task_finished` (`task_finished`) USING BTREE, KEY `idx_update_time` (`update_time`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程消息通知表'; -- ---------------------------- -- 流程消息通知候选人表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_msg_candidate_identity`; CREATE TABLE `zz_flow_msg_candidate_identity` ( `id` bigint(20) NOT NULL COMMENT '主键Id', `message_id` bigint(20) NOT NULL COMMENT '流程任务Id', `candidate_type` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '候选身份类型', `candidate_id` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '候选身份Id', PRIMARY KEY (`id`), KEY `idx_candidate_id` (`candidate_id`) USING BTREE, KEY `idx_message_id` (`message_id`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程消息通知候选人表'; -- ---------------------------- -- 流程消息候选人操作表 -- ---------------------------- DROP TABLE IF EXISTS `zz_flow_msg_identity_operation`; CREATE TABLE `zz_flow_msg_identity_operation` ( `id` bigint NOT NULL COMMENT '主键Id', `message_id` bigint NOT NULL COMMENT '流程任务Id', `login_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT '用户登录名', `operation_type` int NOT NULL COMMENT '操作类型', `operation_time` datetime NOT NULL COMMENT '操作时间', PRIMARY KEY (`id`), KEY `idx_message_id` (`message_id`) USING BTREE, KEY `idx_login_name` (`login_name`) USING BTREE ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_bin COMMENT ='流程消息候选人操作表'; SET FOREIGN_KEY_CHECKS = 1;