派生自 HangZhouMes
hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql
@@ -1,11 +1,11 @@ --liquibase formatted sql -- 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'; -- 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 BIGINT AUTO_INCREMENT PRIMARY KEY, 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, @@ -13,14 +13,14 @@ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, deleted char(1) DEFAULT 0 ); --rollback DROP TABLE sys_dict_type; -- 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'; -- 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 BIGINT AUTO_INCREMENT PRIMARY KEY, dict_id INT AUTO_INCREMENT PRIMARY KEY, dict_sort INT NOT NULL, dict_label VARCHAR(32) NOT NULL, dict_value VARCHAR(32) NOT NULL, @@ -31,12 +31,12 @@ create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, deleted char(1) DEFAULT 0 ); --rollback DROP TABLE sys_dict_data; -- 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'); -- 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) @@ -49,11 +49,11 @@ 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'); -- 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 ('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) @@ -150,7 +150,106 @@ 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 ('clearGlass', 'silver', 'doubleSilver', 'thirdSilver', 'ultraClear', 'heatReflect'); -- rollback DELETE FROM sys_dict_data WHERE dict_type in ('白玻', '单银', '双银'); -- changeset zsh: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 DEFAULT NULL COMMENT '设备id', slot int DEFAULT NULL COMMENT '格子id', pattern_width double(8, 2) DEFAULT NULL COMMENT '原片宽', pattern_height double(8, 2) DEFAULT NULL COMMENT '原片高', pattern_thickness double(8, 2) DEFAULT NULL COMMENT '原片厚度', films_id varchar(64) DEFAULT NULL COMMENT '膜系', create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', remain_quantity int DEFAULT NULL COMMENT '剩余数量', state int DEFAULT NULL COMMENT '状态', shelf int DEFAULT NULL COMMENT '架子号', PRIMARY KEY (id) USING BTREE ); -- rollback DROP TABLE raw_glass_storage_details; -- changeset zsh: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, device_id int DEFAULT NULL COMMENT '设备id', slot int DEFAULT NULL COMMENT '栅格号', enable_state int DEFAULT NULL COMMENT '启用标记', shelf int DEFAULT NULL COMMENT '架子号' ); -- rollback DROP TABLE raw_glass_storage_station; -- changeset zsh: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, start_slot int DEFAULT NULL COMMENT '起始格子', end_slot int DEFAULT NULL COMMENT '目标格子', pattern_quantity int DEFAULT NULL COMMENT '原片数量', task_type int DEFAULT NULL COMMENT '任务类型', task_state int DEFAULT NULL COMMENT '任务状态', shelf int DEFAULT NULL COMMENT '架子号', create_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', update_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (id) USING BTREE ); -- rollback DROP TABLE raw_glass_storage_task; -- changeset zsh:20241015001 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 SELECT count(0) FROM information_schema.columns WHERE table_schema = 'hangzhoumes' AND table_name = 'engineering' AND column_name = 'station_cell'; ALTER TABLE engineering ADD COLUMN station_cell int; -- changeset zsh:20241017001 -- preconditions onFail:CONTINUE onError:CONTINUE -- precondition-sql-check expectedResult:0 select count(1) from raw_glass_storage_station; INSERT INTO raw_glass_storage_station (id, device_id, slot, enable_state, shelf) VALUES (1, 1, 1, 1, 1), (2, 1, 2, 1, 2), (3, 1, 3, 1, 3), (4, 2, 4, 1, 4), (5, 2, 5, 1, 5), (6, 2, 6, 1, 6), (7, 2, 7, 1, 7), (8, 2, 8, 1, 8), (9, 2, 9, 1, 9), (10, 2, 10, 1, 10), (11, 2, 11, 1, 11), (12, 3, 12, 1, 12), (13, 3, 13, 1, 13), (14, 3, 14, 1, 14), (15, 3, 15, 1, 15), (16, 3, 16, 1, 16), (17, 3, 17, 1, 17), (18, 3, 18, 1, 18), (19, 3, 19, 1, 19), (20, 3, 20, 1, 20), (21, 3, 21, 1, 21), (22, 3, 22, 1, 22), (23, 3, 23, 1, 23), (24, 3, 24, 1, 24), (25, 3, 25, 1, 25), (26, 4, 98, 1, NULL), (27, 4, 99, 1, NULL), (28, 5, 101, 1, NULL), (29, 5, 102, 1, NULL), (30, 6, 103, 1, NULL), (31, 6, 104, 1, NULL);
