Revision 466192da
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 | ||
|---|---|---|
| 132 | 132 |
stepName = "Update hibernate_sequences for WorkingSet renaming"; |
| 133 | 133 |
query = " UPDATE hibernate_sequences " |
| 134 | 134 |
+ " SET sequence_name = 'DescriptiveDataSet' " |
| 135 |
+ " WHERE sequence_name = WorkingSet";
|
|
| 135 |
+ " WHERE sequence_name = 'WorkingSet'";
|
|
| 136 | 136 |
step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99); |
| 137 | 137 |
stepList.add(step); |
| 138 | 138 |
|
| ... | ... | |
| 275 | 275 |
stepName = "Rename " + oldTableName + ".workingSet_id"; |
| 276 | 276 |
String oldColumnName = "WorkingSet_id"; |
| 277 | 277 |
String newColumnName = "DescriptiveDataSet_id"; |
| 278 |
if ("WorkingSet_DescriptionBase".equals(oldTableName)){
|
|
| 279 |
oldColumnName = "WorkingSets_id"; |
|
| 280 |
newColumnName = "DescriptiveDataSets_id"; |
|
| 281 |
} |
|
| 278 | 282 |
step = ColumnNameChanger.NewIntegerInstance(stepName, newTableName, oldColumnName, newColumnName, INCLUDE_AUDIT); |
| 279 | 283 |
stepList.add(step); |
| 280 | 284 |
} |
Also available in: Unified diff
ref #7405 fix update script for renaming WorkingSet/DescriptiveDataSet