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
_______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : [email protected] Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
