The following SQL statements should be executed when upgrading from M9/2.0 to 2.0.1.
If the statement fails it means that it is already updated, and will make no harm. These statements should be executed before the application is started. The create-index statement may take a long time if not already there on a big database
MySQL:
alter table chart drop column name;
alter table usersetting modify column value blob default null;
alter table systemsetting modify column value blob default null;
alter table indicator modify column numerator text;
alter table indicator modify column denominator text;
drop table aggregateddatavalue;
drop table aggregatedindicatorvalue;
drop table extendeddataelement;
drop table importobject;
drop table importdatavalue;
create index crosstab on datavalue (periodid, sourceid);
PostgreSQL:
alter table chart drop column name;
alter table indicator alter column numerator type text;
alter table indicator alter column denominator type text;
drop table aggregateddatavalue;
drop table aggregatedindicatorvalue;
drop table extendeddataelement;
drop table importobject;
drop table importdatavalue;
create index crosstab on datavalue (periodid, sourceid);
Wiki: http://208.76.222.114/confluence/display/DHIS2/Database+update+SQL+statements
regards, Lars