java-bbc/db/2025-04-08 补充菜单语言.sql

USE `yami_bbc`;

insert into `tz_sys_menu_lang` (`menu_id`, `lang`, `name`) values
(732,0,'获取最大序列号'),
(732,1,'Obtain the maximum serial number'),
(1047,0, '获取会员分析数据'),
(1047,1, 'Get Member Analysis Data'),
(1048,0, '获取报表项列表'),
(1048,1, 'Get report item list'),
(1049,0, '分页获取推荐报表'),
(1049,1, 'Paging to get recommended reports'),
(1200,0,'获取商品效果分析数据'),
(1200,1, 'Obtain Product Effect Analysis Data'),
(1201,0,'设置提现金额'),
(1201,1, 'Set withdrawal amount');

-- 评论表门店id补充默认值
ALTER TABLE `tz_prod_comm`
MODIFY COLUMN `station_id` bigint(0) NULL DEFAULT 0 COMMENT '门店id' AFTER `shop_id`;


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','执行通联订单的平台转账','2025-04-01 11:12:18','2025-04-01 11:12:18','admin','','CRON','0 0 1 * * ?','DO_NOTHING','FIRST','doAllinpayPlatformTransfer','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2025-04-01 11:12:18','','0','0','0');