ALTER TABLE `crmeb`.`bcx_performance_report`
    ADD COLUMN `order_region_code` varchar(10) NULL COMMENT '订单区域' AFTER `order_no`;

UPDATE `crmeb`.bcx_performance_report SET order_region_code = brokerage_config_snapshot->>'$.order.regionCode' WHERE brokerage_config_snapshot is not null;

ALTER TABLE `crmeb`.`bcx_product_benefits`
    ADD COLUMN `auth_start_time` datetime NULL DEFAULT NULL COMMENT '分销商授权开始时间' AFTER `company_name`,
ADD COLUMN `auth_end_time` datetime NULL DEFAULT NULL COMMENT '分销商授权结束时间' AFTER `auth_start_time`;