MySQL file system DB structure (hierarchical)?

Question

MySQL

Can you please tell me what are the best practices for creating a MySQL DB architecture for a normal file structure.
Let's say there is an application where the user can create folders/subfolders and files. There can be a large nested hierarchy (as in any hosting control panels like cPanel).
How to store all this? In one table with a recursive link for both folders and files with a field of type (directory, document), or create two tables for folders and files with links?
Surely somewhere there is a good example of designing such a database, but I could not find anything intelligible.

Answer 1

Nested Set