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
| -- 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';
| 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';
| 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 ('白玻', '单银', '双银');
|
|
