< Summary - Jellyfin

Information
Class: Jellyfin.Server.Implementations.Migrations.AddIndexesAndCollations
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20210320181425_AddIndexesAndCollations.cs
File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20210320181425_AddIndexesAndCollations.Designer.cs
Line coverage
86%
Covered lines: 595
Uncovered lines: 91
Coverable lines: 686
Total lines: 775
Line coverage: 86.7%
Branch coverage
N/A
Covered branches: 0
Total branches: 0
Branch coverage: N/A
Method coverage

Feature is only available for sponsors

Upgrade to PRO version

Coverage history

Coverage history 0 25 50 75 100

Metrics

MethodBranch coverage Crap Score Cyclomatic complexity Line coverage
File 1: Up(...)100%11100%
File 1: Down(...)100%210%
File 2: BuildTargetModel(...)100%11100%

File(s)

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20210320181425_AddIndexesAndCollations.cs

#LineLine coverage
 1#pragma warning disable CS1591
 2#pragma warning disable SA1601
 3
 4using System;
 5using Microsoft.EntityFrameworkCore.Migrations;
 6
 7namespace Jellyfin.Server.Implementations.Migrations
 8{
 9    public partial class AddIndexesAndCollations : Migration
 10    {
 11        protected override void Up(MigrationBuilder migrationBuilder)
 12        {
 2113            migrationBuilder.DropForeignKey(
 2114                name: "FK_ImageInfos_Users_UserId",
 2115                schema: "jellyfin",
 2116                table: "ImageInfos");
 17
 2118            migrationBuilder.DropForeignKey(
 2119                name: "FK_Permissions_Users_Permission_Permissions_Guid",
 2120                schema: "jellyfin",
 2121                table: "Permissions");
 22
 2123            migrationBuilder.DropForeignKey(
 2124                name: "FK_Preferences_Users_Preference_Preferences_Guid",
 2125                schema: "jellyfin",
 2126                table: "Preferences");
 27
 2128            migrationBuilder.DropIndex(
 2129                name: "IX_Preferences_Preference_Preferences_Guid",
 2130                schema: "jellyfin",
 2131                table: "Preferences");
 32
 2133            migrationBuilder.DropIndex(
 2134                name: "IX_Permissions_Permission_Permissions_Guid",
 2135                schema: "jellyfin",
 2136                table: "Permissions");
 37
 2138            migrationBuilder.DropIndex(
 2139                name: "IX_DisplayPreferences_UserId",
 2140                schema: "jellyfin",
 2141                table: "DisplayPreferences");
 42
 2143            migrationBuilder.DropIndex(
 2144                name: "IX_CustomItemDisplayPreferences_UserId",
 2145                schema: "jellyfin",
 2146                table: "CustomItemDisplayPreferences");
 47
 2148            migrationBuilder.AlterColumn<string>(
 2149                name: "Username",
 2150                schema: "jellyfin",
 2151                table: "Users",
 2152                type: "TEXT",
 2153                maxLength: 255,
 2154                nullable: false,
 2155                collation: "NOCASE",
 2156                oldClrType: typeof(string),
 2157                oldType: "TEXT",
 2158                oldMaxLength: 255);
 59
 2160            migrationBuilder.AddColumn<Guid>(
 2161                name: "UserId",
 2162                schema: "jellyfin",
 2163                table: "Preferences",
 2164                type: "TEXT",
 2165                nullable: true);
 66
 2167            migrationBuilder.AddColumn<Guid>(
 2168                name: "UserId",
 2169                schema: "jellyfin",
 2170                table: "Permissions",
 2171                type: "TEXT",
 2172                nullable: true);
 73
 2174            migrationBuilder.Sql("UPDATE Preferences SET UserId = Preference_Preferences_Guid");
 2175            migrationBuilder.Sql("UPDATE Permissions SET UserId = Permission_Permissions_Guid");
 76
 2177            migrationBuilder.CreateIndex(
 2178                name: "IX_Users_Username",
 2179                schema: "jellyfin",
 2180                table: "Users",
 2181                column: "Username",
 2182                unique: true);
 83
 2184            migrationBuilder.CreateIndex(
 2185                name: "IX_Preferences_UserId_Kind",
 2186                schema: "jellyfin",
 2187                table: "Preferences",
 2188                columns: new[] { "UserId", "Kind" },
 2189                unique: true,
 2190                filter: "[UserId] IS NOT NULL");
 91
 2192            migrationBuilder.CreateIndex(
 2193                name: "IX_Permissions_UserId_Kind",
 2194                schema: "jellyfin",
 2195                table: "Permissions",
 2196                columns: new[] { "UserId", "Kind" },
 2197                unique: true,
 2198                filter: "[UserId] IS NOT NULL");
 99
 21100            migrationBuilder.AddForeignKey(
 21101                name: "FK_ImageInfos_Users_UserId",
 21102                schema: "jellyfin",
 21103                table: "ImageInfos",
 21104                column: "UserId",
 21105                principalSchema: "jellyfin",
 21106                principalTable: "Users",
 21107                principalColumn: "Id",
 21108                onDelete: ReferentialAction.Cascade);
 109
 21110            migrationBuilder.AddForeignKey(
 21111                name: "FK_Permissions_Users_UserId",
 21112                schema: "jellyfin",
 21113                table: "Permissions",
 21114                column: "UserId",
 21115                principalSchema: "jellyfin",
 21116                principalTable: "Users",
 21117                principalColumn: "Id",
 21118                onDelete: ReferentialAction.Cascade);
 119
 21120            migrationBuilder.AddForeignKey(
 21121                name: "FK_Preferences_Users_UserId",
 21122                schema: "jellyfin",
 21123                table: "Preferences",
 21124                column: "UserId",
 21125                principalSchema: "jellyfin",
 21126                principalTable: "Users",
 21127                principalColumn: "Id",
 21128                onDelete: ReferentialAction.Cascade);
 21129        }
 130
 131        protected override void Down(MigrationBuilder migrationBuilder)
 132        {
 0133            migrationBuilder.DropForeignKey(
 0134                name: "FK_ImageInfos_Users_UserId",
 0135                schema: "jellyfin",
 0136                table: "ImageInfos");
 137
 0138            migrationBuilder.DropForeignKey(
 0139                name: "FK_Permissions_Users_UserId",
 0140                schema: "jellyfin",
 0141                table: "Permissions");
 142
 0143            migrationBuilder.DropForeignKey(
 0144                name: "FK_Preferences_Users_UserId",
 0145                schema: "jellyfin",
 0146                table: "Preferences");
 147
 0148            migrationBuilder.DropIndex(
 0149                name: "IX_Users_Username",
 0150                schema: "jellyfin",
 0151                table: "Users");
 152
 0153            migrationBuilder.DropIndex(
 0154                name: "IX_Preferences_UserId_Kind",
 0155                schema: "jellyfin",
 0156                table: "Preferences");
 157
 0158            migrationBuilder.DropIndex(
 0159                name: "IX_Permissions_UserId_Kind",
 0160                schema: "jellyfin",
 0161                table: "Permissions");
 162
 0163            migrationBuilder.DropColumn(
 0164                name: "UserId",
 0165                schema: "jellyfin",
 0166                table: "Preferences");
 167
 0168            migrationBuilder.DropColumn(
 0169                name: "UserId",
 0170                schema: "jellyfin",
 0171                table: "Permissions");
 172
 0173            migrationBuilder.AlterColumn<string>(
 0174                name: "Username",
 0175                schema: "jellyfin",
 0176                table: "Users",
 0177                type: "TEXT",
 0178                maxLength: 255,
 0179                nullable: false,
 0180                oldClrType: typeof(string),
 0181                oldType: "TEXT",
 0182                oldMaxLength: 255,
 0183                oldCollation: "NOCASE");
 184
 0185            migrationBuilder.CreateIndex(
 0186                name: "IX_Preferences_Preference_Preferences_Guid",
 0187                schema: "jellyfin",
 0188                table: "Preferences",
 0189                column: "Preference_Preferences_Guid");
 190
 0191            migrationBuilder.CreateIndex(
 0192                name: "IX_Permissions_Permission_Permissions_Guid",
 0193                schema: "jellyfin",
 0194                table: "Permissions",
 0195                column: "Permission_Permissions_Guid");
 196
 0197            migrationBuilder.CreateIndex(
 0198                name: "IX_DisplayPreferences_UserId",
 0199                schema: "jellyfin",
 0200                table: "DisplayPreferences",
 0201                column: "UserId");
 202
 0203            migrationBuilder.CreateIndex(
 0204                name: "IX_CustomItemDisplayPreferences_UserId",
 0205                schema: "jellyfin",
 0206                table: "CustomItemDisplayPreferences",
 0207                column: "UserId");
 208
 0209            migrationBuilder.AddForeignKey(
 0210                name: "FK_ImageInfos_Users_UserId",
 0211                schema: "jellyfin",
 0212                table: "ImageInfos",
 0213                column: "UserId",
 0214                principalSchema: "jellyfin",
 0215                principalTable: "Users",
 0216                principalColumn: "Id",
 0217                onDelete: ReferentialAction.Restrict);
 218
 0219            migrationBuilder.AddForeignKey(
 0220                name: "FK_Permissions_Users_Permission_Permissions_Guid",
 0221                schema: "jellyfin",
 0222                table: "Permissions",
 0223                column: "Permission_Permissions_Guid",
 0224                principalSchema: "jellyfin",
 0225                principalTable: "Users",
 0226                principalColumn: "Id",
 0227                onDelete: ReferentialAction.Restrict);
 228
 0229            migrationBuilder.AddForeignKey(
 0230                name: "FK_Preferences_Users_Preference_Preferences_Guid",
 0231                schema: "jellyfin",
 0232                table: "Preferences",
 0233                column: "Preference_Preferences_Guid",
 0234                principalSchema: "jellyfin",
 0235                principalTable: "Users",
 0236                principalColumn: "Id",
 0237                onDelete: ReferentialAction.Restrict);
 0238        }
 239    }
 240}

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20210320181425_AddIndexesAndCollations.Designer.cs

#LineLine coverage
 1#pragma warning disable CS1591
 2
 3// <auto-generated />
 4using System;
 5using Jellyfin.Database.Implementations;
 6using Microsoft.EntityFrameworkCore;
 7using Microsoft.EntityFrameworkCore.Infrastructure;
 8using Microsoft.EntityFrameworkCore.Migrations;
 9using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
 10
 11namespace Jellyfin.Server.Implementations.Migrations
 12{
 13    [DbContext(typeof(JellyfinDbContext))]
 14    [Migration("20210320181425_AddIndexesAndCollations")]
 15    partial class AddIndexesAndCollations
 16    {
 17        protected override void BuildTargetModel(ModelBuilder modelBuilder)
 18        {
 19#pragma warning disable 612, 618
 2120            modelBuilder
 2121                .HasDefaultSchema("jellyfin")
 2122                .HasAnnotation("ProductVersion", "5.0.3");
 23
 2124            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 2125                {
 2126                    b.Property<int>("Id")
 2127                        .ValueGeneratedOnAdd()
 2128                        .HasColumnType("INTEGER");
 2129
 2130                    b.Property<int>("DayOfWeek")
 2131                        .HasColumnType("INTEGER");
 2132
 2133                    b.Property<double>("EndHour")
 2134                        .HasColumnType("REAL");
 2135
 2136                    b.Property<double>("StartHour")
 2137                        .HasColumnType("REAL");
 2138
 2139                    b.Property<Guid>("UserId")
 2140                        .HasColumnType("TEXT");
 2141
 2142                    b.HasKey("Id");
 2143
 2144                    b.HasIndex("UserId");
 2145
 2146                    b.ToTable("AccessSchedules");
 2147                });
 48
 2149            modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b =>
 2150                {
 2151                    b.Property<int>("Id")
 2152                        .ValueGeneratedOnAdd()
 2153                        .HasColumnType("INTEGER");
 2154
 2155                    b.Property<DateTime>("DateCreated")
 2156                        .HasColumnType("TEXT");
 2157
 2158                    b.Property<string>("ItemId")
 2159                        .HasMaxLength(256)
 2160                        .HasColumnType("TEXT");
 2161
 2162                    b.Property<int>("LogSeverity")
 2163                        .HasColumnType("INTEGER");
 2164
 2165                    b.Property<string>("Name")
 2166                        .IsRequired()
 2167                        .HasMaxLength(512)
 2168                        .HasColumnType("TEXT");
 2169
 2170                    b.Property<string>("Overview")
 2171                        .HasMaxLength(512)
 2172                        .HasColumnType("TEXT");
 2173
 2174                    b.Property<uint>("RowVersion")
 2175                        .IsConcurrencyToken()
 2176                        .HasColumnType("INTEGER");
 2177
 2178                    b.Property<string>("ShortOverview")
 2179                        .HasMaxLength(512)
 2180                        .HasColumnType("TEXT");
 2181
 2182                    b.Property<string>("Type")
 2183                        .IsRequired()
 2184                        .HasMaxLength(256)
 2185                        .HasColumnType("TEXT");
 2186
 2187                    b.Property<Guid>("UserId")
 2188                        .HasColumnType("TEXT");
 2189
 2190                    b.HasKey("Id");
 2191
 2192                    b.ToTable("ActivityLogs");
 2193                });
 94
 2195            modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b =>
 2196                {
 2197                    b.Property<int>("Id")
 2198                        .ValueGeneratedOnAdd()
 2199                        .HasColumnType("INTEGER");
 21100
 21101                    b.Property<string>("Client")
 21102                        .IsRequired()
 21103                        .HasMaxLength(32)
 21104                        .HasColumnType("TEXT");
 21105
 21106                    b.Property<Guid>("ItemId")
 21107                        .HasColumnType("TEXT");
 21108
 21109                    b.Property<string>("Key")
 21110                        .IsRequired()
 21111                        .HasColumnType("TEXT");
 21112
 21113                    b.Property<Guid>("UserId")
 21114                        .HasColumnType("TEXT");
 21115
 21116                    b.Property<string>("Value")
 21117                        .IsRequired()
 21118                        .HasColumnType("TEXT");
 21119
 21120                    b.HasKey("Id");
 21121
 21122                    b.HasIndex("UserId", "ItemId", "Client", "Key")
 21123                        .IsUnique();
 21124
 21125                    b.ToTable("CustomItemDisplayPreferences");
 21126                });
 127
 21128            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21129                {
 21130                    b.Property<int>("Id")
 21131                        .ValueGeneratedOnAdd()
 21132                        .HasColumnType("INTEGER");
 21133
 21134                    b.Property<int>("ChromecastVersion")
 21135                        .HasColumnType("INTEGER");
 21136
 21137                    b.Property<string>("Client")
 21138                        .IsRequired()
 21139                        .HasMaxLength(32)
 21140                        .HasColumnType("TEXT");
 21141
 21142                    b.Property<string>("DashboardTheme")
 21143                        .HasMaxLength(32)
 21144                        .HasColumnType("TEXT");
 21145
 21146                    b.Property<bool>("EnableNextVideoInfoOverlay")
 21147                        .HasColumnType("INTEGER");
 21148
 21149                    b.Property<int?>("IndexBy")
 21150                        .HasColumnType("INTEGER");
 21151
 21152                    b.Property<Guid>("ItemId")
 21153                        .HasColumnType("TEXT");
 21154
 21155                    b.Property<int>("ScrollDirection")
 21156                        .HasColumnType("INTEGER");
 21157
 21158                    b.Property<bool>("ShowBackdrop")
 21159                        .HasColumnType("INTEGER");
 21160
 21161                    b.Property<bool>("ShowSidebar")
 21162                        .HasColumnType("INTEGER");
 21163
 21164                    b.Property<int>("SkipBackwardLength")
 21165                        .HasColumnType("INTEGER");
 21166
 21167                    b.Property<int>("SkipForwardLength")
 21168                        .HasColumnType("INTEGER");
 21169
 21170                    b.Property<string>("TvHome")
 21171                        .HasMaxLength(32)
 21172                        .HasColumnType("TEXT");
 21173
 21174                    b.Property<Guid>("UserId")
 21175                        .HasColumnType("TEXT");
 21176
 21177                    b.HasKey("Id");
 21178
 21179                    b.HasIndex("UserId", "ItemId", "Client")
 21180                        .IsUnique();
 21181
 21182                    b.ToTable("DisplayPreferences");
 21183                });
 184
 21185            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 21186                {
 21187                    b.Property<int>("Id")
 21188                        .ValueGeneratedOnAdd()
 21189                        .HasColumnType("INTEGER");
 21190
 21191                    b.Property<int>("DisplayPreferencesId")
 21192                        .HasColumnType("INTEGER");
 21193
 21194                    b.Property<int>("Order")
 21195                        .HasColumnType("INTEGER");
 21196
 21197                    b.Property<int>("Type")
 21198                        .HasColumnType("INTEGER");
 21199
 21200                    b.HasKey("Id");
 21201
 21202                    b.HasIndex("DisplayPreferencesId");
 21203
 21204                    b.ToTable("HomeSection");
 21205                });
 206
 21207            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21208                {
 21209                    b.Property<int>("Id")
 21210                        .ValueGeneratedOnAdd()
 21211                        .HasColumnType("INTEGER");
 21212
 21213                    b.Property<DateTime>("LastModified")
 21214                        .HasColumnType("TEXT");
 21215
 21216                    b.Property<string>("Path")
 21217                        .IsRequired()
 21218                        .HasMaxLength(512)
 21219                        .HasColumnType("TEXT");
 21220
 21221                    b.Property<Guid?>("UserId")
 21222                        .HasColumnType("TEXT");
 21223
 21224                    b.HasKey("Id");
 21225
 21226                    b.HasIndex("UserId")
 21227                        .IsUnique();
 21228
 21229                    b.ToTable("ImageInfos");
 21230                });
 231
 21232            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 21233                {
 21234                    b.Property<int>("Id")
 21235                        .ValueGeneratedOnAdd()
 21236                        .HasColumnType("INTEGER");
 21237
 21238                    b.Property<string>("Client")
 21239                        .IsRequired()
 21240                        .HasMaxLength(32)
 21241                        .HasColumnType("TEXT");
 21242
 21243                    b.Property<int?>("IndexBy")
 21244                        .HasColumnType("INTEGER");
 21245
 21246                    b.Property<Guid>("ItemId")
 21247                        .HasColumnType("TEXT");
 21248
 21249                    b.Property<bool>("RememberIndexing")
 21250                        .HasColumnType("INTEGER");
 21251
 21252                    b.Property<bool>("RememberSorting")
 21253                        .HasColumnType("INTEGER");
 21254
 21255                    b.Property<string>("SortBy")
 21256                        .IsRequired()
 21257                        .HasMaxLength(64)
 21258                        .HasColumnType("TEXT");
 21259
 21260                    b.Property<int>("SortOrder")
 21261                        .HasColumnType("INTEGER");
 21262
 21263                    b.Property<Guid>("UserId")
 21264                        .HasColumnType("TEXT");
 21265
 21266                    b.Property<int>("ViewType")
 21267                        .HasColumnType("INTEGER");
 21268
 21269                    b.HasKey("Id");
 21270
 21271                    b.HasIndex("UserId");
 21272
 21273                    b.ToTable("ItemDisplayPreferences");
 21274                });
 275
 21276            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21277                {
 21278                    b.Property<int>("Id")
 21279                        .ValueGeneratedOnAdd()
 21280                        .HasColumnType("INTEGER");
 21281
 21282                    b.Property<int>("Kind")
 21283                        .HasColumnType("INTEGER");
 21284
 21285                    b.Property<Guid?>("Permission_Permissions_Guid")
 21286                        .HasColumnType("TEXT");
 21287
 21288                    b.Property<uint>("RowVersion")
 21289                        .IsConcurrencyToken()
 21290                        .HasColumnType("INTEGER");
 21291
 21292                    b.Property<Guid?>("UserId")
 21293                        .HasColumnType("TEXT");
 21294
 21295                    b.Property<bool>("Value")
 21296                        .HasColumnType("INTEGER");
 21297
 21298                    b.HasKey("Id");
 21299
 21300                    b.HasIndex("UserId", "Kind")
 21301                        .IsUnique()
 21302                        .HasFilter("[UserId] IS NOT NULL");
 21303
 21304                    b.ToTable("Permissions");
 21305                });
 306
 21307            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21308                {
 21309                    b.Property<int>("Id")
 21310                        .ValueGeneratedOnAdd()
 21311                        .HasColumnType("INTEGER");
 21312
 21313                    b.Property<int>("Kind")
 21314                        .HasColumnType("INTEGER");
 21315
 21316                    b.Property<Guid?>("Preference_Preferences_Guid")
 21317                        .HasColumnType("TEXT");
 21318
 21319                    b.Property<uint>("RowVersion")
 21320                        .IsConcurrencyToken()
 21321                        .HasColumnType("INTEGER");
 21322
 21323                    b.Property<Guid?>("UserId")
 21324                        .HasColumnType("TEXT");
 21325
 21326                    b.Property<string>("Value")
 21327                        .IsRequired()
 21328                        .HasMaxLength(65535)
 21329                        .HasColumnType("TEXT");
 21330
 21331                    b.HasKey("Id");
 21332
 21333                    b.HasIndex("UserId", "Kind")
 21334                        .IsUnique()
 21335                        .HasFilter("[UserId] IS NOT NULL");
 21336
 21337                    b.ToTable("Preferences");
 21338                });
 339
 21340            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 21341                {
 21342                    b.Property<Guid>("Id")
 21343                        .ValueGeneratedOnAdd()
 21344                        .HasColumnType("TEXT");
 21345
 21346                    b.Property<string>("AudioLanguagePreference")
 21347                        .HasMaxLength(255)
 21348                        .HasColumnType("TEXT");
 21349
 21350                    b.Property<string>("AuthenticationProviderId")
 21351                        .IsRequired()
 21352                        .HasMaxLength(255)
 21353                        .HasColumnType("TEXT");
 21354
 21355                    b.Property<bool>("DisplayCollectionsView")
 21356                        .HasColumnType("INTEGER");
 21357
 21358                    b.Property<bool>("DisplayMissingEpisodes")
 21359                        .HasColumnType("INTEGER");
 21360
 21361                    b.Property<string>("EasyPassword")
 21362                        .HasMaxLength(65535)
 21363                        .HasColumnType("TEXT");
 21364
 21365                    b.Property<bool>("EnableAutoLogin")
 21366                        .HasColumnType("INTEGER");
 21367
 21368                    b.Property<bool>("EnableLocalPassword")
 21369                        .HasColumnType("INTEGER");
 21370
 21371                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 21372                        .HasColumnType("INTEGER");
 21373
 21374                    b.Property<bool>("EnableUserPreferenceAccess")
 21375                        .HasColumnType("INTEGER");
 21376
 21377                    b.Property<bool>("HidePlayedInLatest")
 21378                        .HasColumnType("INTEGER");
 21379
 21380                    b.Property<long>("InternalId")
 21381                        .HasColumnType("INTEGER");
 21382
 21383                    b.Property<int>("InvalidLoginAttemptCount")
 21384                        .HasColumnType("INTEGER");
 21385
 21386                    b.Property<DateTime?>("LastActivityDate")
 21387                        .HasColumnType("TEXT");
 21388
 21389                    b.Property<DateTime?>("LastLoginDate")
 21390                        .HasColumnType("TEXT");
 21391
 21392                    b.Property<int?>("LoginAttemptsBeforeLockout")
 21393                        .HasColumnType("INTEGER");
 21394
 21395                    b.Property<int>("MaxActiveSessions")
 21396                        .HasColumnType("INTEGER");
 21397
 21398                    b.Property<int?>("MaxParentalAgeRating")
 21399                        .HasColumnType("INTEGER");
 21400
 21401                    b.Property<bool>("MustUpdatePassword")
 21402                        .HasColumnType("INTEGER");
 21403
 21404                    b.Property<string>("Password")
 21405                        .HasMaxLength(65535)
 21406                        .HasColumnType("TEXT");
 21407
 21408                    b.Property<string>("PasswordResetProviderId")
 21409                        .IsRequired()
 21410                        .HasMaxLength(255)
 21411                        .HasColumnType("TEXT");
 21412
 21413                    b.Property<bool>("PlayDefaultAudioTrack")
 21414                        .HasColumnType("INTEGER");
 21415
 21416                    b.Property<bool>("RememberAudioSelections")
 21417                        .HasColumnType("INTEGER");
 21418
 21419                    b.Property<bool>("RememberSubtitleSelections")
 21420                        .HasColumnType("INTEGER");
 21421
 21422                    b.Property<int?>("RemoteClientBitrateLimit")
 21423                        .HasColumnType("INTEGER");
 21424
 21425                    b.Property<uint>("RowVersion")
 21426                        .IsConcurrencyToken()
 21427                        .HasColumnType("INTEGER");
 21428
 21429                    b.Property<string>("SubtitleLanguagePreference")
 21430                        .HasMaxLength(255)
 21431                        .HasColumnType("TEXT");
 21432
 21433                    b.Property<int>("SubtitleMode")
 21434                        .HasColumnType("INTEGER");
 21435
 21436                    b.Property<int>("SyncPlayAccess")
 21437                        .HasColumnType("INTEGER");
 21438
 21439                    b.Property<string>("Username")
 21440                        .IsRequired()
 21441                        .HasMaxLength(255)
 21442                        .HasColumnType("TEXT")
 21443                        .UseCollation("NOCASE");
 21444
 21445                    b.HasKey("Id");
 21446
 21447                    b.HasIndex("Username")
 21448                        .IsUnique();
 21449
 21450                    b.ToTable("Users");
 21451                });
 452
 21453            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 21454                {
 21455                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21456                        .WithMany("AccessSchedules")
 21457                        .HasForeignKey("UserId")
 21458                        .OnDelete(DeleteBehavior.Cascade)
 21459                        .IsRequired();
 21460                });
 461
 21462            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21463                {
 21464                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21465                        .WithMany("DisplayPreferences")
 21466                        .HasForeignKey("UserId")
 21467                        .OnDelete(DeleteBehavior.Cascade)
 21468                        .IsRequired();
 21469                });
 470
 21471            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 21472                {
 21473                    b.HasOne("Jellyfin.Data.Entities.DisplayPreferences", null)
 21474                        .WithMany("HomeSections")
 21475                        .HasForeignKey("DisplayPreferencesId")
 21476                        .OnDelete(DeleteBehavior.Cascade)
 21477                        .IsRequired();
 21478                });
 479
 21480            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21481                {
 21482                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21483                        .WithOne("ProfileImage")
 21484                        .HasForeignKey("Jellyfin.Data.Entities.ImageInfo", "UserId")
 21485                        .OnDelete(DeleteBehavior.Cascade);
 21486                });
 487
 21488            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 21489                {
 21490                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21491                        .WithMany("ItemDisplayPreferences")
 21492                        .HasForeignKey("UserId")
 21493                        .OnDelete(DeleteBehavior.Cascade)
 21494                        .IsRequired();
 21495                });
 496
 21497            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21498                {
 21499                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21500                        .WithMany("Permissions")
 21501                        .HasForeignKey("UserId")
 21502                        .OnDelete(DeleteBehavior.Cascade);
 21503                });
 504
 21505            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21506                {
 21507                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21508                        .WithMany("Preferences")
 21509                        .HasForeignKey("UserId")
 21510                        .OnDelete(DeleteBehavior.Cascade);
 21511                });
 512
 21513            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21514                {
 21515                    b.Navigation("HomeSections");
 21516                });
 517
 21518            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 21519                {
 21520                    b.Navigation("AccessSchedules");
 21521
 21522                    b.Navigation("DisplayPreferences");
 21523
 21524                    b.Navigation("ItemDisplayPreferences");
 21525
 21526                    b.Navigation("Permissions");
 21527
 21528                    b.Navigation("Preferences");
 21529
 21530                    b.Navigation("ProfileImage");
 21531                });
 532#pragma warning restore 612, 618
 21533        }
 534    }
 535}
Generated by: ReportGenerator 5.4.5.0
4/3/2025 - 12:11:21 AM
GitHub | reportgenerator.io

Methods/Properties

Up(Microsoft.EntityFrameworkCore.Migrations.MigrationBuilder)
Down(Microsoft.EntityFrameworkCore.Migrations.MigrationBuilder)
BuildTargetModel(Microsoft.EntityFrameworkCore.ModelBuilder)