[airavata] branch staging updated: Fix SINGLE_USER groups that were incorrectly created as MULTI_USER

[ma...@apache.org]

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

machristie pushed a commit to branch staging
in repository https://gitbox.apache.org/repos/asf/airavata.git


The following commit(s) were added to refs/heads/staging by this push:
     new 13c1f20  Fix SINGLE_USER groups that were incorrectly created as MULTI_USER
13c1f20 is described below

commit 13c1f20adf069bd7000946fc49a6f17353bda776
Author: Marcus Christie <ma...@iu.edu>
AuthorDate: Fri Aug 9 11:28:57 2019 -0400

    Fix SINGLE_USER groups that were incorrectly created as MULTI_USER
---
 .../0.18-0.19/DeltaScripts/sharingCatalog_schema_delta.sql             | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/sharingCatalog_schema_delta.sql b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/sharingCatalog_schema_delta.sql
index 1dc8aef..c9a5533 100644
--- a/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/sharingCatalog_schema_delta.sql
+++ b/modules/registry/release-migration-scripts/0.18-0.19/DeltaScripts/sharingCatalog_schema_delta.sql
@@ -31,3 +31,6 @@ CREATE TABLE IF NOT EXISTS GROUP_ADMIN (
 
 ALTER TABLE `GROUP_ADMIN` ADD CONSTRAINT `GROUP_ADMIN_ibfk_1` FOREIGN KEY IF NOT EXISTS (`ADMIN_ID`, `DOMAIN_ID`) REFERENCES `SHARING_USER` (`USER_ID`, `DOMAIN_ID`) ON DELETE CASCADE ON UPDATE NO ACTION;
 ALTER TABLE `GROUP_ADMIN` ADD KEY IF NOT EXISTS `ADMIN_ID` (`ADMIN_ID`,`DOMAIN_ID`);
+
+-- Some SINGLE_USER groups were incorrectly created as MULTI_USER
+update USER_GROUP set GROUP_CARDINALITY = 'SINGLE_USER' where GROUP_CARDINALITY = 'MULTI_USER' and OWNER_ID = GROUP_ID;