ref #6752 update script for Reference.datepublished_verbatimDate

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
index f12932a12b3ff34004b9df6ef00fcda01726d739..e89ebfa81a6edc53b92165fc6d7543cbe9259d55 100644 (file)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v47_49/SchemaUpdater_47_49.java
@@ -92,6 +92,13 @@ public class SchemaUpdater_47_49 extends SchemaUpdaterBase {
                step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);
                stepList.add(step);
 
+               //#6752 add Reference.datePublished_verbatimDate
+           stepName = "Add Reference.datePublished_verbatimDate";
+           tableName = "Reference";
+           newColumnName = "datePublished_verbatimDate";
+           step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT);
+           stepList.add(step);
+
                //#7096 Add second symbol attribute to DefinedTermBase
                stepName = "Add second symbol to DefinedTermBase";
                tableName = "DefinedTermBase";