dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

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