-- sys_user_unite

CREATE TABLE `sys_user_unite`  (
                                   `user_id` bigint NOT NULL COMMENT '用户id',
                                   `ding_talk_union_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '钉钉用户唯一标识',
                                   `ding_talk_user_id` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '钉钉用户唯一标识',
                                   PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户钉钉关系表' ROW_FORMAT = Dynamic;




-- 定时任务
INSERT INTO sys_job ( job_name, job_group, invoke_target, cron_expression, misfire_policy, concurrent, status, create_by, create_time, update_by, update_time, remark) VALUES ( '定时修改密码', 'SYSTEM', 'ZrTask.syncUpdatePassword()', '0 2 1 */3 * ?', '1', '1', '0', 'admin', NOW(), 'admin', NOW(), '');