Revision a43a5770
Added by Andreas Müller almost 6 years ago
| 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 areaLevel_id = (SELECT id FROM DefinedTermBase WHERE uuid = '79db63a4-1563-461e-8e41-48f5722feca4') " +
|
|
| 218 |
" SET level_id = (SELECT id FROM DefinedTermBase WHERE uuid = '79db63a4-1563-461e-8e41-48f5722feca4') " +
|
|
| 219 | 219 |
" WHERE DTYPE = 'Country' "; |
| 220 | 220 |
step = SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepName, query, -99); |
| 221 | 221 |
stepList.add(step); |
Also available in: Unified diff
fix #7144 fix update script for setting country area levels