Project

General

Profile

« Previous | Next » 

Revision 466192da

Added by Andreas Müller almost 6 years ago

ref #7405 fix update script for renaming WorkingSet/DescriptiveDataSet

View differences:

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