< Summary - Jellyfin

Information
Class: Jellyfin.Database.Providers.Sqlite.Migrations.IndexOptimizations
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260206224832_IndexOptimizations.cs
File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260206224832_IndexOptimizations.Designer.cs
Line coverage
96%
Covered lines: 1774
Uncovered lines: 63
Coverable lines: 1837
Total lines: 1968
Line coverage: 96.5%
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 5/16/2026 - 12:15:55 AM Line coverage: 96.5% (1768/1831) Total lines: 19625/22/2026 - 12:15:17 AM Line coverage: 96.5% (1771/1834) Total lines: 19658/11/2026 - 12:17:00 AM Line coverage: 96.5% (1774/1837) Total lines: 1968

Coverage delta

Coverage delta 1 -1

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/20260206224832_IndexOptimizations.cs

#LineLine coverage
 1using Microsoft.EntityFrameworkCore.Migrations;
 2
 3#nullable disable
 4
 5namespace Jellyfin.Database.Providers.Sqlite.Migrations
 6{
 7    /// <inheritdoc />
 8    public partial class IndexOptimizations : Migration
 9    {
 10        /// <inheritdoc />
 11        protected override void Up(MigrationBuilder migrationBuilder)
 12        {
 2713            migrationBuilder.DropIndex(
 2714                name: "IX_MediaStreamInfos_StreamIndex",
 2715                table: "MediaStreamInfos");
 16
 2717            migrationBuilder.DropIndex(
 2718                name: "IX_MediaStreamInfos_StreamIndex_StreamType",
 2719                table: "MediaStreamInfos");
 20
 2721            migrationBuilder.DropIndex(
 2722                name: "IX_MediaStreamInfos_StreamIndex_StreamType_Language",
 2723                table: "MediaStreamInfos");
 24
 2725            migrationBuilder.DropIndex(
 2726                name: "IX_MediaStreamInfos_StreamType",
 2727                table: "MediaStreamInfos");
 28
 2729            migrationBuilder.DropIndex(
 2730                name: "IX_LinkedChildren_ChildId",
 2731                table: "LinkedChildren");
 32
 2733            migrationBuilder.DropIndex(
 2734                name: "IX_LinkedChildren_ParentId",
 2735                table: "LinkedChildren");
 36
 2737            migrationBuilder.DropIndex(
 2738                name: "IX_Devices_DeviceId",
 2739                table: "Devices");
 40
 2741            migrationBuilder.DropIndex(
 2742                name: "IX_BaseItems_ExtraType",
 2743                table: "BaseItems");
 44
 2745            migrationBuilder.DropIndex(
 2746                name: "IX_BaseItems_Id_Type_IsFolder_IsVirtualItem",
 2747                table: "BaseItems");
 48
 2749            migrationBuilder.DropIndex(
 2750                name: "IX_BaseItemProviders_ProviderId_ProviderValue_ItemId",
 2751                table: "BaseItemProviders");
 52
 2753            migrationBuilder.DropIndex(
 2754                name: "IX_BaseItemImageInfos_ItemId",
 2755                table: "BaseItemImageInfos");
 56
 2757            migrationBuilder.CreateIndex(
 2758                name: "IX_BaseItems_SeasonId",
 2759                table: "BaseItems",
 2760                column: "SeasonId");
 61
 2762            migrationBuilder.CreateIndex(
 2763                name: "IX_BaseItems_SeriesId",
 2764                table: "BaseItems",
 2765                column: "SeriesId");
 66
 2767            migrationBuilder.CreateIndex(
 2768                name: "IX_BaseItems_SeriesName",
 2769                table: "BaseItems",
 2770                column: "SeriesName");
 71
 2772            migrationBuilder.CreateIndex(
 2773                name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_ParentIndexNumber_IndexNumber",
 2774                table: "BaseItems",
 2775                columns: new[] { "Type", "SeriesPresentationUniqueKey", "ParentIndexNumber", "IndexNumber" });
 76
 2777            migrationBuilder.CreateIndex(
 2778                name: "IX_BaseItems_Type_TopParentId_SortName",
 2779                table: "BaseItems",
 2780                columns: new[] { "Type", "TopParentId", "SortName" });
 81
 2782            migrationBuilder.CreateIndex(
 2783                name: "IX_BaseItemProviders_ProviderId_ItemId_ProviderValue",
 2784                table: "BaseItemProviders",
 2785                columns: new[] { "ProviderId", "ItemId", "ProviderValue" });
 2786        }
 87
 88        /// <inheritdoc />
 89        protected override void Down(MigrationBuilder migrationBuilder)
 90        {
 091            migrationBuilder.DropIndex(
 092                name: "IX_BaseItems_SeasonId",
 093                table: "BaseItems");
 94
 095            migrationBuilder.DropIndex(
 096                name: "IX_BaseItems_SeriesId",
 097                table: "BaseItems");
 98
 099            migrationBuilder.DropIndex(
 0100                name: "IX_BaseItems_SeriesName",
 0101                table: "BaseItems");
 102
 0103            migrationBuilder.DropIndex(
 0104                name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_ParentIndexNumber_IndexNumber",
 0105                table: "BaseItems");
 106
 0107            migrationBuilder.DropIndex(
 0108                name: "IX_BaseItems_Type_TopParentId_SortName",
 0109                table: "BaseItems");
 110
 0111            migrationBuilder.DropIndex(
 0112                name: "IX_BaseItemProviders_ProviderId_ItemId_ProviderValue",
 0113                table: "BaseItemProviders");
 114
 0115            migrationBuilder.CreateIndex(
 0116                name: "IX_MediaStreamInfos_StreamIndex",
 0117                table: "MediaStreamInfos",
 0118                column: "StreamIndex");
 119
 0120            migrationBuilder.CreateIndex(
 0121                name: "IX_MediaStreamInfos_StreamIndex_StreamType",
 0122                table: "MediaStreamInfos",
 0123                columns: new[] { "StreamIndex", "StreamType" });
 124
 0125            migrationBuilder.CreateIndex(
 0126                name: "IX_MediaStreamInfos_StreamIndex_StreamType_Language",
 0127                table: "MediaStreamInfos",
 0128                columns: new[] { "StreamIndex", "StreamType", "Language" });
 129
 0130            migrationBuilder.CreateIndex(
 0131                name: "IX_MediaStreamInfos_StreamType",
 0132                table: "MediaStreamInfos",
 0133                column: "StreamType");
 134
 0135            migrationBuilder.CreateIndex(
 0136                name: "IX_LinkedChildren_ChildId",
 0137                table: "LinkedChildren",
 0138                column: "ChildId");
 139
 0140            migrationBuilder.CreateIndex(
 0141                name: "IX_LinkedChildren_ParentId",
 0142                table: "LinkedChildren",
 0143                column: "ParentId");
 144
 0145            migrationBuilder.CreateIndex(
 0146                name: "IX_Devices_DeviceId",
 0147                table: "Devices",
 0148                column: "DeviceId");
 149
 0150            migrationBuilder.CreateIndex(
 0151                name: "IX_BaseItems_ExtraType",
 0152                table: "BaseItems",
 0153                column: "ExtraType");
 154
 0155            migrationBuilder.CreateIndex(
 0156                name: "IX_BaseItems_Id_Type_IsFolder_IsVirtualItem",
 0157                table: "BaseItems",
 0158                columns: new[] { "Id", "Type", "IsFolder", "IsVirtualItem" });
 159
 0160            migrationBuilder.CreateIndex(
 0161                name: "IX_BaseItemProviders_ProviderId_ProviderValue_ItemId",
 0162                table: "BaseItemProviders",
 0163                columns: new[] { "ProviderId", "ProviderValue", "ItemId" });
 164
 0165            migrationBuilder.CreateIndex(
 0166                name: "IX_BaseItemImageInfos_ItemId",
 0167                table: "BaseItemImageInfos",
 0168                column: "ItemId");
 0169        }
 170    }
 171}

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260206224832_IndexOptimizations.Designer.cs

#LineLine coverage
 1// <auto-generated />
 2using System;
 3using Jellyfin.Database.Implementations;
 4using Microsoft.EntityFrameworkCore;
 5using Microsoft.EntityFrameworkCore.Infrastructure;
 6using Microsoft.EntityFrameworkCore.Migrations;
 7using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
 8
 9#nullable disable
 10
 11namespace Jellyfin.Database.Providers.Sqlite.Migrations
 12{
 13    [DbContext(typeof(JellyfinDbContext))]
 14    [Migration("20260206224832_IndexOptimizations")]
 15    partial class IndexOptimizations
 16    {
 17        /// <inheritdoc />
 18        protected override void BuildTargetModel(ModelBuilder modelBuilder)
 19        {
 20#pragma warning disable 612, 618
 2721            modelBuilder.HasAnnotation("ProductVersion", "10.0.2");
 22
 2723            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>
 2724                {
 2725                    b.Property<int>("Id")
 2726                        .ValueGeneratedOnAdd()
 2727                        .HasColumnType("INTEGER");
 2728
 2729                    b.Property<int>("DayOfWeek")
 2730                        .HasColumnType("INTEGER");
 2731
 2732                    b.Property<double>("EndHour")
 2733                        .HasColumnType("REAL");
 2734
 2735                    b.Property<double>("StartHour")
 2736                        .HasColumnType("REAL");
 2737
 2738                    b.Property<Guid>("UserId")
 2739                        .HasColumnType("TEXT");
 2740
 2741                    b.HasKey("Id");
 2742
 2743                    b.HasIndex("UserId");
 2744
 2745                    b.ToTable("AccessSchedules");
 2746
 2747                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 2748                });
 49
 2750            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ActivityLog", b =>
 2751                {
 2752                    b.Property<int>("Id")
 2753                        .ValueGeneratedOnAdd()
 2754                        .HasColumnType("INTEGER");
 2755
 2756                    b.Property<DateTime>("DateCreated")
 2757                        .HasColumnType("TEXT");
 2758
 2759                    b.Property<string>("ItemId")
 2760                        .HasMaxLength(256)
 2761                        .HasColumnType("TEXT");
 2762
 2763                    b.Property<int>("LogSeverity")
 2764                        .HasColumnType("INTEGER");
 2765
 2766                    b.Property<string>("Name")
 2767                        .IsRequired()
 2768                        .HasMaxLength(512)
 2769                        .HasColumnType("TEXT");
 2770
 2771                    b.Property<string>("Overview")
 2772                        .HasMaxLength(512)
 2773                        .HasColumnType("TEXT");
 2774
 2775                    b.Property<uint>("RowVersion")
 2776                        .IsConcurrencyToken()
 2777                        .HasColumnType("INTEGER");
 2778
 2779                    b.Property<string>("ShortOverview")
 2780                        .HasMaxLength(512)
 2781                        .HasColumnType("TEXT");
 2782
 2783                    b.Property<string>("Type")
 2784                        .IsRequired()
 2785                        .HasMaxLength(256)
 2786                        .HasColumnType("TEXT");
 2787
 2788                    b.Property<Guid>("UserId")
 2789                        .HasColumnType("TEXT");
 2790
 2791                    b.HasKey("Id");
 2792
 2793                    b.HasIndex("DateCreated");
 2794
 2795                    b.ToTable("ActivityLogs");
 2796
 2797                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 2798                });
 99
 27100            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>
 27101                {
 27102                    b.Property<Guid>("ItemId")
 27103                        .HasColumnType("TEXT");
 27104
 27105                    b.Property<Guid>("ParentItemId")
 27106                        .HasColumnType("TEXT");
 27107
 27108                    b.HasKey("ItemId", "ParentItemId");
 27109
 27110                    b.HasIndex("ParentItemId");
 27111
 27112                    b.ToTable("AncestorIds");
 27113
 27114                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27115                });
 116
 27117            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>
 27118                {
 27119                    b.Property<Guid>("ItemId")
 27120                        .HasColumnType("TEXT");
 27121
 27122                    b.Property<int>("Index")
 27123                        .HasColumnType("INTEGER");
 27124
 27125                    b.Property<string>("Codec")
 27126                        .HasColumnType("TEXT");
 27127
 27128                    b.Property<string>("CodecTag")
 27129                        .HasColumnType("TEXT");
 27130
 27131                    b.Property<string>("Comment")
 27132                        .HasColumnType("TEXT");
 27133
 27134                    b.Property<string>("Filename")
 27135                        .HasColumnType("TEXT");
 27136
 27137                    b.Property<string>("MimeType")
 27138                        .HasColumnType("TEXT");
 27139
 27140                    b.HasKey("ItemId", "Index");
 27141
 27142                    b.ToTable("AttachmentStreamInfos");
 27143
 27144                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27145                });
 146
 27147            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 27148                {
 27149                    b.Property<Guid>("Id")
 27150                        .ValueGeneratedOnAdd()
 27151                        .HasColumnType("TEXT");
 27152
 27153                    b.Property<string>("Album")
 27154                        .HasColumnType("TEXT");
 27155
 27156                    b.Property<string>("AlbumArtists")
 27157                        .HasColumnType("TEXT");
 27158
 27159                    b.Property<string>("Artists")
 27160                        .HasColumnType("TEXT");
 27161
 27162                    b.Property<int?>("Audio")
 27163                        .HasColumnType("INTEGER");
 27164
 27165                    b.Property<Guid?>("ChannelId")
 27166                        .HasColumnType("TEXT");
 27167
 27168                    b.Property<string>("CleanName")
 27169                        .HasColumnType("TEXT");
 27170
 27171                    b.Property<float?>("CommunityRating")
 27172                        .HasColumnType("REAL");
 27173
 27174                    b.Property<float?>("CriticRating")
 27175                        .HasColumnType("REAL");
 27176
 27177                    b.Property<string>("CustomRating")
 27178                        .HasColumnType("TEXT");
 27179
 27180                    b.Property<string>("Data")
 27181                        .HasColumnType("TEXT");
 27182
 27183                    b.Property<DateTime?>("DateCreated")
 27184                        .HasColumnType("TEXT");
 27185
 27186                    b.Property<DateTime?>("DateLastMediaAdded")
 27187                        .HasColumnType("TEXT");
 27188
 27189                    b.Property<DateTime?>("DateLastRefreshed")
 27190                        .HasColumnType("TEXT");
 27191
 27192                    b.Property<DateTime?>("DateLastSaved")
 27193                        .HasColumnType("TEXT");
 27194
 27195                    b.Property<DateTime?>("DateModified")
 27196                        .HasColumnType("TEXT");
 27197
 27198                    b.Property<DateTime?>("EndDate")
 27199                        .HasColumnType("TEXT");
 27200
 27201                    b.Property<string>("EpisodeTitle")
 27202                        .HasColumnType("TEXT");
 27203
 27204                    b.Property<string>("ExternalId")
 27205                        .HasColumnType("TEXT");
 27206
 27207                    b.Property<string>("ExternalSeriesId")
 27208                        .HasColumnType("TEXT");
 27209
 27210                    b.Property<string>("ExternalServiceId")
 27211                        .HasColumnType("TEXT");
 27212
 27213                    b.Property<int?>("ExtraType")
 27214                        .HasColumnType("INTEGER");
 27215
 27216                    b.Property<string>("ForcedSortName")
 27217                        .HasColumnType("TEXT");
 27218
 27219                    b.Property<string>("Genres")
 27220                        .HasColumnType("TEXT");
 27221
 27222                    b.Property<int?>("Height")
 27223                        .HasColumnType("INTEGER");
 27224
 27225                    b.Property<int?>("IndexNumber")
 27226                        .HasColumnType("INTEGER");
 27227
 27228                    b.Property<int?>("InheritedParentalRatingSubValue")
 27229                        .HasColumnType("INTEGER");
 27230
 27231                    b.Property<int?>("InheritedParentalRatingValue")
 27232                        .HasColumnType("INTEGER");
 27233
 27234                    b.Property<bool>("IsFolder")
 27235                        .HasColumnType("INTEGER");
 27236
 27237                    b.Property<bool>("IsInMixedFolder")
 27238                        .HasColumnType("INTEGER");
 27239
 27240                    b.Property<bool>("IsLocked")
 27241                        .HasColumnType("INTEGER");
 27242
 27243                    b.Property<bool>("IsMovie")
 27244                        .HasColumnType("INTEGER");
 27245
 27246                    b.Property<bool>("IsRepeat")
 27247                        .HasColumnType("INTEGER");
 27248
 27249                    b.Property<bool>("IsSeries")
 27250                        .HasColumnType("INTEGER");
 27251
 27252                    b.Property<bool>("IsVirtualItem")
 27253                        .HasColumnType("INTEGER");
 27254
 27255                    b.Property<float?>("LUFS")
 27256                        .HasColumnType("REAL");
 27257
 27258                    b.Property<string>("MediaType")
 27259                        .HasColumnType("TEXT");
 27260
 27261                    b.Property<string>("Name")
 27262                        .HasColumnType("TEXT");
 27263
 27264                    b.Property<float?>("NormalizationGain")
 27265                        .HasColumnType("REAL");
 27266
 27267                    b.Property<string>("OfficialRating")
 27268                        .HasColumnType("TEXT");
 27269
 27270                    b.Property<string>("OriginalLanguage")
 27271                        .HasColumnType("TEXT");
 27272
 27273                    b.Property<string>("OriginalTitle")
 27274                        .HasColumnType("TEXT");
 27275
 27276                    b.Property<string>("Overview")
 27277                        .HasColumnType("TEXT");
 27278
 27279                    b.Property<Guid?>("OwnerId")
 27280                        .HasColumnType("TEXT");
 27281
 27282                    b.Property<Guid?>("ParentId")
 27283                        .HasColumnType("TEXT");
 27284
 27285                    b.Property<int?>("ParentIndexNumber")
 27286                        .HasColumnType("INTEGER");
 27287
 27288                    b.Property<string>("Path")
 27289                        .HasColumnType("TEXT");
 27290
 27291                    b.Property<string>("PreferredMetadataCountryCode")
 27292                        .HasColumnType("TEXT");
 27293
 27294                    b.Property<string>("PreferredMetadataLanguage")
 27295                        .HasColumnType("TEXT");
 27296
 27297                    b.Property<DateTime?>("PremiereDate")
 27298                        .HasColumnType("TEXT");
 27299
 27300                    b.Property<string>("PresentationUniqueKey")
 27301                        .HasColumnType("TEXT");
 27302
 27303                    b.Property<string>("PrimaryVersionId")
 27304                        .HasColumnType("TEXT");
 27305
 27306                    b.Property<string>("ProductionLocations")
 27307                        .HasColumnType("TEXT");
 27308
 27309                    b.Property<int?>("ProductionYear")
 27310                        .HasColumnType("INTEGER");
 27311
 27312                    b.Property<long?>("RunTimeTicks")
 27313                        .HasColumnType("INTEGER");
 27314
 27315                    b.Property<Guid?>("SeasonId")
 27316                        .HasColumnType("TEXT");
 27317
 27318                    b.Property<string>("SeasonName")
 27319                        .HasColumnType("TEXT");
 27320
 27321                    b.Property<Guid?>("SeriesId")
 27322                        .HasColumnType("TEXT");
 27323
 27324                    b.Property<string>("SeriesName")
 27325                        .HasColumnType("TEXT");
 27326
 27327                    b.Property<string>("SeriesPresentationUniqueKey")
 27328                        .HasColumnType("TEXT");
 27329
 27330                    b.Property<string>("ShowId")
 27331                        .HasColumnType("TEXT");
 27332
 27333                    b.Property<long?>("Size")
 27334                        .HasColumnType("INTEGER");
 27335
 27336                    b.Property<string>("SortName")
 27337                        .HasColumnType("TEXT");
 27338
 27339                    b.Property<DateTime?>("StartDate")
 27340                        .HasColumnType("TEXT");
 27341
 27342                    b.Property<string>("Studios")
 27343                        .HasColumnType("TEXT");
 27344
 27345                    b.Property<string>("Tagline")
 27346                        .HasColumnType("TEXT");
 27347
 27348                    b.Property<string>("Tags")
 27349                        .HasColumnType("TEXT");
 27350
 27351                    b.Property<Guid?>("TopParentId")
 27352                        .HasColumnType("TEXT");
 27353
 27354                    b.Property<int?>("TotalBitrate")
 27355                        .HasColumnType("INTEGER");
 27356
 27357                    b.Property<string>("Type")
 27358                        .IsRequired()
 27359                        .HasColumnType("TEXT");
 27360
 27361                    b.Property<string>("UnratedType")
 27362                        .HasColumnType("TEXT");
 27363
 27364                    b.Property<int?>("Width")
 27365                        .HasColumnType("INTEGER");
 27366
 27367                    b.HasKey("Id");
 27368
 27369                    b.HasIndex("Name");
 27370
 27371                    b.HasIndex("OwnerId");
 27372
 27373                    b.HasIndex("ParentId");
 27374
 27375                    b.HasIndex("Path");
 27376
 27377                    b.HasIndex("PresentationUniqueKey");
 27378
 27379                    b.HasIndex("SeasonId");
 27380
 27381                    b.HasIndex("SeriesId");
 27382
 27383                    b.HasIndex("SeriesName");
 27384
 27385                    b.HasIndex("ExtraType", "OwnerId");
 27386
 27387                    b.HasIndex("TopParentId", "Id");
 27388
 27389                    b.HasIndex("Type", "TopParentId", "Id");
 27390
 27391                    b.HasIndex("Type", "TopParentId", "PresentationUniqueKey");
 27392
 27393                    b.HasIndex("Type", "TopParentId", "SortName");
 27394
 27395                    b.HasIndex("Type", "TopParentId", "StartDate");
 27396
 27397                    b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey");
 27398
 27399                    b.HasIndex("TopParentId", "IsFolder", "IsVirtualItem", "DateCreated");
 27400
 27401                    b.HasIndex("TopParentId", "MediaType", "IsVirtualItem", "DateCreated");
 27402
 27403                    b.HasIndex("TopParentId", "Type", "IsVirtualItem", "DateCreated");
 27404
 27405                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem");
 27406
 27407                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "ParentIndexNumber", "IndexNumber");
 27408
 27409                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName");
 27410
 27411                    b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 27412
 27413                    b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 27414
 27415                    b.ToTable("BaseItems");
 27416
 27417                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27418
 27419                    b.HasData(
 27420                        new
 27421                        {
 27422                            Id = new Guid("00000000-0000-0000-0000-000000000001"),
 27423                            IsFolder = false,
 27424                            IsInMixedFolder = false,
 27425                            IsLocked = false,
 27426                            IsMovie = false,
 27427                            IsRepeat = false,
 27428                            IsSeries = false,
 27429                            IsVirtualItem = false,
 27430                            Name = "This is a placeholder item for UserData that has been detached from its original ite
 27431                            Type = "PLACEHOLDER"
 27432                        });
 27433                });
 434
 27435            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 27436                {
 27437                    b.Property<Guid>("Id")
 27438                        .ValueGeneratedOnAdd()
 27439                        .HasColumnType("TEXT");
 27440
 27441                    b.Property<byte[]>("Blurhash")
 27442                        .HasColumnType("BLOB");
 27443
 27444                    b.Property<DateTime?>("DateModified")
 27445                        .HasColumnType("TEXT");
 27446
 27447                    b.Property<int>("Height")
 27448                        .HasColumnType("INTEGER");
 27449
 27450                    b.Property<int>("ImageType")
 27451                        .HasColumnType("INTEGER");
 27452
 27453                    b.Property<Guid>("ItemId")
 27454                        .HasColumnType("TEXT");
 27455
 27456                    b.Property<string>("Path")
 27457                        .IsRequired()
 27458                        .HasColumnType("TEXT");
 27459
 27460                    b.Property<int>("Width")
 27461                        .HasColumnType("INTEGER");
 27462
 27463                    b.HasKey("Id");
 27464
 27465                    b.HasIndex("ItemId", "ImageType");
 27466
 27467                    b.ToTable("BaseItemImageInfos");
 27468
 27469                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27470                });
 471
 27472            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 27473                {
 27474                    b.Property<int>("Id")
 27475                        .HasColumnType("INTEGER");
 27476
 27477                    b.Property<Guid>("ItemId")
 27478                        .HasColumnType("TEXT");
 27479
 27480                    b.HasKey("Id", "ItemId");
 27481
 27482                    b.HasIndex("ItemId");
 27483
 27484                    b.ToTable("BaseItemMetadataFields");
 27485
 27486                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27487                });
 488
 27489            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 27490                {
 27491                    b.Property<Guid>("ItemId")
 27492                        .HasColumnType("TEXT");
 27493
 27494                    b.Property<string>("ProviderId")
 27495                        .HasColumnType("TEXT");
 27496
 27497                    b.Property<string>("ProviderValue")
 27498                        .IsRequired()
 27499                        .HasColumnType("TEXT");
 27500
 27501                    b.HasKey("ItemId", "ProviderId");
 27502
 27503                    b.HasIndex("ProviderId", "ItemId", "ProviderValue");
 27504
 27505                    b.ToTable("BaseItemProviders");
 27506
 27507                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27508                });
 509
 27510            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 27511                {
 27512                    b.Property<int>("Id")
 27513                        .HasColumnType("INTEGER");
 27514
 27515                    b.Property<Guid>("ItemId")
 27516                        .HasColumnType("TEXT");
 27517
 27518                    b.HasKey("Id", "ItemId");
 27519
 27520                    b.HasIndex("ItemId");
 27521
 27522                    b.ToTable("BaseItemTrailerTypes");
 27523
 27524                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27525                });
 526
 27527            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 27528                {
 27529                    b.Property<Guid>("ItemId")
 27530                        .HasColumnType("TEXT");
 27531
 27532                    b.Property<int>("ChapterIndex")
 27533                        .HasColumnType("INTEGER");
 27534
 27535                    b.Property<DateTime?>("ImageDateModified")
 27536                        .HasColumnType("TEXT");
 27537
 27538                    b.Property<string>("ImagePath")
 27539                        .HasColumnType("TEXT");
 27540
 27541                    b.Property<string>("Name")
 27542                        .HasColumnType("TEXT");
 27543
 27544                    b.Property<long>("StartPositionTicks")
 27545                        .HasColumnType("INTEGER");
 27546
 27547                    b.HasKey("ItemId", "ChapterIndex");
 27548
 27549                    b.ToTable("Chapters");
 27550
 27551                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27552                });
 553
 27554            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.CustomItemDisplayPreferences", b =>
 27555                {
 27556                    b.Property<int>("Id")
 27557                        .ValueGeneratedOnAdd()
 27558                        .HasColumnType("INTEGER");
 27559
 27560                    b.Property<string>("Client")
 27561                        .IsRequired()
 27562                        .HasMaxLength(32)
 27563                        .HasColumnType("TEXT");
 27564
 27565                    b.Property<Guid>("ItemId")
 27566                        .HasColumnType("TEXT");
 27567
 27568                    b.Property<string>("Key")
 27569                        .IsRequired()
 27570                        .HasColumnType("TEXT");
 27571
 27572                    b.Property<Guid>("UserId")
 27573                        .HasColumnType("TEXT");
 27574
 27575                    b.Property<string>("Value")
 27576                        .HasColumnType("TEXT");
 27577
 27578                    b.HasKey("Id");
 27579
 27580                    b.HasIndex("UserId", "ItemId", "Client", "Key")
 27581                        .IsUnique();
 27582
 27583                    b.ToTable("CustomItemDisplayPreferences");
 27584
 27585                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27586                });
 587
 27588            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 27589                {
 27590                    b.Property<int>("Id")
 27591                        .ValueGeneratedOnAdd()
 27592                        .HasColumnType("INTEGER");
 27593
 27594                    b.Property<int>("ChromecastVersion")
 27595                        .HasColumnType("INTEGER");
 27596
 27597                    b.Property<string>("Client")
 27598                        .IsRequired()
 27599                        .HasMaxLength(32)
 27600                        .HasColumnType("TEXT");
 27601
 27602                    b.Property<string>("DashboardTheme")
 27603                        .HasMaxLength(32)
 27604                        .HasColumnType("TEXT");
 27605
 27606                    b.Property<bool>("EnableNextVideoInfoOverlay")
 27607                        .HasColumnType("INTEGER");
 27608
 27609                    b.Property<int?>("IndexBy")
 27610                        .HasColumnType("INTEGER");
 27611
 27612                    b.Property<Guid>("ItemId")
 27613                        .HasColumnType("TEXT");
 27614
 27615                    b.Property<int>("ScrollDirection")
 27616                        .HasColumnType("INTEGER");
 27617
 27618                    b.Property<bool>("ShowBackdrop")
 27619                        .HasColumnType("INTEGER");
 27620
 27621                    b.Property<bool>("ShowSidebar")
 27622                        .HasColumnType("INTEGER");
 27623
 27624                    b.Property<int>("SkipBackwardLength")
 27625                        .HasColumnType("INTEGER");
 27626
 27627                    b.Property<int>("SkipForwardLength")
 27628                        .HasColumnType("INTEGER");
 27629
 27630                    b.Property<string>("TvHome")
 27631                        .HasMaxLength(32)
 27632                        .HasColumnType("TEXT");
 27633
 27634                    b.Property<Guid>("UserId")
 27635                        .HasColumnType("TEXT");
 27636
 27637                    b.HasKey("Id");
 27638
 27639                    b.HasIndex("UserId", "ItemId", "Client")
 27640                        .IsUnique();
 27641
 27642                    b.ToTable("DisplayPreferences");
 27643
 27644                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27645                });
 646
 27647            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 27648                {
 27649                    b.Property<int>("Id")
 27650                        .ValueGeneratedOnAdd()
 27651                        .HasColumnType("INTEGER");
 27652
 27653                    b.Property<int>("DisplayPreferencesId")
 27654                        .HasColumnType("INTEGER");
 27655
 27656                    b.Property<int>("Order")
 27657                        .HasColumnType("INTEGER");
 27658
 27659                    b.Property<int>("Type")
 27660                        .HasColumnType("INTEGER");
 27661
 27662                    b.HasKey("Id");
 27663
 27664                    b.HasIndex("DisplayPreferencesId");
 27665
 27666                    b.ToTable("HomeSection");
 27667
 27668                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27669                });
 670
 27671            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 27672                {
 27673                    b.Property<int>("Id")
 27674                        .ValueGeneratedOnAdd()
 27675                        .HasColumnType("INTEGER");
 27676
 27677                    b.Property<DateTime>("LastModified")
 27678                        .HasColumnType("TEXT");
 27679
 27680                    b.Property<string>("Path")
 27681                        .IsRequired()
 27682                        .HasMaxLength(512)
 27683                        .HasColumnType("TEXT");
 27684
 27685                    b.Property<Guid?>("UserId")
 27686                        .HasColumnType("TEXT");
 27687
 27688                    b.HasKey("Id");
 27689
 27690                    b.HasIndex("UserId")
 27691                        .IsUnique();
 27692
 27693                    b.ToTable("ImageInfos");
 27694
 27695                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27696                });
 697
 27698            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 27699                {
 27700                    b.Property<int>("Id")
 27701                        .ValueGeneratedOnAdd()
 27702                        .HasColumnType("INTEGER");
 27703
 27704                    b.Property<string>("Client")
 27705                        .IsRequired()
 27706                        .HasMaxLength(32)
 27707                        .HasColumnType("TEXT");
 27708
 27709                    b.Property<int?>("IndexBy")
 27710                        .HasColumnType("INTEGER");
 27711
 27712                    b.Property<Guid>("ItemId")
 27713                        .HasColumnType("TEXT");
 27714
 27715                    b.Property<bool>("RememberIndexing")
 27716                        .HasColumnType("INTEGER");
 27717
 27718                    b.Property<bool>("RememberSorting")
 27719                        .HasColumnType("INTEGER");
 27720
 27721                    b.Property<string>("SortBy")
 27722                        .IsRequired()
 27723                        .HasMaxLength(64)
 27724                        .HasColumnType("TEXT");
 27725
 27726                    b.Property<int>("SortOrder")
 27727                        .HasColumnType("INTEGER");
 27728
 27729                    b.Property<Guid>("UserId")
 27730                        .HasColumnType("TEXT");
 27731
 27732                    b.Property<int>("ViewType")
 27733                        .HasColumnType("INTEGER");
 27734
 27735                    b.HasKey("Id");
 27736
 27737                    b.HasIndex("UserId");
 27738
 27739                    b.ToTable("ItemDisplayPreferences");
 27740
 27741                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27742                });
 743
 27744            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 27745                {
 27746                    b.Property<Guid>("ItemValueId")
 27747                        .ValueGeneratedOnAdd()
 27748                        .HasColumnType("TEXT");
 27749
 27750                    b.Property<string>("CleanValue")
 27751                        .IsRequired()
 27752                        .HasColumnType("TEXT");
 27753
 27754                    b.Property<int>("Type")
 27755                        .HasColumnType("INTEGER");
 27756
 27757                    b.Property<string>("Value")
 27758                        .IsRequired()
 27759                        .HasColumnType("TEXT");
 27760
 27761                    b.HasKey("ItemValueId");
 27762
 27763                    b.HasIndex("Type", "CleanValue");
 27764
 27765                    b.HasIndex("Type", "Value")
 27766                        .IsUnique();
 27767
 27768                    b.ToTable("ItemValues");
 27769
 27770                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27771                });
 772
 27773            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 27774                {
 27775                    b.Property<Guid>("ItemValueId")
 27776                        .HasColumnType("TEXT");
 27777
 27778                    b.Property<Guid>("ItemId")
 27779                        .HasColumnType("TEXT");
 27780
 27781                    b.HasKey("ItemValueId", "ItemId");
 27782
 27783                    b.HasIndex("ItemId");
 27784
 27785                    b.ToTable("ItemValuesMap");
 27786
 27787                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27788                });
 789
 27790            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 27791                {
 27792                    b.Property<Guid>("ItemId")
 27793                        .HasColumnType("TEXT");
 27794
 27795                    b.PrimitiveCollection<string>("KeyframeTicks")
 27796                        .HasColumnType("TEXT");
 27797
 27798                    b.Property<long>("TotalDuration")
 27799                        .HasColumnType("INTEGER");
 27800
 27801                    b.HasKey("ItemId");
 27802
 27803                    b.ToTable("KeyframeData");
 27804
 27805                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27806                });
 807
 27808            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.LinkedChildEntity", b =>
 27809                {
 27810                    b.Property<Guid>("ParentId")
 27811                        .HasColumnType("TEXT");
 27812
 27813                    b.Property<Guid>("ChildId")
 27814                        .HasColumnType("TEXT");
 27815
 27816                    b.Property<int>("ChildType")
 27817                        .HasColumnType("INTEGER");
 27818
 27819                    b.Property<int?>("SortOrder")
 27820                        .HasColumnType("INTEGER");
 27821
 27822                    b.HasKey("ParentId", "ChildId");
 27823
 27824                    b.HasIndex("ChildId", "ChildType");
 27825
 27826                    b.HasIndex("ParentId", "ChildType");
 27827
 27828                    b.HasIndex("ParentId", "SortOrder");
 27829
 27830                    b.ToTable("LinkedChildren", (string)null);
 27831
 27832                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27833                });
 834
 27835            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaSegment", b =>
 27836                {
 27837                    b.Property<Guid>("Id")
 27838                        .ValueGeneratedOnAdd()
 27839                        .HasColumnType("TEXT");
 27840
 27841                    b.Property<long>("EndTicks")
 27842                        .HasColumnType("INTEGER");
 27843
 27844                    b.Property<Guid>("ItemId")
 27845                        .HasColumnType("TEXT");
 27846
 27847                    b.Property<string>("SegmentProviderId")
 27848                        .IsRequired()
 27849                        .HasColumnType("TEXT");
 27850
 27851                    b.Property<long>("StartTicks")
 27852                        .HasColumnType("INTEGER");
 27853
 27854                    b.Property<int>("Type")
 27855                        .HasColumnType("INTEGER");
 27856
 27857                    b.HasKey("Id");
 27858
 27859                    b.ToTable("MediaSegments");
 27860
 27861                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 27862                });
 863
 27864            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 27865                {
 27866                    b.Property<Guid>("ItemId")
 27867                        .HasColumnType("TEXT");
 27868
 27869                    b.Property<int>("StreamIndex")
 27870                        .HasColumnType("INTEGER");
 27871
 27872                    b.Property<string>("AspectRatio")
 27873                        .HasColumnType("TEXT");
 27874
 27875                    b.Property<float?>("AverageFrameRate")
 27876                        .HasColumnType("REAL");
 27877
 27878                    b.Property<int?>("BitDepth")
 27879                        .HasColumnType("INTEGER");
 27880
 27881                    b.Property<int?>("BitRate")
 27882                        .HasColumnType("INTEGER");
 27883
 27884                    b.Property<int?>("BlPresentFlag")
 27885                        .HasColumnType("INTEGER");
 27886
 27887                    b.Property<string>("ChannelLayout")
 27888                        .HasColumnType("TEXT");
 27889
 27890                    b.Property<int?>("Channels")
 27891                        .HasColumnType("INTEGER");
 27892
 27893                    b.Property<string>("Codec")
 27894                        .HasColumnType("TEXT");
 27895
 27896                    b.Property<string>("CodecTag")
 27897                        .HasColumnType("TEXT");
 27898
 27899                    b.Property<string>("CodecTimeBase")
 27900                        .HasColumnType("TEXT");
 27901
 27902                    b.Property<string>("ColorPrimaries")
 27903                        .HasColumnType("TEXT");
 27904
 27905                    b.Property<string>("ColorSpace")
 27906                        .HasColumnType("TEXT");
 27907
 27908                    b.Property<string>("ColorTransfer")
 27909                        .HasColumnType("TEXT");
 27910
 27911                    b.Property<string>("Comment")
 27912                        .HasColumnType("TEXT");
 27913
 27914                    b.Property<int?>("DvBlSignalCompatibilityId")
 27915                        .HasColumnType("INTEGER");
 27916
 27917                    b.Property<int?>("DvLevel")
 27918                        .HasColumnType("INTEGER");
 27919
 27920                    b.Property<int?>("DvProfile")
 27921                        .HasColumnType("INTEGER");
 27922
 27923                    b.Property<int?>("DvVersionMajor")
 27924                        .HasColumnType("INTEGER");
 27925
 27926                    b.Property<int?>("DvVersionMinor")
 27927                        .HasColumnType("INTEGER");
 27928
 27929                    b.Property<int?>("ElPresentFlag")
 27930                        .HasColumnType("INTEGER");
 27931
 27932                    b.Property<bool?>("Hdr10PlusPresentFlag")
 27933                        .HasColumnType("INTEGER");
 27934
 27935                    b.Property<int?>("Height")
 27936                        .HasColumnType("INTEGER");
 27937
 27938                    b.Property<bool?>("IsAnamorphic")
 27939                        .HasColumnType("INTEGER");
 27940
 27941                    b.Property<bool?>("IsAvc")
 27942                        .HasColumnType("INTEGER");
 27943
 27944                    b.Property<bool>("IsDefault")
 27945                        .HasColumnType("INTEGER");
 27946
 27947                    b.Property<bool>("IsExternal")
 27948                        .HasColumnType("INTEGER");
 27949
 27950                    b.Property<bool>("IsForced")
 27951                        .HasColumnType("INTEGER");
 27952
 27953                    b.Property<bool?>("IsHearingImpaired")
 27954                        .HasColumnType("INTEGER");
 27955
 27956                    b.Property<bool?>("IsInterlaced")
 27957                        .HasColumnType("INTEGER");
 27958
 27959                    b.Property<bool>("IsOriginal")
 27960                        .HasColumnType("INTEGER");
 27961
 27962                    b.Property<string>("KeyFrames")
 27963                        .HasColumnType("TEXT");
 27964
 27965                    b.Property<string>("Language")
 27966                        .HasColumnType("TEXT");
 27967
 27968                    b.Property<float?>("Level")
 27969                        .HasColumnType("REAL");
 27970
 27971                    b.Property<string>("NalLengthSize")
 27972                        .HasColumnType("TEXT");
 27973
 27974                    b.Property<string>("Path")
 27975                        .HasColumnType("TEXT");
 27976
 27977                    b.Property<string>("PixelFormat")
 27978                        .HasColumnType("TEXT");
 27979
 27980                    b.Property<string>("Profile")
 27981                        .HasColumnType("TEXT");
 27982
 27983                    b.Property<float?>("RealFrameRate")
 27984                        .HasColumnType("REAL");
 27985
 27986                    b.Property<int?>("RefFrames")
 27987                        .HasColumnType("INTEGER");
 27988
 27989                    b.Property<int?>("Rotation")
 27990                        .HasColumnType("INTEGER");
 27991
 27992                    b.Property<int?>("RpuPresentFlag")
 27993                        .HasColumnType("INTEGER");
 27994
 27995                    b.Property<int?>("SampleRate")
 27996                        .HasColumnType("INTEGER");
 27997
 27998                    b.Property<int>("StreamType")
 27999                        .HasColumnType("INTEGER");
 271000
 271001                    b.Property<string>("TimeBase")
 271002                        .HasColumnType("TEXT");
 271003
 271004                    b.Property<string>("Title")
 271005                        .HasColumnType("TEXT");
 271006
 271007                    b.Property<int?>("Width")
 271008                        .HasColumnType("INTEGER");
 271009
 271010                    b.HasKey("ItemId", "StreamIndex");
 271011
 271012                    b.ToTable("MediaStreamInfos");
 271013
 271014                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271015                });
 1016
 271017            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 271018                {
 271019                    b.Property<Guid>("Id")
 271020                        .ValueGeneratedOnAdd()
 271021                        .HasColumnType("TEXT");
 271022
 271023                    b.Property<string>("Name")
 271024                        .IsRequired()
 271025                        .HasColumnType("TEXT");
 271026
 271027                    b.Property<string>("PersonType")
 271028                        .HasColumnType("TEXT");
 271029
 271030                    b.HasKey("Id");
 271031
 271032                    b.HasIndex("Name");
 271033
 271034                    b.ToTable("Peoples");
 271035
 271036                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271037                });
 1038
 271039            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 271040                {
 271041                    b.Property<Guid>("ItemId")
 271042                        .HasColumnType("TEXT");
 271043
 271044                    b.Property<Guid>("PeopleId")
 271045                        .HasColumnType("TEXT");
 271046
 271047                    b.Property<string>("Role")
 271048                        .HasColumnType("TEXT");
 271049
 271050                    b.Property<int?>("ListOrder")
 271051                        .HasColumnType("INTEGER");
 271052
 271053                    b.Property<int?>("SortOrder")
 271054                        .HasColumnType("INTEGER");
 271055
 271056                    b.HasKey("ItemId", "PeopleId", "Role");
 271057
 271058                    b.HasIndex("PeopleId");
 271059
 271060                    b.HasIndex("ItemId", "ListOrder");
 271061
 271062                    b.HasIndex("ItemId", "SortOrder");
 271063
 271064                    b.ToTable("PeopleBaseItemMap");
 271065
 271066                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271067                });
 1068
 271069            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 271070                {
 271071                    b.Property<int>("Id")
 271072                        .ValueGeneratedOnAdd()
 271073                        .HasColumnType("INTEGER");
 271074
 271075                    b.Property<int>("Kind")
 271076                        .HasColumnType("INTEGER");
 271077
 271078                    b.Property<Guid?>("Permission_Permissions_Guid")
 271079                        .HasColumnType("TEXT");
 271080
 271081                    b.Property<uint>("RowVersion")
 271082                        .IsConcurrencyToken()
 271083                        .HasColumnType("INTEGER");
 271084
 271085                    b.Property<Guid?>("UserId")
 271086                        .HasColumnType("TEXT");
 271087
 271088                    b.Property<bool>("Value")
 271089                        .HasColumnType("INTEGER");
 271090
 271091                    b.HasKey("Id");
 271092
 271093                    b.HasIndex("UserId", "Kind")
 271094                        .IsUnique()
 271095                        .HasFilter("[UserId] IS NOT NULL");
 271096
 271097                    b.ToTable("Permissions");
 271098
 271099                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271100                });
 1101
 271102            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 271103                {
 271104                    b.Property<int>("Id")
 271105                        .ValueGeneratedOnAdd()
 271106                        .HasColumnType("INTEGER");
 271107
 271108                    b.Property<int>("Kind")
 271109                        .HasColumnType("INTEGER");
 271110
 271111                    b.Property<Guid?>("Preference_Preferences_Guid")
 271112                        .HasColumnType("TEXT");
 271113
 271114                    b.Property<uint>("RowVersion")
 271115                        .IsConcurrencyToken()
 271116                        .HasColumnType("INTEGER");
 271117
 271118                    b.Property<Guid?>("UserId")
 271119                        .HasColumnType("TEXT");
 271120
 271121                    b.Property<string>("Value")
 271122                        .IsRequired()
 271123                        .HasMaxLength(65535)
 271124                        .HasColumnType("TEXT");
 271125
 271126                    b.HasKey("Id");
 271127
 271128                    b.HasIndex("UserId", "Kind")
 271129                        .IsUnique()
 271130                        .HasFilter("[UserId] IS NOT NULL");
 271131
 271132                    b.ToTable("Preferences");
 271133
 271134                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271135                });
 1136
 271137            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.ApiKey", b =>
 271138                {
 271139                    b.Property<int>("Id")
 271140                        .ValueGeneratedOnAdd()
 271141                        .HasColumnType("INTEGER");
 271142
 271143                    b.Property<string>("AccessToken")
 271144                        .IsRequired()
 271145                        .HasColumnType("TEXT");
 271146
 271147                    b.Property<DateTime>("DateCreated")
 271148                        .HasColumnType("TEXT");
 271149
 271150                    b.Property<DateTime>("DateLastActivity")
 271151                        .HasColumnType("TEXT");
 271152
 271153                    b.Property<string>("Name")
 271154                        .IsRequired()
 271155                        .HasMaxLength(64)
 271156                        .HasColumnType("TEXT");
 271157
 271158                    b.HasKey("Id");
 271159
 271160                    b.HasIndex("AccessToken")
 271161                        .IsUnique();
 271162
 271163                    b.ToTable("ApiKeys");
 271164
 271165                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271166                });
 1167
 271168            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 271169                {
 271170                    b.Property<int>("Id")
 271171                        .ValueGeneratedOnAdd()
 271172                        .HasColumnType("INTEGER");
 271173
 271174                    b.Property<string>("AccessToken")
 271175                        .IsRequired()
 271176                        .HasColumnType("TEXT");
 271177
 271178                    b.Property<string>("AppName")
 271179                        .IsRequired()
 271180                        .HasMaxLength(64)
 271181                        .HasColumnType("TEXT");
 271182
 271183                    b.Property<string>("AppVersion")
 271184                        .IsRequired()
 271185                        .HasMaxLength(32)
 271186                        .HasColumnType("TEXT");
 271187
 271188                    b.Property<DateTime>("DateCreated")
 271189                        .HasColumnType("TEXT");
 271190
 271191                    b.Property<DateTime>("DateLastActivity")
 271192                        .HasColumnType("TEXT");
 271193
 271194                    b.Property<DateTime>("DateModified")
 271195                        .HasColumnType("TEXT");
 271196
 271197                    b.Property<string>("DeviceId")
 271198                        .IsRequired()
 271199                        .HasMaxLength(256)
 271200                        .HasColumnType("TEXT");
 271201
 271202                    b.Property<string>("DeviceName")
 271203                        .IsRequired()
 271204                        .HasMaxLength(64)
 271205                        .HasColumnType("TEXT");
 271206
 271207                    b.Property<bool>("IsActive")
 271208                        .HasColumnType("INTEGER");
 271209
 271210                    b.Property<Guid>("UserId")
 271211                        .HasColumnType("TEXT");
 271212
 271213                    b.HasKey("Id");
 271214
 271215                    b.HasIndex("AccessToken", "DateLastActivity");
 271216
 271217                    b.HasIndex("DeviceId", "DateLastActivity");
 271218
 271219                    b.HasIndex("UserId", "DeviceId");
 271220
 271221                    b.ToTable("Devices");
 271222
 271223                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271224                });
 1225
 271226            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.DeviceOptions", b =>
 271227                {
 271228                    b.Property<int>("Id")
 271229                        .ValueGeneratedOnAdd()
 271230                        .HasColumnType("INTEGER");
 271231
 271232                    b.Property<string>("CustomName")
 271233                        .HasColumnType("TEXT");
 271234
 271235                    b.Property<string>("DeviceId")
 271236                        .IsRequired()
 271237                        .HasColumnType("TEXT");
 271238
 271239                    b.HasKey("Id");
 271240
 271241                    b.HasIndex("DeviceId")
 271242                        .IsUnique();
 271243
 271244                    b.ToTable("DeviceOptions");
 271245
 271246                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271247                });
 1248
 271249            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.TrickplayInfo", b =>
 271250                {
 271251                    b.Property<Guid>("ItemId")
 271252                        .HasColumnType("TEXT");
 271253
 271254                    b.Property<int>("Width")
 271255                        .HasColumnType("INTEGER");
 271256
 271257                    b.Property<int>("Bandwidth")
 271258                        .HasColumnType("INTEGER");
 271259
 271260                    b.Property<int>("Height")
 271261                        .HasColumnType("INTEGER");
 271262
 271263                    b.Property<int>("Interval")
 271264                        .HasColumnType("INTEGER");
 271265
 271266                    b.Property<int>("ThumbnailCount")
 271267                        .HasColumnType("INTEGER");
 271268
 271269                    b.Property<int>("TileHeight")
 271270                        .HasColumnType("INTEGER");
 271271
 271272                    b.Property<int>("TileWidth")
 271273                        .HasColumnType("INTEGER");
 271274
 271275                    b.HasKey("ItemId", "Width");
 271276
 271277                    b.ToTable("TrickplayInfos");
 271278
 271279                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271280                });
 1281
 271282            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 271283                {
 271284                    b.Property<Guid>("Id")
 271285                        .ValueGeneratedOnAdd()
 271286                        .HasColumnType("TEXT");
 271287
 271288                    b.Property<string>("AudioLanguagePreference")
 271289                        .HasMaxLength(255)
 271290                        .HasColumnType("TEXT");
 271291
 271292                    b.Property<string>("AuthenticationProviderId")
 271293                        .IsRequired()
 271294                        .HasMaxLength(255)
 271295                        .HasColumnType("TEXT");
 271296
 271297                    b.Property<string>("CastReceiverId")
 271298                        .HasMaxLength(32)
 271299                        .HasColumnType("TEXT");
 271300
 271301                    b.Property<bool>("DisplayCollectionsView")
 271302                        .HasColumnType("INTEGER");
 271303
 271304                    b.Property<bool>("DisplayMissingEpisodes")
 271305                        .HasColumnType("INTEGER");
 271306
 271307                    b.Property<bool>("EnableAutoLogin")
 271308                        .HasColumnType("INTEGER");
 271309
 271310                    b.Property<bool>("EnableLocalPassword")
 271311                        .HasColumnType("INTEGER");
 271312
 271313                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 271314                        .HasColumnType("INTEGER");
 271315
 271316                    b.Property<bool>("EnableUserPreferenceAccess")
 271317                        .HasColumnType("INTEGER");
 271318
 271319                    b.Property<bool>("HidePlayedInLatest")
 271320                        .HasColumnType("INTEGER");
 271321
 271322                    b.Property<long>("InternalId")
 271323                        .HasColumnType("INTEGER");
 271324
 271325                    b.Property<int>("InvalidLoginAttemptCount")
 271326                        .HasColumnType("INTEGER");
 271327
 271328                    b.Property<DateTime?>("LastActivityDate")
 271329                        .HasColumnType("TEXT");
 271330
 271331                    b.Property<DateTime?>("LastLoginDate")
 271332                        .HasColumnType("TEXT");
 271333
 271334                    b.Property<int?>("LoginAttemptsBeforeLockout")
 271335                        .HasColumnType("INTEGER");
 271336
 271337                    b.Property<int>("MaxActiveSessions")
 271338                        .HasColumnType("INTEGER");
 271339
 271340                    b.Property<int?>("MaxParentalRatingScore")
 271341                        .HasColumnType("INTEGER");
 271342
 271343                    b.Property<int?>("MaxParentalRatingSubScore")
 271344                        .HasColumnType("INTEGER");
 271345
 271346                    b.Property<bool>("MustUpdatePassword")
 271347                        .HasColumnType("INTEGER");
 271348
 271349                    b.Property<string>("Password")
 271350                        .HasMaxLength(65535)
 271351                        .HasColumnType("TEXT");
 271352
 271353                    b.Property<string>("PasswordResetProviderId")
 271354                        .IsRequired()
 271355                        .HasMaxLength(255)
 271356                        .HasColumnType("TEXT");
 271357
 271358                    b.Property<bool>("PlayDefaultAudioTrack")
 271359                        .HasColumnType("INTEGER");
 271360
 271361                    b.Property<bool>("RememberAudioSelections")
 271362                        .HasColumnType("INTEGER");
 271363
 271364                    b.Property<bool>("RememberSubtitleSelections")
 271365                        .HasColumnType("INTEGER");
 271366
 271367                    b.Property<int?>("RemoteClientBitrateLimit")
 271368                        .HasColumnType("INTEGER");
 271369
 271370                    b.Property<uint>("RowVersion")
 271371                        .IsConcurrencyToken()
 271372                        .HasColumnType("INTEGER");
 271373
 271374                    b.Property<string>("SubtitleLanguagePreference")
 271375                        .HasMaxLength(255)
 271376                        .HasColumnType("TEXT");
 271377
 271378                    b.Property<int>("SubtitleMode")
 271379                        .HasColumnType("INTEGER");
 271380
 271381                    b.Property<int>("SyncPlayAccess")
 271382                        .HasColumnType("INTEGER");
 271383
 271384                    b.Property<string>("Username")
 271385                        .IsRequired()
 271386                        .HasMaxLength(255)
 271387                        .HasColumnType("TEXT");
 271388
 271389                    b.HasKey("Id");
 271390
 271391                    b.HasIndex("Username")
 271392                        .IsUnique();
 271393
 271394                    b.ToTable("Users");
 271395
 271396                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271397                });
 1398
 271399            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 271400                {
 271401                    b.Property<Guid>("ItemId")
 271402                        .HasColumnType("TEXT");
 271403
 271404                    b.Property<Guid>("UserId")
 271405                        .HasColumnType("TEXT");
 271406
 271407                    b.Property<string>("CustomDataKey")
 271408                        .HasColumnType("TEXT");
 271409
 271410                    b.Property<int?>("AudioStreamIndex")
 271411                        .HasColumnType("INTEGER");
 271412
 271413                    b.Property<bool>("IsFavorite")
 271414                        .HasColumnType("INTEGER");
 271415
 271416                    b.Property<DateTime?>("LastPlayedDate")
 271417                        .HasColumnType("TEXT");
 271418
 271419                    b.Property<bool?>("Likes")
 271420                        .HasColumnType("INTEGER");
 271421
 271422                    b.Property<int>("PlayCount")
 271423                        .HasColumnType("INTEGER");
 271424
 271425                    b.Property<long>("PlaybackPositionTicks")
 271426                        .HasColumnType("INTEGER");
 271427
 271428                    b.Property<bool>("Played")
 271429                        .HasColumnType("INTEGER");
 271430
 271431                    b.Property<double?>("Rating")
 271432                        .HasColumnType("REAL");
 271433
 271434                    b.Property<DateTime?>("RetentionDate")
 271435                        .HasColumnType("TEXT");
 271436
 271437                    b.Property<int?>("SubtitleStreamIndex")
 271438                        .HasColumnType("INTEGER");
 271439
 271440                    b.HasKey("ItemId", "UserId", "CustomDataKey");
 271441
 271442                    b.HasIndex("ItemId", "UserId", "IsFavorite");
 271443
 271444                    b.HasIndex("ItemId", "UserId", "LastPlayedDate");
 271445
 271446                    b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks");
 271447
 271448                    b.HasIndex("ItemId", "UserId", "Played");
 271449
 271450                    b.HasIndex("UserId", "IsFavorite", "ItemId");
 271451
 271452                    b.HasIndex("UserId", "ItemId", "LastPlayedDate");
 271453
 271454                    b.HasIndex("UserId", "Played", "ItemId");
 271455
 271456                    b.ToTable("UserData");
 271457
 271458                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 271459                });
 1460
 271461            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>
 271462                {
 271463                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 271464                        .WithMany("AccessSchedules")
 271465                        .HasForeignKey("UserId")
 271466                        .OnDelete(DeleteBehavior.Cascade)
 271467                        .IsRequired();
 271468                });
 1469
 271470            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>
 271471                {
 271472                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271473                        .WithMany("Parents")
 271474                        .HasForeignKey("ItemId")
 271475                        .OnDelete(DeleteBehavior.Cascade)
 271476                        .IsRequired();
 271477
 271478                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "ParentItem")
 271479                        .WithMany("Children")
 271480                        .HasForeignKey("ParentItemId")
 271481                        .OnDelete(DeleteBehavior.Cascade)
 271482                        .IsRequired();
 271483
 271484                    b.Navigation("Item");
 271485
 271486                    b.Navigation("ParentItem");
 271487                });
 1488
 271489            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>
 271490                {
 271491                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271492                        .WithMany()
 271493                        .HasForeignKey("ItemId")
 271494                        .OnDelete(DeleteBehavior.Cascade)
 271495                        .IsRequired();
 271496
 271497                    b.Navigation("Item");
 271498                });
 1499
 271500            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 271501                {
 271502                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Owner")
 271503                        .WithMany("Extras")
 271504                        .HasForeignKey("OwnerId")
 271505                        .OnDelete(DeleteBehavior.NoAction);
 271506
 271507                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "DirectParent")
 271508                        .WithMany("DirectChildren")
 271509                        .HasForeignKey("ParentId")
 271510                        .OnDelete(DeleteBehavior.Cascade);
 271511
 271512                    b.Navigation("DirectParent");
 271513
 271514                    b.Navigation("Owner");
 271515                });
 1516
 271517            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 271518                {
 271519                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271520                        .WithMany("Images")
 271521                        .HasForeignKey("ItemId")
 271522                        .OnDelete(DeleteBehavior.Cascade)
 271523                        .IsRequired();
 271524
 271525                    b.Navigation("Item");
 271526                });
 1527
 271528            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 271529                {
 271530                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271531                        .WithMany("LockedFields")
 271532                        .HasForeignKey("ItemId")
 271533                        .OnDelete(DeleteBehavior.Cascade)
 271534                        .IsRequired();
 271535
 271536                    b.Navigation("Item");
 271537                });
 1538
 271539            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 271540                {
 271541                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271542                        .WithMany("Provider")
 271543                        .HasForeignKey("ItemId")
 271544                        .OnDelete(DeleteBehavior.Cascade)
 271545                        .IsRequired();
 271546
 271547                    b.Navigation("Item");
 271548                });
 1549
 271550            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 271551                {
 271552                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271553                        .WithMany("TrailerTypes")
 271554                        .HasForeignKey("ItemId")
 271555                        .OnDelete(DeleteBehavior.Cascade)
 271556                        .IsRequired();
 271557
 271558                    b.Navigation("Item");
 271559                });
 1560
 271561            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 271562                {
 271563                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271564                        .WithMany("Chapters")
 271565                        .HasForeignKey("ItemId")
 271566                        .OnDelete(DeleteBehavior.Cascade)
 271567                        .IsRequired();
 271568
 271569                    b.Navigation("Item");
 271570                });
 1571
 271572            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 271573                {
 271574                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 271575                        .WithMany("DisplayPreferences")
 271576                        .HasForeignKey("UserId")
 271577                        .OnDelete(DeleteBehavior.Cascade)
 271578                        .IsRequired();
 271579                });
 1580
 271581            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 271582                {
 271583                    b.HasOne("Jellyfin.Database.Implementations.Entities.DisplayPreferences", null)
 271584                        .WithMany("HomeSections")
 271585                        .HasForeignKey("DisplayPreferencesId")
 271586                        .OnDelete(DeleteBehavior.Cascade)
 271587                        .IsRequired();
 271588                });
 1589
 271590            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 271591                {
 271592                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 271593                        .WithOne("ProfileImage")
 271594                        .HasForeignKey("Jellyfin.Database.Implementations.Entities.ImageInfo", "UserId")
 271595                        .OnDelete(DeleteBehavior.Cascade);
 271596                });
 1597
 271598            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 271599                {
 271600                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 271601                        .WithMany("ItemDisplayPreferences")
 271602                        .HasForeignKey("UserId")
 271603                        .OnDelete(DeleteBehavior.Cascade)
 271604                        .IsRequired();
 271605                });
 1606
 271607            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 271608                {
 271609                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271610                        .WithMany("ItemValues")
 271611                        .HasForeignKey("ItemId")
 271612                        .OnDelete(DeleteBehavior.Cascade)
 271613                        .IsRequired();
 271614
 271615                    b.HasOne("Jellyfin.Database.Implementations.Entities.ItemValue", "ItemValue")
 271616                        .WithMany("BaseItemsMap")
 271617                        .HasForeignKey("ItemValueId")
 271618                        .OnDelete(DeleteBehavior.Cascade)
 271619                        .IsRequired();
 271620
 271621                    b.Navigation("Item");
 271622
 271623                    b.Navigation("ItemValue");
 271624                });
 1625
 271626            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 271627                {
 271628                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271629                        .WithMany()
 271630                        .HasForeignKey("ItemId")
 271631                        .OnDelete(DeleteBehavior.Cascade)
 271632                        .IsRequired();
 271633
 271634                    b.Navigation("Item");
 271635                });
 1636
 271637            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.LinkedChildEntity", b =>
 271638                {
 271639                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Child")
 271640                        .WithMany("LinkedChildOfEntities")
 271641                        .HasForeignKey("ChildId")
 271642                        .OnDelete(DeleteBehavior.NoAction)
 271643                        .IsRequired();
 271644
 271645                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Parent")
 271646                        .WithMany("LinkedChildEntities")
 271647                        .HasForeignKey("ParentId")
 271648                        .OnDelete(DeleteBehavior.NoAction)
 271649                        .IsRequired();
 271650
 271651                    b.Navigation("Child");
 271652
 271653                    b.Navigation("Parent");
 271654                });
 1655
 271656            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 271657                {
 271658                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271659                        .WithMany("MediaStreams")
 271660                        .HasForeignKey("ItemId")
 271661                        .OnDelete(DeleteBehavior.Cascade)
 271662                        .IsRequired();
 271663
 271664                    b.Navigation("Item");
 271665                });
 1666
 271667            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 271668                {
 271669                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271670                        .WithMany("Peoples")
 271671                        .HasForeignKey("ItemId")
 271672                        .OnDelete(DeleteBehavior.Cascade)
 271673                        .IsRequired();
 271674
 271675                    b.HasOne("Jellyfin.Database.Implementations.Entities.People", "People")
 271676                        .WithMany("BaseItems")
 271677                        .HasForeignKey("PeopleId")
 271678                        .OnDelete(DeleteBehavior.Cascade)
 271679                        .IsRequired();
 271680
 271681                    b.Navigation("Item");
 271682
 271683                    b.Navigation("People");
 271684                });
 1685
 271686            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 271687                {
 271688                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 271689                        .WithMany("Permissions")
 271690                        .HasForeignKey("UserId")
 271691                        .OnDelete(DeleteBehavior.Cascade);
 271692                });
 1693
 271694            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 271695                {
 271696                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 271697                        .WithMany("Preferences")
 271698                        .HasForeignKey("UserId")
 271699                        .OnDelete(DeleteBehavior.Cascade);
 271700                });
 1701
 271702            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 271703                {
 271704                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 271705                        .WithMany()
 271706                        .HasForeignKey("UserId")
 271707                        .OnDelete(DeleteBehavior.Cascade)
 271708                        .IsRequired();
 271709
 271710                    b.Navigation("User");
 271711                });
 1712
 271713            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 271714                {
 271715                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 271716                        .WithMany("UserData")
 271717                        .HasForeignKey("ItemId")
 271718                        .OnDelete(DeleteBehavior.Cascade)
 271719                        .IsRequired();
 271720
 271721                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 271722                        .WithMany()
 271723                        .HasForeignKey("UserId")
 271724                        .OnDelete(DeleteBehavior.Cascade)
 271725                        .IsRequired();
 271726
 271727                    b.Navigation("Item");
 271728
 271729                    b.Navigation("User");
 271730                });
 1731
 271732            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 271733                {
 271734                    b.Navigation("Chapters");
 271735
 271736                    b.Navigation("Children");
 271737
 271738                    b.Navigation("DirectChildren");
 271739
 271740                    b.Navigation("Extras");
 271741
 271742                    b.Navigation("Images");
 271743
 271744                    b.Navigation("ItemValues");
 271745
 271746                    b.Navigation("LinkedChildEntities");
 271747
 271748                    b.Navigation("LinkedChildOfEntities");
 271749
 271750                    b.Navigation("LockedFields");
 271751
 271752                    b.Navigation("MediaStreams");
 271753
 271754                    b.Navigation("Parents");
 271755
 271756                    b.Navigation("Peoples");
 271757
 271758                    b.Navigation("Provider");
 271759
 271760                    b.Navigation("TrailerTypes");
 271761
 271762                    b.Navigation("UserData");
 271763                });
 1764
 271765            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 271766                {
 271767                    b.Navigation("HomeSections");
 271768                });
 1769
 271770            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 271771                {
 271772                    b.Navigation("BaseItemsMap");
 271773                });
 1774
 271775            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 271776                {
 271777                    b.Navigation("BaseItems");
 271778                });
 1779
 271780            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 271781                {
 271782                    b.Navigation("AccessSchedules");
 271783
 271784                    b.Navigation("DisplayPreferences");
 271785
 271786                    b.Navigation("ItemDisplayPreferences");
 271787
 271788                    b.Navigation("Permissions");
 271789
 271790                    b.Navigation("Preferences");
 271791
 271792                    b.Navigation("ProfileImage");
 271793                });
 1794#pragma warning restore 612, 618
 271795        }
 1796    }
 1797}
Generated by: ReportGenerator 5.5.10.0
11/5/2026 - 12:17:38 AM
GitHub | reportgenerator.io

Methods/Properties

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