Changing the foreign key constraint fails

[gokulapriya4]

new.txt old.txt

I have herewith attached 2 sample files , which I apply it to a database and generate 2 dumps [old and new] . When I generate the patch using Diff tool and generate the patch, it actually fails . The issue is I am trying to change the primary key which is a candidate of foreign key . So the patch should be generated in the order :

1. Drop the foreign Key
2. Drop the primary Key
3. Then create the new Primary Key
4. Create a new foreign Key

But the patch generated is not in that order. I am using the Apgdiff tool version 2.4