java-bbc/db/2025-09-02 修复菜单结构和添加解锁创建失败订单处理库存的定时任务.sql

USE `yami_bbc`;

-- 1427 为门店端代客下单菜单，（1428,1429,1430）为菜单中的保存修改删除按钮
UPDATE tz_shop_menu SET parent_id = 1427 WHERE menu_id IN (1428,1429,1430);


# 添加解锁创建失败订单的redis库存记录定时任务
USE `xxl_job`;
insert into `xxl_job_info` (`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','解锁创建失败订单的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');