Project

General

Profile

Revision 662d3c82

ID662d3c825388a812a725ea2041b0005c45ec32e0
Parent 91f64efa
Child d7bb67dd

Added by Andreas Müller about 2 months ago

fix #9120 update flowering period as supports temporal data (update script)

View differences:

cdmlib-persistence/src/main/java/eu/etaxonomy/cdm/database/update/v515_518/SchemaUpdater_5152_5180.java
185 185
                   + " WHERE uuid='04aa8993-24b4-43e3-888c-5afaa733376e' ";
186 186
        SimpleSchemaUpdaterStep.NewAuditedInstance(stepList, stepName, sql, tableName, 99);
187 187

  
188
        //#9120
189
        //update flowering period as supports temporal data
190
        stepName = "update flowering period as supports temporal data";
191
        tableName = "DefinedTermBase";
192
        sql = "UPDATE @@DefinedTermBase@@ "
193
                + " SET supportedDataTypes = CONCAT(supportedDataTypes, 'TED#') "
194
                + " WHERE uuid = '03710cb5-606e-444a-a3e6-594268e3cc47' AND supportedDataTypes NOT LIKE '%#TED#%' ";
195
        SimpleSchemaUpdaterStep.NewAuditedInstance(stepList, stepName, sql, tableName, 99);
196

  
188 197
        return stepList;
189 198
    }
190 199

  

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)