订单子表添加sku.sql
8.9 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
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
alter table im_doing_order1_00 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_01 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_02 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_03 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_04 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_05 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_06 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_07 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_08 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_09 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_10 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_11 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_12 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_13 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_14 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_15 add sku_id varchar(36) DEFAULT NULL comment '产品sku';
alter table im_doing_order1_00 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_01 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_02 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_03 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_04 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_05 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_06 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_07 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_08 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_09 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_10 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_11 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_12 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_13 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_14 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_15 add erp_code varchar(32) DEFAULT NULL comment '产品ERP-CODE';
alter table im_doing_order1_00 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_01 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_02 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_03 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_04 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_05 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_06 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_07 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_08 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_09 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_10 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_11 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_12 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_13 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_14 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_15 add spec_detail varchar(256) DEFAULT NULL comment '产品规格说明';
alter table im_doing_order1_00 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_01 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_02 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_03 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_04 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_05 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_06 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_07 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_08 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_09 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_10 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_11 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_12 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_13 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_14 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_15 add name varchar(256) DEFAULT NULL comment '产品名称';
alter table im_doing_order1_00 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_01 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_02 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_03 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_04 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_05 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_06 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_07 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_08 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_09 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_10 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_11 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_12 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_13 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_14 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_15 add thumb_img varchar(256) DEFAULT NULL comment '产品缩列图';
alter table im_doing_order1_00 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_01 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_02 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_03 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_04 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_05 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_06 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_07 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_08 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_09 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_10 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_11 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_12 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_13 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_14 add market_price decimal(19,2) DEFAULT NULL comment '市场价';
alter table im_doing_order1_15 add market_price decimal(19,2) DEFAULT NULL comment '市场价';