=== 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 2014-04-13 20:08:51 +0000 +++ dhis-2/dhis-services/dhis-service-core/src/main/java/org/hisp/dhis/startup/TableAlteror.java 2014-04-14 12:13:52 +0000 @@ -663,7 +663,8 @@ executeSql( "UPDATE dataset SET dataelementdecoration=false WHERE dataelementdecoration is null" ); executeSql( "alter table validationrulegroup rename column validationgroupid to validationrulegroupid" ); - executeSql( "alter table sqlview rename column viewid to sqlviewid" ); + executeSql( "update sqlview set sqlviewid=viweid" ); + executeSql( "alter table sqlview drop column viewid" ); executeSql( "UPDATE dashboard SET publicaccess='--------' WHERE publicaccess is null" );