dhis2-devs team mailing list archive

[noreply@xxxxxxxxxxxxx]

------------------------------------------------------------
revno: 13971
committer: Tran Chau <tran.hispvietnam@xxxxxxxxx>
branch nick: dhis2
timestamp: Mon 2014-02-10 15:10:45 +0700
message:
  Minor fix in sql file to convert database in tracker module.
modified:
  resources/sql/rename-patient-to-trackedentity-in-database.sql


--
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 'resources/sql/rename-patient-to-trackedentity-in-database.sql'
--- resources/sql/rename-patient-to-trackedentity-in-database.sql	2014-02-10 05:42:16 +0000
+++ resources/sql/rename-patient-to-trackedentity-in-database.sql	2014-02-10 08:10:45 +0000
@@ -152,7 +152,6 @@
 
 ALTER TABLE programstage_dataelements RENAME COLUMN patienttabularreportid TO trackedentitytabularreportid;
 
-
 ALTER TABLE programstageinstance RENAME COLUMN patientcommentid TO trackedentitycommentid;
 ALTER TABLE trackedentityattribute RENAME COLUMN patientmobilesettingid TO trackedentitymobilesettingid;
 ALTER TABLE trackedentityattribute RENAME COLUMN sort_order_patientattributename TO sort_order_trackedentityattributename;
@@ -162,8 +161,9 @@
 ALTER TABLE trackedentityaudit RENAME COLUMN patientid TO trackedentityinstanceid;
 ALTER TABLE patienttabularreportmembers RENAME TO trackedentitytabularreportmembers;
 ALTER TABLE trackedentitytabularreportmembers RENAME COLUMN patienttabularreportid TO trackedentitytabularreportid;
-ALTER TABLE programstageinstance_patients RENAME COLUMN patientid TO trackedentityinstanceid;
-ALTER TABLE programinstance RENAME COLUMN patientid TO trackedentityinstanceid;
-ALTER TABLE programinstance RENAME COLUMN patientcommentid TO trackedentitycommentid;
+
+
+ALTER TABLE programstageinstance_patients RENAME TO programstageinstance_trackedentityinstances;
+ALTER TABLE programstageinstance_trackedentityinstances RENAME COLUMN patientid TO trackedentityinstanceid;