what's the best way to delete all the subfolders and subfiles, recursively? I'm writing this app in ASP.NET/C#, with a MySQL backend. Should I set up a foreign key constraint? How would I go about ...

By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.