Bug Information Title:  MySQL fk restriction creation fails Text:  The reason why InnoDB FK restrictions fail is the inclusion of the MATCH FULL/PARTIAL argument. This one seems to make MySQL skip the rest of the restrictions. Tested by exporting SQL & removing the offending lines. Be advised that i tested this om MySQL 4.1-alpha which has support for the ON UPDATE restriction. This is not the cas in 4.0.X, so you might want to try that one also an maby make it optional. A good idea would seem to be making all the individual restrictions optional.