From e90ee8c152c553b22b651481675ca78308a148fa Mon Sep 17 00:00:00 2001
From: zhoushihao <zsh19950802@163.com>
Date: 星期四, 07 十一月 2024 11:02:08 +0800
Subject: [PATCH] 1、liquibase新增磨边任务表、磨边任务历史表、磨边对列表 上片任务表、上片历史任务表
---
hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql | 172 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++
hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelogBase.xml | 1
2 files changed, 173 insertions(+), 0 deletions(-)
diff --git a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelogBase.xml b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelogBase.xml
index a98a47b..8414061 100644
--- a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelogBase.xml
+++ b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelogBase.xml
@@ -6,6 +6,7 @@
<!-- 寮曞叆绗竴涓猄QL閰嶇疆鏂囦欢 -->
<include file="./changelog/changelog.sql" relativeToChangelogFile="false"/>
+ <include file="./changelog/ywChangelog.sql" relativeToChangelogFile="false"/>
<!-- 鏇村鐨刬nclude鏍囩... -->
diff --git a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql
new file mode 100644
index 0000000..5892857
--- /dev/null
+++ b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/ywChangelog.sql
@@ -0,0 +1,172 @@
+-- liquibase formatted sql
+
+-- changeset zsh:20241107001
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_one_task' and table_schema = 'hangzhoumes';
+CREATE TABLE edg_storage_device_one_task
+(
+ task_running int DEFAULT NULL COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1杩涚墖 2鍑虹墖 3鐩撮��',
+ glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id',
+ glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id',
+ glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d',
+ current_cell int DEFAULT '0' COMMENT '褰撳墠灞傚彿',
+ start_cell int DEFAULT '0' COMMENT '灞傚彿',
+ end_cell int DEFAULT NULL COMMENT '棰勭暀灞傚彿',
+ task_state int DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟',
+ task_type int DEFAULT NULL COMMENT '浠诲姟绫诲瀷',
+ create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ width int DEFAULT NULL COMMENT '瀹�',
+ height int DEFAULT NULL COMMENT '楂�',
+ thickness int DEFAULT NULL COMMENT '鍘�',
+ film_remove int DEFAULT NULL COMMENT '鏄惁闄よ啘'
+);
+-- rollback DROP TABLE edg_storage_device_one_task;
+
+
+-- changeset zsh:20241107002
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM edg_storage_device_one_task;
+INSERT INTO edg_storage_device_one_task (task_running, glass_id, glass_id_in, glass_id_out, current_cell, start_cell,
+ end_cell, task_state, task_type, width, height, thickness, film_remove)
+VALUES (0, NULL, NULL, NULL, 1, 0, NULL, 0, NULL, 0, 0, 0, 0);
+
+
+-- changeset zsh:20241107003
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_two_task' and table_schema = 'hangzhoumes';
+CREATE TABLE edg_storage_device_two_task
+(
+ task_running int DEFAULT NULL COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1杩涚墖 2鍑虹墖 3鐩撮��',
+ glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id',
+ glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id',
+ glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d',
+ current_cell int DEFAULT '0' COMMENT '褰撳墠灞傚彿',
+ start_cell int DEFAULT '0' COMMENT '灞傚彿',
+ end_cell int DEFAULT NULL COMMENT '棰勭暀灞傚彿',
+ task_state int DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟',
+ task_type int DEFAULT NULL COMMENT '浠诲姟绫诲瀷',
+ create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ width int DEFAULT NULL COMMENT '瀹�',
+ height int DEFAULT NULL COMMENT '楂�',
+ thickness int DEFAULT NULL COMMENT '鍘�',
+ film_remove int DEFAULT NULL COMMENT '鏄惁闄よ啘'
+);
+-- rollback DROP TABLE edg_storage_device_two_task;
+
+-- changeset zsh:20241107004
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM edg_storage_device_two_task;
+INSERT INTO edg_storage_device_two_task (task_running, glass_id, glass_id_in, glass_id_out, current_cell, start_cell,
+ end_cell, task_state, task_type, width, height, thickness, film_remove)
+VALUES (0, NULL, NULL, NULL, 1, 0, NULL, 0, NULL, 0, 0, 0, 0);
+
+
+
+-- changeset zsh:20241107005
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_storage_device_task_history' and table_schema = 'hangzhoumes';
+CREATE TABLE edg_storage_device_task_history
+(
+ id bigint NOT NULL AUTO_INCREMENT COMMENT '宸ョ▼琛╥d',
+ glass_id_in varchar(20) DEFAULT NULL COMMENT '杩涚墖鐜荤拑id',
+ glass_id_out varchar(20) DEFAULT NULL COMMENT '鍑虹墖鐜荤拑id',
+ current_cell int DEFAULT '0' COMMENT '褰撳墠灞傚彿',
+ start_cell int DEFAULT '0' COMMENT '灞傚彿',
+ end_cell int DEFAULT NULL COMMENT '棰勭暀灞傚彿',
+ task_state int DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟',
+ task_type int DEFAULT NULL COMMENT '浠诲姟绫诲瀷',
+ create_time 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 edg_storage_device_task_history;
+
+-- changeset zsh:20241107006
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'edg_glass_task_queue_info' and table_schema = 'hangzhoumes';
+CREATE TABLE edg_glass_task_queue_info
+(
+ glass_id varchar(20) DEFAULT NULL COMMENT '纾ㄨ竟鍓嶇幓鐠僫d',
+ width int DEFAULT NULL COMMENT '瀹�',
+ height int DEFAULT NULL COMMENT '楂�',
+ thickness int DEFAULT NULL COMMENT '鍘�',
+ state int DEFAULT NULL COMMENT '鐘舵��',
+ line int DEFAULT NULL COMMENT '绾胯矾',
+ create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿'
+);
+-- rollback DROP TABLE edg_glass_task_queue_info;
+
+-- changeset zsh:20241107007
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_one_task' and table_schema = 'hangzhoumes';
+CREATE TABLE load_glass_device_one_task
+(
+ task_running int DEFAULT '0' COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖',
+ raw_glass_width int DEFAULT '0' COMMENT '鍘熺墖瀹�',
+ raw_glass_height int DEFAULT '0' COMMENT '鍘熺墖楂�',
+ slot int DEFAULT '0' COMMENT '涓婄墖浣嶇紪鍙�',
+ task_state int DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟',
+ create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ total_count int DEFAULT '0' COMMENT '涓婄墖鎬绘暟閲�',
+ finish_count int DEFAULT '0' COMMENT '宸插畬鎴愭暟閲�',
+ damage_count int DEFAULT '0' COMMENT '鐮存崯鏁伴噺'
+);
+-- rollback DROP TABLE load_glass_device_one_task;
+
+-- changeset zsh:20241107008
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM load_glass_device_one_task;
+INSERT INTO load_glass_device_one_task (task_running, raw_glass_width, raw_glass_height, slot, task_state, total_count,
+ finish_count, damage_count)
+VALUES (0, 0, 0, 0, 0, 0, 0, 0);
+
+-- changeset zsh:20241107009
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_two_task' and table_schema = 'hangzhoumes';
+CREATE TABLE load_glass_device_two_task
+(
+ task_running int DEFAULT '0' COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖',
+ raw_glass_width int DEFAULT '0' COMMENT '鍘熺墖瀹�',
+ raw_glass_height int DEFAULT '0' COMMENT '鍘熺墖楂�',
+ slot int DEFAULT '0' COMMENT '涓婄墖浣嶇紪鍙�',
+ task_state int DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟',
+ create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ total_count int DEFAULT '0' COMMENT '涓婄墖鎬绘暟閲�',
+ finish_count int DEFAULT '0' COMMENT '宸插畬鎴愭暟閲�',
+ damage_count int DEFAULT '0' COMMENT '鐮存崯鏁伴噺'
+);
+-- rollback DROP TABLE load_glass_device_two_task;
+
+-- changeset zsh:20241107010
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM load_glass_device_two_task;
+INSERT INTO load_glass_device_two_task (task_running, raw_glass_width, raw_glass_height, slot, task_state, total_count,
+ finish_count, damage_count)
+VALUES (0, 0, 0, 0, 0, 0, 0, 0);
+
+
+-- changeset zsh:20241107011
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'load_glass_device_task_history' and table_schema = 'hangzhoumes';
+CREATE TABLE load_glass_device_task_history
+(
+ id bigint NOT NULL AUTO_INCREMENT COMMENT '鍘嗗彶浠诲姟id',
+ task_running int DEFAULT '0' COMMENT '浠诲姟璇锋眰 0鏃犱换鍔� 1涓婄墖',
+ raw_glass_width int DEFAULT '0' COMMENT '鍘熺墖瀹�',
+ raw_glass_height int DEFAULT '0' COMMENT '鍘熺墖楂�',
+ station int DEFAULT '0' COMMENT '涓婄墖璁惧缂栧彿',
+ slot int DEFAULT '0' COMMENT '涓婄墖浣嶇紪鍙�',
+ task_state int DEFAULT NULL COMMENT '浠诲姟鐘舵�� 0榛樿绌轰换鍔� 1鎵ц涓� 2缁撴潫浠诲姟',
+ create_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+ update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
+ total_count int DEFAULT '0' COMMENT '涓婄墖鎬绘暟閲�',
+ finish_count int DEFAULT '0' COMMENT '宸插畬鎴愭暟閲�',
+ 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
--
Gitblit v1.8.0