Foreign keys can refer to another column in the same table. The top-level folder might need to be its own parent - I don't know if it'll let you have a NULL there.

Hence, the birth of the MySQL InnoDB vs. MyISAM debate. Of course, MySQL users prior to the 5.5 release were probably perplexed by the assertion that the database didn't support foreign keys. MySQL ...