fix: NEZ-3017 调整 visual_chart 表 x&y 为 double(9, 2)

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";