The files should be deleted automatically by a sweeper proc that runs once a day. When a revision is deleted and the revision is file-based, a trigger logs the event in the table cr_files_to_delete. The sweeper proc checks the cr_files_to_delete table and removes the files that are no longer being used by the sweeper proc. Check to see if the cr_delete_scheduled_files proc has run and check to see if there are any entries in the cr_files_to_delete table.
