Clean up the unique_fields table

[freddyDOTCMS]

Parent Issue

#29459

User Story

When a Contentlet with a Unique Field, a Unique Field itself, or a Content Type that contains a Unique Field is deleted, we need to clean up the unique_fields table. Here's what to do in each case:

Deleting a Contentlet with a Unique Field: Look for the record containing this Contentlet by checking the contents_id property in the supporting_values JSON field. If the list contains multiple Contentlets, remove the specific Contentlet from the list. If it contains only one Contentlet, remove the entire record.

Deleting a Unique Field: Using the field variable attribute in the supporting_values JSON field, locate all records related to the field and delete them.

Deleting a Content Type with at least one Unique Field: Use the Content Type ID in the supporting_values JSON field and delete all corresponding records.

We also need to implement several API/Factory methods to handle these cases.

Acceptance Criteria

Clean up the unique_fields table

Proposed Objective

Core Features

Proposed Priority

Priority 2 - Important

External Links... Slack Conversations, Support Tickets, Figma Designs, etc.

No response

Assumptions & Initiation Needs

No response

Quality Assurance Notes & Workarounds

No response

Sub-Tasks & Estimates

No response