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
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
| -- liquibase formatted sql
|
| -- changeset zsh:20240904001
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_dict_type' and table_schema = 'hangzhoumes';
| CREATE TABLE sys_dict_type
| (
| dict_id INT AUTO_INCREMENT PRIMARY KEY,
| dict_name VARCHAR(32) NOT NULL,
| dict_type VARCHAR(32) NOT NULL,
| state CHAR(1) NOT NULL DEFAULT TRUE,
| description VARCHAR(32),
| create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
| deleted char(1) DEFAULT 0
| );
| -- rollback DROP TABLE sys_dict_type;
|
| -- changeset zsh:20240904002
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'sys_dict_data' and table_schema = 'hangzhoumes';
| CREATE TABLE sys_dict_data
| (
| dict_id INT AUTO_INCREMENT PRIMARY KEY,
| dict_sort INT NOT NULL,
| dict_label VARCHAR(32) NOT NULL,
| dict_value VARCHAR(32) NOT NULL,
| dict_type VARCHAR(32) NOT NULL,
| dict_type_value varchar(32),
| state CHAR(1) NOT NULL DEFAULT TRUE,
| description VARCHAR(32),
| create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
| deleted char(1) DEFAULT 0
| );
| -- rollback DROP TABLE sys_dict_data;
|
|
| -- changeset zsh:20240904003
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_dict_type WHERE dict_type in ('clearGlass', 'silver', 'doubleSilver', 'thirdSilver', 'ultraClear', 'heatReflect');
| INSERT INTO sys_dict_type (dict_name, dict_type, state, description, deleted)
| VALUES ('白玻', 'clearGlass', '1', '0', '0');
| INSERT INTO sys_dict_type (dict_name, dict_type, state, description, deleted)
| VALUES ('单银', 'silver', '1', '1', '0');
| INSERT INTO sys_dict_type (dict_name, dict_type, state, description, deleted)
| VALUES ('双银', 'doubleSilver', '1', '2', '0');
| INSERT INTO sys_dict_type (dict_name, dict_type, state, description, deleted)
| VALUES ('三银', 'thirdSilver', '1', '3', '0');
| INSERT INTO sys_dict_type (dict_name, dict_type, state, description, deleted)
| VALUES ('超白', 'ultraClear', '1', '4', '0');
| INSERT INTO sys_dict_type (dict_name, dict_type, state, description, deleted)
| VALUES ('热反射', 'heatReflect', '1', '5', '0');
| -- rollback DELETE FROM sys_dict_type WHERE dict_type in ('clearGlass', 'silver', 'doubleSilver', 'thirdSilver', 'ultraClear', 'heatReflect');
|
| -- changeset zsh:20240904004
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM sys_dict_data WHERE dict_type in ('白玻', '单银', '双银');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (1, '白玻', 'clearGlass', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (2, '超白', 'ultraClear', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (3, '来料白玻', 'incomingClearGlass', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (4, '欧州茶', 'europeTeaColor', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (5, '水晶灰', 'cristalGrey', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (6, '灰玻', 'grayGlass', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (7, '灰镀膜', 'grayCoating', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (8, '磨砂', 'frosted', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (9, '福特蓝', 'fordBlue', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (10, '福特蓝镀膜', 'fordBlueCoating', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (11, '蓝星灰', 'blueAstralGrey', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (12, '蓝玻', 'blueGlass', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (13, '超白长虹', 'ultraClearChanghong', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (14, '金晶灰', 'jinjinGrey', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (15, '金晶灰茶', 'jinjinTeaGrey', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (16, '镀膜', 'coatingFilm', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (17, '长虹', 'clearGlassChanghong', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (18, '阳光膜', 'solorControl', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (19, '高反底透', 'arGlass', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (20, '高白', 'arClear', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (21, '黑玻', 'blackGlass', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (22, '玉砂', 'emery', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (23, '超白磨砂', 'ultraClearFrosted', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (24, '金茶玻', 'goldenTea', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (25, '蓝灰镀膜', 'blueGraycoatingFilm', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (26, '单项透视', 'onePoint', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (27, '超白镀膜', 'ultraClearCoatingFilm', '白玻', '0', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (1, 'F绿', 'fGreen', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (2, 'F绿lowe', 'fGreenLowe', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (3, 'F绿镀膜', 'fGreenCoating', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (4, 'Low-e', 'lowe', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (5, 'super52', 'super52', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (6, '中玻在线', 'zgOnlineGlass', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (7, '北玻60离线lowe', 'ng60OfflineLowe', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (8, '南玻在线lowe', 'csgOnlineLowe', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (9, '台玻81A', 'tg81a', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (10, '台玻lowe70', 'tgLowe70', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (11, '台玻LOWE78', 'tgLowe78', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (12, '河北金瑞lowe80', 'hbJinruiLowe80', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (13, '福特蓝lowe', 'fordBlueLowe', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (14, '福莱特FXB60', 'flatFxb60', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (15, '福莱特lowe60', 'flatLowe60', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (16, '福莱特lowe70', 'flatLowe70', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (17, '福莱特lowe80', 'flatLowe80', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (18, '耀皮在线LOWE', 'sypOnlineLowe', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (19, '超白Lowe', 'ultraClearLowe', '单银', '1', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (1, '双银lowe', 'doubleSilverLowe', '双银', '2', '1', '1', '0');
| INSERT INTO sys_dict_data(dict_sort, dict_label, dict_value, dict_type, dict_type_value, state, description, deleted)
| VALUES (2, '超白双银Lowe', 'ultraDoubleSilverLowe', '双银', '2', '1', '1', '0');
| -- rollback DELETE FROM sys_dict_data WHERE dict_type in ('白玻', '单银', '双银');
|
|
| -- changeset wangfei:20240918001
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_details' and table_schema = 'hangzhoumes';
| CREATE TABLE raw_glass_storage_details
| (
| id bigint NOT NULL AUTO_INCREMENT,
| device_id int NULL DEFAULT NULL COMMENT '设备id',
| slot_id varchar(255) NULL DEFAULT NULL COMMENT '格子id',
| pattern_width double(8, 2) NULL DEFAULT NULL COMMENT '原片宽',
| pattern_height double(8, 2) NULL DEFAULT NULL COMMENT '原片高',
| pattern_thickness double(8, 2) NULL DEFAULT NULL COMMENT '原片厚度',
| films_id varchar(255) NULL DEFAULT NULL COMMENT '膜系',
| create_time datetime NOT NULL COMMENT '创建时间',
| remain_quantity varchar(255) NULL DEFAULT NULL COMMENT '剩余数量',
| PRIMARY KEY (id) USING BTREE
| );
| -- rollback DROP TABLE raw_glass_storage_details;
|
| -- changeset wangfei:20240918002
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_station' and table_schema = 'hangzhoumes';
| CREATE TABLE raw_glass_storage_station
| (
| id bigint NOT NULL AUTO_INCREMENT,
| device_id int NULL DEFAULT NULL COMMENT '设备id',
| slot int NULL DEFAULT NULL COMMENT '栅格号',
| enable_state varchar(255) NULL DEFAULT NULL COMMENT '启用标记',
| start_slot int NULL DEFAULT NULL COMMENT '开始工位',
| end_slot int NULL DEFAULT NULL COMMENT '目标工位',
| PRIMARY KEY (id) USING BTREE
| );
| -- rollback DROP TABLE raw_glass_storage_station;
|
|
| -- changeset wangfei:20240918003
| -- preconditions onFail:CONTINUE onError:CONTINUE
| -- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_task' and table_schema = 'hangzhoumes';
| CREATE TABLE raw_glass_storage_task
| (
| id bigint NOT NULL AUTO_INCREMENT,
| enable_id int NULL DEFAULT NULL COMMENT '任务ID',
| originate_slot int NULL DEFAULT NULL COMMENT '起始格子',
| end_slot int NULL DEFAULT NULL COMMENT '目标格子',
| pattern_quantity varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原片数量',
| enable_type int NULL DEFAULT NULL COMMENT '任务类型',
| enable_state int NULL DEFAULT NULL COMMENT '任务状态',
| create_time datetime NULL DEFAULT NULL COMMENT '创建时间',
| PRIMARY KEY (id) USING BTREE
| );
| -- rollback DROP TABLE raw_glass_storage_task;
|
|
