Looks like MySQL supports cascade delete for foreign keys. Set up a few test tables and see how it goes.

MySQL will soon store FOREIGN KEY definitions so that a client can ask for and receive an answer about how the original connection was made. The current `.frm' file format does not have any place for ...