=== modified file 'dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/InitTableAlteror.java' --- dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/InitTableAlteror.java 2015-06-19 07:35:50 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/InitTableAlteror.java 2015-06-19 09:57:16 +0000 @@ -71,10 +71,6 @@ executeSql( "ALTER TABLE program DROP COLUMN displayonallorgunit" ); upgradeProgramStageDataElements(); - - executeSql( "UPDATE program SET dataentryformid =(SELECT trackedentityform.dataentryformid FROM trackedentityform WHERE program.programid=trackedentityform.programid) " + - "WHERE program.programid = (SELECT trackedentityform.programid FROM trackedentityform WHERE program.programid = trackedentityform.programid)" ); -// executeSql( "drop table trackedentityform"); } // ------------------------------------------------------------------------- === modified file 'dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/startup/TableAlteror.java' --- dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/startup/TableAlteror.java 2015-04-21 18:14:12 +0000 +++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/startup/TableAlteror.java 2015-06-19 09:57:16 +0000 @@ -310,6 +310,9 @@ executeSql( "drop index index_patientdatavalue" ); + executeSql( "update program p set dataentryformid = (select dataentryformid from trackedentityform tf where tf.programid=p.programid limit 1)" ); + executeSql( "drop table trackedentityform" ); + updateProgramStageList(); updateProgramAttributeList();