In mysql if you create two tables and then create foriegn keys for them the properties on update and on delete are been lost when we Alter Table.

Example Information:

  MySQL 5.1

  User: root

  Password: ******

  Host: 10.168.11.37

  Port: 3306

  Database: test

  Tables:  test & testfk

 

testfk has the two foriegn key constraints that are pointing to table test.  the extraction is getting the update and delete information correctly and you will notice the object has the correct information on line 282 of ConstraintDetailPane.java.

after line 283 though the information is reset to "", not sure why.  if you follow the method is happens in CPropertyTable.java method setProperties(List<? extends Property> properties).  after this method is run on the object the data is lost.

 

Andy if you could take a look at this and fix for 10.0,

thanks,

Ivan