From 34a5775085f5db40dfc80250e5185f5485eecfc2 Mon Sep 17 00:00:00 2001
From: ZengTao <2773468879@qq.com>
Date: 星期五, 20 九月 2024 13:01:18 +0800
Subject: [PATCH] Merge branch 'master' of http://bore.pub:10439/r/HangZhouMes
---
hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql | 92 ++++++++++++++++++++++++++++++++++++---------
1 files changed, 73 insertions(+), 19 deletions(-)
diff --git a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql b/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql
index 68e1a70..64764d3 100644
--- a/hangzhoumesParent/moduleService/TemperingGlassModule/src/main/resources/changelog/changelog.sql
+++ b/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';
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';
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,61 @@
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 wangfei:20240918001
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_details';
+CREATE TABLE raw_glass_storage_details
+(
+ id bigint NOT NULL AUTO_INCREMENT,
+ device_id int NULL DEFAULT NULL COMMENT '璁惧id',
+ slot_id varchar(255) 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(255) NULL DEFAULT NULL COMMENT '鑶滅郴',
+ create_time datetime NOT NULL COMMENT '鍒涘缓鏃堕棿',
+ remain_quantity varchar(255) NULL DEFAULT NULL COMMENT '鍓╀綑鏁伴噺',
+ PRIMARY KEY (id) USING BTREE
+);
+-- rollback DROP TABLE raw_glass_storage_details;
+
+
+-- changeset wangfei:20240918002
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_station';
+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 '鍚敤鏍囪',
+ start_slot int NULL DEFAULT NULL COMMENT '寮�濮嬪伐浣�',
+ end_slot int NULL DEFAULT NULL COMMENT '鐩爣宸ヤ綅',
+ PRIMARY KEY (id) USING BTREE
+);
+-- rollback DROP TABLE raw_glass_storage_station;
+
+
+-- changeset wangfei:20240918003
+-- preconditions onFail:CONTINUE onError:CONTINUE
+-- precondition-sql-check expectedResult:0 SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'raw_glass_storage_task';
+CREATE TABLE raw_glass_storage_task
+(
+ id bigint NOT NULL AUTO_INCREMENT,
+ enable_id int NULL DEFAULT NULL COMMENT '浠诲姟ID',
+ originate_slot int NULL DEFAULT NULL COMMENT '璧峰鏍煎瓙',
+ end_slot int NULL DEFAULT NULL COMMENT '鐩爣鏍煎瓙',
+ pattern_quantity varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '鍘熺墖鏁伴噺',
+ enable_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;
--
Gitblit v1.8.0