If you use foreign key constraints you can't dump and restore tables unless you do so in a very specific order. It's very easy to do ``allowed'' circular definitions that make the tables impossible to ...

I'm working on a web app, and it part of it, there is a very simple database-driven file/document manager. As a file manager, there is the possibility of sub-folders. So in the DB, I have the ...