=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2011-04-10 13:48:29 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2011-04-11 16:38:05 +0000 @@ -119,6 +119,13 @@ executeSql( "ALTER TABLE map DROP COLUMN zoom" ); executeSql( "ALTER TABLE maplayer DROP CONSTRAINT maplayer_mapsource_key" ); + // extended data element + executeSql( "ALTER TABLE dataelement DROP CONSTRAINT fk_dataelement_extendeddataelementid" ); + executeSql( "ALTER TABLE dataelement DROP COLUMN extendeddataelementid" ); + executeSql( "ALTER TABLE indicator DROP CONSTRAINT fk_indicator_extendeddataelementid" ); + executeSql( "ALTER TABLE indicator DROP COLUMN extendeddataelementid" ); + executeSql( "DROP TABLE extendeddataelement" ); + // --------------------------------------------------------------------- // Update tables for dimensional model // ---------------------------------------------------------------------