[dolphinscheduler] branch dev updated: [BUG-7779][SQL] fix syntax error in init sql of postgre (#7782)

[ke...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

kerwin pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/dolphinscheduler.git


The following commit(s) were added to refs/heads/dev by this push:
     new 4662e6d  [BUG-7779][SQL] fix syntax error in init sql of postgre (#7782)
4662e6d is described below

commit 4662e6d92971ed7aaa021050205038f940c02723
Author: 天仇 <53...@qq.com>
AuthorDate: Tue Jan 4 13:06:06 2022 +0800

    [BUG-7779][SQL] fix syntax error in init sql of postgre (#7782)
    
    fix syntax error of table `t_ds_task_definition` and `t_ds_task_definition_log` in postgresql with column `task_group_priority int(4)`
---
 .../src/main/resources/sql/dolphinscheduler_postgresql.sql            | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql b/dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql
index bfd8402..472b4ce 100644
--- a/dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql
+++ b/dolphinscheduler-dao/src/main/resources/sql/dolphinscheduler_postgresql.sql
@@ -392,7 +392,7 @@ CREATE TABLE t_ds_task_definition (
   timeout int DEFAULT '0' ,
   delay_time int DEFAULT '0' ,
   task_group_id int DEFAULT NULL,
-  task_group_priority int(4) DEFAULT '0',
+  task_group_priority int DEFAULT '0',
   resource_ids text ,
   create_time timestamp DEFAULT NULL ,
   update_time timestamp DEFAULT NULL ,
@@ -429,7 +429,7 @@ CREATE TABLE t_ds_task_definition_log (
   resource_ids text ,
   operator int DEFAULT NULL ,
   task_group_id int DEFAULT NULL,
-  task_group_priority int(4) DEFAULT '0',
+  task_group_priority int DEFAULT '0',
   operate_time timestamp DEFAULT NULL ,
   create_time timestamp DEFAULT NULL ,
   update_time timestamp DEFAULT NULL ,