USE yami_bbc;
ALTER TABLE `tz_warehouse`
    ADD COLUMN `status` TINYINT(4)  NULL DEFAULT 1 COMMENT  '状态 -1.删除 1.正常';

#优化店铺分类关联表的索引为唯一索引

ALTER TABLE tz_category_shop DROP INDEX idx_shop_category_id;
ALTER TABLE tz_category_shop ADD UNIQUE `idx_shop_category_id` (`shop_id`, `category_id`);

# 34是极兔速递
UPDATE `tz_delivery`
SET
    ali_no = 'JITU'
WHERE
    dvy_id = 34;

# 移除敏感词配置，谨慎操作
delete from tz_sys_config where `param_key` = 'SENSITIVE_WORDS';


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-02-23 16:27:12','2024-02-23 16:27:12','admin','','CRON','0 0/1 * * * ?','DO_NOTHING','FIRST','handleDeliveryTimeOutOrder','','SERIAL_EXECUTION','0','0','BEAN','','GLUE代码初始化','2024-02-23 16:27:12','','1','0','0');
