< Summary - Jellyfin

Information
Class: Jellyfin.Server.Implementations.Migrations.AddDevices
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20210814002109_AddDevices.cs
File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20210814002109_AddDevices.Designer.cs
Line coverage
98%
Covered lines: 700
Uncovered lines: 10
Coverable lines: 710
Total lines: 781
Line coverage: 98.5%
Branch coverage
N/A
Covered branches: 0
Total branches: 0
Branch coverage: N/A
Method coverage

Feature is only available for sponsors

Upgrade to PRO version

Coverage history

Coverage history 0 25 50 75 100

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/20210814002109_AddDevices.cs

#LineLine coverage
 1#pragma warning disable CS1591, SA1601
 2
 3using System;
 4using Microsoft.EntityFrameworkCore.Migrations;
 5
 6namespace Jellyfin.Server.Implementations.Migrations
 7{
 8    public partial class AddDevices : Migration
 9    {
 10        protected override void Up(MigrationBuilder migrationBuilder)
 11        {
 2112            migrationBuilder.CreateTable(
 2113                name: "ApiKeys",
 2114                schema: "jellyfin",
 2115                columns: table => new
 2116                {
 2117                    Id = table.Column<int>(type: "INTEGER", nullable: false)
 2118                        .Annotation("Sqlite:Autoincrement", true),
 2119                    DateCreated = table.Column<DateTime>(type: "TEXT", nullable: false),
 2120                    DateLastActivity = table.Column<DateTime>(type: "TEXT", nullable: false),
 2121                    Name = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false),
 2122                    AccessToken = table.Column<string>(type: "TEXT", nullable: false)
 2123                },
 2124                constraints: table =>
 2125                {
 2126                    table.PrimaryKey("PK_ApiKeys", x => x.Id);
 2127                });
 28
 2129            migrationBuilder.CreateTable(
 2130                name: "DeviceOptions",
 2131                schema: "jellyfin",
 2132                columns: table => new
 2133                {
 2134                    Id = table.Column<int>(type: "INTEGER", nullable: false)
 2135                        .Annotation("Sqlite:Autoincrement", true),
 2136                    DeviceId = table.Column<string>(type: "TEXT", nullable: false),
 2137                    CustomName = table.Column<string>(type: "TEXT", nullable: true)
 2138                },
 2139                constraints: table =>
 2140                {
 2141                    table.PrimaryKey("PK_DeviceOptions", x => x.Id);
 2142                });
 43
 2144            migrationBuilder.CreateTable(
 2145                name: "Devices",
 2146                schema: "jellyfin",
 2147                columns: table => new
 2148                {
 2149                    Id = table.Column<int>(type: "INTEGER", nullable: false)
 2150                        .Annotation("Sqlite:Autoincrement", true),
 2151                    UserId = table.Column<Guid>(type: "TEXT", nullable: false),
 2152                    AccessToken = table.Column<string>(type: "TEXT", nullable: false),
 2153                    AppName = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false),
 2154                    AppVersion = table.Column<string>(type: "TEXT", maxLength: 32, nullable: false),
 2155                    DeviceName = table.Column<string>(type: "TEXT", maxLength: 64, nullable: false),
 2156                    DeviceId = table.Column<string>(type: "TEXT", maxLength: 256, nullable: false),
 2157                    IsActive = table.Column<bool>(type: "INTEGER", nullable: false),
 2158                    DateCreated = table.Column<DateTime>(type: "TEXT", nullable: false),
 2159                    DateModified = table.Column<DateTime>(type: "TEXT", nullable: false),
 2160                    DateLastActivity = table.Column<DateTime>(type: "TEXT", nullable: false)
 2161                },
 2162                constraints: table =>
 2163                {
 2164                    table.PrimaryKey("PK_Devices", x => x.Id);
 2165                    table.ForeignKey(
 2166                        name: "FK_Devices_Users_UserId",
 2167                        column: x => x.UserId,
 2168                        principalSchema: "jellyfin",
 2169                        principalTable: "Users",
 2170                        principalColumn: "Id",
 2171                        onDelete: ReferentialAction.Cascade);
 2172                });
 73
 2174            migrationBuilder.CreateIndex(
 2175                name: "IX_ApiKeys_AccessToken",
 2176                schema: "jellyfin",
 2177                table: "ApiKeys",
 2178                column: "AccessToken",
 2179                unique: true);
 80
 2181            migrationBuilder.CreateIndex(
 2182                name: "IX_DeviceOptions_DeviceId",
 2183                schema: "jellyfin",
 2184                table: "DeviceOptions",
 2185                column: "DeviceId",
 2186                unique: true);
 87
 2188            migrationBuilder.CreateIndex(
 2189                name: "IX_Devices_AccessToken_DateLastActivity",
 2190                schema: "jellyfin",
 2191                table: "Devices",
 2192                columns: new[] { "AccessToken", "DateLastActivity" });
 93
 2194            migrationBuilder.CreateIndex(
 2195                name: "IX_Devices_DeviceId",
 2196                schema: "jellyfin",
 2197                table: "Devices",
 2198                column: "DeviceId");
 99
 21100            migrationBuilder.CreateIndex(
 21101                name: "IX_Devices_DeviceId_DateLastActivity",
 21102                schema: "jellyfin",
 21103                table: "Devices",
 21104                columns: new[] { "DeviceId", "DateLastActivity" });
 105
 21106            migrationBuilder.CreateIndex(
 21107                name: "IX_Devices_UserId_DeviceId",
 21108                schema: "jellyfin",
 21109                table: "Devices",
 21110                columns: new[] { "UserId", "DeviceId" });
 21111        }
 112
 113        protected override void Down(MigrationBuilder migrationBuilder)
 114        {
 0115            migrationBuilder.DropTable(
 0116                name: "ApiKeys",
 0117                schema: "jellyfin");
 118
 0119            migrationBuilder.DropTable(
 0120                name: "DeviceOptions",
 0121                schema: "jellyfin");
 122
 0123            migrationBuilder.DropTable(
 0124                name: "Devices",
 0125                schema: "jellyfin");
 0126        }
 127    }
 128}

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20210814002109_AddDevices.Designer.cs

#LineLine coverage
 1#pragma warning disable CS1591
 2
 3// <auto-generated />
 4using System;
 5using Jellyfin.Database.Implementations;
 6using Microsoft.EntityFrameworkCore;
 7using Microsoft.EntityFrameworkCore.Infrastructure;
 8using Microsoft.EntityFrameworkCore.Migrations;
 9using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
 10
 11namespace Jellyfin.Server.Implementations.Migrations
 12{
 13    [DbContext(typeof(JellyfinDbContext))]
 14    [Migration("20210814002109_AddDevices")]
 15    partial class AddDevices
 16    {
 17        protected override void BuildTargetModel(ModelBuilder modelBuilder)
 18        {
 19#pragma warning disable 612, 618
 2120            modelBuilder
 2121                .HasDefaultSchema("jellyfin")
 2122                .HasAnnotation("ProductVersion", "5.0.7");
 23
 2124            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 2125                {
 2126                    b.Property<int>("Id")
 2127                        .ValueGeneratedOnAdd()
 2128                        .HasColumnType("INTEGER");
 2129
 2130                    b.Property<int>("DayOfWeek")
 2131                        .HasColumnType("INTEGER");
 2132
 2133                    b.Property<double>("EndHour")
 2134                        .HasColumnType("REAL");
 2135
 2136                    b.Property<double>("StartHour")
 2137                        .HasColumnType("REAL");
 2138
 2139                    b.Property<Guid>("UserId")
 2140                        .HasColumnType("TEXT");
 2141
 2142                    b.HasKey("Id");
 2143
 2144                    b.HasIndex("UserId");
 2145
 2146                    b.ToTable("AccessSchedules");
 2147                });
 48
 2149            modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b =>
 2150                {
 2151                    b.Property<int>("Id")
 2152                        .ValueGeneratedOnAdd()
 2153                        .HasColumnType("INTEGER");
 2154
 2155                    b.Property<DateTime>("DateCreated")
 2156                        .HasColumnType("TEXT");
 2157
 2158                    b.Property<string>("ItemId")
 2159                        .HasMaxLength(256)
 2160                        .HasColumnType("TEXT");
 2161
 2162                    b.Property<int>("LogSeverity")
 2163                        .HasColumnType("INTEGER");
 2164
 2165                    b.Property<string>("Name")
 2166                        .IsRequired()
 2167                        .HasMaxLength(512)
 2168                        .HasColumnType("TEXT");
 2169
 2170                    b.Property<string>("Overview")
 2171                        .HasMaxLength(512)
 2172                        .HasColumnType("TEXT");
 2173
 2174                    b.Property<uint>("RowVersion")
 2175                        .IsConcurrencyToken()
 2176                        .HasColumnType("INTEGER");
 2177
 2178                    b.Property<string>("ShortOverview")
 2179                        .HasMaxLength(512)
 2180                        .HasColumnType("TEXT");
 2181
 2182                    b.Property<string>("Type")
 2183                        .IsRequired()
 2184                        .HasMaxLength(256)
 2185                        .HasColumnType("TEXT");
 2186
 2187                    b.Property<Guid>("UserId")
 2188                        .HasColumnType("TEXT");
 2189
 2190                    b.HasKey("Id");
 2191
 2192                    b.ToTable("ActivityLogs");
 2193                });
 94
 2195            modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b =>
 2196                {
 2197                    b.Property<int>("Id")
 2198                        .ValueGeneratedOnAdd()
 2199                        .HasColumnType("INTEGER");
 21100
 21101                    b.Property<string>("Client")
 21102                        .IsRequired()
 21103                        .HasMaxLength(32)
 21104                        .HasColumnType("TEXT");
 21105
 21106                    b.Property<Guid>("ItemId")
 21107                        .HasColumnType("TEXT");
 21108
 21109                    b.Property<string>("Key")
 21110                        .IsRequired()
 21111                        .HasColumnType("TEXT");
 21112
 21113                    b.Property<Guid>("UserId")
 21114                        .HasColumnType("TEXT");
 21115
 21116                    b.Property<string>("Value")
 21117                        .HasColumnType("TEXT");
 21118
 21119                    b.HasKey("Id");
 21120
 21121                    b.HasIndex("UserId", "ItemId", "Client", "Key")
 21122                        .IsUnique();
 21123
 21124                    b.ToTable("CustomItemDisplayPreferences");
 21125                });
 126
 21127            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21128                {
 21129                    b.Property<int>("Id")
 21130                        .ValueGeneratedOnAdd()
 21131                        .HasColumnType("INTEGER");
 21132
 21133                    b.Property<int>("ChromecastVersion")
 21134                        .HasColumnType("INTEGER");
 21135
 21136                    b.Property<string>("Client")
 21137                        .IsRequired()
 21138                        .HasMaxLength(32)
 21139                        .HasColumnType("TEXT");
 21140
 21141                    b.Property<string>("DashboardTheme")
 21142                        .HasMaxLength(32)
 21143                        .HasColumnType("TEXT");
 21144
 21145                    b.Property<bool>("EnableNextVideoInfoOverlay")
 21146                        .HasColumnType("INTEGER");
 21147
 21148                    b.Property<int?>("IndexBy")
 21149                        .HasColumnType("INTEGER");
 21150
 21151                    b.Property<Guid>("ItemId")
 21152                        .HasColumnType("TEXT");
 21153
 21154                    b.Property<int>("ScrollDirection")
 21155                        .HasColumnType("INTEGER");
 21156
 21157                    b.Property<bool>("ShowBackdrop")
 21158                        .HasColumnType("INTEGER");
 21159
 21160                    b.Property<bool>("ShowSidebar")
 21161                        .HasColumnType("INTEGER");
 21162
 21163                    b.Property<int>("SkipBackwardLength")
 21164                        .HasColumnType("INTEGER");
 21165
 21166                    b.Property<int>("SkipForwardLength")
 21167                        .HasColumnType("INTEGER");
 21168
 21169                    b.Property<string>("TvHome")
 21170                        .HasMaxLength(32)
 21171                        .HasColumnType("TEXT");
 21172
 21173                    b.Property<Guid>("UserId")
 21174                        .HasColumnType("TEXT");
 21175
 21176                    b.HasKey("Id");
 21177
 21178                    b.HasIndex("UserId", "ItemId", "Client")
 21179                        .IsUnique();
 21180
 21181                    b.ToTable("DisplayPreferences");
 21182                });
 183
 21184            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 21185                {
 21186                    b.Property<int>("Id")
 21187                        .ValueGeneratedOnAdd()
 21188                        .HasColumnType("INTEGER");
 21189
 21190                    b.Property<int>("DisplayPreferencesId")
 21191                        .HasColumnType("INTEGER");
 21192
 21193                    b.Property<int>("Order")
 21194                        .HasColumnType("INTEGER");
 21195
 21196                    b.Property<int>("Type")
 21197                        .HasColumnType("INTEGER");
 21198
 21199                    b.HasKey("Id");
 21200
 21201                    b.HasIndex("DisplayPreferencesId");
 21202
 21203                    b.ToTable("HomeSection");
 21204                });
 205
 21206            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21207                {
 21208                    b.Property<int>("Id")
 21209                        .ValueGeneratedOnAdd()
 21210                        .HasColumnType("INTEGER");
 21211
 21212                    b.Property<DateTime>("LastModified")
 21213                        .HasColumnType("TEXT");
 21214
 21215                    b.Property<string>("Path")
 21216                        .IsRequired()
 21217                        .HasMaxLength(512)
 21218                        .HasColumnType("TEXT");
 21219
 21220                    b.Property<Guid?>("UserId")
 21221                        .HasColumnType("TEXT");
 21222
 21223                    b.HasKey("Id");
 21224
 21225                    b.HasIndex("UserId")
 21226                        .IsUnique();
 21227
 21228                    b.ToTable("ImageInfos");
 21229                });
 230
 21231            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 21232                {
 21233                    b.Property<int>("Id")
 21234                        .ValueGeneratedOnAdd()
 21235                        .HasColumnType("INTEGER");
 21236
 21237                    b.Property<string>("Client")
 21238                        .IsRequired()
 21239                        .HasMaxLength(32)
 21240                        .HasColumnType("TEXT");
 21241
 21242                    b.Property<int?>("IndexBy")
 21243                        .HasColumnType("INTEGER");
 21244
 21245                    b.Property<Guid>("ItemId")
 21246                        .HasColumnType("TEXT");
 21247
 21248                    b.Property<bool>("RememberIndexing")
 21249                        .HasColumnType("INTEGER");
 21250
 21251                    b.Property<bool>("RememberSorting")
 21252                        .HasColumnType("INTEGER");
 21253
 21254                    b.Property<string>("SortBy")
 21255                        .IsRequired()
 21256                        .HasMaxLength(64)
 21257                        .HasColumnType("TEXT");
 21258
 21259                    b.Property<int>("SortOrder")
 21260                        .HasColumnType("INTEGER");
 21261
 21262                    b.Property<Guid>("UserId")
 21263                        .HasColumnType("TEXT");
 21264
 21265                    b.Property<int>("ViewType")
 21266                        .HasColumnType("INTEGER");
 21267
 21268                    b.HasKey("Id");
 21269
 21270                    b.HasIndex("UserId");
 21271
 21272                    b.ToTable("ItemDisplayPreferences");
 21273                });
 274
 21275            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21276                {
 21277                    b.Property<int>("Id")
 21278                        .ValueGeneratedOnAdd()
 21279                        .HasColumnType("INTEGER");
 21280
 21281                    b.Property<int>("Kind")
 21282                        .HasColumnType("INTEGER");
 21283
 21284                    b.Property<Guid?>("Permission_Permissions_Guid")
 21285                        .HasColumnType("TEXT");
 21286
 21287                    b.Property<uint>("RowVersion")
 21288                        .IsConcurrencyToken()
 21289                        .HasColumnType("INTEGER");
 21290
 21291                    b.Property<Guid?>("UserId")
 21292                        .HasColumnType("TEXT");
 21293
 21294                    b.Property<bool>("Value")
 21295                        .HasColumnType("INTEGER");
 21296
 21297                    b.HasKey("Id");
 21298
 21299                    b.HasIndex("UserId", "Kind")
 21300                        .IsUnique()
 21301                        .HasFilter("[UserId] IS NOT NULL");
 21302
 21303                    b.ToTable("Permissions");
 21304                });
 305
 21306            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21307                {
 21308                    b.Property<int>("Id")
 21309                        .ValueGeneratedOnAdd()
 21310                        .HasColumnType("INTEGER");
 21311
 21312                    b.Property<int>("Kind")
 21313                        .HasColumnType("INTEGER");
 21314
 21315                    b.Property<Guid?>("Preference_Preferences_Guid")
 21316                        .HasColumnType("TEXT");
 21317
 21318                    b.Property<uint>("RowVersion")
 21319                        .IsConcurrencyToken()
 21320                        .HasColumnType("INTEGER");
 21321
 21322                    b.Property<Guid?>("UserId")
 21323                        .HasColumnType("TEXT");
 21324
 21325                    b.Property<string>("Value")
 21326                        .IsRequired()
 21327                        .HasMaxLength(65535)
 21328                        .HasColumnType("TEXT");
 21329
 21330                    b.HasKey("Id");
 21331
 21332                    b.HasIndex("UserId", "Kind")
 21333                        .IsUnique()
 21334                        .HasFilter("[UserId] IS NOT NULL");
 21335
 21336                    b.ToTable("Preferences");
 21337                });
 338
 21339            modelBuilder.Entity("Jellyfin.Data.Entities.Security.ApiKey", b =>
 21340                {
 21341                    b.Property<int>("Id")
 21342                        .ValueGeneratedOnAdd()
 21343                        .HasColumnType("INTEGER");
 21344
 21345                    b.Property<string>("AccessToken")
 21346                        .IsRequired()
 21347                        .HasColumnType("TEXT");
 21348
 21349                    b.Property<DateTime>("DateCreated")
 21350                        .HasColumnType("TEXT");
 21351
 21352                    b.Property<DateTime>("DateLastActivity")
 21353                        .HasColumnType("TEXT");
 21354
 21355                    b.Property<string>("Name")
 21356                        .IsRequired()
 21357                        .HasMaxLength(64)
 21358                        .HasColumnType("TEXT");
 21359
 21360                    b.HasKey("Id");
 21361
 21362                    b.HasIndex("AccessToken")
 21363                        .IsUnique();
 21364
 21365                    b.ToTable("ApiKeys");
 21366                });
 367
 21368            modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
 21369                {
 21370                    b.Property<int>("Id")
 21371                        .ValueGeneratedOnAdd()
 21372                        .HasColumnType("INTEGER");
 21373
 21374                    b.Property<string>("AccessToken")
 21375                        .IsRequired()
 21376                        .HasColumnType("TEXT");
 21377
 21378                    b.Property<string>("AppName")
 21379                        .IsRequired()
 21380                        .HasMaxLength(64)
 21381                        .HasColumnType("TEXT");
 21382
 21383                    b.Property<string>("AppVersion")
 21384                        .IsRequired()
 21385                        .HasMaxLength(32)
 21386                        .HasColumnType("TEXT");
 21387
 21388                    b.Property<DateTime>("DateCreated")
 21389                        .HasColumnType("TEXT");
 21390
 21391                    b.Property<DateTime>("DateLastActivity")
 21392                        .HasColumnType("TEXT");
 21393
 21394                    b.Property<DateTime>("DateModified")
 21395                        .HasColumnType("TEXT");
 21396
 21397                    b.Property<string>("DeviceId")
 21398                        .IsRequired()
 21399                        .HasMaxLength(256)
 21400                        .HasColumnType("TEXT");
 21401
 21402                    b.Property<string>("DeviceName")
 21403                        .IsRequired()
 21404                        .HasMaxLength(64)
 21405                        .HasColumnType("TEXT");
 21406
 21407                    b.Property<bool>("IsActive")
 21408                        .HasColumnType("INTEGER");
 21409
 21410                    b.Property<Guid>("UserId")
 21411                        .HasColumnType("TEXT");
 21412
 21413                    b.HasKey("Id");
 21414
 21415                    b.HasIndex("DeviceId");
 21416
 21417                    b.HasIndex("AccessToken", "DateLastActivity");
 21418
 21419                    b.HasIndex("DeviceId", "DateLastActivity");
 21420
 21421                    b.HasIndex("UserId", "DeviceId");
 21422
 21423                    b.ToTable("Devices");
 21424                });
 425
 21426            modelBuilder.Entity("Jellyfin.Data.Entities.Security.DeviceOptions", b =>
 21427                {
 21428                    b.Property<int>("Id")
 21429                        .ValueGeneratedOnAdd()
 21430                        .HasColumnType("INTEGER");
 21431
 21432                    b.Property<string>("CustomName")
 21433                        .HasColumnType("TEXT");
 21434
 21435                    b.Property<string>("DeviceId")
 21436                        .IsRequired()
 21437                        .HasColumnType("TEXT");
 21438
 21439                    b.HasKey("Id");
 21440
 21441                    b.HasIndex("DeviceId")
 21442                        .IsUnique();
 21443
 21444                    b.ToTable("DeviceOptions");
 21445                });
 446
 21447            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 21448                {
 21449                    b.Property<Guid>("Id")
 21450                        .ValueGeneratedOnAdd()
 21451                        .HasColumnType("TEXT");
 21452
 21453                    b.Property<string>("AudioLanguagePreference")
 21454                        .HasMaxLength(255)
 21455                        .HasColumnType("TEXT");
 21456
 21457                    b.Property<string>("AuthenticationProviderId")
 21458                        .IsRequired()
 21459                        .HasMaxLength(255)
 21460                        .HasColumnType("TEXT");
 21461
 21462                    b.Property<bool>("DisplayCollectionsView")
 21463                        .HasColumnType("INTEGER");
 21464
 21465                    b.Property<bool>("DisplayMissingEpisodes")
 21466                        .HasColumnType("INTEGER");
 21467
 21468                    b.Property<string>("EasyPassword")
 21469                        .HasMaxLength(65535)
 21470                        .HasColumnType("TEXT");
 21471
 21472                    b.Property<bool>("EnableAutoLogin")
 21473                        .HasColumnType("INTEGER");
 21474
 21475                    b.Property<bool>("EnableLocalPassword")
 21476                        .HasColumnType("INTEGER");
 21477
 21478                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 21479                        .HasColumnType("INTEGER");
 21480
 21481                    b.Property<bool>("EnableUserPreferenceAccess")
 21482                        .HasColumnType("INTEGER");
 21483
 21484                    b.Property<bool>("HidePlayedInLatest")
 21485                        .HasColumnType("INTEGER");
 21486
 21487                    b.Property<long>("InternalId")
 21488                        .HasColumnType("INTEGER");
 21489
 21490                    b.Property<int>("InvalidLoginAttemptCount")
 21491                        .HasColumnType("INTEGER");
 21492
 21493                    b.Property<DateTime?>("LastActivityDate")
 21494                        .HasColumnType("TEXT");
 21495
 21496                    b.Property<DateTime?>("LastLoginDate")
 21497                        .HasColumnType("TEXT");
 21498
 21499                    b.Property<int?>("LoginAttemptsBeforeLockout")
 21500                        .HasColumnType("INTEGER");
 21501
 21502                    b.Property<int>("MaxActiveSessions")
 21503                        .HasColumnType("INTEGER");
 21504
 21505                    b.Property<int?>("MaxParentalAgeRating")
 21506                        .HasColumnType("INTEGER");
 21507
 21508                    b.Property<bool>("MustUpdatePassword")
 21509                        .HasColumnType("INTEGER");
 21510
 21511                    b.Property<string>("Password")
 21512                        .HasMaxLength(65535)
 21513                        .HasColumnType("TEXT");
 21514
 21515                    b.Property<string>("PasswordResetProviderId")
 21516                        .IsRequired()
 21517                        .HasMaxLength(255)
 21518                        .HasColumnType("TEXT");
 21519
 21520                    b.Property<bool>("PlayDefaultAudioTrack")
 21521                        .HasColumnType("INTEGER");
 21522
 21523                    b.Property<bool>("RememberAudioSelections")
 21524                        .HasColumnType("INTEGER");
 21525
 21526                    b.Property<bool>("RememberSubtitleSelections")
 21527                        .HasColumnType("INTEGER");
 21528
 21529                    b.Property<int?>("RemoteClientBitrateLimit")
 21530                        .HasColumnType("INTEGER");
 21531
 21532                    b.Property<uint>("RowVersion")
 21533                        .IsConcurrencyToken()
 21534                        .HasColumnType("INTEGER");
 21535
 21536                    b.Property<string>("SubtitleLanguagePreference")
 21537                        .HasMaxLength(255)
 21538                        .HasColumnType("TEXT");
 21539
 21540                    b.Property<int>("SubtitleMode")
 21541                        .HasColumnType("INTEGER");
 21542
 21543                    b.Property<int>("SyncPlayAccess")
 21544                        .HasColumnType("INTEGER");
 21545
 21546                    b.Property<string>("Username")
 21547                        .IsRequired()
 21548                        .HasMaxLength(255)
 21549                        .HasColumnType("TEXT")
 21550                        .UseCollation("NOCASE");
 21551
 21552                    b.HasKey("Id");
 21553
 21554                    b.HasIndex("Username")
 21555                        .IsUnique();
 21556
 21557                    b.ToTable("Users");
 21558                });
 559
 21560            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 21561                {
 21562                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21563                        .WithMany("AccessSchedules")
 21564                        .HasForeignKey("UserId")
 21565                        .OnDelete(DeleteBehavior.Cascade)
 21566                        .IsRequired();
 21567                });
 568
 21569            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21570                {
 21571                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21572                        .WithMany("DisplayPreferences")
 21573                        .HasForeignKey("UserId")
 21574                        .OnDelete(DeleteBehavior.Cascade)
 21575                        .IsRequired();
 21576                });
 577
 21578            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 21579                {
 21580                    b.HasOne("Jellyfin.Data.Entities.DisplayPreferences", null)
 21581                        .WithMany("HomeSections")
 21582                        .HasForeignKey("DisplayPreferencesId")
 21583                        .OnDelete(DeleteBehavior.Cascade)
 21584                        .IsRequired();
 21585                });
 586
 21587            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21588                {
 21589                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21590                        .WithOne("ProfileImage")
 21591                        .HasForeignKey("Jellyfin.Data.Entities.ImageInfo", "UserId")
 21592                        .OnDelete(DeleteBehavior.Cascade);
 21593                });
 594
 21595            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 21596                {
 21597                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21598                        .WithMany("ItemDisplayPreferences")
 21599                        .HasForeignKey("UserId")
 21600                        .OnDelete(DeleteBehavior.Cascade)
 21601                        .IsRequired();
 21602                });
 603
 21604            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21605                {
 21606                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21607                        .WithMany("Permissions")
 21608                        .HasForeignKey("UserId")
 21609                        .OnDelete(DeleteBehavior.Cascade);
 21610                });
 611
 21612            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21613                {
 21614                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21615                        .WithMany("Preferences")
 21616                        .HasForeignKey("UserId")
 21617                        .OnDelete(DeleteBehavior.Cascade);
 21618                });
 619
 21620            modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
 21621                {
 21622                    b.HasOne("Jellyfin.Data.Entities.User", "User")
 21623                        .WithMany()
 21624                        .HasForeignKey("UserId")
 21625                        .OnDelete(DeleteBehavior.Cascade)
 21626                        .IsRequired();
 21627
 21628                    b.Navigation("User");
 21629                });
 630
 21631            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21632                {
 21633                    b.Navigation("HomeSections");
 21634                });
 635
 21636            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 21637                {
 21638                    b.Navigation("AccessSchedules");
 21639
 21640                    b.Navigation("DisplayPreferences");
 21641
 21642                    b.Navigation("ItemDisplayPreferences");
 21643
 21644                    b.Navigation("Permissions");
 21645
 21646                    b.Navigation("Preferences");
 21647
 21648                    b.Navigation("ProfileImage");
 21649                });
 650#pragma warning restore 612, 618
 21651        }
 652    }
 653}
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)