/* Navicat Premium Data Transfer Source Server : 47.92.229.224 Source Server Type : MySQL Source Server Version : 80032 Source Host : 47.92.229.224:3306 Source Schema : quartz Target Server Type : MySQL Target Server Version : 80032 File Encoding : 65001 Date: 18/09/2023 09:13:51 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- 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_general_ci NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `blob_data` blob NULL COMMENT '存放持久化Trigger对象', 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_general_ci COMMENT = 'Blob类型的触发器表' 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_general_ci NOT NULL COMMENT '调度名称', `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '日历名称', `calendar` blob NOT NULL COMMENT '存放持久化calendar对象', PRIMARY KEY (`sched_name`, `calendar_name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '日历信息表' 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_general_ci NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `cron_expression` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'cron表达式', `time_zone_id` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '时区', 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_general_ci COMMENT = 'Cron类型的触发器表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of QRTZ_CRON_TRIGGERS -- ---------------------------- INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME108', 'DEFAULT', '0/1 * * * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME109', 'DEFAULT', '0/2 * * * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME110', 'DEFAULT', '0/15 * * * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME111', 'DEFAULT', '0/30 * * * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME112', 'DEFAULT', '0 0 3 * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME113', 'DEFAULT', '0 0 1 * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME114', 'DEFAULT', '0 0 1 * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME115', 'DEFAULT', '0 20 3 1 * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME117', 'DEFAULT', '0 20 3 1 * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME118', 'DEFAULT', '0 0 3 * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME119', 'DEFAULT', '0 59 23 * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME120', 'DEFAULT', '0 0 3 * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME121', 'DEFAULT', '0 10 3,4,5,6 ? * MON', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME122', 'DEFAULT', '0 20 6 1 * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME123', 'DEFAULT', '0 0 7,10,14,17 * * ?', 'Asia/Shanghai'); INSERT INTO `QRTZ_CRON_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME124', 'DEFAULT', '0 0 1 * * ?', '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_general_ci NOT NULL COMMENT '调度名称', `entry_id` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度器实例id', `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度器实例名', `fired_time` bigint(0) NOT NULL COMMENT '触发的时间', `sched_time` bigint(0) NOT NULL COMMENT '定时器制定的时间', `priority` int(0) NOT NULL COMMENT '优先级', `state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态', `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务名称', `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '任务组名', `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否并发', `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '是否接受恢复执行', PRIMARY KEY (`sched_name`, `entry_id`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '已触发的触发器表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of QRTZ_FIRED_TRIGGERS -- ---------------------------- INSERT INTO `QRTZ_FIRED_TRIGGERS` VALUES ('xunmeiScheduler', 'iZ8vbhv0561f12sfxzcok2Z16948778141901694877822296', 'TASK_CLASS_NAME110', 'DEFAULT', 'iZ8vbhv0561f12sfxzcok2Z1694877814190', 1694999625014, 1694999640000, 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_general_ci NOT NULL COMMENT '调度名称', `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称', `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名', `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相关介绍', `job_class_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '执行任务类名称', `is_durable` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否持久化', `is_nonconcurrent` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否并发', `is_update_data` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否更新数据', `requests_recovery` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '是否接受恢复执行', `job_data` blob NULL COMMENT '存放持久化job对象', PRIMARY KEY (`sched_name`, `job_name`, `job_group`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '任务详细信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of QRTZ_JOB_DETAILS -- ---------------------------- INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME108', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C7565787000740009E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189F1ED8330787070707070707400013174000D302F31202A202A202A202A203F740013546573745461736B2E6E6F506172616D73282974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006C740012E6B58BE8AF95E5AE9AE697B6E4BBBBE58AA174000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME109', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C7565787000740009E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189F2D892F8787070707070707400013174000D302F32202A202A202A202A203F74001B546573745461736B2E796573506172616D73282761646D696E272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006D74001BE6B58BE8AF95E69C89E58F82E695B0E5AE9AE697B6E4BBBBE58AA174000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME110', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C7565787000740009E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B5974190300007870770800000189F2D9DF00787070707070707400013174000E302F3135202A202A202A202A203F740023546573745461736B2E6D616E79506172616D73282761646D696E272C2774657374272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006E740018E6B58BE8AF95E5A49AE4B8AAE58F82E695B0E696B9E6B39574000131740001307800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME111', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C7565787000740006E4BD95E682A67372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A2672A838787070707070707400013174000E302F3330202A202A202A202A203F74002653796E63466A6E784F7267557365725461736B2E73796E63466A6E784F7267416E645573657274000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000006F740016E5908CE6ADA5464A4E58E69CBAE69E84E794A8E688B774000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME112', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A4A6293E8787070707070707400013174000B3020302033202A202A203F74001D52657472696576616C5461736B2E72657472696576654461795461736B74000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000007074003AE8B083E99885E79B91E68EA7E6AF8FE697A5E6AF8FE591A8E4BBBBE58AA1EFBC88E6AF8FE5A4A9E5878CE699A833E782B9E689A7E8A18CEFBC8974000131740001307800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME113', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A4FB98D38787070707070707400013174000B3020302031202A202A203F740020436F7265456475547261696E696E675461736B2E6275696C644564755461736B74000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000007174001D456475E5AE9AE697B6E7949FE68890E4BBBBE58AA128E697A0E58F822974000131740001307800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME114', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A4FC387E8787070707070707400013174000B3020302031202A202A203F740030436F7265456475547261696E696E675461736B2E6275696C644564755461736B28276379636C65272C2764617465272974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000007274002A456475E5AE9AE697B6E7949FE68890E4BBBBE58AA128E69C89E58F822CE8A1A5E581BFE68EA5E58FA32974000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME115', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A53CE0408787070707070707400013174000C3020323020332031202A203F74001F52657472696576616C5461736B2E72657472696576654D6F6E74685461736B74000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000073740047E8B083E99885E79B91E68EA7E6AF8FE69C88E5ADA3E5BAA6E58D8AE5B9B4E5B9B4E4BBBBE58AA1EFBC88E6AF8FE69C8831E58FB7E5878CE699A8333A3230E689A7E8A18CEFBC8974000131740001307800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME117', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A54953050787070707070707400013174000C3020323020332031202A203F74004852657472696576616C5461736B2E72657472696576654D6F6E74685461736B4279446174652822E694B9E68890E585B7E4BD93E69F90E69C8831E697A5E79A84E697A5E69C9F222974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000075740033E8B083E99885E79B91E68EA7E6AF8FE69C88E5ADA3E5BAA6E58D8AE5B9B4E5B9B4E4BBBBE58AA1E8A1A5E69591E68EA5E58FA374000132740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME118', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A54CE39E0787070707070707400013174000B3020302033202A202A203F74003352657472696576616C5461736B2E72657472696576654461795461736B2822E694B9E68890E585B7E4BD93E697A5E69C9F222974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000076740024E8B083E99885E79B91E68EA7E6AF8FE697A5E6AF8FE591A8E4BBBBE58AA1E8A1A5E6959174000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME119', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A54D1A0F8787070707070707400013174000D30203539203233202A202A203F74001D52657472696576616C5461736B2E7570646174655461736B537461727474000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000077740027E4BFAEE694B9E79B91E68EA7E8B083E99885E4BBBBE58AA1E8B685E69C9FE79A84E68EA5E58FA374000131740001307800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME120', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzJobExecution', '0', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A6ED97E30787070707070707400013074000B3020302033202A202A203F74001F436F7265526573756D7074696F6E5461736B2E6275696C644461795461736B74000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000078740018E7949FE68890E6AF8FE697A5E5B1A5E8818CE4BBBBE58AA174000131740001307800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME121', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A6EDB241078707070707070740001317400143020313020332C342C352C36203F202A204D4F4E740020436F7265526573756D7074696F6E5461736B2E6275696C645765656B5461736B74000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B02000078700000000000000079740018E7949FE68890E6AF8FE591A8E5B1A5E8818CE4BBBBE58AA174000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME122', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A6EDC3D50787070707070707400013174000C3020323020362031202A203F740021436F7265526573756D7074696F6E5461736B2E6275696C644D6F6E74685461736B74000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000007A740018E7949FE68890E6AF8FE69C88E5B1A5E8818CE4BBBBE58AA174000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME123', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A8878D598787070707070707400013174001430203020372C31302C31342C3137202A202A203F74001A576561746865725461736B2E6765744461746146726F6D41706974000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000007B74001EE88EB7E58F96E681B6E58AA3E5A4A9E6B094E9A284E8ADA6E695B0E68DAE74000131740001317800); INSERT INTO `QRTZ_JOB_DETAILS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME124', 'DEFAULT', NULL, 'com.xunmei.job.util.QuartzDisallowConcurrentExecution', '0', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787001737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F4000000000000C7708000000100000000174000F5441534B5F50524F504552544945537372001C636F6D2E78756E6D65692E6A6F622E646F6D61696E2E5379734A6F6200000000000000010200084C000A636F6E63757272656E747400124C6A6176612F6C616E672F537472696E673B4C000E63726F6E45787072657373696F6E71007E00094C000C696E766F6B6554617267657471007E00094C00086A6F6247726F757071007E00094C00056A6F6249647400104C6A6176612F6C616E672F4C6F6E673B4C00076A6F624E616D6571007E00094C000D6D697366697265506F6C69637971007E00094C000673746174757371007E00097872002C636F6D2E78756E6D65692E636F6D6D6F6E2E636F72652E7765622E646F6D61696E2E42617365456E7469747900000000000000010200094C0008636865636B5375627400134C6A6176612F6C616E672F426F6F6C65616E3B4C0008637265617465427971007E00094C000A63726561746554696D657400104C6A6176612F7574696C2F446174653B4C0007706167654E756D71007E000A4C00087061676553697A6571007E000A4C0006706172616D7371007E00034C000B73656172636856616C756571007E00094C0008757064617465427971007E00094C000A75706461746554696D6571007E000D7870737200116A6176612E6C616E672E426F6F6C65616ECD207280D59CFAEE0200015A000576616C756578700074000FE8B685E7BAA7E7AEA1E79086E591987372000E6A6176612E7574696C2E44617465686A81014B597419030000787077080000018A8C90B768787070707070707400013174000B3020302031202A202A203F740027436F7265456475547261696E696E675461736B2E7570646174654564755461736B53746174757374000744454641554C547372000E6A6176612E6C616E672E4C6F6E673B8BE490CC8F23DF0200014A000576616C7565787200106A6176612E6C616E672E4E756D62657286AC951D0B94E08B0200007870000000000000007C74002F456475E5AE9AE697B6E5A484E79086E980BEE69C9FE4BBBBE58AA128E6AF8FE697A5E5878CE699A8E4B880E782B92974000131740001307800); -- ---------------------------- -- Table structure for QRTZ_LOCKS -- ---------------------------- DROP TABLE IF EXISTS `QRTZ_LOCKS`; CREATE TABLE `QRTZ_LOCKS` ( `sched_name` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调度名称', `lock_name` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '悲观锁名称', PRIMARY KEY (`sched_name`, `lock_name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '存储的悲观锁信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of QRTZ_LOCKS -- ---------------------------- INSERT INTO `QRTZ_LOCKS` VALUES ('xunmeiScheduler', 'STATE_ACCESS'); INSERT INTO `QRTZ_LOCKS` VALUES ('xunmeiScheduler', '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_general_ci NOT NULL COMMENT '调度名称', `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', PRIMARY KEY (`sched_name`, `trigger_group`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '暂停的触发器表' 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_general_ci NOT NULL COMMENT '调度名称', `instance_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '实例名称', `last_checkin_time` bigint(0) NOT NULL COMMENT '上次检查时间', `checkin_interval` bigint(0) NOT NULL COMMENT '检查间隔时间', PRIMARY KEY (`sched_name`, `instance_name`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '调度器状态表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of QRTZ_SCHEDULER_STATE -- ---------------------------- INSERT INTO `QRTZ_SCHEDULER_STATE` VALUES ('xunmeiScheduler', 'iZ8vbhv0561f12sfxzcok2Z1694877814190', 1694999627017, 15000); -- ---------------------------- -- 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_general_ci NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `repeat_count` bigint(0) NOT NULL COMMENT '重复的次数统计', `repeat_interval` bigint(0) NOT NULL COMMENT '重复的间隔时间', `times_triggered` bigint(0) NOT NULL COMMENT '已经触发的次数', 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_general_ci COMMENT = '简单触发器的信息表' 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_general_ci NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_name的外键', `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_triggers表trigger_group的外键', `str_prop_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第一个参数', `str_prop_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第二个参数', `str_prop_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'String类型的trigger的第三个参数', `int_prop_1` int(0) NULL DEFAULT NULL COMMENT 'int类型的trigger的第一个参数', `int_prop_2` int(0) NULL DEFAULT NULL COMMENT 'int类型的trigger的第二个参数', `long_prop_1` bigint(0) NULL DEFAULT NULL COMMENT 'long类型的trigger的第一个参数', `long_prop_2` bigint(0) NULL DEFAULT NULL COMMENT 'long类型的trigger的第二个参数', `dec_prop_1` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第一个参数', `dec_prop_2` decimal(13, 4) NULL DEFAULT NULL COMMENT 'decimal类型的trigger的第二个参数', `bool_prop_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第一个参数', `bool_prop_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'Boolean类型的trigger的第二个参数', 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_general_ci COMMENT = '同步机制的行锁表' 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_general_ci NOT NULL COMMENT '调度名称', `trigger_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器的名字', `trigger_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器所属组的名字', `job_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_job_details表job_name的外键', `job_group` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'qrtz_job_details表job_group的外键', `description` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '相关介绍', `next_fire_time` bigint(0) NULL DEFAULT NULL COMMENT '上一次触发时间（毫秒）', `prev_fire_time` bigint(0) NULL DEFAULT NULL COMMENT '下一次触发时间（默认为-1表示不触发）', `priority` int(0) NULL DEFAULT NULL COMMENT '优先级', `trigger_state` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器状态', `trigger_type` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '触发器的类型', `start_time` bigint(0) NOT NULL COMMENT '开始时间', `end_time` bigint(0) NULL DEFAULT NULL COMMENT '结束时间', `calendar_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日程表名称', `misfire_instr` smallint(0) NULL DEFAULT NULL COMMENT '补偿执行的策略', `job_data` blob NULL COMMENT '存放持久化job对象', 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_general_ci COMMENT = '触发器详细信息表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of QRTZ_TRIGGERS -- ---------------------------- INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME108', 'DEFAULT', 'TASK_CLASS_NAME108', 'DEFAULT', NULL, 1694877818000, -1, 5, 'PAUSED', 'CRON', 1694877818000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME109', 'DEFAULT', 'TASK_CLASS_NAME109', 'DEFAULT', NULL, 1694877820000, -1, 5, 'PAUSED', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME110', 'DEFAULT', 'TASK_CLASS_NAME110', 'DEFAULT', NULL, 1694999640000, 1694999625000, 5, 'ACQUIRED', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME111', 'DEFAULT', 'TASK_CLASS_NAME111', 'DEFAULT', NULL, 1694877840000, -1, 5, 'PAUSED', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME112', 'DEFAULT', 'TASK_CLASS_NAME112', 'DEFAULT', NULL, 1695063600000, 1694977200000, 5, 'WAITING', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME113', 'DEFAULT', 'TASK_CLASS_NAME113', 'DEFAULT', NULL, 1695056400000, 1694970000000, 5, 'WAITING', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME114', 'DEFAULT', 'TASK_CLASS_NAME114', 'DEFAULT', NULL, 1694883600000, -1, 5, 'PAUSED', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME115', 'DEFAULT', 'TASK_CLASS_NAME115', 'DEFAULT', NULL, 1696101600000, -1, 5, 'WAITING', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME117', 'DEFAULT', 'TASK_CLASS_NAME117', 'DEFAULT', NULL, 1696101600000, -1, 5, 'PAUSED', 'CRON', 1694877819000, 0, NULL, 1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME118', 'DEFAULT', 'TASK_CLASS_NAME118', 'DEFAULT', NULL, 1694890800000, -1, 5, 'PAUSED', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME119', 'DEFAULT', 'TASK_CLASS_NAME119', 'DEFAULT', NULL, 1695052740000, 1694966340000, 5, 'WAITING', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME120', 'DEFAULT', 'TASK_CLASS_NAME120', 'DEFAULT', NULL, 1695063600000, 1694977200000, 5, 'WAITING', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME121', 'DEFAULT', 'TASK_CLASS_NAME121', 'DEFAULT', NULL, 1694977800000, -1, 5, 'PAUSED', 'CRON', 1694877819000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME122', 'DEFAULT', 'TASK_CLASS_NAME122', 'DEFAULT', NULL, 1696112400000, -1, 5, 'PAUSED', 'CRON', 1694877820000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME123', 'DEFAULT', 'TASK_CLASS_NAME123', 'DEFAULT', NULL, 1694905200000, -1, 5, 'PAUSED', 'CRON', 1694877820000, 0, NULL, -1, ''); INSERT INTO `QRTZ_TRIGGERS` VALUES ('xunmeiScheduler', 'TASK_CLASS_NAME124', 'DEFAULT', 'TASK_CLASS_NAME124', 'DEFAULT', NULL, 1695056400000, 1694970000000, 5, 'WAITING', 'CRON', 1694877820000, 0, NULL, -1, ''); -- ---------------------------- -- Table structure for sys_job -- ---------------------------- DROP TABLE IF EXISTS `sys_job`; CREATE TABLE `sys_job` ( `job_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '任务ID', `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '任务名称', `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'DEFAULT' COMMENT '任务组名', `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串', `cron_expression` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT 'cron执行表达式', `misfire_policy` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '3' COMMENT '计划执行错误策略（1立即执行 2执行一次 3放弃执行）', `concurrent` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '1' COMMENT '是否并发执行（0允许 1禁止）', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '状态（0正常 1暂停）', `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '创建者', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '更新者', `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间', PRIMARY KEY (`job_id`, `job_name`, `job_group`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 125 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度表' ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of sys_job -- ---------------------------- INSERT INTO `sys_job` VALUES (108, '测试定时任务', 'DEFAULT', 'TestTask.noParams()', '0/1 * * * * ?', '1', '1', '1', '管理员', '2023-08-14 10:43:42', '管理员', '2023-08-14 14:59:20'); INSERT INTO `sys_job` VALUES (109, '测试有参数定时任务', 'DEFAULT', 'TestTask.yesParams(\'admin\')', '0/2 * * * * ?', '1', '1', '1', '管理员', '2023-08-14 15:00:27', '管理员', '2023-08-14 15:00:53'); INSERT INTO `sys_job` VALUES (110, '测试多个参数方法', 'DEFAULT', 'TestTask.manyParams(\'admin\',\'test\')', '0/15 * * * * ?', '1', '1', '0', '管理员', '2023-08-14 15:01:52', '', '2023-08-31 19:42:07'); INSERT INTO `sys_job` VALUES (111, '同步FJNX机构用户', 'DEFAULT', 'SyncFjnxOrgUserTask.syncFjnxOrgAndUser', '0/30 * * * * ?', '1', '1', '1', '何悦', '2023-08-24 15:29:23', '何悦', '2023-08-31 15:06:24'); INSERT INTO `sys_job` VALUES (112, '调阅监控每日每周任务（每天凌晨3点执行）', 'DEFAULT', 'RetrievalTask.retrieveDayTask', '0 0 3 * * ?', '1', '1', '0', '超级管理员', '2023-08-31 14:58:09', '超级管理员', '2023-09-02 15:25:24'); INSERT INTO `sys_job` VALUES (113, 'Edu定时生成任务(无参)', 'DEFAULT', 'CoreEduTrainingTask.buildEduTask', '0 0 1 * * ?', '1', '1', '0', '超级管理员', '2023-09-01 15:51:15', '超级管理员', '2023-09-01 17:19:06'); INSERT INTO `sys_job` VALUES (114, 'Edu定时生成任务(有参,补偿接口)', 'DEFAULT', 'CoreEduTrainingTask.buildEduTask(\'cycle\',\'date\')', '0 0 1 * * ?', '1', '1', '1', '超级管理员', '2023-09-01 16:02:09', '超级管理员', '2023-09-01 16:02:37'); INSERT INTO `sys_job` VALUES (115, '调阅监控每月季度半年年任务（每月1号凌晨3:20执行）', 'DEFAULT', 'RetrievalTask.retrieveMonthTask', '0 20 3 1 * ?', '1', '1', '0', '超级管理员', '2023-09-02 10:52:05', '', '2023-09-02 15:24:54'); INSERT INTO `sys_job` VALUES (117, '调阅监控每月季度半年年任务补救接口', 'DEFAULT', 'RetrievalTask.retrieveMonthTaskByDate(\"改成具体某月1日的日期\")', '0 20 3 1 * ?', '2', '1', '1', '超级管理员', '2023-09-02 14:29:38', '超级管理员', '2023-09-02 15:32:29'); INSERT INTO `sys_job` VALUES (118, '调阅监控每日每周任务补救', 'DEFAULT', 'RetrievalTask.retrieveDayTask(\"改成具体日期\")', '0 0 3 * * ?', '1', '1', '1', '超级管理员', '2023-09-02 15:31:56', '', NULL); INSERT INTO `sys_job` VALUES (119, '修改监控调阅任务超期的接口', 'DEFAULT', 'RetrievalTask.updateTaskStart', '0 59 23 * * ?', '1', '1', '0', '超级管理员', '2023-09-02 15:35:39', '', '2023-09-02 16:51:17'); INSERT INTO `sys_job` VALUES (120, '生成每日履职任务', 'DEFAULT', 'CoreResumptionTask.buildDayTask', '0 0 3 * * ?', '1', '0', '0', '超级管理员', '2023-09-07 16:54:22', 'jwx', '2023-09-15 14:50:23'); INSERT INTO `sys_job` VALUES (121, '生成每周履职任务', 'DEFAULT', 'CoreResumptionTask.buildWeekTask', '0 10 3,4,5,6 ? * MON', '1', '1', '1', '超级管理员', '2023-09-07 16:56:10', '', NULL); INSERT INTO `sys_job` VALUES (122, '生成每月履职任务', 'DEFAULT', 'CoreResumptionTask.buildMonthTask', '0 20 6 1 * ?', '1', '1', '1', '超级管理员', '2023-09-07 16:57:22', '', NULL); INSERT INTO `sys_job` VALUES (123, '获取恶劣天气预警数据', 'DEFAULT', 'WeatherTask.getDataFromApi', '0 0 7,10,14,17 * * ?', '1', '1', '1', '超级管理员', '2023-09-12 16:18:55', '', NULL); INSERT INTO `sys_job` VALUES (124, 'Edu定时处理逾期任务(每日凌晨一点)', 'DEFAULT', 'CoreEduTrainingTask.updateEduTaskStatus', '0 0 1 * * ?', '1', '1', '0', '超级管理员', '2023-09-13 11:23:29', '', '2023-09-13 11:26:41'); INSERT INTO `sys_job` VALUES (128, '履职临期提醒(除了每日的）', 'DEFAULT', 'CoreMessageSendTask.resumptionRemind', '0 0 0 * * ?', '1', '1', '0', '超级管理员', '2023-09-22 17:03:31', '', '2023-09-22 20:29:13'); INSERT INTO `sys_job` VALUES (125, '消息发送管理(每日凌晨零点）', 'DEFAULT', 'CoreMessageSendTask.messageSendTask', '0 0 0 * * ? *', '1', '1', '0', '超级管理员', '2023-09-21 12:30:22', '超级管理员', '2023-09-22 19:04:39'); -- ---------------------------- -- Table structure for sys_job_log -- ---------------------------- DROP TABLE IF EXISTS `sys_job_log`; CREATE TABLE `sys_job_log` ( `job_log_id` bigint(0) NOT NULL AUTO_INCREMENT COMMENT '任务日志ID', `job_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务名称', `job_group` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '任务组名', `invoke_target` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '调用目标字符串', `job_message` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '日志信息', `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '执行状态（0正常 1失败）', `exception_info` varchar(2000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '异常信息', `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间', PRIMARY KEY (`job_log_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 146802 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '定时任务调度日志表' ROW_FORMAT = Dynamic; SET FOREIGN_KEY_CHECKS = 1;