James Greig wrote: > At this time, our advice would be to avoid MySQL 5.1 from our p.o.v.
Indeed: 5.1 sucks at this point. > Are we likely to have orphaned data by not having the 'delete on cascade' > foreign keys on these two tables? Yes. > Or does dbmail-util compensate for this > and remove any orphaned data? No. Before 2.2 dbmail was targetted at mysql/myisam and solved key constraints in the program logic. This was changed in 2.2: key constraints and cascades are now fully depended upon for maintaining data integrity, wherever possible. -- ________________________________________________________________ Paul Stevens paul at nfg.nl NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31 The Netherlands________________________________http://www.nfg.nl _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
