query-orchestration/internal/database/migrations_archive/00000000000109_create_folders_table.down.sql

-- Rollback: Drop folders table and its indexes
DROP INDEX IF EXISTS idx_folders_path;
DROP INDEX IF EXISTS idx_folders_clientid;
DROP INDEX IF EXISTS idx_folders_parentid;
DROP TABLE IF EXISTS folders;