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