=== 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 2014-07-03 09:17:44 +0000 +++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/startup/TableAlteror.java 2014-07-10 11:59:42 +0000 @@ -276,8 +276,7 @@ executeSql( "UPDATE trackedentityaudit SET accessedmodule='tracked_entity_instance_dashboard' WHERE accessedmodule='instance_dashboard' or accessedmodule='patient_dashboard'" ); - executeSql( "UPDATE program_attributes SET allowDateInFuture='false' WHERE allowDateInFuture is null" ); - + executeSql( "UPDATE programstageinstance SET status=1 WHERE completed=true" ); executeSql( "ALTER TABLE programstageinstance DROP COLUMN completed" ); @@ -291,6 +290,11 @@ executeSql( "update programstage_dataelements set allowfuturedate = allowdateinfuture where allowfuturedate is null" ); executeSql( "update programstage_dataelements set allowfuturedate = false where allowfuturedate is null" ); executeSql( "ALTER TABLE programstage_dataelements DROP COLUMN allowdateinfuture" ); + + executeSql( "update program_attributes set allowfuturedate = allowdateinfuture where allowfuturedate is null" ); + executeSql( "update program_attributes set allowfuturedate = false where allowfuturedate is null" ); + executeSql( "ALTER TABLE program_attributes DROP COLUMN allowdateinfuture" ); + executeSql( "UPDATE program_attributes SET allowFutureDate='false' WHERE allowFutureDate is null" ); } // -------------------------------------------------------------------------