EDIT

import eu.etaxonomy.cdm.database.update.ColumnRemover;

		//#7074 change type for Media.mediaCreated

		changeTypeMediaCreated(stepList);

    /**

     * @param stepList

     */

    private void changeTypeMediaCreated(List<ISchemaUpdaterStep> stepList) {

        //rename old column

        String stepName = "Rename Media.mediaCreated";

        String tableName = "Media";

        String oldColumnName = "mediaCreated";

        String newColumnName = "mediaCreatedOld";

        ISchemaUpdaterStep step = ColumnNameChanger.NewDateTimeInstance(stepName, tableName, oldColumnName, newColumnName, INCLUDE_AUDIT);

        stepList.add(step);

        //add timeperiod columns

        stepName = "Add mediaCreated_start";

        tableName = "Media";

        newColumnName = "mediaCreated_start";

        int size = 50;

        step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, size, INCLUDE_AUDIT);

        stepList.add(step);

        stepName = "Add mediaCreated_end";

        newColumnName = "mediaCreated_end";

        step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, size, INCLUDE_AUDIT);

        stepList.add(step);

        stepName = "Add mediaCreated_freetext";

        newColumnName = "mediaCreated_freetext";

        step = ColumnAdder.NewStringInstance(stepName, tableName, newColumnName, INCLUDE_AUDIT);

        stepList.add(step);

        //move data

        stepName = "Copy mediaCreated to new columns";

        String query = "UPDATE @@Media@@ "

                + " SET mediaCreated_start = Left(Replace(Replace(Replace(mediaCreatedOld, '-', ''), ':', ''), ' ', '_'), 13)"

                + " WHERE mediaCreatedOld IS NOT NULL ";

        step = SimpleSchemaUpdaterStep.NewAuditedInstance(stepName, query, tableName, -99);

        stepList.add(step);

        //delete old column

        stepName = "Remove old mediaCreated";

        String columnName = "mediaCreatedOld";

        ColumnRemover.NewInstance(stepName, tableName, columnName, INCLUDE_AUDIT);

        stepList.add(step);

    }