Accueil Explorer Aide
S'inscrire Connexion
lamianchain.com
/
java-bbc
2
0
Fork 0
Fichiers Tickets 0 Pull Requests 0 Wiki
Branche: master
Branches Tags
java-bbc
/
db
/
3xxl_job.sql

3xxl_job.sql 27 KB
Lien permanent Historique Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382 
  1. /*
    2. 

  2. SQLyog Ultimate v13.1.1 (64 bit)
    3. 

  3. MySQL - 8.0.27 : Database - xxl_job
    4. 

  4. *********************************************************************
    5. 

  5. */
    6. 

  6. 

  7. /*!40101 SET NAMES utf8 */;
    8. 

  8. 

  9. /*!40101 SET SQL_MODE = ''*/;
    10. 

  10. 

  11. /*!40014 SET @OLD_UNIQUE_CHECKS = @@UNIQUE_CHECKS, UNIQUE_CHECKS = 0 */;
    12. 

  12. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;
    13. 

  13. /*!40101 SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' */;
    14. 

  14. /*!40111 SET @OLD_SQL_NOTES = @@SQL_NOTES, SQL_NOTES = 0 */;
    15. 

  15. CREATE DATABASE IF NOT EXISTS `xxl_job` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
    16. 

  16. 

  17. USE `xxl_job`;
    18. 

  18. 

  19. /*Table structure for table `xxl_job_group` */
    20. 

  20. 

  21. DROP TABLE IF EXISTS `xxl_job_group`;
    22. 

  22. 

  23. CREATE TABLE `xxl_job_group`
    24. 

  24. (
    25. 

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

  26.     `app_name`     varchar(64) NOT NULL COMMENT '执行器AppName',
    27. 

  27.     `title`        varchar(12) NOT NULL COMMENT '执行器名称',
    28. 

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

  29.     `address_list` text COMMENT '执行器地址列表，多地址逗号分隔',
    30. 

  30.     `update_time`  datetime             DEFAULT NULL,
    31. 

  31.     PRIMARY KEY (`id`)
    32. 

  32. ) ENGINE = InnoDB
    33. 

  33.   AUTO_INCREMENT = 3
    34. 

  34.   DEFAULT CHARSET = utf8mb4
    35. 

  35.   COLLATE = utf8mb4_general_ci;
    36. 

  36. 

  37. /*Data for the table `xxl_job_group` */
    38. 

  38. 

  39. insert into `xxl_job_group`(`id`, `app_name`, `title`, `address_type`, `address_list`, `update_time`)
    40. 

  40. values (2, 'mall4j-bbc', 'mall4j商城系统', 0, '', '2021-11-25 11:19:02');
    41. 

  41. 

  42. /*Table structure for table `xxl_job_info` */
    43. 

  43. 

  44. DROP TABLE IF EXISTS `xxl_job_info`;
    45. 

  45. 

  46. CREATE TABLE `xxl_job_info`
    47. 

  47. (
    48. 

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

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

  50.     `job_desc`                  varchar(255) NOT NULL,
    51. 

  51.     `add_time`                  datetime              DEFAULT NULL,
    52. 

  52.     `update_time`               datetime              DEFAULT NULL,
    53. 

  53.     `author`                    varchar(64)           DEFAULT NULL COMMENT '作者',
    54. 

  54.     `alarm_email`               varchar(255)          DEFAULT NULL COMMENT '报警邮件',
    55. 

  55.     `schedule_type`             varchar(50)  NOT NULL DEFAULT 'NONE' COMMENT '调度类型',
    56. 

  56.     `schedule_conf`             varchar(128)          DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型',
    57. 

  57.     `misfire_strategy`          varchar(50)  NOT NULL DEFAULT 'DO_NOTHING' COMMENT '调度过期策略',
    58. 

  58.     `executor_route_strategy`   varchar(50)           DEFAULT NULL COMMENT '执行器路由策略',
    59. 

  59.     `executor_handler`          varchar(255)          DEFAULT NULL COMMENT '执行器任务handler',
    60. 

  60.     `executor_param`            varchar(512)          DEFAULT NULL COMMENT '执行器任务参数',
    61. 

  61.     `executor_block_strategy`   varchar(50)           DEFAULT NULL COMMENT '阻塞处理策略',
    62. 

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

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

  64.     `glue_type`                 varchar(50)  NOT NULL COMMENT 'GLUE类型',
    65. 

  65.     `glue_source`               mediumtext COMMENT 'GLUE源代码',
    66. 

  66.     `glue_remark`               varchar(128)          DEFAULT NULL COMMENT 'GLUE备注',
    67. 

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

  68.     `child_jobid`               varchar(255)          DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
    69. 

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

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

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

  72.     PRIMARY KEY (`id`)
    73. 

  73. ) ENGINE = InnoDB
    74. 

  74.   AUTO_INCREMENT = 30
    75. 

  75.   DEFAULT CHARSET = utf8mb4
    76. 

  76.   COLLATE = utf8mb4_general_ci;
    77. 

  77. 

  78. /*Data for the table `xxl_job_info` */
    79. 

  79. 

  80. insert into `xxl_job_info`(`id`, `job_group`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`,
    81. 

  81.                            `schedule_type`, `schedule_conf`, `misfire_strategy`, `executor_route_strategy`,
    82. 

  82.                            `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`,
    83. 

  83.                            `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`,
    84. 

  84.                            `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`)
    85. 

  85. values (2, 2, '设置店铺的过期优惠券为过期状态，改变店铺库存为0优惠券的状态(设为取消投放状态)', '2021-11-25 10:32:49',
    86. 

  86.         '2021-11-25 11:12:12', 'admin', '', 'CRON', '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'changeCoupon', '',
    87. 

  87.         'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-11-25 10:32:49', '', 1, 1637810340000,
    88. 

  88.         1637810400000),
    89. 

  89.        (3, 2, '删除用户失效30天以上的优惠券', '2021-11-25 10:35:32', '2021-11-25 11:12:08', 'admin', '', 'CRON',
    90. 

  90.         '0 0 0/1 * * ?', 'DO_NOTHING', 'FIRST', 'deleteCouponUser', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    91. 

  91.         'GLUE代码初始化', '2021-11-25 10:35:32', '', 1, 0, 1637812800000),
    92. 

  92.        (4, 2, '改变用户优惠券的状态(设为失效状态)', '2021-11-25 10:36:07', '2021-11-25 11:12:03', 'admin', '', 'CRON',
    93. 

  93.         '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'changeCouponUser', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    94. 

  94.         'GLUE代码初始化', '2021-11-25 10:36:07', '', 1, 1637810340000, 1637810400000),
    95. 

  95.        (5, 2, '投放优惠券', '2021-11-25 10:36:34', '2021-11-25 11:12:01', 'admin', '', 'CRON', '0 1/30 * * * ?',
    96. 

  96.         'DO_NOTHING', 'FIRST', 'putOnCoupon', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    97. 

  97.         '2021-11-25 10:36:34', '', 1, 1637810340000, 1637810400000),
    98. 

  98.        (6, 2, '取消超时未支付订单', '2021-11-25 10:39:58', '2021-11-25 11:11:59', 'admin', '', 'CRON', '0 * * * * ?',
    99. 

  99.         'DO_NOTHING', 'FIRST', 'cancelOrder', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    100. 

  100.         '2021-11-25 10:39:58', '', 1, 1637810340000, 1637810400000),
    101. 

  101.        (7, 2, '系统自动确认收货订单', '2021-11-25 10:40:20', '2021-11-25 11:11:56', 'admin', '', 'CRON',
    102. 

  102.         '0 0/5 * * * ?', 'DO_NOTHING', 'FIRST', 'confirmOrder', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    103. 

  103.         'GLUE代码初始化', '2021-11-25 10:40:20', '', 1, 1637810100000, 1637810400000),
    104. 

  104.        (8, 2, '1分钟执行一次订单催付通知，对没支付的订单发送通知', '2021-11-25 10:41:25', '2021-11-25 11:11:54', 'admin',
    105. 

  105.         '', 'CRON', '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'pressPayOrder', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    106. 

  106.         'GLUE代码初始化', '2021-11-25 10:41:25', '', 1, 1637810340000, 1637810400000),
    107. 

  107.        (9, 2, '每天00:00:05执行一遍订单结算定时任务', '2021-11-25 10:42:07', '2021-11-25 11:11:51', 'admin', '', 'CRON',
    108. 

  108.         '5 0 0 * * ? *', 'DO_NOTHING', 'FIRST', 'orderCommissionSettlement', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    109. 

  109.         'GLUE代码初始化', '2021-11-25 10:42:07', '', 1, 0, 1637856005000),
    110. 

  110.        (10, 2, '活动结束任务：处理所有未成团的拼团单（退款处理）、清除物品拼团活动ID、处理拼团单（退款处理）',
    111. 

  111.         '2021-11-25 10:43:22', '2021-11-25 11:11:48', 'admin', '', 'CRON', '0 * * * * ? *', 'DO_NOTHING', 'FIRST',
    112. 

  112.         'activityFinish', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-11-25 10:43:22', '', 1,
    113. 

  113.         1637810340000, 1637810400000),
    114. 

  114.        (11, 2, '团购活动失效，活动商品恢复为普通商品', '2021-11-25 10:43:51', '2021-11-25 11:11:45', 'admin', '', 'CRON',
    115. 

  115.         '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'activityFinishAndProdChange', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    116. 

  116.         '', 'GLUE代码初始化', '2021-11-25 10:43:51', '', 1, 1637810340000, 1637810400000),
    117. 

  117.        (12, 2, '取消申请退款超时的订单，无论该超时订单处于任何状态', '2021-11-25 10:45:21', '2021-11-25 11:11:43',
    118. 

  118.         'admin', '', 'CRON', '0 0/5 * * * ?', 'DO_NOTHING', 'FIRST', 'cancelWhenTimeOut', '', 'SERIAL_EXECUTION', 0, 0,
    119. 

  119.         'BEAN', '', 'GLUE代码初始化', '2021-11-25 10:45:21', '', 1, 1637810100000, 1637810400000),
    120. 

  120.        (13, 2, '退款临近超时提醒,每12小时执行发送一次提醒', '2021-11-25 10:46:01', '2021-11-25 11:11:40', 'admin', '',
    121. 

  121.         'CRON', '0 0 9,21 * * ?', 'DO_NOTHING', 'FIRST', 'pressRefundOrder', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    122. 

  122.         'GLUE代码初始化', '2021-11-25 10:46:01', '', 1, 0, 1637845200000),
    123. 

  123.        (14, 2, '秒杀取消超时未支付订单', '2021-11-25 10:47:58', '2021-11-25 11:11:37', 'admin', '', 'CRON',
    124. 

  124.         '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'cancelSeckillOrder', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    125. 

  125.         'GLUE代码初始化', '2021-11-25 10:47:58', '', 1, 1637810340000, 1637810400000),
    126. 

  126.        (15, 2, '秒杀活动结束时，秒杀商品改变为普通商品', '2021-11-25 10:48:19', '2021-11-25 11:11:35', 'admin', '',
    127. 

  127.         'CRON', '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'seckillFinish', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    128. 

  128.         'GLUE代码初始化', '2021-11-25 10:48:19', '', 1, 1637810340000, 1637810400000),
    129. 

  129.        (16, 2, '用户会员到期重置会员的任务', '2021-11-25 10:50:07', '2021-11-25 11:11:33', 'admin', '', 'CRON',
    130. 

  130.         '0 1 0 * * ? *', 'DO_NOTHING', 'FIRST', 'vipUserClear', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    131. 

  131.         'GLUE代码初始化', '2021-11-25 10:50:07', '', 1, 0, 1637856060000),
    132. 

  132.        (17, 2, '积分过期每年结算', '2021-11-25 10:50:29', '2021-11-25 11:11:28', 'admin', '', 'CRON', '0 0 0 1 1 ? *',
    133. 

  133.         'DO_NOTHING', 'FIRST', 'scoreExpireTask', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    134. 

  134.         '2021-11-25 10:50:29', '', 1, 0, 1640966400000),
    135. 

  135.        (18, 2, '将缓存中的用户操作记录插入到数据库(数据统计)', '2021-11-25 10:51:30', '2021-11-25 11:11:25', 'admin',
    136. 

  136.         '', 'CRON', '0 0/5 * * * ?', 'DO_NOTHING', 'FIRST', 'insertFlowAnalysisLog', '', 'SERIAL_EXECUTION', 0, 0,
    137. 

  137.         'BEAN', '', 'GLUE代码初始化', '2021-11-25 10:51:30', '', 1, 1637810100000, 1637810400000),
    138. 

  138.        (19, 2, '统计前一天的记录数据，储存到对应的数据表中(数据统计)', '2021-11-25 10:51:58', '2021-11-25 11:11:22',
    139. 

  139.         'admin', '', 'CRON', '0 0 3 * * ? ', 'DO_NOTHING', 'FIRST', 'statisticalFlowData', '', 'SERIAL_EXECUTION', 0, 0,
    140. 

  140.         'BEAN', '', 'GLUE代码初始化', '2021-11-25 10:51:58', '', 1, 1637810340000, 1637810400000),
    141. 

  141.        (24, 2, '每一分钟执行一次预售商品检查', '2021-11-25 10:55:50', '2021-11-25 11:11:04', 'admin', '', 'CRON',
    142. 

  142.         '0 0/1 * * * ? ', 'DO_NOTHING', 'FIRST', 'recoveryPreSaleProd', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    143. 

  143.         'GLUE代码初始化', '2021-11-25 10:55:50', '', 1, 1637810340000, 1637810400000),
    144. 

  144.        (25, 2, '每一分钟检查一次核销时间过期的虚拟商品并进行下架', '2021-11-25 10:56:21', '2021-11-25 11:11:01',
    145. 

  145.         'admin', '', 'CRON', '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'offlineExpireVirtualProd', '', 'SERIAL_EXECUTION',
    146. 

  146.         0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-11-25 10:56:21', '', 1, 1637810340000, 1637810400000),
    147. 

  147.        (26, 2, '满减活动过期后，关闭活动', '2021-11-25 10:57:01', '2021-11-25 11:10:59', 'admin', '', 'CRON',
    148. 

  148.         '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'closeDiscount', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    149. 

  149.         'GLUE代码初始化', '2021-11-25 10:57:01', '', 1, 1637810340000, 1637810400000),
    150. 

  150.        (28, 2, '根据签约时间改变店铺状态', '2021-11-25 10:59:37', '2021-11-25 11:10:54', 'admin', '', 'CRON',
    151. 

  151.         '0 30 0 * * ? *', 'DO_NOTHING', 'FIRST', 'changeShopStatusByContractTime', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    152. 

  152.         '', 'GLUE代码初始化', '2021-11-25 10:59:37', '', 1, 0, 1637857800000),
    153. 

  153.        (29, 2, '推送未发送的消息', '2021-11-25 11:00:42', '2021-11-25 11:10:51', 'admin', '', 'CRON', '0 0/1 * * * ?',
    154. 

  154.         'DO_NOTHING', 'FIRST', 'sendMessage', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    155. 

  155.         '2021-11-25 11:00:42', '', 1, 1637810340000, 1637810400000),
    156. 

  156.        (30, 2, '关闭已经结束的赠品活动', '2021-12-03 09:35:47', '2021-12-03 09:53:13', 'admin', '', 'CRON',
    157. 

  157.         '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'closeGiveaway', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    158. 

  158.         'GLUE代码初始化', '2021-12-03 09:35:47', '', 1, 1639448700000, 1639448760000),
    159. 

  159.        (31, 2, '关闭已经结束的套餐活动', '2021-12-14 10:24:47', '2021-12-14 10:24:52', 'admin', '', 'CRON',
    160. 

  160.         '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'closeCombo', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    161. 

  161.         'GLUE代码初始化', '2021-12-14 10:24:47', '', 1, 1639448700000, 1639448760000),
    162. 

  162.        (33, 2, '查询商家转账情况', '2022-04-14 13:34:25', '2022-05-19 14:00:16', 'admin', '', 'CRON', '0 30 0 * * ?',
    163. 

  163.         'DO_NOTHING', 'FIRST', 'queryAndUpdateEntPay', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    164. 

  164.         '2022-04-14 13:34:25', '', 1, 0, '1652977800000'),
    165. 

  165.        (34, 2, '满减活动开启，删除商家活动缓存', '2022-09-19 14:02:48', '2022-09-19 14:02:48', 'admin', '', 'CRON',
    166. 

  166.         '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'startDiscount', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    167. 

  167.         'GLUE代码初始化', '2022-09-19 14:02:48', '', 1, 1663568280000, 1663568340000),
    168. 

  168.        (35, 2, '启用未开启的赠品活动', '2022-10-08 09:10:27', '2022-10-08 09:11:36', 'admin', '', 'CRON',
    169. 

  169.         '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'enableGiveaway', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    170. 

  170.         'GLUE代码初始化', '2022-10-08 09:10:27', '', 1, 1665208680000, 1665208740000),
    171. 

  171.        (36, 2, '开启到了活动时间未开启的套餐活动', '2022-09-29 16:27:28', '2022-09-29 17:22:21', 'admin', '', 'CRON',
    172. 

  172.         '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'enableCombo', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    173. 

  173.         'GLUE代码初始化', '2022-09-29 16:27:28', '', 1, 0, 0),
    174. 

  174.        (37, 2, '检验商品es库存及销量', '2022-11-24 13:49:31', '2022-11-24 13:50:38', 'admin', '', 'CRON',
    175. 

  175.         '0 0/5 * * * ?', 'DO_NOTHING', 'FIRST', 'verifyProdStockAndSold', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    176. 

  176.         'GLUE代码初始化', '2022-11-24 13:49:31', '', 1, 1669271400000, 1669271700000),
    177. 

  177.        (38, 2, '统计店铺商品销量', '2023-03-19 14:02:48', '2023-03-19 14:02:48', 'admin', '', 'CRON', '30 0 0 * * ? *',
    178. 

  178.         'DO_NOTHING', 'FIRST', 'calculateShopSoldNum', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    179. 

  179.         '2023-03-19 14:02:48', '', 1, 1663568280000, 1663568340000),
    180. 

  180.        (41, 2, '定时改变直播间状态', '2023-07-21 17:08:16', '2023-07-24 10:24:59', 'admin', '', 'CRON',
    181. 

  181.         '0 0/30 * * * ? ', 'DO_NOTHING', 'FIRST', 'changeLiveRoomStatus', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    182. 

  182.         'GLUE代码初始化', '2023-07-21 17:08:16', '', 1, 0, 0),
    183. 

  183.        (42, 2, '发放退款', '2023-09-07 09:16:24', '2023-09-07 11:35:33', 'admin', '', 'CRON', '0 0/1 * * * ?', 'DO_NOTHING',
    184. 

  184.         'FIRST', 'refundRequest', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2023-09-07 09:16:24', '',
    185. 

  185.         1, 1694068500000, 1694068560000),
    186. 

  186.        (43, 2, '小程序发货虚拟订单和自提订单定时任务', '2023-09-15 13:53:42', '2023-09-15 14:06:19', 'admin', '', 'CRON',
    187. 

  187.         '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'wxAppShipment', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '',
    188. 

  188.         'GLUE代码初始化', '2023-09-15 13:53:42', '', 1, 0, 0),
    189. 

  189.        (44, 2, '支付宝退款订单查单', '2023-09-07 09:16:50', '2023-09-07 11:15:16', 'admin', '', 'CRON', '0 0/1 * * * ?',
    190. 

  190.         'DO_NOTHING', 'FIRST', 'updateAliPayRefundStatus', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    191. 

  191.         '2023-09-07 09:16:50', '', 1, 1694068500000, 1694068560000),
    192. 

  192.        (45, 2, '执行平台介入超时处理，超时默认平台拒绝退款', '2023-10-09 16:20:28', '2023-10-09 16:20:28', 'admin', '', 'CRON', '0 0/1 * * * ?',
    193. 

  193.         'DO_NOTHING', 'FIRST', 'refundInterventionTimeOut', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    194. 

  194.         '2023-10-09 16:20:28', '', 1, 1701833880000, 1701833940000),
    195. 

  195.        (46, 2, '用户创建通联会员', '2023-11-10 14:30:03', '2023-11-10 14:51:03', 'admin', '', 'CRON', '0 0/10 * * * ? *',
    196. 

  196.         'DO_NOTHING', 'FIRST', 'createAllinpayMember', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化',
    197. 

  197.         '2023-11-10 14:30:03', '', 0, 0, 1699599600000),
    198. 

  198.         (47,2, '改变弹窗广告状态', '2024-01-17 10:07:30', '2024-01-17 10:07:30', 'admin', '', 'CRON',
    199. 

  199.             '0 0/30 * * * ?', 'DO_NOTHING', 'FIRST', 'changePopup', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    200. 

  200.             '', 'GLUE代码初始化', '2023-12-25 10:07:30', '', 1, 0, 0),
    201. 

  201.         (49,2, '确认收货30天自动好评', '2024-03-06 10:07:30', '2024-03-06 10:07:30', 'admin', '', 'CRON',
    202. 

  202.             '0 0 * * * ?', 'DO_NOTHING', 'FIRST', 'autoProdGoodComm', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    203. 

  203.             '', 'GLUE代码初始化', '2023-12-25 10:07:30', '', 1, 0, 0),
    204. 

  204.         (50,2, '同步商品和门店的数据到es(es开启或关闭时，需执行一次)', '2024-03-15 10:07:30', '2024-03-15 10:07:30', 'admin', '', 'CRON',
    205. 

  205.             '0 0/30 * * * ?', 'DO_NOTHING', 'FIRST', 'syncDataToEs', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    206. 

  206.             '', 'GLUE代码初始化', '2023-12-25 10:07:30', '', 0, 0, 0),
    207. 

  207.         (52,2, '退款订单库存处理', '2024-03-06 10:07:30', '2024-03-06 10:07:30', 'admin', '', 'CRON',
    208. 

  208.             '0 0/5 * * * ?', 'DO_NOTHING', 'FIRST', 'refundOrderStock', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    209. 

  209.             '', 'GLUE代码初始化', '2023-12-25 10:07:30', '', 1, 0, 0),
    210. 

  210.         (53,2, '恢复商品sku库存', '2024-03-06 10:07:30', '2024-03-06 10:07:30', 'admin', '', 'CRON',
    211. 

  211.             '0 0/5 * * * ?', 'DO_NOTHING', 'FIRST', 'restoreStock', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    212. 

  212.             '', 'GLUE代码初始化', '2023-12-25 10:07:30', '', 0, 0, 0),
    213. 

  213.         (54,2,'待发货订单发货超时处理','2024-02-23 16:27:12','2024-02-23 16:27:12','admin','','CRON',
    214. 

  214.            '0 0/1 * * * ?','DO_NOTHING','FIRST','handleDeliveryTimeOutOrder','','SERIAL_EXECUTION','0','0',
    215. 

  215.            'BEAN','','GLUE代码初始化','2024-02-23 16:27:12','','1','0','0'),
    216. 

  216.         (55,2,'恢复悟空im的频道, 执行任务后要清除token，让用户全部下线','2024-02-23 16:27:12','2024-02-23 16:27:12','admin','',
    217. 

  217.            'CRON','0 0 0 1 1 ?','DO_NOTHING','FIRST','restoreChannelData','','SERIAL_EXECUTION','0','0','BEAN',
    218. 

  218.            '','GLUE代码初始化','2024-02-23 16:27:12','','0','0','0'),
    219. 

  219.         (56,2,'虚拟商品到期未使用自动退款','2024-07-02 16:55:04','2024-07-02 16:55:47','admin',
    220. 

  220.         '','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','handleExpireUnusedVirtualOrder','',
    221. 

  221.         'SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-07-02 16:55:04','','1','0','0'),
    222. 

  222.         (57,2,'获取一天前申请提现还未成功的提现申请,将提现冻结金额回退(通联环境)','2024-07-09 15:14:57','2024-07-09 15:15:29','admin',
    223. 

  223.             '','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','returnAmountByTimeOut','','SERIAL_EXECUTION','0','0','BEAN',
    224. 

  224.             '','GLUE代码初始化','2024-07-09 15:14:57','','0','0','0'),
    225. 

  225.         (58,2, '过期卡券商品，减少库存', '2024-07-16 10:58:11', '2024-07-16 10:58:19', 'admin',
    226. 

  226.             '', 'CRON', '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'overdueVoucher', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    227. 

  227.             '', 'GLUE代码初始化', '2024-07-16 10:58:11', '', 1, '0', '0'),
    228. 

  228.        (60,2, '检查商家聚水潭授权是否已经过期，过期则自动关闭', '2024-10-17 13:42:21', '2024-10-17 13:43:00', 'admin', '', 'CRON',
    229. 

  229.             '0 0/1 0 * * ?', 'DO_NOTHING', 'FIRST', 'checkShopJstConfigExpire', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    230. 

  230.             '', 'GLUE代码初始化', '2024-10-17 13:42:21', '', 0, 1729184340000, 1729267200000),
    231. 

  231.        (61,2, '每分钟更新直播间状态：到了开播时间，更新为直播中，到了直播结束时间，更新为已结束', '2024-09-14 09:26:03', '2024-09-18 09:23:38', 'admin',
    232. 

  232.         '', 'CRON', '0 * * * * ?', 'DO_NOTHING', 'FIRST', 'changeLiveCoomStatus', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN',
    233. 

  233.         '', 'GLUE代码初始化', '2024-09-14 09:26:03', '', 1, 1727074800000, 1727074860000),
    234. 

  234.        (62,2,'查询一个小时前待审核的商家在通联那边的审核状态,如果已经是全部审核通过需要将商家的审核状态改成以通过(开启通联后需要开启此定时任务)','2024-12-19 17:14:32','2024-12-20 15:17:52','admin','','CRON','0 1 * * * ?','DO_NOTHING','FIRST','checkAllinpayShopStatus','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-12-19 17:14:32','','0','0','0'),
    235. 

  235.        (63,2,'通联的商家影印件上传,定时任务20s执行一次,每个图片需要间隔5s(开启通联后需要开启此定时任务)','2024-12-19 10:38:34','2024-12-19 10:38:34','admin','','CRON','0/20 * * * * ?','DO_NOTHING','FIRST','uploadFileToAllinpay','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-12-19 10:38:34','','0','0','0'),
    236. 

  236.        (64, 2, '更新商品库存、销量', '2025-03-01 10:32:49',
    237. 

  237.         '2025-03-01 11:12:12', 'admin', '', 'CRON', '0 0/1 * * * ?', 'DO_NOTHING', 'FIRST', 'handleSkuStockChange', '',
    238. 

  238.         'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-11-25 10:32:49', '', 1, 1637810340000,
    239. 

  239.         1637810400000),
    240. 

  240.        (65, 2, '执行通联订单的平台转账','2025-04-01 11:12:18','2025-04-01 11:12:18','admin','','CRON','0 0 1 * * ?','DO_NOTHING','FIRST','doAllinpayPlatformTransfer','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2025-04-01 11:12:18','','0','0','0'),
    241. 

  241.        (66, 2, '店铺销量初始化统计', '2025-04-07 10:04:38', '2025-04-07 10:04:38', 'admin', '', 'NONE', '', 'DO_NOTHING', 'FIRST', 'initShopSoldNum', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2025-04-07 10:04:38', '', 0, 0, 0),
    242. 

  242. (67,2,'解锁创建失败订单的redis库存记录','2025-08-19 16:54:50','2025-08-21 14:30:10','admin','','CRON','0 0 * * * ?','DO_NOTHING','FIRST','unLockOrderSkuStock','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2025-08-19 16:54:50','','1','0','1755759600000');
    243. 

  243. 

  244. 

  245. 

  246. 

  247. /*Table structure for table `xxl_job_lock` */
    248. 

  248. 

  249. DROP TABLE IF EXISTS `xxl_job_lock`;
    250. 

  250. 

  251. CREATE TABLE `xxl_job_lock`
    252. 

  252. (
    253. 

  253.     `lock_name` varchar(50) NOT NULL COMMENT '锁名称',
    254. 

  254.     PRIMARY KEY (`lock_name`)
    255. 

  255. ) ENGINE = InnoDB
    256. 

  256.   DEFAULT CHARSET = utf8mb4
    257. 

  257.   COLLATE = utf8mb4_general_ci;
    258. 

  258. 

  259. /*Data for the table `xxl_job_lock` */
    260. 

  260. 

  261. insert into `xxl_job_lock`(`lock_name`)
    262. 

  262. values ('schedule_lock');
    263. 

  263. 

  264. /*Table structure for table `xxl_job_log` */
    265. 

  265. 

  266. DROP TABLE IF EXISTS `xxl_job_log`;
    267. 

  267. 

  268. CREATE TABLE `xxl_job_log`
    269. 

  269. (
    270. 

  270.     `id`                        bigint  NOT NULL AUTO_INCREMENT,
    271. 

  271.     `job_group`                 int     NOT NULL COMMENT '执行器主键ID',
    272. 

  272.     `job_id`                    int     NOT NULL COMMENT '任务，主键ID',
    273. 

  273.     `executor_address`          varchar(255)     DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
    274. 

  274.     `executor_handler`          varchar(255)     DEFAULT NULL COMMENT '执行器任务handler',
    275. 

  275.     `executor_param`            varchar(512)     DEFAULT NULL COMMENT '执行器任务参数',
    276. 

  276.     `executor_sharding_param`   varchar(20)      DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
    277. 

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

  278.     `trigger_time`              datetime         DEFAULT NULL COMMENT '调度-时间',
    279. 

  279.     `trigger_code`              int     NOT NULL COMMENT '调度-结果',
    280. 

  280.     `trigger_msg`               text COMMENT '调度-日志',
    281. 

  281.     `handle_time`               datetime         DEFAULT NULL COMMENT '执行-时间',
    282. 

  282.     `handle_code`               int     NOT NULL COMMENT '执行-状态',
    283. 

  283.     `handle_msg`                text COMMENT '执行-日志',
    284. 

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

  285.     PRIMARY KEY (`id`),
    286. 

  286.     KEY `I_trigger_time` (`trigger_time`),
    287. 

  287.     KEY `I_handle_code` (`handle_code`)
    288. 

  288. ) ENGINE = InnoDB
    289. 

  289.   AUTO_INCREMENT = 135
    290. 

  290.   DEFAULT CHARSET = utf8mb4
    291. 

  291.   COLLATE = utf8mb4_general_ci;
    292. 

  292. 

  293. /*Data for the table `xxl_job_log` */
    294. 

  294. 

  295. /*Table structure for table `xxl_job_log_report` */
    296. 

  296. 

  297. DROP TABLE IF EXISTS `xxl_job_log_report`;
    298. 

  298. 

  299. CREATE TABLE `xxl_job_log_report`
    300. 

  300. (
    301. 

  301.     `id`            int NOT NULL AUTO_INCREMENT,
    302. 

  302.     `trigger_day`   datetime     DEFAULT NULL COMMENT '调度-时间',
    303. 

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

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

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

  306.     `update_time`   datetime     DEFAULT NULL,
    307. 

  307.     PRIMARY KEY (`id`),
    308. 

  308.     UNIQUE KEY `i_trigger_day` (`trigger_day`) USING BTREE
    309. 

  309. ) ENGINE = InnoDB
    310. 

  310.   AUTO_INCREMENT = 4
    311. 

  311.   DEFAULT CHARSET = utf8mb4
    312. 

  312.   COLLATE = utf8mb4_general_ci;
    313. 

  313. 

  314. /*Data for the table `xxl_job_log_report` */
    315. 

  315. 

  316. /*Table structure for table `xxl_job_logglue` */
    317. 

  317. 

  318. DROP TABLE IF EXISTS `xxl_job_logglue`;
    319. 

  319. 

  320. CREATE TABLE `xxl_job_logglue`
    321. 

  321. (
    322. 

  322.     `id`          int          NOT NULL AUTO_INCREMENT,
    323. 

  323.     `job_id`      int          NOT NULL COMMENT '任务，主键ID',
    324. 

  324.     `glue_type`   varchar(50) DEFAULT NULL COMMENT 'GLUE类型',
    325. 

  325.     `glue_source` mediumtext COMMENT 'GLUE源代码',
    326. 

  326.     `glue_remark` varchar(128) NOT NULL COMMENT 'GLUE备注',
    327. 

  327.     `add_time`    datetime    DEFAULT NULL,
    328. 

  328.     `update_time` datetime    DEFAULT NULL,
    329. 

  329.     PRIMARY KEY (`id`)
    330. 

  330. ) ENGINE = InnoDB
    331. 

  331.   DEFAULT CHARSET = utf8mb4
    332. 

  332.   COLLATE = utf8mb4_general_ci;
    333. 

  333. 

  334. /*Data for the table `xxl_job_logglue` */
    335. 

  335. 

  336. /*Table structure for table `xxl_job_registry` */
    337. 

  337. 

  338. DROP TABLE IF EXISTS `xxl_job_registry`;
    339. 

  339. 

  340. CREATE TABLE `xxl_job_registry`
    341. 

  341. (
    342. 

  342.     `id`             int          NOT NULL AUTO_INCREMENT,
    343. 

  343.     `registry_group` varchar(50)  NOT NULL,
    344. 

  344.     `registry_key`   varchar(255) NOT NULL,
    345. 

  345.     `registry_value` varchar(255) NOT NULL,
    346. 

  346.     `update_time`    datetime DEFAULT NULL,
    347. 

  347.     PRIMARY KEY (`id`),
    348. 

  348.     KEY `i_g_k_v` (`registry_group`, `registry_key`, `registry_value`)
    349. 

  349. ) ENGINE = InnoDB
    350. 

  350.   AUTO_INCREMENT = 4
    351. 

  351.   DEFAULT CHARSET = utf8mb4
    352. 

  352.   COLLATE = utf8mb4_general_ci;
    353. 

  353. 

  354. /*Data for the table `xxl_job_registry` */
    355. 

  355. 

  356. /*Table structure for table `xxl_job_user` */
    357. 

  357. 

  358. DROP TABLE IF EXISTS `xxl_job_user`;
    359. 

  359. 

  360. CREATE TABLE `xxl_job_user`
    361. 

  361. (
    362. 

  362.     `id`         int         NOT NULL AUTO_INCREMENT,
    363. 

  363.     `username`   varchar(50) NOT NULL COMMENT '账号',
    364. 

  364.     `password`   varchar(50) NOT NULL COMMENT '密码',
    365. 

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

  366.     `permission` varchar(255) DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
    367. 

  367.     PRIMARY KEY (`id`),
    368. 

  368.     UNIQUE KEY `i_username` (`username`) USING BTREE
    369. 

  369. ) ENGINE = InnoDB
    370. 

  370.   AUTO_INCREMENT = 2
    371. 

  371.   DEFAULT CHARSET = utf8mb4
    372. 

  372.   COLLATE = utf8mb4_general_ci;
    373. 

  373. 

  374. /*Data for the table `xxl_job_user` */
    375. 

  375. # 密码hn02le.34lkdLKD
    376. 

  376. insert into `xxl_job_user`(`id`, `username`, `password`, `role`, `permission`)
    377. 

  377. values (1, 'admin', '5d10634cf16a4311bcf541e227be0665', 1, NULL);
    378. 

  378. 

  379. /*!40101 SET SQL_MODE = @OLD_SQL_MODE */;
    380. 

  380. /*!40014 SET FOREIGN_KEY_CHECKS = @OLD_FOREIGN_KEY_CHECKS */;
    381. 

  381. /*!40014 SET UNIQUE_CHECKS = @OLD_UNIQUE_CHECKS */;
    382. 

  382. /*!40111 SET SQL_NOTES = @OLD_SQL_NOTES */;
    383.