(dolphinscheduler) branch dev updated: Fix database schema change check failed with pg in ci (#15995)

[xincheng]

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

xincheng 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 1a4537ecbd Fix database schema change check failed with pg in ci 
(#15995)
1a4537ecbd is described below

commit 1a4537ecbdcb2b118c83e4302a79a3b780d66bbb
Author: Wenjun Ruan <wen...@apache.org>
AuthorDate: Wed May 15 10:36:27 2024 +0800

    Fix database schema change check failed with pg in ci (#15995)
    
    Co-authored-by: xiangzihao <460888...@qq.com>
---
 .../sql/upgrade/3.0.0_schema/postgresql/dolphinscheduler_ddl.sql       | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

diff --git 
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/postgresql/dolphinscheduler_ddl.sql
 
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/postgresql/dolphinscheduler_ddl.sql
index 393bda87fc..fbc9b26b86 100644
--- 
a/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/postgresql/dolphinscheduler_ddl.sql
+++ 
b/dolphinscheduler-dao/src/main/resources/sql/upgrade/3.0.0_schema/postgresql/dolphinscheduler_ddl.sql
@@ -40,7 +40,8 @@ ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS 
"process_instance_id" int DEFAUL
 ALTER TABLE t_ds_alert ADD COLUMN IF NOT EXISTS "alert_type" int DEFAULT NULL;
 
 --- Add unique key
-CREATE UNIQUE INDEX IF NOT EXISTS t_ds_relation_project_user_un on 
t_ds_relation_project_user (user_id, project_id);
+
+CREATE INDEX IF NOT EXISTS t_ds_relation_project_user_un on 
t_ds_relation_project_user (user_id, project_id);
 CREATE UNIQUE INDEX IF NOT EXISTS unique_name on t_ds_project (name);
 CREATE UNIQUE INDEX IF NOT EXISTS unique_code on t_ds_project (code);
 CREATE UNIQUE INDEX IF NOT EXISTS unique_queue_name on t_ds_queue (queue_name);