When using the InnoDB table format in MySql, there’s the possibility to define foreign key relations to guarantee referential integrity.
Setting up the relations by using “ALTER TABLE” sql statements is not that trivial though. I had some struggles the other day… Luckily there’s a view in PhpMyAdmin that takes care of this. Check out this post from Jim Epler’s blog. Thanks Jim!