子订单添加商品折扣信息.sql
3.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
# 在子订单添加折后商品金额
alter table im_doing_order1_00 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_01 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_02 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_03 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_04 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_05 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_06 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_07 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_08 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_09 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_10 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_11 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_12 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_13 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_14 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
alter table im_doing_order1_15 modify discount_price decimal(16,6) DEFAULT NULL COMMENT '折后商品单价';
# 在子订单添加折后行金额
alter table im_doing_order1_00 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_01 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_02 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_03 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_04 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_05 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_06 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_07 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_08 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_09 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_10 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_11 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_12 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_13 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_14 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';
alter table im_doing_order1_15 modify discount_line_price decimal(10,2) DEFAULT NULL COMMENT '折后行金额';