2022-11-08_update.sql

alter table `ecw_offer_prod` add column `liquid_clearance_fee_price` decimal(15,2) DEFAULT '0.00' COMMENT '液体清关费单价';
alter table `ecw_offer_prod` add column `liquid_freight_price` decimal(15,2) DEFAULT '0.00' COMMENT '液体运费单价';
alter table `ecw_offer_prod` add column `electrified_clearance_fee_price` decimal(15,2) DEFAULT '0.00' COMMENT '带电清关费单价';
alter table `ecw_offer_prod` add column `electrified_freight_price` decimal(15,2) DEFAULT '0.00' COMMENT '带电运费单价';
alter table `ecw_offer_prod` add column `brand_clearance_fee_price` decimal(15,2) DEFAULT '0.00' COMMENT '品牌清关费单价';
alter table `ecw_offer_prod` add column `brand_freight_price` decimal(15,2) DEFAULT '0.00' COMMENT '品牌运费单价';
alter table `ecw_offer_prod` add column `discount_clearance_fee_price` decimal(15,2) DEFAULT '0.00' COMMENT '清关费单价优惠金额';
alter table `ecw_offer_prod` add column `discount_clearance_fee_total_price` decimal(15,2) DEFAULT '0.00' COMMENT '清关费单价优惠总金额';
alter table `ecw_offer_prod` add column `discount_freight_price` decimal(15,2) DEFAULT '0.00' COMMENT '运费单价优惠金额';
alter table `ecw_offer_prod` add column `discount_freight_total_price` decimal(15,2) DEFAULT '0.00' COMMENT '运费单价优惠总金额';


alter table `ecw_offer_prod` add column `coupon_info` json DEFAULT NULL COMMENT '使用的优惠信息';
alter table `ecw_order_item` add column `coupon_info` json DEFAULT NULL COMMENT '使用的优惠信息';