java-bbc/db/2024-07-16 添加虚拟商品到期自动退款等定时任务.sql

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','虚拟商品到期未使用自动退款','2024-07-02 16:55:04','2024-07-02 18:03:25','admin','','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','handleExpireUnusedVirtualOrder','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-07-02 16:55:04','','1','0','1719914640000'),
('2','获取一天前申请提现还未成功的提现申请,将提现冻结金额回退(通联环境)','2024-07-09 15:14:57','2024-07-09 15:15:29','admin','','CRON','0 0/5 * * * ?','DO_NOTHING','FIRST','returnAmountByTimeOut','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-07-09 15:14:57','','0','0','0');

ALTER TABLE `tz_prod`
DROP COLUMN is_refund;