/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50732 Source Host : localhost:3306 Source Database : wjp_project40 Target Server Type : MYSQL Target Server Version : 50732 File Encoding : 65001 Date: 2023-08-09 17:32:16 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `act_evt_log` -- ---------------------------- DROP TABLE IF EXISTS `act_evt_log`; CREATE TABLE `act_evt_log` ( `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DATA_` longblob, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `IS_PROCESSED_` tinyint(4) DEFAULT '0', PRIMARY KEY (`LOG_NR_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_evt_log -- ---------------------------- -- ---------------------------- -- Table structure for `act_ge_bytearray` -- ---------------------------- DROP TABLE IF EXISTS `act_ge_bytearray`; CREATE TABLE `act_ge_bytearray` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `BYTES_` longblob, `GENERATED_` tinyint(4) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`), CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ge_bytearray -- ---------------------------- -- ---------------------------- -- Table structure for `act_ge_property` -- ---------------------------- DROP TABLE IF EXISTS `act_ge_property`; CREATE TABLE `act_ge_property` ( `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, PRIMARY KEY (`NAME_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ge_property -- ---------------------------- INSERT INTO `act_ge_property` VALUES ('batch.schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('cfg.execution-related-entities-count', 'true', '1'); INSERT INTO `act_ge_property` VALUES ('cfg.task-related-entities-count', 'true', '1'); INSERT INTO `act_ge_property` VALUES ('common.schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('entitylink.schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('eventsubscription.schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('identitylink.schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('job.schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', '1'); INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(6.8.0.0)', '1'); INSERT INTO `act_ge_property` VALUES ('schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('task.schema.version', '6.8.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('variable.schema.version', '6.8.0.0', '1'); -- ---------------------------- -- Table structure for `act_hi_actinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_actinst`; CREATE TABLE `act_hi_actinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `TRANSACTION_ORDER_` int(11) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`), KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`), KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`), KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_actinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_attachment` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_attachment`; CREATE TABLE `act_hi_attachment` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_attachment -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_comment` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_comment`; CREATE TABLE `act_hi_comment` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TIME_` datetime(3) NOT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `FULL_MSG_` longblob, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_comment -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_detail` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_detail`; CREATE TABLE `act_hi_detail` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, `TIME_` datetime(3) NOT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`), KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`), KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`), KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_detail -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_entitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_entitylink`; CREATE TABLE `act_hi_entitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`,`ROOT_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_entitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_identitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_identitylink`; CREATE TABLE `act_hi_identitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`), KEY `ACT_IDX_HI_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`), KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_identitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_procinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_procinst`; CREATE TABLE `act_hi_procinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BUSINESS_STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`), KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`), KEY `ACT_IDX_HI_PRO_SUPER_PROCINST` (`SUPER_PROCESS_INSTANCE_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_procinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_taskinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_taskinst`; CREATE TABLE `act_hi_taskinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `CLAIM_TIME_` datetime(3) DEFAULT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `PRIORITY_` int(11) DEFAULT NULL, `DUE_DATE_` datetime(3) DEFAULT NULL, `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_taskinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_tsk_log` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_tsk_log`; CREATE TABLE `act_hi_tsk_log` ( `ID_` bigint(20) NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DATA_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_tsk_log -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_varinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_varinst`; CREATE TABLE `act_hi_varinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`), KEY `ACT_IDX_HI_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`), KEY `ACT_IDX_HI_PROCVAR_EXE` (`EXECUTION_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_varinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_bytearray` -- ---------------------------- DROP TABLE IF EXISTS `act_id_bytearray`; CREATE TABLE `act_id_bytearray` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTES_` longblob, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_bytearray -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_group` -- ---------------------------- DROP TABLE IF EXISTS `act_id_group`; CREATE TABLE `act_id_group` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_group -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_info` -- ---------------------------- DROP TABLE IF EXISTS `act_id_info`; CREATE TABLE `act_id_info` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PASSWORD_` longblob, `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_info -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_membership` -- ---------------------------- DROP TABLE IF EXISTS `act_id_membership`; CREATE TABLE `act_id_membership` ( `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`USER_ID_`,`GROUP_ID_`), KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`), CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`), CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_membership -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_priv` -- ---------------------------- DROP TABLE IF EXISTS `act_id_priv`; CREATE TABLE `act_id_priv` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_PRIV_NAME` (`NAME_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_priv -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_priv_mapping` -- ---------------------------- DROP TABLE IF EXISTS `act_id_priv_mapping`; CREATE TABLE `act_id_priv_mapping` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PRIV_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_FK_PRIV_MAPPING` (`PRIV_ID_`), KEY `ACT_IDX_PRIV_USER` (`USER_ID_`), KEY `ACT_IDX_PRIV_GROUP` (`GROUP_ID_`), CONSTRAINT `ACT_FK_PRIV_MAPPING` FOREIGN KEY (`PRIV_ID_`) REFERENCES `act_id_priv` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_priv_mapping -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_property` -- ---------------------------- DROP TABLE IF EXISTS `act_id_property`; CREATE TABLE `act_id_property` ( `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, PRIMARY KEY (`NAME_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_property -- ---------------------------- INSERT INTO `act_id_property` VALUES ('schema.version', '6.8.0.0', '1'); -- ---------------------------- -- Table structure for `act_id_token` -- ---------------------------- DROP TABLE IF EXISTS `act_id_token`; CREATE TABLE `act_id_token` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TOKEN_VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TOKEN_DATE_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), `IP_ADDRESS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_AGENT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TOKEN_DATA_` varchar(2000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_token -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_user` -- ---------------------------- DROP TABLE IF EXISTS `act_id_user`; CREATE TABLE `act_id_user` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DISPLAY_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_user -- ---------------------------- -- ---------------------------- -- Table structure for `act_procdef_info` -- ---------------------------- DROP TABLE IF EXISTS `act_procdef_info`; CREATE TABLE `act_procdef_info` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`), KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`), KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`), CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_procdef_info -- ---------------------------- -- ---------------------------- -- Table structure for `act_re_deployment` -- ---------------------------- DROP TABLE IF EXISTS `act_re_deployment`; CREATE TABLE `act_re_deployment` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL, `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PARENT_DEPLOYMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_re_deployment -- ---------------------------- -- ---------------------------- -- Table structure for `act_re_model` -- ---------------------------- DROP TABLE IF EXISTS `act_re_model`; CREATE TABLE `act_re_model` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`), KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`), KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`), CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`), CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_re_model -- ---------------------------- -- ---------------------------- -- Table structure for `act_re_procdef` -- ---------------------------- DROP TABLE IF EXISTS `act_re_procdef`; CREATE TABLE `act_re_procdef` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin NOT NULL, `VERSION_` int(11) NOT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL, `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_VERSION_` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`DERIVED_VERSION_`,`TENANT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_re_procdef -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_actinst` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_actinst`; CREATE TABLE `act_ru_actinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `TRANSACTION_ORDER_` int(11) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_RU_ACTI_START` (`START_TIME_`), KEY `ACT_IDX_RU_ACTI_END` (`END_TIME_`), KEY `ACT_IDX_RU_ACTI_PROC` (`PROC_INST_ID_`), KEY `ACT_IDX_RU_ACTI_PROC_ACT` (`PROC_INST_ID_`,`ACT_ID_`), KEY `ACT_IDX_RU_ACTI_EXEC` (`EXECUTION_ID_`), KEY `ACT_IDX_RU_ACTI_EXEC_ACT` (`EXECUTION_ID_`,`ACT_ID_`), KEY `ACT_IDX_RU_ACTI_TASK` (`TASK_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_actinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_deadletter_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_deadletter_job`; CREATE TABLE `act_ru_deadletter_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_DEADLETTER_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_DJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_DJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_DJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_deadletter_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_entitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_entitylink`; CREATE TABLE `act_ru_entitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`,`ROOT_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_entitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_event_subscr` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_event_subscr`; CREATE TABLE `act_ru_event_subscr` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`), KEY `ACT_IDX_EVENT_SUBSCR_SCOPEREF_` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`), CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_event_subscr -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_execution` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_execution`; CREATE TABLE `act_ru_execution` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ROOT_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `IS_ACTIVE_` tinyint(4) DEFAULT NULL, `IS_CONCURRENT_` tinyint(4) DEFAULT NULL, `IS_SCOPE_` tinyint(4) DEFAULT NULL, `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL, `IS_MI_ROOT_` tinyint(4) DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `CACHED_ENT_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) DEFAULT NULL, `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL, `EVT_SUBSCR_COUNT_` int(11) DEFAULT NULL, `TASK_COUNT_` int(11) DEFAULT NULL, `JOB_COUNT_` int(11) DEFAULT NULL, `TIMER_JOB_COUNT_` int(11) DEFAULT NULL, `SUSP_JOB_COUNT_` int(11) DEFAULT NULL, `DEADLETTER_JOB_COUNT_` int(11) DEFAULT NULL, `EXTERNAL_WORKER_JOB_COUNT_` int(11) DEFAULT NULL, `VAR_COUNT_` int(11) DEFAULT NULL, `ID_LINK_COUNT_` int(11) DEFAULT NULL, `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BUSINESS_STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`), KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`), KEY `ACT_IDX_EXEC_REF_ID_` (`REFERENCE_ID_`), KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`), KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`), KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`), KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE, CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`), CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_execution -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_external_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_external_job`; CREATE TABLE `act_ru_external_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_EXTERNAL_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_EXTERNAL_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_EXTERNAL_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_EJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_EJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_EJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), CONSTRAINT `ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_EXTERNAL_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_external_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_history_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_history_job`; CREATE TABLE `act_ru_history_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ADV_HANDLER_CFG_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_history_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_identitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_identitylink`; CREATE TABLE `act_ru_identitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`), KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`), KEY `ACT_IDX_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`), KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`), KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`), CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`), CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_identitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_job`; CREATE TABLE `act_ru_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_JOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_JOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_JOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_suspended_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_suspended_job`; CREATE TABLE `act_ru_suspended_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_SUSPENDED_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_SJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_SJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_SJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_suspended_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_task` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_task`; CREATE TABLE `act_ru_task` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PRIORITY_` int(11) DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `DUE_DATE_` datetime(3) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CLAIM_TIME_` datetime(3) DEFAULT NULL, `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL, `VAR_COUNT_` int(11) DEFAULT NULL, `ID_LINK_COUNT_` int(11) DEFAULT NULL, `SUB_TASK_COUNT_` int(11) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`), KEY `ACT_IDX_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`), KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`), KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`), CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_task -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_timer_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_timer_job`; CREATE TABLE `act_ru_timer_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_TIMER_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_TIMER_JOB_DUEDATE` (`DUEDATE_`), KEY `ACT_IDX_TJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_timer_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_variable` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_variable`; CREATE TABLE `act_ru_variable` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_RU_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_RU_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`), KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`), KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`), KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`), CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_variable -- ---------------------------- -- ---------------------------- -- Table structure for `bpm_definition_ext` -- ---------------------------- DROP TABLE IF EXISTS `bpm_definition_ext`; CREATE TABLE `bpm_definition_ext` ( `id` bigint(20) NOT NULL COMMENT 'id', `model_id` varchar(64) DEFAULT NULL COMMENT '模型ID', `process_definition_id` varchar(64) DEFAULT NULL COMMENT '流程定义ID', `form_id` bigint(20) DEFAULT NULL COMMENT '表单ID', `form_content` text COMMENT '表单内容', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程定义扩展'; -- ---------------------------- -- Records of bpm_definition_ext -- ---------------------------- INSERT INTO `bpm_definition_ext` VALUES ('1689184233819238401', '690b77f5-368a-11ee-975a-9829a668307d', 'process_1691567671516:1:7537774a-368a-11ee-975a-9829a668307d', '1689183281775144962', '{\"widgetList\":[{\"type\":\"static-text\",\"icon\":\"static-text\",\"formItemFlag\":false,\"options\":{\"name\":\"statictext111193\",\"columnWidth\":\"200px\",\"hidden\":false,\"textContent\":\"分组表单\",\"customClass\":[],\"onCreated\":\"\",\"onMounted\":\"\",\"label\":\"static-text\"},\"id\":\"statictext111193\"},{\"type\":\"divider\",\"icon\":\"divider\",\"formItemFlag\":false,\"options\":{\"name\":\"divider102346\",\"label\":\"\",\"columnWidth\":\"200px\",\"direction\":\"horizontal\",\"contentPosition\":\"center\",\"hidden\":true,\"customClass\":[],\"onCreated\":\"\",\"onMounted\":\"\"},\"id\":\"divider102346\"},{\"type\":\"card\",\"category\":\"container\",\"icon\":\"card\",\"widgetList\":[{\"type\":\"grid\",\"category\":\"container\",\"icon\":\"grid\",\"cols\":[{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input12931\",\"label\":\"发件人姓名\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":[],\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input12931\"}],\"options\":{\"name\":\"gridCol25469\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-25469\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input23031\",\"label\":\"发件人号码\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input23031\"}],\"options\":{\"name\":\"gridCol25125\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-25125\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"switch\",\"icon\":\"switch-field\",\"formItemFlag\":true,\"options\":{\"name\":\"switch96070\",\"label\":\"是否保密\",\"labelAlign\":\"\",\"defaultValue\":true,\"columnWidth\":\"200px\",\"labelWidth\":null,\"labelHidden\":false,\"disabled\":false,\"hidden\":false,\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"switchWidth\":40,\"activeText\":\"\",\"inactiveText\":\"\",\"activeColor\":null,\"inactiveColor\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onValidate\":\"\"},\"id\":\"switch96070\"}],\"options\":{\"name\":\"gridCol38707\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-38707\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"textarea\",\"icon\":\"textarea-field\",\"formItemFlag\":true,\"options\":{\"name\":\"textarea21654\",\"label\":\"发件人地址\",\"labelAlign\":\"\",\"rows\":3,\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"textarea21654\"}],\"options\":{\"name\":\"gridCol36174\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-36174\"}],\"options\":{\"name\":\"grid35834\",\"hidden\":false,\"gutter\":12,\"customClass\":\"\"},\"id\":\"grid35834\"}],\"options\":{\"name\":\"card27350\",\"label\":\"发件信息\",\"hidden\":false,\"folded\":false,\"showFold\":true,\"cardWidth\":\"100%\",\"shadow\":\"never\",\"customClass\":\"\"},\"id\":\"card27350\"},{\"type\":\"divider\",\"icon\":\"divider\",\"formItemFlag\":false,\"options\":{\"name\":\"divider69240\",\"label\":\"\",\"columnWidth\":\"200px\",\"direction\":\"horizontal\",\"contentPosition\":\"center\",\"hidden\":true,\"customClass\":\"\",\"onCreated\":\"\",\"onMounted\":\"\"},\"id\":\"divider69240\"},{\"type\":\"card\",\"category\":\"container\",\"icon\":\"card\",\"widgetList\":[{\"type\":\"grid\",\"category\":\"container\",\"icon\":\"grid\",\"cols\":[{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input113152\",\"label\":\"收件人姓名\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":[],\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input113152\"}],\"options\":{\"name\":\"gridCol47242\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-47242\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input40240\",\"label\":\"收件人号码\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input40240\"}],\"options\":{\"name\":\"gridCol27970\",\"hidden\":false,\"span\":12,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-27970\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"checkbox\",\"icon\":\"checkbox-field\",\"formItemFlag\":true,\"options\":{\"name\":\"checkbox63174\",\"label\":\"接收时间段\",\"labelAlign\":\"\",\"defaultValue\":[],\"columnWidth\":\"200px\",\"size\":\"\",\"displayStyle\":\"inline\",\"buttonStyle\":false,\"border\":false,\"labelWidth\":null,\"labelHidden\":false,\"disabled\":false,\"hidden\":false,\"optionItems\":[{\"label\":\"上午9:00 - 11:30\",\"value\":1},{\"label\":\"下午12:30 - 18:00\",\"value\":2},{\"label\":\"晚上18:00 - 21:00\",\"value\":3}],\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onValidate\":\"\"},\"id\":\"checkbox63174\"}],\"options\":{\"name\":\"gridCol93630\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-93630\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"input\",\"icon\":\"text-field\",\"formItemFlag\":true,\"options\":{\"name\":\"input78584\",\"label\":\"收件人地址\",\"labelAlign\":\"\",\"type\":\"text\",\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"showPassword\":false,\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"prefixIcon\":\"\",\"suffixIcon\":\"\",\"appendButton\":false,\"appendButtonDisabled\":false,\"buttonIcon\":\"el-icon-search\",\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"input78584\"}],\"options\":{\"name\":\"gridCol65188\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-65188\"}],\"options\":{\"name\":\"grid114672\",\"hidden\":false,\"gutter\":12,\"customClass\":\"\"},\"id\":\"grid114672\"}],\"options\":{\"name\":\"card111229\",\"label\":\"收件信息\",\"hidden\":false,\"folded\":false,\"showFold\":true,\"cardWidth\":\"100%\",\"shadow\":\"never\",\"customClass\":\"\"},\"id\":\"card111229\"},{\"type\":\"divider\",\"icon\":\"divider\",\"formItemFlag\":false,\"options\":{\"name\":\"divider75887\",\"label\":\"\",\"columnWidth\":\"200px\",\"direction\":\"horizontal\",\"contentPosition\":\"center\",\"hidden\":true,\"customClass\":[],\"onCreated\":\"\",\"onMounted\":\"\"},\"id\":\"divider75887\"},{\"type\":\"card\",\"category\":\"container\",\"icon\":\"card\",\"widgetList\":[{\"type\":\"grid\",\"category\":\"container\",\"icon\":\"grid\",\"cols\":[{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"time-range\",\"icon\":\"time-range-field\",\"formItemFlag\":true,\"options\":{\"name\":\"timerange47503\",\"label\":\"送货时间\",\"labelAlign\":\"\",\"defaultValue\":null,\"startPlaceholder\":\"\",\"endPlaceholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"clearable\":true,\"editable\":false,\"format\":\"HH:mm:ss\",\"required\":true,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"timerange47503\"}],\"options\":{\"name\":\"gridCol109912\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-109912\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"slider\",\"icon\":\"slider-field\",\"formItemFlag\":true,\"options\":{\"name\":\"slider54714\",\"label\":\"价格保护\",\"labelAlign\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"disabled\":false,\"hidden\":false,\"required\":false,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":[],\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"min\":0,\"max\":100,\"step\":10,\"range\":false,\"height\":null,\"onCreated\":\"\",\"onMounted\":\"\",\"onChange\":\"\",\"onValidate\":\"\",\"showStops\":true},\"id\":\"slider54714\"}],\"options\":{\"name\":\"gridCol114653\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-114653\"},{\"type\":\"grid-col\",\"category\":\"container\",\"icon\":\"grid-col\",\"internal\":true,\"widgetList\":[{\"type\":\"textarea\",\"icon\":\"textarea-field\",\"formItemFlag\":true,\"options\":{\"name\":\"textarea64794\",\"label\":\"其他信息\",\"labelAlign\":\"\",\"rows\":3,\"defaultValue\":\"\",\"placeholder\":\"\",\"columnWidth\":\"200px\",\"size\":\"\",\"labelWidth\":null,\"labelHidden\":false,\"readonly\":false,\"disabled\":false,\"hidden\":false,\"required\":false,\"validation\":\"\",\"validationHint\":\"\",\"customClass\":\"\",\"labelIconClass\":null,\"labelIconPosition\":\"rear\",\"labelTooltip\":null,\"minLength\":null,\"maxLength\":null,\"showWordLimit\":false,\"onCreated\":\"\",\"onMounted\":\"\",\"onInput\":\"\",\"onChange\":\"\",\"onFocus\":\"\",\"onBlur\":\"\",\"onValidate\":\"\"},\"id\":\"textarea64794\"}],\"options\":{\"name\":\"gridCol80867\",\"hidden\":false,\"span\":24,\"offset\":0,\"push\":0,\"pull\":0,\"responsive\":false,\"md\":12,\"sm\":12,\"xs\":12,\"customClass\":\"\"},\"id\":\"grid-col-80867\"}],\"options\":{\"name\":\"grid28709\",\"hidden\":false,\"gutter\":12,\"customClass\":\"\"},\"id\":\"grid28709\"}],\"options\":{\"name\":\"card106066\",\"label\":\"补充信息\",\"hidden\":false,\"folded\":false,\"showFold\":true,\"cardWidth\":\"100%\",\"shadow\":\"never\",\"customClass\":\"\"},\"id\":\"card106066\"}],\"formConfig\":{\"modelName\":\"formData\",\"refName\":\"vForm\",\"rulesName\":\"rules\",\"labelWidth\":150,\"labelPosition\":\"left\",\"size\":\"\",\"labelAlign\":\"label-right-align\",\"cssCode\":\"\",\"customClass\":[],\"functions\":\"\",\"layoutType\":\"PC\",\"jsonVersion\":3,\"onFormCreated\":\"\",\"onFormMounted\":\"\",\"onFormDataChange\":\"\",\"onFormValidate\":\"\"}}', '1067246875800000001', '2023-08-09 15:58:00', '1067246875800000001', '2023-08-09 15:58:00'); -- ---------------------------- -- Table structure for `bpm_form` -- ---------------------------- DROP TABLE IF EXISTS `bpm_form`; CREATE TABLE `bpm_form` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(50) DEFAULT NULL COMMENT '名称', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `content` text COMMENT '表单内容', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程表单'; -- ---------------------------- -- Records of bpm_form -- ---------------------------- -- ---------------------------- -- Table structure for `bpm_instance_ext` -- ---------------------------- DROP TABLE IF EXISTS `bpm_instance_ext`; CREATE TABLE `bpm_instance_ext` ( `id` bigint(20) NOT NULL COMMENT 'id', `process_instance_id` varchar(64) DEFAULT NULL COMMENT '流程实例ID', `process_definition_id` varchar(64) DEFAULT NULL COMMENT '流程定义ID', `form_variables` varchar(4000) DEFAULT NULL COMMENT '表单值', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程实例扩展'; -- ---------------------------- -- Records of bpm_instance_ext -- ---------------------------- -- ---------------------------- -- Table structure for `flw_channel_definition` -- ---------------------------- DROP TABLE IF EXISTS `flw_channel_definition`; CREATE TABLE `flw_channel_definition` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `KEY_` varchar(255) DEFAULT NULL, `CATEGORY_` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `TENANT_ID_` varchar(255) DEFAULT NULL, `RESOURCE_NAME_` varchar(255) DEFAULT NULL, `DESCRIPTION_` varchar(255) DEFAULT NULL, `TYPE_` varchar(255) DEFAULT NULL, `IMPLEMENTATION_` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_IDX_CHANNEL_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_channel_definition -- ---------------------------- -- ---------------------------- -- Table structure for `flw_event_definition` -- ---------------------------- DROP TABLE IF EXISTS `flw_event_definition`; CREATE TABLE `flw_event_definition` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `KEY_` varchar(255) DEFAULT NULL, `CATEGORY_` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, `TENANT_ID_` varchar(255) DEFAULT NULL, `RESOURCE_NAME_` varchar(255) DEFAULT NULL, `DESCRIPTION_` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_IDX_EVENT_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_event_definition -- ---------------------------- -- ---------------------------- -- Table structure for `flw_event_deployment` -- ---------------------------- DROP TABLE IF EXISTS `flw_event_deployment`; CREATE TABLE `flw_event_deployment` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `CATEGORY_` varchar(255) DEFAULT NULL, `DEPLOY_TIME_` datetime(3) DEFAULT NULL, `TENANT_ID_` varchar(255) DEFAULT NULL, `PARENT_DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_event_deployment -- ---------------------------- -- ---------------------------- -- Table structure for `flw_event_resource` -- ---------------------------- DROP TABLE IF EXISTS `flw_event_resource`; CREATE TABLE `flw_event_resource` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, `RESOURCE_BYTES_` longblob, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_event_resource -- ---------------------------- -- ---------------------------- -- Table structure for `flw_ev_databasechangelog` -- ---------------------------- DROP TABLE IF EXISTS `flw_ev_databasechangelog`; CREATE TABLE `flw_ev_databasechangelog` ( `ID` varchar(255) NOT NULL, `AUTHOR` varchar(255) NOT NULL, `FILENAME` varchar(255) NOT NULL, `DATEEXECUTED` datetime NOT NULL, `ORDEREXECUTED` int(11) NOT NULL, `EXECTYPE` varchar(10) NOT NULL, `MD5SUM` varchar(35) DEFAULT NULL, `DESCRIPTION` varchar(255) DEFAULT NULL, `COMMENTS` varchar(255) DEFAULT NULL, `TAG` varchar(255) DEFAULT NULL, `LIQUIBASE` varchar(20) DEFAULT NULL, `CONTEXTS` varchar(255) DEFAULT NULL, `LABELS` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID` varchar(10) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_ev_databasechangelog -- ---------------------------- INSERT INTO `flw_ev_databasechangelog` VALUES ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2023-08-08 14:31:05', '1', 'EXECUTED', '8:1b0c48c9cf7945be799d868a2626d687', 'createTable tableName=FLW_EVENT_DEPLOYMENT; createTable tableName=FLW_EVENT_RESOURCE; createTable tableName=FLW_EVENT_DEFINITION; createIndex indexName=ACT_IDX_EVENT_DEF_UNIQ, tableName=FLW_EVENT_DEFINITION; createTable tableName=FLW_CHANNEL_DEFIN...', '', null, '4.20.0', null, null, '1476265112'); INSERT INTO `flw_ev_databasechangelog` VALUES ('2', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2023-08-08 14:31:05', '2', 'EXECUTED', '8:0ea825feb8e470558f0b5754352b9cda', 'addColumn tableName=FLW_CHANNEL_DEFINITION; addColumn tableName=FLW_CHANNEL_DEFINITION', '', null, '4.20.0', null, null, '1476265112'); INSERT INTO `flw_ev_databasechangelog` VALUES ('3', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2023-08-08 14:31:05', '3', 'EXECUTED', '8:3c2bb293350b5cbe6504331980c9dcee', 'customChange', '', null, '4.20.0', null, null, '1476265112'); -- ---------------------------- -- Table structure for `flw_ev_databasechangeloglock` -- ---------------------------- DROP TABLE IF EXISTS `flw_ev_databasechangeloglock`; CREATE TABLE `flw_ev_databasechangeloglock` ( `ID` int(11) NOT NULL, `LOCKED` bit(1) NOT NULL, `LOCKGRANTED` datetime DEFAULT NULL, `LOCKEDBY` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_ev_databasechangeloglock -- ---------------------------- INSERT INTO `flw_ev_databasechangeloglock` VALUES ('1', '', null, null); -- ---------------------------- -- Table structure for `flw_ru_batch` -- ---------------------------- DROP TABLE IF EXISTS `flw_ru_batch`; CREATE TABLE `flw_ru_batch` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL, `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) NOT NULL, `COMPLETE_TIME_` datetime(3) DEFAULT NULL, `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BATCH_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of flw_ru_batch -- ---------------------------- -- ---------------------------- -- Table structure for `flw_ru_batch_part` -- ---------------------------- DROP TABLE IF EXISTS `flw_ru_batch_part`; CREATE TABLE `flw_ru_batch_part` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `BATCH_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL, `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) NOT NULL, `COMPLETE_TIME_` datetime(3) DEFAULT NULL, `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RESULT_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `FLW_IDX_BATCH_PART` (`BATCH_ID_`), CONSTRAINT `FLW_FK_BATCH_PART_PARENT` FOREIGN KEY (`BATCH_ID_`) REFERENCES `flw_ru_batch` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of flw_ru_batch_part -- ---------------------------- -- ---------------------------- -- Table structure for `gen_base_class` -- ---------------------------- DROP TABLE IF EXISTS `gen_base_class`; CREATE TABLE `gen_base_class` ( `id` bigint(20) NOT NULL COMMENT 'id', `package_name` varchar(200) DEFAULT NULL COMMENT '基类包名', `code` varchar(200) DEFAULT NULL COMMENT '基类编码', `fields` varchar(500) DEFAULT NULL COMMENT '基类字段，多个用英文逗号分隔', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='基类管理'; -- ---------------------------- -- Records of gen_base_class -- ---------------------------- INSERT INTO `gen_base_class` VALUES ('1302875019642159105', '${package}.common.entity.BaseEntity', 'BaseEntity', 'id,creator,create_date', '', '2023-08-08 14:33:24'); -- ---------------------------- -- Table structure for `gen_datasource` -- ---------------------------- DROP TABLE IF EXISTS `gen_datasource`; CREATE TABLE `gen_datasource` ( `id` bigint(20) NOT NULL COMMENT 'id', `db_type` varchar(200) DEFAULT NULL COMMENT '数据库类型 MySQL、Oracle、SQLServer、PostgreSQL', `conn_name` varchar(200) NOT NULL COMMENT '连接名', `conn_url` varchar(500) DEFAULT NULL COMMENT 'URL', `username` varchar(200) DEFAULT NULL COMMENT '用户名', `password` varchar(200) DEFAULT NULL COMMENT '密码', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：启用 1：禁用', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据源管理'; -- ---------------------------- -- Records of gen_datasource -- ---------------------------- INSERT INTO `gen_datasource` VALUES ('1302855887882412034', 'MySQL', '本地', 'jdbc:mysql://localhost:3306/wjp_project40?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true', 'root', '123456', '0', '2023-08-08 14:33:24'); -- ---------------------------- -- Table structure for `gen_field_type` -- ---------------------------- DROP TABLE IF EXISTS `gen_field_type`; CREATE TABLE `gen_field_type` ( `id` bigint(20) NOT NULL COMMENT 'id', `column_type` varchar(200) DEFAULT NULL COMMENT '字段类型', `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型', `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `column_type` (`column_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字段类型管理'; -- ---------------------------- -- Records of gen_field_type -- ---------------------------- INSERT INTO `gen_field_type` VALUES ('1152452777352425473', 'datetime', 'Date', 'java.util.Date', '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453412995002369', 'date', 'Date', 'java.util.Date', '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453603525455873', 'tinyint', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453660052090881', 'smallint', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453722136178689', 'mediumint', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453808874385409', 'int', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453849735294977', 'integer', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453895029583873', 'bigint', 'Long', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453931373228033', 'float', 'Float', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152453967880450050', 'double', 'Double', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454047601586177', 'decimal', 'BigDecimal', 'java.math.BigDecimal', '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454090760974338', 'bit', 'Boolean', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454147010785282', 'char', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454183136325633', 'varchar', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454312664821761', 'tinytext', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454343820111874', 'text', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454372077137921', 'mediumtext', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454401378545665', 'longtext', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454486267064322', 'timestamp', 'Date', 'java.util.Date', '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454630295269378', 'NUMBER', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454715645161474', 'BINARY_INTEGER', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454778828156930', 'BINARY_FLOAT', 'Float', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454828987838466', 'BINARY_DOUBLE', 'Double', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454885745160193', 'VARCHAR2', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454919756771329', 'NVARCHAR', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454952568811521', 'NVARCHAR2', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152454986349735938', 'CLOB', 'String', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152455109695827970', 'int8', 'Long', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152455153002016770', 'int4', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152455184669011969', 'int2', 'Integer', null, '2023-08-08 14:33:24'); INSERT INTO `gen_field_type` VALUES ('1152455217359417345', 'numeric', 'BigDecimal', 'java.math.BigDecimal', '2023-08-08 14:33:24'); -- ---------------------------- -- Table structure for `gen_table_field` -- ---------------------------- DROP TABLE IF EXISTS `gen_table_field`; CREATE TABLE `gen_table_field` ( `id` bigint(20) NOT NULL COMMENT 'id', `table_id` bigint(20) DEFAULT NULL COMMENT '表ID', `table_name` varchar(200) DEFAULT NULL COMMENT '表名', `column_name` varchar(200) DEFAULT NULL COMMENT '列名', `column_type` varchar(200) DEFAULT NULL COMMENT '类型', `column_comment` varchar(200) DEFAULT NULL COMMENT '列说明', `attr_name` varchar(200) DEFAULT NULL COMMENT '属性名', `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型', `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名', `is_pk` tinyint(4) DEFAULT NULL COMMENT '是否主键 0：否 1：是', `is_required` tinyint(4) DEFAULT NULL COMMENT '是否必填 0：否 1：是', `is_form` tinyint(4) DEFAULT NULL COMMENT '是否表单字段 0：否 1：是', `is_list` tinyint(4) DEFAULT NULL COMMENT '是否列表字段 0：否 1：是', `is_query` tinyint(4) DEFAULT NULL COMMENT '是否查询字段 0：否 1：是', `query_type` varchar(200) DEFAULT NULL COMMENT '查询方式', `form_type` varchar(200) DEFAULT NULL COMMENT '表单类型', `dict_name` varchar(200) DEFAULT NULL COMMENT '字典名称', `validator_type` varchar(200) DEFAULT NULL COMMENT '效验方式', `sort` int(11) DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`), KEY `table_name` (`table_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表列'; -- ---------------------------- -- Records of gen_table_field -- ---------------------------- INSERT INTO `gen_table_field` VALUES ('1308327671502385153', '1308327671447859201', 'gen_test_data', 'id', 'BIGINT', 'id', 'id', 'Long', null, '1', '0', '0', '0', '0', '=', 'text', null, null, '0'); INSERT INTO `gen_table_field` VALUES ('1308327671510773761', '1308327671447859201', 'gen_test_data', 'username', 'VARCHAR', '用户名', 'username', 'String', null, '0', '1', '1', '1', '1', 'like', 'text', null, null, '1'); INSERT INTO `gen_table_field` VALUES ('1308327671510773762', '1308327671447859201', 'gen_test_data', 'real_name', 'VARCHAR', '姓名', 'realName', 'String', null, '0', '1', '1', '1', '0', 'like', 'text', null, null, '2'); INSERT INTO `gen_table_field` VALUES ('1308327671510773763', '1308327671447859201', 'gen_test_data', 'gender', 'TINYINT', '性别', 'gender', 'Integer', null, '0', '1', '1', '1', '1', '=', 'select', 'gender', null, '3'); INSERT INTO `gen_table_field` VALUES ('1308327671510773764', '1308327671447859201', 'gen_test_data', 'email', 'VARCHAR', '邮箱', 'email', 'String', null, '0', '1', '1', '1', '0', '=', 'text', null, null, '4'); INSERT INTO `gen_table_field` VALUES ('1308327671514968065', '1308327671447859201', 'gen_test_data', 'notice_type', 'TINYINT', '类型', 'noticeType', 'Integer', null, '0', '1', '1', '1', '0', '=', 'radio', 'notice_type', null, '5'); INSERT INTO `gen_table_field` VALUES ('1308327671514968066', '1308327671447859201', 'gen_test_data', 'content', 'TEXT', '内容', 'content', 'String', null, '0', '1', '1', '0', '0', '=', 'editor', null, null, '6'); INSERT INTO `gen_table_field` VALUES ('1308327671514968067', '1308327671447859201', 'gen_test_data', 'creator', 'BIGINT', '创建者', 'creator', 'Long', null, '0', '0', '0', '0', '0', '=', 'text', null, null, '7'); INSERT INTO `gen_table_field` VALUES ('1308327671514968068', '1308327671447859201', 'gen_test_data', 'create_date', 'DATETIME', '创建时间', 'createDate', 'Date', 'java.util.Date', '0', '0', '0', '1', '1', '=', 'date', null, null, '8'); INSERT INTO `gen_table_field` VALUES ('1308327671514968069', '1308327671447859201', 'gen_test_data', 'updater', 'BIGINT', '更新者', 'updater', 'Long', null, '0', '0', '0', '0', '0', '=', 'text', null, null, '9'); INSERT INTO `gen_table_field` VALUES ('1308327671523356674', '1308327671447859201', 'gen_test_data', 'update_date', 'DATETIME', '更新时间', 'updateDate', 'Date', 'java.util.Date', '0', '0', '0', '0', '0', '=', 'text', null, null, '10'); -- ---------------------------- -- Table structure for `gen_table_info` -- ---------------------------- DROP TABLE IF EXISTS `gen_table_info`; CREATE TABLE `gen_table_info` ( `id` bigint(20) NOT NULL COMMENT 'id', `table_name` varchar(200) DEFAULT NULL COMMENT '表名', `class_name` varchar(200) DEFAULT NULL COMMENT '类名', `table_comment` varchar(200) DEFAULT NULL COMMENT '功能名', `author` varchar(200) DEFAULT NULL COMMENT '作者', `email` varchar(200) DEFAULT NULL COMMENT '邮箱', `package_name` varchar(200) DEFAULT NULL COMMENT '项目包名', `version` varchar(200) DEFAULT NULL COMMENT '项目版本号', `backend_path` varchar(500) DEFAULT NULL COMMENT '后端生成路径', `frontend_path` varchar(500) DEFAULT NULL COMMENT '前端生成路径', `module_name` varchar(200) DEFAULT NULL COMMENT '模块名', `sub_module_name` varchar(200) DEFAULT NULL COMMENT '子模块名', `datasource_id` bigint(20) DEFAULT NULL COMMENT '数据源ID', `baseclass_id` bigint(20) DEFAULT NULL COMMENT '基类ID', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `table_name` (`table_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表'; -- ---------------------------- -- Records of gen_table_info -- ---------------------------- INSERT INTO `gen_table_info` VALUES ('1308327671447859201', 'gen_test_data', 'TestData', '测试功能', 'Toby', 'javatangbin@163.com', 'com.wjp', '3.0', 'D:\\wjp\\wjp-enterprise\\wjp-admin', 'D:\\wjp\\wjp-enterprise-admin', 'gen', null, '0', '1302875019642159105', '2023-08-08 14:33:24'); -- ---------------------------- -- Table structure for `gen_template` -- ---------------------------- DROP TABLE IF EXISTS `gen_template`; CREATE TABLE `gen_template` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(200) DEFAULT NULL COMMENT '名称', `file_name` varchar(200) DEFAULT NULL COMMENT '文件名', `content` mediumtext NOT NULL COMMENT '内容', `path` varchar(500) DEFAULT NULL COMMENT '生成路径', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：启用 1：禁用', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='模板管理'; -- ---------------------------- -- Records of gen_template -- ---------------------------- INSERT INTO `gen_template` VALUES ('1144564443498168321', 'Entity.java', '${ClassName}Entity.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/entity/${subModuleName!}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1151104918417948674', 'Dao.java', '${ClassName}Dao.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dao/${subModuleName!}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1222102542519422977', 'Dao.xml', '${ClassName}Dao.xml', '', '${backendPath}/src/main/resources/mapper/${moduleName}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1222811087900602369', 'Service.java', '${ClassName}Service.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1222811738672033793', 'ServiceImpl.java', '${ClassName}ServiceImpl.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}/impl', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1222814109661753346', 'Excel.java', '${ClassName}Excel.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/excel/${subModuleName!}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1222816187301851138', 'DTO.java', '${ClassName}DTO.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dto/${subModuleName!}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1222817622663983106', 'Controller.java', '${ClassName}Controller.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/controller/${subModuleName!}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1304292858898309122', 'list.vue', '${classname}.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2023-08-08 14:33:24'); INSERT INTO `gen_template` VALUES ('1304293015698169857', 'add-or-update.vue', '${classname}-add-or-update.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2023-08-08 14:33:24'); -- ---------------------------- -- Table structure for `gen_test_data` -- ---------------------------- DROP TABLE IF EXISTS `gen_test_data`; CREATE TABLE `gen_test_data` ( `id` bigint(20) NOT NULL COMMENT 'id', `username` varchar(50) DEFAULT NULL COMMENT '用户名', `real_name` varchar(50) DEFAULT NULL COMMENT '姓名', `gender` tinyint(3) unsigned DEFAULT NULL COMMENT '性别', `email` varchar(100) DEFAULT NULL COMMENT '邮箱', `notice_type` tinyint(4) DEFAULT NULL COMMENT '类型', `content` text COMMENT '内容', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试功能'; -- ---------------------------- -- Records of gen_test_data -- ---------------------------- INSERT INTO `gen_test_data` VALUES ('1067246875800000001', 'toby', 'Toby', '0', 'root@scjydz.com', '0', '

代码生成器！

', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); -- ---------------------------- -- Table structure for `qrtz_blob_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_blob_triggers`; CREATE TABLE `qrtz_blob_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `BLOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_blob_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_calendars` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_calendars`; CREATE TABLE `qrtz_calendars` ( `SCHED_NAME` varchar(120) NOT NULL, `CALENDAR_NAME` varchar(200) NOT NULL, `CALENDAR` blob NOT NULL, PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_calendars -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_cron_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_cron_triggers`; CREATE TABLE `qrtz_cron_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `CRON_EXPRESSION` varchar(120) NOT NULL, `TIME_ZONE_ID` varchar(80) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_cron_triggers -- ---------------------------- INSERT INTO `qrtz_cron_triggers` VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai'); INSERT INTO `qrtz_cron_triggers` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai'); -- ---------------------------- -- Table structure for `qrtz_fired_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_fired_triggers`; CREATE TABLE `qrtz_fired_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `ENTRY_ID` varchar(95) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `INSTANCE_NAME` varchar(200) NOT NULL, `FIRED_TIME` bigint(13) NOT NULL, `SCHED_TIME` bigint(13) NOT NULL, `PRIORITY` int(11) NOT NULL, `STATE` varchar(16) NOT NULL, `JOB_NAME` varchar(200) DEFAULT NULL, `JOB_GROUP` varchar(200) DEFAULT NULL, `IS_NONCONCURRENT` varchar(1) DEFAULT NULL, `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`), KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`), KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`), KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_fired_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_job_details` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_job_details`; CREATE TABLE `qrtz_job_details` ( `SCHED_NAME` varchar(120) NOT NULL, `JOB_NAME` varchar(200) NOT NULL, `JOB_GROUP` varchar(200) NOT NULL, `DESCRIPTION` varchar(250) DEFAULT NULL, `JOB_CLASS_NAME` varchar(250) NOT NULL, `IS_DURABLE` varchar(1) NOT NULL, `IS_NONCONCURRENT` varchar(1) NOT NULL, `IS_UPDATE_DATA` varchar(1) NOT NULL, `REQUESTS_RECOVERY` varchar(1) NOT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`), KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_job_details -- ---------------------------- INSERT INTO `qrtz_job_details` VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', null, 'io.renren.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189D3CD3F58787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F74000672656E72656E740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F770800000189D3CD3F58787371007E00110ECF9F6107B456017800); INSERT INTO `qrtz_job_details` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', null, 'com.wjp.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002C636F6D2E776A702E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720020636F6D2E776A702E636F6D6D6F6E2E656E746974792E42617365456E74697479E3EBD9BB2ED95AFB0200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189D3CD3F58787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F74000672656E72656E740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F770800000189D3CD3F58787371007E00110ECF9F6107B456017800); -- ---------------------------- -- Table structure for `qrtz_locks` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_locks`; CREATE TABLE `qrtz_locks` ( `SCHED_NAME` varchar(120) NOT NULL, `LOCK_NAME` varchar(40) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_locks -- ---------------------------- INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'STATE_ACCESS'); INSERT INTO `qrtz_locks` VALUES ('RenrenScheduler', 'TRIGGER_ACCESS'); -- ---------------------------- -- Table structure for `qrtz_paused_trigger_grps` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`; CREATE TABLE `qrtz_paused_trigger_grps` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_paused_trigger_grps -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_scheduler_state` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_scheduler_state`; CREATE TABLE `qrtz_scheduler_state` ( `SCHED_NAME` varchar(120) NOT NULL, `INSTANCE_NAME` varchar(200) NOT NULL, `LAST_CHECKIN_TIME` bigint(13) NOT NULL, `CHECKIN_INTERVAL` bigint(13) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_scheduler_state -- ---------------------------- INSERT INTO `qrtz_scheduler_state` VALUES ('RenrenScheduler', 'DESKTOP-KIOOR1691476261273', '1691476878409', '15000'); INSERT INTO `qrtz_scheduler_state` VALUES ('WjpScheduler', 'DESKTOP-KIOOR1691570557601', '1691573536746', '15000'); -- ---------------------------- -- Table structure for `qrtz_simple_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simple_triggers`; CREATE TABLE `qrtz_simple_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `REPEAT_COUNT` bigint(7) NOT NULL, `REPEAT_INTERVAL` bigint(12) NOT NULL, `TIMES_TRIGGERED` bigint(10) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_simple_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_simprop_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simprop_triggers`; CREATE TABLE `qrtz_simprop_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `STR_PROP_1` varchar(512) DEFAULT NULL, `STR_PROP_2` varchar(512) DEFAULT NULL, `STR_PROP_3` varchar(512) DEFAULT NULL, `INT_PROP_1` int(11) DEFAULT NULL, `INT_PROP_2` int(11) DEFAULT NULL, `LONG_PROP_1` bigint(20) DEFAULT NULL, `LONG_PROP_2` bigint(20) DEFAULT NULL, `DEC_PROP_1` decimal(13,4) DEFAULT NULL, `DEC_PROP_2` decimal(13,4) DEFAULT NULL, `BOOL_PROP_1` varchar(1) DEFAULT NULL, `BOOL_PROP_2` varchar(1) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_simprop_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_triggers`; CREATE TABLE `qrtz_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `JOB_NAME` varchar(200) NOT NULL, `JOB_GROUP` varchar(200) NOT NULL, `DESCRIPTION` varchar(250) DEFAULT NULL, `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL, `PREV_FIRE_TIME` bigint(13) DEFAULT NULL, `PRIORITY` int(11) DEFAULT NULL, `TRIGGER_STATE` varchar(16) NOT NULL, `TRIGGER_TYPE` varchar(8) NOT NULL, `START_TIME` bigint(13) NOT NULL, `END_TIME` bigint(13) DEFAULT NULL, `CALENDAR_NAME` varchar(200) DEFAULT NULL, `MISFIRE_INSTR` smallint(2) DEFAULT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`), KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`), KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`), KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`), KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_triggers -- ---------------------------- INSERT INTO `qrtz_triggers` VALUES ('RenrenScheduler', 'TASK_1067246875800000076', 'DEFAULT', 'TASK_1067246875800000076', 'DEFAULT', null, '1691478000000', '-1', '5', 'PAUSED', 'CRON', '1691476278000', '0', null, '2', ''); INSERT INTO `qrtz_triggers` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', 'TASK_1067246875800000076', 'DEFAULT', null, '1691478000000', '-1', '5', 'PAUSED', 'CRON', '1691477974000', '0', null, '2', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002C636F6D2E776A702E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720020636F6D2E776A702E636F6D6D6F6E2E656E746974792E42617365456E74697479E3EBD9BB2ED95AFB0200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189D3CD3F58787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F740003776A70740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F770800000189D4387C78787371007E00110ECF9F6107B456017800); -- ---------------------------- -- Table structure for `schedule_job` -- ---------------------------- DROP TABLE IF EXISTS `schedule_job`; CREATE TABLE `schedule_job` ( `id` bigint(20) NOT NULL COMMENT 'id', `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称', `params` varchar(2000) DEFAULT NULL COMMENT '参数', `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式', `status` tinyint(3) unsigned DEFAULT NULL COMMENT '任务状态 0：暂停 1：正常', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务'; -- ---------------------------- -- Records of schedule_job -- ---------------------------- INSERT INTO `schedule_job` VALUES ('1067246875800000076', 'testTask', 'wjp', '0 0/30 * * * ?', '0', '有参测试，多个参数使用json', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:16:59'); -- ---------------------------- -- Table structure for `schedule_job_log` -- ---------------------------- DROP TABLE IF EXISTS `schedule_job_log`; CREATE TABLE `schedule_job_log` ( `id` bigint(20) NOT NULL COMMENT 'id', `job_id` bigint(20) NOT NULL COMMENT '任务id', `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称', `params` varchar(2000) DEFAULT NULL COMMENT '参数', `status` tinyint(3) unsigned NOT NULL COMMENT '任务状态 0：失败 1：成功', `error` varchar(2000) DEFAULT NULL COMMENT '失败信息', `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_job_id` (`job_id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务日志'; -- ---------------------------- -- Records of schedule_job_log -- ---------------------------- -- ---------------------------- -- Table structure for `sys_dept` -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `id` bigint(20) NOT NULL COMMENT 'id', `pid` bigint(20) DEFAULT NULL COMMENT '上级ID', `pids` varchar(500) DEFAULT NULL COMMENT '所有上级ID，用逗号分开', `name` varchar(50) DEFAULT NULL COMMENT '部门名称', `sort` int(10) unsigned DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_pid` (`pid`), KEY `idx_sort` (`sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='部门管理'; -- ---------------------------- -- Records of sys_dept -- ---------------------------- INSERT INTO `sys_dept` VALUES ('1067246875800000062', '1067246875800000063', '1067246875800000066,1067246875800000063', '技术部', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dept` VALUES ('1067246875800000063', '1067246875800000066', '1067246875800000066', '北京总公司', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:37:18'); INSERT INTO `sys_dept` VALUES ('1067246875800000064', '1067246875800000066', '1067246875800000066', '成都总公司', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:37:08'); INSERT INTO `sys_dept` VALUES ('1067246875800000065', '1067246875800000064', '1067246875800000066,1067246875800000064', '软件部', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:37:29'); INSERT INTO `sys_dept` VALUES ('1067246875800000066', '0', '0', '佳缘科技股份有限公司', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 16:36:56'); INSERT INTO `sys_dept` VALUES ('1067246875800000067', '1067246875800000064', '1067246875800000066,1067246875800000064', '销售部', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dept` VALUES ('1067246875800000068', '1067246875800000063', '1067246875800000066,1067246875800000063', '产品部', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); -- ---------------------------- -- Table structure for `sys_dict_data` -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `id` bigint(20) NOT NULL COMMENT 'id', `dict_type_id` bigint(20) NOT NULL COMMENT '字典类型ID', `dict_label` varchar(255) NOT NULL COMMENT '字典标签', `dict_value` varchar(255) DEFAULT NULL COMMENT '字典值', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `sort` int(10) unsigned DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_dict_type_value` (`dict_type_id`,`dict_value`), KEY `idx_sort` (`sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典数据'; -- ---------------------------- -- Records of sys_dict_data -- ---------------------------- INSERT INTO `sys_dict_data` VALUES ('1160061112075464705', '1160061077912858625', '男', '0', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1160061146967879681', '1160061077912858625', '女', '1', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1160061190127267841', '1160061077912858625', '保密', '2', '', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1225814069634195457', '1225813644059140097', '公告', '0', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1225814107559092225', '1225813644059140097', '会议', '1', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1225814271879340034', '1225813644059140097', '其他', '2', '', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1341593562419445762', '1341593474355838978', '停用', '0', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1341593595407646722', '1341593474355838978', '正常', '1', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1343069765549191170', '1343069688596295682', '已取消', '-1', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1343069839847092226', '1343069688596295682', '等待付款', '0', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_data` VALUES ('1343069914518286337', '1343069688596295682', '已完成', '1', '', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); -- ---------------------------- -- Table structure for `sys_dict_type` -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_type`; CREATE TABLE `sys_dict_type` ( `id` bigint(20) NOT NULL COMMENT 'id', `dict_type` varchar(100) NOT NULL COMMENT '字典类型', `dict_name` varchar(255) NOT NULL COMMENT '字典名称', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `sort` int(10) unsigned DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `dict_type` (`dict_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典类型'; -- ---------------------------- -- Records of sys_dict_type -- ---------------------------- INSERT INTO `sys_dict_type` VALUES ('1160061077912858625', 'gender', '性别', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_type` VALUES ('1225813644059140097', 'notice_type', '站内通知-类型', '', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_type` VALUES ('1341593474355838978', 'post_status', '岗位管理状态', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_dict_type` VALUES ('1343069688596295682', 'order_status', '订单状态', '', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); -- ---------------------------- -- Table structure for `sys_language` -- ---------------------------- DROP TABLE IF EXISTS `sys_language`; CREATE TABLE `sys_language` ( `table_name` varchar(32) NOT NULL COMMENT '表名', `table_id` bigint(20) NOT NULL COMMENT '表主键', `field_name` varchar(32) NOT NULL COMMENT '字段名', `field_value` varchar(200) NOT NULL COMMENT '字段值', `language` varchar(10) NOT NULL COMMENT '语言', PRIMARY KEY (`table_name`,`table_id`,`field_name`,`language`), KEY `idx_table_id` (`table_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='国际化'; -- ---------------------------- -- Records of sys_language -- ---------------------------- INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', 'Authority Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', '权限管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', '權限管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', 'Export', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', '导出', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', '導出', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', 'Role Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', '角色管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', '角色管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', 'Department Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', '部门管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', '部門管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', 'Form Design', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', '表单设计', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', '表单设计', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', 'Process Design', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', '流程设计', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', '流程设计', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', 'Running Process', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', '运行中的流程', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', '運行中的流程', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', 'Menu Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', '菜单管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', '菜單管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', 'Timed Task', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', '定时任务', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', '定時任務', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', 'Setting', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', '系统设置', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', '系統設置', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', 'Pause', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', '暂停', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', '暫停', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', 'Resume', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', '恢复', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', '恢復', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', 'Execute', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', '立即执行', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', '立即執行', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', 'Log List', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', '日志列表', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', '日誌列表', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', 'Parameter Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', '参数管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', '參數管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', 'Dict Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', '字典管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', '字典管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', 'Log Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', '日志管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', '日誌管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', 'File Upload', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', '文件上传', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', '文件上傳', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', 'Login Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', '登录日志', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', '登錄日誌', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', 'Operation Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', '操作日志', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', '操作日誌', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', 'Error Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', '异常日志', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', '異常日誌', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', 'System Monitoring', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', '系统监控', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', '系統監控', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', 'User Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', '用户管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', '用戶管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', 'Export', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', '导出', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', '導出', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', 'Station Notice', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', '站内通知', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', '站內通知', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', 'Notice Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', '通知管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', '通知管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', 'My Notice', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', '我的通知', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', '我的通知', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', 'Process Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', '流程管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', '流程管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', 'Personal Office', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', '流程使用', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', '辦公管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', 'Todo', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', '待办任务', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', '待辦任務', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', 'Task Already', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', '已办任务', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', '已辦任務', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', 'Initiation Process', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', '发起流程', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', '發起流程', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', 'My Send', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', '我发起的', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', '我發起的', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', 'Interface Document', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', '接口文档', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', '接口文檔', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', 'Report Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', '报表管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', '報表管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', 'Report Design', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', '报表设计器', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', '報表設計器', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', 'Report List', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', '报表列表', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', '報表列表', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', 'DevTools', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', '开发者工具', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', '開發者工具', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', 'DataSource', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', '数据源管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', '數據源管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', 'Field Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', '字段管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', '字段管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', 'BaseClass', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', '基类管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', '基類管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', 'Template', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', '模板管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', '模板管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', 'Code Generation', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', '代码生成工具', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', '代碼生成工具', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', 'Parameter Config', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', '参数配置', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', '參數配置', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', 'Config Info', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', '配置信息', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', '配置信息', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', 'Job Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', '岗位管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', '崗位管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', 'Online User', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', '在线用户', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', '在線用戶', 'zh-TW'); -- ---------------------------- -- Table structure for `sys_log_error` -- ---------------------------- DROP TABLE IF EXISTS `sys_log_error`; CREATE TABLE `sys_log_error` ( `id` bigint(20) NOT NULL COMMENT 'id', `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI', `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式', `request_params` text COMMENT '请求参数', `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理', `ip` varchar(32) DEFAULT NULL COMMENT '操作IP', `error_info` text COMMENT '异常信息', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='异常日志'; -- ---------------------------- -- Records of sys_log_error -- ---------------------------- -- ---------------------------- -- Table structure for `sys_log_login` -- ---------------------------- DROP TABLE IF EXISTS `sys_log_login`; CREATE TABLE `sys_log_login` ( `id` bigint(20) NOT NULL COMMENT 'id', `operation` tinyint(3) unsigned DEFAULT NULL COMMENT '用户操作 0：用户登录 1：用户退出', `status` tinyint(3) unsigned NOT NULL COMMENT '状态 0：失败 1：成功 2：账号已锁定', `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理', `ip` varchar(32) DEFAULT NULL COMMENT '操作IP', `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_status` (`status`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='登录日志'; -- ---------------------------- -- Records of sys_log_login -- ---------------------------- -- ---------------------------- -- Table structure for `sys_log_operation` -- ---------------------------- DROP TABLE IF EXISTS `sys_log_operation`; CREATE TABLE `sys_log_operation` ( `id` bigint(20) NOT NULL COMMENT 'id', `operation` varchar(50) DEFAULT NULL COMMENT '用户操作', `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI', `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式', `request_params` text COMMENT '请求参数', `request_time` int(10) unsigned NOT NULL COMMENT '请求时长(毫秒)', `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理', `ip` varchar(32) DEFAULT NULL COMMENT '操作IP', `status` tinyint(3) unsigned NOT NULL COMMENT '状态 0：失败 1：成功', `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志'; -- ---------------------------- -- Records of sys_log_operation -- ---------------------------- -- ---------------------------- -- Table structure for `sys_menu` -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` bigint(20) NOT NULL COMMENT 'id', `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级菜单为0', `url` varchar(200) DEFAULT NULL COMMENT '菜单URL', `permissions` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)', `menu_type` tinyint(3) unsigned DEFAULT NULL COMMENT '类型 0：菜单 1：按钮', `open_style` tinyint(3) unsigned DEFAULT NULL COMMENT '打开方式 0：内部 1：外部', `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标', `sort` int(11) DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_pid` (`pid`), KEY `idx_sort` (`sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='菜单管理'; -- ---------------------------- -- Records of sys_menu -- ---------------------------- INSERT INTO `sys_menu` VALUES ('1067246875800000002', '0', null, null, '0', '0', 'icon-safetycertificate', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000003', '1067246875800000055', null, 'sys:user:save,sys:dept:list,sys:role:list', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000004', '1067246875800000055', null, 'sys:user:update,sys:dept:list,sys:role:list', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000005', '1067246875800000055', null, 'sys:user:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000006', '1067246875800000055', null, 'sys:user:export', '1', '0', null, '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000007', '1067246875800000002', 'sys/role', null, '0', '0', 'icon-team', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000008', '1067246875800000007', null, 'sys:role:page,sys:role:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000009', '1067246875800000007', null, 'sys:role:save,sys:menu:select,sys:dept:list', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000010', '1067246875800000007', null, 'sys:role:update,sys:menu:select,sys:dept:list', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000011', '1067246875800000007', null, 'sys:role:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000012', '1067246875800000002', 'sys/dept', null, '0', '0', 'icon-apartment', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000014', '1067246875800000012', null, 'sys:dept:list,sys:dept:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000015', '1067246875800000012', null, 'sys:dept:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000016', '1067246875800000012', null, 'sys:dept:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000017', '1067246875800000012', null, 'sys:dept:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000018', '1150940491508928513', 'flow/bpmform', 'flow:bpmform:all', '0', '0', 'icon-detail', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000019', '1150940491508928513', 'flow/model', 'sys:model:all', '0', '0', 'icon-appstore-fill', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000020', '1150940491508928513', 'flow/running', 'sys:running:all,sys:flow:all', '0', '0', 'icon-play-square', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000025', '1067246875800000035', 'sys/menu', null, '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000026', '1067246875800000025', null, 'sys:menu:list,sys:menu:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000027', '1067246875800000025', null, 'sys:menu:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000028', '1067246875800000025', null, 'sys:menu:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000029', '1067246875800000025', null, 'sys:menu:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000030', '1067246875800000035', 'job/schedule', null, '0', '0', 'icon-dashboard', '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000031', '1067246875800000030', null, 'sys:schedule:page,sys:schedule:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000032', '1067246875800000030', null, 'sys:schedule:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000033', '1067246875800000030', null, 'sys:schedule:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000034', '1067246875800000030', null, 'sys:schedule:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000035', '0', null, null, '0', '0', 'icon-setting', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000036', '1067246875800000030', null, 'sys:schedule:pause', '1', '0', null, '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000037', '1067246875800000030', null, 'sys:schedule:resume', '1', '0', null, '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000038', '1067246875800000030', null, 'sys:schedule:run', '1', '0', null, '6', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000039', '1067246875800000030', null, 'sys:schedule:log', '1', '0', null, '7', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000040', '1067246875800000035', 'sys/params', '', '0', '0', 'icon-fileprotect', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000041', '1067246875800000035', 'sys/dict-type', null, '0', '0', 'icon-golden-fill', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000042', '1067246875800000041', null, 'sys:dict:page,sys:dict:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000043', '1067246875800000041', null, 'sys:dict:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000044', '1067246875800000041', null, 'sys:dict:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000045', '1067246875800000041', null, 'sys:dict:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000046', '0', null, null, '0', '0', 'icon-container', '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000047', '1067246875800000035', 'oss/oss', 'sys:oss:all', '0', '0', 'icon-upload', '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000048', '1067246875800000046', 'sys/log-login', 'sys:log:login', '0', '0', 'icon-filedone', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000049', '1067246875800000046', 'sys/log-operation', 'sys:log:operation', '0', '0', 'icon-solution', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000050', '1067246875800000046', 'sys/log-error', 'sys:log:error', '0', '0', 'icon-file-exception', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000053', '0', null, null, '0', '0', 'icon-desktop', '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000055', '1067246875800000002', 'sys/user', null, '0', '0', 'icon-user', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000056', '1067246875800000055', null, 'sys:user:page,sys:user:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000057', '1067246875800000040', null, 'sys:params:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000058', '1067246875800000040', null, 'sys:params:export', '1', '0', null, '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000059', '1067246875800000040', '', 'sys:params:page,sys:params:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000060', '1067246875800000040', null, 'sys:params:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000061', '1067246875800000040', '', 'sys:params:delete', '1', '0', '', '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000300', '0', null, null, '0', '0', 'icon-bell', '5', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000301', '1067246875800000300', 'notice/notice', 'sys:notice:all', '0', '0', 'icon-bell', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1067246875800000302', '1067246875800000300', 'notice/notice-user', 'sys:notice:all', '0', '0', 'icon-notification', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1150940491508928513', '0', null, null, '0', '0', 'icon-reloadtime', '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1150941310262235138', '0', null, null, '0', '0', 'icon-user', '4', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-09 11:40:46'); INSERT INTO `sys_menu` VALUES ('1150941384811794433', '1150941310262235138', 'flow/todo', 'sys:flow:all,sys:user:page', '0', '0', 'icon-dashboard', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1150941447038488577', '1150941310262235138', 'flow/done', 'sys:flow:all', '0', '0', 'icon-check-square', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1150941506626965506', '1150941310262235138', 'flow/start', 'sys:flow:all', '0', '0', 'icon-play-square', '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1150941588046794754', '1150941310262235138', 'flow/my-send', 'sys:flow:all', '0', '0', 'icon-edit-square', '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1156748733921165314', '1067246875800000053', '{{ApiUrl}}/doc.html', '', '0', '1', 'icon-file-word', '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1302850622416084993', '0', '', '', '0', '0', 'icon-rocket', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1302850783288614913', '1305532398162145281', 'devtools/datasource', '', '0', '0', 'icon-sync', '0', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1302862890696564738', '1305532398162145281', 'devtools/fieldtype', '', '0', '0', 'icon-eye', '1', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1302874751835848705', '1305532398162145281', 'devtools/baseclass', '', '0', '0', 'icon-info-circle', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1304081184014635010', '1305532398162145281', 'devtools/template', '', '0', '0', 'icon-up-circle', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1304802103569809410', '1302850622416084993', 'devtools/generator', '', '0', '0', 'icon-tags', '0', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1305513187675144193', '1305532398162145281', 'devtools/param', '', '0', '0', 'icon-setting', '5', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1305532398162145281', '1302850622416084993', '', '', '0', '0', 'icon-setting', '3', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_menu` VALUES ('1341596622612987906', '1067246875800000002', 'sys/post', null, '0', '0', 'icon-pic-left', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1341596622688485377', '1341596622612987906', null, 'sys:post:page,sys:post:info', '1', '0', null, '0', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1341596622755594242', '1341596622612987906', null, 'sys:post:save', '1', '0', null, '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1341596622835286018', '1341596622612987906', null, 'sys:post:update', '1', '0', null, '2', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1341596622902394881', '1341596622612987906', null, 'sys:post:delete', '1', '0', null, '3', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); INSERT INTO `sys_menu` VALUES ('1341659662599495681', '1067246875800000053', 'sys/online', 'sys:online:all', '0', '0', 'icon-team', '1', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); -- ---------------------------- -- Table structure for `sys_notice` -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `id` bigint(20) NOT NULL COMMENT 'id', `notice_type` int(11) NOT NULL COMMENT '通知类型', `title` varchar(200) DEFAULT NULL COMMENT '标题', `content` text COMMENT '内容', `receiver_type` tinyint(3) unsigned DEFAULT NULL COMMENT '接收者 0：全部 1：部门', `receiver_type_ids` varchar(500) DEFAULT NULL COMMENT '接收者ID，用逗号分开', `status` tinyint(3) unsigned DEFAULT NULL COMMENT '发送状态 0：草稿 1：已发布', `sender_name` varchar(50) DEFAULT NULL COMMENT '发送者', `sender_date` datetime DEFAULT NULL COMMENT '发送时间', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知管理'; -- ---------------------------- -- Records of sys_notice -- ---------------------------- -- ---------------------------- -- Table structure for `sys_notice_user` -- ---------------------------- DROP TABLE IF EXISTS `sys_notice_user`; CREATE TABLE `sys_notice_user` ( `receiver_id` bigint(20) NOT NULL COMMENT '接收者ID', `notice_id` bigint(20) NOT NULL COMMENT '通知ID', `read_status` tinyint(3) unsigned DEFAULT NULL COMMENT '阅读状态 0：未读 1：已读', `read_date` datetime DEFAULT NULL COMMENT '阅读时间', PRIMARY KEY (`receiver_id`,`notice_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='我的通知'; -- ---------------------------- -- Records of sys_notice_user -- ---------------------------- -- ---------------------------- -- Table structure for `sys_oss` -- ---------------------------- DROP TABLE IF EXISTS `sys_oss`; CREATE TABLE `sys_oss` ( `id` bigint(20) NOT NULL COMMENT 'id', `url` varchar(200) DEFAULT NULL COMMENT 'URL地址', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件上传'; -- ---------------------------- -- Records of sys_oss -- ---------------------------- -- ---------------------------- -- Table structure for `sys_params` -- ---------------------------- DROP TABLE IF EXISTS `sys_params`; CREATE TABLE `sys_params` ( `id` bigint(20) NOT NULL COMMENT 'id', `param_code` varchar(32) DEFAULT NULL COMMENT '参数编码', `param_value` varchar(2000) DEFAULT NULL COMMENT '参数值', `param_type` tinyint(3) unsigned DEFAULT '1' COMMENT '类型 0：系统参数 1：非系统参数', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_param_code` (`param_code`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='参数管理'; -- ---------------------------- -- Records of sys_params -- ---------------------------- INSERT INTO `sys_params` VALUES ('1067246875800000072', 'DEV_TOOLS_PARAM_KEY', '{\"packageName\":\"com.wjp\",\"version\":\"4.0\",\"author\":\"Toby\",\"email\":\"javatangbin@163.com\",\"backendPath\":\"D:\\\\toby\\\\code\\\\kuangjia\\\\wjp-project40\\\\wjp-admin\",\"frontendPath\":\"D:\\\\toby\\\\code\\\\kuangjia\\\\wjp-project-admin40\"}', '0', '代码生成器配置信息', '1067246875800000001', '2023-08-08 14:33:24', '1067246875800000001', '2023-08-08 14:33:24'); INSERT INTO `sys_params` VALUES ('1067246875800000073', 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":1,\"qiniuDomain\":\"http://test.oss.scjydz.com\",\"qiniuPrefix\":\"upload\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"qiniuBucketName\":\"wjp-oss\",\"aliyunDomain\":\"\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"\",\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', '0', '云存储配置信息', '1067246875800000001', '2023-08-08 14:19:51', '1067246875800000001', '2023-08-08 14:19:51'); -- ---------------------------- -- Table structure for `sys_post` -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `id` bigint(20) NOT NULL COMMENT 'id', `post_code` varchar(100) DEFAULT NULL COMMENT '岗位编码', `post_name` varchar(100) DEFAULT NULL COMMENT '岗位名称', `sort` int(11) DEFAULT NULL COMMENT '排序', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：停用 1：正常', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='岗位管理'; -- ---------------------------- -- Records of sys_post -- ---------------------------- -- ---------------------------- -- Table structure for `sys_role` -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(50) DEFAULT NULL COMMENT '角色名称', `remark` varchar(100) DEFAULT NULL COMMENT '备注', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_dept_id` (`dept_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色管理'; -- ---------------------------- -- Records of sys_role -- ---------------------------- INSERT INTO `sys_role` VALUES ('1689151872981299201', '超级管理员', '超级管理员', null, '1067246875800000001', '2023-08-09 13:49:24', '1067246875800000001', '2023-08-09 16:52:52'); -- ---------------------------- -- Table structure for `sys_role_data_scope` -- ---------------------------- DROP TABLE IF EXISTS `sys_role_data_scope`; CREATE TABLE `sys_role_data_scope` ( `id` bigint(20) NOT NULL COMMENT 'id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色数据权限'; -- ---------------------------- -- Records of sys_role_data_scope -- ---------------------------- INSERT INTO `sys_role_data_scope` VALUES ('1689198043284193281', '1689151872981299201', '1067246875800000066', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_data_scope` VALUES ('1689198043292581890', '1689151872981299201', '1067246875800000064', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_data_scope` VALUES ('1689198043300970497', '1689151872981299201', '1067246875800000065', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_data_scope` VALUES ('1689198043305164801', '1689151872981299201', '1067246875800000067', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_data_scope` VALUES ('1689198043313553410', '1689151872981299201', '1067246875800000063', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_data_scope` VALUES ('1689198043321942018', '1689151872981299201', '1067246875800000068', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_data_scope` VALUES ('1689198043330330626', '1689151872981299201', '1067246875800000062', '1067246875800000001', '2023-08-09 16:52:52'); -- ---------------------------- -- Table structure for `sys_role_menu` -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `id` bigint(20) NOT NULL COMMENT 'id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`), KEY `idx_menu_id` (`menu_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色菜单关系'; -- ---------------------------- -- Records of sys_role_menu -- ---------------------------- INSERT INTO `sys_role_menu` VALUES ('1689198042764099586', '1689151872981299201', '1067246875800000053', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042776682498', '1689151872981299201', '1067246875800000002', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042785071106', '1689151872981299201', '1067246875800000055', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042793459714', '1689151872981299201', '1067246875800000056', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042801848321', '1689151872981299201', '1067246875800000003', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042810236930', '1689151872981299201', '1067246875800000004', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042818625538', '1689151872981299201', '1067246875800000005', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042822819842', '1689151872981299201', '1067246875800000006', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042831208449', '1689151872981299201', '1341596622612987906', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042839597058', '1689151872981299201', '1341596622688485377', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042847985666', '1689151872981299201', '1341596622755594242', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042856374274', '1689151872981299201', '1341596622835286018', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042864762881', '1689151872981299201', '1341596622902394881', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042881540098', '1689151872981299201', '1067246875800000012', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042889928705', '1689151872981299201', '1067246875800000014', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042894123009', '1689151872981299201', '1067246875800000015', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042902511617', '1689151872981299201', '1067246875800000016', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042910900226', '1689151872981299201', '1067246875800000017', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042919288833', '1689151872981299201', '1067246875800000007', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042927677442', '1689151872981299201', '1067246875800000008', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042931871745', '1689151872981299201', '1067246875800000009', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042940260353', '1689151872981299201', '1067246875800000010', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042948648962', '1689151872981299201', '1067246875800000011', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042965426178', '1689151872981299201', '1067246875800000035', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042969620482', '1689151872981299201', '1067246875800000025', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042978009090', '1689151872981299201', '1067246875800000026', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042986397697', '1689151872981299201', '1067246875800000027', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198042998980609', '1689151872981299201', '1067246875800000028', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043007369217', '1689151872981299201', '1067246875800000029', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043019952130', '1689151872981299201', '1067246875800000040', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043028340738', '1689151872981299201', '1067246875800000059', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043032535041', '1689151872981299201', '1067246875800000057', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043040923649', '1689151872981299201', '1067246875800000060', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043049312258', '1689151872981299201', '1067246875800000061', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043057700865', '1689151872981299201', '1067246875800000058', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043066089473', '1689151872981299201', '1067246875800000041', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043082866690', '1689151872981299201', '1067246875800000042', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043091255297', '1689151872981299201', '1067246875800000043', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043099643906', '1689151872981299201', '1067246875800000044', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043103838209', '1689151872981299201', '1067246875800000045', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043116421121', '1689151872981299201', '1067246875800000030', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043116421122', '1689151872981299201', '1067246875800000031', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043124809730', '1689151872981299201', '1067246875800000032', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043141586945', '1689151872981299201', '1067246875800000033', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043149975553', '1689151872981299201', '1067246875800000034', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043158364162', '1689151872981299201', '1067246875800000036', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043170947074', '1689151872981299201', '1067246875800000037', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043179335681', '1689151872981299201', '1067246875800000038', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043187724290', '1689151872981299201', '1067246875800000039', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043196112897', '1689151872981299201', '1067246875800000047', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043204501506', '1689151872981299201', '1067246875800000300', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043212890113', '1689151872981299201', '1067246875800000302', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043221278721', '1689151872981299201', '1067246875800000301', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043233861633', '1689151872981299201', '1067246875800000046', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043233861634', '1689151872981299201', '1067246875800000048', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043242250242', '1689151872981299201', '1067246875800000049', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043259027458', '1689151872981299201', '1067246875800000050', '1067246875800000001', '2023-08-09 16:52:52'); INSERT INTO `sys_role_menu` VALUES ('1689198043259027459', '1689151872981299201', '1341659662599495681', '1067246875800000001', '2023-08-09 16:52:52'); -- ---------------------------- -- Table structure for `sys_role_user` -- ---------------------------- DROP TABLE IF EXISTS `sys_role_user`; CREATE TABLE `sys_role_user` ( `id` bigint(20) NOT NULL COMMENT 'id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色用户关系'; -- ---------------------------- -- Records of sys_role_user -- ---------------------------- INSERT INTO `sys_role_user` VALUES ('1689198194241388546', '1689151872981299201', '1689152089323499521', '1067246875800000001', '2023-08-09 16:53:28'); -- ---------------------------- -- Table structure for `sys_user` -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint(20) NOT NULL COMMENT 'id', `username` varchar(50) NOT NULL COMMENT '用户名', `password` varchar(100) DEFAULT NULL COMMENT '密码', `real_name` varchar(50) DEFAULT NULL COMMENT '姓名', `head_url` varchar(200) DEFAULT NULL COMMENT '头像', `gender` tinyint(3) unsigned DEFAULT NULL COMMENT '性别 0：男 1：女 2：保密', `email` varchar(100) DEFAULT NULL COMMENT '邮箱', `mobile` varchar(100) DEFAULT NULL COMMENT '手机号', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID', `super_admin` tinyint(3) unsigned DEFAULT NULL COMMENT '超级管理员 0：否 1：是', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：停用 1：正常', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_username` (`username`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统用户'; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('1067246875800000001', 'admin', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '管理员', null, '0', 'root@renren.io', '13612345678', null, '1', '1', '1067246875800000001', '2023-08-08 14:19:50', '1067246875800000001', '2023-08-08 14:19:50'); INSERT INTO `sys_user` VALUES ('1689152089323499521', 'root', '$2a$10$UfWfEQAYe2XwsP.n9wy4OuhsYE0WuR.uhVo15orrCEecoYXu8/CCO', '超级管理员', null, '0', '', '', '1067246875800000066', '0', '1', '1067246875800000001', '2023-08-09 13:50:16', '1067246875800000001', '2023-08-09 16:53:28'); -- ---------------------------- -- Table structure for `sys_user_post` -- ---------------------------- DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `id` bigint(20) NOT NULL COMMENT 'id', `post_id` bigint(20) DEFAULT NULL COMMENT '岗位ID', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_post_id` (`post_id`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户岗位关系'; -- ---------------------------- -- Records of sys_user_post -- ---------------------------- -- ---------------------------- -- Table structure for `sys_user_token` -- ---------------------------- DROP TABLE IF EXISTS `sys_user_token`; CREATE TABLE `sys_user_token` ( `id` bigint(20) NOT NULL COMMENT 'id', `user_id` bigint(20) NOT NULL COMMENT '用户id', `token` varchar(100) NOT NULL COMMENT '用户token', `expire_date` datetime DEFAULT NULL COMMENT '过期时间', `update_date` datetime DEFAULT NULL COMMENT '更新时间', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), UNIQUE KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统用户Token'; -- ---------------------------- -- Records of sys_user_token -- ---------------------------- INSERT INTO `sys_user_token` VALUES ('1688802091666866178', '1067246875800000001', '3f3556faad90731f930bc279ebe90785', '2023-08-10 05:24:59', '2023-08-09 17:24:59', '2023-08-08 14:39:30'); INSERT INTO `sys_user_token` VALUES ('1688832709784064002', '1688832479013457922', '1d78c4d3d1b9ffd7300e0e94997faa6e', '2023-08-10 02:15:04', '2023-08-09 14:15:04', '2023-08-08 16:41:10'); INSERT INTO `sys_user_token` VALUES ('1689156110964781057', '1689152089323499521', 'aff727fc69b83d778696fb3231a2a97c', '2023-08-10 05:28:58', '2023-08-09 17:28:58', '2023-08-09 14:06:15'); INSERT INTO `sys_user_token` VALUES ('1689156782175055874', '1353943117220315138', '5053ace23188fc343dffc4fb55af635c', '2023-08-10 02:08:55', '2023-08-09 14:08:55', '2023-08-09 14:08:55'); -- ---------------------------- -- Table structure for `tb_token` -- ---------------------------- DROP TABLE IF EXISTS `tb_token`; CREATE TABLE `tb_token` ( `id` bigint(20) NOT NULL COMMENT 'id', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `token` varchar(100) NOT NULL COMMENT 'token', `expire_date` datetime DEFAULT NULL COMMENT '过期时间', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), UNIQUE KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户Token'; -- ---------------------------- -- Records of tb_token -- ---------------------------- -- ---------------------------- -- Table structure for `tb_user` -- ---------------------------- DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` bigint(20) NOT NULL COMMENT 'id', `username` varchar(50) NOT NULL COMMENT '用户名', `mobile` varchar(20) NOT NULL COMMENT '手机号', `password` varchar(64) DEFAULT NULL COMMENT '密码', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户'; -- ---------------------------- -- Records of tb_user -- ---------------------------- INSERT INTO `tb_user` VALUES ('1067246875900000001', 'mark', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2023-08-08 14:35:16');