1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_info`;
| CREATE TABLE `xxl_job`.`xxl_job_info`
| (
| `id` int(11) NOT NULL AUTO_INCREMENT,
| `job_group` int(11) NOT NULL COMMENT '执行器主键ID',
| `job_cron` varchar(128) NOT NULL COMMENT '任务执行CRON',
| `job_desc` varchar(255) NOT NULL,
| `add_time` datetime DEFAULT NULL,
| `update_time` datetime DEFAULT NULL,
| `author` varchar(64) DEFAULT NULL COMMENT '作者',
| `alarm_email` varchar(255) DEFAULT NULL COMMENT '报警邮件',
| `executor_route_strategy` varchar(50) DEFAULT NULL COMMENT '执行器路由策略',
| `executor_handler` varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
| `executor_param` varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
| `executor_block_strategy` varchar(50) DEFAULT NULL COMMENT '阻塞处理策略',
| `executor_timeout` int(11) NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位秒',
| `executor_fail_retry_count` int(11) NOT NULL DEFAULT '0' COMMENT '失败重试次数',
| `glue_type` varchar(50) NOT NULL COMMENT 'GLUE类型',
| `glue_source` mediumtext COMMENT 'GLUE源代码',
| `glue_remark` varchar(128) DEFAULT NULL COMMENT 'GLUE备注',
| `glue_updatetime` datetime DEFAULT NULL COMMENT 'GLUE更新时间',
| `child_jobid` varchar(255) DEFAULT NULL COMMENT '子任务ID，多个逗号分隔',
| `trigger_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '调度状态：0-停止，1-运行',
| `trigger_last_time` bigint(13) NOT NULL DEFAULT '0' COMMENT '上次调度时间',
| `trigger_next_time` bigint(13) NOT NULL DEFAULT '0' COMMENT '下次调度时间',
| PRIMARY KEY (`id`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_log`;
| CREATE TABLE `xxl_job`.`xxl_job_log`
| (
| `id` bigint(20) NOT NULL AUTO_INCREMENT,
| `job_group` int(11) NOT NULL COMMENT '执行器主键ID',
| `job_id` int(11) NOT NULL COMMENT '任务，主键ID',
| `executor_address` varchar(255) DEFAULT NULL COMMENT '执行器地址，本次执行的地址',
| `executor_handler` varchar(255) DEFAULT NULL COMMENT '执行器任务handler',
| `executor_param` varchar(512) DEFAULT NULL COMMENT '执行器任务参数',
| `executor_sharding_param` varchar(20) DEFAULT NULL COMMENT '执行器任务分片参数，格式如 1/2',
| `executor_fail_retry_count` int(11) NOT NULL DEFAULT '0' COMMENT '失败重试次数',
| `trigger_time` datetime DEFAULT NULL COMMENT '调度-时间',
| `trigger_code` int(11) NOT NULL COMMENT '调度-结果',
| `trigger_msg` text COMMENT '调度-日志',
| `handle_time` datetime DEFAULT NULL COMMENT '执行-时间',
| `handle_code` int(11) NOT NULL COMMENT '执行-状态',
| `handle_msg` text COMMENT '执行-日志',
| `alarm_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '告警状态：0-默认、1-无需告警、2-告警成功、3-告警失败',
| PRIMARY KEY (`id`),
| KEY `I_trigger_time` (`trigger_time`),
| KEY `I_handle_code` (`handle_code`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_log_report`;
| CREATE TABLE `xxl_job`.`xxl_job_log_report`
| (
| `id` int(11) NOT NULL AUTO_INCREMENT,
| `trigger_day` datetime DEFAULT NULL COMMENT '调度-时间',
| `running_count` int(11) NOT NULL DEFAULT '0' COMMENT '运行中-日志数量',
| `suc_count` int(11) NOT NULL DEFAULT '0' COMMENT '执行成功-日志数量',
| `fail_count` int(11) NOT NULL DEFAULT '0' COMMENT '执行失败-日志数量',
| PRIMARY KEY (`id`),
| UNIQUE KEY `i_trigger_day` (`trigger_day`) USING BTREE
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_logglue`;
| CREATE TABLE `xxl_job`.`xxl_job_logglue`
| (
| `id` int(11) NOT NULL AUTO_INCREMENT,
| `job_id` int(11) NOT NULL COMMENT '任务，主键ID',
| `glue_type` varchar(50) DEFAULT NULL COMMENT 'GLUE类型',
| `glue_source` mediumtext COMMENT 'GLUE源代码',
| `glue_remark` varchar(128) NOT NULL COMMENT 'GLUE备注',
| `add_time` datetime DEFAULT NULL,
| `update_time` datetime DEFAULT NULL,
| PRIMARY KEY (`id`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_registry`;
| CREATE TABLE `xxl_job`.`xxl_job_registry`
| (
| `id` int(11) NOT NULL AUTO_INCREMENT,
| `registry_group` varchar(50) NOT NULL,
| `registry_key` varchar(255) NOT NULL,
| `registry_value` varchar(255) NOT NULL,
| `update_time` datetime DEFAULT NULL,
| PRIMARY KEY (`id`),
| KEY `i_g_k_v` (`registry_group`, `registry_key`, `registry_value`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_group`;
| CREATE TABLE `xxl_job`.`xxl_job_group`
| (
| `id` int(11) NOT NULL AUTO_INCREMENT,
| `app_name` varchar(64) NOT NULL COMMENT '执行器AppName',
| `title` varchar(20) NOT NULL COMMENT '执行器名称',
| `order` int(11) NOT NULL COMMENT '排序',
| `address_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
| `address_list` varchar(512) DEFAULT NULL COMMENT '执行器地址列表，多地址逗号分隔',
| PRIMARY KEY (`id`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_user`;
| CREATE TABLE `xxl_job`.`xxl_job_user`
| (
| `id` int(11) NOT NULL AUTO_INCREMENT,
| `username` varchar(50) NOT NULL COMMENT '账号',
| `password` varchar(50) NOT NULL COMMENT '密码',
| `role` tinyint(4) NOT NULL COMMENT '角色：0-普通用户、1-管理员',
| `permission` varchar(255) DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
| PRIMARY KEY (`id`),
| UNIQUE KEY `i_username` (`username`) USING BTREE
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| DROP TABLE IF EXISTS `xxl_job`.`xxl_job_lock`;
| CREATE TABLE `xxl_job`.`xxl_job_lock`
| (
| `lock_name` varchar(50) NOT NULL COMMENT '锁名称',
| PRIMARY KEY (`lock_name`)
| ) ENGINE = InnoDB
| DEFAULT CHARSET = utf8mb4;
|
| INSERT INTO `xxl_job`.`xxl_job_group`(`id`, `app_name`, `title`, `order`, `address_type`, `address_list`)
| VALUES (15, 'phoenix', '新单体执行器', 1, 0, '10.42.1.209:7079'),
| (17, 'phoenix-posting', '单体过账Posting', 1, 0, '10.42.1.205:7227');
|
| INSERT INTO `xxl_job`.`xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`,
| `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`,
| `executor_param`, `executor_block_strategy`, `executor_timeout`,
| `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`,
| `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`,
| `trigger_next_time`)
| VALUES (36, 15, '0 0 18 * * ?', '每天更新工位生产日历', '2021-12-21 13:28:38', '2022-01-17 09:26:55', 'qizheng.sun', '', 'FIRST',
| 'workstationCalendarJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-21 13:28:38',
| '', 1, 1653559200000, 1653645600000),
| (40, 17, '0 0/6 * * * ?', '聚合工位原始采集数据', '2021-12-22 18:35:21', '2022-01-17 10:07:55', 'POSTING', '', 'FIRST',
| 'workStationAggregateJobHandler', '', 'DISCARD_LATER', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-22 18:35:21', '',
| 1, 1653566040000, 1653566400000),
| (41, 17, '0 56 23 * * ?', '构建明日生产日历时间切片缓存', '2021-12-22 18:36:55', '2022-01-14 10:37:18', 'POSTING', '', 'FIRST',
| 'productionTimeCacheJobHandler', '', 'DISCARD_LATER', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-22 18:36:55', '',
| 1, 1653559800000, 1653646200000),
| (42, 17, '0 30 23 * * ?', '构建工位状态明日班次固定点', '2021-12-22 18:38:25', '2022-01-14 10:36:59', 'POSTING', '', 'FIRST',
| 'stateFixPointJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2021-12-22 18:38:25', '', 1,
| 1653559500000, 1653645900000),
| (48, 15, '0 56 23 * * ?', '生产日历切片缓存', '2022-03-23 18:32:50', '2022-03-23 18:39:03', 'wenchao.long', '', 'FIRST',
| 'calendarCacheJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-03-23 18:32:50', '', 1,
| 1653494160000, 1653580560000),
| (49, 15, '0/5 * * * * ?', '同步当前时间全量参数', '2022-07-16 11:06:46', '2022-07-16 11:06:46', 'wenchao.long', '',
| 'FIRST',
| 'allDmpCollectDataJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-07-16 11:06:46', '',
| 1, 0, 0),
| (44, 15, '0 0 0 * * ?', '保养计划定时任务', '2022-03-02 15:07:10', '2022-03-02 15:07:36', 'jiangxiaodong', '', 'FIRST',
| 'maintainPlanJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-03-02 15:07:10', '', 1,
| 1653494400000, 1653580800000),
| (50, 15, '0 30 8 * * ?', '逾期通知定时任务', '2022-08-26 13:17:03', '2022-08-26 15:15:53', 'haolv', '', 'FIRST',
| 'maintain-overdueJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-26 13:17:03', '',
| 1, 1661585400000, 1661587200000),
| (51, 15, '0 30 8 * * ?', '预警通知定时任务', '2022-08-26 13:18:07', '2022-08-26 15:15:50', 'haolv', '', 'FIRST',
| 'maintenance-warningJobHandler', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-26 13:18:07',
| '', 1, 1661585400000, 1661587200000),
| (53, 15, '0/2 * * * * ?', 'fms实时数据推送', '2022-08-29 10:13:30', '2022-08-29 10:13:30', 'XXL', '', 'FIRST',
| 'fmsPushDataJob', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-08-29 10:13:30', '', 1,
| 1661761462000, 1661761464000),
| (54, 17, '0/10 * * * * ?', '定时扫描状态反馈执行记录', '2022-09-07 17:12:02', '2022-09-15 13:19:56', 'POSTING', '', 'FIRST',
| 'feedbackAnalyseJobHandler', '', 'DISCARD_LATER', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-09-07 17:12:02', '', 1,
| 1663312480000, 1663312490000);
|
|
|
| INSERT INTO `xxl_job`.`xxl_job_lock`(`lock_name`)
| VALUES ('schedule_lock');
|
| INSERT INTO `xxl_job`.`xxl_job_user`(`id`, `username`, `password`, `role`, `permission`)
| VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 1, NULL);
|
| -- 定时清除dmp日志任务
| INSERT INTO `xxl_job`.`xxl_job_info`(`id`, `job_group`, `job_cron`, `job_desc`, `add_time`, `update_time`, `author`, `alarm_email`, `executor_route_strategy`, `executor_handler`, `executor_param`, `executor_block_strategy`, `executor_timeout`, `executor_fail_retry_count`, `glue_type`, `glue_source`, `glue_remark`, `glue_updatetime`, `child_jobid`, `trigger_status`, `trigger_last_time`, `trigger_next_time`) VALUES (55, 15, '0 0 2 L 3/3 ? ', 'DMP日志定期清除任务', '2022-10-11 19:45:11', '2022-10-11 19:45:47', 'wangshaofei', '', 'FIRST', 'dmpLogRegularCleanJobHandler', '3', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-10-11 19:45:11', '', 0, 0, 0);
|
|
