This is an automated email from the ASF dual-hosted git repository.
caishunfeng pushed a commit to branch 3.1.0-prepare
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git
The following commit(s) were added to refs/heads/3.1.0-prepare by this push:
new f1de1707d5 Update dolphinscheduler_ddl.sql fix alert t_ds_user add
time_zone is not correct (#11795)
f1de1707d5 is described below
commit f1de1707d56bfd84e6a3d2933c191deddfb41628
Author: fuchanghai <[email protected]>
AuthorDate: Tue Sep 6 23:14:41 2022 +0800
Update dolphinscheduler_ddl.sql fix alert t_ds_user add time_zone is not
correct (#11795)
---
.../resources/sql/upgrade/3.0.0_schema/mysql/dolphinscheduler_ddl.sql | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)
diff --git
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/mysql/dolphinscheduler_ddl.sql
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/mysql/dolphinscheduler_ddl.sql
index c5b15ec884..72acb02051 100644
---
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/mysql/dolphinscheduler_ddl.sql
+++
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/mysql/dolphinscheduler_ddl.sql
@@ -407,7 +407,7 @@ BEGIN
IF NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME='t_ds_user'
AND TABLE_SCHEMA=(SELECT DATABASE())
- AND COLUMN_NAME='t_ds_user')
+ AND COLUMN_NAME='time_zone')
THEN
ALTER TABLE `t_ds_user` ADD COLUMN `time_zone` varchar(32) DEFAULT NULL
COMMENT 'time zone';
END IF;
@@ -751,4 +751,4 @@ CREATE TABLE `t_ds_task_group_queue` (
`create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`update_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP,
PRIMARY KEY( `id` )
-)ENGINE= INNODB AUTO_INCREMENT= 1 DEFAULT CHARSET= utf8;
\ No newline at end of file
+)ENGINE= INNODB AUTO_INCREMENT= 1 DEFAULT CHARSET= utf8;
