/* Navicat MySQL Data Transfer Source Server : localhost Source Server Version : 50732 Source Host : localhost:3306 Source Database : wjp_project410 Target Server Type : MYSQL Target Server Version : 50732 File Encoding : 65001 Date: 2024-04-07 14:11:40 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `act_evt_log` -- ---------------------------- DROP TABLE IF EXISTS `act_evt_log`; CREATE TABLE `act_evt_log` ( `LOG_NR_` bigint(20) NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DATA_` longblob, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `IS_PROCESSED_` tinyint(4) DEFAULT '0', PRIMARY KEY (`LOG_NR_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_evt_log -- ---------------------------- -- ---------------------------- -- Table structure for `act_ge_bytearray` -- ---------------------------- DROP TABLE IF EXISTS `act_ge_bytearray`; CREATE TABLE `act_ge_bytearray` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `BYTES_` longblob, `GENERATED_` tinyint(4) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_FK_BYTEARR_DEPL` (`DEPLOYMENT_ID_`), CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ge_bytearray -- ---------------------------- -- ---------------------------- -- Table structure for `act_ge_property` -- ---------------------------- DROP TABLE IF EXISTS `act_ge_property`; CREATE TABLE `act_ge_property` ( `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, PRIMARY KEY (`NAME_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ge_property -- ---------------------------- INSERT INTO `act_ge_property` VALUES ('batch.schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('cfg.execution-related-entities-count', 'true', '1'); INSERT INTO `act_ge_property` VALUES ('cfg.task-related-entities-count', 'true', '1'); INSERT INTO `act_ge_property` VALUES ('common.schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('entitylink.schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('eventsubscription.schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('identitylink.schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('job.schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('next.dbid', '1', '1'); INSERT INTO `act_ge_property` VALUES ('schema.history', 'create(7.0.0.0)', '1'); INSERT INTO `act_ge_property` VALUES ('schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('task.schema.version', '7.0.0.0', '1'); INSERT INTO `act_ge_property` VALUES ('variable.schema.version', '7.0.0.0', '1'); -- ---------------------------- -- Table structure for `act_hi_actinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_actinst`; CREATE TABLE `act_hi_actinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `TRANSACTION_ORDER_` int(11) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_ACT_INST_START` (`START_TIME_`), KEY `ACT_IDX_HI_ACT_INST_END` (`END_TIME_`), KEY `ACT_IDX_HI_ACT_INST_PROCINST` (`PROC_INST_ID_`,`ACT_ID_`), KEY `ACT_IDX_HI_ACT_INST_EXEC` (`EXECUTION_ID_`,`ACT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_actinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_attachment` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_attachment`; CREATE TABLE `act_hi_attachment` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `URL_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CONTENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_attachment -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_comment` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_comment`; CREATE TABLE `act_hi_comment` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TIME_` datetime(3) NOT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACTION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `MESSAGE_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `FULL_MSG_` longblob, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_comment -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_detail` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_detail`; CREATE TABLE `act_hi_detail` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, `TIME_` datetime(3) NOT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_DETAIL_PROC_INST` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_DETAIL_ACT_INST` (`ACT_INST_ID_`), KEY `ACT_IDX_HI_DETAIL_TIME` (`TIME_`), KEY `ACT_IDX_HI_DETAIL_NAME` (`NAME_`), KEY `ACT_IDX_HI_DETAIL_TASK_ID` (`TASK_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_detail -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_entitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_entitylink`; CREATE TABLE `act_hi_entitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`,`ROOT_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_HI_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_entitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_identitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_identitylink`; CREATE TABLE `act_hi_identitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_IDENT_LNK_USER` (`USER_ID_`), KEY `ACT_IDX_HI_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_IDENT_LNK_TASK` (`TASK_ID_`), KEY `ACT_IDX_HI_IDENT_LNK_PROCINST` (`PROC_INST_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_identitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_procinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_procinst`; CREATE TABLE `act_hi_procinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `END_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUPER_PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BUSINESS_STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `PROC_INST_ID_` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_PRO_INST_END` (`END_TIME_`), KEY `ACT_IDX_HI_PRO_I_BUSKEY` (`BUSINESS_KEY_`), KEY `ACT_IDX_HI_PRO_SUPER_PROCINST` (`SUPER_PROCESS_INSTANCE_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_procinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_taskinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_taskinst`; CREATE TABLE `act_hi_taskinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `CLAIM_TIME_` datetime(3) DEFAULT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `PRIORITY_` int(11) DEFAULT NULL, `DUE_DATE_` datetime(3) DEFAULT NULL, `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_TASK_INST_PROCINST` (`PROC_INST_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_taskinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_tsk_log` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_tsk_log`; CREATE TABLE `act_hi_tsk_log` ( `ID_` bigint(20) NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `TIME_STAMP_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DATA_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_tsk_log -- ---------------------------- -- ---------------------------- -- Table structure for `act_hi_varinst` -- ---------------------------- DROP TABLE IF EXISTS `act_hi_varinst`; CREATE TABLE `act_hi_varinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(100) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `LAST_UPDATED_TIME_` datetime(3) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_HI_PROCVAR_NAME_TYPE` (`NAME_`,`VAR_TYPE_`), KEY `ACT_IDX_HI_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_HI_PROCVAR_PROC_INST` (`PROC_INST_ID_`), KEY `ACT_IDX_HI_PROCVAR_TASK_ID` (`TASK_ID_`), KEY `ACT_IDX_HI_PROCVAR_EXE` (`EXECUTION_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_hi_varinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_bytearray` -- ---------------------------- DROP TABLE IF EXISTS `act_id_bytearray`; CREATE TABLE `act_id_bytearray` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTES_` longblob, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_bytearray -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_group` -- ---------------------------- DROP TABLE IF EXISTS `act_id_group`; CREATE TABLE `act_id_group` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_group -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_info` -- ---------------------------- DROP TABLE IF EXISTS `act_id_info`; CREATE TABLE `act_id_info` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `USER_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PASSWORD_` longblob, `PARENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_info -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_membership` -- ---------------------------- DROP TABLE IF EXISTS `act_id_membership`; CREATE TABLE `act_id_membership` ( `USER_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(64) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`USER_ID_`,`GROUP_ID_`), KEY `ACT_FK_MEMB_GROUP` (`GROUP_ID_`), CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `act_id_group` (`ID_`), CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `act_id_user` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_membership -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_priv` -- ---------------------------- DROP TABLE IF EXISTS `act_id_priv`; CREATE TABLE `act_id_priv` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_PRIV_NAME` (`NAME_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_priv -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_priv_mapping` -- ---------------------------- DROP TABLE IF EXISTS `act_id_priv_mapping`; CREATE TABLE `act_id_priv_mapping` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PRIV_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_FK_PRIV_MAPPING` (`PRIV_ID_`), KEY `ACT_IDX_PRIV_USER` (`USER_ID_`), KEY `ACT_IDX_PRIV_GROUP` (`GROUP_ID_`), CONSTRAINT `ACT_FK_PRIV_MAPPING` FOREIGN KEY (`PRIV_ID_`) REFERENCES `act_id_priv` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_priv_mapping -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_property` -- ---------------------------- DROP TABLE IF EXISTS `act_id_property`; CREATE TABLE `act_id_property` ( `NAME_` varchar(64) COLLATE utf8_bin NOT NULL, `VALUE_` varchar(300) COLLATE utf8_bin DEFAULT NULL, `REV_` int(11) DEFAULT NULL, PRIMARY KEY (`NAME_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_property -- ---------------------------- INSERT INTO `act_id_property` VALUES ('schema.version', '7.0.0.0', '1'); -- ---------------------------- -- Table structure for `act_id_token` -- ---------------------------- DROP TABLE IF EXISTS `act_id_token`; CREATE TABLE `act_id_token` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TOKEN_VALUE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TOKEN_DATE_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3), `IP_ADDRESS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_AGENT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TOKEN_DATA_` varchar(2000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_token -- ---------------------------- -- ---------------------------- -- Table structure for `act_id_user` -- ---------------------------- DROP TABLE IF EXISTS `act_id_user`; CREATE TABLE `act_id_user` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `FIRST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LAST_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DISPLAY_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EMAIL_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PWD_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PICTURE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_id_user -- ---------------------------- -- ---------------------------- -- Table structure for `act_procdef_info` -- ---------------------------- DROP TABLE IF EXISTS `act_procdef_info`; CREATE TABLE `act_procdef_info` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `INFO_JSON_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_INFO_PROCDEF` (`PROC_DEF_ID_`), KEY `ACT_IDX_INFO_PROCDEF` (`PROC_DEF_ID_`), KEY `ACT_FK_INFO_JSON_BA` (`INFO_JSON_ID_`), CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_procdef_info -- ---------------------------- -- ---------------------------- -- Table structure for `act_re_deployment` -- ---------------------------- DROP TABLE IF EXISTS `act_re_deployment`; CREATE TABLE `act_re_deployment` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `DEPLOY_TIME_` timestamp(3) NULL DEFAULT NULL, `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PARENT_DEPLOYMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_re_deployment -- ---------------------------- -- ---------------------------- -- Table structure for `act_re_model` -- ---------------------------- DROP TABLE IF EXISTS `act_re_model`; CREATE TABLE `act_re_model` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `LAST_UPDATE_TIME_` timestamp(3) NULL DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EDITOR_SOURCE_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_FK_MODEL_SOURCE` (`EDITOR_SOURCE_VALUE_ID_`), KEY `ACT_FK_MODEL_SOURCE_EXTRA` (`EDITOR_SOURCE_EXTRA_VALUE_ID_`), KEY `ACT_FK_MODEL_DEPLOYMENT` (`DEPLOYMENT_ID_`), CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `act_re_deployment` (`ID_`), CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_re_model -- ---------------------------- -- ---------------------------- -- Table structure for `act_re_procdef` -- ---------------------------- DROP TABLE IF EXISTS `act_re_procdef`; CREATE TABLE `act_re_procdef` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `KEY_` varchar(255) COLLATE utf8_bin NOT NULL, `VERSION_` int(11) NOT NULL, `DEPLOYMENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DGRM_RESOURCE_NAME_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `HAS_START_FORM_KEY_` tinyint(4) DEFAULT NULL, `HAS_GRAPHICAL_NOTATION_` tinyint(4) DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `ENGINE_VERSION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_FROM_ROOT_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DERIVED_VERSION_` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_UNIQ_PROCDEF` (`KEY_`,`VERSION_`,`DERIVED_VERSION_`,`TENANT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_re_procdef -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_actinst` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_actinst`; CREATE TABLE `act_ru_actinst` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT '1', `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin NOT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin NOT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ACT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) NOT NULL, `END_TIME_` datetime(3) DEFAULT NULL, `DURATION_` bigint(20) DEFAULT NULL, `TRANSACTION_ORDER_` int(11) DEFAULT NULL, `DELETE_REASON_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_RU_ACTI_START` (`START_TIME_`), KEY `ACT_IDX_RU_ACTI_END` (`END_TIME_`), KEY `ACT_IDX_RU_ACTI_PROC` (`PROC_INST_ID_`), KEY `ACT_IDX_RU_ACTI_PROC_ACT` (`PROC_INST_ID_`,`ACT_ID_`), KEY `ACT_IDX_RU_ACTI_EXEC` (`EXECUTION_ID_`), KEY `ACT_IDX_RU_ACTI_EXEC_ACT` (`EXECUTION_ID_`,`ACT_ID_`), KEY `ACT_IDX_RU_ACTI_TASK` (`TASK_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_actinst -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_deadletter_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_deadletter_job`; CREATE TABLE `act_ru_deadletter_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_DEADLETTER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_DEADLETTER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_DEADLETTER_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_DJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_DJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_DJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_DEADLETTER_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_DEADLETTER_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_deadletter_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_entitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_entitylink`; CREATE TABLE `act_ru_entitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `LINK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REF_SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ROOT_SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HIERARCHY_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_ENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_REF_SCOPE` (`REF_SCOPE_ID_`,`REF_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_ROOT_SCOPE` (`ROOT_SCOPE_ID_`,`ROOT_SCOPE_TYPE_`,`LINK_TYPE_`), KEY `ACT_IDX_ENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`,`LINK_TYPE_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_entitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_event_subscr` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_event_subscr`; CREATE TABLE `act_ru_event_subscr` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `EVENT_TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EVENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACTIVITY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CONFIGURATION_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATED_` timestamp(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3), `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_EVENT_SUBSCR_CONFIG_` (`CONFIGURATION_`), KEY `ACT_IDX_EVENT_SUBSCR_SCOPEREF_` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_EVENT_EXEC` (`EXECUTION_ID_`), CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_event_subscr -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_execution` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_execution`; CREATE TABLE `act_ru_execution` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `BUSINESS_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUPER_EXEC_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ROOT_PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `IS_ACTIVE_` tinyint(4) DEFAULT NULL, `IS_CONCURRENT_` tinyint(4) DEFAULT NULL, `IS_SCOPE_` tinyint(4) DEFAULT NULL, `IS_EVENT_SCOPE_` tinyint(4) DEFAULT NULL, `IS_MI_ROOT_` tinyint(4) DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `CACHED_ENT_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_ACT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `START_TIME_` datetime(3) DEFAULT NULL, `START_USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `LOCK_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL, `EVT_SUBSCR_COUNT_` int(11) DEFAULT NULL, `TASK_COUNT_` int(11) DEFAULT NULL, `JOB_COUNT_` int(11) DEFAULT NULL, `TIMER_JOB_COUNT_` int(11) DEFAULT NULL, `SUSP_JOB_COUNT_` int(11) DEFAULT NULL, `DEADLETTER_JOB_COUNT_` int(11) DEFAULT NULL, `EXTERNAL_WORKER_JOB_COUNT_` int(11) DEFAULT NULL, `VAR_COUNT_` int(11) DEFAULT NULL, `ID_LINK_COUNT_` int(11) DEFAULT NULL, `CALLBACK_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CALLBACK_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `REFERENCE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BUSINESS_STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_EXEC_BUSKEY` (`BUSINESS_KEY_`), KEY `ACT_IDC_EXEC_ROOT` (`ROOT_PROC_INST_ID_`), KEY `ACT_IDX_EXEC_REF_ID_` (`REFERENCE_ID_`), KEY `ACT_FK_EXE_PROCINST` (`PROC_INST_ID_`), KEY `ACT_FK_EXE_PARENT` (`PARENT_ID_`), KEY `ACT_FK_EXE_SUPER` (`SUPER_EXEC_`), KEY `ACT_FK_EXE_PROCDEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE, CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`), CONSTRAINT `ACT_FK_EXE_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `ACT_FK_EXE_SUPER` FOREIGN KEY (`SUPER_EXEC_`) REFERENCES `act_ru_execution` (`ID_`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_execution -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_external_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_external_job`; CREATE TABLE `act_ru_external_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_EXTERNAL_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_EXTERNAL_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_EXTERNAL_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_EJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_EJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_EJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), CONSTRAINT `ACT_FK_EXTERNAL_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_EXTERNAL_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_external_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_history_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_history_job`; CREATE TABLE `act_ru_history_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ADV_HANDLER_CFG_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_history_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_identitylink` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_identitylink`; CREATE TABLE `act_ru_identitylink` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `GROUP_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `USER_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_IDENT_LNK_USER` (`USER_ID_`), KEY `ACT_IDX_IDENT_LNK_GROUP` (`GROUP_ID_`), KEY `ACT_IDX_IDENT_LNK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_IDENT_LNK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_IDENT_LNK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_ATHRZ_PROCEDEF` (`PROC_DEF_ID_`), KEY `ACT_FK_TSKASS_TASK` (`TASK_ID_`), KEY `ACT_FK_IDL_PROCINST` (`PROC_INST_ID_`), CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`), CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `act_ru_task` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_identitylink -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_job`; CREATE TABLE `act_ru_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_JOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_JOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_JOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_suspended_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_suspended_job`; CREATE TABLE `act_ru_suspended_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_SUSPENDED_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_SUSPENDED_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_SUSPENDED_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_SJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_SJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_SJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_SUSPENDED_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_SUSPENDED_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_suspended_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_task` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_task`; CREATE TABLE `act_ru_task` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PROPAGATED_STAGE_INST_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DESCRIPTION_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ASSIGNEE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `DELEGATION_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PRIORITY_` int(11) DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `DUE_DATE_` datetime(3) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUSPENSION_STATE_` int(11) DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', `FORM_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CLAIM_TIME_` datetime(3) DEFAULT NULL, `IS_COUNT_ENABLED_` tinyint(4) DEFAULT NULL, `VAR_COUNT_` int(11) DEFAULT NULL, `ID_LINK_COUNT_` int(11) DEFAULT NULL, `SUB_TASK_COUNT_` int(11) DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_TASK_CREATE` (`CREATE_TIME_`), KEY `ACT_IDX_TASK_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TASK_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TASK_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_TASK_EXE` (`EXECUTION_ID_`), KEY `ACT_FK_TASK_PROCINST` (`PROC_INST_ID_`), KEY `ACT_FK_TASK_PROCDEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`), CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_task -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_timer_job` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_timer_job`; CREATE TABLE `act_ru_timer_job` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `CATEGORY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp(3) NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `EXCLUSIVE_` tinyint(1) DEFAULT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_DEF_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `ELEMENT_NAME_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_DEFINITION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CORRELATION_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RETRIES_` int(11) DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `DUEDATE_` timestamp(3) NULL DEFAULT NULL, `REPEAT_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `HANDLER_CFG_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `CUSTOM_VALUES_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` timestamp(3) NULL DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `ACT_IDX_TIMER_JOB_EXCEPTION_STACK_ID` (`EXCEPTION_STACK_ID_`), KEY `ACT_IDX_TIMER_JOB_CUSTOM_VALUES_ID` (`CUSTOM_VALUES_ID_`), KEY `ACT_IDX_TIMER_JOB_CORRELATION_ID` (`CORRELATION_ID_`), KEY `ACT_IDX_TIMER_JOB_DUEDATE` (`DUEDATE_`), KEY `ACT_IDX_TJOB_SCOPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TJOB_SUB_SCOPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_TJOB_SCOPE_DEF` (`SCOPE_DEFINITION_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_TIMER_JOB_EXECUTION` (`EXECUTION_ID_`), KEY `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` (`PROCESS_INSTANCE_ID_`), KEY `ACT_FK_TIMER_JOB_PROC_DEF` (`PROC_DEF_ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_CUSTOM_VALUES` FOREIGN KEY (`CUSTOM_VALUES_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `act_re_procdef` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_timer_job -- ---------------------------- -- ---------------------------- -- Table structure for `act_ru_variable` -- ---------------------------- DROP TABLE IF EXISTS `act_ru_variable`; CREATE TABLE `act_ru_variable` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TYPE_` varchar(255) COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `PROC_INST_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TASK_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `DOUBLE_` double DEFAULT NULL, `LONG_` bigint(20) DEFAULT NULL, `TEXT_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `TEXT2_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, `META_INFO_` varchar(4000) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`ID_`), KEY `ACT_IDX_RU_VAR_SCOPE_ID_TYPE` (`SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_IDX_RU_VAR_SUB_ID_TYPE` (`SUB_SCOPE_ID_`,`SCOPE_TYPE_`), KEY `ACT_FK_VAR_BYTEARRAY` (`BYTEARRAY_ID_`), KEY `ACT_IDX_VARIABLE_TASK_ID` (`TASK_ID_`), KEY `ACT_FK_VAR_EXE` (`EXECUTION_ID_`), KEY `ACT_FK_VAR_PROCINST` (`PROC_INST_ID_`), CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `act_ge_bytearray` (`ID_`), CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `act_ru_execution` (`ID_`), CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `act_ru_execution` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of act_ru_variable -- ---------------------------- -- ---------------------------- -- Table structure for `bpm_definition_ext` -- ---------------------------- DROP TABLE IF EXISTS `bpm_definition_ext`; CREATE TABLE `bpm_definition_ext` ( `id` bigint(20) NOT NULL COMMENT 'id', `model_id` varchar(64) DEFAULT NULL COMMENT '模型ID', `process_definition_id` varchar(64) DEFAULT NULL COMMENT '流程定义ID', `form_type` varchar(64) DEFAULT NULL COMMENT '表单类型', `form_id` varchar(500) DEFAULT NULL COMMENT '表单ID', `form_content` text COMMENT '表单内容', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程定义扩展'; -- ---------------------------- -- Records of bpm_definition_ext -- ---------------------------- -- ---------------------------- -- Table structure for `bpm_form` -- ---------------------------- DROP TABLE IF EXISTS `bpm_form`; CREATE TABLE `bpm_form` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(50) DEFAULT NULL COMMENT '名称', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `content` text COMMENT '表单内容', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程表单'; -- ---------------------------- -- Records of bpm_form -- ---------------------------- -- ---------------------------- -- Table structure for `bpm_form_correction` -- ---------------------------- DROP TABLE IF EXISTS `bpm_form_correction`; CREATE TABLE `bpm_form_correction` ( `id` bigint(20) NOT NULL COMMENT 'id', `apply_post` varchar(255) DEFAULT NULL COMMENT '申请岗位', `entry_date` datetime DEFAULT NULL COMMENT '入职日期', `correction_date` datetime DEFAULT NULL COMMENT '转正日期', `work_content` varchar(2000) DEFAULT NULL COMMENT '工作内容', `achievement` varchar(2000) DEFAULT NULL COMMENT '工作成绩', `instance_id` varchar(80) DEFAULT NULL COMMENT '实例ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='自定义表单(转正申请)'; -- ---------------------------- -- Records of bpm_form_correction -- ---------------------------- -- ---------------------------- -- Table structure for `bpm_instance_ext` -- ---------------------------- DROP TABLE IF EXISTS `bpm_instance_ext`; CREATE TABLE `bpm_instance_ext` ( `id` bigint(20) NOT NULL COMMENT 'id', `process_instance_id` varchar(64) DEFAULT NULL COMMENT '流程实例ID', `process_definition_id` varchar(64) DEFAULT NULL COMMENT '流程定义ID', `form_variables` varchar(4000) DEFAULT NULL COMMENT '表单值', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='流程实例扩展'; -- ---------------------------- -- Records of bpm_instance_ext -- ---------------------------- -- ---------------------------- -- Table structure for `flw_channel_definition` -- ---------------------------- DROP TABLE IF EXISTS `flw_channel_definition`; CREATE TABLE `flw_channel_definition` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `KEY_` varchar(255) DEFAULT NULL, `CATEGORY_` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, `CREATE_TIME_` datetime(3) DEFAULT NULL, `TENANT_ID_` varchar(255) DEFAULT NULL, `RESOURCE_NAME_` varchar(255) DEFAULT NULL, `DESCRIPTION_` varchar(255) DEFAULT NULL, `TYPE_` varchar(255) DEFAULT NULL, `IMPLEMENTATION_` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_IDX_CHANNEL_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_channel_definition -- ---------------------------- -- ---------------------------- -- Table structure for `flw_event_definition` -- ---------------------------- DROP TABLE IF EXISTS `flw_event_definition`; CREATE TABLE `flw_event_definition` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `VERSION_` int(11) DEFAULT NULL, `KEY_` varchar(255) DEFAULT NULL, `CATEGORY_` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, `TENANT_ID_` varchar(255) DEFAULT NULL, `RESOURCE_NAME_` varchar(255) DEFAULT NULL, `DESCRIPTION_` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID_`), UNIQUE KEY `ACT_IDX_EVENT_DEF_UNIQ` (`KEY_`,`VERSION_`,`TENANT_ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_event_definition -- ---------------------------- -- ---------------------------- -- Table structure for `flw_event_deployment` -- ---------------------------- DROP TABLE IF EXISTS `flw_event_deployment`; CREATE TABLE `flw_event_deployment` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `CATEGORY_` varchar(255) DEFAULT NULL, `DEPLOY_TIME_` datetime(3) DEFAULT NULL, `TENANT_ID_` varchar(255) DEFAULT NULL, `PARENT_DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_event_deployment -- ---------------------------- -- ---------------------------- -- Table structure for `flw_event_resource` -- ---------------------------- DROP TABLE IF EXISTS `flw_event_resource`; CREATE TABLE `flw_event_resource` ( `ID_` varchar(255) NOT NULL, `NAME_` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID_` varchar(255) DEFAULT NULL, `RESOURCE_BYTES_` longblob, PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_event_resource -- ---------------------------- -- ---------------------------- -- Table structure for `flw_ev_databasechangelog` -- ---------------------------- DROP TABLE IF EXISTS `flw_ev_databasechangelog`; CREATE TABLE `flw_ev_databasechangelog` ( `ID` varchar(255) NOT NULL, `AUTHOR` varchar(255) NOT NULL, `FILENAME` varchar(255) NOT NULL, `DATEEXECUTED` datetime NOT NULL, `ORDEREXECUTED` int(11) NOT NULL, `EXECTYPE` varchar(10) NOT NULL, `MD5SUM` varchar(35) DEFAULT NULL, `DESCRIPTION` varchar(255) DEFAULT NULL, `COMMENTS` varchar(255) DEFAULT NULL, `TAG` varchar(255) DEFAULT NULL, `LIQUIBASE` varchar(20) DEFAULT NULL, `CONTEXTS` varchar(255) DEFAULT NULL, `LABELS` varchar(255) DEFAULT NULL, `DEPLOYMENT_ID` varchar(10) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_ev_databasechangelog -- ---------------------------- INSERT INTO `flw_ev_databasechangelog` VALUES ('1', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-04-07 11:59:17', '1', 'EXECUTED', '9:63268f536c469325acef35970312551b', 'createTable tableName=FLW_EVENT_DEPLOYMENT; createTable tableName=FLW_EVENT_RESOURCE; createTable tableName=FLW_EVENT_DEFINITION; createIndex indexName=ACT_IDX_EVENT_DEF_UNIQ, tableName=FLW_EVENT_DEFINITION; createTable tableName=FLW_CHANNEL_DEFIN...', '', null, '4.24.0', null, null, '2462357105'); INSERT INTO `flw_ev_databasechangelog` VALUES ('2', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-04-07 11:59:17', '2', 'EXECUTED', '9:dcb58b7dfd6dbda66939123a96985536', 'addColumn tableName=FLW_CHANNEL_DEFINITION; addColumn tableName=FLW_CHANNEL_DEFINITION', '', null, '4.24.0', null, null, '2462357105'); INSERT INTO `flw_ev_databasechangelog` VALUES ('3', 'flowable', 'org/flowable/eventregistry/db/liquibase/flowable-eventregistry-db-changelog.xml', '2024-04-07 11:59:17', '3', 'EXECUTED', '9:d0c05678d57af23ad93699991e3bf4f6', 'customChange', '', null, '4.24.0', null, null, '2462357105'); -- ---------------------------- -- Table structure for `flw_ev_databasechangeloglock` -- ---------------------------- DROP TABLE IF EXISTS `flw_ev_databasechangeloglock`; CREATE TABLE `flw_ev_databasechangeloglock` ( `ID` int(11) NOT NULL, `LOCKED` tinyint(1) NOT NULL, `LOCKGRANTED` datetime DEFAULT NULL, `LOCKEDBY` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flw_ev_databasechangeloglock -- ---------------------------- INSERT INTO `flw_ev_databasechangeloglock` VALUES ('1', '0', null, null); -- ---------------------------- -- Table structure for `flw_ru_batch` -- ---------------------------- DROP TABLE IF EXISTS `flw_ru_batch`; CREATE TABLE `flw_ru_batch` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL, `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) NOT NULL, `COMPLETE_TIME_` datetime(3) DEFAULT NULL, `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `BATCH_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of flw_ru_batch -- ---------------------------- -- ---------------------------- -- Table structure for `flw_ru_batch_part` -- ---------------------------- DROP TABLE IF EXISTS `flw_ru_batch_part`; CREATE TABLE `flw_ru_batch_part` ( `ID_` varchar(64) COLLATE utf8_bin NOT NULL, `REV_` int(11) DEFAULT NULL, `BATCH_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TYPE_` varchar(64) COLLATE utf8_bin NOT NULL, `SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SUB_SCOPE_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SCOPE_TYPE_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `SEARCH_KEY2_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `CREATE_TIME_` datetime(3) NOT NULL, `COMPLETE_TIME_` datetime(3) DEFAULT NULL, `STATUS_` varchar(255) COLLATE utf8_bin DEFAULT NULL, `RESULT_DOC_ID_` varchar(64) COLLATE utf8_bin DEFAULT NULL, `TENANT_ID_` varchar(255) COLLATE utf8_bin DEFAULT '', PRIMARY KEY (`ID_`), KEY `FLW_IDX_BATCH_PART` (`BATCH_ID_`), CONSTRAINT `FLW_FK_BATCH_PART_PARENT` FOREIGN KEY (`BATCH_ID_`) REFERENCES `flw_ru_batch` (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; -- ---------------------------- -- Records of flw_ru_batch_part -- ---------------------------- -- ---------------------------- -- Table structure for `gen_base_class` -- ---------------------------- DROP TABLE IF EXISTS `gen_base_class`; CREATE TABLE `gen_base_class` ( `id` bigint(20) NOT NULL COMMENT 'id', `package_name` varchar(200) DEFAULT NULL COMMENT '基类包名', `code` varchar(200) DEFAULT NULL COMMENT '基类编码', `fields` varchar(500) DEFAULT NULL COMMENT '基类字段，多个用英文逗号分隔', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='基类管理'; -- ---------------------------- -- Records of gen_base_class -- ---------------------------- INSERT INTO `gen_base_class` VALUES ('1302875019642159105', '${package}.common.entity.BaseEntity', 'BaseEntity', 'id,creator,create_date', '专业版', '2024-04-07 11:49:42'); -- ---------------------------- -- Table structure for `gen_datasource` -- ---------------------------- DROP TABLE IF EXISTS `gen_datasource`; CREATE TABLE `gen_datasource` ( `id` bigint(20) NOT NULL COMMENT 'id', `db_type` varchar(200) DEFAULT NULL COMMENT '数据库类型 MySQL、Oracle、SQLServer、PostgreSQL', `conn_name` varchar(200) NOT NULL COMMENT '连接名', `conn_url` varchar(500) DEFAULT NULL COMMENT 'URL', `username` varchar(200) DEFAULT NULL COMMENT '用户名', `password` varchar(200) DEFAULT NULL COMMENT '密码', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：启用 1：禁用', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='数据源管理'; -- ---------------------------- -- Records of gen_datasource -- ---------------------------- INSERT INTO `gen_datasource` VALUES ('1302855887882412034', 'MySQL', '本地', 'jdbc:mysql://localhost:3306/wjp_project?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true', 'root', '123456', '0', '2024-04-07 11:49:42'); -- ---------------------------- -- Table structure for `gen_field_type` -- ---------------------------- DROP TABLE IF EXISTS `gen_field_type`; CREATE TABLE `gen_field_type` ( `id` bigint(20) NOT NULL COMMENT 'id', `column_type` varchar(200) DEFAULT NULL COMMENT '字段类型', `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型', `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `column_type` (`column_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字段类型管理'; -- ---------------------------- -- Records of gen_field_type -- ---------------------------- INSERT INTO `gen_field_type` VALUES ('1152452777352425473', 'datetime', 'Date', 'java.util.Date', '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453412995002369', 'date', 'Date', 'java.util.Date', '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453603525455873', 'tinyint', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453660052090881', 'smallint', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453722136178689', 'mediumint', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453808874385409', 'int', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453849735294977', 'integer', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453895029583873', 'bigint', 'Long', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453931373228033', 'float', 'Float', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152453967880450050', 'double', 'Double', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454047601586177', 'decimal', 'BigDecimal', 'java.math.BigDecimal', '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454090760974338', 'bit', 'Boolean', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454147010785282', 'char', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454183136325633', 'varchar', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454312664821761', 'tinytext', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454343820111874', 'text', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454372077137921', 'mediumtext', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454401378545665', 'longtext', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454486267064322', 'timestamp', 'Date', 'java.util.Date', '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454630295269378', 'NUMBER', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454715645161474', 'BINARY_INTEGER', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454778828156930', 'BINARY_FLOAT', 'Float', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454828987838466', 'BINARY_DOUBLE', 'Double', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454885745160193', 'VARCHAR2', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454919756771329', 'NVARCHAR', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454952568811521', 'NVARCHAR2', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152454986349735938', 'CLOB', 'String', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152455109695827970', 'int8', 'Long', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152455153002016770', 'int4', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152455184669011969', 'int2', 'Integer', null, '2024-04-07 11:49:42'); INSERT INTO `gen_field_type` VALUES ('1152455217359417345', 'numeric', 'BigDecimal', 'java.math.BigDecimal', '2024-04-07 11:49:42'); -- ---------------------------- -- Table structure for `gen_table_field` -- ---------------------------- DROP TABLE IF EXISTS `gen_table_field`; CREATE TABLE `gen_table_field` ( `id` bigint(20) NOT NULL COMMENT 'id', `table_id` bigint(20) DEFAULT NULL COMMENT '表ID', `table_name` varchar(200) DEFAULT NULL COMMENT '表名', `column_name` varchar(200) DEFAULT NULL COMMENT '列名', `column_type` varchar(200) DEFAULT NULL COMMENT '类型', `column_comment` varchar(200) DEFAULT NULL COMMENT '列说明', `attr_name` varchar(200) DEFAULT NULL COMMENT '属性名', `attr_type` varchar(200) DEFAULT NULL COMMENT '属性类型', `package_name` varchar(200) DEFAULT NULL COMMENT '属性包名', `is_pk` tinyint(4) DEFAULT NULL COMMENT '是否主键 0：否 1：是', `is_required` tinyint(4) DEFAULT NULL COMMENT '是否必填 0：否 1：是', `is_form` tinyint(4) DEFAULT NULL COMMENT '是否表单字段 0：否 1：是', `is_list` tinyint(4) DEFAULT NULL COMMENT '是否列表字段 0：否 1：是', `is_query` tinyint(4) DEFAULT NULL COMMENT '是否查询字段 0：否 1：是', `query_type` varchar(200) DEFAULT NULL COMMENT '查询方式', `form_type` varchar(200) DEFAULT NULL COMMENT '表单类型', `dict_name` varchar(200) DEFAULT NULL COMMENT '字典名称', `validator_type` varchar(200) DEFAULT NULL COMMENT '效验方式', `sort` int(11) DEFAULT NULL COMMENT '排序', PRIMARY KEY (`id`), KEY `table_name` (`table_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表列'; -- ---------------------------- -- Records of gen_table_field -- ---------------------------- INSERT INTO `gen_table_field` VALUES ('1308327671502385153', '1308327671447859201', 'gen_test_data', 'id', 'BIGINT', 'id', 'id', 'Long', null, '1', '0', '0', '0', '0', '=', 'text', null, null, '0'); INSERT INTO `gen_table_field` VALUES ('1308327671510773761', '1308327671447859201', 'gen_test_data', 'username', 'VARCHAR', '用户名', 'username', 'String', null, '0', '1', '1', '1', '1', 'like', 'text', null, null, '1'); INSERT INTO `gen_table_field` VALUES ('1308327671510773762', '1308327671447859201', 'gen_test_data', 'real_name', 'VARCHAR', '姓名', 'realName', 'String', null, '0', '1', '1', '1', '0', 'like', 'text', null, null, '2'); INSERT INTO `gen_table_field` VALUES ('1308327671510773763', '1308327671447859201', 'gen_test_data', 'gender', 'TINYINT', '性别', 'gender', 'Integer', null, '0', '1', '1', '1', '1', '=', 'select', 'gender', null, '3'); INSERT INTO `gen_table_field` VALUES ('1308327671510773764', '1308327671447859201', 'gen_test_data', 'email', 'VARCHAR', '邮箱', 'email', 'String', null, '0', '1', '1', '1', '0', '=', 'text', null, null, '4'); INSERT INTO `gen_table_field` VALUES ('1308327671514968065', '1308327671447859201', 'gen_test_data', 'notice_type', 'TINYINT', '类型', 'noticeType', 'Integer', null, '0', '1', '1', '1', '0', '=', 'radio', 'notice_type', null, '5'); INSERT INTO `gen_table_field` VALUES ('1308327671514968066', '1308327671447859201', 'gen_test_data', 'content', 'TEXT', '内容', 'content', 'String', null, '0', '1', '1', '0', '0', '=', 'editor', null, null, '6'); INSERT INTO `gen_table_field` VALUES ('1308327671514968067', '1308327671447859201', 'gen_test_data', 'creator', 'BIGINT', '创建者', 'creator', 'Long', null, '0', '0', '0', '0', '0', '=', 'text', null, null, '7'); INSERT INTO `gen_table_field` VALUES ('1308327671514968068', '1308327671447859201', 'gen_test_data', 'create_date', 'DATETIME', '创建时间', 'createDate', 'Date', 'java.util.Date', '0', '0', '0', '1', '1', '=', 'date', null, null, '8'); INSERT INTO `gen_table_field` VALUES ('1308327671514968069', '1308327671447859201', 'gen_test_data', 'updater', 'BIGINT', '更新者', 'updater', 'Long', null, '0', '0', '0', '0', '0', '=', 'text', null, null, '9'); INSERT INTO `gen_table_field` VALUES ('1308327671523356674', '1308327671447859201', 'gen_test_data', 'update_date', 'DATETIME', '更新时间', 'updateDate', 'Date', 'java.util.Date', '0', '0', '0', '0', '0', '=', 'text', null, null, '10'); -- ---------------------------- -- Table structure for `gen_table_info` -- ---------------------------- DROP TABLE IF EXISTS `gen_table_info`; CREATE TABLE `gen_table_info` ( `id` bigint(20) NOT NULL COMMENT 'id', `table_name` varchar(200) DEFAULT NULL COMMENT '表名', `class_name` varchar(200) DEFAULT NULL COMMENT '类名', `table_comment` varchar(200) DEFAULT NULL COMMENT '功能名', `author` varchar(200) DEFAULT NULL COMMENT '作者', `email` varchar(200) DEFAULT NULL COMMENT '邮箱', `package_name` varchar(200) DEFAULT NULL COMMENT '项目包名', `version` varchar(200) DEFAULT NULL COMMENT '项目版本号', `backend_path` varchar(500) DEFAULT NULL COMMENT '后端生成路径', `frontend_path` varchar(500) DEFAULT NULL COMMENT '前端生成路径', `module_name` varchar(200) DEFAULT NULL COMMENT '模块名', `sub_module_name` varchar(200) DEFAULT NULL COMMENT '子模块名', `datasource_id` bigint(20) DEFAULT NULL COMMENT '数据源ID', `baseclass_id` bigint(20) DEFAULT NULL COMMENT '基类ID', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `table_name` (`table_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='代码生成表'; -- ---------------------------- -- Records of gen_table_info -- ---------------------------- INSERT INTO `gen_table_info` VALUES ('1308327671447859201', 'gen_test_data', 'TestData', '测试功能', 'Toby', 'javatangbin@163.com', 'com.wjp', '3.0', 'D:\\code\\wjp-project\\wjp-admin', 'D:\\code\\wjp-project-admin', 'gen', null, '0', '1302875019642159105', '2024-04-07 11:49:42'); -- ---------------------------- -- Table structure for `gen_template` -- ---------------------------- DROP TABLE IF EXISTS `gen_template`; CREATE TABLE `gen_template` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(200) DEFAULT NULL COMMENT '名称', `file_name` varchar(200) DEFAULT NULL COMMENT '文件名', `content` mediumtext NOT NULL COMMENT '内容', `path` varchar(500) DEFAULT NULL COMMENT '生成路径', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：启用 1：禁用', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='模板管理'; -- ---------------------------- -- Records of gen_template -- ---------------------------- INSERT INTO `gen_template` VALUES ('1144564443498168321', 'Entity.java', '${ClassName}Entity.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/entity/${subModuleName!}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1151104918417948674', 'Dao.java', '${ClassName}Dao.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dao/${subModuleName!}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1222102542519422977', 'Dao.xml', '${ClassName}Dao.xml', '', '${backendPath}/src/main/resources/mapper/${moduleName}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1222811087900602369', 'Service.java', '${ClassName}Service.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1222811738672033793', 'ServiceImpl.java', '${ClassName}ServiceImpl.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/service/${subModuleName!}/impl', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1222814109661753346', 'Excel.java', '${ClassName}Excel.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/excel/${subModuleName!}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1222816187301851138', 'DTO.java', '${ClassName}DTO.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/dto/${subModuleName!}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1222817622663983106', 'Controller.java', '${ClassName}Controller.java', '', '${backendPath}/src/main/java/${packagePath}/modules/${moduleName}/controller/${subModuleName!}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1304292858898309122', 'list.vue', '${classname}.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2024-04-07 11:49:42'); INSERT INTO `gen_template` VALUES ('1304293015698169857', 'add-or-update.vue', '${classname}-add-or-update.vue', '', '${frontendPath}/src/views/${moduleName}', '0', '2024-04-07 11:49:42'); -- ---------------------------- -- Table structure for `gen_test_data` -- ---------------------------- DROP TABLE IF EXISTS `gen_test_data`; CREATE TABLE `gen_test_data` ( `id` bigint(20) NOT NULL COMMENT 'id', `username` varchar(50) DEFAULT NULL COMMENT '用户名', `real_name` varchar(50) DEFAULT NULL COMMENT '姓名', `gender` tinyint(3) unsigned DEFAULT NULL COMMENT '性别', `email` varchar(100) DEFAULT NULL COMMENT '邮箱', `notice_type` tinyint(4) DEFAULT NULL COMMENT '类型', `content` text COMMENT '内容', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='测试功能'; -- ---------------------------- -- Records of gen_test_data -- ---------------------------- INSERT INTO `gen_test_data` VALUES ('1067246875800000001', 'toby', 'Toby', '0', 'root@scjydz.com', '0', '

代码生成器！

', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); -- ---------------------------- -- Table structure for `mp_account` -- ---------------------------- DROP TABLE IF EXISTS `mp_account`; CREATE TABLE `mp_account` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(100) DEFAULT NULL COMMENT '名称', `app_id` varchar(100) DEFAULT NULL COMMENT 'AppID', `app_secret` varchar(100) DEFAULT NULL COMMENT 'AppSecret', `token` varchar(100) DEFAULT NULL COMMENT 'Token', `aes_key` varchar(100) DEFAULT NULL COMMENT 'EncodingAESKey', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='公众号账号管理'; -- ---------------------------- -- Records of mp_account -- ---------------------------- -- ---------------------------- -- Table structure for `mp_menu` -- ---------------------------- DROP TABLE IF EXISTS `mp_menu`; CREATE TABLE `mp_menu` ( `id` bigint(20) NOT NULL COMMENT 'id', `menu` varchar(2000) DEFAULT NULL COMMENT '菜单json数据', `app_id` varchar(100) DEFAULT NULL COMMENT 'AppID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_app_id` (`app_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='公众号自定义菜单'; -- ---------------------------- -- Records of mp_menu -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_blob_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_blob_triggers`; CREATE TABLE `qrtz_blob_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `BLOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `SCHED_NAME` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_blob_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_calendars` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_calendars`; CREATE TABLE `qrtz_calendars` ( `SCHED_NAME` varchar(120) NOT NULL, `CALENDAR_NAME` varchar(200) NOT NULL, `CALENDAR` blob NOT NULL, PRIMARY KEY (`SCHED_NAME`,`CALENDAR_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_calendars -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_cron_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_cron_triggers`; CREATE TABLE `qrtz_cron_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `CRON_EXPRESSION` varchar(120) NOT NULL, `TIME_ZONE_ID` varchar(80) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_cron_triggers -- ---------------------------- INSERT INTO `qrtz_cron_triggers` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', '0 0/30 * * * ?', 'Asia/Shanghai'); -- ---------------------------- -- Table structure for `qrtz_fired_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_fired_triggers`; CREATE TABLE `qrtz_fired_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `ENTRY_ID` varchar(95) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `INSTANCE_NAME` varchar(200) NOT NULL, `FIRED_TIME` bigint(13) NOT NULL, `SCHED_TIME` bigint(13) NOT NULL, `PRIORITY` int(11) NOT NULL, `STATE` varchar(16) NOT NULL, `JOB_NAME` varchar(200) DEFAULT NULL, `JOB_GROUP` varchar(200) DEFAULT NULL, `IS_NONCONCURRENT` varchar(1) DEFAULT NULL, `REQUESTS_RECOVERY` varchar(1) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`ENTRY_ID`), KEY `IDX_QRTZ_FT_TRIG_INST_NAME` (`SCHED_NAME`,`INSTANCE_NAME`), KEY `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME`,`INSTANCE_NAME`,`REQUESTS_RECOVERY`), KEY `IDX_QRTZ_FT_J_G` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_FT_JG` (`SCHED_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_FT_T_G` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_FT_TG` (`SCHED_NAME`,`TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_fired_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_job_details` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_job_details`; CREATE TABLE `qrtz_job_details` ( `SCHED_NAME` varchar(120) NOT NULL, `JOB_NAME` varchar(200) NOT NULL, `JOB_GROUP` varchar(200) NOT NULL, `DESCRIPTION` varchar(250) DEFAULT NULL, `JOB_CLASS_NAME` varchar(250) NOT NULL, `IS_DURABLE` varchar(1) NOT NULL, `IS_NONCONCURRENT` varchar(1) NOT NULL, `IS_UPDATE_DATA` varchar(1) NOT NULL, `REQUESTS_RECOVERY` varchar(1) NOT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_J_REQ_RECOVERY` (`SCHED_NAME`,`REQUESTS_RECOVERY`), KEY `IDX_QRTZ_J_GRP` (`SCHED_NAME`,`JOB_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_job_details -- ---------------------------- INSERT INTO `qrtz_job_details` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', null, 'com.wjp.modules.job.utils.ScheduleJob', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D4A4F425F504152414D5F4B45597372002E696F2E72656E72656E2E6D6F64756C65732E6A6F622E656E746974792E5363686564756C654A6F62456E7469747900000000000000010200074C00086265616E4E616D657400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C0006706172616D7371007E00094C000672656D61726B71007E00094C00067374617475737400134C6A6176612F6C616E672F496E74656765723B4C000A757064617465446174657400104C6A6176612F7574696C2F446174653B4C0007757064617465727400104C6A6176612F6C616E672F4C6F6E673B78720022696F2E72656E72656E2E636F6D6D6F6E2E656E746974792E42617365456E74697479FB83923222FF87B90200034C000A6372656174654461746571007E000B4C000763726561746F7271007E000C4C0002696471007E000C78707372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018EB6AC3190787372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700ECF9F6107B456017371007E00110ECF9F6107B4564C740008746573745461736B74000E3020302F3330202A202A202A203F74000672656E72656E740025E69C89E58F82E6B58BE8AF95EFBC8CE5A49AE4B8AAE58F82E695B0E4BDBFE794A86A736F6E737200116A6176612E6C616E672E496E746567657212E2A0A4F781873802000149000576616C75657871007E0012000000007371007E000F77080000018EB6AC3190787371007E00110ECF9F6107B456017800); -- ---------------------------- -- Table structure for `qrtz_locks` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_locks`; CREATE TABLE `qrtz_locks` ( `SCHED_NAME` varchar(120) NOT NULL, `LOCK_NAME` varchar(40) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`LOCK_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_locks -- ---------------------------- INSERT INTO `qrtz_locks` VALUES ('WjpScheduler', 'STATE_ACCESS'); INSERT INTO `qrtz_locks` VALUES ('WjpScheduler', 'TRIGGER_ACCESS'); -- ---------------------------- -- Table structure for `qrtz_paused_trigger_grps` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`; CREATE TABLE `qrtz_paused_trigger_grps` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_paused_trigger_grps -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_scheduler_state` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_scheduler_state`; CREATE TABLE `qrtz_scheduler_state` ( `SCHED_NAME` varchar(120) NOT NULL, `INSTANCE_NAME` varchar(200) NOT NULL, `LAST_CHECKIN_TIME` bigint(13) NOT NULL, `CHECKIN_INTERVAL` bigint(13) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`INSTANCE_NAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_scheduler_state -- ---------------------------- INSERT INTO `qrtz_scheduler_state` VALUES ('WjpScheduler', 'DESKTOP-KIOOR1712462353322', '1712468647706', '15000'); INSERT INTO `qrtz_scheduler_state` VALUES ('WjpScheduler', 'DESKTOP-KIOOR1712468918453', '1712470293177', '15000'); -- ---------------------------- -- Table structure for `qrtz_simple_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simple_triggers`; CREATE TABLE `qrtz_simple_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `REPEAT_COUNT` bigint(7) NOT NULL, `REPEAT_INTERVAL` bigint(12) NOT NULL, `TIMES_TRIGGERED` bigint(10) NOT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_simple_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_simprop_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_simprop_triggers`; CREATE TABLE `qrtz_simprop_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `STR_PROP_1` varchar(512) DEFAULT NULL, `STR_PROP_2` varchar(512) DEFAULT NULL, `STR_PROP_3` varchar(512) DEFAULT NULL, `INT_PROP_1` int(11) DEFAULT NULL, `INT_PROP_2` int(11) DEFAULT NULL, `LONG_PROP_1` bigint(20) DEFAULT NULL, `LONG_PROP_2` bigint(20) DEFAULT NULL, `DEC_PROP_1` decimal(13,4) DEFAULT NULL, `DEC_PROP_2` decimal(13,4) DEFAULT NULL, `BOOL_PROP_1` varchar(1) DEFAULT NULL, `BOOL_PROP_2` varchar(1) DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_simprop_triggers -- ---------------------------- -- ---------------------------- -- Table structure for `qrtz_triggers` -- ---------------------------- DROP TABLE IF EXISTS `qrtz_triggers`; CREATE TABLE `qrtz_triggers` ( `SCHED_NAME` varchar(120) NOT NULL, `TRIGGER_NAME` varchar(200) NOT NULL, `TRIGGER_GROUP` varchar(200) NOT NULL, `JOB_NAME` varchar(200) NOT NULL, `JOB_GROUP` varchar(200) NOT NULL, `DESCRIPTION` varchar(250) DEFAULT NULL, `NEXT_FIRE_TIME` bigint(13) DEFAULT NULL, `PREV_FIRE_TIME` bigint(13) DEFAULT NULL, `PRIORITY` int(11) DEFAULT NULL, `TRIGGER_STATE` varchar(16) NOT NULL, `TRIGGER_TYPE` varchar(8) NOT NULL, `START_TIME` bigint(13) NOT NULL, `END_TIME` bigint(13) DEFAULT NULL, `CALENDAR_NAME` varchar(200) DEFAULT NULL, `MISFIRE_INSTR` smallint(2) DEFAULT NULL, `JOB_DATA` blob, PRIMARY KEY (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_T_J` (`SCHED_NAME`,`JOB_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_T_JG` (`SCHED_NAME`,`JOB_GROUP`), KEY `IDX_QRTZ_T_C` (`SCHED_NAME`,`CALENDAR_NAME`), KEY `IDX_QRTZ_T_G` (`SCHED_NAME`,`TRIGGER_GROUP`), KEY `IDX_QRTZ_T_STATE` (`SCHED_NAME`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_N_STATE` (`SCHED_NAME`,`TRIGGER_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_N_G_STATE` (`SCHED_NAME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_NEXT_FIRE_TIME` (`SCHED_NAME`,`NEXT_FIRE_TIME`), KEY `IDX_QRTZ_T_NFT_ST` (`SCHED_NAME`,`TRIGGER_STATE`,`NEXT_FIRE_TIME`), KEY `IDX_QRTZ_T_NFT_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`), KEY `IDX_QRTZ_T_NFT_ST_MISFIRE` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_STATE`), KEY `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME`,`MISFIRE_INSTR`,`NEXT_FIRE_TIME`,`TRIGGER_GROUP`,`TRIGGER_STATE`), CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of qrtz_triggers -- ---------------------------- INSERT INTO `qrtz_triggers` VALUES ('WjpScheduler', 'TASK_1067246875800000076', 'DEFAULT', 'TASK_1067246875800000076', 'DEFAULT', null, '1712462400000', '-1', '5', 'PAUSED', 'CRON', '1712462367000', '0', null, '2', ''); -- ---------------------------- -- Table structure for `schedule_job` -- ---------------------------- DROP TABLE IF EXISTS `schedule_job`; CREATE TABLE `schedule_job` ( `id` bigint(20) NOT NULL COMMENT 'id', `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称', `params` varchar(2000) DEFAULT NULL COMMENT '参数', `cron_expression` varchar(100) DEFAULT NULL COMMENT 'cron表达式', `status` tinyint(3) unsigned DEFAULT NULL COMMENT '任务状态 0：暂停 1：正常', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务'; -- ---------------------------- -- Records of schedule_job -- ---------------------------- INSERT INTO `schedule_job` VALUES ('1067246875800000076', 'testTask', 'wjp', '0 0/30 * * * ?', '0', '有参测试，多个参数使用json', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `schedule_job_log` -- ---------------------------- DROP TABLE IF EXISTS `schedule_job_log`; CREATE TABLE `schedule_job_log` ( `id` bigint(20) NOT NULL COMMENT 'id', `job_id` bigint(20) NOT NULL COMMENT '任务id', `bean_name` varchar(200) DEFAULT NULL COMMENT 'spring bean名称', `params` varchar(2000) DEFAULT NULL COMMENT '参数', `status` tinyint(3) unsigned NOT NULL COMMENT '任务状态 0：失败 1：成功', `error` varchar(2000) DEFAULT NULL COMMENT '失败信息', `times` int(11) NOT NULL COMMENT '耗时(单位：毫秒)', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_job_id` (`job_id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='定时任务日志'; -- ---------------------------- -- Records of schedule_job_log -- ---------------------------- -- ---------------------------- -- Table structure for `sys_dept` -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `id` bigint(20) NOT NULL COMMENT 'id', `pid` bigint(20) DEFAULT NULL COMMENT '上级ID', `pids` varchar(500) DEFAULT NULL COMMENT '所有上级ID，用逗号分开', `name` varchar(50) DEFAULT NULL COMMENT '部门名称', `leader_id` bigint(20) DEFAULT NULL COMMENT '负责人ID', `sort` int(10) unsigned DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_pid` (`pid`), KEY `idx_sort` (`sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='部门管理'; -- ---------------------------- -- Records of sys_dept -- ---------------------------- INSERT INTO `sys_dept` VALUES ('1067246875800000062', '1067246875800000063', '1067246875800000066,1067246875800000063', '技术部', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dept` VALUES ('1067246875800000063', '1067246875800000066', '1067246875800000066', '长沙分公司', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dept` VALUES ('1067246875800000064', '1067246875800000066', '1067246875800000066', '上海分公司', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dept` VALUES ('1067246875800000065', '1067246875800000064', '1067246875800000066,1067246875800000064', '市场部', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dept` VALUES ('1067246875800000066', '0', '0', '佳缘科技股份有限公司', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dept` VALUES ('1067246875800000067', '1067246875800000064', '1067246875800000066,1067246875800000064', '销售部', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dept` VALUES ('1067246875800000068', '1067246875800000063', '1067246875800000066,1067246875800000063', '产品部', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_dict_data` -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `id` bigint(20) NOT NULL COMMENT 'id', `dict_type_id` bigint(20) NOT NULL COMMENT '字典类型ID', `dict_label` varchar(255) NOT NULL COMMENT '字典标签', `dict_value` varchar(255) DEFAULT NULL COMMENT '字典值', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `sort` int(10) unsigned DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_dict_type_value` (`dict_type_id`,`dict_value`), KEY `idx_sort` (`sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典数据'; -- ---------------------------- -- Records of sys_dict_data -- ---------------------------- INSERT INTO `sys_dict_data` VALUES ('1160061112075464705', '1160061077912858625', '男', '0', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1160061146967879681', '1160061077912858625', '女', '1', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1160061190127267841', '1160061077912858625', '保密', '2', '', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1225814069634195457', '1225813644059140097', '公告', '0', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1225814107559092225', '1225813644059140097', '会议', '1', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1225814271879340034', '1225813644059140097', '其他', '2', '', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1341593562419445762', '1341593474355838978', '停用', '0', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1341593595407646722', '1341593474355838978', '正常', '1', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1343069765549191170', '1343069688596295682', '已取消', '-1', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1343069839847092226', '1343069688596295682', '等待付款', '0', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_data` VALUES ('1343069914518286337', '1343069688596295682', '已完成', '1', '', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_dict_type` -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_type`; CREATE TABLE `sys_dict_type` ( `id` bigint(20) NOT NULL COMMENT 'id', `dict_type` varchar(100) NOT NULL COMMENT '字典类型', `dict_name` varchar(255) NOT NULL COMMENT '字典名称', `remark` varchar(255) DEFAULT NULL COMMENT '备注', `sort` int(10) unsigned DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `dict_type` (`dict_type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='字典类型'; -- ---------------------------- -- Records of sys_dict_type -- ---------------------------- INSERT INTO `sys_dict_type` VALUES ('1160061077912858625', 'gender', '性别', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_type` VALUES ('1225813644059140097', 'notice_type', '站内通知-类型', '', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_type` VALUES ('1341593474355838978', 'post_status', '岗位管理状态', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_dict_type` VALUES ('1343069688596295682', 'order_status', '订单状态', '', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_language` -- ---------------------------- DROP TABLE IF EXISTS `sys_language`; CREATE TABLE `sys_language` ( `table_name` varchar(32) NOT NULL COMMENT '表名', `table_id` bigint(20) NOT NULL COMMENT '表主键', `field_name` varchar(32) NOT NULL COMMENT '字段名', `field_value` varchar(200) NOT NULL COMMENT '字段值', `language` varchar(10) NOT NULL COMMENT '语言', PRIMARY KEY (`table_name`,`table_id`,`field_name`,`language`), KEY `idx_table_id` (`table_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='国际化'; -- ---------------------------- -- Records of sys_language -- ---------------------------- INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', 'Authority Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', '权限管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000002', 'name', '權限管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000003', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000004', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000005', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', 'Export', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', '导出', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000006', 'name', '導出', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', 'Role Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', '角色管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000007', 'name', '角色管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000008', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000009', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000010', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000011', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', 'Department Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', '部门管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000012', 'name', '部門管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000014', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000015', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000016', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000017', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', 'Form Design', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', '表单设计', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000018', 'name', '表单设计', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', 'Process Design', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', '流程设计', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000019', 'name', '流程设计', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', 'Running Process', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', '运行中的流程', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000020', 'name', '運行中的流程', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000021', 'name', 'SMS Service', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000021', 'name', '短信服务', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000021', 'name', '短信服務', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000022', 'name', 'Mail Template', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000022', 'name', '邮件模板', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000022', 'name', '郵件模板', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000023', 'name', 'Mail Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000023', 'name', '邮件发送记录', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000023', 'name', '郵件發送記錄', 'zh-TW '); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000024', 'name', 'Message Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000024', 'name', '消息管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000024', 'name', '消息管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', 'Menu Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', '菜单管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000025', 'name', '菜單管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000026', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000027', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000028', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000029', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', 'Timed Task', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', '定时任务', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000030', 'name', '定時任務', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000031', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000032', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000033', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000034', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', 'Setting', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', '系统设置', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000035', 'name', '系統設置', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', 'Pause', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', '暂停', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000036', 'name', '暫停', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', 'Resume', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', '恢复', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000037', 'name', '恢復', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', 'Execute', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', '立即执行', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000038', 'name', '立即執行', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', 'Log List', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', '日志列表', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000039', 'name', '日誌列表', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', 'Parameter Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', '参数管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000040', 'name', '參數管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', 'Dict Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', '字典管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000041', 'name', '字典管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000042', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000043', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000044', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000045', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', 'Log Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', '日志管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000046', 'name', '日誌管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', 'File Upload', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', '文件上传', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000047', 'name', '文件上傳', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', 'Login Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', '登录日志', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000048', 'name', '登錄日誌', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', 'Operation Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', '操作日志', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000049', 'name', '操作日誌', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', 'Error Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', '异常日志', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000050', 'name', '異常日誌', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000051', 'name', 'SQL Monitoring', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000051', 'name', 'SQL监控', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000051', 'name', 'SQL監控', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000052', 'name', 'News Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000052', 'name', '新闻管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000052', 'name', '新聞管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', 'System Monitoring', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', '系统监控', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000053', 'name', '系統監控', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000054', 'name', 'Demo', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000054', 'name', '功能示例', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000054', 'name', '功能示例', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', 'User Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', '用户管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000055', 'name', '用戶管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000056', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000057', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', 'Export', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', '导出', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000058', 'name', '導出', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000059', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000060', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000061', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', 'Station Notice', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', '站内通知', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000300', 'name', '站內通知', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', 'Notice Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', '通知管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000301', 'name', '通知管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', 'My Notice', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', '我的通知', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000302', 'name', '我的通知', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000303', 'name', 'SMS History', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000303', 'name', '短信发送记录', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1067246875800000303', 'name', '短信發送記錄', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', 'Process Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', '流程管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150940491508928513', 'name', '流程管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', 'Personal Office', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', '办公管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941310262235138', 'name', '辦公管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', 'Todo', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', '待办任务', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941384811794433', 'name', '待辦任務', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', 'Task Already', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', '已办任务', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941447038488577', 'name', '已辦任務', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', 'Initiation Process', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', '发起流程', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941506626965506', 'name', '發起流程', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', 'My Send', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', '我发起的', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1150941588046794754', 'name', '我發起的', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', 'Interface Document', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', '接口文档', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1156748733921165314', 'name', '接口文檔', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842115', 'name', 'Administrative Regions', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842115', 'name', '行政区域', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842115', 'name', '行政區域', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842116', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842116', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842116', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842117', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842117', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842117', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842118', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842118', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842118', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842119', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842119', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1158267114314842119', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501800', 'name', 'ECharts', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501800', 'name', 'ECharts', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501800', 'name', 'ECharts', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501825', 'name', 'Master And Child', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501825', 'name', '主子表演示', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501825', 'name', '主子表演示', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501826', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501826', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501826', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501827', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501827', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501827', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501828', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501828', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501828', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501829', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501829', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1270380959719501829', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', 'Report Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', '报表管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278047072649217', 'name', '報表管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', 'Report Design', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', '报表设计器', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300278435729440769', 'name', '報表設計器', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', 'Report List', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', '报表列表', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1300381796852060161', 'name', '報表列表', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', 'DevTools', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', '开发者工具', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850622416084993', 'name', '開發者工具', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', 'DataSource', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', '数据源管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302850783288614913', 'name', '數據源管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', 'Field Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', '字段管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302862890696564738', 'name', '字段管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', 'BaseClass', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', '基类管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1302874751835848705', 'name', '基類管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', 'Template', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', '模板管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304081184014635010', 'name', '模板管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', 'Code Generation', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', '代码生成工具', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809410', 'name', '代碼生成工具', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809411', 'name', 'Project Editor', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809411', 'name', '项目名修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1304802103569809411', 'name', '項目名修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', 'Parameter Config', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', '参数配置', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305513187675144193', 'name', '參數配置', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', 'Config Info', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', '配置信息', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1305532398162145281', 'name', '配置信息', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1340949288542347266', 'name', 'Page Design', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1340949288542347266', 'name', '页面表单设计', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1340949288542347266', 'name', '頁面表單設計', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', 'Job Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', '岗位管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622612987906', 'name', '崗位管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', 'View', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', '查看', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622688485377', 'name', '查看', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', 'Add', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', '新增', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622755594242', 'name', '新增', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', 'Edit', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', '修改', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622835286018', 'name', '修改', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', 'Delete', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', '删除', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341596622902394881', 'name', '刪除', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', 'Online User', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', '在线用户', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341659662599495681', 'name', '在線用戶', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341676084016852994', 'name', 'Excel Demo', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341676084016852994', 'name', 'Excel导入演示', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1341676084016852994', 'name', 'Excel導入演示', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074487777677313', 'name', 'Pay Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074487777677313', 'name', '支付管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074487777677313', 'name', '支付管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074685589442561', 'name', 'Order Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074685589442561', 'name', '订单管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074685589442561', 'name', '訂單管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074794440019970', 'name', 'AliPay Log', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074794440019970', 'name', '支付宝回调日志', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1343074794440019970', 'name', '支付寶回調日誌', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419551957005963266', 'name', 'Wechat Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419551957005963266', 'name', '微信管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419551957005963266', 'name', '微信管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419553543706972161', 'name', 'Mp Management', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419553543706972161', 'name', '公众号管理', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419553543706972161', 'name', '公眾號管理', 'zh-TW'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419963799817691137', 'name', 'Custom Menu', 'en-US'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419963799817691137', 'name', '自定义菜单', 'zh-CN'); INSERT INTO `sys_language` VALUES ('sys_menu', '1419963799817691137', 'name', '自定義選單', 'zh-TW'); -- ---------------------------- -- Table structure for `sys_log_error` -- ---------------------------- DROP TABLE IF EXISTS `sys_log_error`; CREATE TABLE `sys_log_error` ( `id` bigint(20) NOT NULL COMMENT 'id', `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI', `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式', `request_params` text COMMENT '请求参数', `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理', `ip` varchar(32) DEFAULT NULL COMMENT '操作IP', `error_info` text COMMENT '异常信息', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='异常日志'; -- ---------------------------- -- Records of sys_log_error -- ---------------------------- -- ---------------------------- -- Table structure for `sys_log_login` -- ---------------------------- DROP TABLE IF EXISTS `sys_log_login`; CREATE TABLE `sys_log_login` ( `id` bigint(20) NOT NULL COMMENT 'id', `operation` tinyint(3) unsigned DEFAULT NULL COMMENT '用户操作 0：用户登录 1：用户退出', `status` tinyint(3) unsigned NOT NULL COMMENT '状态 0：失败 1：成功 2：账号已锁定', `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理', `ip` varchar(32) DEFAULT NULL COMMENT '操作IP', `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_status` (`status`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='登录日志'; -- ---------------------------- -- Records of sys_log_login -- ---------------------------- INSERT INTO `sys_log_login` VALUES ('1776847691573903362', '0', '1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/123.0.0.0 Safari/537.36', '0:0:0:0:0:0:0:1', 'admin', '1067246875800000001', '2024-04-07 13:41:16'); -- ---------------------------- -- Table structure for `sys_log_operation` -- ---------------------------- DROP TABLE IF EXISTS `sys_log_operation`; CREATE TABLE `sys_log_operation` ( `id` bigint(20) NOT NULL COMMENT 'id', `operation` varchar(50) DEFAULT NULL COMMENT '用户操作', `request_uri` varchar(200) DEFAULT NULL COMMENT '请求URI', `request_method` varchar(20) DEFAULT NULL COMMENT '请求方式', `request_params` text COMMENT '请求参数', `request_time` int(10) unsigned NOT NULL COMMENT '请求时长(毫秒)', `user_agent` varchar(500) DEFAULT NULL COMMENT '用户代理', `ip` varchar(32) DEFAULT NULL COMMENT '操作IP', `status` tinyint(3) unsigned NOT NULL COMMENT '状态 0：失败 1：成功', `creator_name` varchar(50) DEFAULT NULL COMMENT '用户名', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='操作日志'; -- ---------------------------- -- Records of sys_log_operation -- ---------------------------- -- ---------------------------- -- Table structure for `sys_mail_log` -- ---------------------------- DROP TABLE IF EXISTS `sys_mail_log`; CREATE TABLE `sys_mail_log` ( `id` bigint(20) NOT NULL COMMENT 'id', `template_id` bigint(20) NOT NULL COMMENT '邮件模板ID', `mail_from` varchar(200) DEFAULT NULL COMMENT '发送者', `mail_to` varchar(400) DEFAULT NULL COMMENT '收件人', `mail_cc` varchar(400) DEFAULT NULL COMMENT '抄送者', `subject` varchar(200) DEFAULT NULL COMMENT '邮件主题', `content` text COMMENT '邮件正文', `status` tinyint(3) unsigned DEFAULT NULL COMMENT '发送状态 0：失败 1：成功', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮件发送记录'; -- ---------------------------- -- Records of sys_mail_log -- ---------------------------- -- ---------------------------- -- Table structure for `sys_mail_template` -- ---------------------------- DROP TABLE IF EXISTS `sys_mail_template`; CREATE TABLE `sys_mail_template` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(100) DEFAULT NULL COMMENT '模板名称', `subject` varchar(200) DEFAULT NULL COMMENT '邮件主题', `content` text COMMENT '邮件正文', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='邮件模板'; -- ---------------------------- -- Records of sys_mail_template -- ---------------------------- INSERT INTO `sys_mail_template` VALUES ('1067246875800000077', '验证码模板', '注册验证码', '

注册验证码：${code}

', null, '2024-04-07 11:48:42', null, null); -- ---------------------------- -- Table structure for `sys_menu` -- ---------------------------- DROP TABLE IF EXISTS `sys_menu`; CREATE TABLE `sys_menu` ( `id` bigint(20) NOT NULL COMMENT 'id', `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级菜单为0', `url` varchar(200) DEFAULT NULL COMMENT '菜单URL', `permissions` varchar(500) DEFAULT NULL COMMENT '授权(多个用逗号分隔，如：sys:user:list,sys:user:save)', `menu_type` tinyint(3) unsigned DEFAULT NULL COMMENT '类型 0：菜单 1：按钮', `open_style` tinyint(3) unsigned DEFAULT NULL COMMENT '打开方式 0：内部 1：外部', `icon` varchar(50) DEFAULT NULL COMMENT '菜单图标', `sort` int(11) DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_pid` (`pid`), KEY `idx_sort` (`sort`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='菜单管理'; -- ---------------------------- -- Records of sys_menu -- ---------------------------- INSERT INTO `sys_menu` VALUES ('1067246875800000002', '0', null, null, '0', '0', 'icon-safetycertificate', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000003', '1067246875800000055', null, 'sys:user:save,sys:dept:list,sys:role:list', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000004', '1067246875800000055', null, 'sys:user:update,sys:dept:list,sys:role:list', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000005', '1067246875800000055', null, 'sys:user:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000006', '1067246875800000055', null, 'sys:user:export', '1', '0', null, '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000007', '1067246875800000002', 'sys/role', null, '0', '0', 'icon-team', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000008', '1067246875800000007', null, 'sys:role:page,sys:role:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000009', '1067246875800000007', null, 'sys:role:save,sys:menu:select,sys:dept:list', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000010', '1067246875800000007', null, 'sys:role:update,sys:menu:select,sys:dept:list', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000011', '1067246875800000007', null, 'sys:role:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000012', '1067246875800000002', 'sys/dept', null, '0', '0', 'icon-apartment', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000014', '1067246875800000012', null, 'sys:dept:list,sys:dept:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000015', '1067246875800000012', null, 'sys:dept:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000016', '1067246875800000012', null, 'sys:dept:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000017', '1067246875800000012', null, 'sys:dept:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000018', '1150940491508928513', 'flow/bpmform', 'flow:bpmform:all', '0', '0', 'icon-detail', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000019', '1150940491508928513', 'flow/model', 'sys:model:all', '0', '0', 'icon-appstore-fill', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000020', '1150940491508928513', 'flow/running', 'sys:running:all,sys:flow:all', '0', '0', 'icon-play-square', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000021', '1067246875800000024', 'message/sms', 'sys:sms:all', '0', '0', 'icon-message-fill', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000022', '1067246875800000024', 'message/mail_template', 'sys:mail:all', '0', '0', 'icon-mail', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000023', '1067246875800000024', 'message/mail_log', 'sys:mail:log', '0', '0', 'icon-detail-fill', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000024', '0', null, null, '0', '0', 'icon-message', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000025', '1067246875800000035', 'sys/menu', null, '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000026', '1067246875800000025', null, 'sys:menu:list,sys:menu:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000027', '1067246875800000025', null, 'sys:menu:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000028', '1067246875800000025', null, 'sys:menu:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000029', '1067246875800000025', null, 'sys:menu:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000030', '1067246875800000035', 'job/schedule', null, '0', '0', 'icon-dashboard', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000031', '1067246875800000030', null, 'sys:schedule:page,sys:schedule:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000032', '1067246875800000030', null, 'sys:schedule:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000033', '1067246875800000030', null, 'sys:schedule:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000034', '1067246875800000030', null, 'sys:schedule:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000035', '0', null, null, '0', '0', 'icon-setting', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000036', '1067246875800000030', null, 'sys:schedule:pause', '1', '0', null, '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000037', '1067246875800000030', null, 'sys:schedule:resume', '1', '0', null, '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000038', '1067246875800000030', null, 'sys:schedule:run', '1', '0', null, '6', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000039', '1067246875800000030', null, 'sys:schedule:log', '1', '0', null, '7', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000040', '1067246875800000035', 'sys/params', '', '0', '0', 'icon-fileprotect', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000041', '1067246875800000035', 'sys/dict-type', null, '0', '0', 'icon-golden-fill', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000042', '1067246875800000041', null, 'sys:dict:page,sys:dict:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000043', '1067246875800000041', null, 'sys:dict:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000044', '1067246875800000041', null, 'sys:dict:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000045', '1067246875800000041', null, 'sys:dict:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000046', '0', null, null, '0', '0', 'icon-container', '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000047', '1067246875800000035', 'oss/oss', 'sys:oss:all', '0', '0', 'icon-upload', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000048', '1067246875800000046', 'sys/log-login', 'sys:log:login', '0', '0', 'icon-filedone', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000049', '1067246875800000046', 'sys/log-operation', 'sys:log:operation', '0', '0', 'icon-solution', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000050', '1067246875800000046', 'sys/log-error', 'sys:log:error', '0', '0', 'icon-file-exception', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000051', '1067246875800000053', '{{ApiUrl}}/druid/sql.html', null, '0', '0', 'icon-database', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000052', '1067246875800000054', 'demo/news', 'demo:news:all', '0', '0', 'icon-file-word', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000053', '0', null, null, '0', '0', 'icon-desktop', '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000054', '0', null, null, '0', '0', 'icon-windows', '6', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000055', '1067246875800000002', 'sys/user', null, '0', '0', 'icon-user', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000056', '1067246875800000055', null, 'sys:user:page,sys:user:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000057', '1067246875800000040', null, 'sys:params:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000058', '1067246875800000040', null, 'sys:params:export', '1', '0', null, '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000059', '1067246875800000040', '', 'sys:params:page,sys:params:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000060', '1067246875800000040', null, 'sys:params:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000061', '1067246875800000040', '', 'sys:params:delete', '1', '0', '', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000300', '0', null, null, '0', '0', 'icon-bell', '5', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000301', '1067246875800000300', 'notice/notice', 'sys:notice:all', '0', '0', 'icon-bell', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000302', '1067246875800000300', 'notice/notice-user', 'sys:notice:all', '0', '0', 'icon-notification', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1067246875800000303', '1067246875800000024', 'message/sms-log', 'sys:smslog:all', '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1150940491508928513', '0', null, null, '0', '0', 'icon-reloadtime', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1150941310262235138', '0', null, null, '0', '0', 'icon-user', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1150941384811794433', '1150941310262235138', 'flow/todo', 'sys:flow:all,sys:user:page', '0', '0', 'icon-dashboard', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1150941447038488577', '1150941310262235138', 'flow/done', 'sys:flow:all', '0', '0', 'icon-check-square', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1150941506626965506', '1150941310262235138', 'flow/start', 'sys:flow:all', '0', '0', 'icon-play-square', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1150941588046794754', '1150941310262235138', 'flow/my-send', 'sys:flow:all', '0', '0', 'icon-edit-square', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1156748733921165314', '1067246875800000053', '{{ApiUrl}}/doc.html', '', '0', '1', 'icon-file-word', '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1158267114314842115', '1067246875800000035', 'sys/region', null, '0', '0', 'icon-location', '4', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1158267114314842116', '1158267114314842115', null, 'sys:region:list,sys:region:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1158267114314842117', '1158267114314842115', null, 'sys:region:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1158267114314842118', '1158267114314842115', null, 'sys:region:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1158267114314842119', '1158267114314842115', null, 'sys:region:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1270380959719501800', '1067246875800000054', 'demo/charts', null, '0', '0', 'icon-tag', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1270380959719501825', '1067246875800000054', 'demo/product', null, '0', '0', 'icon-tag', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1270380959719501826', '1270380959719501825', null, 'demo:product:page,demo:product:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1270380959719501827', '1270380959719501825', null, 'demo:product:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1270380959719501828', '1270380959719501825', null, 'demo:product:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1270380959719501829', '1270380959719501825', null, 'demo:product:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1300278047072649217', '0', '', '', '0', '0', 'icon-filesearch', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1300278435729440769', '1300278047072649217', '{{ApiUrl}}/ureport/designer', '', '0', '0', 'icon-book', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1300381796852060161', '1300278047072649217', 'ureport/ureport', 'sys:ureport:all', '0', '0', 'icon-up-circle', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1302850622416084993', '0', '', '', '0', '0', 'icon-rocket', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1302850783288614913', '1305532398162145281', 'devtools/datasource', '', '0', '0', 'icon-sync', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1302862890696564738', '1305532398162145281', 'devtools/fieldtype', '', '0', '0', 'icon-eye', '1', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1302874751835848705', '1305532398162145281', 'devtools/baseclass', '', '0', '0', 'icon-info-circle', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1304081184014635010', '1305532398162145281', 'devtools/template', '', '0', '0', 'icon-up-circle', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1304802103569809410', '1302850622416084993', 'devtools/generator', '', '0', '0', 'icon-tags', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1304802103569809411', '1302850622416084993', 'devtools/project', '', '0', '0', 'icon-tags', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1305513187675144193', '1305532398162145281', 'devtools/param', '', '0', '0', 'icon-setting', '5', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1305532398162145281', '1302850622416084993', '', '', '0', '0', 'icon-setting', '3', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1340949288542347266', '1302850622416084993', 'form-generator/form', '', '0', '0', 'icon-edit-square', '0', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_menu` VALUES ('1341596622612987906', '1067246875800000002', 'sys/post', null, '0', '0', 'icon-pic-left', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1341596622688485377', '1341596622612987906', null, 'sys:post:page,sys:post:info', '1', '0', null, '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1341596622755594242', '1341596622612987906', null, 'sys:post:save', '1', '0', null, '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1341596622835286018', '1341596622612987906', null, 'sys:post:update', '1', '0', null, '2', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1341596622902394881', '1341596622612987906', null, 'sys:post:delete', '1', '0', null, '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1341659662599495681', '1067246875800000053', 'sys/online', 'sys:online:all', '0', '0', 'icon-team', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1341676084016852994', '1067246875800000054', 'demo/excel', 'demo:excel:all', '0', '0', 'icon-table', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1343074487777677313', '0', '', '', '0', '0', 'icon-Dollar', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1343074685589442561', '1343074487777677313', 'pay/order', 'pay:order:all', '0', '0', 'icon-unorderedlist', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1343074794440019970', '1343074487777677313', 'pay/alipaynotifylog', 'pay:alipayNotifyLog:all', '0', '0', 'icon-filedone', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1419551957005963266', '0', '', '', '0', '0', 'icon-wechat-fill', '3', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1419553543706972161', '1419551957005963266', 'mp/account', 'mp:account:all', '0', '0', 'icon-user', '0', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_menu` VALUES ('1419963799817691137', '1419551957005963266', 'mp/menu', 'mp:menu:all', '0', '0', 'icon-unorderedlist', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_notice` -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `id` bigint(20) NOT NULL COMMENT 'id', `notice_type` int(11) NOT NULL COMMENT '通知类型', `title` varchar(200) DEFAULT NULL COMMENT '标题', `content` text COMMENT '内容', `receiver_type` tinyint(3) unsigned DEFAULT NULL COMMENT '接收者 0：全部 1：部门', `receiver_type_ids` varchar(500) DEFAULT NULL COMMENT '接收者ID，用逗号分开', `status` tinyint(3) unsigned DEFAULT NULL COMMENT '发送状态 0：草稿 1：已发布', `sender_name` varchar(50) DEFAULT NULL COMMENT '发送者', `sender_date` datetime DEFAULT NULL COMMENT '发送时间', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='通知管理'; -- ---------------------------- -- Records of sys_notice -- ---------------------------- -- ---------------------------- -- Table structure for `sys_notice_user` -- ---------------------------- DROP TABLE IF EXISTS `sys_notice_user`; CREATE TABLE `sys_notice_user` ( `receiver_id` bigint(20) NOT NULL COMMENT '接收者ID', `notice_id` bigint(20) NOT NULL COMMENT '通知ID', `read_status` tinyint(3) unsigned DEFAULT NULL COMMENT '阅读状态 0：未读 1：已读', `read_date` datetime DEFAULT NULL COMMENT '阅读时间', PRIMARY KEY (`receiver_id`,`notice_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='我的通知'; -- ---------------------------- -- Records of sys_notice_user -- ---------------------------- -- ---------------------------- -- Table structure for `sys_oss` -- ---------------------------- DROP TABLE IF EXISTS `sys_oss`; CREATE TABLE `sys_oss` ( `id` bigint(20) NOT NULL COMMENT 'id', `url` varchar(200) DEFAULT NULL COMMENT 'URL地址', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='文件上传'; -- ---------------------------- -- Records of sys_oss -- ---------------------------- -- ---------------------------- -- Table structure for `sys_params` -- ---------------------------- DROP TABLE IF EXISTS `sys_params`; CREATE TABLE `sys_params` ( `id` bigint(20) NOT NULL COMMENT 'id', `param_code` varchar(32) DEFAULT NULL COMMENT '参数编码', `param_value` varchar(2000) DEFAULT NULL COMMENT '参数值', `param_type` tinyint(3) unsigned DEFAULT '1' COMMENT '类型 0：系统参数 1：非系统参数', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_param_code` (`param_code`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='参数管理'; -- ---------------------------- -- Records of sys_params -- ---------------------------- INSERT INTO `sys_params` VALUES ('1067246875800000072', 'DEV_TOOLS_PARAM_KEY', '{\"packageName\":\"com.wjp\",\"version\":\"3.0\",\"author\":\"Toby\",\"email\":\"javatangbin@163.com\",\"backendPath\":\"D:\\\\code\\\\wjp-project\\\\wjp-admin\",\"frontendPath\":\"D:\\\\code\\\\wjp-project-admin\"}', '0', '代码生成器配置信息', '1067246875800000001', '2024-04-07 11:49:42', '1067246875800000001', '2024-04-07 11:49:42'); INSERT INTO `sys_params` VALUES ('1067246875800000073', 'CLOUD_STORAGE_CONFIG_KEY', '{\"type\":1,\"qiniuDomain\":\"http://test.oss.scjydz.com\",\"qiniuPrefix\":\"upload\",\"qiniuAccessKey\":\"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ\",\"qiniuSecretKey\":\"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV\",\"qiniuBucketName\":\"wjp-oss\",\"aliyunDomain\":\"\",\"aliyunPrefix\":\"\",\"aliyunEndPoint\":\"\",\"aliyunAccessKeyId\":\"\",\"aliyunAccessKeySecret\":\"\",\"aliyunBucketName\":\"\",\"qcloudDomain\":\"\",\"qcloudPrefix\":\"\",\"qcloudSecretId\":\"\",\"qcloudSecretKey\":\"\",\"qcloudBucketName\":\"\"}', '0', '云存储配置信息', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_params` VALUES ('1067246875800000075', 'MAIL_CONFIG_KEY', '{\"smtp\":\"smtp.163.com\",\"port\":25,\"username\":\"wjp_test@163.com\",\"password\":\"wjp123456\"}', '0', '邮件配置信息', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_post` -- ---------------------------- DROP TABLE IF EXISTS `sys_post`; CREATE TABLE `sys_post` ( `id` bigint(20) NOT NULL COMMENT 'id', `post_code` varchar(100) DEFAULT NULL COMMENT '岗位编码', `post_name` varchar(100) DEFAULT NULL COMMENT '岗位名称', `sort` int(11) DEFAULT NULL COMMENT '排序', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：停用 1：正常', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='岗位管理'; -- ---------------------------- -- Records of sys_post -- ---------------------------- INSERT INTO `sys_post` VALUES ('1341597192832811009', 'tech', '技术岗', '0', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_region` -- ---------------------------- DROP TABLE IF EXISTS `sys_region`; CREATE TABLE `sys_region` ( `id` bigint(20) NOT NULL COMMENT 'id', `pid` bigint(20) DEFAULT NULL COMMENT '上级ID，一级为0', `name` varchar(100) DEFAULT NULL COMMENT '名称', `tree_level` tinyint(4) DEFAULT NULL COMMENT '层级', `leaf` tinyint(4) DEFAULT NULL COMMENT '是否叶子节点 0：否 1：是', `sort` bigint(20) DEFAULT NULL COMMENT '排序', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='行政区域'; -- ---------------------------- -- Records of sys_region -- ---------------------------- -- ---------------------------- -- Table structure for `sys_role` -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(50) DEFAULT NULL COMMENT '角色名称', `remark` varchar(100) DEFAULT NULL COMMENT '备注', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), KEY `idx_dept_id` (`dept_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色管理'; -- ---------------------------- -- Records of sys_role -- ---------------------------- -- ---------------------------- -- Table structure for `sys_role_data_scope` -- ---------------------------- DROP TABLE IF EXISTS `sys_role_data_scope`; CREATE TABLE `sys_role_data_scope` ( `id` bigint(20) NOT NULL COMMENT 'id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色数据权限'; -- ---------------------------- -- Records of sys_role_data_scope -- ---------------------------- -- ---------------------------- -- Table structure for `sys_role_menu` -- ---------------------------- DROP TABLE IF EXISTS `sys_role_menu`; CREATE TABLE `sys_role_menu` ( `id` bigint(20) NOT NULL COMMENT 'id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `menu_id` bigint(20) DEFAULT NULL COMMENT '菜单ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`), KEY `idx_menu_id` (`menu_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色菜单关系'; -- ---------------------------- -- Records of sys_role_menu -- ---------------------------- -- ---------------------------- -- Table structure for `sys_role_user` -- ---------------------------- DROP TABLE IF EXISTS `sys_role_user`; CREATE TABLE `sys_role_user` ( `id` bigint(20) NOT NULL COMMENT 'id', `role_id` bigint(20) DEFAULT NULL COMMENT '角色ID', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_role_id` (`role_id`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='角色用户关系'; -- ---------------------------- -- Records of sys_role_user -- ---------------------------- -- ---------------------------- -- Table structure for `sys_sms` -- ---------------------------- DROP TABLE IF EXISTS `sys_sms`; CREATE TABLE `sys_sms` ( `id` bigint(20) NOT NULL COMMENT 'id', `sms_code` varchar(32) DEFAULT NULL COMMENT '短信编码', `platform` tinyint(3) unsigned NOT NULL COMMENT '平台类型', `sms_config` varchar(2000) DEFAULT NULL COMMENT '短信配置', `remark` varchar(200) DEFAULT NULL COMMENT '备注', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_sms_code` (`sms_code`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='短信'; -- ---------------------------- -- Records of sys_sms -- ---------------------------- INSERT INTO `sys_sms` VALUES ('1228954061084676097', '1001', '1', '{\"aliyunAccessKeyId\":\"1\",\"aliyunAccessKeySecret\":\"1\",\"aliyunSignName\":\"1\",\"aliyunTemplateCode\":\"1\",\"qcloudAppKey\":\"\",\"qcloudSignName\":\"\",\"qcloudTemplateId\":\"\",\"qiniuAccessKey\":\"\",\"qiniuSecretKey\":\"\",\"qiniuTemplateId\":\"\"}', '', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_sms_log` -- ---------------------------- DROP TABLE IF EXISTS `sys_sms_log`; CREATE TABLE `sys_sms_log` ( `id` bigint(20) NOT NULL COMMENT 'id', `sms_code` varchar(32) DEFAULT NULL COMMENT '短信编码', `platform` tinyint(3) unsigned NOT NULL COMMENT '平台类型', `mobile` varchar(20) DEFAULT NULL COMMENT '手机号', `params_1` varchar(50) DEFAULT NULL COMMENT '参数1', `params_2` varchar(50) DEFAULT NULL COMMENT '参数2', `params_3` varchar(50) DEFAULT NULL COMMENT '参数3', `params_4` varchar(50) DEFAULT NULL COMMENT '参数4', `status` tinyint(3) unsigned DEFAULT NULL COMMENT '发送状态 0：失败 1：成功', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_sms_code` (`sms_code`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='短信日志'; -- ---------------------------- -- Records of sys_sms_log -- ---------------------------- -- ---------------------------- -- Table structure for `sys_ureport_data` -- ---------------------------- DROP TABLE IF EXISTS `sys_ureport_data`; CREATE TABLE `sys_ureport_data` ( `id` bigint(20) NOT NULL COMMENT 'id', `file_name` varchar(200) DEFAULT NULL COMMENT '报表文件名', `content` mediumblob COMMENT '内容', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='报表数据'; -- ---------------------------- -- Records of sys_ureport_data -- ---------------------------- -- ---------------------------- -- Table structure for `sys_user` -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `id` bigint(20) NOT NULL COMMENT 'id', `username` varchar(50) NOT NULL COMMENT '用户名', `password` varchar(100) DEFAULT NULL COMMENT '密码', `real_name` varchar(50) DEFAULT NULL COMMENT '姓名', `head_url` varchar(200) DEFAULT NULL COMMENT '头像', `gender` tinyint(3) unsigned DEFAULT NULL COMMENT '性别 0：男 1：女 2：保密', `email` varchar(100) DEFAULT NULL COMMENT '邮箱', `mobile` varchar(100) DEFAULT NULL COMMENT '手机号', `dept_id` bigint(20) DEFAULT NULL COMMENT '部门ID', `super_admin` tinyint(3) unsigned DEFAULT NULL COMMENT '超级管理员 0：否 1：是', `status` tinyint(4) DEFAULT NULL COMMENT '状态 0：停用 1：正常', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_username` (`username`), KEY `idx_create_date` (`create_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统用户'; -- ---------------------------- -- Records of sys_user -- ---------------------------- INSERT INTO `sys_user` VALUES ('1067246875800000001', 'admin', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '管理员', null, '0', 'root@scjydz.com', '13612345678', null, '1', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); INSERT INTO `sys_user` VALUES ('1353943117220315138', 'test', '$2a$10$012Kx2ba5jzqr9gLlG4MX.bnQJTD9UWqF57XDo2N3.fPtLne02u/m', '测试用户', null, '0', 'test@scjydz.com', '13012345678', '1067246875800000066', '0', '1', '1067246875800000001', '2024-04-07 11:48:42', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `sys_user_post` -- ---------------------------- DROP TABLE IF EXISTS `sys_user_post`; CREATE TABLE `sys_user_post` ( `id` bigint(20) NOT NULL COMMENT 'id', `post_id` bigint(20) DEFAULT NULL COMMENT '岗位ID', `user_id` bigint(20) DEFAULT NULL COMMENT '用户ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), KEY `idx_post_id` (`post_id`), KEY `idx_user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户岗位关系'; -- ---------------------------- -- Records of sys_user_post -- ---------------------------- -- ---------------------------- -- Table structure for `sys_user_token` -- ---------------------------- DROP TABLE IF EXISTS `sys_user_token`; CREATE TABLE `sys_user_token` ( `id` bigint(20) NOT NULL COMMENT 'id', `user_id` bigint(20) NOT NULL COMMENT '用户id', `token` varchar(100) NOT NULL COMMENT '用户token', `expire_date` datetime DEFAULT NULL COMMENT '过期时间', `update_date` datetime DEFAULT NULL COMMENT '更新时间', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), UNIQUE KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统用户Token'; -- ---------------------------- -- Records of sys_user_token -- ---------------------------- INSERT INTO `sys_user_token` VALUES ('1776847691678760961', '1067246875800000001', '35225a2a8b88b3ff2e4061f535fe8fb1', '2024-04-08 01:41:17', '2024-04-07 13:41:17', '2024-04-07 13:41:17'); -- ---------------------------- -- Table structure for `tb_alipay_notify_log` -- ---------------------------- DROP TABLE IF EXISTS `tb_alipay_notify_log`; CREATE TABLE `tb_alipay_notify_log` ( `id` bigint(20) NOT NULL COMMENT 'id', `out_trade_no` bigint(20) DEFAULT NULL COMMENT '订单号', `total_amount` decimal(10,2) DEFAULT NULL COMMENT '订单金额', `buyer_pay_amount` decimal(10,2) DEFAULT NULL COMMENT '付款金额', `receipt_amount` decimal(10,2) DEFAULT NULL COMMENT '实收金额', `invoice_amount` decimal(10,2) DEFAULT NULL COMMENT '开票金额', `notify_id` varchar(50) DEFAULT NULL COMMENT '通知校验ID', `buyer_id` varchar(50) DEFAULT NULL COMMENT '买家支付宝用户号', `seller_id` varchar(50) DEFAULT NULL COMMENT '卖家支付宝用户号', `trade_no` varchar(50) DEFAULT NULL COMMENT '支付宝交易号', `trade_status` varchar(50) DEFAULT NULL COMMENT '交易状态', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='支付宝回调日志'; -- ---------------------------- -- Records of tb_alipay_notify_log -- ---------------------------- INSERT INTO `tb_alipay_notify_log` VALUES ('1343493644518195201', '1343491774781419523', '3600.00', '3600.00', '3600.00', '3600.00', '2020122800222174658006930510128003', '2088102177806934', '2088102177441441', '2020122822001406930501194003', 'TRADE_SUCCESS', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `tb_excel_data` -- ---------------------------- DROP TABLE IF EXISTS `tb_excel_data`; CREATE TABLE `tb_excel_data` ( `id` bigint(20) NOT NULL COMMENT 'id', `real_name` varchar(100) DEFAULT NULL COMMENT '学生姓名', `user_identity` varchar(100) DEFAULT NULL COMMENT '身份证', `address` varchar(200) DEFAULT NULL COMMENT '家庭地址', `join_date` datetime DEFAULT NULL COMMENT '入学日期', `class_name` varchar(100) DEFAULT NULL COMMENT '班级名称', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Excel导入演示'; -- ---------------------------- -- Records of tb_excel_data -- ---------------------------- INSERT INTO `tb_excel_data` VALUES ('1343762012112445441', '大力', '430212199910102980', '上海市长宁区中山公园', '2024-04-07 11:48:42', '姚班2101', '1067246875800000001', '2024-04-07 11:48:42'); -- ---------------------------- -- Table structure for `tb_news` -- ---------------------------- DROP TABLE IF EXISTS `tb_news`; CREATE TABLE `tb_news` ( `id` bigint(20) NOT NULL COMMENT 'id', `title` varchar(100) NOT NULL COMMENT '标题', `content` mediumtext NOT NULL COMMENT '内容', `pub_date` datetime DEFAULT NULL COMMENT '发布时间', `dept_id` bigint(20) DEFAULT NULL COMMENT '创建者dept_id', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='新闻管理'; -- ---------------------------- -- Records of tb_news -- ---------------------------- -- ---------------------------- -- Table structure for `tb_order` -- ---------------------------- DROP TABLE IF EXISTS `tb_order`; CREATE TABLE `tb_order` ( `id` bigint(20) NOT NULL COMMENT 'id', `order_id` bigint(20) DEFAULT NULL COMMENT '订单ID', `product_id` bigint(20) NOT NULL COMMENT '产品ID', `product_name` varchar(100) DEFAULT NULL COMMENT '产品名称', `pay_amount` decimal(10,2) NOT NULL COMMENT '支付金额', `status` tinyint(4) DEFAULT NULL COMMENT '订单状态 -1：已取消 0：等待付款 1：已完成', `user_id` bigint(20) DEFAULT NULL COMMENT '购买用户ID', `pay_at` datetime DEFAULT NULL COMMENT '支付时间', `create_date` datetime DEFAULT NULL COMMENT '下单时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_order_id` (`order_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='订单'; -- ---------------------------- -- Table structure for `tb_product` -- ---------------------------- DROP TABLE IF EXISTS `tb_product`; CREATE TABLE `tb_product` ( `id` bigint(20) NOT NULL COMMENT 'id', `name` varchar(100) NOT NULL COMMENT '产品名称', `content` mediumtext NOT NULL COMMENT '产品介绍', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品管理'; -- ---------------------------- -- Records of tb_product -- ---------------------------- -- ---------------------------- -- Table structure for `tb_product_params` -- ---------------------------- DROP TABLE IF EXISTS `tb_product_params`; CREATE TABLE `tb_product_params` ( `id` bigint(20) NOT NULL COMMENT 'id', `param_name` varchar(100) DEFAULT NULL COMMENT '参数名', `param_value` varchar(200) DEFAULT NULL COMMENT '参数值', `product_id` bigint(20) DEFAULT NULL COMMENT '产品ID', `creator` bigint(20) DEFAULT NULL COMMENT '创建者', `create_date` datetime DEFAULT NULL COMMENT '创建时间', `updater` bigint(20) DEFAULT NULL COMMENT '更新者', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='产品参数管理'; -- ---------------------------- -- Records of tb_product_params -- ---------------------------- -- ---------------------------- -- Table structure for `tb_token` -- ---------------------------- DROP TABLE IF EXISTS `tb_token`; CREATE TABLE `tb_token` ( `id` bigint(20) NOT NULL COMMENT 'id', `user_id` bigint(20) NOT NULL COMMENT '用户ID', `token` varchar(100) NOT NULL COMMENT 'token', `expire_date` datetime DEFAULT NULL COMMENT '过期时间', `update_date` datetime DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `user_id` (`user_id`), UNIQUE KEY `token` (`token`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户Token'; -- ---------------------------- -- Records of tb_token -- ---------------------------- -- ---------------------------- -- Table structure for `tb_user` -- ---------------------------- DROP TABLE IF EXISTS `tb_user`; CREATE TABLE `tb_user` ( `id` bigint(20) NOT NULL COMMENT 'id', `username` varchar(50) NOT NULL COMMENT '用户名', `mobile` varchar(20) NOT NULL COMMENT '手机号', `password` varchar(64) DEFAULT NULL COMMENT '密码', `create_date` datetime DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`id`), UNIQUE KEY `username` (`username`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户'; -- ---------------------------- -- Records of tb_user -- ---------------------------- INSERT INTO `tb_user` VALUES ('1067246875900000001', 'toby', '13612345678', '8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918', '2024-04-07 11:51:15');