fix #6879 Update uuid and name for admin user group

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
index 97f674c4dce31fcb1c94082d4ed719f8d3d7bed2..ff06d86cd1789fd17d120c59c725f5442d6ee17c 100644 (file)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
@@ -57,6 +57,7 @@ public class SchemaUpdater_47_49 extends SchemaUpdaterBase {
                String tableName;
                ISchemaUpdaterStep step;
                String newColumnName;
+               String query;
 
                List<ISchemaUpdaterStep> stepList = new ArrayList<>();
 
@@ -68,8 +69,11 @@ public class SchemaUpdater_47_49 extends SchemaUpdaterBase {
                        null, null, "nom. val.", uuidLanguage);
                stepList.add(step);
 
+               //... idInVoc
                stepName = "nom valid => nom. val. (idInVocabulary)";
-        String query = "UPDATE @@DefinedTermBase@@ SET idInVocabulary = 'nom. val.' WHERE uuid = '" + uuidTerm + "'";
+        query = "UPDATE @@DefinedTermBase@@ "
+                + " SET idInVocabulary = 'nom. val.' "
+                + " WHERE uuid = '" + uuidTerm + "'";
                tableName = "DefinedTermBase";
                step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
                stepList.add(step);
@@ -82,6 +86,18 @@ public class SchemaUpdater_47_49 extends SchemaUpdaterBase {
                step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, length, INCLUDE_AUDIT);
                stepList.add(step);
 
+               //#6879 Update uuid and name for admin user group
+           stepName = "nom valid => nom. val. (idInVocabulary)";
+        query = "UPDATE @@PermissionGroup@@ "
+                + " SET uuid='1739df71-bf73-4dc6-8320-aaaf72cb555f', name='Admin' "
+                + " WHERE  name='admin' or name='Admin'";
+        tableName = "PermissionGroup";
+        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
+        stepList.add(step);
+
+
+
+
 
 
 //        //#5149 remove unique index on Sequence_Reference.citations_id