Reduce the maximum length of string primary keys in the EF 6 and EF Core stores #2366
Description
Confirm you've already contributed to this project or that you sponsor it
- I confirm I'm a sponsor or a contributor
Version
7.0.0
Describe the bug
OpenIddict 7.0 increased the maximum length of the OpenIddictTokens.Type column from 50 to 150, which caused a regression with MySQL/MariaDB, as the length of the index is now (255 + 50 + 400 + 50) * 4 = 3420 (which exceeds the maximum value supported by MySQL/MariaDB when using utf8mb4).
To fix this issue, we'll have to reduce the length of the Id columns from 255 to 100 in the next major version (by default, OpenIddict uses Guids-as-strings identifiers like ASP.NET Core Identity, so 100 should be more than enough).
To reproduce
Exceptions (if any)
MySql.Data.MySqlClient.MySqlException (0x80004005): Specified key was too long; max key length is 3072 bytes