From 8785b6b5ee9298308752b53bf546953ae49b8c88 Mon Sep 17 00:00:00 2001
From: wangfei <3597712270@qq.com>
Date: 星期一, 21 十月 2024 09:56:05 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'
---
hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql | 127 +++++++++++++++++++++++++++++++++++++++++
1 files changed, 125 insertions(+), 2 deletions(-)
diff --git a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql
index a0545c6..3c2df0c 100644
--- a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql
+++ b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql
@@ -2,7 +2,7 @@
-- 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';
+-- 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,
@@ -17,7 +17,7 @@
-- 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';
+-- 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,
@@ -153,4 +153,127 @@
-- 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 NULL DEFAULT NULL COMMENT '璁惧id',
+ slot int 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(64) NULL DEFAULT NULL COMMENT '鑶滅郴',
+ create_time datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ remain_quantity int NULL DEFAULT NULL COMMENT '鍓╀綑鏁伴噺',
+ state int NULL 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 AUTO_INCREMENT,
+ device_id int NULL DEFAULT NULL COMMENT '璁惧id',
+ slot int NULL DEFAULT NULL COMMENT '鏍呮牸鍙�',
+ enable_state varchar(255) NULL DEFAULT NULL COMMENT '鍚敤鏍囪',
+ PRIMARY KEY (id)
+);
+-- 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 NULL DEFAULT NULL COMMENT '璧峰鏍煎瓙',
+ end_slot int NULL DEFAULT NULL COMMENT '鐩爣鏍煎瓙',
+ pattern_quantity int NULL DEFAULT NULL COMMENT '鍘熺墖鏁伴噺',
+ task_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;
+
+
+-- 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 varchar(20);
+
+-- 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 (slot, device_id, enable_state)
+VALUES (1, 1, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (2, 1, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (3, 1, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (4, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (5, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (6, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (7, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (8, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (9, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (10, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (11, 2, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (12, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (13, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (14, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (15, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (16, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (17, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (18, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (19, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (20, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (21, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (22, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (23, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (24, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (25, 3, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (98, 4, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (99, 4, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (101, 5, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (102, 5, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (103, 6, '1');
+INSERT INTO raw_glass_storage_station (slot, device_id, enable_state)
+VALUES (104, 6, '1');
+
+
--
Gitblit v1.8.0