v1.44.3 - Improve Category Deletion

Added

• Added a new relation bans to the Categories model.
• Added a new relation pending_posts to the CommunityUsers model.

Changed

• The set_children method in the categories flow has been updated to handle preserving nested non-empty categories within empty categories. This change ensures that when a parent category is empty but contains a non-empty child category, the child category is preserved, archived, and hidden, while the parent category is deleted.

• The delete method for categories has been updated to properly delete categories. This includes deleting all related data in the database, such as topics, subscriptions, bans, moderators, activity logs, category tags, category post logs, and category group categories.

• The delete method in the topics model has been updated to clean up more tables and use the model.delete method. This includes deleting related data in the database, such as pending posts, topic participants, user topic last seens, bans, subscriptions, and bookmarks.

• The hard_delete method in the pending_posts model has been updated to also delete related activity logs when a pending post is hard deleted.

Misc

• Updated test suite to more carefully verify queries when performing deletion operations