From d231bf8a792bc8b368e01d9a48a68ea2b021f64b Mon Sep 17 00:00:00 2001 From: shizhendong Date: Thu, 27 Jul 2023 11:29:28 +0800 Subject: fix: NEZ-3017 调整 visual_chart 表 x&y 为 double(9, 2) MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit --- ...3.07.18.1__modify visual_chart x, y colnum type to double.sql | 4 ++-- nz-admin/src/main/resources/db/beforeValidate.sql | 9 ++++++++- 2 files changed, 10 insertions(+), 3 deletions(-) diff --git a/nz-admin/src/main/resources/db/V2023.07.18.1__modify visual_chart x, y colnum type to double.sql b/nz-admin/src/main/resources/db/V2023.07.18.1__modify visual_chart x, y colnum type to double.sql index 0e628ec5..ac7d07a7 100644 --- a/nz-admin/src/main/resources/db/V2023.07.18.1__modify visual_chart x, y colnum type to double.sql +++ b/nz-admin/src/main/resources/db/V2023.07.18.1__modify visual_chart x, y colnum type to double.sql @@ -3,5 +3,5 @@ */ ALTER TABLE `visual_chart` -MODIFY COLUMN IF EXISTS `x` double(5, 2) NOT NULL DEFAULT 0 COMMENT 'x轴起点', -MODIFY COLUMN IF EXISTS `y` double(5, 2) NOT NULL DEFAULT 0 COMMENT 'y轴起点'; +MODIFY COLUMN IF EXISTS `x` double(9, 2) NOT NULL DEFAULT 0 COMMENT 'x轴起点', +MODIFY COLUMN IF EXISTS `y` double(9, 2) NOT NULL DEFAULT 0 COMMENT 'y轴起点'; diff --git a/nz-admin/src/main/resources/db/beforeValidate.sql b/nz-admin/src/main/resources/db/beforeValidate.sql index 6137dc6b..4f28adad 100644 --- a/nz-admin/src/main/resources/db/beforeValidate.sql +++ b/nz-admin/src/main/resources/db/beforeValidate.sql @@ -11,6 +11,9 @@ * 2023-07-19 * 1. V2023.07.18__asset_type_config modify init data.sql SQL 改动，修改 checksum 值 * + * 2023-07-27 + * 1. 删除 V2023.07.18.1__modify visual_chart x, y colnum type to double.sql 记录 + * */ -- ---------------------------- @@ -49,5 +52,9 @@ SET `checksum` = 475861812 WHERE script = "V2023.07.18__asset_type_config modify init data.sql"; - +DELETE +FROM + flyway_schema_history +WHERE + script = "V2023.07.18.1__modify visual_chart x, y colnum type to double.sql"; -- cgit v1.2.3