< Summary - Jellyfin

Information
Class: Jellyfin.Server.Implementations.Migrations.LibraryDbMigration
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20241020103111_LibraryDbMigration.cs
File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20241020103111_LibraryDbMigration.Designer.cs
Line coverage
98%
Covered lines: 2062
Uncovered lines: 29
Coverable lines: 2091
Total lines: 2246
Line coverage: 98.6%
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/20241020103111_LibraryDbMigration.cs

#LineLine coverage
 1using System;
 2using Microsoft.EntityFrameworkCore.Migrations;
 3
 4#nullable disable
 5
 6namespace Jellyfin.Server.Implementations.Migrations
 7{
 8    /// <inheritdoc />
 9    public partial class LibraryDbMigration : Migration
 10    {
 11        /// <inheritdoc />
 12        protected override void Up(MigrationBuilder migrationBuilder)
 13        {
 2114            migrationBuilder.CreateTable(
 2115                name: "BaseItems",
 2116                columns: table => new
 2117                {
 2118                    Id = table.Column<Guid>(type: "TEXT", nullable: false),
 2119                    Type = table.Column<string>(type: "TEXT", nullable: false),
 2120                    Data = table.Column<string>(type: "TEXT", nullable: true),
 2121                    Path = table.Column<string>(type: "TEXT", nullable: true),
 2122                    StartDate = table.Column<DateTime>(type: "TEXT", nullable: false),
 2123                    EndDate = table.Column<DateTime>(type: "TEXT", nullable: false),
 2124                    ChannelId = table.Column<string>(type: "TEXT", nullable: true),
 2125                    IsMovie = table.Column<bool>(type: "INTEGER", nullable: false),
 2126                    CommunityRating = table.Column<float>(type: "REAL", nullable: true),
 2127                    CustomRating = table.Column<string>(type: "TEXT", nullable: true),
 2128                    IndexNumber = table.Column<int>(type: "INTEGER", nullable: true),
 2129                    IsLocked = table.Column<bool>(type: "INTEGER", nullable: false),
 2130                    Name = table.Column<string>(type: "TEXT", nullable: true),
 2131                    OfficialRating = table.Column<string>(type: "TEXT", nullable: true),
 2132                    MediaType = table.Column<string>(type: "TEXT", nullable: true),
 2133                    Overview = table.Column<string>(type: "TEXT", nullable: true),
 2134                    ParentIndexNumber = table.Column<int>(type: "INTEGER", nullable: true),
 2135                    PremiereDate = table.Column<DateTime>(type: "TEXT", nullable: true),
 2136                    ProductionYear = table.Column<int>(type: "INTEGER", nullable: true),
 2137                    Genres = table.Column<string>(type: "TEXT", nullable: true),
 2138                    SortName = table.Column<string>(type: "TEXT", nullable: true),
 2139                    ForcedSortName = table.Column<string>(type: "TEXT", nullable: true),
 2140                    RunTimeTicks = table.Column<long>(type: "INTEGER", nullable: true),
 2141                    DateCreated = table.Column<DateTime>(type: "TEXT", nullable: true),
 2142                    DateModified = table.Column<DateTime>(type: "TEXT", nullable: true),
 2143                    IsSeries = table.Column<bool>(type: "INTEGER", nullable: false),
 2144                    EpisodeTitle = table.Column<string>(type: "TEXT", nullable: true),
 2145                    IsRepeat = table.Column<bool>(type: "INTEGER", nullable: false),
 2146                    PreferredMetadataLanguage = table.Column<string>(type: "TEXT", nullable: true),
 2147                    PreferredMetadataCountryCode = table.Column<string>(type: "TEXT", nullable: true),
 2148                    DateLastRefreshed = table.Column<DateTime>(type: "TEXT", nullable: true),
 2149                    DateLastSaved = table.Column<DateTime>(type: "TEXT", nullable: true),
 2150                    IsInMixedFolder = table.Column<bool>(type: "INTEGER", nullable: false),
 2151                    Studios = table.Column<string>(type: "TEXT", nullable: true),
 2152                    ExternalServiceId = table.Column<string>(type: "TEXT", nullable: true),
 2153                    Tags = table.Column<string>(type: "TEXT", nullable: true),
 2154                    IsFolder = table.Column<bool>(type: "INTEGER", nullable: false),
 2155                    InheritedParentalRatingValue = table.Column<int>(type: "INTEGER", nullable: true),
 2156                    UnratedType = table.Column<string>(type: "TEXT", nullable: true),
 2157                    CriticRating = table.Column<float>(type: "REAL", nullable: true),
 2158                    CleanName = table.Column<string>(type: "TEXT", nullable: true),
 2159                    PresentationUniqueKey = table.Column<string>(type: "TEXT", nullable: true),
 2160                    OriginalTitle = table.Column<string>(type: "TEXT", nullable: true),
 2161                    PrimaryVersionId = table.Column<string>(type: "TEXT", nullable: true),
 2162                    DateLastMediaAdded = table.Column<DateTime>(type: "TEXT", nullable: true),
 2163                    Album = table.Column<string>(type: "TEXT", nullable: true),
 2164                    LUFS = table.Column<float>(type: "REAL", nullable: true),
 2165                    NormalizationGain = table.Column<float>(type: "REAL", nullable: true),
 2166                    IsVirtualItem = table.Column<bool>(type: "INTEGER", nullable: false),
 2167                    SeriesName = table.Column<string>(type: "TEXT", nullable: true),
 2168                    SeasonName = table.Column<string>(type: "TEXT", nullable: true),
 2169                    ExternalSeriesId = table.Column<string>(type: "TEXT", nullable: true),
 2170                    Tagline = table.Column<string>(type: "TEXT", nullable: true),
 2171                    ProductionLocations = table.Column<string>(type: "TEXT", nullable: true),
 2172                    ExtraIds = table.Column<string>(type: "TEXT", nullable: true),
 2173                    TotalBitrate = table.Column<int>(type: "INTEGER", nullable: true),
 2174                    ExtraType = table.Column<int>(type: "INTEGER", nullable: true),
 2175                    Artists = table.Column<string>(type: "TEXT", nullable: true),
 2176                    AlbumArtists = table.Column<string>(type: "TEXT", nullable: true),
 2177                    ExternalId = table.Column<string>(type: "TEXT", nullable: true),
 2178                    SeriesPresentationUniqueKey = table.Column<string>(type: "TEXT", nullable: true),
 2179                    ShowId = table.Column<string>(type: "TEXT", nullable: true),
 2180                    OwnerId = table.Column<string>(type: "TEXT", nullable: true),
 2181                    Width = table.Column<int>(type: "INTEGER", nullable: true),
 2182                    Height = table.Column<int>(type: "INTEGER", nullable: true),
 2183                    Size = table.Column<long>(type: "INTEGER", nullable: true),
 2184                    Audio = table.Column<int>(type: "INTEGER", nullable: true),
 2185                    ParentId = table.Column<Guid>(type: "TEXT", nullable: true),
 2186                    TopParentId = table.Column<Guid>(type: "TEXT", nullable: true),
 2187                    SeasonId = table.Column<Guid>(type: "TEXT", nullable: true),
 2188                    SeriesId = table.Column<Guid>(type: "TEXT", nullable: true)
 2189                },
 2190                constraints: table =>
 2191                {
 2192                    table.PrimaryKey("PK_BaseItems", x => x.Id);
 2193                });
 94
 2195            migrationBuilder.CreateTable(
 2196                name: "ItemValues",
 2197                columns: table => new
 2198                {
 2199                    ItemValueId = table.Column<Guid>(type: "TEXT", nullable: false),
 21100                    Type = table.Column<int>(type: "INTEGER", nullable: false),
 21101                    Value = table.Column<string>(type: "TEXT", nullable: false),
 21102                    CleanValue = table.Column<string>(type: "TEXT", nullable: false)
 21103                },
 21104                constraints: table =>
 21105                {
 21106                    table.PrimaryKey("PK_ItemValues", x => x.ItemValueId);
 21107                });
 108
 21109            migrationBuilder.CreateTable(
 21110                name: "Peoples",
 21111                columns: table => new
 21112                {
 21113                    Id = table.Column<Guid>(type: "TEXT", nullable: false),
 21114                    Name = table.Column<string>(type: "TEXT", nullable: false),
 21115                    PersonType = table.Column<string>(type: "TEXT", nullable: true)
 21116                },
 21117                constraints: table =>
 21118                {
 21119                    table.PrimaryKey("PK_Peoples", x => x.Id);
 21120                });
 121
 21122            migrationBuilder.CreateTable(
 21123                name: "AncestorIds",
 21124                columns: table => new
 21125                {
 21126                    ParentItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21127                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21128                    BaseItemEntityId = table.Column<Guid>(type: "TEXT", nullable: true)
 21129                },
 21130                constraints: table =>
 21131                {
 21132                    table.PrimaryKey("PK_AncestorIds", x => new { x.ItemId, x.ParentItemId });
 21133                    table.ForeignKey(
 21134                        name: "FK_AncestorIds_BaseItems_BaseItemEntityId",
 21135                        column: x => x.BaseItemEntityId,
 21136                        principalTable: "BaseItems",
 21137                        principalColumn: "Id");
 21138                    table.ForeignKey(
 21139                        name: "FK_AncestorIds_BaseItems_ItemId",
 21140                        column: x => x.ItemId,
 21141                        principalTable: "BaseItems",
 21142                        principalColumn: "Id",
 21143                        onDelete: ReferentialAction.Cascade);
 21144                    table.ForeignKey(
 21145                        name: "FK_AncestorIds_BaseItems_ParentItemId",
 21146                        column: x => x.ParentItemId,
 21147                        principalTable: "BaseItems",
 21148                        principalColumn: "Id",
 21149                        onDelete: ReferentialAction.Cascade);
 21150                });
 151
 21152            migrationBuilder.CreateTable(
 21153                name: "AttachmentStreamInfos",
 21154                columns: table => new
 21155                {
 21156                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21157                    Index = table.Column<int>(type: "INTEGER", nullable: false),
 21158                    Codec = table.Column<string>(type: "TEXT", nullable: false),
 21159                    CodecTag = table.Column<string>(type: "TEXT", nullable: true),
 21160                    Comment = table.Column<string>(type: "TEXT", nullable: true),
 21161                    Filename = table.Column<string>(type: "TEXT", nullable: true),
 21162                    MimeType = table.Column<string>(type: "TEXT", nullable: true)
 21163                },
 21164                constraints: table =>
 21165                {
 21166                    table.PrimaryKey("PK_AttachmentStreamInfos", x => new { x.ItemId, x.Index });
 21167                    table.ForeignKey(
 21168                        name: "FK_AttachmentStreamInfos_BaseItems_ItemId",
 21169                        column: x => x.ItemId,
 21170                        principalTable: "BaseItems",
 21171                        principalColumn: "Id",
 21172                        onDelete: ReferentialAction.Cascade);
 21173                });
 174
 21175            migrationBuilder.CreateTable(
 21176                name: "BaseItemImageInfos",
 21177                columns: table => new
 21178                {
 21179                    Id = table.Column<Guid>(type: "TEXT", nullable: false),
 21180                    Path = table.Column<string>(type: "TEXT", nullable: false),
 21181                    DateModified = table.Column<DateTime>(type: "TEXT", nullable: false),
 21182                    ImageType = table.Column<int>(type: "INTEGER", nullable: false),
 21183                    Width = table.Column<int>(type: "INTEGER", nullable: false),
 21184                    Height = table.Column<int>(type: "INTEGER", nullable: false),
 21185                    Blurhash = table.Column<byte[]>(type: "BLOB", nullable: true),
 21186                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false)
 21187                },
 21188                constraints: table =>
 21189                {
 21190                    table.PrimaryKey("PK_BaseItemImageInfos", x => x.Id);
 21191                    table.ForeignKey(
 21192                        name: "FK_BaseItemImageInfos_BaseItems_ItemId",
 21193                        column: x => x.ItemId,
 21194                        principalTable: "BaseItems",
 21195                        principalColumn: "Id",
 21196                        onDelete: ReferentialAction.Cascade);
 21197                });
 198
 21199            migrationBuilder.CreateTable(
 21200                name: "BaseItemMetadataFields",
 21201                columns: table => new
 21202                {
 21203                    Id = table.Column<int>(type: "INTEGER", nullable: false),
 21204                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false)
 21205                },
 21206                constraints: table =>
 21207                {
 21208                    table.PrimaryKey("PK_BaseItemMetadataFields", x => new { x.Id, x.ItemId });
 21209                    table.ForeignKey(
 21210                        name: "FK_BaseItemMetadataFields_BaseItems_ItemId",
 21211                        column: x => x.ItemId,
 21212                        principalTable: "BaseItems",
 21213                        principalColumn: "Id",
 21214                        onDelete: ReferentialAction.Cascade);
 21215                });
 216
 21217            migrationBuilder.CreateTable(
 21218                name: "BaseItemProviders",
 21219                columns: table => new
 21220                {
 21221                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21222                    ProviderId = table.Column<string>(type: "TEXT", nullable: false),
 21223                    ProviderValue = table.Column<string>(type: "TEXT", nullable: false)
 21224                },
 21225                constraints: table =>
 21226                {
 21227                    table.PrimaryKey("PK_BaseItemProviders", x => new { x.ItemId, x.ProviderId });
 21228                    table.ForeignKey(
 21229                        name: "FK_BaseItemProviders_BaseItems_ItemId",
 21230                        column: x => x.ItemId,
 21231                        principalTable: "BaseItems",
 21232                        principalColumn: "Id",
 21233                        onDelete: ReferentialAction.Cascade);
 21234                });
 235
 21236            migrationBuilder.CreateTable(
 21237                name: "BaseItemTrailerTypes",
 21238                columns: table => new
 21239                {
 21240                    Id = table.Column<int>(type: "INTEGER", nullable: false),
 21241                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false)
 21242                },
 21243                constraints: table =>
 21244                {
 21245                    table.PrimaryKey("PK_BaseItemTrailerTypes", x => new { x.Id, x.ItemId });
 21246                    table.ForeignKey(
 21247                        name: "FK_BaseItemTrailerTypes_BaseItems_ItemId",
 21248                        column: x => x.ItemId,
 21249                        principalTable: "BaseItems",
 21250                        principalColumn: "Id",
 21251                        onDelete: ReferentialAction.Cascade);
 21252                });
 253
 21254            migrationBuilder.CreateTable(
 21255                name: "Chapters",
 21256                columns: table => new
 21257                {
 21258                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21259                    ChapterIndex = table.Column<int>(type: "INTEGER", nullable: false),
 21260                    StartPositionTicks = table.Column<long>(type: "INTEGER", nullable: false),
 21261                    Name = table.Column<string>(type: "TEXT", nullable: true),
 21262                    ImagePath = table.Column<string>(type: "TEXT", nullable: true),
 21263                    ImageDateModified = table.Column<DateTime>(type: "TEXT", nullable: true)
 21264                },
 21265                constraints: table =>
 21266                {
 21267                    table.PrimaryKey("PK_Chapters", x => new { x.ItemId, x.ChapterIndex });
 21268                    table.ForeignKey(
 21269                        name: "FK_Chapters_BaseItems_ItemId",
 21270                        column: x => x.ItemId,
 21271                        principalTable: "BaseItems",
 21272                        principalColumn: "Id",
 21273                        onDelete: ReferentialAction.Cascade);
 21274                });
 275
 21276            migrationBuilder.CreateTable(
 21277                name: "MediaStreamInfos",
 21278                columns: table => new
 21279                {
 21280                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21281                    StreamIndex = table.Column<int>(type: "INTEGER", nullable: false),
 21282                    StreamType = table.Column<int>(type: "INTEGER", nullable: true),
 21283                    Codec = table.Column<string>(type: "TEXT", nullable: true),
 21284                    Language = table.Column<string>(type: "TEXT", nullable: true),
 21285                    ChannelLayout = table.Column<string>(type: "TEXT", nullable: true),
 21286                    Profile = table.Column<string>(type: "TEXT", nullable: true),
 21287                    AspectRatio = table.Column<string>(type: "TEXT", nullable: true),
 21288                    Path = table.Column<string>(type: "TEXT", nullable: true),
 21289                    IsInterlaced = table.Column<bool>(type: "INTEGER", nullable: false),
 21290                    BitRate = table.Column<int>(type: "INTEGER", nullable: false),
 21291                    Channels = table.Column<int>(type: "INTEGER", nullable: false),
 21292                    SampleRate = table.Column<int>(type: "INTEGER", nullable: false),
 21293                    IsDefault = table.Column<bool>(type: "INTEGER", nullable: false),
 21294                    IsForced = table.Column<bool>(type: "INTEGER", nullable: false),
 21295                    IsExternal = table.Column<bool>(type: "INTEGER", nullable: false),
 21296                    Height = table.Column<int>(type: "INTEGER", nullable: false),
 21297                    Width = table.Column<int>(type: "INTEGER", nullable: false),
 21298                    AverageFrameRate = table.Column<float>(type: "REAL", nullable: false),
 21299                    RealFrameRate = table.Column<float>(type: "REAL", nullable: false),
 21300                    Level = table.Column<float>(type: "REAL", nullable: false),
 21301                    PixelFormat = table.Column<string>(type: "TEXT", nullable: true),
 21302                    BitDepth = table.Column<int>(type: "INTEGER", nullable: false),
 21303                    IsAnamorphic = table.Column<bool>(type: "INTEGER", nullable: false),
 21304                    RefFrames = table.Column<int>(type: "INTEGER", nullable: false),
 21305                    CodecTag = table.Column<string>(type: "TEXT", nullable: false),
 21306                    Comment = table.Column<string>(type: "TEXT", nullable: false),
 21307                    NalLengthSize = table.Column<string>(type: "TEXT", nullable: false),
 21308                    IsAvc = table.Column<bool>(type: "INTEGER", nullable: false),
 21309                    Title = table.Column<string>(type: "TEXT", nullable: false),
 21310                    TimeBase = table.Column<string>(type: "TEXT", nullable: false),
 21311                    CodecTimeBase = table.Column<string>(type: "TEXT", nullable: false),
 21312                    ColorPrimaries = table.Column<string>(type: "TEXT", nullable: false),
 21313                    ColorSpace = table.Column<string>(type: "TEXT", nullable: false),
 21314                    ColorTransfer = table.Column<string>(type: "TEXT", nullable: false),
 21315                    DvVersionMajor = table.Column<int>(type: "INTEGER", nullable: false),
 21316                    DvVersionMinor = table.Column<int>(type: "INTEGER", nullable: false),
 21317                    DvProfile = table.Column<int>(type: "INTEGER", nullable: false),
 21318                    DvLevel = table.Column<int>(type: "INTEGER", nullable: false),
 21319                    RpuPresentFlag = table.Column<int>(type: "INTEGER", nullable: false),
 21320                    ElPresentFlag = table.Column<int>(type: "INTEGER", nullable: false),
 21321                    BlPresentFlag = table.Column<int>(type: "INTEGER", nullable: false),
 21322                    DvBlSignalCompatibilityId = table.Column<int>(type: "INTEGER", nullable: false),
 21323                    IsHearingImpaired = table.Column<bool>(type: "INTEGER", nullable: false),
 21324                    Rotation = table.Column<int>(type: "INTEGER", nullable: false),
 21325                    KeyFrames = table.Column<string>(type: "TEXT", nullable: true)
 21326                },
 21327                constraints: table =>
 21328                {
 21329                    table.PrimaryKey("PK_MediaStreamInfos", x => new { x.ItemId, x.StreamIndex });
 21330                    table.ForeignKey(
 21331                        name: "FK_MediaStreamInfos_BaseItems_ItemId",
 21332                        column: x => x.ItemId,
 21333                        principalTable: "BaseItems",
 21334                        principalColumn: "Id",
 21335                        onDelete: ReferentialAction.Cascade);
 21336                });
 337
 21338            migrationBuilder.CreateTable(
 21339                name: "UserData",
 21340                columns: table => new
 21341                {
 21342                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21343                    UserId = table.Column<Guid>(type: "TEXT", nullable: false),
 21344                    Rating = table.Column<double>(type: "REAL", nullable: true),
 21345                    PlaybackPositionTicks = table.Column<long>(type: "INTEGER", nullable: false),
 21346                    PlayCount = table.Column<int>(type: "INTEGER", nullable: false),
 21347                    IsFavorite = table.Column<bool>(type: "INTEGER", nullable: false),
 21348                    LastPlayedDate = table.Column<DateTime>(type: "TEXT", nullable: true),
 21349                    Played = table.Column<bool>(type: "INTEGER", nullable: false),
 21350                    AudioStreamIndex = table.Column<int>(type: "INTEGER", nullable: true),
 21351                    SubtitleStreamIndex = table.Column<int>(type: "INTEGER", nullable: true),
 21352                    Likes = table.Column<bool>(type: "INTEGER", nullable: true)
 21353                },
 21354                constraints: table =>
 21355                {
 21356                    table.PrimaryKey("PK_UserData", x => new { x.ItemId, x.UserId });
 21357                    table.ForeignKey(
 21358                        name: "FK_UserData_BaseItems_ItemId",
 21359                        column: x => x.ItemId,
 21360                        principalTable: "BaseItems",
 21361                        principalColumn: "Id",
 21362                        onDelete: ReferentialAction.Cascade);
 21363                    table.ForeignKey(
 21364                        name: "FK_UserData_Users_UserId",
 21365                        column: x => x.UserId,
 21366                        principalTable: "Users",
 21367                        principalColumn: "Id",
 21368                        onDelete: ReferentialAction.Cascade);
 21369                });
 370
 21371            migrationBuilder.CreateTable(
 21372                name: "ItemValuesMap",
 21373                columns: table => new
 21374                {
 21375                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21376                    ItemValueId = table.Column<Guid>(type: "TEXT", nullable: false)
 21377                },
 21378                constraints: table =>
 21379                {
 21380                    table.PrimaryKey("PK_ItemValuesMap", x => new { x.ItemValueId, x.ItemId });
 21381                    table.ForeignKey(
 21382                        name: "FK_ItemValuesMap_BaseItems_ItemId",
 21383                        column: x => x.ItemId,
 21384                        principalTable: "BaseItems",
 21385                        principalColumn: "Id",
 21386                        onDelete: ReferentialAction.Cascade);
 21387                    table.ForeignKey(
 21388                        name: "FK_ItemValuesMap_ItemValues_ItemValueId",
 21389                        column: x => x.ItemValueId,
 21390                        principalTable: "ItemValues",
 21391                        principalColumn: "ItemValueId",
 21392                        onDelete: ReferentialAction.Cascade);
 21393                });
 394
 21395            migrationBuilder.CreateTable(
 21396                name: "PeopleBaseItemMap",
 21397                columns: table => new
 21398                {
 21399                    ItemId = table.Column<Guid>(type: "TEXT", nullable: false),
 21400                    PeopleId = table.Column<Guid>(type: "TEXT", nullable: false),
 21401                    SortOrder = table.Column<int>(type: "INTEGER", nullable: true),
 21402                    ListOrder = table.Column<int>(type: "INTEGER", nullable: true),
 21403                    Role = table.Column<string>(type: "TEXT", nullable: true)
 21404                },
 21405                constraints: table =>
 21406                {
 21407                    table.PrimaryKey("PK_PeopleBaseItemMap", x => new { x.ItemId, x.PeopleId });
 21408                    table.ForeignKey(
 21409                        name: "FK_PeopleBaseItemMap_BaseItems_ItemId",
 21410                        column: x => x.ItemId,
 21411                        principalTable: "BaseItems",
 21412                        principalColumn: "Id",
 21413                        onDelete: ReferentialAction.Cascade);
 21414                    table.ForeignKey(
 21415                        name: "FK_PeopleBaseItemMap_Peoples_PeopleId",
 21416                        column: x => x.PeopleId,
 21417                        principalTable: "Peoples",
 21418                        principalColumn: "Id",
 21419                        onDelete: ReferentialAction.Cascade);
 21420                });
 421
 21422            migrationBuilder.CreateIndex(
 21423                name: "IX_AncestorIds_BaseItemEntityId",
 21424                table: "AncestorIds",
 21425                column: "BaseItemEntityId");
 426
 21427            migrationBuilder.CreateIndex(
 21428                name: "IX_AncestorIds_ParentItemId",
 21429                table: "AncestorIds",
 21430                column: "ParentItemId");
 431
 21432            migrationBuilder.CreateIndex(
 21433                name: "IX_BaseItemImageInfos_ItemId",
 21434                table: "BaseItemImageInfos",
 21435                column: "ItemId");
 436
 21437            migrationBuilder.CreateIndex(
 21438                name: "IX_BaseItemMetadataFields_ItemId",
 21439                table: "BaseItemMetadataFields",
 21440                column: "ItemId");
 441
 21442            migrationBuilder.CreateIndex(
 21443                name: "IX_BaseItemProviders_ProviderId_ProviderValue_ItemId",
 21444                table: "BaseItemProviders",
 21445                columns: new[] { "ProviderId", "ProviderValue", "ItemId" });
 446
 21447            migrationBuilder.CreateIndex(
 21448                name: "IX_BaseItems_Id_Type_IsFolder_IsVirtualItem",
 21449                table: "BaseItems",
 21450                columns: new[] { "Id", "Type", "IsFolder", "IsVirtualItem" });
 451
 21452            migrationBuilder.CreateIndex(
 21453                name: "IX_BaseItems_IsFolder_TopParentId_IsVirtualItem_PresentationUniqueKey_DateCreated",
 21454                table: "BaseItems",
 21455                columns: new[] { "IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated" });
 456
 21457            migrationBuilder.CreateIndex(
 21458                name: "IX_BaseItems_MediaType_TopParentId_IsVirtualItem_PresentationUniqueKey",
 21459                table: "BaseItems",
 21460                columns: new[] { "MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey" });
 461
 21462            migrationBuilder.CreateIndex(
 21463                name: "IX_BaseItems_ParentId",
 21464                table: "BaseItems",
 21465                column: "ParentId");
 466
 21467            migrationBuilder.CreateIndex(
 21468                name: "IX_BaseItems_Path",
 21469                table: "BaseItems",
 21470                column: "Path");
 471
 21472            migrationBuilder.CreateIndex(
 21473                name: "IX_BaseItems_PresentationUniqueKey",
 21474                table: "BaseItems",
 21475                column: "PresentationUniqueKey");
 476
 21477            migrationBuilder.CreateIndex(
 21478                name: "IX_BaseItems_TopParentId_Id",
 21479                table: "BaseItems",
 21480                columns: new[] { "TopParentId", "Id" });
 481
 21482            migrationBuilder.CreateIndex(
 21483                name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_IsFolder_IsVirtualItem",
 21484                table: "BaseItems",
 21485                columns: new[] { "Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem" });
 486
 21487            migrationBuilder.CreateIndex(
 21488                name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_PresentationUniqueKey_SortName",
 21489                table: "BaseItems",
 21490                columns: new[] { "Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName" });
 491
 21492            migrationBuilder.CreateIndex(
 21493                name: "IX_BaseItems_Type_TopParentId_Id",
 21494                table: "BaseItems",
 21495                columns: new[] { "Type", "TopParentId", "Id" });
 496
 21497            migrationBuilder.CreateIndex(
 21498                name: "IX_BaseItems_Type_TopParentId_IsVirtualItem_PresentationUniqueKey_DateCreated",
 21499                table: "BaseItems",
 21500                columns: new[] { "Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated" });
 501
 21502            migrationBuilder.CreateIndex(
 21503                name: "IX_BaseItems_Type_TopParentId_PresentationUniqueKey",
 21504                table: "BaseItems",
 21505                columns: new[] { "Type", "TopParentId", "PresentationUniqueKey" });
 506
 21507            migrationBuilder.CreateIndex(
 21508                name: "IX_BaseItems_Type_TopParentId_StartDate",
 21509                table: "BaseItems",
 21510                columns: new[] { "Type", "TopParentId", "StartDate" });
 511
 21512            migrationBuilder.CreateIndex(
 21513                name: "IX_BaseItemTrailerTypes_ItemId",
 21514                table: "BaseItemTrailerTypes",
 21515                column: "ItemId");
 516
 21517            migrationBuilder.CreateIndex(
 21518                name: "IX_ItemValues_Type_CleanValue",
 21519                table: "ItemValues",
 21520                columns: new[] { "Type", "CleanValue" });
 521
 21522            migrationBuilder.CreateIndex(
 21523                name: "IX_ItemValuesMap_ItemId",
 21524                table: "ItemValuesMap",
 21525                column: "ItemId");
 526
 21527            migrationBuilder.CreateIndex(
 21528                name: "IX_MediaStreamInfos_StreamIndex",
 21529                table: "MediaStreamInfos",
 21530                column: "StreamIndex");
 531
 21532            migrationBuilder.CreateIndex(
 21533                name: "IX_MediaStreamInfos_StreamIndex_StreamType",
 21534                table: "MediaStreamInfos",
 21535                columns: new[] { "StreamIndex", "StreamType" });
 536
 21537            migrationBuilder.CreateIndex(
 21538                name: "IX_MediaStreamInfos_StreamIndex_StreamType_Language",
 21539                table: "MediaStreamInfos",
 21540                columns: new[] { "StreamIndex", "StreamType", "Language" });
 541
 21542            migrationBuilder.CreateIndex(
 21543                name: "IX_MediaStreamInfos_StreamType",
 21544                table: "MediaStreamInfos",
 21545                column: "StreamType");
 546
 21547            migrationBuilder.CreateIndex(
 21548                name: "IX_PeopleBaseItemMap_ItemId_ListOrder",
 21549                table: "PeopleBaseItemMap",
 21550                columns: new[] { "ItemId", "ListOrder" });
 551
 21552            migrationBuilder.CreateIndex(
 21553                name: "IX_PeopleBaseItemMap_ItemId_SortOrder",
 21554                table: "PeopleBaseItemMap",
 21555                columns: new[] { "ItemId", "SortOrder" });
 556
 21557            migrationBuilder.CreateIndex(
 21558                name: "IX_PeopleBaseItemMap_PeopleId",
 21559                table: "PeopleBaseItemMap",
 21560                column: "PeopleId");
 561
 21562            migrationBuilder.CreateIndex(
 21563                name: "IX_Peoples_Name",
 21564                table: "Peoples",
 21565                column: "Name");
 566
 21567            migrationBuilder.CreateIndex(
 21568                name: "IX_UserData_ItemId_UserId_IsFavorite",
 21569                table: "UserData",
 21570                columns: new[] { "ItemId", "UserId", "IsFavorite" });
 571
 21572            migrationBuilder.CreateIndex(
 21573                name: "IX_UserData_ItemId_UserId_LastPlayedDate",
 21574                table: "UserData",
 21575                columns: new[] { "ItemId", "UserId", "LastPlayedDate" });
 576
 21577            migrationBuilder.CreateIndex(
 21578                name: "IX_UserData_ItemId_UserId_PlaybackPositionTicks",
 21579                table: "UserData",
 21580                columns: new[] { "ItemId", "UserId", "PlaybackPositionTicks" });
 581
 21582            migrationBuilder.CreateIndex(
 21583                name: "IX_UserData_ItemId_UserId_Played",
 21584                table: "UserData",
 21585                columns: new[] { "ItemId", "UserId", "Played" });
 586
 21587            migrationBuilder.CreateIndex(
 21588                name: "IX_UserData_UserId",
 21589                table: "UserData",
 21590                column: "UserId");
 21591        }
 592
 593        /// <inheritdoc />
 594        protected override void Down(MigrationBuilder migrationBuilder)
 595        {
 0596            migrationBuilder.DropTable(
 0597                name: "AncestorIds");
 598
 0599            migrationBuilder.DropTable(
 0600                name: "AttachmentStreamInfos");
 601
 0602            migrationBuilder.DropTable(
 0603                name: "BaseItemImageInfos");
 604
 0605            migrationBuilder.DropTable(
 0606                name: "BaseItemMetadataFields");
 607
 0608            migrationBuilder.DropTable(
 0609                name: "BaseItemProviders");
 610
 0611            migrationBuilder.DropTable(
 0612                name: "BaseItemTrailerTypes");
 613
 0614            migrationBuilder.DropTable(
 0615                name: "Chapters");
 616
 0617            migrationBuilder.DropTable(
 0618                name: "ItemValuesMap");
 619
 0620            migrationBuilder.DropTable(
 0621                name: "MediaStreamInfos");
 622
 0623            migrationBuilder.DropTable(
 0624                name: "PeopleBaseItemMap");
 625
 0626            migrationBuilder.DropTable(
 0627                name: "UserData");
 628
 0629            migrationBuilder.DropTable(
 0630                name: "ItemValues");
 631
 0632            migrationBuilder.DropTable(
 0633                name: "Peoples");
 634
 0635            migrationBuilder.DropTable(
 0636                name: "BaseItems");
 0637        }
 638    }
 639}

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