USE yami_bbc;

#移除无用的配置项
UPDATE  `tz_sys_config` SET param_value = '{\"distributionSwitch\":0,\"autoCheck\":0,\"realName\":true,\"identityCardPic\":false,\"identityCardNumber\":true,\"withdrawal\":1,\"frequency\":30,\"amountMax\":300,\"amountMin\":1,\"paymentExplain\":\"预计处理需要1-5个工作日\",\"number\":2}'
WHERE param_key = 'DISTRIBUTION_CONFIG';


# 添加定时任务
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','恢复悟空im的频道, 执行任务后要清除token，让用户全部下线','2024-06-05 15:35:46','2024-06-05 15:35:46','admin','','CRON','0 0 0 1 1 ?','DO_NOTHING','FIRST','restoreChannelData','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-06-05 15:35:46','','0','0','0');

USE yami_bbc;
# 修改售后评价的删除按钮为不隐藏,其中74为售后评价的删除按钮菜单
update `tz_shop_menu` set hidden = 0 where menu_id = 74;

# ！！！短信改造，执行前需要将原来的短信配置添加到yml文件中，再执行sql
delete from tz_sys_config where param_key = 'SMS_CONFIG';

# 添加初始化库存预警定时任务，执行一次后删除
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-06-11 11:35:46','2024-06-11 11:35:46','admin','','CRON','0 * * * * ?','DO_NOTHING','FIRST','intiStockWrningStatus','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-06-11 11:35:46','','0','0','0');