Project

General

Profile

Revision ff183e33

IDff183e33aa0710615245e9cf45c5420f00dda123
Parent 2cdc89ce
Child b1518752

Added by Andreas Müller over 1 year ago

ref #7144 fix update script for country levels

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
215 215
        //#7144 Set Country area level
216 216
        stepName = "Set Country area level";
217 217
        query = " UPDATE @@DefinedTermBase@@ " +
218
                " SET level_id = (SELECT id FROM DefinedTermBase WHERE uuid = '79db63a4-1563-461e-8e41-48f5722feca4') " +
218
                " SET level_id = ( SELECT id FROM (SELECT id FROM DefinedTermBase WHERE uuid = '79db63a4-1563-461e-8e41-48f5722feca4') as drv) " +
219 219
                " WHERE DTYPE = 'Country' ";
220 220
        step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99);
221 221
        stepList.add(step);

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)