-- ---------------------------- -- Table structure for ACT_EVT_LOG -- ---------------------------- DROP TABLE IF EXISTS `ACT_EVT_LOG`; CREATE TABLE `ACT_EVT_LOG` ( `LOG_NR_` bigint NOT NULL AUTO_INCREMENT, `TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TIME_STAMP_` timestamp NOT NULL, `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DATA_` longblob NULL, `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `LOCK_TIME_` timestamp NULL DEFAULT NULL, `IS_PROCESSED_` tinyint NULL DEFAULT 0, PRIMARY KEY (`LOG_NR_`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_EVT_LOG -- ---------------------------- -- ---------------------------- -- Table structure for ACT_RE_DEPLOYMENT -- ---------------------------- DROP TABLE IF EXISTS `ACT_RE_DEPLOYMENT`; CREATE TABLE `ACT_RE_DEPLOYMENT` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', `DEPLOY_TIME_` timestamp NULL DEFAULT NULL, `ENGINE_VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_GE_BYTEARRAY -- ---------------------------- DROP TABLE IF EXISTS `ACT_GE_BYTEARRAY`; CREATE TABLE `ACT_GE_BYTEARRAY` ( `ID_` varchar(64) NOT NULL, `REV_` int NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `BYTES_` longblob NULL, `GENERATED_` tinyint NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_BYTEARR_DEPL`(`DEPLOYMENT_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_BYTEARR_DEPL` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_GE_PROPERTY -- ---------------------------- DROP TABLE IF EXISTS `ACT_GE_PROPERTY`; CREATE TABLE `ACT_GE_PROPERTY` ( `NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `VALUE_` varchar(300) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `REV_` int NULL DEFAULT NULL, PRIMARY KEY (`NAME_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_HI_ACTINST -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_ACTINST`; CREATE TABLE `ACT_HI_ACTINST` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CALL_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ACT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ACT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `START_TIME_` datetime NOT NULL, `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL, `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_START`(`START_TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_END`(`END_TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_PROCINST`(`PROC_INST_ID_` ASC, `ACT_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_ACT_INST_EXEC`(`EXECUTION_ID_` ASC, `ACT_ID_` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `URL_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CONTENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TIME_` datetime NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TIME_` datetime NOT NULL, `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ACTION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `MESSAGE_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `FULL_MSG_` longblob NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ACT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `REV_` int NULL DEFAULT NULL, `TIME_` datetime NOT NULL, `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DOUBLE_` double NULL DEFAULT NULL, `LONG_` bigint NULL DEFAULT NULL, `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_PROC_INST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_ACT_INST`(`ACT_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_TIME`(`TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_NAME`(`NAME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_DETAIL_TASK_ID`(`TASK_ID_` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_HI_DETAIL -- ---------------------------- -- ---------------------------- -- Table structure for ACT_HI_IDENTITYLINK -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_IDENTITYLINK`; CREATE TABLE `ACT_HI_IDENTITYLINK` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_IDENT_LNK_USER`(`USER_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_IDENT_LNK_TASK`(`TASK_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_IDENT_LNK_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `START_TIME_` datetime NOT NULL, `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL, `START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `START_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `END_ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `SUPER_PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `PROC_INST_ID_`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PRO_INST_END`(`END_TIME_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PRO_I_BUSKEY`(`BUSINESS_KEY_` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `START_TIME_` datetime NOT NULL, `CLAIM_TIME_` datetime NULL DEFAULT NULL, `END_TIME_` datetime NULL DEFAULT NULL, `DURATION_` bigint NULL DEFAULT NULL, `DELETE_REASON_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PRIORITY_` int NULL DEFAULT NULL, `DUE_DATE_` datetime NULL DEFAULT NULL, `FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_TASK_INST_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_HI_TASKINST -- ---------------------------- -- ---------------------------- -- Table structure for ACT_HI_VARINST -- ---------------------------- DROP TABLE IF EXISTS `ACT_HI_VARINST`; CREATE TABLE `ACT_HI_VARINST` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `VAR_TYPE_` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `REV_` int NULL DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DOUBLE_` double NULL DEFAULT NULL, `LONG_` bigint NULL DEFAULT NULL, `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CREATE_TIME_` datetime NULL DEFAULT NULL, `LAST_UPDATED_TIME_` datetime NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_HI_PROCVAR_PROC_INST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PROCVAR_NAME_TYPE`(`NAME_` ASC, `VAR_TYPE_` ASC) USING BTREE, INDEX `ACT_IDX_HI_PROCVAR_TASK_ID`(`TASK_ID_` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_HI_VARINST -- ---------------------------- -- ---------------------------- -- Table structure for ACT_ID_GROUP -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_GROUP`; CREATE TABLE `ACT_ID_GROUP` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `VALUE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PASSWORD_` longblob NULL, `PARENT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_ID_INFO -- ---------------------------- -- ---------------------------- -- Table structure for ACT_ID_USER -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_USER`; CREATE TABLE `ACT_ID_USER` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `FIRST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `LAST_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EMAIL_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PWD_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PICTURE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_ID_MEMBERSHIP -- ---------------------------- DROP TABLE IF EXISTS `ACT_ID_MEMBERSHIP`; CREATE TABLE `ACT_ID_MEMBERSHIP` ( `USER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `GROUP_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, PRIMARY KEY (`USER_ID_`, `GROUP_ID_`) USING BTREE, INDEX `ACT_FK_MEMB_GROUP`(`GROUP_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_MEMB_GROUP` FOREIGN KEY (`GROUP_ID_`) REFERENCES `ACT_ID_GROUP` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_MEMB_USER` FOREIGN KEY (`USER_ID_`) REFERENCES `ACT_ID_USER` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_ID_USER -- ---------------------------- -- ---------------------------- -- Table structure for ACT_RE_PROCDEF -- ---------------------------- DROP TABLE IF EXISTS `ACT_RE_PROCDEF`; CREATE TABLE `ACT_RE_PROCDEF` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `VERSION_` int NOT NULL, `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DGRM_RESOURCE_NAME_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HAS_START_FORM_KEY_` tinyint NULL DEFAULT NULL, `HAS_GRAPHICAL_NOTATION_` tinyint NULL DEFAULT NULL, `SUSPENSION_STATE_` int NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', `ENGINE_VERSION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `ACT_UNIQ_PROCDEF`(`KEY_` ASC, `VERSION_` ASC, `TENANT_ID_` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_PROCDEF_INFO -- ---------------------------- DROP TABLE IF EXISTS `ACT_PROCDEF_INFO`; CREATE TABLE `ACT_PROCDEF_INFO` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `INFO_JSON_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, UNIQUE INDEX `ACT_UNIQ_INFO_PROCDEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_IDX_INFO_PROCDEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_FK_INFO_JSON_BA`(`INFO_JSON_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_INFO_JSON_BA` FOREIGN KEY (`INFO_JSON_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_INFO_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_RE_MODEL -- ---------------------------- DROP TABLE IF EXISTS `ACT_RE_MODEL`; CREATE TABLE `ACT_RE_MODEL` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CREATE_TIME_` timestamp NULL DEFAULT NULL, `LAST_UPDATE_TIME_` timestamp NULL DEFAULT NULL, `VERSION_` int NULL DEFAULT NULL, `META_INFO_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DEPLOYMENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EDITOR_SOURCE_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EDITOR_SOURCE_EXTRA_VALUE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_MODEL_SOURCE`(`EDITOR_SOURCE_VALUE_ID_` ASC) USING BTREE, INDEX `ACT_FK_MODEL_SOURCE_EXTRA`(`EDITOR_SOURCE_EXTRA_VALUE_ID_` ASC) USING BTREE, INDEX `ACT_FK_MODEL_DEPLOYMENT`(`DEPLOYMENT_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_MODEL_DEPLOYMENT` FOREIGN KEY (`DEPLOYMENT_ID_`) REFERENCES `ACT_RE_DEPLOYMENT` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_MODEL_SOURCE` FOREIGN KEY (`EDITOR_SOURCE_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_MODEL_SOURCE_EXTRA` FOREIGN KEY (`EDITOR_SOURCE_EXTRA_VALUE_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_RU_EXECUTION -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_EXECUTION`; CREATE TABLE `ACT_RU_EXECUTION` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `BUSINESS_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PARENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `SUPER_EXEC_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ROOT_PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ACT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `IS_ACTIVE_` tinyint NULL DEFAULT NULL, `IS_CONCURRENT_` tinyint NULL DEFAULT NULL, `IS_SCOPE_` tinyint NULL DEFAULT NULL, `IS_EVENT_SCOPE_` tinyint NULL DEFAULT NULL, `IS_MI_ROOT_` tinyint NULL DEFAULT NULL, `SUSPENSION_STATE_` int NULL DEFAULT NULL, `CACHED_ENT_STATE_` int NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `START_TIME_` datetime NULL DEFAULT NULL, `START_USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `LOCK_TIME_` timestamp NULL DEFAULT NULL, `IS_COUNT_ENABLED_` tinyint NULL DEFAULT NULL, `EVT_SUBSCR_COUNT_` int NULL DEFAULT NULL, `TASK_COUNT_` int NULL DEFAULT NULL, `JOB_COUNT_` int NULL DEFAULT NULL, `TIMER_JOB_COUNT_` int NULL DEFAULT NULL, `SUSP_JOB_COUNT_` int NULL DEFAULT NULL, `DEADLETTER_JOB_COUNT_` int NULL DEFAULT NULL, `VAR_COUNT_` int NULL DEFAULT NULL, `ID_LINK_COUNT_` int NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_EXEC_BUSKEY`(`BUSINESS_KEY_` ASC) USING BTREE, INDEX `ACT_IDC_EXEC_ROOT`(`ROOT_PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_FK_EXE_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_FK_EXE_PARENT`(`PARENT_ID_` ASC) USING BTREE, INDEX `ACT_FK_EXE_SUPER`(`SUPER_EXEC_` ASC) USING BTREE, INDEX `ACT_FK_EXE_PROCDEF`(`PROC_DEF_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_EXE_PARENT` FOREIGN KEY (`PARENT_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE CASCADE ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_EXE_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, 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 ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_RU_DEADLETTER_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_DEADLETTER_JOB`; CREATE TABLE `ACT_RU_DEADLETTER_JOB` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DUEDATE_` timestamp NULL DEFAULT NULL, `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_DEADLETTER_JOB_EXECUTION`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_` ASC) USING BTREE, INDEX `ACT_FK_DEADLETTER_JOB_PROC_DEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_FK_DEADLETTER_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_DEADLETTER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_DEADLETTER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_RU_DEADLETTER_JOB -- ---------------------------- -- ---------------------------- -- Table structure for ACT_RU_EVENT_SUBSCR -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_EVENT_SUBSCR`; CREATE TABLE `ACT_RU_EVENT_SUBSCR` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `EVENT_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `EVENT_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ACTIVITY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CONFIGURATION_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CREATED_` timestamp NOT NULL DEFAULT CURRENT_timestamp, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_EVENT_SUBSCR_CONFIG_`(`CONFIGURATION_` ASC) USING BTREE, INDEX `ACT_FK_EVENT_EXEC`(`EXECUTION_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_EVENT_EXEC` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_RU_EVENT_SUBSCR -- ---------------------------- -- ---------------------------- -- Table structure for ACT_RU_TASK -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_TASK`; CREATE TABLE `ACT_RU_TASK` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DESCRIPTION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_DEF_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `ASSIGNEE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DELEGATION_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PRIORITY_` int NULL DEFAULT NULL, `CREATE_TIME_` timestamp NULL DEFAULT NULL, `DUE_DATE_` datetime NULL DEFAULT NULL, `CATEGORY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `SUSPENSION_STATE_` int NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', `FORM_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `CLAIM_TIME_` datetime NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_TASK_CREATE`(`CREATE_TIME_` ASC) USING BTREE, INDEX `ACT_FK_TASK_EXE`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_FK_TASK_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_FK_TASK_PROCDEF`(`PROC_DEF_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_TASK_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_TASK_PROCDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_TASK_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_RU_IDENTITYLINK -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_IDENTITYLINK`; CREATE TABLE `ACT_RU_IDENTITYLINK` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `GROUP_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `USER_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_IDENT_LNK_USER`(`USER_ID_` ASC) USING BTREE, INDEX `ACT_IDX_IDENT_LNK_GROUP`(`GROUP_ID_` ASC) USING BTREE, INDEX `ACT_IDX_ATHRZ_PROCEDEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_FK_TSKASS_TASK`(`TASK_ID_` ASC) USING BTREE, INDEX `ACT_FK_IDL_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_ATHRZ_PROCEDEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_IDL_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_TSKASS_TASK` FOREIGN KEY (`TASK_ID_`) REFERENCES `ACT_RU_TASK` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `RETRIES_` int NULL DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DUEDATE_` timestamp NULL DEFAULT NULL, `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_JOB_EXECUTION`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_FK_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_` ASC) USING BTREE, INDEX `ACT_FK_JOB_PROC_DEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_FK_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Table structure for ACT_RU_SUSPENDED_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_SUSPENDED_JOB`; CREATE TABLE `ACT_RU_SUSPENDED_JOB` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `RETRIES_` int NULL DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DUEDATE_` timestamp NULL DEFAULT NULL, `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_SUSPENDED_JOB_EXECUTION`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_` ASC) USING BTREE, INDEX `ACT_FK_SUSPENDED_JOB_PROC_DEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_FK_SUSPENDED_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_SUSPENDED_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_SUSPENDED_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_RU_SUSPENDED_JOB -- ---------------------------- -- ---------------------------- -- Table structure for ACT_RU_TIMER_JOB -- ---------------------------- DROP TABLE IF EXISTS `ACT_RU_TIMER_JOB`; CREATE TABLE `ACT_RU_TIMER_JOB` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `LOCK_EXP_TIME_` timestamp NULL DEFAULT NULL, `LOCK_OWNER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXCLUSIVE_` tinyint(1) NULL DEFAULT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROCESS_INSTANCE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `RETRIES_` int NULL DEFAULT NULL, `EXCEPTION_STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `EXCEPTION_MSG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DUEDATE_` timestamp NULL DEFAULT NULL, `REPEAT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `HANDLER_CFG_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT '', PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_FK_TIMER_JOB_EXECUTION`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_FK_TIMER_JOB_PROCESS_INSTANCE`(`PROCESS_INSTANCE_ID_` ASC) USING BTREE, INDEX `ACT_FK_TIMER_JOB_PROC_DEF`(`PROC_DEF_ID_` ASC) USING BTREE, INDEX `ACT_FK_TIMER_JOB_EXCEPTION`(`EXCEPTION_STACK_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_TIMER_JOB_EXCEPTION` FOREIGN KEY (`EXCEPTION_STACK_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_TIMER_JOB_EXECUTION` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_TIMER_JOB_PROC_DEF` FOREIGN KEY (`PROC_DEF_ID_`) REFERENCES `ACT_RE_PROCDEF` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_TIMER_JOB_PROCESS_INSTANCE` FOREIGN KEY (`PROCESS_INSTANCE_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- 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) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `REV_` int NULL DEFAULT NULL, `TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, `EXECUTION_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `BYTEARRAY_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `DOUBLE_` double NULL DEFAULT NULL, `LONG_` bigint NULL DEFAULT NULL, `TEXT_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `TEXT2_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`ID_`) USING BTREE, INDEX `ACT_IDX_VARIABLE_TASK_ID`(`TASK_ID_` ASC) USING BTREE, INDEX `ACT_FK_VAR_EXE`(`EXECUTION_ID_` ASC) USING BTREE, INDEX `ACT_FK_VAR_PROCINST`(`PROC_INST_ID_` ASC) USING BTREE, INDEX `ACT_FK_VAR_BYTEARRAY`(`BYTEARRAY_ID_` ASC) USING BTREE, CONSTRAINT `ACT_FK_VAR_BYTEARRAY` FOREIGN KEY (`BYTEARRAY_ID_`) REFERENCES `ACT_GE_BYTEARRAY` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT, CONSTRAINT `ACT_FK_VAR_PROCINST` FOREIGN KEY (`PROC_INST_ID_`) REFERENCES `ACT_RU_EXECUTION` (`ID_`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ACT_RU_VARIABLE -- ---------------------------- -- 代码业务表 -- ---------------------------- -- Table structure for gen_table -- ---------------------------- DROP TABLE IF EXISTS `gen_table`; CREATE TABLE `gen_table` ( `table_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号', `table_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表名称', `table_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '表描述', `sub_table_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '关联子表的表名', `sub_table_fk_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '子表关联的外键名', `class_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '实体类名称', `tpl_category` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'crud' COMMENT '使用的模板（crud单表操作 tree树表操作 sub主子表操作）', `package_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成包路径', `module_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成模块名', `business_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成业务名', `function_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能名', `function_author` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '生成功能作者', `gen_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '生成代码方式（0zip压缩包 1自定义路径）', `gen_path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '/' COMMENT '生成路径（不填默认项目路径）', `options` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '其它生成选项', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `parent_menu_id` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父级菜单', `parent_menu_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父级菜单名称', `tree_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '树表主键', `tree_parent_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '树表父级字段', `tree_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '树表父级名称', PRIMARY KEY (`table_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for gen_table_column 代码业务表字段 -- ---------------------------- DROP TABLE IF EXISTS `gen_table_column`; CREATE TABLE `gen_table_column` ( `column_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号', `table_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '归属表编号', `column_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列名称', `column_comment` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列描述', `column_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '列类型', `java_type` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA类型', `java_field` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'JAVA字段名', `is_pk` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否主键（1是）', `is_increment` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否自增（1是）', `is_required` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否必填（1是）', `is_insert` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否为插入字段（1是）', `is_edit` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否编辑字段（1是）', `is_list` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否列表字段（1是）', `is_query` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否查询字段（1是）', `query_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'EQ' COMMENT '查询方式（等于、不等于、大于、小于、范围）', `html_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '显示类型（文本框、文本域、下拉框、复选框、单选框、日期控件）', `dict_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '字典类型', `sort` int NULL DEFAULT NULL COMMENT '排序', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`column_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '代码生成业务表字段' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for schedule_fired_triggers -- ---------------------------- DROP TABLE IF EXISTS `schedule_fired_triggers`; CREATE TABLE `schedule_fired_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `ENTRY_ID` varchar(95) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `FIRED_TIME` bigint NOT NULL, `SCHED_TIME` bigint NOT NULL, `PRIORITY` int NOT NULL, `STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE, INDEX `IDX_QRTZ_FT_TRIG_INST_NAME`(`SCHED_NAME` ASC, `INSTANCE_NAME` ASC) USING BTREE, INDEX `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY`(`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC) USING BTREE, INDEX `IDX_QRTZ_FT_J_G`(`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC) USING BTREE, INDEX `IDX_QRTZ_FT_JG`(`SCHED_NAME` ASC, `JOB_GROUP` ASC) USING BTREE, INDEX `IDX_QRTZ_FT_T_G`(`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE, INDEX `IDX_QRTZ_FT_TG`(`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for schedule_job -- ---------------------------- DROP TABLE IF EXISTS `schedule_job`; CREATE TABLE `schedule_job` ( `job_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务id', `bean_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'spring bean名称', `params` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数', `cron_expression` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'cron表达式', `status` tinyint NULL DEFAULT NULL COMMENT '任务状态 0：正常 1：暂停', `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `job_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`job_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for schedule_job_details -- ---------------------------- DROP TABLE IF EXISTS `schedule_job_details`; CREATE TABLE `schedule_job_details` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `IS_DURABLE` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `JOB_DATA` blob NULL, PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE, INDEX `IDX_QRTZ_J_REQ_RECOVERY`(`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC) USING BTREE, INDEX `IDX_QRTZ_J_GRP`(`SCHED_NAME` ASC, `JOB_GROUP` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of schedule_job_details -- ---------------------------- -- ---------------------------- -- Table structure for schedule_locks -- ---------------------------- DROP TABLE IF EXISTS `schedule_locks`; CREATE TABLE `schedule_locks` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `LOCK_NAME` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of schedule_locks -- ---------------------------- -- ---------------------------- -- Table structure for schedule_log -- ---------------------------- DROP TABLE IF EXISTS `schedule_log`; CREATE TABLE `schedule_log` ( `log_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务日志id', `job_id` char(19) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '任务id', `bean_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'spring bean名称', `params` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '参数', `status` tinyint NOT NULL COMMENT '任务状态 0：成功 1：失败', `error` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '失败信息', `times` int NOT NULL COMMENT '耗时(单位：毫秒)', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`log_id`) USING BTREE, INDEX `job_id`(`job_id` ASC) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '定时任务日志' ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for schedule_paused_trigger_grps -- ---------------------------- DROP TABLE IF EXISTS `schedule_paused_trigger_grps`; CREATE TABLE `schedule_paused_trigger_grps` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of schedule_paused_trigger_grps -- ---------------------------- -- ---------------------------- -- Table structure for schedule_scheduler_state -- ---------------------------- DROP TABLE IF EXISTS `schedule_scheduler_state`; CREATE TABLE `schedule_scheduler_state` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `INSTANCE_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `LAST_CHECKIN_TIME` bigint NOT NULL, `CHECKIN_INTERVAL` bigint NOT NULL, PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for schedule_triggers -- ---------------------------- DROP TABLE IF EXISTS `schedule_triggers`; CREATE TABLE `schedule_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `JOB_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `JOB_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `DESCRIPTION` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `NEXT_FIRE_TIME` bigint NULL DEFAULT NULL, `PREV_FIRE_TIME` bigint NULL DEFAULT NULL, `PRIORITY` int NULL DEFAULT NULL, `TRIGGER_STATE` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `START_TIME` bigint NOT NULL, `END_TIME` bigint NULL DEFAULT NULL, `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `MISFIRE_INSTR` smallint NULL DEFAULT NULL, `JOB_DATA` blob NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, INDEX `IDX_QRTZ_T_J`(`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC) USING BTREE, INDEX `IDX_QRTZ_T_JG`(`SCHED_NAME` ASC, `JOB_GROUP` ASC) USING BTREE, INDEX `IDX_QRTZ_T_C`(`SCHED_NAME` ASC, `CALENDAR_NAME` ASC) USING BTREE, INDEX `IDX_QRTZ_T_G`(`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE, INDEX `IDX_QRTZ_T_STATE`(`SCHED_NAME` ASC, `TRIGGER_STATE` ASC) USING BTREE, INDEX `IDX_QRTZ_T_N_STATE`(`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC) USING BTREE, INDEX `IDX_QRTZ_T_N_G_STATE`(`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC) USING BTREE, INDEX `IDX_QRTZ_T_NEXT_FIRE_TIME`(`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC) USING BTREE, INDEX `IDX_QRTZ_T_NFT_ST`(`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC) USING BTREE, INDEX `IDX_QRTZ_T_NFT_MISFIRE`(`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC) USING BTREE, INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE`(`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC) USING BTREE, INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP`(`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC) USING BTREE, CONSTRAINT `schedule_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `schedule_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for schedule_blob_triggers -- ---------------------------- DROP TABLE IF EXISTS `schedule_blob_triggers`; CREATE TABLE `schedule_blob_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `BLOB_DATA` blob NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, INDEX `SCHED_NAME`(`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE, CONSTRAINT `schedule_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `schedule_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of schedule_blob_triggers -- ---------------------------- -- ---------------------------- -- Table structure for schedule_calendars -- ---------------------------- DROP TABLE IF EXISTS `schedule_calendars`; CREATE TABLE `schedule_calendars` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `CALENDAR_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `CALENDAR` blob NOT NULL, PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of schedule_calendars -- ---------------------------- -- ---------------------------- -- Table structure for schedule_cron_triggers -- ---------------------------- DROP TABLE IF EXISTS `schedule_cron_triggers`; CREATE TABLE `schedule_cron_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, CONSTRAINT `schedule_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `schedule_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for schedule_simple_triggers -- ---------------------------- DROP TABLE IF EXISTS `schedule_simple_triggers`; CREATE TABLE `schedule_simple_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `REPEAT_COUNT` bigint NOT NULL, `REPEAT_INTERVAL` bigint NOT NULL, `TIMES_TRIGGERED` bigint NOT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, CONSTRAINT `schedule_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `schedule_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of schedule_simple_triggers -- ---------------------------- -- ---------------------------- -- Table structure for schedule_simprop_triggers -- ---------------------------- DROP TABLE IF EXISTS `schedule_simprop_triggers`; CREATE TABLE `schedule_simprop_triggers` ( `SCHED_NAME` varchar(120) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_NAME` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `TRIGGER_GROUP` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `STR_PROP_1` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STR_PROP_2` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `STR_PROP_3` varchar(512) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `INT_PROP_1` int NULL DEFAULT NULL, `INT_PROP_2` int NULL DEFAULT NULL, `LONG_PROP_1` bigint NULL DEFAULT NULL, `LONG_PROP_2` bigint NULL DEFAULT NULL, `DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL, `DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL, `BOOL_PROP_1` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `BOOL_PROP_2` varchar(1) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE, CONSTRAINT `schedule_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `schedule_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_config -- ---------------------------- DROP TABLE IF EXISTS `sys_config`; CREATE TABLE `sys_config` ( `config_id` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置标识', `config_name` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置名称', `config_code` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置标识', `config_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置值', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `config_type` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '配置类型', PRIMARY KEY (`config_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_data_source -- ---------------------------- DROP TABLE IF EXISTS `sys_data_source`; CREATE TABLE `sys_data_source` ( `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据源编号', `name` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据源名称', `enable` bit(1) NULL DEFAULT NULL COMMENT '是否启用', `username` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名', `password` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码', `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `driver` char(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '驱动', `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_data_source -- ---------------------------- -- ---------------------------- -- Table structure for sys_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_dept`; CREATE TABLE `sys_dept` ( `dept_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称', `parent_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父级编号', `dept_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门名称', `sort` int NULL DEFAULT NULL COMMENT '排序', `leader` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '负责人', `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '联系方式', `email` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `status` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门状态', `create_by` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `remark` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '备注', `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详细地址', PRIMARY KEY (`dept_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_dict -- ---------------------------- DROP TABLE IF EXISTS `sys_dict`; CREATE TABLE `sys_dict` ( `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标识', `type_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典类型名称', `type_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典类型标识', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典类型描述', `enable` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否启用', `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_dict_data -- ---------------------------- DROP TABLE IF EXISTS `sys_dict_data`; CREATE TABLE `sys_dict_data` ( `data_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标识', `data_label` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典标签', `data_value` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '字典值', `type_code` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '所属类型', `is_default` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否默认', `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `enable` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否启用', PRIMARY KEY (`data_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_file -- ---------------------------- DROP TABLE IF EXISTS `sys_file`; CREATE TABLE `sys_file` ( `id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标识', `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件名称', `file_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件描述', `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件路径', `file_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件类型', `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `target_date` datetime NULL DEFAULT NULL COMMENT '所属时间', `file_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '文件大小', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_log -- ---------------------------- DROP TABLE IF EXISTS `sys_log`; CREATE TABLE `sys_log` ( `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '相应消息体', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题', `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求方式', `business_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '业务类型', `request_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求方法', `operate_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作人', `operate_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作路径', `operate_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作地址', `request_param` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求参数', `response_body` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相应消息体', `success` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否成功', `error_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '异常信息', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述', `request_body` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '请求消息体', `browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '使用浏览器', `system_os` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '操作系统', `logging_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志类型，登录日志，操作日志', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_mail -- ---------------------------- DROP TABLE IF EXISTS `sys_mail`; CREATE TABLE `sys_mail` ( `mail_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮件id(主键)', `receiver` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0' COMMENT '收件人邮箱', `subject` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮件主体', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '邮件正文', `create_by` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送人', `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', PRIMARY KEY (`mail_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_notice -- ---------------------------- DROP TABLE IF EXISTS `sys_notice`; CREATE TABLE `sys_notice` ( `id` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '标题', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '内容', `sender` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '发送人', `accept` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '接收者', `type` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '类型', `create_by` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_power -- ---------------------------- DROP TABLE IF EXISTS `sys_power`; CREATE TABLE `sys_power` ( `power_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限编号', `power_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限名称', `power_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限类型', `power_code` char(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限标识', `power_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '权限路径', `open_type` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '打开方式', `parent_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '父类编号', `icon` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '图标', `sort` int NULL DEFAULT NULL COMMENT '排序', `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `enable` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否开启', PRIMARY KEY (`power_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_role -- ---------------------------- DROP TABLE IF EXISTS `sys_role`; CREATE TABLE `sys_role` ( `role_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色编号', `role_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色名称', `role_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色标识', `enable` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否启用', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `details` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '详情', `sort` int NULL DEFAULT NULL COMMENT '排序', `data_scope` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '数据权限', PRIMARY KEY (`role_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_role_dept -- ---------------------------- DROP TABLE IF EXISTS `sys_role_dept`; CREATE TABLE `sys_role_dept` ( `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `role_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `dept_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_role_dept -- ---------------------------- -- ---------------------------- -- Table structure for sys_role_power -- ---------------------------- DROP TABLE IF EXISTS `sys_role_power`; CREATE TABLE `sys_role_power` ( `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `role_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `power_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_user -- ---------------------------- DROP TABLE IF EXISTS `sys_user`; CREATE TABLE `sys_user` ( `user_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '编号', `username` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '账户', `password` char(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '密码', `salt` char(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '状态', `real_name` char(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '姓名', `email` char(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱', `avatar` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像', `sex` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别', `phone` char(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '电话', `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间', `create_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '创建人', `update_time` datetime NULL DEFAULT NULL COMMENT '修改时间', `update_by` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '修改人', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注', `enable` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否启用', `login` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否登录', `dept_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '部门编号', `last_time` datetime NULL DEFAULT NULL COMMENT '最后一次登录时间', PRIMARY KEY (`user_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for sys_user_role -- ---------------------------- DROP TABLE IF EXISTS `sys_user_role`; CREATE TABLE `sys_user_role` ( `id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '标识', `user_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户编号', `role_id` char(19) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '角色编号', PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Table structure for bz_anchor -- ---------------------------- DROP TABLE IF EXISTS `bz_anchor`; CREATE TABLE `bz_anchor` ( `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `platform` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `player_id` int(11) NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of bz_anchor -- ---------------------------- -- ---------------------------- -- Table structure for bz_anchor_studio -- ---------------------------- DROP TABLE IF EXISTS `bz_anchor_studio`; CREATE TABLE `bz_anchor_studio` ( `id` int(11) NOT NULL AUTO_INCREMENT, `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `platform` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `room_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `open_time` datetime NULL DEFAULT NULL, `close_time` datetime NULL DEFAULT NULL, `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `anchor_id` int(11) NULL DEFAULT NULL, `anchor_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `anchor_nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `anchor_logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `game_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of bz_anchor_studio -- ---------------------------- -- ---------------------------- -- Table structure for bz_game -- ---------------------------- DROP TABLE IF EXISTS `bz_game`; CREATE TABLE `bz_game` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `platform` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `create_time` datetime NOT NULL, `modify_time` timestamp ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of bz_game -- ---------------------------- -- ---------------------------- -- Table structure for bz_gift_record -- ---------------------------- DROP TABLE IF EXISTS `bz_gift_record`; CREATE TABLE `bz_gift_record` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'ID', `platform` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '平台', `game` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '游戏', `gift_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '礼物信息', `gift_count` int(11) NULL DEFAULT NULL COMMENT '礼物数量', `gift_value` decimal(10, 2) NULL DEFAULT NULL COMMENT '总价值', `status` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '礼物状态', `mode` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模式', `user_nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户昵称', `user_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户ID', `anchor_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主播CODE', `anchor_id` int(11) NULL DEFAULT NULL COMMENT '主播ID', `anchor_nick_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '主播昵称', `studio_id` int(11) NULL DEFAULT NULL COMMENT '直播间ID', `room_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'roomId', `publish_time` datetime NULL DEFAULT NULL COMMENT '赠送时间', `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `create_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `update_by` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of bz_gift_record -- ---------------------------- -- ---------------------------- -- Table structure for bz_player -- ---------------------------- DROP TABLE IF EXISTS `bz_player`; CREATE TABLE `bz_player` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `platform` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `card_no` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `card_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `create_time` datetime NULL DEFAULT NULL, `update_time` datetime NULL DEFAULT NULL, `status` varchar(20) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `create_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `update_by` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = DYNAMIC; INSERT INTO `gen_table` VALUES ('1787351729340153856', 'bz_player', '玩家账号管理', NULL, NULL, 'BzPlayer', 'crud', 'com.hy.modules.bz', 'bz', 'player', '生成并管理玩家账号', '伍月', '1', '/', 'null', '', '2024-05-06 13:20:35', '', '2024-05-06 21:11:08', '', '11', '卡密系统_公管', '', '', NULL); INSERT INTO `gen_table` VALUES ('1787659009898053632', 'bz_anchor_studio', '直播间列表', NULL, NULL, 'BzAnchorStudio', 'crud', 'com.hy.modules.bz', 'bz', 'anchorStudio', '主播直播间列表查询刷新', '伍月', '1', '/', 'null', '', '2024-05-07 09:41:35', '', '2024-05-07 09:45:52', '主播直播间列表查询刷新', '1787655461902745600', '直播数据_公管', '', '', NULL); INSERT INTO `gen_table` VALUES ('1787669839779725312', 'bz_gift_record', '礼物列表', NULL, NULL, 'BzGiftRecord', 'crud', 'com.hy.modules.bz', 'bz', 'giftRecord', '直播间礼物列表展示', '伍月', '1', '/', 'null', '', '2024-05-07 10:24:37', '', '2024-05-07 10:28:06', '', '1787655461902745600', '直播数据_公管', '', '', NULL); -- ---------------------------- -- Records of gen_table_column -- ---------------------------- INSERT INTO `gen_table_column` VALUES ('1787351729877024768', '1787351729340153856', 'id', 'ID', 'bigint(20)', 'Long', 'id', '1', '1', NULL, NULL, NULL, '1', NULL, 'EQ', 'input', 'input', 1, '', '2024-05-06 13:20:35', NULL, '2024-05-06 21:11:08'); INSERT INTO `gen_table_column` VALUES ('1787351730048991232', '1787351729340153856', 'platform', '平台', 'varchar(64)', 'String', 'platform', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'platform', 2, '', '2024-05-06 13:20:35', NULL, '2024-05-06 21:11:08'); INSERT INTO `gen_table_column` VALUES ('1787351730166431744', '1787351729340153856', 'card_no', '账号（登录名）', 'varchar(255)', 'String', 'cardNo', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', 'input', 3, '', '2024-05-06 13:20:35', NULL, '2024-05-06 21:11:08'); INSERT INTO `gen_table_column` VALUES ('1787351730279677952', '1787351729340153856', 'card_password', '密码', 'varchar(255)', 'String', 'cardPassword', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 4, '', '2024-05-06 13:20:35', NULL, '2024-05-06 21:11:08'); INSERT INTO `gen_table_column` VALUES ('1787351730397118464', '1787351729340153856', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, NULL, NULL, '1', '1', 'BETWEEN', 'datetime', 'input', 5, '', '2024-05-06 13:20:35', NULL, '2024-05-06 21:11:08'); INSERT INTO `gen_table_column` VALUES ('1787351730510364672', '1787351729340153856', 'modify_time', '最后修改时间', 'timestamp', 'Date', 'modifyTime', '0', '0', NULL, NULL, NULL, '1', NULL, 'EQ', 'datetime', 'input', 6, '', '2024-05-06 13:20:35', NULL, '2024-05-06 21:11:08'); INSERT INTO `gen_table_column` VALUES ('1787351730623610880', '1787351729340153856', 'status', '状态', 'varchar(20)', 'String', 'status', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'status', 7, '', '2024-05-06 13:20:35', NULL, '2024-05-06 21:11:08'); INSERT INTO `gen_table_column` VALUES ('1787659010288123904', '1787659009898053632', 'id', 'ID', 'int(11)', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', 'input', 1, '', '2024-05-07 09:41:35', NULL, '2024-05-07 09:45:52'); INSERT INTO `gen_table_column` VALUES ('1787659010413953024', '1787659009898053632', 'code', 'CODE', 'varchar(255)', 'String', 'code', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 2, '', '2024-05-07 09:41:35', NULL, '2024-05-07 09:45:52'); INSERT INTO `gen_table_column` VALUES ('1787659010535587840', '1787659009898053632', 'platform', '平台', 'varchar(64)', 'String', 'platform', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'platform', 3, '', '2024-05-07 09:41:35', NULL, '2024-05-07 09:45:52'); INSERT INTO `gen_table_column` VALUES ('1787659010661416960', '1787659009898053632', 'room_id', 'roomId', 'varchar(255)', 'String', 'roomId', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 4, '', '2024-05-07 09:41:35', NULL, '2024-05-07 09:45:52'); INSERT INTO `gen_table_column` VALUES ('1787659010812411904', '1787659009898053632', 'open_time', '开播时间', 'datetime', 'Date', 'openTime', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'datetime', 'input', 5, '', '2024-05-07 09:41:35', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659010946629632', '1787659009898053632', 'close_time', '下播时间', 'datetime', 'Date', 'closeTime', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'datetime', 'input', 6, '', '2024-05-07 09:41:35', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659011064070144', '1787659009898053632', 'status', '直播间状态', 'varchar(20)', 'String', 'status', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'radio', 'input', 7, '', '2024-05-07 09:41:35', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659011189899264', '1787659009898053632', 'anchor_id', '主播ID', 'int(11)', 'Long', 'anchorId', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', 'input', 8, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659011340894208', '1787659009898053632', 'anchor_name', '主播名称', 'varchar(255)', 'String', 'anchorName', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', 'input', 9, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659011475111936', '1787659009898053632', 'anchor_nick_name', '主播昵称', 'varchar(255)', 'String', 'anchorNickName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', 'input', 10, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659011605135360', '1787659009898053632', 'anchor_logo', '主播头像', 'varchar(255)', 'String', 'anchorLogo', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 11, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659011756130304', '1787659009898053632', 'game_name', '开播游戏', 'varchar(255)', 'String', 'gameName', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'tk_game', 12, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659011881959424', '1787659009898053632', 'create_time', '创建时间', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', 'input', 13, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659012011982848', '1787659009898053632', 'update_time', '更新时间', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', 'input', 14, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659012137811968', '1787659009898053632', 'create_by', '创建者', 'varchar(255)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', 'input', 15, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787659012272029696', '1787659009898053632', 'update_by', '更新者', 'varchar(255)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', 'input', 16, '', '2024-05-07 09:41:36', NULL, '2024-05-07 09:45:53'); INSERT INTO `gen_table_column` VALUES ('1787669840144629760', '1787669839779725312', 'id', 'ID', 'int(11)', 'Long', 'id', '1', '1', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', 'input', 1, '', '2024-05-07 10:24:37', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669840262070272', '1787669839779725312', 'platform', '平台', 'varchar(64)', 'String', 'platform', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'platform', 2, '', '2024-05-07 10:24:37', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669840383705088', '1787669839779725312', 'game', '游戏', 'varchar(255)', 'String', 'game', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'tk_game', 3, '', '2024-05-07 10:24:37', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669840505339904', '1787669839779725312', 'gift_info', '礼物信息', 'varchar(255)', 'String', 'giftInfo', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 4, '', '2024-05-07 10:24:37', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669840618586112', '1787669839779725312', 'gift_count', '礼物数量', 'int(11)', 'Long', 'giftCount', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 5, '', '2024-05-07 10:24:37', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669840736026624', '1787669839779725312', 'gift_value', '总价值', 'decimal(10,2)', 'BigDecimal', 'giftValue', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 6, '', '2024-05-07 10:24:37', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669840857661440', '1787669839779725312', 'status', '礼物状态', 'varchar(20)', 'String', 'status', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'gift_status', 7, '', '2024-05-07 10:24:37', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669840983490560', '1787669839779725312', 'mode', '模式', 'varchar(32)', 'String', 'mode', '0', '0', NULL, '1', '1', '1', '1', 'EQ', 'radio', 'gift_mode', 8, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841100931072', '1787669839779725312', 'user_nick_name', '用户昵称', 'varchar(255)', 'String', 'userNickName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', 'input', 9, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841214177280', '1787669839779725312', 'user_id', '用户ID', 'varchar(255)', 'String', 'userId', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 10, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841335812096', '1787669839779725312', 'anchor_code', '主播CODE', 'varchar(255)', 'String', 'anchorCode', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 11, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841449058304', '1787669839779725312', 'anchor_id', '主播ID', 'int(11)', 'Long', 'anchorId', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', 'input', 12, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841579081728', '1787669839779725312', 'anchor_nick_name', '主播昵称', 'varchar(255)', 'String', 'anchorNickName', '0', '0', NULL, '1', '1', '1', '1', 'LIKE', 'input', 'input', 13, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841683939328', '1787669839779725312', 'studio_id', '直播间ID', 'int(11)', 'Long', 'studioId', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', 'input', 14, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841809768448', '1787669839779725312', 'room_id', 'roomId', 'varchar(255)', 'String', 'roomId', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 15, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669841918820352', '1787669839779725312', 'publish_time', '赠送时间', 'datetime', 'Date', 'publishTime', '0', '0', NULL, '1', '1', '1', '1', 'BETWEEN', 'datetime', 'input', 16, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669842032066560', '1787669839779725312', 'create_time', 'null', 'datetime', 'Date', 'createTime', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'datetime', 'input', 17, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669842141118464', '1787669839779725312', 'update_time', 'null', 'datetime', 'Date', 'updateTime', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'datetime', 'input', 18, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669842258558976', '1787669839779725312', 'create_by', 'null', 'varchar(255)', 'String', 'createBy', '0', '0', NULL, '1', NULL, NULL, NULL, 'EQ', 'input', 'input', 19, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669842367610880', '1787669839779725312', 'update_by', 'null', 'varchar(255)', 'String', 'updateBy', '0', '0', NULL, '1', '1', NULL, NULL, 'EQ', 'input', 'input', 20, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `gen_table_column` VALUES ('1787669842485051392', '1787669839779725312', 'remark', '备注', 'varchar(255)', 'String', 'remark', '0', '0', NULL, '1', '1', '1', NULL, 'EQ', 'input', 'input', 21, '', '2024-05-07 10:24:38', NULL, '2024-05-07 10:28:06'); INSERT INTO `sys_power` VALUES ('1', '系统管理', '0', '', '', '', '0', 'layui-icon layui-icon layui-icon-set-fill', 9, NULL, NULL, '1309861917694623744', '2024-05-07 09:27:15', NULL, '1'); INSERT INTO `sys_power` VALUES ('11', '卡密系统_公管', '0', '', '', '', '0', 'layui-icon layui-icon layui-icon layui-icon layui-icon layui-icon-rate', 1, NULL, NULL, '1309861917694623744', '2024-05-07 09:27:22', NULL, '1'); INSERT INTO `sys_power` VALUES ('1304387665067507712', '数据字典', '1', 'sys:dictType:main', '/system/dictType/main', '_iframe', '1', 'layui-icon layui-icon layui-icon layui-icon layui-icon-flag', 4, NULL, NULL, NULL, NULL, NULL, '1'); INSERT INTO `sys_power` VALUES ('1322085079861690368', '用户管理', '1', 'sys:user:main', '/system/user/main', '_iframe', '1', 'layui-icon layui-icon layui-icon layui-icon layui-icon-rate', 0, NULL, NULL, NULL, NULL, NULL, '1'); INSERT INTO `sys_power` VALUES ('1787366016288817152', '玩家账号管理', '1', 'bz:player:main', '/bz/player/main', '_iframe', '11', 'layui-icon layui-icon layui-icon-friends', 0, '1309861917694623744', '2024-05-06 14:17:20', '1309861917694623744', '2024-05-06 14:51:10', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787655461902745600', '直播数据_公管', '0', '', '', '', '0', 'layui-icon layui-icon-home', 0, '1309861917694623744', '2024-05-07 09:27:29', '1309861917694623744', '2024-05-07 09:28:39', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787660995494150144', '直播列表', '1', 'bz:anchorStudio:main', '/bz/anchorStudio/main', '_iframe', '1787655461902745600', 'layui-icon layui-icon-service', 0, '1309861917694623744', '2024-05-07 09:49:29', '1309861917694623744', '2024-05-07 09:49:39', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787672291962781696', '礼物列表', '1', 'bz:giftRecord:main', '/bz/giftRecord/main', '_iframe', '1787655461902745600', 'layui-icon layui-icon-star', 1, '1309861917694623744', '2024-05-07 10:34:22', '1309861917694623744', '2024-05-07 10:34:37', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787791179299946496', '数据权限', '1', 'bz:player:data', '/bz/player/data', '_iframe', '1787366016288817152', 'layui-icon layui-icon-home', NULL, '1309861917694623744', '2024-05-07 18:26:47', '1309861917694623744', '2024-05-07 18:26:50', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787791325840539648', '新增', '1', 'bz:player:add', '/bz/player/add', '_blank', '1787366016288817152', 'layui-icon layui-icon-home', NULL, '1309861917694623744', '2024-05-07 18:27:22', '1309861917694623744', '2024-05-07 18:28:32', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787791503762915328', '删除', '1', 'bz:player:remove', '/bz/player/remove', '_blank', '1787366016288817152', 'layui-icon layui-icon-home', NULL, '1309861917694623744', '2024-05-07 18:28:04', '1309861917694623744', '2024-05-07 18:28:32', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787791603612516352', '修改', '1', 'bz:player:edit', '/bz/player/edit', '_blank', '1787366016288817152', 'layui-icon layui-icon-home', NULL, '1309861917694623744', '2024-05-07 18:28:28', '1309861917694623744', '2024-05-07 18:28:33', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787792081784143872', '查询列表', '1', 'bz:anchorStudio:data', '/bz/anchorStudio/data', '_iframe', '1787660995494150144', 'layui-icon layui-icon-home', NULL, '1309861917694623744', '2024-05-07 18:30:22', '1309861917694623744', '2024-05-07 18:30:27', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787792247127801856', '查询列表', '1', 'bz:giftRecord:data', '/bz/giftRecord/data', '_blank', '1787672291962781696', 'layui-icon layui-icon-home', NULL, '1309861917694623744', '2024-05-07 18:31:01', '1309861917694623744', '2024-05-07 18:31:30', NULL, '1'); INSERT INTO `sys_power` VALUES ('1787792354896248832', '查询统计信息', '1', 'bz:giftRecord:statistics', '/bz/giftRecord/statistics', '_blank', '1787672291962781696', 'layui-icon layui-icon-home', NULL, '1309861917694623744', '2024-05-07 18:31:27', '1309861917694623744', '2024-05-07 18:31:30', NULL, '1'); INSERT INTO `sys_power` VALUES ('3', '角色管理', '1', 'sys:role:main', '/system/role/main', '_iframe', '1', 'layui-icon layui-icon-user', 1, NULL, NULL, NULL, NULL, NULL, '1'); INSERT INTO `sys_power` VALUES ('4', '权限管理', '1', 'sys:power:main', '/system/power/main', '_iframe', '1', 'layui-icon layui-icon-vercode', 2, NULL, NULL, NULL, NULL, NULL, '1'); INSERT INTO `sys_power` VALUES ('442417411065516032', '开发工具', '0', '', '', '', '0', 'layui-icon layui-icon layui-icon layui-icon layui-icon-senior', 10, NULL, NULL, '1309861917694623744', '2024-05-07 09:27:02', NULL, '1'); INSERT INTO `sys_power` VALUES ('694203311615639552', '接口文档', '1', 'sys:doc:main', '/system/doc/main', '_iframe', '442417411065516032', 'layui-icon layui-icon layui-icon layui-icon layui-icon layui-icon layui-icon layui-icon layui-icon layui-icon-chart', 9, NULL, NULL, '1309861917694623744', '2024-05-07 12:46:35', NULL, '1'); INSERT INTO `sys_role` VALUES ('1309851245195821056', '超级管理员', 'admin', '1', NULL, NULL, '2024-05-06 14:17:50', '1309861917694623744', NULL, '超级管理员', 1, 'ALL'); INSERT INTO `sys_role` VALUES ('1313761100243664896', '普通管理员', 'manager', '1', NULL, NULL, '2024-05-06 14:17:51', '1309861917694623744', NULL, '普通管理员', 2, NULL); INSERT INTO `sys_role` VALUES ('1356112133691015168', '应急管理员', 'users', '1', NULL, NULL, '2024-05-06 14:17:51', '1309861917694623744', NULL, '应急管理员', 2, NULL); INSERT INTO `sys_role` VALUES ('1787702360502611969', '前端开发', 'front_developer', '1', '2024-05-07 12:33:51', '1309861917694623744', '2024-05-07 12:33:51', '1309861917694623744', NULL, '前端开发人员', 3, 'ALL'); INSERT INTO `sys_role_power` VALUES ('1787655564503810048', '1309851245195821056', '1', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810049', '1309851245195821056', '1304387665067507712', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810053', '1309851245195821056', '1322085079861690368', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810057', '1309851245195821056', '3', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810058', '1309851245195821056', '4', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810059', '1309851245195821056', '11', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810060', '1309851245195821056', '1787366016288817152', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810061', '1309851245195821056', '1787655461902745600', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810062', '1309851245195821056', '442417411065516032', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655564503810066', '1309851245195821056', '694203311615639552', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655634871648256', '1356112133691015168', '1', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655634871648257', '1356112133691015168', '1304387665067507712', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655634871648261', '1356112133691015168', '1322085079861690368', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655634871648265', '1356112133691015168', '3', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787655634871648266', '1356112133691015168', '4', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787705608326086656', '1787702360502611969', '442417411065516032', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787705608326086657', '1787702360502611969', '694203311615639552', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541056', '1313761100243664896', '11', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541057', '1313761100243664896', '1787366016288817152', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541058', '1313761100243664896', '1787791179299946496', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541059', '1313761100243664896', '1787791325840539648', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541060', '1313761100243664896', '1787791503762915328', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541061', '1313761100243664896', '1787791603612516352', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541062', '1313761100243664896', '1787655461902745600', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541063', '1313761100243664896', '1787660995494150144', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541064', '1313761100243664896', '1787792081784143872', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541065', '1313761100243664896', '1787672291962781696', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541066', '1313761100243664896', '1787792247127801856', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_role_power` VALUES ('1787792416682541067', '1313761100243664896', '1787792354896248832', NULL, NULL, NULL, NULL, NULL); INSERT INTO `sys_dict` VALUES ('1787451635828523008', '来源平台', 'platform', '星际战争来源数据平台', '0', '1309861917694623744', '2024-05-06 19:57:33', '1309861917694623744', '2024-05-06 19:57:33', NULL); INSERT INTO `sys_dict` VALUES ('1787452228324294656', '账号状态', 'status', '星际战争游戏账号状态', '0', '1309861917694623744', '2024-05-06 19:59:55', '1309861917694623744', '2024-05-06 19:59:55', NULL); INSERT INTO `sys_dict` VALUES ('1787471972762910720', '游戏', 'tk_game', 'tiktok平台游戏', '0', '1309861917694623744', '2024-05-06 21:18:22', '1309861917694623744', '2024-05-06 21:18:22', NULL); INSERT INTO `sys_dict` VALUES ('1787472340498513920', '礼物', 'tk_gift', 'tk平台礼物', '0', '1309861917694623744', '2024-05-06 21:19:50', '1309861917694623744', '2024-05-06 21:19:50', NULL); INSERT INTO `sys_dict` VALUES ('1787657442067218432', '直播间状态', 'tk_room_status', 'tk直播间状态', '0', '1309861917694623744', '2024-05-07 09:35:21', '1309861917694623744', '2024-05-07 09:35:21', NULL); INSERT INTO `sys_dict` VALUES ('1787668653152403456', '直播间礼物状态', 'gift_status', 'tk直播间礼物状态', '0', '1309861917694623744', '2024-05-07 10:19:54', '1309861917694623744', '2024-05-07 10:20:05', NULL); INSERT INTO `sys_dict` VALUES ('1787669084435906560', '礼物模式', 'gift_mode', 'tk直播间礼物模式', '0', '1309861917694623744', '2024-05-07 10:21:37', '1309861917694623744', '2024-05-07 10:21:47', NULL); INSERT INTO `sys_dict_data` VALUES ('1787451835133460480', 'TikTok', 'Tiktok', 'platform', NULL, '1309861917694623744', '2024-05-06 19:58:21', '1309861917694623744', '2024-05-06 19:58:21', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787452402559877120', '正常', 'normal', 'status', NULL, '1309861917694623744', '2024-05-06 20:00:36', '1309861917694623744', '2024-05-06 20:00:36', '正常状态，可登录', '0'); INSERT INTO `sys_dict_data` VALUES ('1787452509103587328', '禁用', 'abnormal', 'status', NULL, '1309861917694623744', '2024-05-06 20:01:02', '1309861917694623744', '2024-05-06 20:01:02', '禁用状态', '0'); INSERT INTO `sys_dict_data` VALUES ('1787472071094173696', '星际战争', '1', 'tk_game', NULL, '1309861917694623744', '2024-05-06 21:18:46', '1309861917694623744', '2024-05-06 21:18:46', 'tk 星际战争', '0'); INSERT INTO `sys_dict_data` VALUES ('1787651188921991168', '仙女棒', '1', 'tk_gift', NULL, '1309861917694623744', '2024-05-07 09:10:31', '1309861917694623744', '2024-05-07 09:10:31', '人类方提升防护服/僵尸方出普通僵尸', '0'); INSERT INTO `sys_dict_data` VALUES ('1787651468094865408', '能力药丸', '10', 'tk_gift', NULL, '1309861917694623744', '2024-05-07 09:11:37', '1309861917694623744', '2024-05-07 09:11:37', '人类方武器升级x1/僵尸方出动物僵尸', '0'); INSERT INTO `sys_dict_data` VALUES ('1787651581672423424', '魔法镜', '19', 'tk_gift', NULL, '1309861917694623744', '2024-05-07 09:12:04', '1309861917694623744', '2024-05-07 09:12:04', '人类方武器升级x3/僵尸方出僵尸士兵', '0'); INSERT INTO `sys_dict_data` VALUES ('1787651739776712704', '甜甜圈', '52', 'tk_gift', NULL, '1309861917694623744', '2024-05-07 09:12:42', '1309861917694623744', '2024-05-07 09:12:42', '人类方医疗包加血/僵尸方出僵尸军官', '0'); INSERT INTO `sys_dict_data` VALUES ('1787651892730396672', '恶魔炸弹', '199', 'tk_gift', NULL, '1309861917694623744', '2024-05-07 09:13:18', '1309861917694623744', '2024-05-07 09:13:18', '人类方火箭筒120秒/僵尸方出boss', '0'); INSERT INTO `sys_dict_data` VALUES ('1787652105557770240', '超级空投', '888', 'tk_gift', NULL, '1309861917694623744', '2024-05-07 09:14:09', '1309861917694623744', '2024-05-07 09:14:09', '满血，加特林，火箭筒和护甲/920僵尸潮', '0'); INSERT INTO `sys_dict_data` VALUES ('1787657530755776512', '直播中', 'open', 'tk_room_status', NULL, '1309861917694623744', '2024-05-07 09:35:43', '1309861917694623744', '2024-05-07 09:35:43', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787657586057674752', '已下播', 'closed', 'tk_room_status', NULL, '1309861917694623744', '2024-05-07 09:35:56', '1309861917694623744', '2024-05-07 09:35:56', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787668786212503552', '接收', 'receive', 'gift_status', NULL, '1309861917694623744', '2024-05-07 10:20:26', '1309861917694623744', '2024-05-07 10:20:26', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787668849525522432', '处理中', 'processing', 'gift_status', NULL, '1309861917694623744', '2024-05-07 10:20:41', '1309861917694623744', '2024-05-07 10:20:41', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787668916676329472', '生效', 'finished', 'gift_status', NULL, '1309861917694623744', '2024-05-07 10:20:57', '1309861917694623744', '2024-05-07 10:20:57', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787668996271636480', '无效', 'invalid', 'gift_status', NULL, '1309861917694623744', '2024-05-07 10:21:16', '1309861917694623744', '2024-05-07 10:21:16', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787669192388902912', '主界面', 'main', 'gift_mode', NULL, '1309861917694623744', '2024-05-07 10:22:03', '1309861917694623744', '2024-05-07 10:22:03', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787669249142030336', '躲猫猫', 'hide', 'gift_mode', NULL, '1309861917694623744', '2024-05-07 10:22:16', '1309861917694623744', '2024-05-07 10:22:16', '', '0'); INSERT INTO `sys_dict_data` VALUES ('1787669311729434624', '人鬼大战', 'battle', 'gift_mode', NULL, '1309861917694623744', '2024-05-07 10:22:31', '1309861917694623744', '2024-05-07 10:22:31', '', '0'); INSERT INTO `sys_user` VALUES ('1309861917694623744', 'admin', '$2a$10$6T.NGloFO.mD/QOAUelMTOcjAH8N49h34TsXduDVlnNMrASIGBNz6', NULL, '1', '超级管理员', 'it_huiyang@163.com', '', '0', '18767121847', '2020-09-26 22:26:32', NULL, '2024-05-07 18:23:36', '1309861917694623744', '没什么', '1', NULL, '', '2024-05-07 18:23:36'); INSERT INTO `sys_user_role` VALUES ('1787366776036655104', '1309861917694623744', '1309851245195821056');