Workout why we are getting foreign key violations on mnet_host.applicationid

From Dan's data:

Moodles Affected Average Percentage rows affected Table Key Total Violated Rows Total Rows
141 99.8 mnet_host applicationid 282 283

Work out where these are coming from, and see if we can devise an automated clean-up on upgrade.