Revision 6d38d5c2
Added by Andreas Müller over 1 year ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v40_50/SchemaUpdater_47_50.java | ||
|---|---|---|
| 13 | 13 |
import java.util.List; |
| 14 | 14 |
import java.util.UUID; |
| 15 | 15 |
|
| 16 |
import org.apache.logging.log4j.LogManager;import org.apache.logging.log4j.Logger; |
|
| 16 |
import org.apache.logging.log4j.LogManager; |
|
| 17 |
import org.apache.logging.log4j.Logger; |
|
| 17 | 18 |
|
| 18 | 19 |
import eu.etaxonomy.cdm.database.DatabaseTypeEnum; |
| 19 | 20 |
import eu.etaxonomy.cdm.database.update.ClassBaseTypeUpdater; |
| ... | ... | |
| 72 | 73 |
query = "UPDATE @@LSIDAuthority_namespaces@@ " |
| 73 | 74 |
+ " SET namespaces_element = 'eu.etaxonomy.cdm.model.name.TaxonName' " |
| 74 | 75 |
+ " WHERE namespaces_element = 'eu.etaxonomy.cdm.model.name.TaxonNameBase'"; |
| 75 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query, -99);
|
|
| 76 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query); |
|
| 76 | 77 |
|
| 77 | 78 |
//#6699 delete term version |
| 78 | 79 |
stepName = "Delete term version"; |
| 79 | 80 |
query = "DELETE FROM @@CdmMetaData@@ WHERE propertyName = 'TERM_VERSION'"; |
| 80 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query, -99);
|
|
| 81 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query); |
|
| 81 | 82 |
|
| 82 | 83 |
//#6581 make nomenclatural reference and OriginalSource |
| 83 | 84 |
stepName = "Make nomenclatural reference and OriginalSource"; |
| ... | ... | |
| 122 | 123 |
query = "UPDATE @@PermissionGroup@@ " |
| 123 | 124 |
+ " SET uuid='1739df71-bf73-4dc6-8320-aaaf72cb555f', name='Admin' " |
| 124 | 125 |
+ " WHERE name='admin' or name='Admin'"; |
| 125 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query, -99);
|
|
| 126 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query); |
|
| 126 | 127 |
|
| 127 | 128 |
//#7405 Rename WorkingSet to DescriptiveDataSet |
| 128 | 129 |
String oldTableName = "WorkingSet"; |
| ... | ... | |
| 221 | 222 |
query = " UPDATE @@DefinedTermBase@@ " + |
| 222 | 223 |
" SET level_id = ( SELECT id FROM (SELECT id FROM DefinedTermBase WHERE uuid = '79db63a4-1563-461e-8e41-48f5722feca4') as drv) " + |
| 223 | 224 |
" WHERE DTYPE = 'Country' "; |
| 224 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query, -99);
|
|
| 225 |
SimpleSchemaUpdaterStep.NewNonAuditedInstance(stepList, stepName, query); |
|
| 225 | 226 |
|
| 226 | 227 |
//#6588 |
| 227 | 228 |
stepName = "Add ExternalLink table"; |
Also available in: Unified diff
cleanup