From 7c8319c6b45850a47b4beaabd9442a02465aabcc Mon Sep 17 00:00:00 2001 From: zhoushihao <zsh19950802@163.com> Date: 星期日, 20 十月 2024 21:06:50 +0800 Subject: [PATCH] 现场确认录入原片仓储工位基础数据 --- hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql | 66 +++++++++++++++++++++++++++++++++ 1 files changed, 66 insertions(+), 0 deletions(-) diff --git a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql index 5473f61..b4ea6a1 100644 --- a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql +++ b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql @@ -209,5 +209,71 @@ 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