Integrity constraint violation on Pimcore 10 to 11 upgrade

[NiklasBr]

personalization-bundle/src/Installer.php

Lines 59 to 69 in e8c3be5

	private function addUserPermission(): void
	{
	$db = \Pimcore\Db::get();
	foreach (self::USER_PERMISSIONS as $permission) {
	$db->insert('users_permission_definitions', [
	$db->quoteIdentifier('key') => $permission,
	$db->quoteIdentifier('category') => self::USER_PERMISSIONS_CATEGORY,
	]);
	}
	}

The above throws an error if you used Personalization Bundle in Pimcore 10:

 [ERROR] An exception occurred while executing a query: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'targeting' for key 'users_permission_definitions.PRIMARY'

[github-actions]

Thanks a lot for reporting the issue. We did not consider the issue as "Pimcore:Priority", "Pimcore:ToDo" or "Pimcore:Backlog", so we're not going to work on that anytime soon. Please create a pull request to fix the issue if this is a bug report. We'll then review it as quickly as possible. If you're interested in contributing a feature, please contact us first here before creating a pull request. We'll then decide whether we'd accept it or not. Thanks for your understanding.