< Summary - Jellyfin

Information
Class: Jellyfin.Server.Implementations.Migrations.FixMediaStreams2
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20241112234144_FixMediaStreams2.cs
File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20241112234144_FixMediaStreams2.Designer.cs
Line coverage
96%
Covered lines: 1568
Uncovered lines: 64
Coverable lines: 1632
Total lines: 1738
Line coverage: 96%
Branch coverage
N/A
Covered branches: 0
Total branches: 0
Branch coverage: N/A
Method coverage

Feature is only available for sponsors

Upgrade to PRO version

Coverage history

Coverage history 0 25 50 75 100

Metrics

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

File(s)

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

#LineLine coverage
 1using Microsoft.EntityFrameworkCore.Migrations;
 2
 3#nullable disable
 4
 5namespace Jellyfin.Server.Implementations.Migrations
 6{
 7    /// <inheritdoc />
 8    public partial class FixMediaStreams2 : Migration
 9    {
 10        /// <inheritdoc />
 11        protected override void Up(MigrationBuilder migrationBuilder)
 12        {
 2113            migrationBuilder.AlterColumn<string>(
 2114                name: "Profile",
 2115                table: "MediaStreamInfos",
 2116                type: "TEXT",
 2117                nullable: true,
 2118                oldClrType: typeof(string),
 2119                oldType: "TEXT");
 20
 2121            migrationBuilder.AlterColumn<string>(
 2122                name: "Path",
 2123                table: "MediaStreamInfos",
 2124                type: "TEXT",
 2125                nullable: true,
 2126                oldClrType: typeof(string),
 2127                oldType: "TEXT");
 28
 2129            migrationBuilder.AlterColumn<string>(
 2130                name: "Language",
 2131                table: "MediaStreamInfos",
 2132                type: "TEXT",
 2133                nullable: true,
 2134                oldClrType: typeof(string),
 2135                oldType: "TEXT");
 36
 2137            migrationBuilder.AlterColumn<bool>(
 2138                name: "IsInterlaced",
 2139                table: "MediaStreamInfos",
 2140                type: "INTEGER",
 2141                nullable: true,
 2142                oldClrType: typeof(bool),
 2143                oldType: "INTEGER");
 44
 2145            migrationBuilder.AlterColumn<string>(
 2146                name: "Codec",
 2147                table: "MediaStreamInfos",
 2148                type: "TEXT",
 2149                nullable: true,
 2150                oldClrType: typeof(string),
 2151                oldType: "TEXT");
 52
 2153            migrationBuilder.AlterColumn<string>(
 2154                name: "ChannelLayout",
 2155                table: "MediaStreamInfos",
 2156                type: "TEXT",
 2157                nullable: true,
 2158                oldClrType: typeof(string),
 2159                oldType: "TEXT");
 60
 2161            migrationBuilder.AlterColumn<string>(
 2162                name: "AspectRatio",
 2163                table: "MediaStreamInfos",
 2164                type: "TEXT",
 2165                nullable: true,
 2166                oldClrType: typeof(string),
 2167                oldType: "TEXT");
 2168        }
 69
 70        /// <inheritdoc />
 71        protected override void Down(MigrationBuilder migrationBuilder)
 72        {
 073            migrationBuilder.AlterColumn<string>(
 074                name: "Profile",
 075                table: "MediaStreamInfos",
 076                type: "TEXT",
 077                nullable: false,
 078                defaultValue: string.Empty,
 079                oldClrType: typeof(string),
 080                oldType: "TEXT",
 081                oldNullable: true);
 82
 083            migrationBuilder.AlterColumn<string>(
 084                name: "Path",
 085                table: "MediaStreamInfos",
 086                type: "TEXT",
 087                nullable: false,
 088                defaultValue: string.Empty,
 089                oldClrType: typeof(string),
 090                oldType: "TEXT",
 091                oldNullable: true);
 92
 093            migrationBuilder.AlterColumn<string>(
 094                name: "Language",
 095                table: "MediaStreamInfos",
 096                type: "TEXT",
 097                nullable: false,
 098                defaultValue: string.Empty,
 099                oldClrType: typeof(string),
 0100                oldType: "TEXT",
 0101                oldNullable: true);
 102
 0103            migrationBuilder.AlterColumn<bool>(
 0104                name: "IsInterlaced",
 0105                table: "MediaStreamInfos",
 0106                type: "INTEGER",
 0107                nullable: false,
 0108                defaultValue: false,
 0109                oldClrType: typeof(bool),
 0110                oldType: "INTEGER",
 0111                oldNullable: true);
 112
 0113            migrationBuilder.AlterColumn<string>(
 0114                name: "Codec",
 0115                table: "MediaStreamInfos",
 0116                type: "TEXT",
 0117                nullable: false,
 0118                defaultValue: string.Empty,
 0119                oldClrType: typeof(string),
 0120                oldType: "TEXT",
 0121                oldNullable: true);
 122
 0123            migrationBuilder.AlterColumn<string>(
 0124                name: "ChannelLayout",
 0125                table: "MediaStreamInfos",
 0126                type: "TEXT",
 0127                nullable: false,
 0128                defaultValue: string.Empty,
 0129                oldClrType: typeof(string),
 0130                oldType: "TEXT",
 0131                oldNullable: true);
 132
 0133            migrationBuilder.AlterColumn<string>(
 0134                name: "AspectRatio",
 0135                table: "MediaStreamInfos",
 0136                type: "TEXT",
 0137                nullable: false,
 0138                defaultValue: string.Empty,
 0139                oldClrType: typeof(string),
 0140                oldType: "TEXT",
 0141                oldNullable: true);
 0142        }
 143    }
 144}

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20241112234144_FixMediaStreams2.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.Server.Implementations.Migrations
 12{
 13    [DbContext(typeof(JellyfinDbContext))]
 14    [Migration("20241112234144_FixMediaStreams2")]
 15    partial class FixMediaStreams2
 16    {
 17        /// <inheritdoc />
 18        protected override void BuildTargetModel(ModelBuilder modelBuilder)
 19        {
 20#pragma warning disable 612, 618
 2121            modelBuilder.HasAnnotation("ProductVersion", "8.0.10");
 22
 2123            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 2124                {
 2125                    b.Property<int>("Id")
 2126                        .ValueGeneratedOnAdd()
 2127                        .HasColumnType("INTEGER");
 2128
 2129                    b.Property<int>("DayOfWeek")
 2130                        .HasColumnType("INTEGER");
 2131
 2132                    b.Property<double>("EndHour")
 2133                        .HasColumnType("REAL");
 2134
 2135                    b.Property<double>("StartHour")
 2136                        .HasColumnType("REAL");
 2137
 2138                    b.Property<Guid>("UserId")
 2139                        .HasColumnType("TEXT");
 2140
 2141                    b.HasKey("Id");
 2142
 2143                    b.HasIndex("UserId");
 2144
 2145                    b.ToTable("AccessSchedules");
 2146                });
 47
 2148            modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b =>
 2149                {
 2150                    b.Property<int>("Id")
 2151                        .ValueGeneratedOnAdd()
 2152                        .HasColumnType("INTEGER");
 2153
 2154                    b.Property<DateTime>("DateCreated")
 2155                        .HasColumnType("TEXT");
 2156
 2157                    b.Property<string>("ItemId")
 2158                        .HasMaxLength(256)
 2159                        .HasColumnType("TEXT");
 2160
 2161                    b.Property<int>("LogSeverity")
 2162                        .HasColumnType("INTEGER");
 2163
 2164                    b.Property<string>("Name")
 2165                        .IsRequired()
 2166                        .HasMaxLength(512)
 2167                        .HasColumnType("TEXT");
 2168
 2169                    b.Property<string>("Overview")
 2170                        .HasMaxLength(512)
 2171                        .HasColumnType("TEXT");
 2172
 2173                    b.Property<uint>("RowVersion")
 2174                        .IsConcurrencyToken()
 2175                        .HasColumnType("INTEGER");
 2176
 2177                    b.Property<string>("ShortOverview")
 2178                        .HasMaxLength(512)
 2179                        .HasColumnType("TEXT");
 2180
 2181                    b.Property<string>("Type")
 2182                        .IsRequired()
 2183                        .HasMaxLength(256)
 2184                        .HasColumnType("TEXT");
 2185
 2186                    b.Property<Guid>("UserId")
 2187                        .HasColumnType("TEXT");
 2188
 2189                    b.HasKey("Id");
 2190
 2191                    b.HasIndex("DateCreated");
 2192
 2193                    b.ToTable("ActivityLogs");
 2194                });
 95
 2196            modelBuilder.Entity("Jellyfin.Data.Entities.AncestorId", b =>
 2197                {
 2198                    b.Property<Guid>("ItemId")
 2199                        .HasColumnType("TEXT");
 21100
 21101                    b.Property<Guid>("ParentItemId")
 21102                        .HasColumnType("TEXT");
 21103
 21104                    b.HasKey("ItemId", "ParentItemId");
 21105
 21106                    b.HasIndex("ParentItemId");
 21107
 21108                    b.ToTable("AncestorIds");
 21109                });
 110
 21111            modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b =>
 21112                {
 21113                    b.Property<Guid>("ItemId")
 21114                        .HasColumnType("TEXT");
 21115
 21116                    b.Property<int>("Index")
 21117                        .HasColumnType("INTEGER");
 21118
 21119                    b.Property<string>("Codec")
 21120                        .IsRequired()
 21121                        .HasColumnType("TEXT");
 21122
 21123                    b.Property<string>("CodecTag")
 21124                        .HasColumnType("TEXT");
 21125
 21126                    b.Property<string>("Comment")
 21127                        .HasColumnType("TEXT");
 21128
 21129                    b.Property<string>("Filename")
 21130                        .HasColumnType("TEXT");
 21131
 21132                    b.Property<string>("MimeType")
 21133                        .HasColumnType("TEXT");
 21134
 21135                    b.HasKey("ItemId", "Index");
 21136
 21137                    b.ToTable("AttachmentStreamInfos");
 21138                });
 139
 21140            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b =>
 21141                {
 21142                    b.Property<Guid>("Id")
 21143                        .ValueGeneratedOnAdd()
 21144                        .HasColumnType("TEXT");
 21145
 21146                    b.Property<string>("Album")
 21147                        .HasColumnType("TEXT");
 21148
 21149                    b.Property<string>("AlbumArtists")
 21150                        .HasColumnType("TEXT");
 21151
 21152                    b.Property<string>("Artists")
 21153                        .HasColumnType("TEXT");
 21154
 21155                    b.Property<int?>("Audio")
 21156                        .HasColumnType("INTEGER");
 21157
 21158                    b.Property<string>("ChannelId")
 21159                        .HasColumnType("TEXT");
 21160
 21161                    b.Property<string>("CleanName")
 21162                        .HasColumnType("TEXT");
 21163
 21164                    b.Property<float?>("CommunityRating")
 21165                        .HasColumnType("REAL");
 21166
 21167                    b.Property<float?>("CriticRating")
 21168                        .HasColumnType("REAL");
 21169
 21170                    b.Property<string>("CustomRating")
 21171                        .HasColumnType("TEXT");
 21172
 21173                    b.Property<string>("Data")
 21174                        .HasColumnType("TEXT");
 21175
 21176                    b.Property<DateTime?>("DateCreated")
 21177                        .HasColumnType("TEXT");
 21178
 21179                    b.Property<DateTime?>("DateLastMediaAdded")
 21180                        .HasColumnType("TEXT");
 21181
 21182                    b.Property<DateTime?>("DateLastRefreshed")
 21183                        .HasColumnType("TEXT");
 21184
 21185                    b.Property<DateTime?>("DateLastSaved")
 21186                        .HasColumnType("TEXT");
 21187
 21188                    b.Property<DateTime?>("DateModified")
 21189                        .HasColumnType("TEXT");
 21190
 21191                    b.Property<DateTime>("EndDate")
 21192                        .HasColumnType("TEXT");
 21193
 21194                    b.Property<string>("EpisodeTitle")
 21195                        .HasColumnType("TEXT");
 21196
 21197                    b.Property<string>("ExternalId")
 21198                        .HasColumnType("TEXT");
 21199
 21200                    b.Property<string>("ExternalSeriesId")
 21201                        .HasColumnType("TEXT");
 21202
 21203                    b.Property<string>("ExternalServiceId")
 21204                        .HasColumnType("TEXT");
 21205
 21206                    b.Property<string>("ExtraIds")
 21207                        .HasColumnType("TEXT");
 21208
 21209                    b.Property<int?>("ExtraType")
 21210                        .HasColumnType("INTEGER");
 21211
 21212                    b.Property<string>("ForcedSortName")
 21213                        .HasColumnType("TEXT");
 21214
 21215                    b.Property<string>("Genres")
 21216                        .HasColumnType("TEXT");
 21217
 21218                    b.Property<int?>("Height")
 21219                        .HasColumnType("INTEGER");
 21220
 21221                    b.Property<int?>("IndexNumber")
 21222                        .HasColumnType("INTEGER");
 21223
 21224                    b.Property<int?>("InheritedParentalRatingValue")
 21225                        .HasColumnType("INTEGER");
 21226
 21227                    b.Property<bool>("IsFolder")
 21228                        .HasColumnType("INTEGER");
 21229
 21230                    b.Property<bool>("IsInMixedFolder")
 21231                        .HasColumnType("INTEGER");
 21232
 21233                    b.Property<bool>("IsLocked")
 21234                        .HasColumnType("INTEGER");
 21235
 21236                    b.Property<bool>("IsMovie")
 21237                        .HasColumnType("INTEGER");
 21238
 21239                    b.Property<bool>("IsRepeat")
 21240                        .HasColumnType("INTEGER");
 21241
 21242                    b.Property<bool>("IsSeries")
 21243                        .HasColumnType("INTEGER");
 21244
 21245                    b.Property<bool>("IsVirtualItem")
 21246                        .HasColumnType("INTEGER");
 21247
 21248                    b.Property<float?>("LUFS")
 21249                        .HasColumnType("REAL");
 21250
 21251                    b.Property<string>("MediaType")
 21252                        .HasColumnType("TEXT");
 21253
 21254                    b.Property<string>("Name")
 21255                        .HasColumnType("TEXT");
 21256
 21257                    b.Property<float?>("NormalizationGain")
 21258                        .HasColumnType("REAL");
 21259
 21260                    b.Property<string>("OfficialRating")
 21261                        .HasColumnType("TEXT");
 21262
 21263                    b.Property<string>("OriginalTitle")
 21264                        .HasColumnType("TEXT");
 21265
 21266                    b.Property<string>("Overview")
 21267                        .HasColumnType("TEXT");
 21268
 21269                    b.Property<string>("OwnerId")
 21270                        .HasColumnType("TEXT");
 21271
 21272                    b.Property<Guid?>("ParentId")
 21273                        .HasColumnType("TEXT");
 21274
 21275                    b.Property<int?>("ParentIndexNumber")
 21276                        .HasColumnType("INTEGER");
 21277
 21278                    b.Property<string>("Path")
 21279                        .HasColumnType("TEXT");
 21280
 21281                    b.Property<string>("PreferredMetadataCountryCode")
 21282                        .HasColumnType("TEXT");
 21283
 21284                    b.Property<string>("PreferredMetadataLanguage")
 21285                        .HasColumnType("TEXT");
 21286
 21287                    b.Property<DateTime?>("PremiereDate")
 21288                        .HasColumnType("TEXT");
 21289
 21290                    b.Property<string>("PresentationUniqueKey")
 21291                        .HasColumnType("TEXT");
 21292
 21293                    b.Property<string>("PrimaryVersionId")
 21294                        .HasColumnType("TEXT");
 21295
 21296                    b.Property<string>("ProductionLocations")
 21297                        .HasColumnType("TEXT");
 21298
 21299                    b.Property<int?>("ProductionYear")
 21300                        .HasColumnType("INTEGER");
 21301
 21302                    b.Property<long?>("RunTimeTicks")
 21303                        .HasColumnType("INTEGER");
 21304
 21305                    b.Property<Guid?>("SeasonId")
 21306                        .HasColumnType("TEXT");
 21307
 21308                    b.Property<string>("SeasonName")
 21309                        .HasColumnType("TEXT");
 21310
 21311                    b.Property<Guid?>("SeriesId")
 21312                        .HasColumnType("TEXT");
 21313
 21314                    b.Property<string>("SeriesName")
 21315                        .HasColumnType("TEXT");
 21316
 21317                    b.Property<string>("SeriesPresentationUniqueKey")
 21318                        .HasColumnType("TEXT");
 21319
 21320                    b.Property<string>("ShowId")
 21321                        .HasColumnType("TEXT");
 21322
 21323                    b.Property<long?>("Size")
 21324                        .HasColumnType("INTEGER");
 21325
 21326                    b.Property<string>("SortName")
 21327                        .HasColumnType("TEXT");
 21328
 21329                    b.Property<DateTime>("StartDate")
 21330                        .HasColumnType("TEXT");
 21331
 21332                    b.Property<string>("Studios")
 21333                        .HasColumnType("TEXT");
 21334
 21335                    b.Property<string>("Tagline")
 21336                        .HasColumnType("TEXT");
 21337
 21338                    b.Property<string>("Tags")
 21339                        .HasColumnType("TEXT");
 21340
 21341                    b.Property<Guid?>("TopParentId")
 21342                        .HasColumnType("TEXT");
 21343
 21344                    b.Property<int?>("TotalBitrate")
 21345                        .HasColumnType("INTEGER");
 21346
 21347                    b.Property<string>("Type")
 21348                        .IsRequired()
 21349                        .HasColumnType("TEXT");
 21350
 21351                    b.Property<string>("UnratedType")
 21352                        .HasColumnType("TEXT");
 21353
 21354                    b.Property<int?>("Width")
 21355                        .HasColumnType("INTEGER");
 21356
 21357                    b.HasKey("Id");
 21358
 21359                    b.HasIndex("ParentId");
 21360
 21361                    b.HasIndex("Path");
 21362
 21363                    b.HasIndex("PresentationUniqueKey");
 21364
 21365                    b.HasIndex("TopParentId", "Id");
 21366
 21367                    b.HasIndex("Type", "TopParentId", "Id");
 21368
 21369                    b.HasIndex("Type", "TopParentId", "PresentationUniqueKey");
 21370
 21371                    b.HasIndex("Type", "TopParentId", "StartDate");
 21372
 21373                    b.HasIndex("Id", "Type", "IsFolder", "IsVirtualItem");
 21374
 21375                    b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey");
 21376
 21377                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem");
 21378
 21379                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName");
 21380
 21381                    b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 21382
 21383                    b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 21384
 21385                    b.ToTable("BaseItems");
 21386                });
 387
 21388            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b =>
 21389                {
 21390                    b.Property<Guid>("Id")
 21391                        .ValueGeneratedOnAdd()
 21392                        .HasColumnType("TEXT");
 21393
 21394                    b.Property<byte[]>("Blurhash")
 21395                        .HasColumnType("BLOB");
 21396
 21397                    b.Property<DateTime>("DateModified")
 21398                        .HasColumnType("TEXT");
 21399
 21400                    b.Property<int>("Height")
 21401                        .HasColumnType("INTEGER");
 21402
 21403                    b.Property<int>("ImageType")
 21404                        .HasColumnType("INTEGER");
 21405
 21406                    b.Property<Guid>("ItemId")
 21407                        .HasColumnType("TEXT");
 21408
 21409                    b.Property<string>("Path")
 21410                        .IsRequired()
 21411                        .HasColumnType("TEXT");
 21412
 21413                    b.Property<int>("Width")
 21414                        .HasColumnType("INTEGER");
 21415
 21416                    b.HasKey("Id");
 21417
 21418                    b.HasIndex("ItemId");
 21419
 21420                    b.ToTable("BaseItemImageInfos");
 21421                });
 422
 21423            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b =>
 21424                {
 21425                    b.Property<int>("Id")
 21426                        .HasColumnType("INTEGER");
 21427
 21428                    b.Property<Guid>("ItemId")
 21429                        .HasColumnType("TEXT");
 21430
 21431                    b.HasKey("Id", "ItemId");
 21432
 21433                    b.HasIndex("ItemId");
 21434
 21435                    b.ToTable("BaseItemMetadataFields");
 21436                });
 437
 21438            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b =>
 21439                {
 21440                    b.Property<Guid>("ItemId")
 21441                        .HasColumnType("TEXT");
 21442
 21443                    b.Property<string>("ProviderId")
 21444                        .HasColumnType("TEXT");
 21445
 21446                    b.Property<string>("ProviderValue")
 21447                        .IsRequired()
 21448                        .HasColumnType("TEXT");
 21449
 21450                    b.HasKey("ItemId", "ProviderId");
 21451
 21452                    b.HasIndex("ProviderId", "ProviderValue", "ItemId");
 21453
 21454                    b.ToTable("BaseItemProviders");
 21455                });
 456
 21457            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b =>
 21458                {
 21459                    b.Property<int>("Id")
 21460                        .HasColumnType("INTEGER");
 21461
 21462                    b.Property<Guid>("ItemId")
 21463                        .HasColumnType("TEXT");
 21464
 21465                    b.HasKey("Id", "ItemId");
 21466
 21467                    b.HasIndex("ItemId");
 21468
 21469                    b.ToTable("BaseItemTrailerTypes");
 21470                });
 471
 21472            modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b =>
 21473                {
 21474                    b.Property<Guid>("ItemId")
 21475                        .HasColumnType("TEXT");
 21476
 21477                    b.Property<int>("ChapterIndex")
 21478                        .HasColumnType("INTEGER");
 21479
 21480                    b.Property<DateTime?>("ImageDateModified")
 21481                        .HasColumnType("TEXT");
 21482
 21483                    b.Property<string>("ImagePath")
 21484                        .HasColumnType("TEXT");
 21485
 21486                    b.Property<string>("Name")
 21487                        .HasColumnType("TEXT");
 21488
 21489                    b.Property<long>("StartPositionTicks")
 21490                        .HasColumnType("INTEGER");
 21491
 21492                    b.HasKey("ItemId", "ChapterIndex");
 21493
 21494                    b.ToTable("Chapters");
 21495                });
 496
 21497            modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b =>
 21498                {
 21499                    b.Property<int>("Id")
 21500                        .ValueGeneratedOnAdd()
 21501                        .HasColumnType("INTEGER");
 21502
 21503                    b.Property<string>("Client")
 21504                        .IsRequired()
 21505                        .HasMaxLength(32)
 21506                        .HasColumnType("TEXT");
 21507
 21508                    b.Property<Guid>("ItemId")
 21509                        .HasColumnType("TEXT");
 21510
 21511                    b.Property<string>("Key")
 21512                        .IsRequired()
 21513                        .HasColumnType("TEXT");
 21514
 21515                    b.Property<Guid>("UserId")
 21516                        .HasColumnType("TEXT");
 21517
 21518                    b.Property<string>("Value")
 21519                        .HasColumnType("TEXT");
 21520
 21521                    b.HasKey("Id");
 21522
 21523                    b.HasIndex("UserId", "ItemId", "Client", "Key")
 21524                        .IsUnique();
 21525
 21526                    b.ToTable("CustomItemDisplayPreferences");
 21527                });
 528
 21529            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21530                {
 21531                    b.Property<int>("Id")
 21532                        .ValueGeneratedOnAdd()
 21533                        .HasColumnType("INTEGER");
 21534
 21535                    b.Property<int>("ChromecastVersion")
 21536                        .HasColumnType("INTEGER");
 21537
 21538                    b.Property<string>("Client")
 21539                        .IsRequired()
 21540                        .HasMaxLength(32)
 21541                        .HasColumnType("TEXT");
 21542
 21543                    b.Property<string>("DashboardTheme")
 21544                        .HasMaxLength(32)
 21545                        .HasColumnType("TEXT");
 21546
 21547                    b.Property<bool>("EnableNextVideoInfoOverlay")
 21548                        .HasColumnType("INTEGER");
 21549
 21550                    b.Property<int?>("IndexBy")
 21551                        .HasColumnType("INTEGER");
 21552
 21553                    b.Property<Guid>("ItemId")
 21554                        .HasColumnType("TEXT");
 21555
 21556                    b.Property<int>("ScrollDirection")
 21557                        .HasColumnType("INTEGER");
 21558
 21559                    b.Property<bool>("ShowBackdrop")
 21560                        .HasColumnType("INTEGER");
 21561
 21562                    b.Property<bool>("ShowSidebar")
 21563                        .HasColumnType("INTEGER");
 21564
 21565                    b.Property<int>("SkipBackwardLength")
 21566                        .HasColumnType("INTEGER");
 21567
 21568                    b.Property<int>("SkipForwardLength")
 21569                        .HasColumnType("INTEGER");
 21570
 21571                    b.Property<string>("TvHome")
 21572                        .HasMaxLength(32)
 21573                        .HasColumnType("TEXT");
 21574
 21575                    b.Property<Guid>("UserId")
 21576                        .HasColumnType("TEXT");
 21577
 21578                    b.HasKey("Id");
 21579
 21580                    b.HasIndex("UserId", "ItemId", "Client")
 21581                        .IsUnique();
 21582
 21583                    b.ToTable("DisplayPreferences");
 21584                });
 585
 21586            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 21587                {
 21588                    b.Property<int>("Id")
 21589                        .ValueGeneratedOnAdd()
 21590                        .HasColumnType("INTEGER");
 21591
 21592                    b.Property<int>("DisplayPreferencesId")
 21593                        .HasColumnType("INTEGER");
 21594
 21595                    b.Property<int>("Order")
 21596                        .HasColumnType("INTEGER");
 21597
 21598                    b.Property<int>("Type")
 21599                        .HasColumnType("INTEGER");
 21600
 21601                    b.HasKey("Id");
 21602
 21603                    b.HasIndex("DisplayPreferencesId");
 21604
 21605                    b.ToTable("HomeSection");
 21606                });
 607
 21608            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21609                {
 21610                    b.Property<int>("Id")
 21611                        .ValueGeneratedOnAdd()
 21612                        .HasColumnType("INTEGER");
 21613
 21614                    b.Property<DateTime>("LastModified")
 21615                        .HasColumnType("TEXT");
 21616
 21617                    b.Property<string>("Path")
 21618                        .IsRequired()
 21619                        .HasMaxLength(512)
 21620                        .HasColumnType("TEXT");
 21621
 21622                    b.Property<Guid?>("UserId")
 21623                        .HasColumnType("TEXT");
 21624
 21625                    b.HasKey("Id");
 21626
 21627                    b.HasIndex("UserId")
 21628                        .IsUnique();
 21629
 21630                    b.ToTable("ImageInfos");
 21631                });
 632
 21633            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 21634                {
 21635                    b.Property<int>("Id")
 21636                        .ValueGeneratedOnAdd()
 21637                        .HasColumnType("INTEGER");
 21638
 21639                    b.Property<string>("Client")
 21640                        .IsRequired()
 21641                        .HasMaxLength(32)
 21642                        .HasColumnType("TEXT");
 21643
 21644                    b.Property<int?>("IndexBy")
 21645                        .HasColumnType("INTEGER");
 21646
 21647                    b.Property<Guid>("ItemId")
 21648                        .HasColumnType("TEXT");
 21649
 21650                    b.Property<bool>("RememberIndexing")
 21651                        .HasColumnType("INTEGER");
 21652
 21653                    b.Property<bool>("RememberSorting")
 21654                        .HasColumnType("INTEGER");
 21655
 21656                    b.Property<string>("SortBy")
 21657                        .IsRequired()
 21658                        .HasMaxLength(64)
 21659                        .HasColumnType("TEXT");
 21660
 21661                    b.Property<int>("SortOrder")
 21662                        .HasColumnType("INTEGER");
 21663
 21664                    b.Property<Guid>("UserId")
 21665                        .HasColumnType("TEXT");
 21666
 21667                    b.Property<int>("ViewType")
 21668                        .HasColumnType("INTEGER");
 21669
 21670                    b.HasKey("Id");
 21671
 21672                    b.HasIndex("UserId");
 21673
 21674                    b.ToTable("ItemDisplayPreferences");
 21675                });
 676
 21677            modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b =>
 21678                {
 21679                    b.Property<Guid>("ItemValueId")
 21680                        .ValueGeneratedOnAdd()
 21681                        .HasColumnType("TEXT");
 21682
 21683                    b.Property<string>("CleanValue")
 21684                        .IsRequired()
 21685                        .HasColumnType("TEXT");
 21686
 21687                    b.Property<int>("Type")
 21688                        .HasColumnType("INTEGER");
 21689
 21690                    b.Property<string>("Value")
 21691                        .IsRequired()
 21692                        .HasColumnType("TEXT");
 21693
 21694                    b.HasKey("ItemValueId");
 21695
 21696                    b.HasIndex("Type", "CleanValue");
 21697
 21698                    b.ToTable("ItemValues");
 21699                });
 700
 21701            modelBuilder.Entity("Jellyfin.Data.Entities.ItemValueMap", b =>
 21702                {
 21703                    b.Property<Guid>("ItemValueId")
 21704                        .HasColumnType("TEXT");
 21705
 21706                    b.Property<Guid>("ItemId")
 21707                        .HasColumnType("TEXT");
 21708
 21709                    b.HasKey("ItemValueId", "ItemId");
 21710
 21711                    b.HasIndex("ItemId");
 21712
 21713                    b.ToTable("ItemValuesMap");
 21714                });
 715
 21716            modelBuilder.Entity("Jellyfin.Data.Entities.MediaSegment", b =>
 21717                {
 21718                    b.Property<Guid>("Id")
 21719                        .ValueGeneratedOnAdd()
 21720                        .HasColumnType("TEXT");
 21721
 21722                    b.Property<long>("EndTicks")
 21723                        .HasColumnType("INTEGER");
 21724
 21725                    b.Property<Guid>("ItemId")
 21726                        .HasColumnType("TEXT");
 21727
 21728                    b.Property<string>("SegmentProviderId")
 21729                        .IsRequired()
 21730                        .HasColumnType("TEXT");
 21731
 21732                    b.Property<long>("StartTicks")
 21733                        .HasColumnType("INTEGER");
 21734
 21735                    b.Property<int>("Type")
 21736                        .HasColumnType("INTEGER");
 21737
 21738                    b.HasKey("Id");
 21739
 21740                    b.ToTable("MediaSegments");
 21741                });
 742
 21743            modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b =>
 21744                {
 21745                    b.Property<Guid>("ItemId")
 21746                        .HasColumnType("TEXT");
 21747
 21748                    b.Property<int>("StreamIndex")
 21749                        .HasColumnType("INTEGER");
 21750
 21751                    b.Property<string>("AspectRatio")
 21752                        .HasColumnType("TEXT");
 21753
 21754                    b.Property<float?>("AverageFrameRate")
 21755                        .HasColumnType("REAL");
 21756
 21757                    b.Property<int?>("BitDepth")
 21758                        .HasColumnType("INTEGER");
 21759
 21760                    b.Property<int?>("BitRate")
 21761                        .HasColumnType("INTEGER");
 21762
 21763                    b.Property<int?>("BlPresentFlag")
 21764                        .HasColumnType("INTEGER");
 21765
 21766                    b.Property<string>("ChannelLayout")
 21767                        .HasColumnType("TEXT");
 21768
 21769                    b.Property<int?>("Channels")
 21770                        .HasColumnType("INTEGER");
 21771
 21772                    b.Property<string>("Codec")
 21773                        .HasColumnType("TEXT");
 21774
 21775                    b.Property<string>("CodecTag")
 21776                        .HasColumnType("TEXT");
 21777
 21778                    b.Property<string>("CodecTimeBase")
 21779                        .HasColumnType("TEXT");
 21780
 21781                    b.Property<string>("ColorPrimaries")
 21782                        .HasColumnType("TEXT");
 21783
 21784                    b.Property<string>("ColorSpace")
 21785                        .HasColumnType("TEXT");
 21786
 21787                    b.Property<string>("ColorTransfer")
 21788                        .HasColumnType("TEXT");
 21789
 21790                    b.Property<string>("Comment")
 21791                        .HasColumnType("TEXT");
 21792
 21793                    b.Property<int?>("DvBlSignalCompatibilityId")
 21794                        .HasColumnType("INTEGER");
 21795
 21796                    b.Property<int?>("DvLevel")
 21797                        .HasColumnType("INTEGER");
 21798
 21799                    b.Property<int?>("DvProfile")
 21800                        .HasColumnType("INTEGER");
 21801
 21802                    b.Property<int?>("DvVersionMajor")
 21803                        .HasColumnType("INTEGER");
 21804
 21805                    b.Property<int?>("DvVersionMinor")
 21806                        .HasColumnType("INTEGER");
 21807
 21808                    b.Property<int?>("ElPresentFlag")
 21809                        .HasColumnType("INTEGER");
 21810
 21811                    b.Property<int?>("Height")
 21812                        .HasColumnType("INTEGER");
 21813
 21814                    b.Property<bool?>("IsAnamorphic")
 21815                        .HasColumnType("INTEGER");
 21816
 21817                    b.Property<bool?>("IsAvc")
 21818                        .HasColumnType("INTEGER");
 21819
 21820                    b.Property<bool>("IsDefault")
 21821                        .HasColumnType("INTEGER");
 21822
 21823                    b.Property<bool>("IsExternal")
 21824                        .HasColumnType("INTEGER");
 21825
 21826                    b.Property<bool>("IsForced")
 21827                        .HasColumnType("INTEGER");
 21828
 21829                    b.Property<bool?>("IsHearingImpaired")
 21830                        .HasColumnType("INTEGER");
 21831
 21832                    b.Property<bool?>("IsInterlaced")
 21833                        .HasColumnType("INTEGER");
 21834
 21835                    b.Property<string>("KeyFrames")
 21836                        .HasColumnType("TEXT");
 21837
 21838                    b.Property<string>("Language")
 21839                        .HasColumnType("TEXT");
 21840
 21841                    b.Property<float?>("Level")
 21842                        .HasColumnType("REAL");
 21843
 21844                    b.Property<string>("NalLengthSize")
 21845                        .HasColumnType("TEXT");
 21846
 21847                    b.Property<string>("Path")
 21848                        .HasColumnType("TEXT");
 21849
 21850                    b.Property<string>("PixelFormat")
 21851                        .HasColumnType("TEXT");
 21852
 21853                    b.Property<string>("Profile")
 21854                        .HasColumnType("TEXT");
 21855
 21856                    b.Property<float?>("RealFrameRate")
 21857                        .HasColumnType("REAL");
 21858
 21859                    b.Property<int?>("RefFrames")
 21860                        .HasColumnType("INTEGER");
 21861
 21862                    b.Property<int?>("Rotation")
 21863                        .HasColumnType("INTEGER");
 21864
 21865                    b.Property<int?>("RpuPresentFlag")
 21866                        .HasColumnType("INTEGER");
 21867
 21868                    b.Property<int?>("SampleRate")
 21869                        .HasColumnType("INTEGER");
 21870
 21871                    b.Property<int>("StreamType")
 21872                        .HasColumnType("INTEGER");
 21873
 21874                    b.Property<string>("TimeBase")
 21875                        .HasColumnType("TEXT");
 21876
 21877                    b.Property<string>("Title")
 21878                        .HasColumnType("TEXT");
 21879
 21880                    b.Property<int?>("Width")
 21881                        .HasColumnType("INTEGER");
 21882
 21883                    b.HasKey("ItemId", "StreamIndex");
 21884
 21885                    b.HasIndex("StreamIndex");
 21886
 21887                    b.HasIndex("StreamType");
 21888
 21889                    b.HasIndex("StreamIndex", "StreamType");
 21890
 21891                    b.HasIndex("StreamIndex", "StreamType", "Language");
 21892
 21893                    b.ToTable("MediaStreamInfos");
 21894                });
 895
 21896            modelBuilder.Entity("Jellyfin.Data.Entities.People", b =>
 21897                {
 21898                    b.Property<Guid>("Id")
 21899                        .ValueGeneratedOnAdd()
 21900                        .HasColumnType("TEXT");
 21901
 21902                    b.Property<string>("Name")
 21903                        .IsRequired()
 21904                        .HasColumnType("TEXT");
 21905
 21906                    b.Property<string>("PersonType")
 21907                        .HasColumnType("TEXT");
 21908
 21909                    b.HasKey("Id");
 21910
 21911                    b.HasIndex("Name");
 21912
 21913                    b.ToTable("Peoples");
 21914                });
 915
 21916            modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b =>
 21917                {
 21918                    b.Property<Guid>("ItemId")
 21919                        .HasColumnType("TEXT");
 21920
 21921                    b.Property<Guid>("PeopleId")
 21922                        .HasColumnType("TEXT");
 21923
 21924                    b.Property<int?>("ListOrder")
 21925                        .HasColumnType("INTEGER");
 21926
 21927                    b.Property<string>("Role")
 21928                        .HasColumnType("TEXT");
 21929
 21930                    b.Property<int?>("SortOrder")
 21931                        .HasColumnType("INTEGER");
 21932
 21933                    b.HasKey("ItemId", "PeopleId");
 21934
 21935                    b.HasIndex("PeopleId");
 21936
 21937                    b.HasIndex("ItemId", "ListOrder");
 21938
 21939                    b.HasIndex("ItemId", "SortOrder");
 21940
 21941                    b.ToTable("PeopleBaseItemMap");
 21942                });
 943
 21944            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21945                {
 21946                    b.Property<int>("Id")
 21947                        .ValueGeneratedOnAdd()
 21948                        .HasColumnType("INTEGER");
 21949
 21950                    b.Property<int>("Kind")
 21951                        .HasColumnType("INTEGER");
 21952
 21953                    b.Property<Guid?>("Permission_Permissions_Guid")
 21954                        .HasColumnType("TEXT");
 21955
 21956                    b.Property<uint>("RowVersion")
 21957                        .IsConcurrencyToken()
 21958                        .HasColumnType("INTEGER");
 21959
 21960                    b.Property<Guid?>("UserId")
 21961                        .HasColumnType("TEXT");
 21962
 21963                    b.Property<bool>("Value")
 21964                        .HasColumnType("INTEGER");
 21965
 21966                    b.HasKey("Id");
 21967
 21968                    b.HasIndex("UserId", "Kind")
 21969                        .IsUnique()
 21970                        .HasFilter("[UserId] IS NOT NULL");
 21971
 21972                    b.ToTable("Permissions");
 21973                });
 974
 21975            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21976                {
 21977                    b.Property<int>("Id")
 21978                        .ValueGeneratedOnAdd()
 21979                        .HasColumnType("INTEGER");
 21980
 21981                    b.Property<int>("Kind")
 21982                        .HasColumnType("INTEGER");
 21983
 21984                    b.Property<Guid?>("Preference_Preferences_Guid")
 21985                        .HasColumnType("TEXT");
 21986
 21987                    b.Property<uint>("RowVersion")
 21988                        .IsConcurrencyToken()
 21989                        .HasColumnType("INTEGER");
 21990
 21991                    b.Property<Guid?>("UserId")
 21992                        .HasColumnType("TEXT");
 21993
 21994                    b.Property<string>("Value")
 21995                        .IsRequired()
 21996                        .HasMaxLength(65535)
 21997                        .HasColumnType("TEXT");
 21998
 21999                    b.HasKey("Id");
 211000
 211001                    b.HasIndex("UserId", "Kind")
 211002                        .IsUnique()
 211003                        .HasFilter("[UserId] IS NOT NULL");
 211004
 211005                    b.ToTable("Preferences");
 211006                });
 1007
 211008            modelBuilder.Entity("Jellyfin.Data.Entities.Security.ApiKey", b =>
 211009                {
 211010                    b.Property<int>("Id")
 211011                        .ValueGeneratedOnAdd()
 211012                        .HasColumnType("INTEGER");
 211013
 211014                    b.Property<string>("AccessToken")
 211015                        .IsRequired()
 211016                        .HasColumnType("TEXT");
 211017
 211018                    b.Property<DateTime>("DateCreated")
 211019                        .HasColumnType("TEXT");
 211020
 211021                    b.Property<DateTime>("DateLastActivity")
 211022                        .HasColumnType("TEXT");
 211023
 211024                    b.Property<string>("Name")
 211025                        .IsRequired()
 211026                        .HasMaxLength(64)
 211027                        .HasColumnType("TEXT");
 211028
 211029                    b.HasKey("Id");
 211030
 211031                    b.HasIndex("AccessToken")
 211032                        .IsUnique();
 211033
 211034                    b.ToTable("ApiKeys");
 211035                });
 1036
 211037            modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
 211038                {
 211039                    b.Property<int>("Id")
 211040                        .ValueGeneratedOnAdd()
 211041                        .HasColumnType("INTEGER");
 211042
 211043                    b.Property<string>("AccessToken")
 211044                        .IsRequired()
 211045                        .HasColumnType("TEXT");
 211046
 211047                    b.Property<string>("AppName")
 211048                        .IsRequired()
 211049                        .HasMaxLength(64)
 211050                        .HasColumnType("TEXT");
 211051
 211052                    b.Property<string>("AppVersion")
 211053                        .IsRequired()
 211054                        .HasMaxLength(32)
 211055                        .HasColumnType("TEXT");
 211056
 211057                    b.Property<DateTime>("DateCreated")
 211058                        .HasColumnType("TEXT");
 211059
 211060                    b.Property<DateTime>("DateLastActivity")
 211061                        .HasColumnType("TEXT");
 211062
 211063                    b.Property<DateTime>("DateModified")
 211064                        .HasColumnType("TEXT");
 211065
 211066                    b.Property<string>("DeviceId")
 211067                        .IsRequired()
 211068                        .HasMaxLength(256)
 211069                        .HasColumnType("TEXT");
 211070
 211071                    b.Property<string>("DeviceName")
 211072                        .IsRequired()
 211073                        .HasMaxLength(64)
 211074                        .HasColumnType("TEXT");
 211075
 211076                    b.Property<bool>("IsActive")
 211077                        .HasColumnType("INTEGER");
 211078
 211079                    b.Property<Guid>("UserId")
 211080                        .HasColumnType("TEXT");
 211081
 211082                    b.HasKey("Id");
 211083
 211084                    b.HasIndex("DeviceId");
 211085
 211086                    b.HasIndex("AccessToken", "DateLastActivity");
 211087
 211088                    b.HasIndex("DeviceId", "DateLastActivity");
 211089
 211090                    b.HasIndex("UserId", "DeviceId");
 211091
 211092                    b.ToTable("Devices");
 211093                });
 1094
 211095            modelBuilder.Entity("Jellyfin.Data.Entities.Security.DeviceOptions", b =>
 211096                {
 211097                    b.Property<int>("Id")
 211098                        .ValueGeneratedOnAdd()
 211099                        .HasColumnType("INTEGER");
 211100
 211101                    b.Property<string>("CustomName")
 211102                        .HasColumnType("TEXT");
 211103
 211104                    b.Property<string>("DeviceId")
 211105                        .IsRequired()
 211106                        .HasColumnType("TEXT");
 211107
 211108                    b.HasKey("Id");
 211109
 211110                    b.HasIndex("DeviceId")
 211111                        .IsUnique();
 211112
 211113                    b.ToTable("DeviceOptions");
 211114                });
 1115
 211116            modelBuilder.Entity("Jellyfin.Data.Entities.TrickplayInfo", b =>
 211117                {
 211118                    b.Property<Guid>("ItemId")
 211119                        .HasColumnType("TEXT");
 211120
 211121                    b.Property<int>("Width")
 211122                        .HasColumnType("INTEGER");
 211123
 211124                    b.Property<int>("Bandwidth")
 211125                        .HasColumnType("INTEGER");
 211126
 211127                    b.Property<int>("Height")
 211128                        .HasColumnType("INTEGER");
 211129
 211130                    b.Property<int>("Interval")
 211131                        .HasColumnType("INTEGER");
 211132
 211133                    b.Property<int>("ThumbnailCount")
 211134                        .HasColumnType("INTEGER");
 211135
 211136                    b.Property<int>("TileHeight")
 211137                        .HasColumnType("INTEGER");
 211138
 211139                    b.Property<int>("TileWidth")
 211140                        .HasColumnType("INTEGER");
 211141
 211142                    b.HasKey("ItemId", "Width");
 211143
 211144                    b.ToTable("TrickplayInfos");
 211145                });
 1146
 211147            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 211148                {
 211149                    b.Property<Guid>("Id")
 211150                        .ValueGeneratedOnAdd()
 211151                        .HasColumnType("TEXT");
 211152
 211153                    b.Property<string>("AudioLanguagePreference")
 211154                        .HasMaxLength(255)
 211155                        .HasColumnType("TEXT");
 211156
 211157                    b.Property<string>("AuthenticationProviderId")
 211158                        .IsRequired()
 211159                        .HasMaxLength(255)
 211160                        .HasColumnType("TEXT");
 211161
 211162                    b.Property<string>("CastReceiverId")
 211163                        .HasMaxLength(32)
 211164                        .HasColumnType("TEXT");
 211165
 211166                    b.Property<bool>("DisplayCollectionsView")
 211167                        .HasColumnType("INTEGER");
 211168
 211169                    b.Property<bool>("DisplayMissingEpisodes")
 211170                        .HasColumnType("INTEGER");
 211171
 211172                    b.Property<bool>("EnableAutoLogin")
 211173                        .HasColumnType("INTEGER");
 211174
 211175                    b.Property<bool>("EnableLocalPassword")
 211176                        .HasColumnType("INTEGER");
 211177
 211178                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 211179                        .HasColumnType("INTEGER");
 211180
 211181                    b.Property<bool>("EnableUserPreferenceAccess")
 211182                        .HasColumnType("INTEGER");
 211183
 211184                    b.Property<bool>("HidePlayedInLatest")
 211185                        .HasColumnType("INTEGER");
 211186
 211187                    b.Property<long>("InternalId")
 211188                        .HasColumnType("INTEGER");
 211189
 211190                    b.Property<int>("InvalidLoginAttemptCount")
 211191                        .HasColumnType("INTEGER");
 211192
 211193                    b.Property<DateTime?>("LastActivityDate")
 211194                        .HasColumnType("TEXT");
 211195
 211196                    b.Property<DateTime?>("LastLoginDate")
 211197                        .HasColumnType("TEXT");
 211198
 211199                    b.Property<int?>("LoginAttemptsBeforeLockout")
 211200                        .HasColumnType("INTEGER");
 211201
 211202                    b.Property<int>("MaxActiveSessions")
 211203                        .HasColumnType("INTEGER");
 211204
 211205                    b.Property<int?>("MaxParentalAgeRating")
 211206                        .HasColumnType("INTEGER");
 211207
 211208                    b.Property<bool>("MustUpdatePassword")
 211209                        .HasColumnType("INTEGER");
 211210
 211211                    b.Property<string>("Password")
 211212                        .HasMaxLength(65535)
 211213                        .HasColumnType("TEXT");
 211214
 211215                    b.Property<string>("PasswordResetProviderId")
 211216                        .IsRequired()
 211217                        .HasMaxLength(255)
 211218                        .HasColumnType("TEXT");
 211219
 211220                    b.Property<bool>("PlayDefaultAudioTrack")
 211221                        .HasColumnType("INTEGER");
 211222
 211223                    b.Property<bool>("RememberAudioSelections")
 211224                        .HasColumnType("INTEGER");
 211225
 211226                    b.Property<bool>("RememberSubtitleSelections")
 211227                        .HasColumnType("INTEGER");
 211228
 211229                    b.Property<int?>("RemoteClientBitrateLimit")
 211230                        .HasColumnType("INTEGER");
 211231
 211232                    b.Property<uint>("RowVersion")
 211233                        .IsConcurrencyToken()
 211234                        .HasColumnType("INTEGER");
 211235
 211236                    b.Property<string>("SubtitleLanguagePreference")
 211237                        .HasMaxLength(255)
 211238                        .HasColumnType("TEXT");
 211239
 211240                    b.Property<int>("SubtitleMode")
 211241                        .HasColumnType("INTEGER");
 211242
 211243                    b.Property<int>("SyncPlayAccess")
 211244                        .HasColumnType("INTEGER");
 211245
 211246                    b.Property<string>("Username")
 211247                        .IsRequired()
 211248                        .HasMaxLength(255)
 211249                        .HasColumnType("TEXT")
 211250                        .UseCollation("NOCASE");
 211251
 211252                    b.HasKey("Id");
 211253
 211254                    b.HasIndex("Username")
 211255                        .IsUnique();
 211256
 211257                    b.ToTable("Users");
 211258                });
 1259
 211260            modelBuilder.Entity("Jellyfin.Data.Entities.UserData", b =>
 211261                {
 211262                    b.Property<Guid>("ItemId")
 211263                        .HasColumnType("TEXT");
 211264
 211265                    b.Property<Guid>("UserId")
 211266                        .HasColumnType("TEXT");
 211267
 211268                    b.Property<string>("CustomDataKey")
 211269                        .HasColumnType("TEXT");
 211270
 211271                    b.Property<int?>("AudioStreamIndex")
 211272                        .HasColumnType("INTEGER");
 211273
 211274                    b.Property<bool>("IsFavorite")
 211275                        .HasColumnType("INTEGER");
 211276
 211277                    b.Property<DateTime?>("LastPlayedDate")
 211278                        .HasColumnType("TEXT");
 211279
 211280                    b.Property<bool?>("Likes")
 211281                        .HasColumnType("INTEGER");
 211282
 211283                    b.Property<int>("PlayCount")
 211284                        .HasColumnType("INTEGER");
 211285
 211286                    b.Property<long>("PlaybackPositionTicks")
 211287                        .HasColumnType("INTEGER");
 211288
 211289                    b.Property<bool>("Played")
 211290                        .HasColumnType("INTEGER");
 211291
 211292                    b.Property<double?>("Rating")
 211293                        .HasColumnType("REAL");
 211294
 211295                    b.Property<int?>("SubtitleStreamIndex")
 211296                        .HasColumnType("INTEGER");
 211297
 211298                    b.HasKey("ItemId", "UserId", "CustomDataKey");
 211299
 211300                    b.HasIndex("UserId");
 211301
 211302                    b.HasIndex("ItemId", "UserId", "IsFavorite");
 211303
 211304                    b.HasIndex("ItemId", "UserId", "LastPlayedDate");
 211305
 211306                    b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks");
 211307
 211308                    b.HasIndex("ItemId", "UserId", "Played");
 211309
 211310                    b.ToTable("UserData");
 211311                });
 1312
 211313            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 211314                {
 211315                    b.HasOne("Jellyfin.Data.Entities.User", null)
 211316                        .WithMany("AccessSchedules")
 211317                        .HasForeignKey("UserId")
 211318                        .OnDelete(DeleteBehavior.Cascade)
 211319                        .IsRequired();
 211320                });
 1321
 211322            modelBuilder.Entity("Jellyfin.Data.Entities.AncestorId", b =>
 211323                {
 211324                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211325                        .WithMany("Children")
 211326                        .HasForeignKey("ItemId")
 211327                        .OnDelete(DeleteBehavior.Cascade)
 211328                        .IsRequired();
 211329
 211330                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "ParentItem")
 211331                        .WithMany("ParentAncestors")
 211332                        .HasForeignKey("ParentItemId")
 211333                        .OnDelete(DeleteBehavior.Cascade)
 211334                        .IsRequired();
 211335
 211336                    b.Navigation("Item");
 211337
 211338                    b.Navigation("ParentItem");
 211339                });
 1340
 211341            modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b =>
 211342                {
 211343                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211344                        .WithMany()
 211345                        .HasForeignKey("ItemId")
 211346                        .OnDelete(DeleteBehavior.Cascade)
 211347                        .IsRequired();
 211348
 211349                    b.Navigation("Item");
 211350                });
 1351
 211352            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b =>
 211353                {
 211354                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211355                        .WithMany("Images")
 211356                        .HasForeignKey("ItemId")
 211357                        .OnDelete(DeleteBehavior.Cascade)
 211358                        .IsRequired();
 211359
 211360                    b.Navigation("Item");
 211361                });
 1362
 211363            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b =>
 211364                {
 211365                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211366                        .WithMany("LockedFields")
 211367                        .HasForeignKey("ItemId")
 211368                        .OnDelete(DeleteBehavior.Cascade)
 211369                        .IsRequired();
 211370
 211371                    b.Navigation("Item");
 211372                });
 1373
 211374            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b =>
 211375                {
 211376                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211377                        .WithMany("Provider")
 211378                        .HasForeignKey("ItemId")
 211379                        .OnDelete(DeleteBehavior.Cascade)
 211380                        .IsRequired();
 211381
 211382                    b.Navigation("Item");
 211383                });
 1384
 211385            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b =>
 211386                {
 211387                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211388                        .WithMany("TrailerTypes")
 211389                        .HasForeignKey("ItemId")
 211390                        .OnDelete(DeleteBehavior.Cascade)
 211391                        .IsRequired();
 211392
 211393                    b.Navigation("Item");
 211394                });
 1395
 211396            modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b =>
 211397                {
 211398                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211399                        .WithMany("Chapters")
 211400                        .HasForeignKey("ItemId")
 211401                        .OnDelete(DeleteBehavior.Cascade)
 211402                        .IsRequired();
 211403
 211404                    b.Navigation("Item");
 211405                });
 1406
 211407            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 211408                {
 211409                    b.HasOne("Jellyfin.Data.Entities.User", null)
 211410                        .WithMany("DisplayPreferences")
 211411                        .HasForeignKey("UserId")
 211412                        .OnDelete(DeleteBehavior.Cascade)
 211413                        .IsRequired();
 211414                });
 1415
 211416            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 211417                {
 211418                    b.HasOne("Jellyfin.Data.Entities.DisplayPreferences", null)
 211419                        .WithMany("HomeSections")
 211420                        .HasForeignKey("DisplayPreferencesId")
 211421                        .OnDelete(DeleteBehavior.Cascade)
 211422                        .IsRequired();
 211423                });
 1424
 211425            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 211426                {
 211427                    b.HasOne("Jellyfin.Data.Entities.User", null)
 211428                        .WithOne("ProfileImage")
 211429                        .HasForeignKey("Jellyfin.Data.Entities.ImageInfo", "UserId")
 211430                        .OnDelete(DeleteBehavior.Cascade);
 211431                });
 1432
 211433            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 211434                {
 211435                    b.HasOne("Jellyfin.Data.Entities.User", null)
 211436                        .WithMany("ItemDisplayPreferences")
 211437                        .HasForeignKey("UserId")
 211438                        .OnDelete(DeleteBehavior.Cascade)
 211439                        .IsRequired();
 211440                });
 1441
 211442            modelBuilder.Entity("Jellyfin.Data.Entities.ItemValueMap", b =>
 211443                {
 211444                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211445                        .WithMany("ItemValues")
 211446                        .HasForeignKey("ItemId")
 211447                        .OnDelete(DeleteBehavior.Cascade)
 211448                        .IsRequired();
 211449
 211450                    b.HasOne("Jellyfin.Data.Entities.ItemValue", "ItemValue")
 211451                        .WithMany("BaseItemsMap")
 211452                        .HasForeignKey("ItemValueId")
 211453                        .OnDelete(DeleteBehavior.Cascade)
 211454                        .IsRequired();
 211455
 211456                    b.Navigation("Item");
 211457
 211458                    b.Navigation("ItemValue");
 211459                });
 1460
 211461            modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b =>
 211462                {
 211463                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211464                        .WithMany("MediaStreams")
 211465                        .HasForeignKey("ItemId")
 211466                        .OnDelete(DeleteBehavior.Cascade)
 211467                        .IsRequired();
 211468
 211469                    b.Navigation("Item");
 211470                });
 1471
 211472            modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b =>
 211473                {
 211474                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211475                        .WithMany("Peoples")
 211476                        .HasForeignKey("ItemId")
 211477                        .OnDelete(DeleteBehavior.Cascade)
 211478                        .IsRequired();
 211479
 211480                    b.HasOne("Jellyfin.Data.Entities.People", "People")
 211481                        .WithMany("BaseItems")
 211482                        .HasForeignKey("PeopleId")
 211483                        .OnDelete(DeleteBehavior.Cascade)
 211484                        .IsRequired();
 211485
 211486                    b.Navigation("Item");
 211487
 211488                    b.Navigation("People");
 211489                });
 1490
 211491            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 211492                {
 211493                    b.HasOne("Jellyfin.Data.Entities.User", null)
 211494                        .WithMany("Permissions")
 211495                        .HasForeignKey("UserId")
 211496                        .OnDelete(DeleteBehavior.Cascade);
 211497                });
 1498
 211499            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 211500                {
 211501                    b.HasOne("Jellyfin.Data.Entities.User", null)
 211502                        .WithMany("Preferences")
 211503                        .HasForeignKey("UserId")
 211504                        .OnDelete(DeleteBehavior.Cascade);
 211505                });
 1506
 211507            modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
 211508                {
 211509                    b.HasOne("Jellyfin.Data.Entities.User", "User")
 211510                        .WithMany()
 211511                        .HasForeignKey("UserId")
 211512                        .OnDelete(DeleteBehavior.Cascade)
 211513                        .IsRequired();
 211514
 211515                    b.Navigation("User");
 211516                });
 1517
 211518            modelBuilder.Entity("Jellyfin.Data.Entities.UserData", b =>
 211519                {
 211520                    b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
 211521                        .WithMany("UserData")
 211522                        .HasForeignKey("ItemId")
 211523                        .OnDelete(DeleteBehavior.Cascade)
 211524                        .IsRequired();
 211525
 211526                    b.HasOne("Jellyfin.Data.Entities.User", "User")
 211527                        .WithMany()
 211528                        .HasForeignKey("UserId")
 211529                        .OnDelete(DeleteBehavior.Cascade)
 211530                        .IsRequired();
 211531
 211532                    b.Navigation("Item");
 211533
 211534                    b.Navigation("User");
 211535                });
 1536
 211537            modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b =>
 211538                {
 211539                    b.Navigation("Chapters");
 211540
 211541                    b.Navigation("Children");
 211542
 211543                    b.Navigation("Images");
 211544
 211545                    b.Navigation("ItemValues");
 211546
 211547                    b.Navigation("LockedFields");
 211548
 211549                    b.Navigation("MediaStreams");
 211550
 211551                    b.Navigation("ParentAncestors");
 211552
 211553                    b.Navigation("Peoples");
 211554
 211555                    b.Navigation("Provider");
 211556
 211557                    b.Navigation("TrailerTypes");
 211558
 211559                    b.Navigation("UserData");
 211560                });
 1561
 211562            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 211563                {
 211564                    b.Navigation("HomeSections");
 211565                });
 1566
 211567            modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b =>
 211568                {
 211569                    b.Navigation("BaseItemsMap");
 211570                });
 1571
 211572            modelBuilder.Entity("Jellyfin.Data.Entities.People", b =>
 211573                {
 211574                    b.Navigation("BaseItems");
 211575                });
 1576
 211577            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 211578                {
 211579                    b.Navigation("AccessSchedules");
 211580
 211581                    b.Navigation("DisplayPreferences");
 211582
 211583                    b.Navigation("ItemDisplayPreferences");
 211584
 211585                    b.Navigation("Permissions");
 211586
 211587                    b.Navigation("Preferences");
 211588
 211589                    b.Navigation("ProfileImage");
 211590                });
 1591#pragma warning restore 612, 618
 211592        }
 1593    }
 1594}
Generated by: ReportGenerator 5.4.5.0
4/3/2025 - 12:11:21 AM
GitHub | reportgenerator.io

Methods/Properties

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