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

/*
Navicat MySQL Data Transfer

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

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

Date: 2024-04-07 14:11:40
*/

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', '7.0.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', '7.0.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('entitylink.schema.version', '7.0.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('eventsubscription.schema.version', '7.0.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('identitylink.schema.version', '7.0.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('job.schema.version', '7.0.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', '1');
INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(7.0.0.0)', '1');
INSERT INTO `act_ge_property` VALUES ('schema.version', '7.0.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('task.schema.version', '7.0.0.0', '1');
INSERT INTO `act_ge_property` VALUES ('variable.schema.version', '7.0.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,
  `META_INFO_` 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', '7.0.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,
  `META_INFO_` 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_type` varchar(64) DEFAULT NULL COMMENT '表单类型',
  `form_id` varchar(500) 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
-- ----------------------------

-- ----------------------------
-- 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_form_correction`
-- ----------------------------
DROP TABLE IF EXISTS `bpm_form_correction`;
CREATE TABLE `bpm_form_correction` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `apply_post` varchar(255) DEFAULT NULL COMMENT '申请岗位',
  `entry_date` datetime DEFAULT NULL COMMENT '入职日期',
  `correction_date` datetime DEFAULT NULL COMMENT '转正日期',
  `work_content` varchar(2000) DEFAULT NULL COMMENT '工作内容',
  `achievement` varchar(2000) DEFAULT NULL COMMENT '工作成绩',
  `instance_id` varchar(80) DEFAULT NULL COMMENT '实例ID',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义表单(转正申请)';

-- ----------------------------
-- Records of bpm_form_correction
-- ----------------------------

-- ----------------------------
-- 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', '2024-04-07 11:59:17', '1', 'EXECUTED', '9:63268f536c469325acef35970312551b', '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.24.0', null, null, '2462357105');
INSERT INTO `flw_ev_databasechangelog` VALUES ('2', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-04-07 11:59:17', '2', 'EXECUTED', '9:dcb58b7dfd6dbda66939123a96985536', 'addColumn tableName=FLW_CHANNEL_DEFINITION; addColumn tableName=FLW_CHANNEL_DEFINITION', '', null, '4.24.0', null, null, '2462357105');
INSERT INTO `flw_ev_databasechangelog` VALUES ('3', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-04-07 11:59:17', '3', 'EXECUTED', '9:d0c05678d57af23ad93699991e3bf4f6', 'customChange', '', null, '4.24.0', null, null, '2462357105');

-- ----------------------------
-- Table structure for `flw_ev_databasechangeloglock`
-- ----------------------------
DROP TABLE IF EXISTS `flw_ev_databasechangeloglock`;
CREATE TABLE `flw_ev_databasechangeloglock` (
  `ID` int(11) NOT NULL,
  `LOCKED` tinyint(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', '0', 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', '专业版', '2024-04-07 11:49:42');

-- ----------------------------
-- 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_project?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true', 'root', '123456', '0', '2024-04-07 11:49:42');

-- ----------------------------
-- 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', '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453412995002369', 'date', 'Date', 'java.util.Date', '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453603525455873', 'tinyint', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453660052090881', 'smallint', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453722136178689', 'mediumint', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453808874385409', 'int', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453849735294977', 'integer', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453895029583873', 'bigint', 'Long', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453931373228033', 'float', 'Float', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152453967880450050', 'double', 'Double', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454047601586177', 'decimal', 'BigDecimal', 'java.math.BigDecimal', '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454090760974338', 'bit', 'Boolean', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454147010785282', 'char', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454183136325633', 'varchar', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454312664821761', 'tinytext', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454343820111874', 'text', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454372077137921', 'mediumtext', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454401378545665', 'longtext', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454486267064322', 'timestamp', 'Date', 'java.util.Date', '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454630295269378', 'NUMBER', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454715645161474', 'BINARY_INTEGER', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454778828156930', 'BINARY_FLOAT', 'Float', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454828987838466', 'BINARY_DOUBLE', 'Double', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454885745160193', 'VARCHAR2', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454919756771329', 'NVARCHAR', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454952568811521', 'NVARCHAR2', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152454986349735938', 'CLOB', 'String', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152455109695827970', 'int8', 'Long', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152455153002016770', 'int4', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152455184669011969', 'int2', 'Integer', null, '2024-04-07 11:49:42');
INSERT INTO `gen_field_type` VALUES ('1152455217359417345', 'numeric', 'BigDecimal', 'java.math.BigDecimal', '2024-04-07 11:49:42');

-- ----------------------------
-- 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:\\code\\wjp-project\\wjp-admin', 'D:\\code\\wjp-project-admin', 'gen', null, '0', '1302875019642159105', '2024-04-07 11:49:42');

-- ----------------------------
-- 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', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1151104918417948674', 'Dao.java', '${ClassName}Dao.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dao/${subModuleName!}', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1222102542519422977', 'Dao.xml', '${ClassName}Dao.xml', '', '${backendPath}/src/main/resources/mapper/${moduleName}', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1222811087900602369', 'Service.java', '${ClassName}Service.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1222811738672033793', 'ServiceImpl.java', '${ClassName}ServiceImpl.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}/impl', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1222814109661753346', 'Excel.java', '${ClassName}Excel.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/excel/${subModuleName!}', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1222816187301851138', 'DTO.java', '${ClassName}DTO.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dto/${subModuleName!}', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1222817622663983106', 'Controller.java', '${ClassName}Controller.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/controller/${subModuleName!}', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1304292858898309122', 'list.vue', '${classname}.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2024-04-07 11:49:42');
INSERT INTO `gen_template` VALUES ('1304293015698169857', 'add-or-update.vue', '${classname}-add-or-update.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2024-04-07 11:49:42');

-- ----------------------------
-- 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', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');

-- ----------------------------
-- Table structure for `mp_account`
-- ----------------------------
DROP TABLE IF EXISTS `mp_account`;
CREATE TABLE `mp_account` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `app_id` varchar(100) DEFAULT NULL COMMENT 'AppID',
  `app_secret` varchar(100) DEFAULT NULL COMMENT 'AppSecret',
  `token` varchar(100) DEFAULT NULL COMMENT 'Token',
  `aes_key` varchar(100) DEFAULT NULL COMMENT 'EncodingAESKey',
  `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 mp_account
-- ----------------------------

-- ----------------------------
-- Table structure for `mp_menu`
-- ----------------------------
DROP TABLE IF EXISTS `mp_menu`;
CREATE TABLE `mp_menu` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `menu` varchar(2000) DEFAULT NULL COMMENT '菜单json数据',
  `app_id` varchar(100) DEFAULT NULL COMMENT 'AppID',
  `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_app_id` (`app_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='公众号自定义菜单';

-- ----------------------------
-- Records of mp_menu
-- ----------------------------

-- ----------------------------
-- 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 ('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 ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', null, 'com.wjp.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018EB6AC3190787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F74000672656E72656E740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F77080000018EB6AC3190787371007E00110ECF9F6107B456017800);

-- ----------------------------
-- 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 ('WjpScheduler', 'STATE_ACCESS');
INSERT INTO `qrtz_locks` VALUES ('WjpScheduler', '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 ('WjpScheduler', 'DESKTOP-KIOOR1712462353322', '1712468647706', '15000');
INSERT INTO `qrtz_scheduler_state` VALUES ('WjpScheduler', 'DESKTOP-KIOOR1712468918453', '1712470293177', '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 ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', 'TASK_1067246875800000076', 'DEFAULT', null, '1712462400000', '-1', '5', 'PAUSED', 'CRON', '1712462367000', '0', null, '2', '');

-- ----------------------------
-- 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', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- 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 '部门名称',
  `leader_id` bigint(20) DEFAULT NULL COMMENT '负责人ID',
  `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', '技术部', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dept` VALUES ('1067246875800000063', '1067246875800000066', '1067246875800000066', '长沙分公司', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dept` VALUES ('1067246875800000064', '1067246875800000066', '1067246875800000066', '上海分公司', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dept` VALUES ('1067246875800000065', '1067246875800000064', '1067246875800000066,1067246875800000064', '市场部', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dept` VALUES ('1067246875800000066', '0', '0', '佳缘科技股份有限公司', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dept` VALUES ('1067246875800000067', '1067246875800000064', '1067246875800000066,1067246875800000064', '销售部', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dept` VALUES ('1067246875800000068', '1067246875800000063', '1067246875800000066,1067246875800000063', '产品部', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- 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', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1160061146967879681', '1160061077912858625', '女', '1', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1160061190127267841', '1160061077912858625', '保密', '2', '', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1225814069634195457', '1225813644059140097', '公告', '0', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1225814107559092225', '1225813644059140097', '会议', '1', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1225814271879340034', '1225813644059140097', '其他', '2', '', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1341593562419445762', '1341593474355838978', '停用', '0', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1341593595407646722', '1341593474355838978', '正常', '1', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1343069765549191170', '1343069688596295682', '已取消', '-1', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1343069839847092226', '1343069688596295682', '等待付款', '0', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_data` VALUES ('1343069914518286337', '1343069688596295682', '已完成', '1', '', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- 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', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_type` VALUES ('1225813644059140097', 'notice_type', '站内通知-类型', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_type` VALUES ('1341593474355838978', 'post_status', '岗位管理状态', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_dict_type` VALUES ('1343069688596295682', 'order_status', '订单状态', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- 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', '1067246875800000021', 'name', 'SMS Service', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000021', 'name', '短信服务', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000021', 'name', '短信服務', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000022', 'name', 'Mail Template', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000022', 'name', '邮件模板', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000022', 'name', '郵件模板', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000023', 'name', 'Mail Log', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000023', 'name', '邮件发送记录', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000023', 'name', '郵件發送記錄', 'zh-TW ');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000024', 'name', 'Message Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000024', 'name', '消息管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000024', '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', '1067246875800000051', 'name', 'SQL Monitoring', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000051', 'name', 'SQL监控', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000051', 'name', 'SQL監控', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000052', 'name', 'News Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000052', 'name', '新闻管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000052', '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', '1067246875800000054', 'name', 'Demo', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000054', 'name', '功能示例', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000054', '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', '1067246875800000303', 'name', 'SMS History', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000303', 'name', '短信发送记录', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000303', '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', '1158267114314842115', 'name', 'Administrative Regions', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842115', 'name', '行政区域', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842115', 'name', '行政區域', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842116', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842116', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842116', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842117', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842117', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842117', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842118', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842118', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842118', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842119', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842119', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842119', 'name', '刪除', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501800', 'name', 'ECharts', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501800', 'name', 'ECharts', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501800', 'name', 'ECharts', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501825', 'name', 'Master And Child', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501825', 'name', '主子表演示', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501825', 'name', '主子表演示', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501826', 'name', 'View', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501826', 'name', '查看', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501826', 'name', '查看', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501827', 'name', 'Add', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501827', 'name', '新增', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501827', 'name', '新增', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501828', 'name', 'Edit', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501828', 'name', '修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501828', 'name', '修改', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501829', 'name', 'Delete', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501829', 'name', '删除', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501829', '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', '1304802103569809411', 'name', 'Project Editor', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809411', 'name', '项目名修改', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809411', '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', '1340949288542347266', 'name', 'Page Design', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1340949288542347266', 'name', '页面表单设计', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1340949288542347266', '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');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341676084016852994', 'name', 'Excel Demo', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341676084016852994', 'name', 'Excel导入演示', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1341676084016852994', 'name', 'Excel導入演示', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074487777677313', 'name', 'Pay Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074487777677313', 'name', '支付管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074487777677313', 'name', '支付管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074685589442561', 'name', 'Order Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074685589442561', 'name', '订单管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074685589442561', 'name', '訂單管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074794440019970', 'name', 'AliPay Log', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074794440019970', 'name', '支付宝回调日志', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1343074794440019970', 'name', '支付寶回調日誌', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419551957005963266', 'name', 'Wechat Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419551957005963266', 'name', '微信管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419551957005963266', 'name', '微信管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419553543706972161', 'name', 'Mp Management', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419553543706972161', 'name', '公众号管理', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419553543706972161', 'name', '公眾號管理', 'zh-TW');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419963799817691137', 'name', 'Custom Menu', 'en-US');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419963799817691137', 'name', '自定义菜单', 'zh-CN');
INSERT INTO `sys_language` VALUES ('sys_menu', '1419963799817691137', '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
-- ----------------------------
INSERT INTO `sys_log_login` VALUES ('1776847691573903362', '0', '1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36', '0:0:0:0:0:0:0:1', 'admin', '1067246875800000001', '2024-04-07 13:41:16');

-- ----------------------------
-- 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_mail_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_mail_log`;
CREATE TABLE `sys_mail_log` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `template_id` bigint(20) NOT NULL COMMENT '邮件模板ID',
  `mail_from` varchar(200) DEFAULT NULL COMMENT '发送者',
  `mail_to` varchar(400) DEFAULT NULL COMMENT '收件人',
  `mail_cc` varchar(400) DEFAULT NULL COMMENT '抄送者',
  `subject` varchar(200) DEFAULT NULL COMMENT '邮件主题',
  `content` text COMMENT '邮件正文',
  `status` tinyint(3) unsigned DEFAULT NULL COMMENT '发送状态  0：失败  1：成功',
  `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_mail_log
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_mail_template`
-- ----------------------------
DROP TABLE IF EXISTS `sys_mail_template`;
CREATE TABLE `sys_mail_template` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `name` varchar(100) DEFAULT NULL COMMENT '模板名称',
  `subject` 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`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮件模板';

-- ----------------------------
-- Records of sys_mail_template
-- ----------------------------
INSERT INTO `sys_mail_template` VALUES ('1067246875800000077', '验证码模板', '注册验证码', '<p>注册验证码：${code}</p>', null, '2024-04-07 11:48:42', null, null);

-- ----------------------------
-- 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', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000003', '1067246875800000055', null, 'sys:user:save,sys:dept:list,sys:role:list', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000004', '1067246875800000055', null, 'sys:user:update,sys:dept:list,sys:role:list', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000005', '1067246875800000055', null, 'sys:user:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000006', '1067246875800000055', null, 'sys:user:export', '1', '0', null, '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000007', '1067246875800000002', 'sys/role', null, '0', '0', 'icon-team', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000008', '1067246875800000007', null, 'sys:role:page,sys:role:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000009', '1067246875800000007', null, 'sys:role:save,sys:menu:select,sys:dept:list', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000010', '1067246875800000007', null, 'sys:role:update,sys:menu:select,sys:dept:list', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000011', '1067246875800000007', null, 'sys:role:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000012', '1067246875800000002', 'sys/dept', null, '0', '0', 'icon-apartment', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000014', '1067246875800000012', null, 'sys:dept:list,sys:dept:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000015', '1067246875800000012', null, 'sys:dept:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000016', '1067246875800000012', null, 'sys:dept:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000017', '1067246875800000012', null, 'sys:dept:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000018', '1150940491508928513', 'flow/bpmform', 'flow:bpmform:all', '0', '0', 'icon-detail', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000019', '1150940491508928513', 'flow/model', 'sys:model:all', '0', '0', 'icon-appstore-fill', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000020', '1150940491508928513', 'flow/running', 'sys:running:all,sys:flow:all', '0', '0', 'icon-play-square', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000021', '1067246875800000024', 'message/sms', 'sys:sms:all', '0', '0', 'icon-message-fill', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000022', '1067246875800000024', 'message/mail_template', 'sys:mail:all', '0', '0', 'icon-mail', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000023', '1067246875800000024', 'message/mail_log', 'sys:mail:log', '0', '0', 'icon-detail-fill', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000024', '0', null, null, '0', '0', 'icon-message', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000025', '1067246875800000035', 'sys/menu', null, '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000026', '1067246875800000025', null, 'sys:menu:list,sys:menu:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000027', '1067246875800000025', null, 'sys:menu:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000028', '1067246875800000025', null, 'sys:menu:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000029', '1067246875800000025', null, 'sys:menu:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000030', '1067246875800000035', 'job/schedule', null, '0', '0', 'icon-dashboard', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000031', '1067246875800000030', null, 'sys:schedule:page,sys:schedule:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000032', '1067246875800000030', null, 'sys:schedule:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000033', '1067246875800000030', null, 'sys:schedule:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000034', '1067246875800000030', null, 'sys:schedule:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000035', '0', null, null, '0', '0', 'icon-setting', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000036', '1067246875800000030', null, 'sys:schedule:pause', '1', '0', null, '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000037', '1067246875800000030', null, 'sys:schedule:resume', '1', '0', null, '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000038', '1067246875800000030', null, 'sys:schedule:run', '1', '0', null, '6', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000039', '1067246875800000030', null, 'sys:schedule:log', '1', '0', null, '7', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000040', '1067246875800000035', 'sys/params', '', '0', '0', 'icon-fileprotect', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000041', '1067246875800000035', 'sys/dict-type', null, '0', '0', 'icon-golden-fill', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000042', '1067246875800000041', null, 'sys:dict:page,sys:dict:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000043', '1067246875800000041', null, 'sys:dict:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000044', '1067246875800000041', null, 'sys:dict:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000045', '1067246875800000041', null, 'sys:dict:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000046', '0', null, null, '0', '0', 'icon-container', '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000047', '1067246875800000035', 'oss/oss', 'sys:oss:all', '0', '0', 'icon-upload', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000048', '1067246875800000046', 'sys/log-login', 'sys:log:login', '0', '0', 'icon-filedone', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000049', '1067246875800000046', 'sys/log-operation', 'sys:log:operation', '0', '0', 'icon-solution', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000050', '1067246875800000046', 'sys/log-error', 'sys:log:error', '0', '0', 'icon-file-exception', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000051', '1067246875800000053', '{{ApiUrl}}/druid/sql.html', null, '0', '0', 'icon-database', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000052', '1067246875800000054', 'demo/news', 'demo:news:all', '0', '0', 'icon-file-word', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000053', '0', null, null, '0', '0', 'icon-desktop', '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000054', '0', null, null, '0', '0', 'icon-windows', '6', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000055', '1067246875800000002', 'sys/user', null, '0', '0', 'icon-user', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000056', '1067246875800000055', null, 'sys:user:page,sys:user:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000057', '1067246875800000040', null, 'sys:params:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000058', '1067246875800000040', null, 'sys:params:export', '1', '0', null, '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000059', '1067246875800000040', '', 'sys:params:page,sys:params:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000060', '1067246875800000040', null, 'sys:params:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000061', '1067246875800000040', '', 'sys:params:delete', '1', '0', '', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000300', '0', null, null, '0', '0', 'icon-bell', '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000301', '1067246875800000300', 'notice/notice', 'sys:notice:all', '0', '0', 'icon-bell', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000302', '1067246875800000300', 'notice/notice-user', 'sys:notice:all', '0', '0', 'icon-notification', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1067246875800000303', '1067246875800000024', 'message/sms-log', 'sys:smslog:all', '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1150940491508928513', '0', null, null, '0', '0', 'icon-reloadtime', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1150941310262235138', '0', null, null, '0', '0', 'icon-user', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1150941384811794433', '1150941310262235138', 'flow/todo', 'sys:flow:all,sys:user:page', '0', '0', 'icon-dashboard', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1150941447038488577', '1150941310262235138', 'flow/done', 'sys:flow:all', '0', '0', 'icon-check-square', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1150941506626965506', '1150941310262235138', 'flow/start', 'sys:flow:all', '0', '0', 'icon-play-square', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1150941588046794754', '1150941310262235138', 'flow/my-send', 'sys:flow:all', '0', '0', 'icon-edit-square', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1156748733921165314', '1067246875800000053', '{{ApiUrl}}/doc.html', '', '0', '1', 'icon-file-word', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1158267114314842115', '1067246875800000035', 'sys/region', null, '0', '0', 'icon-location', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1158267114314842116', '1158267114314842115', null, 'sys:region:list,sys:region:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1158267114314842117', '1158267114314842115', null, 'sys:region:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1158267114314842118', '1158267114314842115', null, 'sys:region:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1158267114314842119', '1158267114314842115', null, 'sys:region:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1270380959719501800', '1067246875800000054', 'demo/charts', null, '0', '0', 'icon-tag', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1270380959719501825', '1067246875800000054', 'demo/product', null, '0', '0', 'icon-tag', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1270380959719501826', '1270380959719501825', null, 'demo:product:page,demo:product:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1270380959719501827', '1270380959719501825', null, 'demo:product:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1270380959719501828', '1270380959719501825', null, 'demo:product:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1270380959719501829', '1270380959719501825', null, 'demo:product:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1300278047072649217', '0', '', '', '0', '0', 'icon-filesearch', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1300278435729440769', '1300278047072649217', '{{ApiUrl}}/ureport/designer', '', '0', '0', 'icon-book', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1300381796852060161', '1300278047072649217', 'ureport/ureport', 'sys:ureport:all', '0', '0', 'icon-up-circle', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1302850622416084993', '0', '', '', '0', '0', 'icon-rocket', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1302850783288614913', '1305532398162145281', 'devtools/datasource', '', '0', '0', 'icon-sync', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1302862890696564738', '1305532398162145281', 'devtools/fieldtype', '', '0', '0', 'icon-eye', '1', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1302874751835848705', '1305532398162145281', 'devtools/baseclass', '', '0', '0', 'icon-info-circle', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1304081184014635010', '1305532398162145281', 'devtools/template', '', '0', '0', 'icon-up-circle', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1304802103569809410', '1302850622416084993', 'devtools/generator', '', '0', '0', 'icon-tags', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1304802103569809411', '1302850622416084993', 'devtools/project', '', '0', '0', 'icon-tags', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1305513187675144193', '1305532398162145281', 'devtools/param', '', '0', '0', 'icon-setting', '5', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1305532398162145281', '1302850622416084993', '', '', '0', '0', 'icon-setting', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1340949288542347266', '1302850622416084993', 'form-generator/form', '', '0', '0', 'icon-edit-square', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
INSERT INTO `sys_menu` VALUES ('1341596622612987906', '1067246875800000002', 'sys/post', null, '0', '0', 'icon-pic-left', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1341596622688485377', '1341596622612987906', null, 'sys:post:page,sys:post:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1341596622755594242', '1341596622612987906', null, 'sys:post:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1341596622835286018', '1341596622612987906', null, 'sys:post:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1341596622902394881', '1341596622612987906', null, 'sys:post:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1341659662599495681', '1067246875800000053', 'sys/online', 'sys:online:all', '0', '0', 'icon-team', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1341676084016852994', '1067246875800000054', 'demo/excel', 'demo:excel:all', '0', '0', 'icon-table', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1343074487777677313', '0', '', '', '0', '0', 'icon-Dollar', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1343074685589442561', '1343074487777677313', 'pay/order', 'pay:order:all', '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1343074794440019970', '1343074487777677313', 'pay/alipaynotifylog', 'pay:alipayNotifyLog:all', '0', '0', 'icon-filedone', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1419551957005963266', '0', '', '', '0', '0', 'icon-wechat-fill', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1419553543706972161', '1419551957005963266', 'mp/account', 'mp:account:all', '0', '0', 'icon-user', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_menu` VALUES ('1419963799817691137', '1419551957005963266', 'mp/menu', 'mp:menu:all', '0', '0', 'icon-unorderedlist', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- 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\":\"3.0\",\"author\":\"Toby\",\"email\":\"javatangbin@163.com\",\"backendPath\":\"D:\\\\code\\\\wjp-project\\\\wjp-admin\",\"frontendPath\":\"D:\\\\code\\\\wjp-project-admin\"}', '0', '代码生成器配置信息', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42');
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', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_params` VALUES ('1067246875800000075', 'MAIL_CONFIG_KEY', '{\"smtp\":\"smtp.163.com\",\"port\":25,\"username\":\"wjp_test@163.com\",\"password\":\"wjp123456\"}', '0', '邮件配置信息', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- 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
-- ----------------------------
INSERT INTO `sys_post` VALUES ('1341597192832811009', 'tech', '技术岗', '0', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- Table structure for `sys_region`
-- ----------------------------
DROP TABLE IF EXISTS `sys_region`;
CREATE TABLE `sys_region` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级为0',
  `name` varchar(100) DEFAULT NULL COMMENT '名称',
  `tree_level` tinyint(4) DEFAULT NULL COMMENT '层级',
  `leaf` tinyint(4) DEFAULT NULL COMMENT '是否叶子节点  0：否   1：是',
  `sort` bigint(20) 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 sys_region
-- ----------------------------

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

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

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

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

-- ----------------------------
-- Table structure for `sys_sms`
-- ----------------------------
DROP TABLE IF EXISTS `sys_sms`;
CREATE TABLE `sys_sms` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `sms_code` varchar(32) DEFAULT NULL COMMENT '短信编码',
  `platform` tinyint(3) unsigned NOT NULL COMMENT '平台类型',
  `sms_config` varchar(2000) DEFAULT NULL COMMENT '短信配置',
  `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_sms_code` (`sms_code`),
  KEY `idx_create_date` (`create_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='短信';

-- ----------------------------
-- Records of sys_sms
-- ----------------------------
INSERT INTO `sys_sms` VALUES ('1228954061084676097', '1001', '1', '{\"aliyunAccessKeyId\":\"1\",\"aliyunAccessKeySecret\":\"1\",\"aliyunSignName\":\"1\",\"aliyunTemplateCode\":\"1\",\"qcloudAppKey\":\"\",\"qcloudSignName\":\"\",\"qcloudTemplateId\":\"\",\"qiniuAccessKey\":\"\",\"qiniuSecretKey\":\"\",\"qiniuTemplateId\":\"\"}', '', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- Table structure for `sys_sms_log`
-- ----------------------------
DROP TABLE IF EXISTS `sys_sms_log`;
CREATE TABLE `sys_sms_log` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `sms_code` varchar(32) DEFAULT NULL COMMENT '短信编码',
  `platform` tinyint(3) unsigned NOT NULL COMMENT '平台类型',
  `mobile` varchar(20) DEFAULT NULL COMMENT '手机号',
  `params_1` varchar(50) DEFAULT NULL COMMENT '参数1',
  `params_2` varchar(50) DEFAULT NULL COMMENT '参数2',
  `params_3` varchar(50) DEFAULT NULL COMMENT '参数3',
  `params_4` varchar(50) DEFAULT NULL COMMENT '参数4',
  `status` tinyint(3) unsigned DEFAULT NULL COMMENT '发送状态  0：失败  1：成功',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_sms_code` (`sms_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='短信日志';

-- ----------------------------
-- Records of sys_sms_log
-- ----------------------------

-- ----------------------------
-- Table structure for `sys_ureport_data`
-- ----------------------------
DROP TABLE IF EXISTS `sys_ureport_data`;
CREATE TABLE `sys_ureport_data` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `file_name` varchar(200) DEFAULT NULL COMMENT '报表文件名',
  `content` mediumblob COMMENT '内容',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  `update_date` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='报表数据';

-- ----------------------------
-- Records of sys_ureport_data
-- ----------------------------

-- ----------------------------
-- 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@scjydz.com', '13612345678', null, '1', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');
INSERT INTO `sys_user` VALUES ('1353943117220315138', 'test', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '测试用户', null, '0', 'test@scjydz.com', '13012345678', '1067246875800000066', '0', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- 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 ('1776847691678760961', '1067246875800000001', '35225a2a8b88b3ff2e4061f535fe8fb1', '2024-04-08 01:41:17', '2024-04-07 13:41:17', '2024-04-07 13:41:17');

-- ----------------------------
-- Table structure for `tb_alipay_notify_log`
-- ----------------------------
DROP TABLE IF EXISTS `tb_alipay_notify_log`;
CREATE TABLE `tb_alipay_notify_log` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `out_trade_no` bigint(20) DEFAULT NULL COMMENT '订单号',
  `total_amount` decimal(10,2) DEFAULT NULL COMMENT '订单金额',
  `buyer_pay_amount` decimal(10,2) DEFAULT NULL COMMENT '付款金额',
  `receipt_amount` decimal(10,2) DEFAULT NULL COMMENT '实收金额',
  `invoice_amount` decimal(10,2) DEFAULT NULL COMMENT '开票金额',
  `notify_id` varchar(50) DEFAULT NULL COMMENT '通知校验ID',
  `buyer_id` varchar(50) DEFAULT NULL COMMENT '买家支付宝用户号',
  `seller_id` varchar(50) DEFAULT NULL COMMENT '卖家支付宝用户号',
  `trade_no` varchar(50) DEFAULT NULL COMMENT '支付宝交易号',
  `trade_status` varchar(50) DEFAULT NULL COMMENT '交易状态',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付宝回调日志';

-- ----------------------------
-- Records of tb_alipay_notify_log
-- ----------------------------
INSERT INTO `tb_alipay_notify_log` VALUES ('1343493644518195201', '1343491774781419523', '3600.00', '3600.00', '3600.00', '3600.00', '2020122800222174658006930510128003', '2088102177806934', '2088102177441441', '2020122822001406930501194003', 'TRADE_SUCCESS', '2024-04-07 11:48:42');

-- ----------------------------
-- Table structure for `tb_excel_data`
-- ----------------------------
DROP TABLE IF EXISTS `tb_excel_data`;
CREATE TABLE `tb_excel_data` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `real_name` varchar(100) DEFAULT NULL COMMENT '学生姓名',
  `user_identity` varchar(100) DEFAULT NULL COMMENT '身份证',
  `address` varchar(200) DEFAULT NULL COMMENT '家庭地址',
  `join_date` datetime DEFAULT NULL COMMENT '入学日期',
  `class_name` varchar(100) DEFAULT NULL COMMENT '班级名称',
  `creator` bigint(20) DEFAULT NULL COMMENT '创建者',
  `create_date` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Excel导入演示';

-- ----------------------------
-- Records of tb_excel_data
-- ----------------------------
INSERT INTO `tb_excel_data` VALUES ('1343762012112445441', '大力', '430212199910102980', '上海市长宁区中山公园', '2024-04-07 11:48:42', '姚班2101', '1067246875800000001', '2024-04-07 11:48:42');

-- ----------------------------
-- Table structure for `tb_news`
-- ----------------------------
DROP TABLE IF EXISTS `tb_news`;
CREATE TABLE `tb_news` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `title` varchar(100) NOT NULL COMMENT '标题',
  `content` mediumtext NOT NULL COMMENT '内容',
  `pub_date` datetime DEFAULT NULL COMMENT '发布时间',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '创建者dept_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='新闻管理';

-- ----------------------------
-- Records of tb_news
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_order`
-- ----------------------------
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `order_id` bigint(20) DEFAULT NULL COMMENT '订单ID',
  `product_id` bigint(20) NOT NULL COMMENT '产品ID',
  `product_name` varchar(100) DEFAULT NULL COMMENT '产品名称',
  `pay_amount` decimal(10,2) NOT NULL COMMENT '支付金额',
  `status` tinyint(4) DEFAULT NULL COMMENT '订单状态  -1：已取消   0：等待付款   1：已完成',
  `user_id` bigint(20) DEFAULT NULL COMMENT '购买用户ID',
  `pay_at` datetime DEFAULT NULL COMMENT '支付时间',
  `create_date` datetime DEFAULT NULL COMMENT '下单时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_order_id` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单';

-- ----------------------------
-- Table structure for `tb_product`
-- ----------------------------
DROP TABLE IF EXISTS `tb_product`;
CREATE TABLE `tb_product` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `name` varchar(100) NOT NULL COMMENT '产品名称',
  `content` mediumtext NOT 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 tb_product
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_product_params`
-- ----------------------------
DROP TABLE IF EXISTS `tb_product_params`;
CREATE TABLE `tb_product_params` (
  `id` bigint(20) NOT NULL COMMENT 'id',
  `param_name` varchar(100) DEFAULT NULL COMMENT '参数名',
  `param_value` varchar(200) DEFAULT NULL COMMENT '参数值',
  `product_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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品参数管理';

-- ----------------------------
-- Records of tb_product_params
-- ----------------------------

-- ----------------------------
-- 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', 'toby', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2024-04-07 11:51:15');