Redundant index circles_member_cisi

[ChristophWurst]

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 indices

Actual behaviour

Redundant index circles_member_cisi which is already covered by circles_member_cisiuiutil.

circles/lib/Migration/Version0022Date20220526113601.php

Lines 251 to 255 in faf5c58

	$table->addIndex(
	['circle_id', 'single_id', 'user_id', 'user_type', 'instance', 'level'],
	'circles_member_cisiuiutil'
	);
	$table->addIndex(['circle_id', 'single_id'], 'circles_member_cisi');

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)

List of activated apps

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

Nextcloud configuration

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/…

Browser log

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