/*
Navicat MySQL Data Transfer

Source Server         : test_hc_community
Source Server Version : 50623
Source Host           : dev.db.java110.com:3306
Source Database       : hc_community

Target Server Type    : MYSQL
Target Server Version : 50623
File Encoding         : 65001

Date: 2021-06-11 10:26:13
*/


-- ----------------------------
-- Table structure for 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
-- ----------------------------
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_`) USING BTREE,
  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
-- ----------------------------
INSERT INTO `act_ge_bytearray` VALUES ('10002', '1', 'resourceEnter.bpmn', '10001', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('10003', '1', 'resourceEnter.resourceEntry.png', '10001', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('12502', '1', 'resourceEnter.bpmn', '12501', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('12503', '1', 'resourceEnter.resourceEntry.png', '12501', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('15002', '1', 'complaint.bpmn', '15001', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('15003', '1', 'resourceEnter.bpmn', '15001', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('15004', '1', 'complaint.complaint.png', '15001', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('15005', '1', 'resourceEnter.resourceEntry.png', '15001', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('17502', '1', 'complaint.bpmn', '17501', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('17503', '1', 'resourceEnter.bpmn', '17501', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('17504', '1', 'complaint.complaint.png', '17501', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('17505', '1', 'resourceEnter.resourceEntry.png', '17501', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('17509', '1', 'var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17511', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17517', '1', 'var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17519', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17524', '1', 'var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17526', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17528', '1', 'var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17530', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17535', '1', 'var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('17537', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('20002', '1', 'var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('20004', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('20009', '1', 'var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('20011', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('22502', '1', 'var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('22504', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('22509', '1', 'var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('22511', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('25002', '1', 'complaint.bpmn', '25001', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('25003', '1', 'resourceEnter.bpmn', '25001', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('25004', '1', 'complaint.complaint.png', '25001', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('25005', '1', 'resourceEnter.resourceEntry.png', '25001', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('25011', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('25024', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('25028', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('25041', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('27507', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('27520', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('30004', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('30017', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('30024', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('30037', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('32504', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('32517', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('32524', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('32537', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('32544', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('32557', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('35007', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('35020', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('37504', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('37517', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('40004', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('40017', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('40024', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('40037', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('40042', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('40055', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('42502', '1', 'complaint.bpmn', '42501', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('42503', '1', 'resourceEnter.bpmn', '42501', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('42504', '1', 'complaint.complaint.png', '42501', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('42505', '1', 'resourceEnter.resourceEntry.png', '42501', 0x[BLOB], '1');
INSERT INTO `act_ge_bytearray` VALUES ('42511', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('42524', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('42531', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('42544', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('42552', '1', 'hist.var-complaintDto', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('42565', '1', 'hist.var-302019110143040008', null, 0x[BLOB], null);
INSERT INTO `act_ge_bytearray` VALUES ('45002', '1', 'complaint.bpmn', '45001', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('45003', '1', 'resourceEnter.bpmn', '45001', 0x[BLOB], '0');
INSERT INTO `act_ge_bytearray` VALUES ('45004', '1', 'complaint.complaint.png', '45001', 0x[BLOB], '1');
