diff options
Diffstat (limited to 'Jellyfin.Database')
2 files changed, 2 insertions, 6 deletions
diff --git a/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserConfiguration.cs b/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserConfiguration.cs index a369cf656..bcaa3634e 100644 --- a/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserConfiguration.cs +++ b/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/UserConfiguration.cs @@ -13,8 +13,7 @@ namespace Jellyfin.Server.Implementations.ModelConfiguration public void Configure(EntityTypeBuilder<User> builder) { builder - .Property(user => user.Username) - .UseCollation("NOCASE"); + .Property(user => user.Username); builder .HasOne(u => u.ProfileImage) diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs index 01ddd5ec9..ac9ce3be5 100644 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs +++ b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs @@ -12,9 +12,6 @@ namespace Jellyfin.Database.Providers.PgSql.Migrations /// <inheritdoc /> protected override void Up(MigrationBuilder migrationBuilder) { - // shim NOCASE collation with an undefined locale and case-insensitive matching rules. - migrationBuilder.Sql("CREATE COLLATION NOCASE (provider = icu, locale = 'und-x-icu.utf8', deterministic = false)"); - migrationBuilder.CreateTable( name: "ActivityLogs", columns: table => new @@ -230,7 +227,7 @@ namespace Jellyfin.Database.Providers.PgSql.Migrations columns: table => new { Id = table.Column<Guid>(type: "uuid", nullable: false), - Username = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false, collation: "NOCASE"), + Username = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), Password = table.Column<string>(type: "character varying(65535)", maxLength: 65535, nullable: true), MustUpdatePassword = table.Column<bool>(type: "boolean", nullable: false), AudioLanguagePreference = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), |