< Summary - Jellyfin

Information
Class: Jellyfin.Server.Implementations.Migrations.JellyfinDbModelSnapshot
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/JellyfinDbModelSnapshot.cs
Line coverage
100%
Covered lines: 1613
Uncovered lines: 0
Coverable lines: 1613
Total lines: 1688
Line coverage: 100%
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
BuildModel(...)100%11100%

File(s)

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

#LineLine coverage
 1// <auto-generated />
 2using System;
 3using Jellyfin.Database.Implementations;
 4using Microsoft.EntityFrameworkCore;
 5using Microsoft.EntityFrameworkCore.Infrastructure;
 6using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
 7
 8#nullable disable
 9
 10namespace Jellyfin.Server.Implementations.Migrations
 11{
 12    [DbContext(typeof(JellyfinDbContext))]
 13    partial class JellyfinDbModelSnapshot : ModelSnapshot
 14    {
 15        protected override void BuildModel(ModelBuilder modelBuilder)
 16        {
 17#pragma warning disable 612, 618
 2218            modelBuilder.HasAnnotation("ProductVersion", "9.0.3");
 19
 2220            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>
 2221                {
 2222                    b.Property<int>("Id")
 2223                        .ValueGeneratedOnAdd()
 2224                        .HasColumnType("INTEGER");
 2225
 2226                    b.Property<int>("DayOfWeek")
 2227                        .HasColumnType("INTEGER");
 2228
 2229                    b.Property<double>("EndHour")
 2230                        .HasColumnType("REAL");
 2231
 2232                    b.Property<double>("StartHour")
 2233                        .HasColumnType("REAL");
 2234
 2235                    b.Property<Guid>("UserId")
 2236                        .HasColumnType("TEXT");
 2237
 2238                    b.HasKey("Id");
 2239
 2240                    b.HasIndex("UserId");
 2241
 2242                    b.ToTable("AccessSchedules");
 2243
 2244                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 2245                });
 46
 2247            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ActivityLog", b =>
 2248                {
 2249                    b.Property<int>("Id")
 2250                        .ValueGeneratedOnAdd()
 2251                        .HasColumnType("INTEGER");
 2252
 2253                    b.Property<DateTime>("DateCreated")
 2254                        .HasColumnType("TEXT");
 2255
 2256                    b.Property<string>("ItemId")
 2257                        .HasMaxLength(256)
 2258                        .HasColumnType("TEXT");
 2259
 2260                    b.Property<int>("LogSeverity")
 2261                        .HasColumnType("INTEGER");
 2262
 2263                    b.Property<string>("Name")
 2264                        .IsRequired()
 2265                        .HasMaxLength(512)
 2266                        .HasColumnType("TEXT");
 2267
 2268                    b.Property<string>("Overview")
 2269                        .HasMaxLength(512)
 2270                        .HasColumnType("TEXT");
 2271
 2272                    b.Property<uint>("RowVersion")
 2273                        .IsConcurrencyToken()
 2274                        .HasColumnType("INTEGER");
 2275
 2276                    b.Property<string>("ShortOverview")
 2277                        .HasMaxLength(512)
 2278                        .HasColumnType("TEXT");
 2279
 2280                    b.Property<string>("Type")
 2281                        .IsRequired()
 2282                        .HasMaxLength(256)
 2283                        .HasColumnType("TEXT");
 2284
 2285                    b.Property<Guid>("UserId")
 2286                        .HasColumnType("TEXT");
 2287
 2288                    b.HasKey("Id");
 2289
 2290                    b.HasIndex("DateCreated");
 2291
 2292                    b.ToTable("ActivityLogs");
 2293
 2294                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 2295                });
 96
 2297            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>
 2298                {
 2299                    b.Property<Guid>("ItemId")
 22100                        .HasColumnType("TEXT");
 22101
 22102                    b.Property<Guid>("ParentItemId")
 22103                        .HasColumnType("TEXT");
 22104
 22105                    b.HasKey("ItemId", "ParentItemId");
 22106
 22107                    b.HasIndex("ParentItemId");
 22108
 22109                    b.ToTable("AncestorIds");
 22110
 22111                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22112                });
 113
 22114            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>
 22115                {
 22116                    b.Property<Guid>("ItemId")
 22117                        .HasColumnType("TEXT");
 22118
 22119                    b.Property<int>("Index")
 22120                        .HasColumnType("INTEGER");
 22121
 22122                    b.Property<string>("Codec")
 22123                        .HasColumnType("TEXT");
 22124
 22125                    b.Property<string>("CodecTag")
 22126                        .HasColumnType("TEXT");
 22127
 22128                    b.Property<string>("Comment")
 22129                        .HasColumnType("TEXT");
 22130
 22131                    b.Property<string>("Filename")
 22132                        .HasColumnType("TEXT");
 22133
 22134                    b.Property<string>("MimeType")
 22135                        .HasColumnType("TEXT");
 22136
 22137                    b.HasKey("ItemId", "Index");
 22138
 22139                    b.ToTable("AttachmentStreamInfos");
 22140
 22141                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22142                });
 143
 22144            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 22145                {
 22146                    b.Property<Guid>("Id")
 22147                        .ValueGeneratedOnAdd()
 22148                        .HasColumnType("TEXT");
 22149
 22150                    b.Property<string>("Album")
 22151                        .HasColumnType("TEXT");
 22152
 22153                    b.Property<string>("AlbumArtists")
 22154                        .HasColumnType("TEXT");
 22155
 22156                    b.Property<string>("Artists")
 22157                        .HasColumnType("TEXT");
 22158
 22159                    b.Property<int?>("Audio")
 22160                        .HasColumnType("INTEGER");
 22161
 22162                    b.Property<Guid?>("ChannelId")
 22163                        .HasColumnType("TEXT");
 22164
 22165                    b.Property<string>("CleanName")
 22166                        .HasColumnType("TEXT");
 22167
 22168                    b.Property<float?>("CommunityRating")
 22169                        .HasColumnType("REAL");
 22170
 22171                    b.Property<float?>("CriticRating")
 22172                        .HasColumnType("REAL");
 22173
 22174                    b.Property<string>("CustomRating")
 22175                        .HasColumnType("TEXT");
 22176
 22177                    b.Property<string>("Data")
 22178                        .HasColumnType("TEXT");
 22179
 22180                    b.Property<DateTime?>("DateCreated")
 22181                        .HasColumnType("TEXT");
 22182
 22183                    b.Property<DateTime?>("DateLastMediaAdded")
 22184                        .HasColumnType("TEXT");
 22185
 22186                    b.Property<DateTime?>("DateLastRefreshed")
 22187                        .HasColumnType("TEXT");
 22188
 22189                    b.Property<DateTime?>("DateLastSaved")
 22190                        .HasColumnType("TEXT");
 22191
 22192                    b.Property<DateTime?>("DateModified")
 22193                        .HasColumnType("TEXT");
 22194
 22195                    b.Property<DateTime?>("EndDate")
 22196                        .HasColumnType("TEXT");
 22197
 22198                    b.Property<string>("EpisodeTitle")
 22199                        .HasColumnType("TEXT");
 22200
 22201                    b.Property<string>("ExternalId")
 22202                        .HasColumnType("TEXT");
 22203
 22204                    b.Property<string>("ExternalSeriesId")
 22205                        .HasColumnType("TEXT");
 22206
 22207                    b.Property<string>("ExternalServiceId")
 22208                        .HasColumnType("TEXT");
 22209
 22210                    b.Property<string>("ExtraIds")
 22211                        .HasColumnType("TEXT");
 22212
 22213                    b.Property<int?>("ExtraType")
 22214                        .HasColumnType("INTEGER");
 22215
 22216                    b.Property<string>("ForcedSortName")
 22217                        .HasColumnType("TEXT");
 22218
 22219                    b.Property<string>("Genres")
 22220                        .HasColumnType("TEXT");
 22221
 22222                    b.Property<int?>("Height")
 22223                        .HasColumnType("INTEGER");
 22224
 22225                    b.Property<int?>("IndexNumber")
 22226                        .HasColumnType("INTEGER");
 22227
 22228                    b.Property<int?>("InheritedParentalRatingSubValue")
 22229                        .HasColumnType("INTEGER");
 22230
 22231                    b.Property<int?>("InheritedParentalRatingValue")
 22232                        .HasColumnType("INTEGER");
 22233
 22234                    b.Property<bool>("IsFolder")
 22235                        .HasColumnType("INTEGER");
 22236
 22237                    b.Property<bool>("IsInMixedFolder")
 22238                        .HasColumnType("INTEGER");
 22239
 22240                    b.Property<bool>("IsLocked")
 22241                        .HasColumnType("INTEGER");
 22242
 22243                    b.Property<bool>("IsMovie")
 22244                        .HasColumnType("INTEGER");
 22245
 22246                    b.Property<bool>("IsRepeat")
 22247                        .HasColumnType("INTEGER");
 22248
 22249                    b.Property<bool>("IsSeries")
 22250                        .HasColumnType("INTEGER");
 22251
 22252                    b.Property<bool>("IsVirtualItem")
 22253                        .HasColumnType("INTEGER");
 22254
 22255                    b.Property<float?>("LUFS")
 22256                        .HasColumnType("REAL");
 22257
 22258                    b.Property<string>("MediaType")
 22259                        .HasColumnType("TEXT");
 22260
 22261                    b.Property<string>("Name")
 22262                        .HasColumnType("TEXT");
 22263
 22264                    b.Property<float?>("NormalizationGain")
 22265                        .HasColumnType("REAL");
 22266
 22267                    b.Property<string>("OfficialRating")
 22268                        .HasColumnType("TEXT");
 22269
 22270                    b.Property<string>("OriginalTitle")
 22271                        .HasColumnType("TEXT");
 22272
 22273                    b.Property<string>("Overview")
 22274                        .HasColumnType("TEXT");
 22275
 22276                    b.Property<string>("OwnerId")
 22277                        .HasColumnType("TEXT");
 22278
 22279                    b.Property<Guid?>("ParentId")
 22280                        .HasColumnType("TEXT");
 22281
 22282                    b.Property<int?>("ParentIndexNumber")
 22283                        .HasColumnType("INTEGER");
 22284
 22285                    b.Property<string>("Path")
 22286                        .HasColumnType("TEXT");
 22287
 22288                    b.Property<string>("PreferredMetadataCountryCode")
 22289                        .HasColumnType("TEXT");
 22290
 22291                    b.Property<string>("PreferredMetadataLanguage")
 22292                        .HasColumnType("TEXT");
 22293
 22294                    b.Property<DateTime?>("PremiereDate")
 22295                        .HasColumnType("TEXT");
 22296
 22297                    b.Property<string>("PresentationUniqueKey")
 22298                        .HasColumnType("TEXT");
 22299
 22300                    b.Property<string>("PrimaryVersionId")
 22301                        .HasColumnType("TEXT");
 22302
 22303                    b.Property<string>("ProductionLocations")
 22304                        .HasColumnType("TEXT");
 22305
 22306                    b.Property<int?>("ProductionYear")
 22307                        .HasColumnType("INTEGER");
 22308
 22309                    b.Property<long?>("RunTimeTicks")
 22310                        .HasColumnType("INTEGER");
 22311
 22312                    b.Property<Guid?>("SeasonId")
 22313                        .HasColumnType("TEXT");
 22314
 22315                    b.Property<string>("SeasonName")
 22316                        .HasColumnType("TEXT");
 22317
 22318                    b.Property<Guid?>("SeriesId")
 22319                        .HasColumnType("TEXT");
 22320
 22321                    b.Property<string>("SeriesName")
 22322                        .HasColumnType("TEXT");
 22323
 22324                    b.Property<string>("SeriesPresentationUniqueKey")
 22325                        .HasColumnType("TEXT");
 22326
 22327                    b.Property<string>("ShowId")
 22328                        .HasColumnType("TEXT");
 22329
 22330                    b.Property<long?>("Size")
 22331                        .HasColumnType("INTEGER");
 22332
 22333                    b.Property<string>("SortName")
 22334                        .HasColumnType("TEXT");
 22335
 22336                    b.Property<DateTime?>("StartDate")
 22337                        .HasColumnType("TEXT");
 22338
 22339                    b.Property<string>("Studios")
 22340                        .HasColumnType("TEXT");
 22341
 22342                    b.Property<string>("Tagline")
 22343                        .HasColumnType("TEXT");
 22344
 22345                    b.Property<string>("Tags")
 22346                        .HasColumnType("TEXT");
 22347
 22348                    b.Property<Guid?>("TopParentId")
 22349                        .HasColumnType("TEXT");
 22350
 22351                    b.Property<int?>("TotalBitrate")
 22352                        .HasColumnType("INTEGER");
 22353
 22354                    b.Property<string>("Type")
 22355                        .IsRequired()
 22356                        .HasColumnType("TEXT");
 22357
 22358                    b.Property<string>("UnratedType")
 22359                        .HasColumnType("TEXT");
 22360
 22361                    b.Property<int?>("Width")
 22362                        .HasColumnType("INTEGER");
 22363
 22364                    b.HasKey("Id");
 22365
 22366                    b.HasIndex("ParentId");
 22367
 22368                    b.HasIndex("Path");
 22369
 22370                    b.HasIndex("PresentationUniqueKey");
 22371
 22372                    b.HasIndex("TopParentId", "Id");
 22373
 22374                    b.HasIndex("Type", "TopParentId", "Id");
 22375
 22376                    b.HasIndex("Type", "TopParentId", "PresentationUniqueKey");
 22377
 22378                    b.HasIndex("Type", "TopParentId", "StartDate");
 22379
 22380                    b.HasIndex("Id", "Type", "IsFolder", "IsVirtualItem");
 22381
 22382                    b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey");
 22383
 22384                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem");
 22385
 22386                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName");
 22387
 22388                    b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 22389
 22390                    b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 22391
 22392                    b.ToTable("BaseItems");
 22393
 22394                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22395                });
 396
 22397            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 22398                {
 22399                    b.Property<Guid>("Id")
 22400                        .ValueGeneratedOnAdd()
 22401                        .HasColumnType("TEXT");
 22402
 22403                    b.Property<byte[]>("Blurhash")
 22404                        .HasColumnType("BLOB");
 22405
 22406                    b.Property<DateTime>("DateModified")
 22407                        .HasColumnType("TEXT");
 22408
 22409                    b.Property<int>("Height")
 22410                        .HasColumnType("INTEGER");
 22411
 22412                    b.Property<int>("ImageType")
 22413                        .HasColumnType("INTEGER");
 22414
 22415                    b.Property<Guid>("ItemId")
 22416                        .HasColumnType("TEXT");
 22417
 22418                    b.Property<string>("Path")
 22419                        .IsRequired()
 22420                        .HasColumnType("TEXT");
 22421
 22422                    b.Property<int>("Width")
 22423                        .HasColumnType("INTEGER");
 22424
 22425                    b.HasKey("Id");
 22426
 22427                    b.HasIndex("ItemId");
 22428
 22429                    b.ToTable("BaseItemImageInfos");
 22430
 22431                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22432                });
 433
 22434            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 22435                {
 22436                    b.Property<int>("Id")
 22437                        .HasColumnType("INTEGER");
 22438
 22439                    b.Property<Guid>("ItemId")
 22440                        .HasColumnType("TEXT");
 22441
 22442                    b.HasKey("Id", "ItemId");
 22443
 22444                    b.HasIndex("ItemId");
 22445
 22446                    b.ToTable("BaseItemMetadataFields");
 22447
 22448                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22449                });
 450
 22451            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 22452                {
 22453                    b.Property<Guid>("ItemId")
 22454                        .HasColumnType("TEXT");
 22455
 22456                    b.Property<string>("ProviderId")
 22457                        .HasColumnType("TEXT");
 22458
 22459                    b.Property<string>("ProviderValue")
 22460                        .IsRequired()
 22461                        .HasColumnType("TEXT");
 22462
 22463                    b.HasKey("ItemId", "ProviderId");
 22464
 22465                    b.HasIndex("ProviderId", "ProviderValue", "ItemId");
 22466
 22467                    b.ToTable("BaseItemProviders");
 22468
 22469                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22470                });
 471
 22472            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 22473                {
 22474                    b.Property<int>("Id")
 22475                        .HasColumnType("INTEGER");
 22476
 22477                    b.Property<Guid>("ItemId")
 22478                        .HasColumnType("TEXT");
 22479
 22480                    b.HasKey("Id", "ItemId");
 22481
 22482                    b.HasIndex("ItemId");
 22483
 22484                    b.ToTable("BaseItemTrailerTypes");
 22485
 22486                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22487                });
 488
 22489            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 22490                {
 22491                    b.Property<Guid>("ItemId")
 22492                        .HasColumnType("TEXT");
 22493
 22494                    b.Property<int>("ChapterIndex")
 22495                        .HasColumnType("INTEGER");
 22496
 22497                    b.Property<DateTime?>("ImageDateModified")
 22498                        .HasColumnType("TEXT");
 22499
 22500                    b.Property<string>("ImagePath")
 22501                        .HasColumnType("TEXT");
 22502
 22503                    b.Property<string>("Name")
 22504                        .HasColumnType("TEXT");
 22505
 22506                    b.Property<long>("StartPositionTicks")
 22507                        .HasColumnType("INTEGER");
 22508
 22509                    b.HasKey("ItemId", "ChapterIndex");
 22510
 22511                    b.ToTable("Chapters");
 22512
 22513                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22514                });
 515
 22516            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.CustomItemDisplayPreferences", b =>
 22517                {
 22518                    b.Property<int>("Id")
 22519                        .ValueGeneratedOnAdd()
 22520                        .HasColumnType("INTEGER");
 22521
 22522                    b.Property<string>("Client")
 22523                        .IsRequired()
 22524                        .HasMaxLength(32)
 22525                        .HasColumnType("TEXT");
 22526
 22527                    b.Property<Guid>("ItemId")
 22528                        .HasColumnType("TEXT");
 22529
 22530                    b.Property<string>("Key")
 22531                        .IsRequired()
 22532                        .HasColumnType("TEXT");
 22533
 22534                    b.Property<Guid>("UserId")
 22535                        .HasColumnType("TEXT");
 22536
 22537                    b.Property<string>("Value")
 22538                        .HasColumnType("TEXT");
 22539
 22540                    b.HasKey("Id");
 22541
 22542                    b.HasIndex("UserId", "ItemId", "Client", "Key")
 22543                        .IsUnique();
 22544
 22545                    b.ToTable("CustomItemDisplayPreferences");
 22546
 22547                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22548                });
 549
 22550            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 22551                {
 22552                    b.Property<int>("Id")
 22553                        .ValueGeneratedOnAdd()
 22554                        .HasColumnType("INTEGER");
 22555
 22556                    b.Property<int>("ChromecastVersion")
 22557                        .HasColumnType("INTEGER");
 22558
 22559                    b.Property<string>("Client")
 22560                        .IsRequired()
 22561                        .HasMaxLength(32)
 22562                        .HasColumnType("TEXT");
 22563
 22564                    b.Property<string>("DashboardTheme")
 22565                        .HasMaxLength(32)
 22566                        .HasColumnType("TEXT");
 22567
 22568                    b.Property<bool>("EnableNextVideoInfoOverlay")
 22569                        .HasColumnType("INTEGER");
 22570
 22571                    b.Property<int?>("IndexBy")
 22572                        .HasColumnType("INTEGER");
 22573
 22574                    b.Property<Guid>("ItemId")
 22575                        .HasColumnType("TEXT");
 22576
 22577                    b.Property<int>("ScrollDirection")
 22578                        .HasColumnType("INTEGER");
 22579
 22580                    b.Property<bool>("ShowBackdrop")
 22581                        .HasColumnType("INTEGER");
 22582
 22583                    b.Property<bool>("ShowSidebar")
 22584                        .HasColumnType("INTEGER");
 22585
 22586                    b.Property<int>("SkipBackwardLength")
 22587                        .HasColumnType("INTEGER");
 22588
 22589                    b.Property<int>("SkipForwardLength")
 22590                        .HasColumnType("INTEGER");
 22591
 22592                    b.Property<string>("TvHome")
 22593                        .HasMaxLength(32)
 22594                        .HasColumnType("TEXT");
 22595
 22596                    b.Property<Guid>("UserId")
 22597                        .HasColumnType("TEXT");
 22598
 22599                    b.HasKey("Id");
 22600
 22601                    b.HasIndex("UserId", "ItemId", "Client")
 22602                        .IsUnique();
 22603
 22604                    b.ToTable("DisplayPreferences");
 22605
 22606                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22607                });
 608
 22609            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 22610                {
 22611                    b.Property<int>("Id")
 22612                        .ValueGeneratedOnAdd()
 22613                        .HasColumnType("INTEGER");
 22614
 22615                    b.Property<int>("DisplayPreferencesId")
 22616                        .HasColumnType("INTEGER");
 22617
 22618                    b.Property<int>("Order")
 22619                        .HasColumnType("INTEGER");
 22620
 22621                    b.Property<int>("Type")
 22622                        .HasColumnType("INTEGER");
 22623
 22624                    b.HasKey("Id");
 22625
 22626                    b.HasIndex("DisplayPreferencesId");
 22627
 22628                    b.ToTable("HomeSection");
 22629
 22630                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22631                });
 632
 22633            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 22634                {
 22635                    b.Property<int>("Id")
 22636                        .ValueGeneratedOnAdd()
 22637                        .HasColumnType("INTEGER");
 22638
 22639                    b.Property<DateTime>("LastModified")
 22640                        .HasColumnType("TEXT");
 22641
 22642                    b.Property<string>("Path")
 22643                        .IsRequired()
 22644                        .HasMaxLength(512)
 22645                        .HasColumnType("TEXT");
 22646
 22647                    b.Property<Guid?>("UserId")
 22648                        .HasColumnType("TEXT");
 22649
 22650                    b.HasKey("Id");
 22651
 22652                    b.HasIndex("UserId")
 22653                        .IsUnique();
 22654
 22655                    b.ToTable("ImageInfos");
 22656
 22657                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22658                });
 659
 22660            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 22661                {
 22662                    b.Property<int>("Id")
 22663                        .ValueGeneratedOnAdd()
 22664                        .HasColumnType("INTEGER");
 22665
 22666                    b.Property<string>("Client")
 22667                        .IsRequired()
 22668                        .HasMaxLength(32)
 22669                        .HasColumnType("TEXT");
 22670
 22671                    b.Property<int?>("IndexBy")
 22672                        .HasColumnType("INTEGER");
 22673
 22674                    b.Property<Guid>("ItemId")
 22675                        .HasColumnType("TEXT");
 22676
 22677                    b.Property<bool>("RememberIndexing")
 22678                        .HasColumnType("INTEGER");
 22679
 22680                    b.Property<bool>("RememberSorting")
 22681                        .HasColumnType("INTEGER");
 22682
 22683                    b.Property<string>("SortBy")
 22684                        .IsRequired()
 22685                        .HasMaxLength(64)
 22686                        .HasColumnType("TEXT");
 22687
 22688                    b.Property<int>("SortOrder")
 22689                        .HasColumnType("INTEGER");
 22690
 22691                    b.Property<Guid>("UserId")
 22692                        .HasColumnType("TEXT");
 22693
 22694                    b.Property<int>("ViewType")
 22695                        .HasColumnType("INTEGER");
 22696
 22697                    b.HasKey("Id");
 22698
 22699                    b.HasIndex("UserId");
 22700
 22701                    b.ToTable("ItemDisplayPreferences");
 22702
 22703                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22704                });
 705
 22706            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 22707                {
 22708                    b.Property<Guid>("ItemValueId")
 22709                        .ValueGeneratedOnAdd()
 22710                        .HasColumnType("TEXT");
 22711
 22712                    b.Property<string>("CleanValue")
 22713                        .IsRequired()
 22714                        .HasColumnType("TEXT");
 22715
 22716                    b.Property<int>("Type")
 22717                        .HasColumnType("INTEGER");
 22718
 22719                    b.Property<string>("Value")
 22720                        .IsRequired()
 22721                        .HasColumnType("TEXT");
 22722
 22723                    b.HasKey("ItemValueId");
 22724
 22725                    b.HasIndex("Type", "CleanValue");
 22726
 22727                    b.HasIndex("Type", "Value")
 22728                        .IsUnique();
 22729
 22730                    b.ToTable("ItemValues");
 22731
 22732                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22733                });
 734
 22735            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 22736                {
 22737                    b.Property<Guid>("ItemValueId")
 22738                        .HasColumnType("TEXT");
 22739
 22740                    b.Property<Guid>("ItemId")
 22741                        .HasColumnType("TEXT");
 22742
 22743                    b.HasKey("ItemValueId", "ItemId");
 22744
 22745                    b.HasIndex("ItemId");
 22746
 22747                    b.ToTable("ItemValuesMap");
 22748
 22749                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22750                });
 751
 22752            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 22753                {
 22754                    b.Property<Guid>("ItemId")
 22755                        .HasColumnType("TEXT");
 22756
 22757                    b.PrimitiveCollection<string>("KeyframeTicks")
 22758                        .HasColumnType("TEXT");
 22759
 22760                    b.Property<long>("TotalDuration")
 22761                        .HasColumnType("INTEGER");
 22762
 22763                    b.HasKey("ItemId");
 22764
 22765                    b.ToTable("KeyframeData");
 22766
 22767                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22768                });
 769
 22770            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaSegment", b =>
 22771                {
 22772                    b.Property<Guid>("Id")
 22773                        .ValueGeneratedOnAdd()
 22774                        .HasColumnType("TEXT");
 22775
 22776                    b.Property<long>("EndTicks")
 22777                        .HasColumnType("INTEGER");
 22778
 22779                    b.Property<Guid>("ItemId")
 22780                        .HasColumnType("TEXT");
 22781
 22782                    b.Property<string>("SegmentProviderId")
 22783                        .IsRequired()
 22784                        .HasColumnType("TEXT");
 22785
 22786                    b.Property<long>("StartTicks")
 22787                        .HasColumnType("INTEGER");
 22788
 22789                    b.Property<int>("Type")
 22790                        .HasColumnType("INTEGER");
 22791
 22792                    b.HasKey("Id");
 22793
 22794                    b.ToTable("MediaSegments");
 22795
 22796                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22797                });
 798
 22799            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 22800                {
 22801                    b.Property<Guid>("ItemId")
 22802                        .HasColumnType("TEXT");
 22803
 22804                    b.Property<int>("StreamIndex")
 22805                        .HasColumnType("INTEGER");
 22806
 22807                    b.Property<string>("AspectRatio")
 22808                        .HasColumnType("TEXT");
 22809
 22810                    b.Property<float?>("AverageFrameRate")
 22811                        .HasColumnType("REAL");
 22812
 22813                    b.Property<int?>("BitDepth")
 22814                        .HasColumnType("INTEGER");
 22815
 22816                    b.Property<int?>("BitRate")
 22817                        .HasColumnType("INTEGER");
 22818
 22819                    b.Property<int?>("BlPresentFlag")
 22820                        .HasColumnType("INTEGER");
 22821
 22822                    b.Property<string>("ChannelLayout")
 22823                        .HasColumnType("TEXT");
 22824
 22825                    b.Property<int?>("Channels")
 22826                        .HasColumnType("INTEGER");
 22827
 22828                    b.Property<string>("Codec")
 22829                        .HasColumnType("TEXT");
 22830
 22831                    b.Property<string>("CodecTag")
 22832                        .HasColumnType("TEXT");
 22833
 22834                    b.Property<string>("CodecTimeBase")
 22835                        .HasColumnType("TEXT");
 22836
 22837                    b.Property<string>("ColorPrimaries")
 22838                        .HasColumnType("TEXT");
 22839
 22840                    b.Property<string>("ColorSpace")
 22841                        .HasColumnType("TEXT");
 22842
 22843                    b.Property<string>("ColorTransfer")
 22844                        .HasColumnType("TEXT");
 22845
 22846                    b.Property<string>("Comment")
 22847                        .HasColumnType("TEXT");
 22848
 22849                    b.Property<int?>("DvBlSignalCompatibilityId")
 22850                        .HasColumnType("INTEGER");
 22851
 22852                    b.Property<int?>("DvLevel")
 22853                        .HasColumnType("INTEGER");
 22854
 22855                    b.Property<int?>("DvProfile")
 22856                        .HasColumnType("INTEGER");
 22857
 22858                    b.Property<int?>("DvVersionMajor")
 22859                        .HasColumnType("INTEGER");
 22860
 22861                    b.Property<int?>("DvVersionMinor")
 22862                        .HasColumnType("INTEGER");
 22863
 22864                    b.Property<int?>("ElPresentFlag")
 22865                        .HasColumnType("INTEGER");
 22866
 22867                    b.Property<bool?>("Hdr10PlusPresentFlag")
 22868                        .HasColumnType("INTEGER");
 22869
 22870                    b.Property<int?>("Height")
 22871                        .HasColumnType("INTEGER");
 22872
 22873                    b.Property<bool?>("IsAnamorphic")
 22874                        .HasColumnType("INTEGER");
 22875
 22876                    b.Property<bool?>("IsAvc")
 22877                        .HasColumnType("INTEGER");
 22878
 22879                    b.Property<bool>("IsDefault")
 22880                        .HasColumnType("INTEGER");
 22881
 22882                    b.Property<bool>("IsExternal")
 22883                        .HasColumnType("INTEGER");
 22884
 22885                    b.Property<bool>("IsForced")
 22886                        .HasColumnType("INTEGER");
 22887
 22888                    b.Property<bool?>("IsHearingImpaired")
 22889                        .HasColumnType("INTEGER");
 22890
 22891                    b.Property<bool?>("IsInterlaced")
 22892                        .HasColumnType("INTEGER");
 22893
 22894                    b.Property<string>("KeyFrames")
 22895                        .HasColumnType("TEXT");
 22896
 22897                    b.Property<string>("Language")
 22898                        .HasColumnType("TEXT");
 22899
 22900                    b.Property<float?>("Level")
 22901                        .HasColumnType("REAL");
 22902
 22903                    b.Property<string>("NalLengthSize")
 22904                        .HasColumnType("TEXT");
 22905
 22906                    b.Property<string>("Path")
 22907                        .HasColumnType("TEXT");
 22908
 22909                    b.Property<string>("PixelFormat")
 22910                        .HasColumnType("TEXT");
 22911
 22912                    b.Property<string>("Profile")
 22913                        .HasColumnType("TEXT");
 22914
 22915                    b.Property<float?>("RealFrameRate")
 22916                        .HasColumnType("REAL");
 22917
 22918                    b.Property<int?>("RefFrames")
 22919                        .HasColumnType("INTEGER");
 22920
 22921                    b.Property<int?>("Rotation")
 22922                        .HasColumnType("INTEGER");
 22923
 22924                    b.Property<int?>("RpuPresentFlag")
 22925                        .HasColumnType("INTEGER");
 22926
 22927                    b.Property<int?>("SampleRate")
 22928                        .HasColumnType("INTEGER");
 22929
 22930                    b.Property<int>("StreamType")
 22931                        .HasColumnType("INTEGER");
 22932
 22933                    b.Property<string>("TimeBase")
 22934                        .HasColumnType("TEXT");
 22935
 22936                    b.Property<string>("Title")
 22937                        .HasColumnType("TEXT");
 22938
 22939                    b.Property<int?>("Width")
 22940                        .HasColumnType("INTEGER");
 22941
 22942                    b.HasKey("ItemId", "StreamIndex");
 22943
 22944                    b.HasIndex("StreamIndex");
 22945
 22946                    b.HasIndex("StreamType");
 22947
 22948                    b.HasIndex("StreamIndex", "StreamType");
 22949
 22950                    b.HasIndex("StreamIndex", "StreamType", "Language");
 22951
 22952                    b.ToTable("MediaStreamInfos");
 22953
 22954                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22955                });
 956
 22957            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 22958                {
 22959                    b.Property<Guid>("Id")
 22960                        .ValueGeneratedOnAdd()
 22961                        .HasColumnType("TEXT");
 22962
 22963                    b.Property<string>("Name")
 22964                        .IsRequired()
 22965                        .HasColumnType("TEXT");
 22966
 22967                    b.Property<string>("PersonType")
 22968                        .HasColumnType("TEXT");
 22969
 22970                    b.HasKey("Id");
 22971
 22972                    b.HasIndex("Name");
 22973
 22974                    b.ToTable("Peoples");
 22975
 22976                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 22977                });
 978
 22979            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 22980                {
 22981                    b.Property<Guid>("ItemId")
 22982                        .HasColumnType("TEXT");
 22983
 22984                    b.Property<Guid>("PeopleId")
 22985                        .HasColumnType("TEXT");
 22986
 22987                    b.Property<int?>("ListOrder")
 22988                        .HasColumnType("INTEGER");
 22989
 22990                    b.Property<string>("Role")
 22991                        .HasColumnType("TEXT");
 22992
 22993                    b.Property<int?>("SortOrder")
 22994                        .HasColumnType("INTEGER");
 22995
 22996                    b.HasKey("ItemId", "PeopleId");
 22997
 22998                    b.HasIndex("PeopleId");
 22999
 221000                    b.HasIndex("ItemId", "ListOrder");
 221001
 221002                    b.HasIndex("ItemId", "SortOrder");
 221003
 221004                    b.ToTable("PeopleBaseItemMap");
 221005
 221006                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221007                });
 1008
 221009            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 221010                {
 221011                    b.Property<int>("Id")
 221012                        .ValueGeneratedOnAdd()
 221013                        .HasColumnType("INTEGER");
 221014
 221015                    b.Property<int>("Kind")
 221016                        .HasColumnType("INTEGER");
 221017
 221018                    b.Property<Guid?>("Permission_Permissions_Guid")
 221019                        .HasColumnType("TEXT");
 221020
 221021                    b.Property<uint>("RowVersion")
 221022                        .IsConcurrencyToken()
 221023                        .HasColumnType("INTEGER");
 221024
 221025                    b.Property<Guid?>("UserId")
 221026                        .HasColumnType("TEXT");
 221027
 221028                    b.Property<bool>("Value")
 221029                        .HasColumnType("INTEGER");
 221030
 221031                    b.HasKey("Id");
 221032
 221033                    b.HasIndex("UserId", "Kind")
 221034                        .IsUnique()
 221035                        .HasFilter("[UserId] IS NOT NULL");
 221036
 221037                    b.ToTable("Permissions");
 221038
 221039                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221040                });
 1041
 221042            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 221043                {
 221044                    b.Property<int>("Id")
 221045                        .ValueGeneratedOnAdd()
 221046                        .HasColumnType("INTEGER");
 221047
 221048                    b.Property<int>("Kind")
 221049                        .HasColumnType("INTEGER");
 221050
 221051                    b.Property<Guid?>("Preference_Preferences_Guid")
 221052                        .HasColumnType("TEXT");
 221053
 221054                    b.Property<uint>("RowVersion")
 221055                        .IsConcurrencyToken()
 221056                        .HasColumnType("INTEGER");
 221057
 221058                    b.Property<Guid?>("UserId")
 221059                        .HasColumnType("TEXT");
 221060
 221061                    b.Property<string>("Value")
 221062                        .IsRequired()
 221063                        .HasMaxLength(65535)
 221064                        .HasColumnType("TEXT");
 221065
 221066                    b.HasKey("Id");
 221067
 221068                    b.HasIndex("UserId", "Kind")
 221069                        .IsUnique()
 221070                        .HasFilter("[UserId] IS NOT NULL");
 221071
 221072                    b.ToTable("Preferences");
 221073
 221074                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221075                });
 1076
 221077            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.ApiKey", b =>
 221078                {
 221079                    b.Property<int>("Id")
 221080                        .ValueGeneratedOnAdd()
 221081                        .HasColumnType("INTEGER");
 221082
 221083                    b.Property<string>("AccessToken")
 221084                        .IsRequired()
 221085                        .HasColumnType("TEXT");
 221086
 221087                    b.Property<DateTime>("DateCreated")
 221088                        .HasColumnType("TEXT");
 221089
 221090                    b.Property<DateTime>("DateLastActivity")
 221091                        .HasColumnType("TEXT");
 221092
 221093                    b.Property<string>("Name")
 221094                        .IsRequired()
 221095                        .HasMaxLength(64)
 221096                        .HasColumnType("TEXT");
 221097
 221098                    b.HasKey("Id");
 221099
 221100                    b.HasIndex("AccessToken")
 221101                        .IsUnique();
 221102
 221103                    b.ToTable("ApiKeys");
 221104
 221105                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221106                });
 1107
 221108            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 221109                {
 221110                    b.Property<int>("Id")
 221111                        .ValueGeneratedOnAdd()
 221112                        .HasColumnType("INTEGER");
 221113
 221114                    b.Property<string>("AccessToken")
 221115                        .IsRequired()
 221116                        .HasColumnType("TEXT");
 221117
 221118                    b.Property<string>("AppName")
 221119                        .IsRequired()
 221120                        .HasMaxLength(64)
 221121                        .HasColumnType("TEXT");
 221122
 221123                    b.Property<string>("AppVersion")
 221124                        .IsRequired()
 221125                        .HasMaxLength(32)
 221126                        .HasColumnType("TEXT");
 221127
 221128                    b.Property<DateTime>("DateCreated")
 221129                        .HasColumnType("TEXT");
 221130
 221131                    b.Property<DateTime>("DateLastActivity")
 221132                        .HasColumnType("TEXT");
 221133
 221134                    b.Property<DateTime>("DateModified")
 221135                        .HasColumnType("TEXT");
 221136
 221137                    b.Property<string>("DeviceId")
 221138                        .IsRequired()
 221139                        .HasMaxLength(256)
 221140                        .HasColumnType("TEXT");
 221141
 221142                    b.Property<string>("DeviceName")
 221143                        .IsRequired()
 221144                        .HasMaxLength(64)
 221145                        .HasColumnType("TEXT");
 221146
 221147                    b.Property<bool>("IsActive")
 221148                        .HasColumnType("INTEGER");
 221149
 221150                    b.Property<Guid>("UserId")
 221151                        .HasColumnType("TEXT");
 221152
 221153                    b.HasKey("Id");
 221154
 221155                    b.HasIndex("DeviceId");
 221156
 221157                    b.HasIndex("AccessToken", "DateLastActivity");
 221158
 221159                    b.HasIndex("DeviceId", "DateLastActivity");
 221160
 221161                    b.HasIndex("UserId", "DeviceId");
 221162
 221163                    b.ToTable("Devices");
 221164
 221165                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221166                });
 1167
 221168            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.DeviceOptions", b =>
 221169                {
 221170                    b.Property<int>("Id")
 221171                        .ValueGeneratedOnAdd()
 221172                        .HasColumnType("INTEGER");
 221173
 221174                    b.Property<string>("CustomName")
 221175                        .HasColumnType("TEXT");
 221176
 221177                    b.Property<string>("DeviceId")
 221178                        .IsRequired()
 221179                        .HasColumnType("TEXT");
 221180
 221181                    b.HasKey("Id");
 221182
 221183                    b.HasIndex("DeviceId")
 221184                        .IsUnique();
 221185
 221186                    b.ToTable("DeviceOptions");
 221187
 221188                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221189                });
 1190
 221191            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.TrickplayInfo", b =>
 221192                {
 221193                    b.Property<Guid>("ItemId")
 221194                        .HasColumnType("TEXT");
 221195
 221196                    b.Property<int>("Width")
 221197                        .HasColumnType("INTEGER");
 221198
 221199                    b.Property<int>("Bandwidth")
 221200                        .HasColumnType("INTEGER");
 221201
 221202                    b.Property<int>("Height")
 221203                        .HasColumnType("INTEGER");
 221204
 221205                    b.Property<int>("Interval")
 221206                        .HasColumnType("INTEGER");
 221207
 221208                    b.Property<int>("ThumbnailCount")
 221209                        .HasColumnType("INTEGER");
 221210
 221211                    b.Property<int>("TileHeight")
 221212                        .HasColumnType("INTEGER");
 221213
 221214                    b.Property<int>("TileWidth")
 221215                        .HasColumnType("INTEGER");
 221216
 221217                    b.HasKey("ItemId", "Width");
 221218
 221219                    b.ToTable("TrickplayInfos");
 221220
 221221                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221222                });
 1223
 221224            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 221225                {
 221226                    b.Property<Guid>("Id")
 221227                        .ValueGeneratedOnAdd()
 221228                        .HasColumnType("TEXT");
 221229
 221230                    b.Property<string>("AudioLanguagePreference")
 221231                        .HasMaxLength(255)
 221232                        .HasColumnType("TEXT");
 221233
 221234                    b.Property<string>("AuthenticationProviderId")
 221235                        .IsRequired()
 221236                        .HasMaxLength(255)
 221237                        .HasColumnType("TEXT");
 221238
 221239                    b.Property<string>("CastReceiverId")
 221240                        .HasMaxLength(32)
 221241                        .HasColumnType("TEXT");
 221242
 221243                    b.Property<bool>("DisplayCollectionsView")
 221244                        .HasColumnType("INTEGER");
 221245
 221246                    b.Property<bool>("DisplayMissingEpisodes")
 221247                        .HasColumnType("INTEGER");
 221248
 221249                    b.Property<bool>("EnableAutoLogin")
 221250                        .HasColumnType("INTEGER");
 221251
 221252                    b.Property<bool>("EnableLocalPassword")
 221253                        .HasColumnType("INTEGER");
 221254
 221255                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 221256                        .HasColumnType("INTEGER");
 221257
 221258                    b.Property<bool>("EnableUserPreferenceAccess")
 221259                        .HasColumnType("INTEGER");
 221260
 221261                    b.Property<bool>("HidePlayedInLatest")
 221262                        .HasColumnType("INTEGER");
 221263
 221264                    b.Property<long>("InternalId")
 221265                        .HasColumnType("INTEGER");
 221266
 221267                    b.Property<int>("InvalidLoginAttemptCount")
 221268                        .HasColumnType("INTEGER");
 221269
 221270                    b.Property<DateTime?>("LastActivityDate")
 221271                        .HasColumnType("TEXT");
 221272
 221273                    b.Property<DateTime?>("LastLoginDate")
 221274                        .HasColumnType("TEXT");
 221275
 221276                    b.Property<int?>("LoginAttemptsBeforeLockout")
 221277                        .HasColumnType("INTEGER");
 221278
 221279                    b.Property<int>("MaxActiveSessions")
 221280                        .HasColumnType("INTEGER");
 221281
 221282                    b.Property<int?>("MaxParentalRatingScore")
 221283                        .HasColumnType("INTEGER");
 221284
 221285                    b.Property<int?>("MaxParentalRatingSubScore")
 221286                        .HasColumnType("INTEGER");
 221287
 221288                    b.Property<bool>("MustUpdatePassword")
 221289                        .HasColumnType("INTEGER");
 221290
 221291                    b.Property<string>("Password")
 221292                        .HasMaxLength(65535)
 221293                        .HasColumnType("TEXT");
 221294
 221295                    b.Property<string>("PasswordResetProviderId")
 221296                        .IsRequired()
 221297                        .HasMaxLength(255)
 221298                        .HasColumnType("TEXT");
 221299
 221300                    b.Property<bool>("PlayDefaultAudioTrack")
 221301                        .HasColumnType("INTEGER");
 221302
 221303                    b.Property<bool>("RememberAudioSelections")
 221304                        .HasColumnType("INTEGER");
 221305
 221306                    b.Property<bool>("RememberSubtitleSelections")
 221307                        .HasColumnType("INTEGER");
 221308
 221309                    b.Property<int?>("RemoteClientBitrateLimit")
 221310                        .HasColumnType("INTEGER");
 221311
 221312                    b.Property<uint>("RowVersion")
 221313                        .IsConcurrencyToken()
 221314                        .HasColumnType("INTEGER");
 221315
 221316                    b.Property<string>("SubtitleLanguagePreference")
 221317                        .HasMaxLength(255)
 221318                        .HasColumnType("TEXT");
 221319
 221320                    b.Property<int>("SubtitleMode")
 221321                        .HasColumnType("INTEGER");
 221322
 221323                    b.Property<int>("SyncPlayAccess")
 221324                        .HasColumnType("INTEGER");
 221325
 221326                    b.Property<string>("Username")
 221327                        .IsRequired()
 221328                        .HasMaxLength(255)
 221329                        .HasColumnType("TEXT");
 221330
 221331                    b.HasKey("Id");
 221332
 221333                    b.HasIndex("Username")
 221334                        .IsUnique();
 221335
 221336                    b.ToTable("Users");
 221337
 221338                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221339                });
 1340
 221341            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 221342                {
 221343                    b.Property<Guid>("ItemId")
 221344                        .HasColumnType("TEXT");
 221345
 221346                    b.Property<Guid>("UserId")
 221347                        .HasColumnType("TEXT");
 221348
 221349                    b.Property<string>("CustomDataKey")
 221350                        .HasColumnType("TEXT");
 221351
 221352                    b.Property<int?>("AudioStreamIndex")
 221353                        .HasColumnType("INTEGER");
 221354
 221355                    b.Property<bool>("IsFavorite")
 221356                        .HasColumnType("INTEGER");
 221357
 221358                    b.Property<DateTime?>("LastPlayedDate")
 221359                        .HasColumnType("TEXT");
 221360
 221361                    b.Property<bool?>("Likes")
 221362                        .HasColumnType("INTEGER");
 221363
 221364                    b.Property<int>("PlayCount")
 221365                        .HasColumnType("INTEGER");
 221366
 221367                    b.Property<long>("PlaybackPositionTicks")
 221368                        .HasColumnType("INTEGER");
 221369
 221370                    b.Property<bool>("Played")
 221371                        .HasColumnType("INTEGER");
 221372
 221373                    b.Property<double?>("Rating")
 221374                        .HasColumnType("REAL");
 221375
 221376                    b.Property<int?>("SubtitleStreamIndex")
 221377                        .HasColumnType("INTEGER");
 221378
 221379                    b.HasKey("ItemId", "UserId", "CustomDataKey");
 221380
 221381                    b.HasIndex("UserId");
 221382
 221383                    b.HasIndex("ItemId", "UserId", "IsFavorite");
 221384
 221385                    b.HasIndex("ItemId", "UserId", "LastPlayedDate");
 221386
 221387                    b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks");
 221388
 221389                    b.HasIndex("ItemId", "UserId", "Played");
 221390
 221391                    b.ToTable("UserData");
 221392
 221393                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 221394                });
 1395
 221396            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>
 221397                {
 221398                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 221399                        .WithMany("AccessSchedules")
 221400                        .HasForeignKey("UserId")
 221401                        .OnDelete(DeleteBehavior.Cascade)
 221402                        .IsRequired();
 221403                });
 1404
 221405            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>
 221406                {
 221407                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221408                        .WithMany("Parents")
 221409                        .HasForeignKey("ItemId")
 221410                        .OnDelete(DeleteBehavior.Cascade)
 221411                        .IsRequired();
 221412
 221413                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "ParentItem")
 221414                        .WithMany("Children")
 221415                        .HasForeignKey("ParentItemId")
 221416                        .OnDelete(DeleteBehavior.Cascade)
 221417                        .IsRequired();
 221418
 221419                    b.Navigation("Item");
 221420
 221421                    b.Navigation("ParentItem");
 221422                });
 1423
 221424            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>
 221425                {
 221426                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221427                        .WithMany()
 221428                        .HasForeignKey("ItemId")
 221429                        .OnDelete(DeleteBehavior.Cascade)
 221430                        .IsRequired();
 221431
 221432                    b.Navigation("Item");
 221433                });
 1434
 221435            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 221436                {
 221437                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221438                        .WithMany("Images")
 221439                        .HasForeignKey("ItemId")
 221440                        .OnDelete(DeleteBehavior.Cascade)
 221441                        .IsRequired();
 221442
 221443                    b.Navigation("Item");
 221444                });
 1445
 221446            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 221447                {
 221448                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221449                        .WithMany("LockedFields")
 221450                        .HasForeignKey("ItemId")
 221451                        .OnDelete(DeleteBehavior.Cascade)
 221452                        .IsRequired();
 221453
 221454                    b.Navigation("Item");
 221455                });
 1456
 221457            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 221458                {
 221459                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221460                        .WithMany("Provider")
 221461                        .HasForeignKey("ItemId")
 221462                        .OnDelete(DeleteBehavior.Cascade)
 221463                        .IsRequired();
 221464
 221465                    b.Navigation("Item");
 221466                });
 1467
 221468            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 221469                {
 221470                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221471                        .WithMany("TrailerTypes")
 221472                        .HasForeignKey("ItemId")
 221473                        .OnDelete(DeleteBehavior.Cascade)
 221474                        .IsRequired();
 221475
 221476                    b.Navigation("Item");
 221477                });
 1478
 221479            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 221480                {
 221481                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221482                        .WithMany("Chapters")
 221483                        .HasForeignKey("ItemId")
 221484                        .OnDelete(DeleteBehavior.Cascade)
 221485                        .IsRequired();
 221486
 221487                    b.Navigation("Item");
 221488                });
 1489
 221490            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 221491                {
 221492                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 221493                        .WithMany("DisplayPreferences")
 221494                        .HasForeignKey("UserId")
 221495                        .OnDelete(DeleteBehavior.Cascade)
 221496                        .IsRequired();
 221497                });
 1498
 221499            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 221500                {
 221501                    b.HasOne("Jellyfin.Database.Implementations.Entities.DisplayPreferences", null)
 221502                        .WithMany("HomeSections")
 221503                        .HasForeignKey("DisplayPreferencesId")
 221504                        .OnDelete(DeleteBehavior.Cascade)
 221505                        .IsRequired();
 221506                });
 1507
 221508            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 221509                {
 221510                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 221511                        .WithOne("ProfileImage")
 221512                        .HasForeignKey("Jellyfin.Database.Implementations.Entities.ImageInfo", "UserId")
 221513                        .OnDelete(DeleteBehavior.Cascade);
 221514                });
 1515
 221516            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 221517                {
 221518                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 221519                        .WithMany("ItemDisplayPreferences")
 221520                        .HasForeignKey("UserId")
 221521                        .OnDelete(DeleteBehavior.Cascade)
 221522                        .IsRequired();
 221523                });
 1524
 221525            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 221526                {
 221527                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221528                        .WithMany("ItemValues")
 221529                        .HasForeignKey("ItemId")
 221530                        .OnDelete(DeleteBehavior.Cascade)
 221531                        .IsRequired();
 221532
 221533                    b.HasOne("Jellyfin.Database.Implementations.Entities.ItemValue", "ItemValue")
 221534                        .WithMany("BaseItemsMap")
 221535                        .HasForeignKey("ItemValueId")
 221536                        .OnDelete(DeleteBehavior.Cascade)
 221537                        .IsRequired();
 221538
 221539                    b.Navigation("Item");
 221540
 221541                    b.Navigation("ItemValue");
 221542                });
 1543
 221544            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 221545                {
 221546                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221547                        .WithMany()
 221548                        .HasForeignKey("ItemId")
 221549                        .OnDelete(DeleteBehavior.Cascade)
 221550                        .IsRequired();
 221551
 221552                    b.Navigation("Item");
 221553                });
 1554
 221555            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 221556                {
 221557                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221558                        .WithMany("MediaStreams")
 221559                        .HasForeignKey("ItemId")
 221560                        .OnDelete(DeleteBehavior.Cascade)
 221561                        .IsRequired();
 221562
 221563                    b.Navigation("Item");
 221564                });
 1565
 221566            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 221567                {
 221568                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221569                        .WithMany("Peoples")
 221570                        .HasForeignKey("ItemId")
 221571                        .OnDelete(DeleteBehavior.Cascade)
 221572                        .IsRequired();
 221573
 221574                    b.HasOne("Jellyfin.Database.Implementations.Entities.People", "People")
 221575                        .WithMany("BaseItems")
 221576                        .HasForeignKey("PeopleId")
 221577                        .OnDelete(DeleteBehavior.Cascade)
 221578                        .IsRequired();
 221579
 221580                    b.Navigation("Item");
 221581
 221582                    b.Navigation("People");
 221583                });
 1584
 221585            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 221586                {
 221587                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 221588                        .WithMany("Permissions")
 221589                        .HasForeignKey("UserId")
 221590                        .OnDelete(DeleteBehavior.Cascade);
 221591                });
 1592
 221593            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 221594                {
 221595                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 221596                        .WithMany("Preferences")
 221597                        .HasForeignKey("UserId")
 221598                        .OnDelete(DeleteBehavior.Cascade);
 221599                });
 1600
 221601            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 221602                {
 221603                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 221604                        .WithMany()
 221605                        .HasForeignKey("UserId")
 221606                        .OnDelete(DeleteBehavior.Cascade)
 221607                        .IsRequired();
 221608
 221609                    b.Navigation("User");
 221610                });
 1611
 221612            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 221613                {
 221614                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 221615                        .WithMany("UserData")
 221616                        .HasForeignKey("ItemId")
 221617                        .OnDelete(DeleteBehavior.Cascade)
 221618                        .IsRequired();
 221619
 221620                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 221621                        .WithMany()
 221622                        .HasForeignKey("UserId")
 221623                        .OnDelete(DeleteBehavior.Cascade)
 221624                        .IsRequired();
 221625
 221626                    b.Navigation("Item");
 221627
 221628                    b.Navigation("User");
 221629                });
 1630
 221631            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 221632                {
 221633                    b.Navigation("Chapters");
 221634
 221635                    b.Navigation("Children");
 221636
 221637                    b.Navigation("Images");
 221638
 221639                    b.Navigation("ItemValues");
 221640
 221641                    b.Navigation("LockedFields");
 221642
 221643                    b.Navigation("MediaStreams");
 221644
 221645                    b.Navigation("Parents");
 221646
 221647                    b.Navigation("Peoples");
 221648
 221649                    b.Navigation("Provider");
 221650
 221651                    b.Navigation("TrailerTypes");
 221652
 221653                    b.Navigation("UserData");
 221654                });
 1655
 221656            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 221657                {
 221658                    b.Navigation("HomeSections");
 221659                });
 1660
 221661            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 221662                {
 221663                    b.Navigation("BaseItemsMap");
 221664                });
 1665
 221666            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 221667                {
 221668                    b.Navigation("BaseItems");
 221669                });
 1670
 221671            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 221672                {
 221673                    b.Navigation("AccessSchedules");
 221674
 221675                    b.Navigation("DisplayPreferences");
 221676
 221677                    b.Navigation("ItemDisplayPreferences");
 221678
 221679                    b.Navigation("Permissions");
 221680
 221681                    b.Navigation("Preferences");
 221682
 221683                    b.Navigation("ProfileImage");
 221684                });
 1685#pragma warning restore 612, 618
 221686        }
 1687    }
 1688}
Generated by: ReportGenerator 5.4.5.0
4/26/2025 - 12:10:59 AM
GitHub | reportgenerator.io

Methods/Properties

BuildModel(Microsoft.EntityFrameworkCore.ModelBuilder)