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
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
| /*
| SQLyog Ultimate v13.1.1 (64 bit)
| MySQL - 8.0.27 : Database - xxl_job
| *********************************************************************
| */
|
| /*!40101 SET NAMES utf8 */;
|
| /*!40101 SET SQL_MODE=''*/;
|
| /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
| /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
| /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
| /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
| CREATE DATABASE /*!32312 IF NOT EXISTS*/`xxl_job` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ /*!80016 DEFAULT ENCRYPTION='N' */;
|
| USE `xxl_job`;
|
| /*Table structure for table `xxl_job_group` */
|
| DROP TABLE IF EXISTS `xxl_job_group`;
|
| CREATE TABLE `xxl_job_group` (
| `id` int NOT NULL AUTO_INCREMENT,
| `app_name` varchar(64) NOT NULL COMMENT '执行器AppName',
| `title` varchar(12) NOT NULL COMMENT '执行器名称',
| `address_type` tinyint NOT NULL DEFAULT '0' COMMENT '执行器地址类型：0=自动注册、1=手动录入',
| `address_list` text COMMENT '执行器地址列表，多地址逗号分隔',
| `update_time` datetime DEFAULT NULL,
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_group` */
|
| insert into `xxl_job_group`(`id`,`app_name`,`title`,`address_type`,`address_list`,`update_time`) values
| (2,'mall4j-bbc','mall4j商城系统',0,'','2021-11-25 11:19:02');
|
| /*Table structure for table `xxl_job_info` */
|
| DROP TABLE IF EXISTS `xxl_job_info`;
|
| CREATE TABLE `xxl_job_info` (
| `id` int NOT NULL AUTO_INCREMENT,
| `job_group` int NOT NULL COMMENT '执行器主键ID',
| `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 '报警邮件',
| `schedule_type` varchar(50) NOT NULL DEFAULT 'NONE' COMMENT '调度类型',
| `schedule_conf` varchar(128) DEFAULT NULL COMMENT '调度配置，值含义取决于调度类型',
| `misfire_strategy` varchar(50) NOT NULL DEFAULT 'DO_NOTHING' 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 NOT NULL DEFAULT '0' COMMENT '任务执行超时时间，单位秒',
| `executor_fail_retry_count` int 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 NOT NULL DEFAULT '0' COMMENT '调度状态：0-停止，1-运行',
| `trigger_last_time` bigint NOT NULL DEFAULT '0' COMMENT '上次调度时间',
| `trigger_next_time` bigint NOT NULL DEFAULT '0' COMMENT '下次调度时间',
| PRIMARY KEY (`id`)
| ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_info` */
|
| insert into `xxl_job_info`(`id`,`job_group`,`job_desc`,`add_time`,`update_time`,`author`,`alarm_email`,`schedule_type`,`schedule_conf`,`misfire_strategy`,`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
| (2,2,'设置店铺的过期优惠券为过期状态，改变店铺库存为0优惠券的状态(设为取消投放状态)','2021-11-25 10:32:49','2021-11-25 11:12:12','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','changeCoupon','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:32:49','',1,1637810340000,1637810400000),
| (3,2,'删除用户失效30天以上的优惠券','2021-11-25 10:35:32','2021-11-25 11:12:08','admin','','CRON','0 0 0/1 * * ?','DO_NOTHING','FIRST','deleteCouponUser','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:35:32','',1,0,1637812800000),
| (4,2,'改变用户优惠券的状态(设为失效状态)','2021-11-25 10:36:07','2021-11-25 11:12:03','admin','','CRON','0 * * * * ?','DO_NOTHING','FIRST','changeCouponUser','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:36:07','',1,1637810340000,1637810400000),
| (5,2,'投放优惠券','2021-11-25 10:36:34','2021-11-25 11:12:01','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','putOnCoupon','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:36:34','',1,1637810340000,1637810400000),
| (6,2,'取消超时未支付订单','2021-11-25 10:39:58','2021-11-25 11:11:59','admin','','CRON','0 * * * * ?','DO_NOTHING','FIRST','cancelOrder','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:39:58','',1,1637810340000,1637810400000),
| (7,2,'系统自动确认收货订单','2021-11-25 10:40:20','2021-11-25 11:11:56','admin','','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','confirmOrder','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:40:20','',1,1637810100000,1637810400000),
| (8,2,'1分钟执行一次订单催付通知，对没支付的订单发送通知','2021-11-25 10:41:25','2021-11-25 11:11:54','admin','','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','pressPayOrder','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:41:25','',1,1637810340000,1637810400000),
| (9,2,'每天00:00:05执行一遍订单结算定时任务','2021-11-25 10:42:07','2021-11-25 11:11:51','admin','','CRON','5 0 0 * * ? *','DO_NOTHING','FIRST','orderCommissionSettlement','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:42:07','',1,0,1637856005000),
| (10,2,'活动结束任务：处理所有未成团的拼团单（退款处理）、清除物品拼团活动ID、处理拼团单（退款处理）','2021-11-25 10:43:22','2021-11-25 11:11:48','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','activityFinish','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:43:22','',1,1637810340000,1637810400000),
| (11,2,'团购活动失效，活动商品恢复为普通商品','2021-11-25 10:43:51','2021-11-25 11:11:45','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','activityFinishAndProdChange','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:43:51','',1,1637810340000,1637810400000),
| (12,2,'取消申请退款超时的订单，无论该超时订单处于任何状态','2021-11-25 10:45:21','2021-11-25 11:11:43','admin','','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','cancelWhenTimeOut','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:45:21','',1,1637810100000,1637810400000),
| (13,2,'退款临近超时提醒,每12小时执行发送一次提醒','2021-11-25 10:46:01','2021-11-25 11:11:40','admin','','CRON','0 0 9,21 * * ?','DO_NOTHING','FIRST','pressRefundOrder','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:46:01','',1,0,1637845200000),
| (14,2,'秒杀取消超时未支付订单','2021-11-25 10:47:58','2021-11-25 11:11:37','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','cancelSeckillOrder','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:47:58','',1,1637810340000,1637810400000),
| (15,2,'秒杀活动结束时，秒杀商品改变为普通商品','2021-11-25 10:48:19','2021-11-25 11:11:35','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','seckillFinish','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:48:19','',1,1637810340000,1637810400000),
| (16,2,'用户会员到期重置会员的任务','2021-11-25 10:50:07','2021-11-25 11:11:33','admin','','CRON','0 1 0 * * ? *','DO_NOTHING','FIRST','vipUserClear','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:50:07','',1,0,1637856060000),
| (17,2,'积分过期每年结算','2021-11-25 10:50:29','2021-11-25 11:11:28','admin','','CRON','0 0 0 1 1 ? *','DO_NOTHING','FIRST','scoreExpireTask','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:50:29','',1,0,1640966400000),
| (18,2,'将缓存中的用户操作记录插入到数据库(数据统计)','2021-11-25 10:51:30','2021-11-25 11:11:25','admin','','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','insertFlowAnalysisLog','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:51:30','',1,1637810100000,1637810400000),
| (19,2,'统计前一天的记录数据，储存到对应的数据表中(数据统计)','2021-11-25 10:51:58','2021-11-25 11:11:22','admin','','CRON','0 0 3 * * ? ','DO_NOTHING','FIRST','statisticalFlowData','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:51:58','',1,1637810340000,1637810400000),
| (20,2,'定时五分钟同步下微信直播商品','2021-11-25 10:53:43','2021-11-25 11:11:16','admin','','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','synchronousWxLiveProds','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:53:43','',1,1637810100000,1637810400000),
| (21,2,'每天清除十天前旧的直播商品','2021-11-25 10:54:03','2021-11-25 11:11:12','admin','','CRON','0 0 0 1/1 * ?','DO_NOTHING','FIRST','offShelfLiveProds','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:54:03','',1,0,1637856000000),
| (22,2,'每一分钟获取一次微信直播间的最新数据','2021-11-25 10:54:31','2021-11-25 11:11:09','admin','','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','synchronousWxLiveRoom','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:54:31','',1,1637810340000,1637810400000),
| (23,2,'定时五分钟同步下微信成员信息','2021-11-25 10:54:50','2021-11-25 11:11:07','admin','','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','synchronousWxLiveUsers','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:54:50','',1,1637810100000,1637810400000),
| (24,2,'每一分钟执行一次预售商品检查','2021-11-25 10:55:50','2021-11-25 11:11:04','admin','','CRON','0 0/1 * * * ? ','DO_NOTHING','FIRST','recoveryPreSaleProd','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:55:50','',1,1637810340000,1637810400000),
| (25,2,'每一分钟检查一次核销时间过期的虚拟商品并进行下架','2021-11-25 10:56:21','2021-11-25 11:11:01','admin','','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','offlineExpireVirtualProd','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:56:21','',1,1637810340000,1637810400000),
| (26,2,'满减活动过期后，关闭活动','2021-11-25 10:57:01','2021-11-25 11:10:59','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','closeDiscount','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:57:01','',1,1637810340000,1637810400000),
| (27,2,'更新es中的商品信息','2021-11-25 10:58:36','2021-11-25 11:10:56','admin','','CRON','0 0 0/1 * * ?','DO_NOTHING','FIRST','verifySpuData','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:58:36','',1,0,1637812800000),
| (28,2,'根据签约时间改变店铺状态','2021-11-25 10:59:37','2021-11-25 11:10:54','admin','','CRON','0 30 0 * * ? *','DO_NOTHING','FIRST','changeShopStatusByContractTime','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 10:59:37','',1,0,1637857800000),
| (29,2,'推送未发送的消息','2021-11-25 11:00:42','2021-11-25 11:10:51','admin','','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','sendMessage','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-11-25 11:00:42','',1,1637810340000,1637810400000),
| (30,2,'关闭已经结束的赠品活动','2021-12-03 09:35:47','2021-12-03 09:53:13','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','closeGiveaway','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-12-03 09:35:47','',1,1639448700000,1639448760000),
| (31,2,'关闭已经结束的套餐活动','2021-12-14 10:24:47','2021-12-14 10:24:52','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','closeCombo','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2021-12-14 10:24:47','',1,1639448700000,1639448760000),
| (32,2,'企业支付','2022-04-14 13:33:41','2022-05-19 14:00:19','admin','','CRON','0 0 0 * * ?','DO_NOTHING','FIRST','sendEnterprisePay','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2022-04-14 13:33:41','',1,0,'1652976000000'),
| (33,2,'查询企业支付情况','2022-04-14 13:34:25','2022-05-19 14:00:16','admin','','CRON','0 30 0 * * ?','DO_NOTHING','FIRST','queryAndUpdateEntPay','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2022-04-14 13:34:25','',1,0,'1652977800000'),
| (34,2,'满减活动开启，删除商家活动缓存','2022-09-19 14:02:48','2022-09-19 14:02:48','admin','','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','startDiscount','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2022-09-19 14:02:48','',1,1663568280000,1663568340000),
| (35,2,'启用未开启的赠品活动','2022-10-08 09:10:27','2022-10-08 09:11:36','admin','','CRON','0 1/30 * * * ?','DO_NOTHING','FIRST','enableGiveaway','','SERIAL_EXECUTION', 0, 0, 'BEAN','','GLUE代码初始化','2022-10-08 09:10:27','', 1, 1665208680000, 1665208740000),
| (36,2, '开启到了活动时间未开启的套餐活动', '2022-09-29 16:27:28', '2022-09-29 17:22:21', 'admin', '', 'CRON', '0 1/30 * * * ?', 'DO_NOTHING', 'FIRST', 'enableCombo', '', 'SERIAL_EXECUTION', 0, 0, 'BEAN', '', 'GLUE代码初始化', '2022-09-29 16:27:28', '', 0, 0, 0),
| (37,2,'检验商品es库存及销量','2022-11-24 13:49:31','2022-11-24 13:50:38','admin','','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','verifyProdStockAndSold','','SERIAL_EXECUTION',0,0,'BEAN','','GLUE代码初始化','2022-11-24 13:49:31','',1,1669271400000,1669271700000);
|
|
| /*Table structure for table `xxl_job_lock` */
|
| DROP TABLE IF EXISTS `xxl_job_lock`;
|
| CREATE TABLE `xxl_job_lock` (
| `lock_name` varchar(50) NOT NULL COMMENT '锁名称',
| PRIMARY KEY (`lock_name`)
| ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_lock` */
|
| insert into `xxl_job_lock`(`lock_name`) values
| ('schedule_lock');
|
| /*Table structure for table `xxl_job_log` */
|
| DROP TABLE IF EXISTS `xxl_job_log`;
|
| CREATE TABLE `xxl_job_log` (
| `id` bigint NOT NULL AUTO_INCREMENT,
| `job_group` int NOT NULL COMMENT '执行器主键ID',
| `job_id` int 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 NOT NULL DEFAULT '0' COMMENT '失败重试次数',
| `trigger_time` datetime DEFAULT NULL COMMENT '调度-时间',
| `trigger_code` int NOT NULL COMMENT '调度-结果',
| `trigger_msg` text COMMENT '调度-日志',
| `handle_time` datetime DEFAULT NULL COMMENT '执行-时间',
| `handle_code` int NOT NULL COMMENT '执行-状态',
| `handle_msg` text COMMENT '执行-日志',
| `alarm_status` tinyint 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 AUTO_INCREMENT=135 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_log` */
|
| /*Table structure for table `xxl_job_log_report` */
|
| DROP TABLE IF EXISTS `xxl_job_log_report`;
|
| CREATE TABLE `xxl_job_log_report` (
| `id` int NOT NULL AUTO_INCREMENT,
| `trigger_day` datetime DEFAULT NULL COMMENT '调度-时间',
| `running_count` int NOT NULL DEFAULT '0' COMMENT '运行中-日志数量',
| `suc_count` int NOT NULL DEFAULT '0' COMMENT '执行成功-日志数量',
| `fail_count` int NOT NULL DEFAULT '0' COMMENT '执行失败-日志数量',
| `update_time` datetime DEFAULT NULL,
| PRIMARY KEY (`id`),
| UNIQUE KEY `i_trigger_day` (`trigger_day`) USING BTREE
| ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_log_report` */
|
| /*Table structure for table `xxl_job_logglue` */
|
| DROP TABLE IF EXISTS `xxl_job_logglue`;
|
| CREATE TABLE `xxl_job_logglue` (
| `id` int NOT NULL AUTO_INCREMENT,
| `job_id` int 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 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_logglue` */
|
| /*Table structure for table `xxl_job_registry` */
|
| DROP TABLE IF EXISTS `xxl_job_registry`;
|
| CREATE TABLE `xxl_job_registry` (
| `id` int 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 AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_registry` */
|
| /*Table structure for table `xxl_job_user` */
|
| DROP TABLE IF EXISTS `xxl_job_user`;
|
| CREATE TABLE `xxl_job_user` (
| `id` int NOT NULL AUTO_INCREMENT,
| `username` varchar(50) NOT NULL COMMENT '账号',
| `password` varchar(50) NOT NULL COMMENT '密码',
| `role` tinyint NOT NULL COMMENT '角色：0-普通用户、1-管理员',
| `permission` varchar(255) DEFAULT NULL COMMENT '权限：执行器ID列表，多个逗号分割',
| PRIMARY KEY (`id`),
| UNIQUE KEY `i_username` (`username`) USING BTREE
| ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
|
| /*Data for the table `xxl_job_user` */
|
| insert into `xxl_job_user`(`id`,`username`,`password`,`role`,`permission`) values
| (1,'admin','e10adc3949ba59abbe56e057f20f883e',1,NULL);
|
| /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
| /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
| /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
| /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
|
