Revision 80528bff
Added by Andreas Müller about 3 years ago
| cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v515_518/SchemaUpdater_5181_5182.java | ||
|---|---|---|
| 52 | 52 |
List<ISchemaUpdaterStep> stepList = new ArrayList<>(); |
| 53 | 53 |
|
| 54 | 54 |
// //6581 |
| 55 |
// //move nomenclatural status reference to source |
|
| 56 |
// stepName = "rename NomenclaturalSource"; |
|
| 57 |
// String sql = "UPDATE @@OriginalSourceBase@@ " |
|
| 58 |
// + " SET DTYPE = 'NomenclaturalSource', sourceType='NOR' " |
|
| 59 |
// + " WHERE id IN (SELECT nomenclaturalSource_id FROM @@TaxonName@@ WHERE nomenclaturalSource_id IS NOT NULL) "; |
|
| 60 |
// String sql_aud = "UPDATE @@OriginalSourceBase_AUD@@ SET DTYPE = 'NomenclaturalSource', sourceType='NOR' WHERE id IN (SELECT nomenclaturalSource_id FROM @@TaxonName_AUD@@ WHERE nomenclaturalSource_id IS NOT NULL)"; |
|
| 61 |
// SimpleSchemaUpdaterStep.NewAuditedInstance(stepList, stepName, sql, sql_aud, -99); |
|
| 62 |
|
|
| 63 | 55 |
stepName = "Add sourcedName column to NomenclaturalSource"; |
| 64 | 56 |
tableName = "OriginalSourceBase"; |
| 65 | 57 |
newColumnName = "sourcedName_id"; |
Also available in: Unified diff
cleanup