Duplicated index

[ChristophWurst]

Describe the bug

There is an index that duplicates the primary key.

To Reproduce
Steps to reproduce the behavior:

1. Install the app

Expected behavior
Efficient index usage

social/lib/Migration/Version1000Date20221118000001.php

Lines 699 to 701 in 256c106

	$table->setPrimaryKey(['nid']);
	$table->addUniqueIndex(['id_prim']);
	$table->addUniqueIndex(['nid']);

[ChristophWurst]

# Uniqueness of UNIQ_981A6B5B43E84A97 ignored because PRIMARY is a duplicate constraint
# UNIQ_981A6B5B43E84A97 is a duplicate of PRIMARY
# Key definitions:
#   UNIQUE KEY `UNIQ_981A6B5B43E84A97` (`nid`),
#   PRIMARY KEY (`nid`),
# Column types:
#	  `nid` bigint(20) unsigned not null
# To remove this duplicate index, execute:
ALTER TABLE `social_stream` DROP INDEX `UNIQ_981A6B5B43E84A97`;