/*
|
Navicat Premium Data Transfer
|
|
Source Server : localhost
|
Source Server Type : MySQL
|
Source Server Version : 50724
|
Source Host : localhost:3306
|
Source Schema : guns
|
|
Target Server Type : MySQL
|
Target Server Version : 50724
|
File Encoding : 65001
|
|
Date: 30/08/2019 18:43:02
|
*/
|
|
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;
|
|
-- ----------------------------
|
-- Records of act_evt_log
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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_ge_bytearray_ibfk_1` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ge_bytearray
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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
|
-- ----------------------------
|
INSERT INTO `act_ge_property` VALUES ('cfg.execution-related-entities-count', 'false', '1');
|
INSERT INTO `act_ge_property` VALUES ('next.dbid', '322501', '130');
|
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(6.0.0.4)', '1');
|
INSERT INTO `act_ge_property` VALUES ('schema.version', '6.0.0.4', '1');
|
|
-- ----------------------------
|
-- 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,
|
`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,
|
`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;
|
|
-- ----------------------------
|
-- Records of act_hi_actinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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;
|
|
-- ----------------------------
|
-- Records of act_hi_attachment
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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;
|
|
-- ----------------------------
|
-- Records of act_hi_comment
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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;
|
|
-- ----------------------------
|
-- Records of act_hi_detail
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`),
|
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;
|
|
-- ----------------------------
|
-- Records of act_hi_identitylink
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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,
|
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;
|
|
-- ----------------------------
|
-- Records of act_hi_procinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`PROC_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,
|
`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 '',
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_taskinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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,
|
`REV_` int(11) 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_PROC_INST` (`PROC_INST_ID_`),
|
KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`),
|
KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_hi_varinst
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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;
|
|
-- ----------------------------
|
-- Records of act_id_group
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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;
|
|
-- ----------------------------
|
-- Records of act_id_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
|
PRIMARY KEY (`USER_ID_`,`GROUP_ID_`),
|
KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`),
|
CONSTRAINT `act_id_membership_ibfk_1` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`),
|
CONSTRAINT `act_id_membership_ibfk_2` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_id_membership
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`REV_` int(11) DEFAULT NULL,
|
`FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`LAST_` 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,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_id_user
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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_procdef_info_ibfk_1` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `act_procdef_info_ibfk_2` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_procdef_info
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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,
|
`ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
PRIMARY KEY (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_deployment
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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_re_model_ibfk_1` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`),
|
CONSTRAINT `act_re_model_ibfk_2` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `act_re_model_ibfk_3` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_model
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
PRIMARY KEY (`ID_`),
|
UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`TENANT_ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_re_procdef
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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,
|
`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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
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_`),
|
KEY `ACT_FK_DEADLETTER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
|
CONSTRAINT `act_ru_deadletter_job_ibfk_1` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `act_ru_deadletter_job_ibfk_2` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_deadletter_job_ibfk_3` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_deadletter_job_ibfk_4` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_deadletter_job
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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_ru_event_subscr_ibfk_1` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_event_subscr
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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_TIME_` datetime(3) DEFAULT NULL,
|
`START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
|
`LOCK_TIME_` timestamp(3) NULL 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,
|
`VAR_COUNT_` int(11) DEFAULT NULL,
|
`ID_LINK_COUNT_` int(11) 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_ru_execution_ibfk_1` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE,
|
CONSTRAINT `act_ru_execution_ibfk_2` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
CONSTRAINT `act_ru_execution_ibfk_3` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE,
|
CONSTRAINT `act_ru_execution_ibfk_4` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_execution
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`),
|
KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`),
|
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_ru_identitylink_ibfk_1` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
CONSTRAINT `act_ru_identitylink_ibfk_2` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_identitylink_ibfk_3` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_identitylink
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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,
|
`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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
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_`),
|
KEY `ACT_FK_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
|
CONSTRAINT `act_ru_job_ibfk_1` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `act_ru_job_ibfk_2` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_job_ibfk_3` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_job_ibfk_4` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_job
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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,
|
`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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
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_`),
|
KEY `ACT_FK_SUSPENDED_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
|
CONSTRAINT `act_ru_suspended_job_ibfk_1` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `act_ru_suspended_job_ibfk_2` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_suspended_job_ibfk_3` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_suspended_job_ibfk_4` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_suspended_job
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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 DEFAULT '',
|
`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,
|
`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,
|
PRIMARY KEY (`ID_`),
|
KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`),
|
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_ru_task_ibfk_1` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_task_ibfk_2` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`),
|
CONSTRAINT `act_ru_task_ibfk_3` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_task
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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,
|
`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,
|
`TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '',
|
PRIMARY KEY (`ID_`),
|
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_`),
|
KEY `ACT_FK_TIMER_JOB_EXCEPTION` (`EXCEPTION_STACK_ID_`),
|
CONSTRAINT `act_ru_timer_job_ibfk_1` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `act_ru_timer_job_ibfk_2` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_timer_job_ibfk_3` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_timer_job_ibfk_4` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_timer_job
|
-- ----------------------------
|
|
-- ----------------------------
|
-- 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,
|
`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_VARIABLE_TASK_ID` (`TASK_ID_`),
|
KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`),
|
KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`),
|
KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`),
|
CONSTRAINT `act_ru_variable_ibfk_1` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`),
|
CONSTRAINT `act_ru_variable_ibfk_2` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`),
|
CONSTRAINT `act_ru_variable_ibfk_3` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
|
|
-- ----------------------------
|
-- Records of act_ru_variable
|
-- ----------------------------
|
