[Bug]: Sharing records are not deleted after a file/folder has been permanently deleted

⚠️ This issue respects the following points: ⚠️

• This is a bug, not a question or a configuration/webserver/proxy issue.
• This issue is not already reported on Github OR Nextcloud Community Forum (I've searched it).
• Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• I agree to follow Nextcloud's Code of Conduct.

Bug description

Right now, deleting a file/folder does not delete its corresponding sharing records. After a file/folder has been deleted, sharing records should also be deleted.

Steps to reproduce

1. Create a file/folder
2. Share the created file/folder
3. Permanently delete that file/folder
4. Check table oc_share
   Expect: It's sharing records deleted
   Actual: It's sharing records still exist

Expected behavior

Sharing records should also be removed from the oc_share table.

Nextcloud Server version

28

Operating system

None

PHP engine version

None

Web server

None

Database engine version

None

Is this bug present after an update or on a fresh install?

None

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

• Default user-backend (database)
• LDAP/ Active Directory
• SSO - SAML
• Other

Configuration report

List of activated Apps

Nextcloud Signing status

Nextcloud Logs

Additional info

Reproducible on 28, 29, 30, master

Start by reproducing the four listed steps on a supported Nextcloud version and inspect the oc_share table after permanent deletion. Trace the file or folder deletion path and its sharing-record handling; done means the corresponding sharing records are removed, with regression coverage for the reported behavior.