Redundant index for circles_membership.single_id

How to use GitHub

• Please use the 👍 reaction to show that you are affected by the same issue.
• Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
• Subscribe to receive notifications on status change and new comments.

Steps to reproduce

1. Install the app
2. Look at the db schema

Expected behaviour

Efficient use of database indices

Actual behaviour

circles_membership.PRIMARY and circles_membership.IDX_8FC816EAE7C1D92B cover single_id.

This leads to unnecessary index maintanance, more storage consumption and buffer pool bottlenecks due to plan instability.

Server configuration

Web server: Apache/Nginx

Database: MySQL/Maria/SQLite/PostgreSQL

PHP version: 8.1/8.2/8.3

Nextcloud version: (see Nextcloud admin page)

If you have access to your command line run e.g.:
sudo -u www-data php occ app:list
from within your Nextcloud installation folder

If you have access to your command line run e.g.:
sudo -u www-data php occ config:list system
from within your Nextcloud installation folder

Browser

Browser name: Firefox/Chrome/Safari/…

Browser version: 124/125/…

Operating system: Windows/Ubuntu/Mac/…

Insert your browser log here, this could for example include:
a) The javascript console log
b) The network log
c) ...

Start with the database schema or migration defining circles_membership and inspect the PRIMARY and IDX_8FC816EAE7C1D92B definitions for single_id. Done means the redundant index is no longer present while the needed primary-key coverage remains; verify the resulting schema on a supported database.