| 1234567891011121314151617181920212223 |
- 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');
|
