The index actually differs from the one defined in the update script:
https://github.com/matomo-org/matomo/blob/1fa10c628c751d43b346a909e68833d26d5c08ff/core/Updates/4.0.0-b1.php#L105
Not sure if the index on name
was on purpose. If so we need to limit the field or the index
fixes #16811
@diosmosis which one is the correct index? the one in the update script or the schema?
I don't think we want an index on name, not sure why that was in there.