Головна сторінка Огляд Довідка
Увійти
cairuisen_citu
/
citu
1
0
Відгалуження 0
Файли Проблеми 0 Запити на злиття 0 Wiki
Дерево: d73b54d191
Гілки Теги
citu
/
sql
/
citu
/
xxl_job.sql

xxl_job.sql 38 KB
Історія Запис

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458 
  1. /*
    2. 

  2.  Navicat Premium Data Transfer
    3. 

  3. 

  4.  Source Server         : 192.168.3.80
    5. 

  5.  Source Server Type    : MySQL
    6. 

  6.  Source Server Version : 80020 (8.0.20)
    7. 

  7.  Source Host           : 192.168.3.80:3306
    8. 

  8.  Source Schema         : xxl_job
    9. 

  9. 

  10.  Target Server Type    : MySQL
    11. 

  11.  Target Server Version : 80020 (8.0.20)
    12. 

  12.  File Encoding         : 65001
    13. 

  13. 

  14.  Date: 27/03/2025 17:59:45
    15. 

  15. */
    16. 

  16. 

  17. SET NAMES utf8mb4;
    18. 

  18. SET FOREIGN_KEY_CHECKS = 0;
    19. 

  19. 

  20. -- ----------------------------
    21. 

  21. -- Table structure for xxl_job_group
    22. 

  22. -- ----------------------------
    23. 

  23. DROP TABLE IF EXISTS `xxl_job_group`;
    24. 

  24. CREATE TABLE `xxl_job_group`  (
    25. 

  25.   `id` int NOT NULL AUTO_INCREMENT,
    26. 

  26.   `app_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器AppName',
    27. 

  27.   `title` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '执行器名称',
    28. 

  28.   `address_type` tinyint NOT NULL DEFAULT 0 COMMENT '执行器地址类型：0=自动注册、1=手动录入',
    29. 

  29.   `address_list` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '执行器地址列表，多地址逗号分隔',
    30. 

  30.   `update_time` datetime NULL DEFAULT NULL,
    31. 

  31.   PRIMARY KEY (`id`) USING BTREE
    32. 

  32. ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    33. 

  33. 

  34. -- ----------------------------
    35. 

  35. -- Records of xxl_job_group
    36. 

  36. -- ----------------------------
    37. 

  37. INSERT INTO `xxl_job_group` VALUES (1, 'xxl-job-executor-sample', '示例执行器', 0, NULL, '2025-03-27 17:59:46');
    38. 

  38. INSERT INTO `xxl_job_group` VALUES (2, 'pay-server', '支付服务', 0, 'http://172.17.0.1:10000/', '2025-03-27 17:59:46');
    39. 

  39. INSERT INTO `xxl_job_group` VALUES (3, 'statistics-server', '统计服务', 0, 'http://172.17.0.1:10002/', '2025-03-27 17:59:46');
    40. 

  40. INSERT INTO `xxl_job_group` VALUES (4, 'promotion-server', '促销服务', 0, 'http://172.17.0.1:10004/', '2025-03-27 17:59:46');
    41. 

  41. INSERT INTO `xxl_job_group` VALUES (5, 'trade-server', '商城交易', 0, 'http://172.17.0.1:10001/', '2025-03-27 17:59:46');
    42. 

  42. INSERT INTO `xxl_job_group` VALUES (6, 'menduner-system-server', '门墩儿系统', 0, 'http://172.17.0.1:10003/', '2025-03-27 17:59:46');
    43. 

  43. 

  44. -- ----------------------------
    45. 

  45. -- Table structure for xxl_job_info
    46. 

  46. -- ----------------------------
    47. 

  47. DROP TABLE IF EXISTS `xxl_job_info`;
    48. 

  48. CREATE TABLE `xxl_job_info`  (
    49. 

  49.   `id` int NOT NULL AUTO_INCREMENT,
    50. 

  50.   `job_group` int NOT NULL COMMENT '执行器主键ID',
    51. 

  51.   `job_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    52. 

  52.   `add_time` datetime NULL DEFAULT NULL,
    53. 

  53.   `update_time` datetime NULL DEFAULT NULL,
    54. 

  54.   `author` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '作者',
    55. 

  55.   `alarm_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '报警邮件',
    56. 

  56.   `schedule_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'NONE' COMMENT '调度类型',
    57. 

  57.   `schedule_conf` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型',
    58. 

  58.   `misfire_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略',
    59. 

  59.   `executor_route_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器路由策略',
    60. 

  60.   `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务handler',
    61. 

  61.   `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务参数',
    62. 

  62.   `executor_block_strategy` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '阻塞处理策略',
    63. 

  63.   `executor_timeout` int NOT NULL DEFAULT 0 COMMENT '任务执行超时时间，单位秒',
    64. 

  64.   `executor_fail_retry_count` int NOT NULL DEFAULT 0 COMMENT '失败重试次数',
    65. 

  65.   `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE类型',
    66. 

  66.   `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'GLUE源代码',
    67. 

  67.   `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GLUE备注',
    68. 

  68.   `glue_updatetime` datetime NULL DEFAULT NULL COMMENT 'GLUE更新时间',
    69. 

  69.   `child_jobid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
    70. 

  70.   `trigger_status` tinyint NOT NULL DEFAULT 0 COMMENT '调度状态：0-停止，1-运行',
    71. 

  71.   `trigger_last_time` bigint NOT NULL DEFAULT 0 COMMENT '上次调度时间',
    72. 

  72.   `trigger_next_time` bigint NOT NULL DEFAULT 0 COMMENT '下次调度时间',
    73. 

  73.   PRIMARY KEY (`id`) USING BTREE
    74. 

  74. ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    75. 

  75. 

  76. -- ----------------------------
    77. 

  77. -- Records of xxl_job_info
    78. 

  78. -- ----------------------------
    79. 

  79. INSERT INTO `xxl_job_info` VALUES (1, 1, '测试任务1', '2018-11-03 22:21:31', '2018-11-03 22:21:31', 'XXL', '', 'CRON', '0 0 0 * * ? *', 'DO_NOTHING', 'FIRST', 'demoJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2018-11-03 22:21:31', '', 0, 0, 0);
    80. 

  80. INSERT INTO `xxl_job_info` VALUES (2, 2, '支付订单的过期', '2024-08-06 13:31:59', '2024-08-06 13:34:54', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'payOrderExpireJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-08-06 13:31:59', '', 1, 1743069540000, 1743069600000);
    81. 

  81. INSERT INTO `xxl_job_info` VALUES (3, 2, '支付通知', '2024-08-06 13:32:48', '2024-08-06 13:34:49', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'payNotifyJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-08-06 13:32:48', '', 1, 1743069540000, 1743069600000);
    82. 

  82. INSERT INTO `xxl_job_info` VALUES (4, 2, '支付订单的同步', '2024-08-06 13:33:11', '2024-08-06 13:34:43', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'payOrderSyncJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-08-06 13:33:11', '', 1, 1743069540000, 1743069600000);
    83. 

  83. INSERT INTO `xxl_job_info` VALUES (5, 2, '退款订单的同步', '2024-08-06 13:33:30', '2024-08-06 13:34:37', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'payRefundSyncJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-08-06 13:33:30', '', 1, 1743069540000, 1743069600000);
    84. 

  84. INSERT INTO `xxl_job_info` VALUES (6, 2, '转账订单的同步', '2024-08-06 13:33:48', '2024-08-06 13:33:48', 'Rayson', '', 'CRON', '* * * * * ?', 'DO_NOTHING', 'FIRST', 'payTransferSyncJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-08-06 13:33:48', '', 0, 0, 0);
    85. 

  85. INSERT INTO `xxl_job_info` VALUES (7, 3, '交易统计任务', '2024-09-02 11:02:10', '2024-09-02 11:35:08', 'xxl', '', 'CRON', '0 0 0 * * ?', 'DO_NOTHING', 'FIRST', 'tradeStatisticsJob', '1', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 11:02:10', '', 1, 1743004800000, 1743091200000);
    86. 

  86. INSERT INTO `xxl_job_info` VALUES (8, 3, '商品统计任务', '2024-09-02 11:35:42', '2024-09-02 11:35:49', 'xxl', '', 'CRON', '0 0 0 * * ?', 'DO_NOTHING', 'FIRST', 'productStatisticsJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 11:35:42', '', 1, 1743004800000, 1743091200000);
    87. 

  87. INSERT INTO `xxl_job_info` VALUES (9, 4, '优惠券过期扫描', '2024-09-02 11:51:37', '2024-09-02 11:51:46', 'xxl', '', 'CRON', '0 0/5 * * * ?', 'DO_NOTHING', 'FIRST', 'couponExpireJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 11:51:37', '', 1, 1743069300000, 1743069600000);
    88. 

  88. INSERT INTO `xxl_job_info` VALUES (10, 4, '拼团过期或自动成功', '2024-09-02 11:53:37', '2024-09-02 11:53:42', 'xxl', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'combinationRecordExpireJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 11:53:37', '', 1, 1743069540000, 1743069600000);
    89. 

  89. INSERT INTO `xxl_job_info` VALUES (11, 5, '订单过期扫描', '2024-09-02 12:00:09', '2024-09-02 12:00:14', 'xxl', '', 'CRON', '0 1-2 * * * ?', 'DO_NOTHING', 'FIRST', 'tradeOrderAutoCancelJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 12:00:09', '', 1, 1743066120000, 1743069660000);
    90. 

  90. INSERT INTO `xxl_job_info` VALUES (12, 5, '自动评论订单', '2024-09-02 12:00:57', '2024-09-02 12:01:02', 'xxl', '', 'CRON', '0 0 0 * * ?', 'DO_NOTHING', 'FIRST', 'tradeOrderAutoCommentJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 12:00:57', '', 1, 1743004800000, 1743091200000);
    91. 

  91. INSERT INTO `xxl_job_info` VALUES (13, 5, '自动收货', '2024-09-02 12:01:44', '2024-09-02 12:01:49', 'xxl', '', 'CRON', '0 0 0 * * ?', 'DO_NOTHING', 'FIRST', 'tradeOrderAutoReceiveJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 12:01:44', '', 1, 1743004800000, 1743091200000);
    92. 

  92. INSERT INTO `xxl_job_info` VALUES (14, 5, '自动解冻佣金', '2024-09-02 12:02:26', '2024-09-02 12:02:30', 'xxl', '', 'CRON', '0 0 0 * * ?', 'DO_NOTHING', 'FIRST', 'brokerageRecordUnfreezeJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-09-02 12:02:26', '', 1, 1743004800000, 1743091200000);
    93. 

  93. INSERT INTO `xxl_job_info` VALUES (15, 5, '交易订单的自动过期', '2024-12-31 14:53:10', '2024-12-31 14:56:24', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'tradeOrderAutoCancelJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-12-31 14:53:10', '', 1, 1743069540000, 1743069600000);
    94. 

  94. INSERT INTO `xxl_job_info` VALUES (16, 5, '交易订单的自动评论', '2024-12-31 14:53:38', '2024-12-31 14:56:18', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'tradeOrderAutoCommentJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-12-31 14:53:38', '', 1, 1743069540000, 1743069600000);
    95. 

  95. INSERT INTO `xxl_job_info` VALUES (17, 5, '交易订单的自动收货', '2024-12-31 14:54:02', '2024-12-31 14:56:11', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'tradeOrderAutoReceiveJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2024-12-31 14:54:02', '', 1, 1743069540000, 1743069600000);
    96. 

  96. INSERT INTO `xxl_job_info` VALUES (18, 6, '人才生日提示', '2025-01-10 14:34:15', '2025-01-10 14:35:41', 'Rayson', '', 'CRON', '0 0 8 * * ?', 'DO_NOTHING', 'FIRST', 'personBirthdayJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-01-10 14:34:15', '', 0, 0, 0);
    97. 

  97. INSERT INTO `xxl_job_info` VALUES (19, 6, '门墩儿交易订单的自动过期', '2025-01-10 14:36:36', '2025-01-10 15:03:17', 'Rayson', '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'tradeOrderAutoCancelJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-01-10 14:36:36', '', 1, 1743069540000, 1743069600000);
    98. 

  98. 

  99. -- ----------------------------
    100. 

  100. -- Table structure for xxl_job_lock
    101. 

  101. -- ----------------------------
    102. 

  102. DROP TABLE IF EXISTS `xxl_job_lock`;
    103. 

  103. CREATE TABLE `xxl_job_lock`  (
    104. 

  104.   `lock_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '锁名称',
    105. 

  105.   PRIMARY KEY (`lock_name`) USING BTREE
    106. 

  106. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    107. 

  107. 

  108. -- ----------------------------
    109. 

  109. -- Records of xxl_job_lock
    110. 

  110. -- ----------------------------
    111. 

  111. INSERT INTO `xxl_job_lock` VALUES ('schedule_lock');
    112. 

  112. 

  113. -- ----------------------------
    114. 

  114. -- Table structure for xxl_job_log
    115. 

  115. -- ----------------------------
    116. 

  116. DROP TABLE IF EXISTS `xxl_job_log`;
    117. 

  117. CREATE TABLE `xxl_job_log`  (
    118. 

  118.   `id` bigint NOT NULL AUTO_INCREMENT,
    119. 

  119.   `job_group` int NOT NULL COMMENT '执行器主键ID',
    120. 

  120.   `job_id` int NOT NULL COMMENT '任务，主键ID',
    121. 

  121.   `executor_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
    122. 

  122.   `executor_handler` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务handler',
    123. 

  123.   `executor_param` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务参数',
    124. 

  124.   `executor_sharding_param` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
    125. 

  125.   `executor_fail_retry_count` int NOT NULL DEFAULT 0 COMMENT '失败重试次数',
    126. 

  126.   `trigger_time` datetime NULL DEFAULT NULL COMMENT '调度-时间',
    127. 

  127.   `trigger_code` int NOT NULL COMMENT '调度-结果',
    128. 

  128.   `trigger_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '调度-日志',
    129. 

  129.   `handle_time` datetime NULL DEFAULT NULL COMMENT '执行-时间',
    130. 

  130.   `handle_code` int NOT NULL COMMENT '执行-状态',
    131. 

  131.   `handle_msg` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '执行-日志',
    132. 

  132.   `alarm_status` tinyint NOT NULL DEFAULT 0 COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
    133. 

  133.   PRIMARY KEY (`id`) USING BTREE,
    134. 

  134.   INDEX `I_trigger_time`(`trigger_time` ASC) USING BTREE,
    135. 

  135.   INDEX `I_handle_code`(`handle_code` ASC) USING BTREE
    136. 

  136. ) ENGINE = InnoDB AUTO_INCREMENT = 2156684 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    137. 

  137. 

  138. -- ----------------------------
    139. 

  139. -- Records of xxl_job_log
    140. 

  140. -- ----------------------------
    141. 

  141. 

  142. -- ----------------------------
    143. 

  143. -- Table structure for xxl_job_log_report
    144. 

  144. -- ----------------------------
    145. 

  145. DROP TABLE IF EXISTS `xxl_job_log_report`;
    146. 

  146. CREATE TABLE `xxl_job_log_report`  (
    147. 

  147.   `id` int NOT NULL AUTO_INCREMENT,
    148. 

  148.   `trigger_day` datetime NULL DEFAULT NULL COMMENT '调度-时间',
    149. 

  149.   `running_count` int NOT NULL DEFAULT 0 COMMENT '运行中-日志数量',
    150. 

  150.   `suc_count` int NOT NULL DEFAULT 0 COMMENT '执行成功-日志数量',
    151. 

  151.   `fail_count` int NOT NULL DEFAULT 0 COMMENT '执行失败-日志数量',
    152. 

  152.   `update_time` datetime NULL DEFAULT NULL,
    153. 

  153.   PRIMARY KEY (`id`) USING BTREE,
    154. 

  154.   UNIQUE INDEX `i_trigger_day`(`trigger_day` ASC) USING BTREE
    155. 

  155. ) ENGINE = InnoDB AUTO_INCREMENT = 237 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    156. 

  156. 

  157. -- ----------------------------
    158. 

  158. -- Records of xxl_job_log_report
    159. 

  159. -- ----------------------------
    160. 

  160. INSERT INTO `xxl_job_log_report` VALUES (1, '2024-08-06 00:00:00', 0, 2604, 8, NULL);
    161. 

  161. INSERT INTO `xxl_job_log_report` VALUES (2, '2024-08-05 00:00:00', 0, 0, 0, NULL);
    162. 

  162. INSERT INTO `xxl_job_log_report` VALUES (3, '2024-08-04 00:00:00', 0, 0, 0, NULL);
    163. 

  163. INSERT INTO `xxl_job_log_report` VALUES (4, '2024-08-07 00:00:00', 0, 5756, 4, NULL);
    164. 

  164. INSERT INTO `xxl_job_log_report` VALUES (5, '2024-08-08 00:00:00', 0, 5752, 8, NULL);
    165. 

  165. INSERT INTO `xxl_job_log_report` VALUES (6, '2024-08-09 00:00:00', 0, 5760, 0, NULL);
    166. 

  166. INSERT INTO `xxl_job_log_report` VALUES (7, '2024-08-10 00:00:00', 0, 5760, 0, NULL);
    167. 

  167. INSERT INTO `xxl_job_log_report` VALUES (8, '2024-08-11 00:00:00', 0, 5760, 0, NULL);
    168. 

  168. INSERT INTO `xxl_job_log_report` VALUES (9, '2024-08-12 00:00:00', 0, 5760, 0, NULL);
    169. 

  169. INSERT INTO `xxl_job_log_report` VALUES (10, '2024-08-13 00:00:00', 0, 5760, 0, NULL);
    170. 

  170. INSERT INTO `xxl_job_log_report` VALUES (11, '2024-08-14 00:00:00', 0, 5760, 0, NULL);
    171. 

  171. INSERT INTO `xxl_job_log_report` VALUES (12, '2024-08-15 00:00:00', 0, 5760, 0, NULL);
    172. 

  172. INSERT INTO `xxl_job_log_report` VALUES (13, '2024-08-16 00:00:00', 0, 5752, 8, NULL);
    173. 

  173. INSERT INTO `xxl_job_log_report` VALUES (14, '2024-08-17 00:00:00', 0, 5760, 0, NULL);
    174. 

  174. INSERT INTO `xxl_job_log_report` VALUES (15, '2024-08-18 00:00:00', 0, 5760, 0, NULL);
    175. 

  175. INSERT INTO `xxl_job_log_report` VALUES (16, '2024-08-19 00:00:00', 0, 5756, 4, NULL);
    176. 

  176. INSERT INTO `xxl_job_log_report` VALUES (17, '2024-08-20 00:00:00', 0, 5704, 56, NULL);
    177. 

  177. INSERT INTO `xxl_job_log_report` VALUES (18, '2024-08-21 00:00:00', 0, 5679, 81, NULL);
    178. 

  178. INSERT INTO `xxl_job_log_report` VALUES (19, '2024-08-22 00:00:00', 0, 5748, 12, NULL);
    179. 

  179. INSERT INTO `xxl_job_log_report` VALUES (20, '2024-08-23 00:00:00', 0, 5700, 60, NULL);
    180. 

  180. INSERT INTO `xxl_job_log_report` VALUES (21, '2024-08-24 00:00:00', 0, 5760, 0, NULL);
    181. 

  181. INSERT INTO `xxl_job_log_report` VALUES (22, '2024-08-25 00:00:00', 0, 5760, 0, NULL);
    182. 

  182. INSERT INTO `xxl_job_log_report` VALUES (23, '2024-08-26 00:00:00', 0, 5760, 0, NULL);
    183. 

  183. INSERT INTO `xxl_job_log_report` VALUES (24, '2024-08-27 00:00:00', 0, 5760, 0, NULL);
    184. 

  184. INSERT INTO `xxl_job_log_report` VALUES (25, '2024-08-28 00:00:00', 0, 5756, 4, NULL);
    185. 

  185. INSERT INTO `xxl_job_log_report` VALUES (26, '2024-08-29 00:00:00', 0, 5752, 8, NULL);
    186. 

  186. INSERT INTO `xxl_job_log_report` VALUES (27, '2024-08-30 00:00:00', 0, 5756, 4, NULL);
    187. 

  187. INSERT INTO `xxl_job_log_report` VALUES (28, '2024-08-31 00:00:00', 0, 5760, 0, NULL);
    188. 

  188. INSERT INTO `xxl_job_log_report` VALUES (29, '2024-09-01 00:00:00', 0, 5760, 0, NULL);
    189. 

  189. INSERT INTO `xxl_job_log_report` VALUES (30, '2024-09-02 00:00:00', 0, 6646, 12, NULL);
    190. 

  190. INSERT INTO `xxl_job_log_report` VALUES (31, '2024-09-03 00:00:00', 0, 7541, 0, NULL);
    191. 

  191. INSERT INTO `xxl_job_log_report` VALUES (32, '2024-09-04 00:00:00', 0, 7541, 0, NULL);
    192. 

  192. INSERT INTO `xxl_job_log_report` VALUES (33, '2024-09-05 00:00:00', 0, 7541, 0, NULL);
    193. 

  193. INSERT INTO `xxl_job_log_report` VALUES (34, '2024-09-06 00:00:00', 0, 7541, 0, NULL);
    194. 

  194. INSERT INTO `xxl_job_log_report` VALUES (35, '2024-09-07 00:00:00', 0, 7541, 0, NULL);
    195. 

  195. INSERT INTO `xxl_job_log_report` VALUES (36, '2024-09-08 00:00:00', 0, 7541, 0, NULL);
    196. 

  196. INSERT INTO `xxl_job_log_report` VALUES (37, '2024-09-09 00:00:00', 0, 7541, 0, NULL);
    197. 

  197. INSERT INTO `xxl_job_log_report` VALUES (38, '2024-09-10 00:00:00', 0, 7541, 0, NULL);
    198. 

  198. INSERT INTO `xxl_job_log_report` VALUES (39, '2024-09-11 00:00:00', 0, 7541, 0, NULL);
    199. 

  199. INSERT INTO `xxl_job_log_report` VALUES (40, '2024-09-12 00:00:00', 0, 7541, 0, NULL);
    200. 

  200. INSERT INTO `xxl_job_log_report` VALUES (41, '2024-09-13 00:00:00', 0, 7541, 0, NULL);
    201. 

  201. INSERT INTO `xxl_job_log_report` VALUES (42, '2024-09-14 00:00:00', 0, 7541, 0, NULL);
    202. 

  202. INSERT INTO `xxl_job_log_report` VALUES (43, '2024-09-15 00:00:00', 0, 7541, 0, NULL);
    203. 

  203. INSERT INTO `xxl_job_log_report` VALUES (44, '2024-09-16 00:00:00', 0, 7541, 0, NULL);
    204. 

  204. INSERT INTO `xxl_job_log_report` VALUES (45, '2024-09-17 00:00:00', 0, 7541, 0, NULL);
    205. 

  205. INSERT INTO `xxl_job_log_report` VALUES (46, '2024-09-18 00:00:00', 0, 7541, 0, NULL);
    206. 

  206. INSERT INTO `xxl_job_log_report` VALUES (47, '2024-09-19 00:00:00', 0, 7541, 0, NULL);
    207. 

  207. INSERT INTO `xxl_job_log_report` VALUES (48, '2024-09-20 00:00:00', 0, 7541, 0, NULL);
    208. 

  208. INSERT INTO `xxl_job_log_report` VALUES (49, '2024-09-21 00:00:00', 0, 7541, 0, NULL);
    209. 

  209. INSERT INTO `xxl_job_log_report` VALUES (50, '2024-09-22 00:00:00', 0, 7541, 0, NULL);
    210. 

  210. INSERT INTO `xxl_job_log_report` VALUES (51, '2024-09-23 00:00:00', 0, 7541, 0, NULL);
    211. 

  211. INSERT INTO `xxl_job_log_report` VALUES (52, '2024-09-24 00:00:00', 0, 7541, 0, NULL);
    212. 

  212. INSERT INTO `xxl_job_log_report` VALUES (53, '2024-09-25 00:00:00', 0, 7541, 0, NULL);
    213. 

  213. INSERT INTO `xxl_job_log_report` VALUES (54, '2024-09-26 00:00:00', 0, 7541, 0, NULL);
    214. 

  214. INSERT INTO `xxl_job_log_report` VALUES (55, '2024-09-27 00:00:00', 0, 7541, 0, NULL);
    215. 

  215. INSERT INTO `xxl_job_log_report` VALUES (56, '2024-09-28 00:00:00', 0, 7541, 0, NULL);
    216. 

  216. INSERT INTO `xxl_job_log_report` VALUES (57, '2024-09-29 00:00:00', 0, 7541, 0, NULL);
    217. 

  217. INSERT INTO `xxl_job_log_report` VALUES (58, '2024-09-30 00:00:00', 0, 7541, 0, NULL);
    218. 

  218. INSERT INTO `xxl_job_log_report` VALUES (59, '2024-10-01 00:00:00', 0, 7541, 0, NULL);
    219. 

  219. INSERT INTO `xxl_job_log_report` VALUES (60, '2024-10-02 00:00:00', 0, 7541, 0, NULL);
    220. 

  220. INSERT INTO `xxl_job_log_report` VALUES (61, '2024-10-03 00:00:00', 0, 7541, 0, NULL);
    221. 

  221. INSERT INTO `xxl_job_log_report` VALUES (62, '2024-10-04 00:00:00', 0, 7541, 0, NULL);
    222. 

  222. INSERT INTO `xxl_job_log_report` VALUES (63, '2024-10-05 00:00:00', 0, 7541, 0, NULL);
    223. 

  223. INSERT INTO `xxl_job_log_report` VALUES (64, '2024-10-06 00:00:00', 0, 7541, 0, NULL);
    224. 

  224. INSERT INTO `xxl_job_log_report` VALUES (65, '2024-10-07 00:00:00', 0, 7541, 0, NULL);
    225. 

  225. INSERT INTO `xxl_job_log_report` VALUES (66, '2024-10-08 00:00:00', 0, 7537, 4, NULL);
    226. 

  226. INSERT INTO `xxl_job_log_report` VALUES (67, '2024-10-09 00:00:00', 0, 7541, 0, NULL);
    227. 

  227. INSERT INTO `xxl_job_log_report` VALUES (68, '2024-10-10 00:00:00', 0, 7541, 0, NULL);
    228. 

  228. INSERT INTO `xxl_job_log_report` VALUES (69, '2024-10-11 00:00:00', 0, 7541, 0, NULL);
    229. 

  229. INSERT INTO `xxl_job_log_report` VALUES (70, '2024-10-12 00:00:00', 0, 7537, 4, NULL);
    230. 

  230. INSERT INTO `xxl_job_log_report` VALUES (71, '2024-10-13 00:00:00', 0, 7541, 0, NULL);
    231. 

  231. INSERT INTO `xxl_job_log_report` VALUES (72, '2024-10-14 00:00:00', 0, 7541, 0, NULL);
    232. 

  232. INSERT INTO `xxl_job_log_report` VALUES (73, '2024-10-15 00:00:00', 0, 7541, 0, NULL);
    233. 

  233. INSERT INTO `xxl_job_log_report` VALUES (74, '2024-10-16 00:00:00', 0, 7541, 0, NULL);
    234. 

  234. INSERT INTO `xxl_job_log_report` VALUES (75, '2024-10-17 00:00:00', 0, 7541, 0, NULL);
    235. 

  235. INSERT INTO `xxl_job_log_report` VALUES (76, '2024-10-18 00:00:00', 0, 7312, 8, NULL);
    236. 

  236. INSERT INTO `xxl_job_log_report` VALUES (77, '2024-10-19 00:00:00', 0, 7541, 0, NULL);
    237. 

  237. INSERT INTO `xxl_job_log_report` VALUES (78, '2024-10-20 00:00:00', 0, 7541, 0, NULL);
    238. 

  238. INSERT INTO `xxl_job_log_report` VALUES (79, '2024-10-21 00:00:00', 0, 7541, 0, NULL);
    239. 

  239. INSERT INTO `xxl_job_log_report` VALUES (80, '2024-10-22 00:00:00', 0, 7541, 0, NULL);
    240. 

  240. INSERT INTO `xxl_job_log_report` VALUES (81, '2024-10-23 00:00:00', 0, 7541, 0, NULL);
    241. 

  241. INSERT INTO `xxl_job_log_report` VALUES (82, '2024-10-24 00:00:00', 0, 7541, 0, NULL);
    242. 

  242. INSERT INTO `xxl_job_log_report` VALUES (83, '2024-10-25 00:00:00', 0, 7541, 0, NULL);
    243. 

  243. INSERT INTO `xxl_job_log_report` VALUES (84, '2024-10-26 00:00:00', 0, 7541, 0, NULL);
    244. 

  244. INSERT INTO `xxl_job_log_report` VALUES (85, '2024-10-27 00:00:00', 0, 7541, 0, NULL);
    245. 

  245. INSERT INTO `xxl_job_log_report` VALUES (86, '2024-10-28 00:00:00', 0, 7541, 0, NULL);
    246. 

  246. INSERT INTO `xxl_job_log_report` VALUES (87, '2024-10-29 00:00:00', 0, 7541, 0, NULL);
    247. 

  247. INSERT INTO `xxl_job_log_report` VALUES (88, '2024-10-30 00:00:00', 0, 7541, 0, NULL);
    248. 

  248. INSERT INTO `xxl_job_log_report` VALUES (89, '2024-10-31 00:00:00', 0, 7541, 0, NULL);
    249. 

  249. INSERT INTO `xxl_job_log_report` VALUES (90, '2024-11-01 00:00:00', 0, 7541, 0, NULL);
    250. 

  250. INSERT INTO `xxl_job_log_report` VALUES (91, '2024-11-02 00:00:00', 0, 7541, 0, NULL);
    251. 

  251. INSERT INTO `xxl_job_log_report` VALUES (92, '2024-11-03 00:00:00', 0, 7541, 0, NULL);
    252. 

  252. INSERT INTO `xxl_job_log_report` VALUES (93, '2024-11-04 00:00:00', 0, 7541, 0, NULL);
    253. 

  253. INSERT INTO `xxl_job_log_report` VALUES (94, '2024-11-05 00:00:00', 0, 7541, 0, NULL);
    254. 

  254. INSERT INTO `xxl_job_log_report` VALUES (95, '2024-11-06 00:00:00', 0, 7541, 0, NULL);
    255. 

  255. INSERT INTO `xxl_job_log_report` VALUES (96, '2024-11-07 00:00:00', 0, 7541, 0, NULL);
    256. 

  256. INSERT INTO `xxl_job_log_report` VALUES (97, '2024-11-08 00:00:00', 0, 7541, 0, NULL);
    257. 

  257. INSERT INTO `xxl_job_log_report` VALUES (98, '2024-11-09 00:00:00', 0, 7541, 0, NULL);
    258. 

  258. INSERT INTO `xxl_job_log_report` VALUES (99, '2024-11-10 00:00:00', 0, 7541, 0, NULL);
    259. 

  259. INSERT INTO `xxl_job_log_report` VALUES (100, '2024-11-11 00:00:00', 0, 7541, 0, NULL);
    260. 

  260. INSERT INTO `xxl_job_log_report` VALUES (101, '2024-11-12 00:00:00', 0, 7541, 0, NULL);
    261. 

  261. INSERT INTO `xxl_job_log_report` VALUES (102, '2024-11-13 00:00:00', 0, 7541, 0, NULL);
    262. 

  262. INSERT INTO `xxl_job_log_report` VALUES (103, '2024-11-14 00:00:00', 0, 7533, 8, NULL);
    263. 

  263. INSERT INTO `xxl_job_log_report` VALUES (104, '2024-11-15 00:00:00', 0, 7533, 8, NULL);
    264. 

  264. INSERT INTO `xxl_job_log_report` VALUES (105, '2024-11-16 00:00:00', 0, 7541, 0, NULL);
    265. 

  265. INSERT INTO `xxl_job_log_report` VALUES (106, '2024-11-17 00:00:00', 0, 7541, 0, NULL);
    266. 

  266. INSERT INTO `xxl_job_log_report` VALUES (107, '2024-11-18 00:00:00', 0, 7533, 8, NULL);
    267. 

  267. INSERT INTO `xxl_job_log_report` VALUES (108, '2024-11-19 00:00:00', 0, 7541, 0, NULL);
    268. 

  268. INSERT INTO `xxl_job_log_report` VALUES (109, '2024-11-20 00:00:00', 0, 7537, 4, NULL);
    269. 

  269. INSERT INTO `xxl_job_log_report` VALUES (110, '2024-11-21 00:00:00', 0, 7497, 44, NULL);
    270. 

  270. INSERT INTO `xxl_job_log_report` VALUES (111, '2024-11-22 00:00:00', 0, 7541, 0, NULL);
    271. 

  271. INSERT INTO `xxl_job_log_report` VALUES (112, '2024-11-23 00:00:00', 0, 7541, 0, NULL);
    272. 

  272. INSERT INTO `xxl_job_log_report` VALUES (113, '2024-11-24 00:00:00', 0, 7541, 0, NULL);
    273. 

  273. INSERT INTO `xxl_job_log_report` VALUES (114, '2024-11-25 00:00:00', 0, 7541, 0, NULL);
    274. 

  274. INSERT INTO `xxl_job_log_report` VALUES (115, '2024-11-26 00:00:00', 0, 7541, 0, NULL);
    275. 

  275. INSERT INTO `xxl_job_log_report` VALUES (116, '2024-11-27 00:00:00', 0, 7541, 0, NULL);
    276. 

  276. INSERT INTO `xxl_job_log_report` VALUES (117, '2024-11-28 00:00:00', 0, 7541, 0, NULL);
    277. 

  277. INSERT INTO `xxl_job_log_report` VALUES (118, '2024-11-29 00:00:00', 0, 7481, 60, NULL);
    278. 

  278. INSERT INTO `xxl_job_log_report` VALUES (119, '2024-11-30 00:00:00', 0, 7541, 0, NULL);
    279. 

  279. INSERT INTO `xxl_job_log_report` VALUES (120, '2024-12-01 00:00:00', 0, 7541, 0, NULL);
    280. 

  280. INSERT INTO `xxl_job_log_report` VALUES (121, '2024-12-02 00:00:00', 0, 7541, 0, NULL);
    281. 

  281. INSERT INTO `xxl_job_log_report` VALUES (122, '2024-12-03 00:00:00', 0, 7541, 0, NULL);
    282. 

  282. INSERT INTO `xxl_job_log_report` VALUES (123, '2024-12-04 00:00:00', 0, 7541, 0, NULL);
    283. 

  283. INSERT INTO `xxl_job_log_report` VALUES (124, '2024-12-05 00:00:00', 0, 7541, 0, NULL);
    284. 

  284. INSERT INTO `xxl_job_log_report` VALUES (125, '2024-12-06 00:00:00', 0, 7541, 0, NULL);
    285. 

  285. INSERT INTO `xxl_job_log_report` VALUES (126, '2024-12-07 00:00:00', 0, 7541, 0, NULL);
    286. 

  286. INSERT INTO `xxl_job_log_report` VALUES (127, '2024-12-08 00:00:00', 0, 7541, 0, NULL);
    287. 

  287. INSERT INTO `xxl_job_log_report` VALUES (128, '2024-12-09 00:00:00', 0, 7541, 0, NULL);
    288. 

  288. INSERT INTO `xxl_job_log_report` VALUES (129, '2024-12-10 00:00:00', 0, 7541, 0, NULL);
    289. 

  289. INSERT INTO `xxl_job_log_report` VALUES (130, '2024-12-11 00:00:00', 0, 7541, 0, NULL);
    290. 

  290. INSERT INTO `xxl_job_log_report` VALUES (131, '2024-12-12 00:00:00', 0, 7468, 0, NULL);
    291. 

  291. INSERT INTO `xxl_job_log_report` VALUES (132, '2024-12-13 00:00:00', 0, 7541, 0, NULL);
    292. 

  292. INSERT INTO `xxl_job_log_report` VALUES (133, '2024-12-14 00:00:00', 0, 7541, 0, NULL);
    293. 

  293. INSERT INTO `xxl_job_log_report` VALUES (134, '2024-12-15 00:00:00', 0, 7541, 0, NULL);
    294. 

  294. INSERT INTO `xxl_job_log_report` VALUES (135, '2024-12-16 00:00:00', 0, 7541, 0, NULL);
    295. 

  295. INSERT INTO `xxl_job_log_report` VALUES (136, '2024-12-17 00:00:00', 0, 7537, 4, NULL);
    296. 

  296. INSERT INTO `xxl_job_log_report` VALUES (137, '2024-12-18 00:00:00', 0, 7395, 146, NULL);
    297. 

  297. INSERT INTO `xxl_job_log_report` VALUES (138, '2024-12-19 00:00:00', 0, 7538, 3, NULL);
    298. 

  298. INSERT INTO `xxl_job_log_report` VALUES (139, '2024-12-20 00:00:00', 0, 7534, 7, NULL);
    299. 

  299. INSERT INTO `xxl_job_log_report` VALUES (140, '2024-12-21 00:00:00', 0, 7541, 0, NULL);
    300. 

  300. INSERT INTO `xxl_job_log_report` VALUES (141, '2024-12-22 00:00:00', 0, 7541, 0, NULL);
    301. 

  301. INSERT INTO `xxl_job_log_report` VALUES (142, '2024-12-23 00:00:00', 0, 7541, 0, NULL);
    302. 

  302. INSERT INTO `xxl_job_log_report` VALUES (143, '2024-12-24 00:00:00', 0, 7541, 0, NULL);
    303. 

  303. INSERT INTO `xxl_job_log_report` VALUES (144, '2024-12-25 00:00:00', 0, 7487, 54, NULL);
    304. 

  304. INSERT INTO `xxl_job_log_report` VALUES (145, '2024-12-26 00:00:00', 0, 7472, 69, NULL);
    305. 

  305. INSERT INTO `xxl_job_log_report` VALUES (146, '2024-12-27 00:00:00', 0, 7505, 36, NULL);
    306. 

  306. INSERT INTO `xxl_job_log_report` VALUES (147, '2024-12-28 00:00:00', 0, 7137, 404, NULL);
    307. 

  307. INSERT INTO `xxl_job_log_report` VALUES (148, '2024-12-29 00:00:00', 0, 5813, 1728, NULL);
    308. 

  308. INSERT INTO `xxl_job_log_report` VALUES (149, '2024-12-30 00:00:00', 0, 6523, 1018, NULL);
    309. 

  309. INSERT INTO `xxl_job_log_report` VALUES (150, '2024-12-31 00:00:00', 0, 8400, 782, NULL);
    310. 

  310. INSERT INTO `xxl_job_log_report` VALUES (151, '2025-01-01 00:00:00', 0, 11861, 0, NULL);
    311. 

  311. INSERT INTO `xxl_job_log_report` VALUES (152, '2025-01-02 00:00:00', 0, 11856, 5, NULL);
    312. 

  312. INSERT INTO `xxl_job_log_report` VALUES (153, '2025-01-03 00:00:00', 0, 11853, 8, NULL);
    313. 

  313. INSERT INTO `xxl_job_log_report` VALUES (154, '2025-01-04 00:00:00', 0, 11861, 0, NULL);
    314. 

  314. INSERT INTO `xxl_job_log_report` VALUES (155, '2025-01-05 00:00:00', 0, 11861, 0, NULL);
    315. 

  315. INSERT INTO `xxl_job_log_report` VALUES (156, '2025-01-06 00:00:00', 0, 11861, 0, NULL);
    316. 

  316. INSERT INTO `xxl_job_log_report` VALUES (157, '2025-01-07 00:00:00', 0, 11803, 58, NULL);
    317. 

  317. INSERT INTO `xxl_job_log_report` VALUES (158, '2025-01-08 00:00:00', 0, 11798, 63, NULL);
    318. 

  318. INSERT INTO `xxl_job_log_report` VALUES (159, '2025-01-09 00:00:00', 0, 11849, 12, NULL);
    319. 

  319. INSERT INTO `xxl_job_log_report` VALUES (160, '2025-01-10 00:00:00', 0, 12483, 3, NULL);
    320. 

  320. INSERT INTO `xxl_job_log_report` VALUES (161, '2025-01-11 00:00:00', 0, 13301, 0, NULL);
    321. 

  321. INSERT INTO `xxl_job_log_report` VALUES (162, '2025-01-12 00:00:00', 0, 13301, 0, NULL);
    322. 

  322. INSERT INTO `xxl_job_log_report` VALUES (163, '2025-01-13 00:00:00', 0, 13297, 4, NULL);
    323. 

  323. INSERT INTO `xxl_job_log_report` VALUES (164, '2025-01-14 00:00:00', 0, 13272, 29, NULL);
    324. 

  324. INSERT INTO `xxl_job_log_report` VALUES (165, '2025-01-15 00:00:00', 0, 13292, 9, NULL);
    325. 

  325. INSERT INTO `xxl_job_log_report` VALUES (166, '2025-01-16 00:00:00', 0, 13293, 8, NULL);
    326. 

  326. INSERT INTO `xxl_job_log_report` VALUES (167, '2025-01-17 00:00:00', 0, 13279, 22, NULL);
    327. 

  327. INSERT INTO `xxl_job_log_report` VALUES (168, '2025-01-18 00:00:00', 0, 13301, 0, NULL);
    328. 

  328. INSERT INTO `xxl_job_log_report` VALUES (169, '2025-01-19 00:00:00', 0, 13301, 0, NULL);
    329. 

  329. INSERT INTO `xxl_job_log_report` VALUES (170, '2025-01-20 00:00:00', 0, 13273, 28, NULL);
    330. 

  330. INSERT INTO `xxl_job_log_report` VALUES (171, '2025-01-21 00:00:00', 0, 13248, 53, NULL);
    331. 

  331. INSERT INTO `xxl_job_log_report` VALUES (172, '2025-01-22 00:00:00', 0, 13263, 38, NULL);
    332. 

  332. INSERT INTO `xxl_job_log_report` VALUES (173, '2025-01-23 00:00:00', 0, 13207, 0, NULL);
    333. 

  333. INSERT INTO `xxl_job_log_report` VALUES (174, '2025-01-24 00:00:00', 0, 13301, 0, NULL);
    334. 

  334. INSERT INTO `xxl_job_log_report` VALUES (175, '2025-01-25 00:00:00', 0, 13301, 0, NULL);
    335. 

  335. INSERT INTO `xxl_job_log_report` VALUES (176, '2025-01-26 00:00:00', 0, 13301, 0, NULL);
    336. 

  336. INSERT INTO `xxl_job_log_report` VALUES (177, '2025-01-27 00:00:00', 0, 13301, 0, NULL);
    337. 

  337. INSERT INTO `xxl_job_log_report` VALUES (178, '2025-01-28 00:00:00', 0, 13301, 0, NULL);
    338. 

  338. INSERT INTO `xxl_job_log_report` VALUES (179, '2025-01-29 00:00:00', 0, 13301, 0, NULL);
    339. 

  339. INSERT INTO `xxl_job_log_report` VALUES (180, '2025-01-30 00:00:00', 0, 13301, 0, NULL);
    340. 

  340. INSERT INTO `xxl_job_log_report` VALUES (181, '2025-01-31 00:00:00', 0, 13301, 0, NULL);
    341. 

  341. INSERT INTO `xxl_job_log_report` VALUES (182, '2025-02-01 00:00:00', 0, 13301, 0, NULL);
    342. 

  342. INSERT INTO `xxl_job_log_report` VALUES (183, '2025-02-02 00:00:00', 0, 13301, 0, NULL);
    343. 

  343. INSERT INTO `xxl_job_log_report` VALUES (184, '2025-02-03 00:00:00', 0, 13301, 0, NULL);
    344. 

  344. INSERT INTO `xxl_job_log_report` VALUES (185, '2025-02-04 00:00:00', 0, 13301, 0, NULL);
    345. 

  345. INSERT INTO `xxl_job_log_report` VALUES (186, '2025-02-05 00:00:00', 0, 13289, 12, NULL);
    346. 

  346. INSERT INTO `xxl_job_log_report` VALUES (187, '2025-02-06 00:00:00', 0, 13117, 16, NULL);
    347. 

  347. INSERT INTO `xxl_job_log_report` VALUES (188, '2025-02-07 00:00:00', 0, 13296, 5, NULL);
    348. 

  348. INSERT INTO `xxl_job_log_report` VALUES (189, '2025-02-08 00:00:00', 0, 13299, 2, NULL);
    349. 

  349. INSERT INTO `xxl_job_log_report` VALUES (190, '2025-02-09 00:00:00', 0, 13301, 0, NULL);
    350. 

  350. INSERT INTO `xxl_job_log_report` VALUES (191, '2025-02-10 00:00:00', 0, 13301, 0, NULL);
    351. 

  351. INSERT INTO `xxl_job_log_report` VALUES (192, '2025-02-11 00:00:00', 0, 13280, 21, NULL);
    352. 

  352. INSERT INTO `xxl_job_log_report` VALUES (193, '2025-02-12 00:00:00', 0, 13290, 11, NULL);
    353. 

  353. INSERT INTO `xxl_job_log_report` VALUES (194, '2025-02-13 00:00:00', 0, 13268, 33, NULL);
    354. 

  354. INSERT INTO `xxl_job_log_report` VALUES (195, '2025-02-14 00:00:00', 0, 13295, 6, NULL);
    355. 

  355. INSERT INTO `xxl_job_log_report` VALUES (196, '2025-02-15 00:00:00', 0, 13301, 0, NULL);
    356. 

  356. INSERT INTO `xxl_job_log_report` VALUES (197, '2025-02-16 00:00:00', 0, 13301, 0, NULL);
    357. 

  357. INSERT INTO `xxl_job_log_report` VALUES (198, '2025-02-17 00:00:00', 0, 13298, 3, NULL);
    358. 

  358. INSERT INTO `xxl_job_log_report` VALUES (199, '2025-02-18 00:00:00', 0, 13293, 8, NULL);
    359. 

  359. INSERT INTO `xxl_job_log_report` VALUES (200, '2025-02-19 00:00:00', 0, 13300, 1, NULL);
    360. 

  360. INSERT INTO `xxl_job_log_report` VALUES (201, '2025-02-20 00:00:00', 0, 13301, 0, NULL);
    361. 

  361. INSERT INTO `xxl_job_log_report` VALUES (202, '2025-02-21 00:00:00', 0, 13270, 31, NULL);
    362. 

  362. INSERT INTO `xxl_job_log_report` VALUES (203, '2025-02-22 00:00:00', 0, 13301, 0, NULL);
    363. 

  363. INSERT INTO `xxl_job_log_report` VALUES (204, '2025-02-23 00:00:00', 0, 13301, 0, NULL);
    364. 

  364. INSERT INTO `xxl_job_log_report` VALUES (205, '2025-02-24 00:00:00', 0, 13293, 8, NULL);
    365. 

  365. INSERT INTO `xxl_job_log_report` VALUES (206, '2025-02-25 00:00:00', 0, 13283, 18, NULL);
    366. 

  366. INSERT INTO `xxl_job_log_report` VALUES (207, '2025-02-26 00:00:00', 0, 13290, 11, NULL);
    367. 

  367. INSERT INTO `xxl_job_log_report` VALUES (208, '2025-02-27 00:00:00', 0, 13272, 29, NULL);
    368. 

  368. INSERT INTO `xxl_job_log_report` VALUES (209, '2025-02-28 00:00:00', 0, 13284, 17, NULL);
    369. 

  369. INSERT INTO `xxl_job_log_report` VALUES (210, '2025-03-01 00:00:00', 0, 13300, 1, NULL);
    370. 

  370. INSERT INTO `xxl_job_log_report` VALUES (211, '2025-03-02 00:00:00', 0, 13301, 0, NULL);
    371. 

  371. INSERT INTO `xxl_job_log_report` VALUES (212, '2025-03-03 00:00:00', 0, 13291, 10, NULL);
    372. 

  372. INSERT INTO `xxl_job_log_report` VALUES (213, '2025-03-04 00:00:00', 0, 13299, 2, NULL);
    373. 

  373. INSERT INTO `xxl_job_log_report` VALUES (214, '2025-03-05 00:00:00', 0, 13290, 11, NULL);
    374. 

  374. INSERT INTO `xxl_job_log_report` VALUES (215, '2025-03-06 00:00:00', 0, 13288, 13, NULL);
    375. 

  375. INSERT INTO `xxl_job_log_report` VALUES (216, '2025-03-07 00:00:00', 0, 12969, 332, NULL);
    376. 

  376. INSERT INTO `xxl_job_log_report` VALUES (217, '2025-03-08 00:00:00', 0, 12374, 927, NULL);
    377. 

  377. INSERT INTO `xxl_job_log_report` VALUES (218, '2025-03-09 00:00:00', 0, 13299, 2, NULL);
    378. 

  378. INSERT INTO `xxl_job_log_report` VALUES (219, '2025-03-10 00:00:00', 0, 13299, 2, NULL);
    379. 

  379. INSERT INTO `xxl_job_log_report` VALUES (220, '2025-03-11 00:00:00', 0, 13257, 44, NULL);
    380. 

  380. INSERT INTO `xxl_job_log_report` VALUES (221, '2025-03-12 00:00:00', 0, 13244, 57, NULL);
    381. 

  381. INSERT INTO `xxl_job_log_report` VALUES (222, '2025-03-13 00:00:00', 0, 13274, 27, NULL);
    382. 

  382. INSERT INTO `xxl_job_log_report` VALUES (223, '2025-03-14 00:00:00', 0, 11047, 2, NULL);
    383. 

  383. INSERT INTO `xxl_job_log_report` VALUES (224, '2025-03-17 00:00:00', 0, 6999, 17, NULL);
    384. 

  384. INSERT INTO `xxl_job_log_report` VALUES (225, '2025-03-16 00:00:00', 0, 0, 0, NULL);
    385. 

  385. INSERT INTO `xxl_job_log_report` VALUES (226, '2025-03-15 00:00:00', 0, 0, 0, NULL);
    386. 

  386. INSERT INTO `xxl_job_log_report` VALUES (227, '2025-03-18 00:00:00', 0, 13294, 7, NULL);
    387. 

  387. INSERT INTO `xxl_job_log_report` VALUES (228, '2025-03-19 00:00:00', 0, 13274, 27, NULL);
    388. 

  388. INSERT INTO `xxl_job_log_report` VALUES (229, '2025-03-20 00:00:00', 0, 13297, 4, NULL);
    389. 

  389. INSERT INTO `xxl_job_log_report` VALUES (230, '2025-03-21 00:00:00', 0, 13268, 33, NULL);
    390. 

  390. INSERT INTO `xxl_job_log_report` VALUES (231, '2025-03-22 00:00:00', 0, 13301, 0, NULL);
    391. 

  391. INSERT INTO `xxl_job_log_report` VALUES (232, '2025-03-23 00:00:00', 0, 13301, 0, NULL);
    392. 

  392. INSERT INTO `xxl_job_log_report` VALUES (233, '2025-03-24 00:00:00', 0, 13285, 16, NULL);
    393. 

  393. INSERT INTO `xxl_job_log_report` VALUES (234, '2025-03-25 00:00:00', 0, 0, 0, NULL);
    394. 

  394. INSERT INTO `xxl_job_log_report` VALUES (235, '2025-03-26 00:00:00', 0, 0, 0, NULL);
    395. 

  395. INSERT INTO `xxl_job_log_report` VALUES (236, '2025-03-27 00:00:00', 0, 0, 0, NULL);
    396. 

  396. 

  397. -- ----------------------------
    398. 

  398. -- Table structure for xxl_job_logglue
    399. 

  399. -- ----------------------------
    400. 

  400. DROP TABLE IF EXISTS `xxl_job_logglue`;
    401. 

  401. CREATE TABLE `xxl_job_logglue`  (
    402. 

  402.   `id` int NOT NULL AUTO_INCREMENT,
    403. 

  403.   `job_id` int NOT NULL COMMENT '任务，主键ID',
    404. 

  404.   `glue_type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'GLUE类型',
    405. 

  405.   `glue_source` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT 'GLUE源代码',
    406. 

  406.   `glue_remark` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT 'GLUE备注',
    407. 

  407.   `add_time` datetime NULL DEFAULT NULL,
    408. 

  408.   `update_time` datetime NULL DEFAULT NULL,
    409. 

  409.   PRIMARY KEY (`id`) USING BTREE
    410. 

  410. ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    411. 

  411. 

  412. -- ----------------------------
    413. 

  413. -- Records of xxl_job_logglue
    414. 

  414. -- ----------------------------
    415. 

  415. 

  416. -- ----------------------------
    417. 

  417. -- Table structure for xxl_job_registry
    418. 

  418. -- ----------------------------
    419. 

  419. DROP TABLE IF EXISTS `xxl_job_registry`;
    420. 

  420. CREATE TABLE `xxl_job_registry`  (
    421. 

  421.   `id` int NOT NULL AUTO_INCREMENT,
    422. 

  422.   `registry_group` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    423. 

  423.   `registry_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    424. 

  424.   `registry_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
    425. 

  425.   `update_time` datetime NULL DEFAULT NULL,
    426. 

  426.   PRIMARY KEY (`id`) USING BTREE,
    427. 

  427.   INDEX `i_g_k_v`(`registry_group` ASC, `registry_key` ASC, `registry_value` ASC) USING BTREE
    428. 

  428. ) ENGINE = InnoDB AUTO_INCREMENT = 780 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    429. 

  429. 

  430. -- ----------------------------
    431. 

  431. -- Records of xxl_job_registry
    432. 

  432. -- ----------------------------
    433. 

  433. INSERT INTO `xxl_job_registry` VALUES (728, 'EXECUTOR', 'trade-server', 'http://172.17.0.1:10001/', '2025-03-27 17:59:53');
    434. 

  434. INSERT INTO `xxl_job_registry` VALUES (729, 'EXECUTOR', 'statistics-server', 'http://172.17.0.1:10002/', '2025-03-27 17:59:42');
    435. 

  435. INSERT INTO `xxl_job_registry` VALUES (731, 'EXECUTOR', 'promotion-server', 'http://172.17.0.1:10004/', '2025-03-27 17:59:58');
    436. 

  436. INSERT INTO `xxl_job_registry` VALUES (738, 'EXECUTOR', 'pay-server', 'http://172.17.0.1:10000/', '2025-03-27 17:59:37');
    437. 

  437. INSERT INTO `xxl_job_registry` VALUES (779, 'EXECUTOR', 'menduner-system-server', 'http://172.17.0.1:10003/', '2025-03-27 17:59:56');
    438. 

  438. 

  439. -- ----------------------------
    440. 

  440. -- Table structure for xxl_job_user
    441. 

  441. -- ----------------------------
    442. 

  442. DROP TABLE IF EXISTS `xxl_job_user`;
    443. 

  443. CREATE TABLE `xxl_job_user`  (
    444. 

  444.   `id` int NOT NULL AUTO_INCREMENT,
    445. 

  445.   `username` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '账号',
    446. 

  446.   `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '密码',
    447. 

  447.   `role` tinyint NOT NULL COMMENT '角色：0-普通用户、1-管理员',
    448. 

  448.   `permission` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
    449. 

  449.   PRIMARY KEY (`id`) USING BTREE,
    450. 

  450.   UNIQUE INDEX `i_username`(`username` ASC) USING BTREE
    451. 

  451. ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
    452. 

  452. 

  453. -- ----------------------------
    454. 

  454. -- Records of xxl_job_user
    455. 

  455. -- ----------------------------
    456. 

  456. INSERT INTO `xxl_job_user` VALUES (1, 'admin', 'e3b1ad8d4813493ea1883ee85df551af', 1, NULL);
    457. 

  457. 

  458. SET FOREIGN_KEY_CHECKS = 1;
    459.