update script for new mediaSpecimen attribute #3614

[cdmlib.git] / cdmlib-persistence / src / main / java / eu / etaxonomy / cdm / database / update / v31_33 / SchemaUpdater_31_33.java

diff --git a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v31_33/SchemaUpdater_31_33.java b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v31_33/SchemaUpdater_31_33.java
index 5065e52adfef43147754d7b81eb49dac34a4e021..a86a87a5e291521ba9c85e593d087d56f5aba088 100644 (file)
--- a/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v31_33/SchemaUpdater_31_33.java
+++ b/cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v31_33/SchemaUpdater_31_33.java
@@ -237,7 +237,14 @@ public class SchemaUpdater_31_33 extends SchemaUpdaterBase {
                
                //TODO update molecular data #3340
                
-               //TODO add MediaSpecimen column #3614
+               //add MediaSpecimen column #3614
+               stepName = "Add MediaSpecimen column to SpecimenOrObservationBase";
+               tableName = "SpecimenOrObservationBase";
+               columnName = "mediaSpecimen_id";
+               boolean notNull = false;
+               String referencedTable = "Media";
+               step = ColumnAdder.NewIntegerInstance(stepName, tableName, columnName, INCLUDE_AUDIT, notNull, referencedTable);
+               stepList.add(step);
                
                //remove DescriptionBase_Feature  #2202
                stepName = "Remove table DescriptionBase_Feature";