Creates a temporary table to map folder paths to IDs Inserts the root folder Uses a recursive CTE to:

Process all subfolders at any depth Maintain parent-child relationships

Inserts all files with proper folder_id references