/*
|
Navicat Premium Data Transfer
|
|
Source Server : localhost
|
Source Server Type : MySQL
|
Source Server Version : 80035
|
Source Host : localhost:3306
|
Source Schema : quartz
|
|
Target Server Type : MySQL
|
Target Server Version : 80035
|
File Encoding : 65001
|
|
Date: 24/01/2024 12:03:14
|
*/
|
|
SET NAMES utf8mb4;
|
SET FOREIGN_KEY_CHECKS = 0;
|
|
-- ----------------------------
|
-- Table structure for interface_log
|
-- ----------------------------
|
DROP TABLE IF EXISTS `interface_log`;
|
CREATE TABLE `interface_log` (
|
`uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`interfaceName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`createTime` datetime(0) NULL DEFAULT NULL,
|
`prams` json NULL,
|
`result` json NULL,
|
PRIMARY KEY (`uuid`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of interface_log
|
-- ----------------------------
|
INSERT INTO `interface_log` VALUES ('dbc717ef-d280-4b32-999d-0b2fcfc5da25', '局域物料名称编码数据获取', '127.0.0.1:8080', '2024-01-24 03:43:28', '{\"size\": 1, \"pages\": 303, \"total\": 303, \"orders\": [], \"current\": 1, \"records\": [{\"id\": 1668994782539, \"pym\": \"gmy\", \"name\": \"感冒药\", \"note\": \"\", \"attri1\": \"\", \"attri2\": \"\", \"attri3\": \"\", \"attri4\": \"\", \"attri5\": \"\", \"attri6\": \"\", \"attri7\": \"\", \"attri8\": \"\", \"attri9\": \"\", \"nameen\": \"abc\", \"status\": \"200\", \"appfrom\": \"1\", \"attri10\": \"\", \"attri11\": \"\", \"attri12\": \"产品\", \"attri13\": \"1667957805944\", \"attri14\": \"\", \"attri15\": \"0003.000\", \"aliascode\": \"000\", \"companyid\": \"1560000581165\", \"updatedat\": 1668995367562, \"employeeid\": \"\", \"regioncode\": \"\", \"repeatflag\": \"\", \"updatetime\": 1668995367562, \"globtgccode\": \"\", \"regionlevel\": \"\", \"renewstatus\": \"new\", \"industrycode\": \"517\", \"industryname\": \"医药卫生保健化妆品业\", \"rebacklockflag\": \"\", \"applicationname\": \"审核管理员\", \"tgcoriginalcode\": \"9000000003.000\", \"ontologynamecode\": \"9000000003\", \"applicationaccountid\": \"D15600005811650001\"}], \"searchCount\": true}', '{\"msg\": \" 接口调用网络异常！！！ \", \"batchId\": \"dbc717ef-d280-4b32-999d-0b2fcfc5da25\"}');
|
|
-- ----------------------------
|
-- Table structure for mdm_data
|
-- ----------------------------
|
DROP TABLE IF EXISTS `mdm_data`;
|
CREATE TABLE `mdm_data` (
|
`type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`uuid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`tgcoriginalCode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`updatedat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`updatetime` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of mdm_data
|
-- ----------------------------
|
INSERT INTO `mdm_data` VALUES ('局域物料名称编码数据获取', '461d76fc-bb3a-47e1-8f30-5d4955cc49f7', '9000000003.000', '1668994782539', '1668995367562', '1668995367562');
|
|
-- ----------------------------
|
-- Table structure for qrtz_blob_triggers
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_blob_triggers`;
|
CREATE TABLE `qrtz_blob_triggers` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`BLOB_DATA` blob NULL,
|
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_blob_triggers
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for qrtz_calendars
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_calendars`;
|
CREATE TABLE `qrtz_calendars` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`CALENDAR_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`CALENDAR` blob NOT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_calendars
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for qrtz_cron_triggers
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_cron_triggers`;
|
CREATE TABLE `qrtz_cron_triggers` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`CRON_EXPRESSION` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TIME_ZONE_ID` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_cron_triggers
|
-- ----------------------------
|
INSERT INTO `qrtz_cron_triggers` VALUES ('clusteredScheduler', 'trigger局域物料名称编码数据获取', 'mdm', '*/5 * * * * ?', 'Asia/Shanghai');
|
|
-- ----------------------------
|
-- Table structure for qrtz_fired_triggers
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_fired_triggers`;
|
CREATE TABLE `qrtz_fired_triggers` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`ENTRY_ID` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`INSTANCE_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`FIRED_TIME` bigint(0) NOT NULL,
|
`SCHED_TIME` bigint(0) NOT NULL,
|
`PRIORITY` int(0) NOT NULL,
|
`STATE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`JOB_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`JOB_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_fired_triggers
|
-- ----------------------------
|
INSERT INTO `qrtz_fired_triggers` VALUES ('clusteredScheduler', 'niying17060688045361706068804564', 'trigger局域物料名称编码数据获取', 'mdm', 'niying1706068804536', 1706068990023, 1706068995000, 5, 'ACQUIRED', NULL, NULL, '0', '0');
|
|
-- ----------------------------
|
-- Table structure for qrtz_job_details
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_job_details`;
|
CREATE TABLE `qrtz_job_details` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`JOB_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`JOB_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`IS_DURABLE` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`JOB_DATA` blob NULL,
|
PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_job_details
|
-- ----------------------------
|
INSERT INTO `qrtz_job_details` VALUES ('clusteredScheduler', '局域物料名称编码数据获取', 'mdm', '测试任务', 'com.itstyle.mdm.job.MdmJob', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000D6A6F624D6574686F644E616D6574000D6F627461696E4D646D446174617800);
|
|
-- ----------------------------
|
-- Table structure for qrtz_locks
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_locks`;
|
CREATE TABLE `qrtz_locks` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`LOCK_NAME` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_locks
|
-- ----------------------------
|
INSERT INTO `qrtz_locks` VALUES ('clusteredScheduler', 'STATE_ACCESS');
|
INSERT INTO `qrtz_locks` VALUES ('clusteredScheduler', 'TRIGGER_ACCESS');
|
|
-- ----------------------------
|
-- Table structure for qrtz_paused_trigger_grps
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
|
CREATE TABLE `qrtz_paused_trigger_grps` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_paused_trigger_grps
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for qrtz_scheduler_state
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_scheduler_state`;
|
CREATE TABLE `qrtz_scheduler_state` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`INSTANCE_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`LAST_CHECKIN_TIME` bigint(0) NOT NULL,
|
`CHECKIN_INTERVAL` bigint(0) NOT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_scheduler_state
|
-- ----------------------------
|
INSERT INTO `qrtz_scheduler_state` VALUES ('clusteredScheduler', 'niying1706068804536', 1706068994912, 10000);
|
|
-- ----------------------------
|
-- Table structure for qrtz_simple_triggers
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_simple_triggers`;
|
CREATE TABLE `qrtz_simple_triggers` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`REPEAT_COUNT` bigint(0) NOT NULL,
|
`REPEAT_INTERVAL` bigint(0) NOT NULL,
|
`TIMES_TRIGGERED` bigint(0) NOT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_simple_triggers
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for qrtz_simprop_triggers
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
|
CREATE TABLE `qrtz_simprop_triggers` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`STR_PROP_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`STR_PROP_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`STR_PROP_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`INT_PROP_1` int(0) NULL DEFAULT NULL,
|
`INT_PROP_2` int(0) NULL DEFAULT NULL,
|
`LONG_PROP_1` bigint(0) NULL DEFAULT NULL,
|
`LONG_PROP_2` bigint(0) 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 utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`BOOL_PROP_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_simprop_triggers
|
-- ----------------------------
|
|
-- ----------------------------
|
-- Table structure for qrtz_triggers
|
-- ----------------------------
|
DROP TABLE IF EXISTS `qrtz_triggers`;
|
CREATE TABLE `qrtz_triggers` (
|
`SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`JOB_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`JOB_GROUP` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`NEXT_FIRE_TIME` bigint(0) NULL DEFAULT NULL,
|
`PREV_FIRE_TIME` bigint(0) NULL DEFAULT NULL,
|
`PRIORITY` int(0) NULL DEFAULT NULL,
|
`TRIGGER_STATE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`TRIGGER_TYPE` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
`START_TIME` bigint(0) NOT NULL,
|
`END_TIME` bigint(0) NULL DEFAULT NULL,
|
`CALENDAR_NAME` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`MISFIRE_INSTR` smallint(0) NULL DEFAULT NULL,
|
`JOB_DATA` blob NULL,
|
PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
INDEX `SCHED_NAME`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
|
CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of qrtz_triggers
|
-- ----------------------------
|
INSERT INTO `qrtz_triggers` VALUES ('clusteredScheduler', 'trigger局域物料名称编码数据获取', 'mdm', '局域物料名称编码数据获取', 'mdm', NULL, 1706068995000, 1706068990000, 5, 'ACQUIRED', 'CRON', 1706065947000, 0, NULL, 0, '');
|
|
-- ----------------------------
|
-- Table structure for sys_config
|
-- ----------------------------
|
DROP TABLE IF EXISTS `sys_config`;
|
CREATE TABLE `sys_config` (
|
`id` int(0) NOT NULL AUTO_INCREMENT,
|
`ADDRESS` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`cronExpression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`isEnable` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`sysName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
`association` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
PRIMARY KEY (`id`) USING BTREE
|
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
|
-- ----------------------------
|
-- Records of sys_config
|
-- ----------------------------
|
INSERT INTO `sys_config` VALUES (1, '127.0.0.1:8080', '局域物料名称编码数据接收', '2024-01-17', '启用', 'WMS仓储系统', '局域物料名称编码数据获取');
|
|
SET FOREIGN_KEY_CHECKS = 1;
|
