Revision a918965a
Added by Andreas Müller almost 3 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v522_523/SchemaUpdater_5220_5230.java | ||
|---|---|---|
| 175 | 175 |
newColumnName = "currentConceptPeriod_freetext"; |
| 176 | 176 |
ColumnAdder.NewStringInstance(stepList, stepName, tableName, newColumnName, INCLUDE_AUDIT); |
| 177 | 177 |
|
| 178 |
//#9617 |
|
| 179 |
stepName = "Rename ICNB to ICNP"; |
|
| 180 |
query = "UPDATE @@TaxonName@@ " |
|
| 181 |
+ " SET nameType = 'ICNP' " |
|
| 182 |
+ " WHERE nameType = 'ICNB'"; |
|
| 183 |
SimpleSchemaUpdaterStep.NewAuditedInstance(stepList, stepName, query, "TaxonName", -99); |
|
| 184 |
|
|
| 185 |
|
|
| 178 | 186 |
return stepList; |
| 179 | 187 |
} |
| 180 | 188 |
|
Also available in: Unified diff
fix #9617 rename ICNB to ICNP in cdmlib