=== 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;