[Suggestion] Deleted Categories Migration

When an admin removes a category from an module, let's say the Photos module, it should bring up a form to allow the admin to move all photos falling under this soon to be deleted category over to something more relevant.

Instead, what happens now, if an admin deletes a category, all photos are left with a blank category and in the database it's still using the CAT ID of a now deleted category.

So let's say I had 2 category that I recently found were redundant to keep them both.

Category one is: Animals

Category two is: Cats

I want to get rid of "Cats" and just have people use the general "Animals" category.

What I have to do is delete the category "Cats" and go into the database to mass edit every photo "cat" id to the desired one using a SQL command.

UPDATE `bx_photos_entries` SET `cat` = "10" WHERE `cat` = "12";

For me, this is easy, and it takes the burden off my userbase for having to do this. However, not everyone is a SQL wizard or knows how to work something akin to phpMyAdmin. So with that being said, is this possible that we can add this as a feature to the category deletion prompt for all UNA modules that use categories?