From 9152c5394d4fd9d14d1a5fb9de9d441450b2bac6 Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期三, 20 十一月 2024 08:41:13 +0800
Subject: [PATCH] 1、卧理进出片订阅功能直接按订阅结果判断，订阅后查询数据库，可能造成数据重复读，任务重复执行问题 2、大理片笼新增任务表、任务历史表脚本 3、大理片笼进片任务功能开发已完成50%
---
hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql | 79 +++++++++++++++++++++++++++++++++++++++
1 files changed, 78 insertions(+), 1 deletions(-)
diff --git a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql
index a67b7f8..03146ea 100644
--- a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql
+++ b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql
@@ -170,4 +170,81 @@
damage_count int DEFAULT '0' COMMENT '鐮存崯鏁伴噺',
PRIMARY KEY (id) USING BTREE
);
--- rollback DROP TABLE load_glass_device_task_history;
\ No newline at end of file
+-- rollback DROP TABLE load_glass_device_task_history;
+
+-- changeset zsh:20241112001
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_in_history_task' and table_schema = 'hangzhoumes';
+CREATE TABLE big_storage_cage_in_history_task
+(
+ id BIGINT NOT NULL AUTO_INCREMENT COMMENT '鍘嗗彶浠诲姟id',
+ task_running INT DEFAULT '0' COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1鍚姩浠诲姟 2 纭瀹屾垚',
+ glass_id VARCHAR(32) COMMENT '鐜荤拑id',
+ start_slot INT DEFAULT '0' COMMENT '璧峰鏍煎瓙',
+ target_slot INT DEFAULT '0' COMMENT '鐩爣鏍煎瓙',
+ task_state INT DEFAULT NULL COMMENT '浠诲姟鐘舵�� ',
+ create_time TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ task_type TIMESTAMP NULL 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 big_storage_cage_in_history_task;
+
+-- changeset zsh:20241112002
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_in_one_task' and table_schema = 'hangzhoumes';
+CREATE TABLE big_storage_cage_in_one_task
+(
+ task_running INT DEFAULT '0' COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1鍚姩浠诲姟 2 纭瀹屾垚',
+ glass_id VARCHAR(32) COMMENT '鐜荤拑id',
+ start_slot INT DEFAULT '0' COMMENT '璧峰鏍煎瓙',
+ target_slot INT DEFAULT '0' COMMENT '鐩爣鏍煎瓙',
+ task_state INT DEFAULT NULL COMMENT '浠诲姟鐘舵�� '
+);
+-- rollback DROP TABLE big_storage_cage_in_one_task;
+
+-- changeset zsh:20241112003
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM big_storage_cage_in_one_task;
+INSERT INTO big_storage_cage_in_one_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_one_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_one_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_one_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_one_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_one_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+
+
+-- changeset zsh:20241112004
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'big_storage_cage_in_two_task' and table_schema = 'hangzhoumes';
+CREATE TABLE big_storage_cage_in_two_task
+(
+ task_running INT DEFAULT '0' COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1鍚姩浠诲姟 2 纭瀹屾垚',
+ glass_id VARCHAR(32) COMMENT '鐜荤拑id',
+ start_slot INT DEFAULT '0' COMMENT '璧峰鏍煎瓙',
+ target_slot INT DEFAULT '0' COMMENT '鐩爣鏍煎瓙',
+ task_state INT DEFAULT NULL COMMENT '浠诲姟鐘舵�� '
+);
+-- rollback DROP TABLE big_storage_cage_in_two_task;
+-- changeset zsh:20241112005
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM big_storage_cage_in_two_task;
+INSERT INTO big_storage_cage_in_two_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_two_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_two_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_two_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_two_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+INSERT INTO big_storage_cage_in_two_task(task_running, glass_id, start_slot, target_slot, task_state)
+VALUES (0, NULL, 0, 0, 0);
+
--
Gitblit v1.8.0