Revision d5111e49
Added by Andreas Müller almost 5 years ago
| 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
fix #6879 Update uuid and name for admin user group