(cloudstack) branch 4.20 updated: Add project-user association normalization script to 4.20.1 upgrade (#10116)

[dahn]

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

dahn pushed a commit to branch 4.20
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/4.20 by this push:
     new 2300c1caa3a Add project-user association normalization script to 
4.20.1 upgrade (#10116)
2300c1caa3a is described below

commit 2300c1caa3a190c8eb9ad8ccec6353b429a2b6e1
Author: Fabricio Duarte <fabricio.duarte...@gmail.com>
AuthorDate: Thu Jan 16 12:18:30 2025 -0300

    Add project-user association normalization script to 4.20.1 upgrade (#10116)
---
 .../src/main/resources/META-INF/db/schema-42000to42010-cleanup.sql     | 3 +++
 1 file changed, 3 insertions(+)

diff --git 
a/engine/schema/src/main/resources/META-INF/db/schema-42000to42010-cleanup.sql 
b/engine/schema/src/main/resources/META-INF/db/schema-42000to42010-cleanup.sql
index d187b6fa043..a00d50a7e10 100644
--- 
a/engine/schema/src/main/resources/META-INF/db/schema-42000to42010-cleanup.sql
+++ 
b/engine/schema/src/main/resources/META-INF/db/schema-42000to42010-cleanup.sql
@@ -18,3 +18,6 @@
 --;
 -- Schema upgrade cleanup from 4.20.0.0 to 4.20.1.0
 --;
+
+-- Delete `project_account` entries for users that were removed
+DELETE FROM `cloud`.`project_account` WHERE `user_id` IN (SELECT `id` FROM 
`cloud`.`user` WHERE `removed`);