fix: NEZ-3111 alert_rule.receiver 类型由 varchar(64) 调整为 text

1 files changed, 10 insertions, 0 deletions

diff --git a/nz-admin/src/main/resources/db/V2023.08.10.1__modify alert_rule receiver colnum type to text.sql b/nz-admin/src/main/resources/db/V2023.08.10.1__modify alert_rule receiver colnum type to text.sql
new file mode 100644
index 00000000..fb3ff16b
--- /dev/null
+++ b/nz-admin/src/main/resources/db/V2023.08.10.1__modify alert_rule receiver colnum type to text.sql
@@ -0,0 +1,10 @@
+/**
+ * 1. modify alert_rule receiver colnum type to text.
+ * 2. modify int_alert_rule receiver colnum type to text.
+ */
+
+ALTER TABLE `alert_rule`
+MODIFY COLUMN IF EXISTS `receiver` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '通知用户';
+
+ALTER TABLE `int_alert_rule`
+MODIFY COLUMN IF EXISTS `receiver` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '通知用户';