Project

General

Profile

Revision d5111e49

IDd5111e4927fe58964516cf48c358ebf5d7b5ff6d
Parent 432e932d
Child ed3f9971

Added by Andreas Müller about 1 year ago

fix #6879 Update uuid and name for admin user group

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
57 57
		String tableName;
58 58
		ISchemaUpdaterStep step;
59 59
		String newColumnName;
60
		String query;
60 61

  
61 62
		List<ISchemaUpdaterStep> stepList = new ArrayList<>();
62 63

  
......
68 69
		        null, null, "nom. val.", uuidLanguage);
69 70
		stepList.add(step);
70 71

  
72
		//... idInVoc
71 73
		stepName = "nom valid => nom. val. (idInVocabulary)";
72
        String query = "UPDATE @@DefinedTermBase@@ SET idInVocabulary = 'nom. val.' WHERE uuid = '" + uuidTerm + "'";
74
        query = "UPDATE @@DefinedTermBase@@ "
75
                + " SET idInVocabulary = 'nom. val.' "
76
                + " WHERE uuid = '" + uuidTerm + "'";
73 77
		tableName = "DefinedTermBase";
74 78
		step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
75 79
		stepList.add(step);
......
82 86
		step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, length, INCLUDE_AUDIT);
83 87
		stepList.add(step);
84 88

  
89
		//#6879 Update uuid and name for admin user group
90
	    stepName = "nom valid => nom. val. (idInVocabulary)";
91
        query = "UPDATE @@PermissionGroup@@ "
92
                + " SET uuid='1739df71-bf73-4dc6-8320-aaaf72cb555f', name='Admin' "
93
                + " WHERE  name='admin' or name='Admin'";
94
        tableName = "PermissionGroup";
95
        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
96
        stepList.add(step);
97

  
98

  
99

  
100

  
85 101

  
86 102

  
87 103
//        //#5149 remove unique index on Sequence_Reference.citations_id

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)