子订单添加抵扣V币.sql 3.0 KB

# 在子订单添加折后商品金额
alter table im_doing_order1_00 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_01 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_02 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_03 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_04 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_05 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_06 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_07 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_08 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_09 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_10 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_11 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_12 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_13 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_14 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';
alter table im_doing_order1_15 ADD  deduction_product_vb int DEFAULT NULL COMMENT '抵扣V币';


alter table im_doing_order1_00 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_01 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_02 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_03 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_04 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_05 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_06 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_07 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_08 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_09 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_10 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_11 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_12 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_13 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_14 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';
alter table im_doing_order1_15 ADD  deduction_line_vb int DEFAULT NULL COMMENT '抵扣行V币';