wjp-project/wjp-admin/db/wjp_project40.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50732
Source Host           : localhost:3306
Source Database       : wjp_project40

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

Date: 2023-08-09 17:32:16
*/

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),
  `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,
  `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;

-- ----------------------------
-- 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,
  `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 ('batch.schema.version', '6.8.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.8.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('entitylink.schema.version', '6.8.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('eventsubscription.schema.version', '6.8.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('identitylink.schema.version', '6.8.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('job.schema.version', '6.8.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', '1');
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(6.8.0.0)', '1');
INSERT INTO `act_ge_property` VALUES ('schema.version', '6.8.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('task.schema.version', '6.8.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('variable.schema.version', '6.8.0.0', '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,
  `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;

-- ----------------------------
-- 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_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_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_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;

-- ----------------------------
-- Records of act_hi_entitylink
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- 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,
  `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,
  `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `BUSINESS_STATUS_` 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_`),
  KEY `ACT_IDX_HI_PRO_SUPER_PROCINST` (`SUPER_PROCESS_INSTANCE_ID_`)
) 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,
  `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;

-- ----------------------------
-- Records of act_hi_taskinst
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_hi_tsk_log
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_hi_varinst
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_id_bytearray
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- 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,
  `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,
  `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;

-- ----------------------------
-- Records of act_id_membership
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_id_priv
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_id_priv_mapping
-- ----------------------------

-- ----------------------------
-- 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
-- ----------------------------
INSERT INTO `act_id_property` VALUES ('schema.version', '6.8.0.0', '1');

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_id_token
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- 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_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;

-- ----------------------------
-- 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,
  `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;

-- ----------------------------
-- 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_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;

-- ----------------------------
-- 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,
  `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;

-- ----------------------------
-- Records of act_re_procdef
-- ----------------------------

-- ----------------------------
-- 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_`),
  KEY `ACT_IDX_RU_ACTI_TASK` (`TASK_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- ----------------------------
-- Records of act_ru_actinst
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_ru_deadletter_job
-- ----------------------------

-- ----------------------------
-- 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_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_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;

-- ----------------------------
-- Records of act_ru_entitylink
-- ----------------------------

-- ----------------------------
-- 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,
  `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL,
  `LOCK_OWNER_` varchar(255) 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_IDX_EVENT_SUBSCR_SCOPEREF_` (`SCOPE_ID_`,`SCOPE_TYPE_`),
  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;

-- ----------------------------
-- 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,
  `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,
  `BUSINESS_STATUS_` 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_IDX_EXEC_REF_ID_` (`REFERENCE_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;

-- ----------------------------
-- Records of act_ru_execution
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_ru_external_job
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of act_ru_history_job
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- 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,
  `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;

-- ----------------------------
-- 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,
  `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;

-- ----------------------------
-- 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,
  `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;

-- ----------------------------
-- 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,
  `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_TIMER_JOB_DUEDATE` (`DUEDATE_`),
  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;

-- ----------------------------
-- 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,
  `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;

-- ----------------------------
-- Records of act_ru_variable
-- ----------------------------

-- ----------------------------
-- Table structure for `bpm_definition_ext`
-- ----------------------------
DROP TABLE IF EXISTS `bpm_definition_ext`;
CREATE TABLE `bpm_definition_ext` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `model_id` varchar(64) DEFAULT NULL COMMENT '模型ID',
  `process_definition_id` varchar(64) DEFAULT NULL COMMENT '流程定义ID',
  `form_id` bigint(20) DEFAULT NULL COMMENT '表单ID',
  `form_content` text COMMENT '表单内容',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程定义扩展';

-- ----------------------------
-- Records of bpm_definition_ext
-- ----------------------------
INSERT INTO `bpm_definition_ext` VALUES ('1689184233819238401', '690b77f5-368a-11ee-975a-9829a668307d', 'process_1691567671516:1:7537774a-368a-11ee-975a-9829a668307d', '1689183281775144962', '{\"widgetList\":[{\"type\":\"static-text\",\"icon\":\"static-text\",\"formItemFlag\":false,\"options\":{\"name\":\"statictext111193\",\"columnWidth\":\"200px\",\"hidden\":false,\"textContent\":\"分组表单\",\"customClass\":[],\"onCreated\":\"\",\"onMounted\":\"\",\"label\":\"static-text\"},\"id\":\"statictext111193\"},{\"type\":\"divider\",\"icon\":\"divider\",\"formItemFlag\":false,\"options\":{\"name\":\"divider102346\",\"label\":\"\",\"columnWidth\":\"200px\",\"direction\":\"horizontal\",\"contentPosition\":\"center\",\"hidden\":true,\"customClass\":[],\"onCreated\":\"\",\"onMounted\":\"\"},\"id\":\"divider102346\"},{\"type\":\"card\",\"category\":\"container\",\"icon\":\"card\",\"widgetList\":[{\"type\":\"grid\",\"category\":\"container\",\"icon\":\"grid\",\"cols\":[{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input12931\",\"label\":\"发件人姓名\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":[],\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input12931\"}],\"options\":{\"name\":\"gridCol25469\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-25469\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input23031\",\"label\":\"发件人号码\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input23031\"}],\"options\":{\"name\":\"gridCol25125\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-25125\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"switch\",\"icon\":\"switch-field\",\"formItemFlag\":true,\"options\":{\"name\":\"switch96070\",\"label\":\"是否保密\",\"labelAlign\":\"\",\"defaultValue\":true,\"columnWidth\":\"200px\",\"labelWidth\":null,\"labelHidden\":false,\"disabled\":false,\"hidden\":false,\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"switchWidth\":40,\"activeText\":\"\",\"inactiveText\":\"\",\"activeColor\":null,\"inactiveColor\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onValidate\":\"\"},\"id\":\"switch96070\"}],\"options\":{\"name\":\"gridCol38707\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-38707\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"textarea\",\"icon\":\"textarea-field\",\"formItemFlag\":true,\"options\":{\"name\":\"textarea21654\",\"label\":\"发件人地址\",\"labelAlign\":\"\",\"rows\":3,\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"textarea21654\"}],\"options\":{\"name\":\"gridCol36174\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-36174\"}],\"options\":{\"name\":\"grid35834\",\"hidden\":false,\"gutter\":12,\"customClass\":\"\"},\"id\":\"grid35834\"}],\"options\":{\"name\":\"card27350\",\"label\":\"发件信息\",\"hidden\":false,\"folded\":false,\"showFold\":true,\"cardWidth\":\"100%\",\"shadow\":\"never\",\"customClass\":\"\"},\"id\":\"card27350\"},{\"type\":\"divider\",\"icon\":\"divider\",\"formItemFlag\":false,\"options\":{\"name\":\"divider69240\",\"label\":\"\",\"columnWidth\":\"200px\",\"direction\":\"horizontal\",\"contentPosition\":\"center\",\"hidden\":true,\"customClass\":\"\",\"onCreated\":\"\",\"onMounted\":\"\"},\"id\":\"divider69240\"},{\"type\":\"card\",\"category\":\"container\",\"icon\":\"card\",\"widgetList\":[{\"type\":\"grid\",\"category\":\"container\",\"icon\":\"grid\",\"cols\":[{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input113152\",\"label\":\"收件人姓名\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":[],\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input113152\"}],\"options\":{\"name\":\"gridCol47242\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-47242\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input40240\",\"label\":\"收件人号码\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input40240\"}],\"options\":{\"name\":\"gridCol27970\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-27970\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"checkbox\",\"icon\":\"checkbox-field\",\"formItemFlag\":true,\"options\":{\"name\":\"checkbox63174\",\"label\":\"接收时间段\",\"labelAlign\":\"\",\"defaultValue\":[],\"columnWidth\":\"200px\",\"size\":\"\",\"displayStyle\":\"inline\",\"buttonStyle\":false,\"border\":false,\"labelWidth\":null,\"labelHidden\":false,\"disabled\":false,\"hidden\":false,\"optionItems\":[{\"label\":\"上午9:00 - 11:30\",\"value\":1},{\"label\":\"下午12:30 - 18:00\",\"value\":2},{\"label\":\"晚上18:00 - 21:00\",\"value\":3}],\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onValidate\":\"\"},\"id\":\"checkbox63174\"}],\"options\":{\"name\":\"gridCol93630\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-93630\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input78584\",\"label\":\"收件人地址\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input78584\"}],\"options\":{\"name\":\"gridCol65188\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-65188\"}],\"options\":{\"name\":\"grid114672\",\"hidden\":false,\"gutter\":12,\"customClass\":\"\"},\"id\":\"grid114672\"}],\"options\":{\"name\":\"card111229\",\"label\":\"收件信息\",\"hidden\":false,\"folded\":false,\"showFold\":true,\"cardWidth\":\"100%\",\"shadow\":\"never\",\"customClass\":\"\"},\"id\":\"card111229\"},{\"type\":\"divider\",\"icon\":\"divider\",\"formItemFlag\":false,\"options\":{\"name\":\"divider75887\",\"label\":\"\",\"columnWidth\":\"200px\",\"direction\":\"horizontal\",\"contentPosition\":\"center\",\"hidden\":true,\"customClass\":[],\"onCreated\":\"\",\"onMounted\":\"\"},\"id\":\"divider75887\"},{\"type\":\"card\",\"category\":\"container\",\"icon\":\"card\",\"widgetList\":[{\"type\":\"grid\",\"category\":\"container\",\"icon\":\"grid\",\"cols\":[{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"time-range\",\"icon\":\"time-range-field\",\"formItemFlag\":true,\"options\":{\"name\":\"timerange47503\",\"label\":\"送货时间\",\"labelAlign\":\"\",\"defaultValue\":null,\"startPlaceholder\":\"\",\"endPlaceholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"editable\":false,\"format\":\"HH:mm:ss\",\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"timerange47503\"}],\"options\":{\"name\":\"gridCol109912\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-109912\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"slider\",\"icon\":\"slider-field\",\"formItemFlag\":true,\"options\":{\"name\":\"slider54714\",\"label\":\"价格保护\",\"labelAlign\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"disabled\":false,\"hidden\":false,\"required\":false,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":[],\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"min\":0,\"max\":100,\"step\":10,\"range\":false,\"height\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onValidate\":\"\",\"showStops\":true},\"id\":\"slider54714\"}],\"options\":{\"name\":\"gridCol114653\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-114653\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"textarea\",\"icon\":\"textarea-field\",\"formItemFlag\":true,\"options\":{\"name\":\"textarea64794\",\"label\":\"其他信息\",\"labelAlign\":\"\",\"rows\":3,\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"required\":false,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"textarea64794\"}],\"options\":{\"name\":\"gridCol80867\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-80867\"}],\"options\":{\"name\":\"grid28709\",\"hidden\":false,\"gutter\":12,\"customClass\":\"\"},\"id\":\"grid28709\"}],\"options\":{\"name\":\"card106066\",\"label\":\"补充信息\",\"hidden\":false,\"folded\":false,\"showFold\":true,\"cardWidth\":\"100%\",\"shadow\":\"never\",\"customClass\":\"\"},\"id\":\"card106066\"}],\"formConfig\":{\"modelName\":\"formData\",\"refName\":\"vForm\",\"rulesName\":\"rules\",\"labelWidth\":150,\"labelPosition\":\"left\",\"size\":\"\",\"labelAlign\":\"label-right-align\",\"cssCode\":\"\",\"customClass\":[],\"functions\":\"\",\"layoutType\":\"PC\",\"jsonVersion\":3,\"onFormCreated\":\"\",\"onFormMounted\":\"\",\"onFormDataChange\":\"\",\"onFormValidate\":\"\"}}', '1067246875800000001', '2023-08-09 15:58:00', '1067246875800000001', '2023-08-09 15:58:00');

-- ----------------------------
-- Table structure for `bpm_form`
-- ----------------------------
DROP TABLE IF EXISTS `bpm_form`;
CREATE TABLE `bpm_form` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `content` text COMMENT '表单内容',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程表单';

-- ----------------------------
-- Records of bpm_form
-- ----------------------------

-- ----------------------------
-- Table structure for `bpm_instance_ext`
-- ----------------------------
DROP TABLE IF EXISTS `bpm_instance_ext`;
CREATE TABLE `bpm_instance_ext` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `process_instance_id` varchar(64) DEFAULT NULL COMMENT '流程实例ID',
  `process_definition_id` varchar(64) DEFAULT NULL COMMENT '流程定义ID',
  `form_variables` varchar(4000) DEFAULT NULL COMMENT '表单值',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程实例扩展';

-- ----------------------------
-- Records of bpm_instance_ext
-- ----------------------------

-- ----------------------------
-- Table structure for `flw_channel_definition`
-- ----------------------------
DROP TABLE IF EXISTS `flw_channel_definition`;
CREATE TABLE `flw_channel_definition` (
  `ID_` varchar(255) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `VERSION_` int(11) DEFAULT NULL,
  `KEY_` varchar(255) DEFAULT NULL,
  `CATEGORY_` varchar(255) DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
  `CREATE_TIME_` datetime(3) DEFAULT NULL,
  `TENANT_ID_` varchar(255) DEFAULT NULL,
  `RESOURCE_NAME_` varchar(255) DEFAULT NULL,
  `DESCRIPTION_` varchar(255) DEFAULT NULL,
  `TYPE_` varchar(255) DEFAULT NULL,
  `IMPLEMENTATION_` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_IDX_CHANNEL_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of flw_channel_definition
-- ----------------------------

-- ----------------------------
-- Table structure for `flw_event_definition`
-- ----------------------------
DROP TABLE IF EXISTS `flw_event_definition`;
CREATE TABLE `flw_event_definition` (
  `ID_` varchar(255) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `VERSION_` int(11) DEFAULT NULL,
  `KEY_` varchar(255) DEFAULT NULL,
  `CATEGORY_` varchar(255) DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
  `TENANT_ID_` varchar(255) DEFAULT NULL,
  `RESOURCE_NAME_` varchar(255) DEFAULT NULL,
  `DESCRIPTION_` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID_`),
  UNIQUE KEY `ACT_IDX_EVENT_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of flw_event_definition
-- ----------------------------

-- ----------------------------
-- Table structure for `flw_event_deployment`
-- ----------------------------
DROP TABLE IF EXISTS `flw_event_deployment`;
CREATE TABLE `flw_event_deployment` (
  `ID_` varchar(255) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `CATEGORY_` varchar(255) DEFAULT NULL,
  `DEPLOY_TIME_` datetime(3) DEFAULT NULL,
  `TENANT_ID_` varchar(255) DEFAULT NULL,
  `PARENT_DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of flw_event_deployment
-- ----------------------------

-- ----------------------------
-- Table structure for `flw_event_resource`
-- ----------------------------
DROP TABLE IF EXISTS `flw_event_resource`;
CREATE TABLE `flw_event_resource` (
  `ID_` varchar(255) NOT NULL,
  `NAME_` varchar(255) DEFAULT NULL,
  `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL,
  `RESOURCE_BYTES_` longblob,
  PRIMARY KEY (`ID_`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of flw_event_resource
-- ----------------------------

-- ----------------------------
-- Table structure for `flw_ev_databasechangelog`
-- ----------------------------
DROP TABLE IF EXISTS `flw_ev_databasechangelog`;
CREATE TABLE `flw_ev_databasechangelog` (
  `ID` varchar(255) NOT NULL,
  `AUTHOR` varchar(255) NOT NULL,
  `FILENAME` varchar(255) NOT NULL,
  `DATEEXECUTED` datetime NOT NULL,
  `ORDEREXECUTED` int(11) NOT NULL,
  `EXECTYPE` varchar(10) NOT NULL,
  `MD5SUM` varchar(35) DEFAULT NULL,
  `DESCRIPTION` varchar(255) DEFAULT NULL,
  `COMMENTS` varchar(255) DEFAULT NULL,
  `TAG` varchar(255) DEFAULT NULL,
  `LIQUIBASE` varchar(20) DEFAULT NULL,
  `CONTEXTS` varchar(255) DEFAULT NULL,
  `LABELS` varchar(255) DEFAULT NULL,
  `DEPLOYMENT_ID` varchar(10) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of flw_ev_databasechangelog
-- ----------------------------
INSERT INTO `flw_ev_databasechangelog` VALUES ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2023-08-08 14:31:05', '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, '4.20.0', null, null, '1476265112');
INSERT INTO `flw_ev_databasechangelog` VALUES ('2', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2023-08-08 14:31:05', '2', 'EXECUTED', '8:0ea825feb8e470558f0b5754352b9cda', 'addColumn tableName=FLW_CHANNEL_DEFINITION; addColumn tableName=FLW_CHANNEL_DEFINITION', '', null, '4.20.0', null, null, '1476265112');
INSERT INTO `flw_ev_databasechangelog` VALUES ('3', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2023-08-08 14:31:05', '3', 'EXECUTED', '8:3c2bb293350b5cbe6504331980c9dcee', 'customChange', '', null, '4.20.0', null, null, '1476265112');

-- ----------------------------
-- 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) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of flw_ev_databasechangeloglock
-- ----------------------------
INSERT INTO `flw_ev_databasechangeloglock` VALUES ('1', '', null, null);

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of flw_ru_batch
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of flw_ru_batch_part
-- ----------------------------

-- ----------------------------
-- Table structure for `gen_base_class`
-- ----------------------------
DROP TABLE IF EXISTS `gen_base_class`;
CREATE TABLE `gen_base_class` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `package_name` varchar(200) DEFAULT NULL COMMENT '基类包名',
  `code` varchar(200) DEFAULT NULL COMMENT '基类编码',
  `fields` varchar(500) DEFAULT NULL COMMENT '基类字段，多个用英文逗号分隔',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='基类管理';

-- ----------------------------
-- Records of gen_base_class
-- ----------------------------
INSERT INTO `gen_base_class` VALUES ('1302875019642159105', '${package}.common.entity.BaseEntity', 'BaseEntity', 'id,creator,create_date', '', '2023-08-08 14:33:24');

-- ----------------------------
-- Table structure for `gen_datasource`
-- ----------------------------
DROP TABLE IF EXISTS `gen_datasource`;
CREATE TABLE `gen_datasource` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `db_type` varchar(200) DEFAULT NULL COMMENT '数据库类型 MySQL、Oracle、SQLServer、PostgreSQL',
  `conn_name` varchar(200) NOT NULL COMMENT '连接名',
  `conn_url` varchar(500) DEFAULT NULL COMMENT 'URL',
  `username` varchar(200) DEFAULT NULL COMMENT '用户名',
  `password` varchar(200) DEFAULT NULL COMMENT '密码',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：启用   1：禁用',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据源管理';

-- ----------------------------
-- Records of gen_datasource
-- ----------------------------
INSERT INTO `gen_datasource` VALUES ('1302855887882412034', 'MySQL', '本地', 'jdbc:mysql://localhost:3306/wjp_project40?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true', 'root', '123456', '0', '2023-08-08 14:33:24');

-- ----------------------------
-- Table structure for `gen_field_type`
-- ----------------------------
DROP TABLE IF EXISTS `gen_field_type`;
CREATE TABLE `gen_field_type` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `column_type` varchar(200) DEFAULT NULL COMMENT '字段类型',
  `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型',
  `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `column_type` (`column_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字段类型管理';

-- ----------------------------
-- Records of gen_field_type
-- ----------------------------
INSERT INTO `gen_field_type` VALUES ('1152452777352425473', 'datetime', 'Date', 'java.util.Date', '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453412995002369', 'date', 'Date', 'java.util.Date', '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453603525455873', 'tinyint', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453660052090881', 'smallint', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453722136178689', 'mediumint', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453808874385409', 'int', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453849735294977', 'integer', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453895029583873', 'bigint', 'Long', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453931373228033', 'float', 'Float', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152453967880450050', 'double', 'Double', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454047601586177', 'decimal', 'BigDecimal', 'java.math.BigDecimal', '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454090760974338', 'bit', 'Boolean', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454147010785282', 'char', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454183136325633', 'varchar', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454312664821761', 'tinytext', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454343820111874', 'text', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454372077137921', 'mediumtext', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454401378545665', 'longtext', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454486267064322', 'timestamp', 'Date', 'java.util.Date', '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454630295269378', 'NUMBER', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454715645161474', 'BINARY_INTEGER', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454778828156930', 'BINARY_FLOAT', 'Float', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454828987838466', 'BINARY_DOUBLE', 'Double', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454885745160193', 'VARCHAR2', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454919756771329', 'NVARCHAR', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454952568811521', 'NVARCHAR2', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152454986349735938', 'CLOB', 'String', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152455109695827970', 'int8', 'Long', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152455153002016770', 'int4', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152455184669011969', 'int2', 'Integer', null, '2023-08-08 14:33:24');
INSERT INTO `gen_field_type` VALUES ('1152455217359417345', 'numeric', 'BigDecimal', 'java.math.BigDecimal', '2023-08-08 14:33:24');

-- ----------------------------
-- Table structure for `gen_table_field`
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_field`;
CREATE TABLE `gen_table_field` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `table_id` bigint(20) DEFAULT NULL COMMENT '表ID',
  `table_name` varchar(200) DEFAULT NULL COMMENT '表名',
  `column_name` varchar(200) DEFAULT NULL COMMENT '列名',
  `column_type` varchar(200) DEFAULT NULL COMMENT '类型',
  `column_comment` varchar(200) DEFAULT NULL COMMENT '列说明',
  `attr_name` varchar(200) DEFAULT NULL COMMENT '属性名',
  `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型',
  `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名',
  `is_pk` tinyint(4) DEFAULT NULL COMMENT '是否主键 0：否  1：是',
  `is_required` tinyint(4) DEFAULT NULL COMMENT '是否必填 0：否  1：是',
  `is_form` tinyint(4) DEFAULT NULL COMMENT '是否表单字段 0：否  1：是',
  `is_list` tinyint(4) DEFAULT NULL COMMENT '是否列表字段 0：否  1：是',
  `is_query` tinyint(4) DEFAULT NULL COMMENT '是否查询字段 0：否  1：是',
  `query_type` varchar(200) DEFAULT NULL COMMENT '查询方式',
  `form_type` varchar(200) DEFAULT NULL COMMENT '表单类型',
  `dict_name` varchar(200) DEFAULT NULL COMMENT '字典名称',
  `validator_type` varchar(200) DEFAULT NULL COMMENT '效验方式',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  PRIMARY KEY (`id`),
  KEY `table_name` (`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表列';

-- ----------------------------
-- Records of gen_table_field
-- ----------------------------
INSERT INTO `gen_table_field` VALUES ('1308327671502385153', '1308327671447859201', 'gen_test_data', 'id', 'BIGINT', 'id', 'id', 'Long', null, '1', '0', '0', '0', '0', '=', 'text', null, null, '0');
INSERT INTO `gen_table_field` VALUES ('1308327671510773761', '1308327671447859201', 'gen_test_data', 'username', 'VARCHAR', '用户名', 'username', 'String', null, '0', '1', '1', '1', '1', 'like', 'text', null, null, '1');
INSERT INTO `gen_table_field` VALUES ('1308327671510773762', '1308327671447859201', 'gen_test_data', 'real_name', 'VARCHAR', '姓名', 'realName', 'String', null, '0', '1', '1', '1', '0', 'like', 'text', null, null, '2');
INSERT INTO `gen_table_field` VALUES ('1308327671510773763', '1308327671447859201', 'gen_test_data', 'gender', 'TINYINT', '性别', 'gender', 'Integer', null, '0', '1', '1', '1', '1', '=', 'select', 'gender', null, '3');
INSERT INTO `gen_table_field` VALUES ('1308327671510773764', '1308327671447859201', 'gen_test_data', 'email', 'VARCHAR', '邮箱', 'email', 'String', null, '0', '1', '1', '1', '0', '=', 'text', null, null, '4');
INSERT INTO `gen_table_field` VALUES ('1308327671514968065', '1308327671447859201', 'gen_test_data', 'notice_type', 'TINYINT', '类型', 'noticeType', 'Integer', null, '0', '1', '1', '1', '0', '=', 'radio', 'notice_type', null, '5');
INSERT INTO `gen_table_field` VALUES ('1308327671514968066', '1308327671447859201', 'gen_test_data', 'content', 'TEXT', '内容', 'content', 'String', null, '0', '1', '1', '0', '0', '=', 'editor', null, null, '6');
INSERT INTO `gen_table_field` VALUES ('1308327671514968067', '1308327671447859201', 'gen_test_data', 'creator', 'BIGINT', '创建者', 'creator', 'Long', null, '0', '0', '0', '0', '0', '=', 'text', null, null, '7');
INSERT INTO `gen_table_field` VALUES ('1308327671514968068', '1308327671447859201', 'gen_test_data', 'create_date', 'DATETIME', '创建时间', 'createDate', 'Date', 'java.util.Date', '0', '0', '0', '1', '1', '=', 'date', null, null, '8');
INSERT INTO `gen_table_field` VALUES ('1308327671514968069', '1308327671447859201', 'gen_test_data', 'updater', 'BIGINT', '更新者', 'updater', 'Long', null, '0', '0', '0', '0', '0', '=', 'text', null, null, '9');
INSERT INTO `gen_table_field` VALUES ('1308327671523356674', '1308327671447859201', 'gen_test_data', 'update_date', 'DATETIME', '更新时间', 'updateDate', 'Date', 'java.util.Date', '0', '0', '0', '0', '0', '=', 'text', null, null, '10');

-- ----------------------------
-- Table structure for `gen_table_info`
-- ----------------------------
DROP TABLE IF EXISTS `gen_table_info`;
CREATE TABLE `gen_table_info` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `table_name` varchar(200) DEFAULT NULL COMMENT '表名',
  `class_name` varchar(200) DEFAULT NULL COMMENT '类名',
  `table_comment` varchar(200) DEFAULT NULL COMMENT '功能名',
  `author` varchar(200) DEFAULT NULL COMMENT '作者',
  `email` varchar(200) DEFAULT NULL COMMENT '邮箱',
  `package_name` varchar(200) DEFAULT NULL COMMENT '项目包名',
  `version` varchar(200) DEFAULT NULL COMMENT '项目版本号',
  `backend_path` varchar(500) DEFAULT NULL COMMENT '后端生成路径',
  `frontend_path` varchar(500) DEFAULT NULL COMMENT '前端生成路径',
  `module_name` varchar(200) DEFAULT NULL COMMENT '模块名',
  `sub_module_name` varchar(200) DEFAULT NULL COMMENT '子模块名',
  `datasource_id` bigint(20) DEFAULT NULL COMMENT '数据源ID',
  `baseclass_id` bigint(20) DEFAULT NULL COMMENT '基类ID',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `table_name` (`table_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表';

-- ----------------------------
-- Records of gen_table_info
-- ----------------------------
INSERT INTO `gen_table_info` VALUES ('1308327671447859201', 'gen_test_data', 'TestData', '测试功能', 'Toby', 'javatangbin@163.com', 'com.wjp', '3.0', 'D:\\wjp\\wjp-enterprise\\wjp-admin', 'D:\\wjp\\wjp-enterprise-admin', 'gen', null, '0', '1302875019642159105', '2023-08-08 14:33:24');

-- ----------------------------
-- Table structure for `gen_template`
-- ----------------------------
DROP TABLE IF EXISTS `gen_template`;
CREATE TABLE `gen_template` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `name` varchar(200) DEFAULT NULL COMMENT '名称',
  `file_name` varchar(200) DEFAULT NULL COMMENT '文件名',
  `content` mediumtext NOT NULL COMMENT '内容',
  `path` varchar(500) DEFAULT NULL COMMENT '生成路径',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：启用   1：禁用',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='模板管理';

-- ----------------------------
-- Records of gen_template
-- ----------------------------
INSERT INTO `gen_template` VALUES ('1144564443498168321', 'Entity.java', '${ClassName}Entity.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/entity/${subModuleName!}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1151104918417948674', 'Dao.java', '${ClassName}Dao.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dao/${subModuleName!}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1222102542519422977', 'Dao.xml', '${ClassName}Dao.xml', '', '${backendPath}/src/main/resources/mapper/${moduleName}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1222811087900602369', 'Service.java', '${ClassName}Service.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1222811738672033793', 'ServiceImpl.java', '${ClassName}ServiceImpl.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}/impl', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1222814109661753346', 'Excel.java', '${ClassName}Excel.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/excel/${subModuleName!}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1222816187301851138', 'DTO.java', '${ClassName}DTO.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dto/${subModuleName!}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1222817622663983106', 'Controller.java', '${ClassName}Controller.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/controller/${subModuleName!}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1304292858898309122', 'list.vue', '${classname}.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2023-08-08 14:33:24');
INSERT INTO `gen_template` VALUES ('1304293015698169857', 'add-or-update.vue', '${classname}-add-or-update.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2023-08-08 14:33:24');

-- ----------------------------
-- Table structure for `gen_test_data`
-- ----------------------------
DROP TABLE IF EXISTS `gen_test_data`;
CREATE TABLE `gen_test_data` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `username` varchar(50) DEFAULT NULL COMMENT '用户名',
  `real_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `gender` tinyint(3) unsigned DEFAULT NULL COMMENT '性别',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `notice_type` tinyint(4) DEFAULT NULL COMMENT '类型',
  `content` text COMMENT '内容',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试功能';

-- ----------------------------
-- Records of gen_test_data
-- ----------------------------
INSERT INTO `gen_test_data` VALUES ('1067246875800000001', 'toby', 'Toby', '0', 'root@scjydz.com', '0', '<p>代码生成器！</p>', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');

-- ----------------------------
-- Table structure for `qrtz_blob_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
CREATE TABLE `qrtz_blob_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `BLOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_blob_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for `qrtz_calendars`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_calendars`;
CREATE TABLE `qrtz_calendars` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `CALENDAR_NAME` varchar(200) NOT NULL,
  `CALENDAR` blob NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_calendars
-- ----------------------------

-- ----------------------------
-- Table structure for `qrtz_cron_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
CREATE TABLE `qrtz_cron_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `CRON_EXPRESSION` varchar(120) NOT NULL,
  `TIME_ZONE_ID` varchar(80) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_cron_triggers
-- ----------------------------
INSERT INTO `qrtz_cron_triggers` VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');
INSERT INTO `qrtz_cron_triggers` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai');

-- ----------------------------
-- Table structure for `qrtz_fired_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
CREATE TABLE `qrtz_fired_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `ENTRY_ID` varchar(95) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `FIRED_TIME` bigint(13) NOT NULL,
  `SCHED_TIME` bigint(13) NOT NULL,
  `PRIORITY` int(11) NOT NULL,
  `STATE` varchar(16) NOT NULL,
  `JOB_NAME` varchar(200) DEFAULT NULL,
  `JOB_GROUP` varchar(200) DEFAULT NULL,
  `IS_NONCONCURRENT` varchar(1) DEFAULT NULL,
  `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`),
  KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`),
  KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_fired_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for `qrtz_job_details`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_job_details`;
CREATE TABLE `qrtz_job_details` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `JOB_CLASS_NAME` varchar(250) NOT NULL,
  `IS_DURABLE` varchar(1) NOT NULL,
  `IS_NONCONCURRENT` varchar(1) NOT NULL,
  `IS_UPDATE_DATA` varchar(1) NOT NULL,
  `REQUESTS_RECOVERY` varchar(1) NOT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`),
  KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_job_details
-- ----------------------------
INSERT INTO `qrtz_job_details` VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', null, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189D3CD3F58787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F74000672656E72656E740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F770800000189D3CD3F58787371007E00110ECF9F6107B456017800);
INSERT INTO `qrtz_job_details` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', null, 'com.wjp.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002C636F6D2E776A702E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720020636F6D2E776A702E636F6D6D6F6E2E656E746974792E42617365456E74697479E3EBD9BB2ED95AFB0200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189D3CD3F58787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F74000672656E72656E740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F770800000189D3CD3F58787371007E00110ECF9F6107B456017800);

-- ----------------------------
-- Table structure for `qrtz_locks`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_locks`;
CREATE TABLE `qrtz_locks` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `LOCK_NAME` varchar(40) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_locks
-- ----------------------------
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'TRIGGER_ACCESS');

-- ----------------------------
-- Table structure for `qrtz_paused_trigger_grps`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
CREATE TABLE `qrtz_paused_trigger_grps` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_paused_trigger_grps
-- ----------------------------

-- ----------------------------
-- Table structure for `qrtz_scheduler_state`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
CREATE TABLE `qrtz_scheduler_state` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `INSTANCE_NAME` varchar(200) NOT NULL,
  `LAST_CHECKIN_TIME` bigint(13) NOT NULL,
  `CHECKIN_INTERVAL` bigint(13) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_scheduler_state
-- ----------------------------
INSERT INTO `qrtz_scheduler_state` VALUES ('RenrenScheduler', 'DESKTOP-KIOOR1691476261273', '1691476878409', '15000');
INSERT INTO `qrtz_scheduler_state` VALUES ('WjpScheduler', 'DESKTOP-KIOOR1691570557601', '1691573536746', '15000');

-- ----------------------------
-- Table structure for `qrtz_simple_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
CREATE TABLE `qrtz_simple_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `REPEAT_COUNT` bigint(7) NOT NULL,
  `REPEAT_INTERVAL` bigint(12) NOT NULL,
  `TIMES_TRIGGERED` bigint(10) NOT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_simple_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for `qrtz_simprop_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
CREATE TABLE `qrtz_simprop_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `STR_PROP_1` varchar(512) DEFAULT NULL,
  `STR_PROP_2` varchar(512) DEFAULT NULL,
  `STR_PROP_3` varchar(512) DEFAULT NULL,
  `INT_PROP_1` int(11) DEFAULT NULL,
  `INT_PROP_2` int(11) DEFAULT NULL,
  `LONG_PROP_1` bigint(20) DEFAULT NULL,
  `LONG_PROP_2` bigint(20) DEFAULT NULL,
  `DEC_PROP_1` decimal(13,4) DEFAULT NULL,
  `DEC_PROP_2` decimal(13,4) DEFAULT NULL,
  `BOOL_PROP_1` varchar(1) DEFAULT NULL,
  `BOOL_PROP_2` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_simprop_triggers
-- ----------------------------

-- ----------------------------
-- Table structure for `qrtz_triggers`
-- ----------------------------
DROP TABLE IF EXISTS `qrtz_triggers`;
CREATE TABLE `qrtz_triggers` (
  `SCHED_NAME` varchar(120) NOT NULL,
  `TRIGGER_NAME` varchar(200) NOT NULL,
  `TRIGGER_GROUP` varchar(200) NOT NULL,
  `JOB_NAME` varchar(200) NOT NULL,
  `JOB_GROUP` varchar(200) NOT NULL,
  `DESCRIPTION` varchar(250) DEFAULT NULL,
  `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PREV_FIRE_TIME` bigint(13) DEFAULT NULL,
  `PRIORITY` int(11) DEFAULT NULL,
  `TRIGGER_STATE` varchar(16) NOT NULL,
  `TRIGGER_TYPE` varchar(8) NOT NULL,
  `START_TIME` bigint(13) NOT NULL,
  `END_TIME` bigint(13) DEFAULT NULL,
  `CALENDAR_NAME` varchar(200) DEFAULT NULL,
  `MISFIRE_INSTR` smallint(2) DEFAULT NULL,
  `JOB_DATA` blob,
  PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`),
  KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`),
  KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`),
  KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`),
  KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`),
  CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of qrtz_triggers
-- ----------------------------
INSERT INTO `qrtz_triggers` VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', 'TASK_1067246875800000076', 'DEFAULT', null, '1691478000000', '-1', '5', 'PAUSED', 'CRON', '1691476278000', '0', null, '2', '');
INSERT INTO `qrtz_triggers` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', 'TASK_1067246875800000076', 'DEFAULT', null, '1691478000000', '-1', '5', 'PAUSED', 'CRON', '1691477974000', '0', null, '2', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002C636F6D2E776A702E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720020636F6D2E776A702E636F6D6D6F6E2E656E746974792E42617365456E74697479E3EBD9BB2ED95AFB0200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189D3CD3F58787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F740003776A70740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F770800000189D4387C78787371007E00110ECF9F6107B456017800);

-- ----------------------------
-- Table structure for `schedule_job`
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job`;
CREATE TABLE `schedule_job` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式',
  `status` tinyint(3) unsigned DEFAULT NULL COMMENT '任务状态  0：暂停  1：正常',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务';

-- ----------------------------
-- Records of schedule_job
-- ----------------------------
INSERT INTO `schedule_job` VALUES ('1067246875800000076', 'testTask', 'wjp', '0 0/30 * * * ?', '0', '有参测试，多个参数使用json', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:16:59');

-- ----------------------------
-- Table structure for `schedule_job_log`
-- ----------------------------
DROP TABLE IF EXISTS `schedule_job_log`;
CREATE TABLE `schedule_job_log` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `job_id` bigint(20) NOT NULL COMMENT '任务id',
  `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称',
  `params` varchar(2000) DEFAULT NULL COMMENT '参数',
  `status` tinyint(3) unsigned NOT NULL COMMENT '任务状态    0：失败    1：成功',
  `error` varchar(2000) DEFAULT NULL COMMENT '失败信息',
  `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_job_id` (`job_id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务日志';

-- ----------------------------
-- Records of schedule_job_log
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_dept`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID',
  `pids` varchar(500) DEFAULT NULL COMMENT '所有上级ID，用逗号分开',
  `name` varchar(50) DEFAULT NULL COMMENT '部门名称',
  `sort` int(10) unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
INSERT INTO `sys_dept` VALUES ('1067246875800000062', '1067246875800000063', '1067246875800000066,1067246875800000063', '技术部', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dept` VALUES ('1067246875800000063', '1067246875800000066', '1067246875800000066', '北京总公司', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:37:18');
INSERT INTO `sys_dept` VALUES ('1067246875800000064', '1067246875800000066', '1067246875800000066', '成都总公司', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:37:08');
INSERT INTO `sys_dept` VALUES ('1067246875800000065', '1067246875800000064', '1067246875800000066,1067246875800000064', '软件部', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:37:29');
INSERT INTO `sys_dept` VALUES ('1067246875800000066', '0', '0', '佳缘科技股份有限公司', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:36:56');
INSERT INTO `sys_dept` VALUES ('1067246875800000067', '1067246875800000064', '1067246875800000066,1067246875800000064', '销售部', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dept` VALUES ('1067246875800000068', '1067246875800000063', '1067246875800000066,1067246875800000063', '产品部', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');

-- ----------------------------
-- Table structure for `sys_dict_data`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_data`;
CREATE TABLE `sys_dict_data` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `dict_type_id` bigint(20) NOT NULL COMMENT '字典类型ID',
  `dict_label` varchar(255) NOT NULL COMMENT '字典标签',
  `dict_value` varchar(255) DEFAULT NULL COMMENT '字典值',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `sort` int(10) unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_dict_type_value` (`dict_type_id`,`dict_value`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典数据';

-- ----------------------------
-- Records of sys_dict_data
-- ----------------------------
INSERT INTO `sys_dict_data` VALUES ('1160061112075464705', '1160061077912858625', '男', '0', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1160061146967879681', '1160061077912858625', '女', '1', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1160061190127267841', '1160061077912858625', '保密', '2', '', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1225814069634195457', '1225813644059140097', '公告', '0', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1225814107559092225', '1225813644059140097', '会议', '1', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1225814271879340034', '1225813644059140097', '其他', '2', '', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1341593562419445762', '1341593474355838978', '停用', '0', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1341593595407646722', '1341593474355838978', '正常', '1', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1343069765549191170', '1343069688596295682', '已取消', '-1', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1343069839847092226', '1343069688596295682', '等待付款', '0', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_data` VALUES ('1343069914518286337', '1343069688596295682', '已完成', '1', '', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');

-- ----------------------------
-- Table structure for `sys_dict_type`
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `dict_type` varchar(100) NOT NULL COMMENT '字典类型',
  `dict_name` varchar(255) NOT NULL COMMENT '字典名称',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `sort` int(10) unsigned DEFAULT NULL COMMENT '排序',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `dict_type` (`dict_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典类型';

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES ('1160061077912858625', 'gender', '性别', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_type` VALUES ('1225813644059140097', 'notice_type', '站内通知-类型', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_type` VALUES ('1341593474355838978', 'post_status', '岗位管理状态', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_dict_type` VALUES ('1343069688596295682', 'order_status', '订单状态', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');

-- ----------------------------
-- Table structure for `sys_language`
-- ----------------------------
DROP TABLE IF EXISTS `sys_language`;
CREATE TABLE `sys_language` (
  `table_name` varchar(32) NOT NULL COMMENT '表名',
  `table_id` bigint(20) NOT NULL COMMENT '表主键',
  `field_name` varchar(32) NOT NULL COMMENT '字段名',
  `field_value` varchar(200) NOT NULL COMMENT '字段值',
  `language` varchar(10) NOT NULL COMMENT '语言',
  PRIMARY KEY (`table_name`,`table_id`,`field_name`,`language`),
  KEY `idx_table_id` (`table_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='国际化';

-- ----------------------------
-- Records of sys_language
-- ----------------------------
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', 'Authority Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', '权限管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', '權限管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', 'Export', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', '导出', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', '導出', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', 'Role Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', '角色管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', '角色管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', 'Department Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', '部门管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', '部門管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', 'Form Design', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', '表单设计', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', '表单设计', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', 'Process Design', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', '流程设计', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', '流程设计', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', 'Running Process', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', '运行中的流程', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', '運行中的流程', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', 'Menu Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', '菜单管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', '菜單管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', 'Timed Task', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', '定时任务', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', '定時任務', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', 'Setting', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', '系统设置', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', '系統設置', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', 'Pause', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', '暂停', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', '暫停', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', 'Resume', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', '恢复', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', '恢復', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', 'Execute', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', '立即执行', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', '立即執行', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', 'Log List', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', '日志列表', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', '日誌列表', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', 'Parameter Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', '参数管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', '參數管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', 'Dict Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', '字典管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', '字典管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', 'Log Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', '日志管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', '日誌管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', 'File Upload', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', '文件上传', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', '文件上傳', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', 'Login Log', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', '登录日志', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', '登錄日誌', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', 'Operation Log', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', '操作日志', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', '操作日誌', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', 'Error Log', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', '异常日志', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', '異常日誌', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', 'System Monitoring', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', '系统监控', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', '系統監控', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', 'User Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', '用户管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', '用戶管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', 'Export', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', '导出', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', '導出', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', 'Station Notice', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', '站内通知', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', '站內通知', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', 'Notice Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', '通知管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', '通知管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', 'My Notice', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', '我的通知', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', '我的通知', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', 'Process Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', '流程管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', '流程管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', 'Personal Office', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', '流程使用', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', '辦公管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', 'Todo', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', '待办任务', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', '待辦任務', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', 'Task Already', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', '已办任务', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', '已辦任務', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', 'Initiation Process', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', '发起流程', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', '發起流程', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', 'My Send', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', '我发起的', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', '我發起的', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', 'Interface Document', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', '接口文档', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', '接口文檔', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', 'Report Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', '报表管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', '報表管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', 'Report Design', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', '报表设计器', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', '報表設計器', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', 'Report List', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', '报表列表', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', '報表列表', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', 'DevTools', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', '开发者工具', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', '開發者工具', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', 'DataSource', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', '数据源管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', '數據源管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', 'Field Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', '字段管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', '字段管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', 'BaseClass', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', '基类管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', '基類管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', 'Template', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', '模板管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', '模板管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', 'Code Generation', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', '代码生成工具', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', '代碼生成工具', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', 'Parameter Config', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', '参数配置', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', '參數配置', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', 'Config Info', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', '配置信息', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', '配置信息', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', 'Job Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', '岗位管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', '崗位管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', 'Online User', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', '在线用户', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', '在線用戶', 'zh-TW');

-- ----------------------------
-- Table structure for `sys_log_error`
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_error`;
CREATE TABLE `sys_log_error` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI',
  `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式',
  `request_params` text COMMENT '请求参数',
  `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) DEFAULT NULL COMMENT '操作IP',
  `error_info` text COMMENT '异常信息',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='异常日志';

-- ----------------------------
-- Records of sys_log_error
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_log_login`
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_login`;
CREATE TABLE `sys_log_login` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `operation` tinyint(3) unsigned DEFAULT NULL COMMENT '用户操作   0：用户登录   1：用户退出',
  `status` tinyint(3) unsigned NOT NULL COMMENT '状态  0：失败    1：成功    2：账号已锁定',
  `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) DEFAULT NULL COMMENT '操作IP',
  `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_status` (`status`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='登录日志';

-- ----------------------------
-- Records of sys_log_login
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_log_operation`
-- ----------------------------
DROP TABLE IF EXISTS `sys_log_operation`;
CREATE TABLE `sys_log_operation` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `operation` varchar(50) DEFAULT NULL COMMENT '用户操作',
  `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI',
  `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式',
  `request_params` text COMMENT '请求参数',
  `request_time` int(10) unsigned NOT NULL COMMENT '请求时长(毫秒)',
  `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理',
  `ip` varchar(32) DEFAULT NULL COMMENT '操作IP',
  `status` tinyint(3) unsigned NOT NULL COMMENT '状态  0：失败   1：成功',
  `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志';

-- ----------------------------
-- Records of sys_log_operation
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级菜单为0',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单URL',
  `permissions` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)',
  `menu_type` tinyint(3) unsigned DEFAULT NULL COMMENT '类型   0：菜单   1：按钮',
  `open_style` tinyint(3) unsigned DEFAULT NULL COMMENT '打开方式   0：内部   1：外部',
  `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_pid` (`pid`),
  KEY `idx_sort` (`sort`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='菜单管理';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES ('1067246875800000002', '0', null, null, '0', '0', 'icon-safetycertificate', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000003', '1067246875800000055', null, 'sys:user:save,sys:dept:list,sys:role:list', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000004', '1067246875800000055', null, 'sys:user:update,sys:dept:list,sys:role:list', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000005', '1067246875800000055', null, 'sys:user:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000006', '1067246875800000055', null, 'sys:user:export', '1', '0', null, '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000007', '1067246875800000002', 'sys/role', null, '0', '0', 'icon-team', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000008', '1067246875800000007', null, 'sys:role:page,sys:role:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000009', '1067246875800000007', null, 'sys:role:save,sys:menu:select,sys:dept:list', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000010', '1067246875800000007', null, 'sys:role:update,sys:menu:select,sys:dept:list', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000011', '1067246875800000007', null, 'sys:role:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000012', '1067246875800000002', 'sys/dept', null, '0', '0', 'icon-apartment', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000014', '1067246875800000012', null, 'sys:dept:list,sys:dept:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000015', '1067246875800000012', null, 'sys:dept:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000016', '1067246875800000012', null, 'sys:dept:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000017', '1067246875800000012', null, 'sys:dept:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000018', '1150940491508928513', 'flow/bpmform', 'flow:bpmform:all', '0', '0', 'icon-detail', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000019', '1150940491508928513', 'flow/model', 'sys:model:all', '0', '0', 'icon-appstore-fill', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000020', '1150940491508928513', 'flow/running', 'sys:running:all,sys:flow:all', '0', '0', 'icon-play-square', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000025', '1067246875800000035', 'sys/menu', null, '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000026', '1067246875800000025', null, 'sys:menu:list,sys:menu:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000027', '1067246875800000025', null, 'sys:menu:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000028', '1067246875800000025', null, 'sys:menu:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000029', '1067246875800000025', null, 'sys:menu:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000030', '1067246875800000035', 'job/schedule', null, '0', '0', 'icon-dashboard', '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000031', '1067246875800000030', null, 'sys:schedule:page,sys:schedule:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000032', '1067246875800000030', null, 'sys:schedule:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000033', '1067246875800000030', null, 'sys:schedule:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000034', '1067246875800000030', null, 'sys:schedule:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000035', '0', null, null, '0', '0', 'icon-setting', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000036', '1067246875800000030', null, 'sys:schedule:pause', '1', '0', null, '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000037', '1067246875800000030', null, 'sys:schedule:resume', '1', '0', null, '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000038', '1067246875800000030', null, 'sys:schedule:run', '1', '0', null, '6', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000039', '1067246875800000030', null, 'sys:schedule:log', '1', '0', null, '7', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000040', '1067246875800000035', 'sys/params', '', '0', '0', 'icon-fileprotect', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000041', '1067246875800000035', 'sys/dict-type', null, '0', '0', 'icon-golden-fill', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000042', '1067246875800000041', null, 'sys:dict:page,sys:dict:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000043', '1067246875800000041', null, 'sys:dict:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000044', '1067246875800000041', null, 'sys:dict:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000045', '1067246875800000041', null, 'sys:dict:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000046', '0', null, null, '0', '0', 'icon-container', '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000047', '1067246875800000035', 'oss/oss', 'sys:oss:all', '0', '0', 'icon-upload', '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000048', '1067246875800000046', 'sys/log-login', 'sys:log:login', '0', '0', 'icon-filedone', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000049', '1067246875800000046', 'sys/log-operation', 'sys:log:operation', '0', '0', 'icon-solution', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000050', '1067246875800000046', 'sys/log-error', 'sys:log:error', '0', '0', 'icon-file-exception', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000053', '0', null, null, '0', '0', 'icon-desktop', '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000055', '1067246875800000002', 'sys/user', null, '0', '0', 'icon-user', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000056', '1067246875800000055', null, 'sys:user:page,sys:user:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000057', '1067246875800000040', null, 'sys:params:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000058', '1067246875800000040', null, 'sys:params:export', '1', '0', null, '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000059', '1067246875800000040', '', 'sys:params:page,sys:params:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000060', '1067246875800000040', null, 'sys:params:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000061', '1067246875800000040', '', 'sys:params:delete', '1', '0', '', '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000300', '0', null, null, '0', '0', 'icon-bell', '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000301', '1067246875800000300', 'notice/notice', 'sys:notice:all', '0', '0', 'icon-bell', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1067246875800000302', '1067246875800000300', 'notice/notice-user', 'sys:notice:all', '0', '0', 'icon-notification', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1150940491508928513', '0', null, null, '0', '0', 'icon-reloadtime', '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1150941310262235138', '0', null, null, '0', '0', 'icon-user', '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-09 11:40:46');
INSERT INTO `sys_menu` VALUES ('1150941384811794433', '1150941310262235138', 'flow/todo', 'sys:flow:all,sys:user:page', '0', '0', 'icon-dashboard', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1150941447038488577', '1150941310262235138', 'flow/done', 'sys:flow:all', '0', '0', 'icon-check-square', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1150941506626965506', '1150941310262235138', 'flow/start', 'sys:flow:all', '0', '0', 'icon-play-square', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1150941588046794754', '1150941310262235138', 'flow/my-send', 'sys:flow:all', '0', '0', 'icon-edit-square', '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1156748733921165314', '1067246875800000053', '{{ApiUrl}}/doc.html', '', '0', '1', 'icon-file-word', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1302850622416084993', '0', '', '', '0', '0', 'icon-rocket', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1302850783288614913', '1305532398162145281', 'devtools/datasource', '', '0', '0', 'icon-sync', '0', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1302862890696564738', '1305532398162145281', 'devtools/fieldtype', '', '0', '0', 'icon-eye', '1', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1302874751835848705', '1305532398162145281', 'devtools/baseclass', '', '0', '0', 'icon-info-circle', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1304081184014635010', '1305532398162145281', 'devtools/template', '', '0', '0', 'icon-up-circle', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1304802103569809410', '1302850622416084993', 'devtools/generator', '', '0', '0', 'icon-tags', '0', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1305513187675144193', '1305532398162145281', 'devtools/param', '', '0', '0', 'icon-setting', '5', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1305532398162145281', '1302850622416084993', '', '', '0', '0', 'icon-setting', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_menu` VALUES ('1341596622612987906', '1067246875800000002', 'sys/post', null, '0', '0', 'icon-pic-left', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1341596622688485377', '1341596622612987906', null, 'sys:post:page,sys:post:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1341596622755594242', '1341596622612987906', null, 'sys:post:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1341596622835286018', '1341596622612987906', null, 'sys:post:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1341596622902394881', '1341596622612987906', null, 'sys:post:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');
INSERT INTO `sys_menu` VALUES ('1341659662599495681', '1067246875800000053', 'sys/online', 'sys:online:all', '0', '0', 'icon-team', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');

-- ----------------------------
-- Table structure for `sys_notice`
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice`;
CREATE TABLE `sys_notice` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `notice_type` int(11) NOT NULL COMMENT '通知类型',
  `title` varchar(200) DEFAULT NULL COMMENT '标题',
  `content` text COMMENT '内容',
  `receiver_type` tinyint(3) unsigned DEFAULT NULL COMMENT '接收者  0：全部  1：部门',
  `receiver_type_ids` varchar(500) DEFAULT NULL COMMENT '接收者ID，用逗号分开',
  `status` tinyint(3) unsigned DEFAULT NULL COMMENT '发送状态  0：草稿  1：已发布',
  `sender_name` varchar(50) DEFAULT NULL COMMENT '发送者',
  `sender_date` datetime DEFAULT NULL COMMENT '发送时间',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知管理';

-- ----------------------------
-- Records of sys_notice
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_notice_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_notice_user`;
CREATE TABLE `sys_notice_user` (
  `receiver_id` bigint(20) NOT NULL COMMENT '接收者ID',
  `notice_id` bigint(20) NOT NULL COMMENT '通知ID',
  `read_status` tinyint(3) unsigned DEFAULT NULL COMMENT '阅读状态  0：未读  1：已读',
  `read_date` datetime DEFAULT NULL COMMENT '阅读时间',
  PRIMARY KEY (`receiver_id`,`notice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='我的通知';

-- ----------------------------
-- Records of sys_notice_user
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_oss`
-- ----------------------------
DROP TABLE IF EXISTS `sys_oss`;
CREATE TABLE `sys_oss` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `url` varchar(200) DEFAULT NULL COMMENT 'URL地址',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件上传';

-- ----------------------------
-- Records of sys_oss
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_params`
-- ----------------------------
DROP TABLE IF EXISTS `sys_params`;
CREATE TABLE `sys_params` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `param_code` varchar(32) DEFAULT NULL COMMENT '参数编码',
  `param_value` varchar(2000) DEFAULT NULL COMMENT '参数值',
  `param_type` tinyint(3) unsigned DEFAULT '1' COMMENT '类型   0：系统参数   1：非系统参数',
  `remark` varchar(200) DEFAULT NULL COMMENT '备注',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_param_code` (`param_code`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='参数管理';

-- ----------------------------
-- Records of sys_params
-- ----------------------------
INSERT INTO `sys_params` VALUES ('1067246875800000072', 'DEV_TOOLS_PARAM_KEY', '{\"packageName\":\"com.wjp\",\"version\":\"4.0\",\"author\":\"Toby\",\"email\":\"javatangbin@163.com\",\"backendPath\":\"D:\\\\toby\\\\code\\\\kuangjia\\\\wjp-project40\\\\wjp-admin\",\"frontendPath\":\"D:\\\\toby\\\\code\\\\kuangjia\\\\wjp-project-admin40\"}', '0', '代码生成器配置信息', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24');
INSERT INTO `sys_params` VALUES ('1067246875800000073', 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":1,\"qiniuDomain\":\"http://test.oss.scjydz.com\",\"qiniuPrefix\":\"upload\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"qiniuBucketName\":\"wjp-oss\",\"aliyunDomain\":\"\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"\",\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', '0', '云存储配置信息', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51');

-- ----------------------------
-- Table structure for `sys_post`
-- ----------------------------
DROP TABLE IF EXISTS `sys_post`;
CREATE TABLE `sys_post` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `post_code` varchar(100) DEFAULT NULL COMMENT '岗位编码',
  `post_name` varchar(100) DEFAULT NULL COMMENT '岗位名称',
  `sort` int(11) DEFAULT NULL COMMENT '排序',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：停用   1：正常',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='岗位管理';

-- ----------------------------
-- Records of sys_post
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_role`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `name` varchar(50) DEFAULT NULL COMMENT '角色名称',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_dept_id` (`dept_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色管理';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES ('1689151872981299201', '超级管理员', '超级管理员', null, '1067246875800000001', '2023-08-09 13:49:24', '1067246875800000001', '2023-08-09 16:52:52');

-- ----------------------------
-- Table structure for `sys_role_data_scope`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_data_scope`;
CREATE TABLE `sys_role_data_scope` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色数据权限';

-- ----------------------------
-- Records of sys_role_data_scope
-- ----------------------------
INSERT INTO `sys_role_data_scope` VALUES ('1689198043284193281', '1689151872981299201', '1067246875800000066', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_data_scope` VALUES ('1689198043292581890', '1689151872981299201', '1067246875800000064', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_data_scope` VALUES ('1689198043300970497', '1689151872981299201', '1067246875800000065', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_data_scope` VALUES ('1689198043305164801', '1689151872981299201', '1067246875800000067', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_data_scope` VALUES ('1689198043313553410', '1689151872981299201', '1067246875800000063', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_data_scope` VALUES ('1689198043321942018', '1689151872981299201', '1067246875800000068', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_data_scope` VALUES ('1689198043330330626', '1689151872981299201', '1067246875800000062', '1067246875800000001', '2023-08-09 16:52:52');

-- ----------------------------
-- Table structure for `sys_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_menu_id` (`menu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色菜单关系';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
INSERT INTO `sys_role_menu` VALUES ('1689198042764099586', '1689151872981299201', '1067246875800000053', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042776682498', '1689151872981299201', '1067246875800000002', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042785071106', '1689151872981299201', '1067246875800000055', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042793459714', '1689151872981299201', '1067246875800000056', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042801848321', '1689151872981299201', '1067246875800000003', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042810236930', '1689151872981299201', '1067246875800000004', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042818625538', '1689151872981299201', '1067246875800000005', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042822819842', '1689151872981299201', '1067246875800000006', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042831208449', '1689151872981299201', '1341596622612987906', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042839597058', '1689151872981299201', '1341596622688485377', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042847985666', '1689151872981299201', '1341596622755594242', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042856374274', '1689151872981299201', '1341596622835286018', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042864762881', '1689151872981299201', '1341596622902394881', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042881540098', '1689151872981299201', '1067246875800000012', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042889928705', '1689151872981299201', '1067246875800000014', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042894123009', '1689151872981299201', '1067246875800000015', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042902511617', '1689151872981299201', '1067246875800000016', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042910900226', '1689151872981299201', '1067246875800000017', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042919288833', '1689151872981299201', '1067246875800000007', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042927677442', '1689151872981299201', '1067246875800000008', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042931871745', '1689151872981299201', '1067246875800000009', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042940260353', '1689151872981299201', '1067246875800000010', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042948648962', '1689151872981299201', '1067246875800000011', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042965426178', '1689151872981299201', '1067246875800000035', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042969620482', '1689151872981299201', '1067246875800000025', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042978009090', '1689151872981299201', '1067246875800000026', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042986397697', '1689151872981299201', '1067246875800000027', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198042998980609', '1689151872981299201', '1067246875800000028', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043007369217', '1689151872981299201', '1067246875800000029', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043019952130', '1689151872981299201', '1067246875800000040', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043028340738', '1689151872981299201', '1067246875800000059', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043032535041', '1689151872981299201', '1067246875800000057', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043040923649', '1689151872981299201', '1067246875800000060', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043049312258', '1689151872981299201', '1067246875800000061', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043057700865', '1689151872981299201', '1067246875800000058', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043066089473', '1689151872981299201', '1067246875800000041', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043082866690', '1689151872981299201', '1067246875800000042', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043091255297', '1689151872981299201', '1067246875800000043', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043099643906', '1689151872981299201', '1067246875800000044', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043103838209', '1689151872981299201', '1067246875800000045', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043116421121', '1689151872981299201', '1067246875800000030', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043116421122', '1689151872981299201', '1067246875800000031', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043124809730', '1689151872981299201', '1067246875800000032', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043141586945', '1689151872981299201', '1067246875800000033', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043149975553', '1689151872981299201', '1067246875800000034', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043158364162', '1689151872981299201', '1067246875800000036', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043170947074', '1689151872981299201', '1067246875800000037', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043179335681', '1689151872981299201', '1067246875800000038', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043187724290', '1689151872981299201', '1067246875800000039', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043196112897', '1689151872981299201', '1067246875800000047', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043204501506', '1689151872981299201', '1067246875800000300', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043212890113', '1689151872981299201', '1067246875800000302', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043221278721', '1689151872981299201', '1067246875800000301', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043233861633', '1689151872981299201', '1067246875800000046', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043233861634', '1689151872981299201', '1067246875800000048', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043242250242', '1689151872981299201', '1067246875800000049', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043259027458', '1689151872981299201', '1067246875800000050', '1067246875800000001', '2023-08-09 16:52:52');
INSERT INTO `sys_role_menu` VALUES ('1689198043259027459', '1689151872981299201', '1341659662599495681', '1067246875800000001', '2023-08-09 16:52:52');

-- ----------------------------
-- Table structure for `sys_role_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_user`;
CREATE TABLE `sys_role_user` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_role_id` (`role_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色用户关系';

-- ----------------------------
-- Records of sys_role_user
-- ----------------------------
INSERT INTO `sys_role_user` VALUES ('1689198194241388546', '1689151872981299201', '1689152089323499521', '1067246875800000001', '2023-08-09 16:53:28');

-- ----------------------------
-- Table structure for `sys_user`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `password` varchar(100) DEFAULT NULL COMMENT '密码',
  `real_name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `head_url` varchar(200) DEFAULT NULL COMMENT '头像',
  `gender` tinyint(3) unsigned DEFAULT NULL COMMENT '性别   0：男   1：女    2：保密',
  `email` varchar(100) DEFAULT NULL COMMENT '邮箱',
  `mobile` varchar(100) DEFAULT NULL COMMENT '手机号',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID',
  `super_admin` tinyint(3) unsigned DEFAULT NULL COMMENT '超级管理员   0：否   1：是',
  `status` tinyint(4) DEFAULT NULL COMMENT '状态  0：停用   1：正常',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `updater` bigint(20) DEFAULT NULL COMMENT '更新者',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_username` (`username`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统用户';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES ('1067246875800000001', 'admin', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '管理员', null, '0', 'root@renren.io', '13612345678', null, '1', '1', '1067246875800000001', '2023-08-08 14:19:50', '1067246875800000001', '2023-08-08 14:19:50');
INSERT INTO `sys_user` VALUES ('1689152089323499521', 'root', '$2a$10$UfWfEQAYe2XwsP.n9wy4OuhsYE0WuR.uhVo15orrCEecoYXu8/CCO', '超级管理员', null, '0', '', '', '1067246875800000066', '0', '1', '1067246875800000001', '2023-08-09 13:50:16', '1067246875800000001', '2023-08-09 16:53:28');

-- ----------------------------
-- Table structure for `sys_user_post`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_post`;
CREATE TABLE `sys_user_post` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `post_id` bigint(20) DEFAULT NULL COMMENT '岗位ID',
  `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_post_id` (`post_id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户岗位关系';

-- ----------------------------
-- Records of sys_user_post
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_user_token`
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_token`;
CREATE TABLE `sys_user_token` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `user_id` bigint(20) NOT NULL COMMENT '用户id',
  `token` varchar(100) NOT NULL COMMENT '用户token',
  `expire_date` datetime DEFAULT NULL COMMENT '过期时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统用户Token';

-- ----------------------------
-- Records of sys_user_token
-- ----------------------------
INSERT INTO `sys_user_token` VALUES ('1688802091666866178', '1067246875800000001', '3f3556faad90731f930bc279ebe90785', '2023-08-10 05:24:59', '2023-08-09 17:24:59', '2023-08-08 14:39:30');
INSERT INTO `sys_user_token` VALUES ('1688832709784064002', '1688832479013457922', '1d78c4d3d1b9ffd7300e0e94997faa6e', '2023-08-10 02:15:04', '2023-08-09 14:15:04', '2023-08-08 16:41:10');
INSERT INTO `sys_user_token` VALUES ('1689156110964781057', '1689152089323499521', 'aff727fc69b83d778696fb3231a2a97c', '2023-08-10 05:28:58', '2023-08-09 17:28:58', '2023-08-09 14:06:15');
INSERT INTO `sys_user_token` VALUES ('1689156782175055874', '1353943117220315138', '5053ace23188fc343dffc4fb55af635c', '2023-08-10 02:08:55', '2023-08-09 14:08:55', '2023-08-09 14:08:55');

-- ----------------------------
-- Table structure for `tb_token`
-- ----------------------------
DROP TABLE IF EXISTS `tb_token`;
CREATE TABLE `tb_token` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `user_id` bigint(20) NOT NULL COMMENT '用户ID',
  `token` varchar(100) NOT NULL COMMENT 'token',
  `expire_date` datetime DEFAULT NULL COMMENT '过期时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  UNIQUE KEY `token` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户Token';

-- ----------------------------
-- Records of tb_token
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_user`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `username` varchar(50) NOT NULL COMMENT '用户名',
  `mobile` varchar(20) NOT NULL COMMENT '手机号',
  `password` varchar(64) DEFAULT NULL COMMENT '密码',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('1067246875900000001', 'mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2023-08-08 14:35:16');