dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #33107
[Branch ~dhis2-devs-core/dhis2/trunk] Rev 16865: Tracker table alteror. Removed statement that takes forever to complete on large databases. We mu...
------------------------------------------------------------
revno: 16865
committer: Lars Helge Overland <larshelge@xxxxxxxxx>
branch nick: dhis2
timestamp: Mon 2014-09-29 21:07:43 +0200
message:
Tracker table alteror. Removed statement that takes forever to complete on large databases. We must distribute this as script.
modified:
dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/startup/TableAlteror.java
--
lp:dhis2
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription
=== 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-08-28 07:05:34 +0000
+++ dhis-2/dhis-services/dhis-service-tracker/src/main/java/org/hisp/dhis/trackedentity/startup/TableAlteror.java 2014-09-29 19:07:43 +0000
@@ -257,8 +257,6 @@
+ "where trackedentityattribute.mandatory is not null" );
executeSql( "ALTER TABLE trackedentityattribute DROP COLUMN mandatory" );
- executeSql( "update datavalue set storedby='aggregated_from_tracker' where storedby='DHIS-System'" );
-
executeSql( "ALTER TABLE trackedentityattribute DROP COLUMN groupBy" );
executeSql( "update trackedentityattribute set valuetype='string' where valuetype='combo' and optionsetid is null" );