< Summary - Jellyfin

Information
Class: Jellyfin.Server.Implementations.Migrations.FixDisplayPreferencesIndex
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20200905220533_FixDisplayPreferencesIndex.cs
File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20200905220533_FixDisplayPreferencesIndex.Designer.cs
Line coverage
96%
Covered lines: 439
Uncovered lines: 15
Coverable lines: 454
Total lines: 512
Line coverage: 96.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/20200905220533_FixDisplayPreferencesIndex.cs

#LineLine coverage
 1#pragma warning disable CS1591
 2#pragma warning disable SA1601
 3
 4using Microsoft.EntityFrameworkCore.Migrations;
 5
 6namespace Jellyfin.Server.Implementations.Migrations
 7{
 8    public partial class FixDisplayPreferencesIndex : Migration
 9    {
 10        protected override void Up(MigrationBuilder migrationBuilder)
 11        {
 2112            migrationBuilder.DropIndex(
 2113                name: "IX_DisplayPreferences_UserId",
 2114                schema: "jellyfin",
 2115                table: "DisplayPreferences");
 16
 2117            migrationBuilder.CreateIndex(
 2118                name: "IX_DisplayPreferences_UserId",
 2119                schema: "jellyfin",
 2120                table: "DisplayPreferences",
 2121                column: "UserId");
 22
 2123            migrationBuilder.CreateIndex(
 2124                name: "IX_DisplayPreferences_UserId_Client",
 2125                schema: "jellyfin",
 2126                table: "DisplayPreferences",
 2127                columns: new[] { "UserId", "Client" },
 2128                unique: true);
 2129        }
 30
 31        protected override void Down(MigrationBuilder migrationBuilder)
 32        {
 033            migrationBuilder.DropIndex(
 034                name: "IX_DisplayPreferences_UserId",
 035                schema: "jellyfin",
 036                table: "DisplayPreferences");
 37
 038            migrationBuilder.DropIndex(
 039                name: "IX_DisplayPreferences_UserId_Client",
 040                schema: "jellyfin",
 041                table: "DisplayPreferences");
 42
 043            migrationBuilder.CreateIndex(
 044                name: "IX_DisplayPreferences_UserId",
 045                schema: "jellyfin",
 046                table: "DisplayPreferences",
 047                column: "UserId",
 048                unique: true);
 049        }
 50    }
 51}

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20200905220533_FixDisplayPreferencesIndex.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("20200905220533_FixDisplayPreferencesIndex")]
 15    partial class FixDisplayPreferencesIndex
 16    {
 17        protected override void BuildTargetModel(ModelBuilder modelBuilder)
 18        {
 19#pragma warning disable 612, 618
 2120            modelBuilder
 2121                .HasDefaultSchema("jellyfin")
 2122                .HasAnnotation("ProductVersion", "3.1.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                        .HasColumnType("TEXT")
 2160                        .HasMaxLength(256);
 2161
 2162                    b.Property<int>("LogSeverity")
 2163                        .HasColumnType("INTEGER");
 2164
 2165                    b.Property<string>("Name")
 2166                        .IsRequired()
 2167                        .HasColumnType("TEXT")
 2168                        .HasMaxLength(512);
 2169
 2170                    b.Property<string>("Overview")
 2171                        .HasColumnType("TEXT")
 2172                        .HasMaxLength(512);
 2173
 2174                    b.Property<uint>("RowVersion")
 2175                        .IsConcurrencyToken()
 2176                        .HasColumnType("INTEGER");
 2177
 2178                    b.Property<string>("ShortOverview")
 2179                        .HasColumnType("TEXT")
 2180                        .HasMaxLength(512);
 2181
 2182                    b.Property<string>("Type")
 2183                        .IsRequired()
 2184                        .HasColumnType("TEXT")
 2185                        .HasMaxLength(256);
 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.DisplayPreferences", b =>
 2196                {
 2197                    b.Property<int>("Id")
 2198                        .ValueGeneratedOnAdd()
 2199                        .HasColumnType("INTEGER");
 21100
 21101                    b.Property<int>("ChromecastVersion")
 21102                        .HasColumnType("INTEGER");
 21103
 21104                    b.Property<string>("Client")
 21105                        .IsRequired()
 21106                        .HasColumnType("TEXT")
 21107                        .HasMaxLength(32);
 21108
 21109                    b.Property<string>("DashboardTheme")
 21110                        .HasColumnType("TEXT")
 21111                        .HasMaxLength(32);
 21112
 21113                    b.Property<bool>("EnableNextVideoInfoOverlay")
 21114                        .HasColumnType("INTEGER");
 21115
 21116                    b.Property<int?>("IndexBy")
 21117                        .HasColumnType("INTEGER");
 21118
 21119                    b.Property<int>("ScrollDirection")
 21120                        .HasColumnType("INTEGER");
 21121
 21122                    b.Property<bool>("ShowBackdrop")
 21123                        .HasColumnType("INTEGER");
 21124
 21125                    b.Property<bool>("ShowSidebar")
 21126                        .HasColumnType("INTEGER");
 21127
 21128                    b.Property<int>("SkipBackwardLength")
 21129                        .HasColumnType("INTEGER");
 21130
 21131                    b.Property<int>("SkipForwardLength")
 21132                        .HasColumnType("INTEGER");
 21133
 21134                    b.Property<string>("TvHome")
 21135                        .HasColumnType("TEXT")
 21136                        .HasMaxLength(32);
 21137
 21138                    b.Property<Guid>("UserId")
 21139                        .HasColumnType("TEXT");
 21140
 21141                    b.HasKey("Id");
 21142
 21143                    b.HasIndex("UserId");
 21144
 21145                    b.HasIndex("UserId", "Client")
 21146                        .IsUnique();
 21147
 21148                    b.ToTable("DisplayPreferences");
 21149                });
 150
 21151            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 21152                {
 21153                    b.Property<int>("Id")
 21154                        .ValueGeneratedOnAdd()
 21155                        .HasColumnType("INTEGER");
 21156
 21157                    b.Property<int>("DisplayPreferencesId")
 21158                        .HasColumnType("INTEGER");
 21159
 21160                    b.Property<int>("Order")
 21161                        .HasColumnType("INTEGER");
 21162
 21163                    b.Property<int>("Type")
 21164                        .HasColumnType("INTEGER");
 21165
 21166                    b.HasKey("Id");
 21167
 21168                    b.HasIndex("DisplayPreferencesId");
 21169
 21170                    b.ToTable("HomeSection");
 21171                });
 172
 21173            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21174                {
 21175                    b.Property<int>("Id")
 21176                        .ValueGeneratedOnAdd()
 21177                        .HasColumnType("INTEGER");
 21178
 21179                    b.Property<DateTime>("LastModified")
 21180                        .HasColumnType("TEXT");
 21181
 21182                    b.Property<string>("Path")
 21183                        .IsRequired()
 21184                        .HasColumnType("TEXT")
 21185                        .HasMaxLength(512);
 21186
 21187                    b.Property<Guid?>("UserId")
 21188                        .HasColumnType("TEXT");
 21189
 21190                    b.HasKey("Id");
 21191
 21192                    b.HasIndex("UserId")
 21193                        .IsUnique();
 21194
 21195                    b.ToTable("ImageInfos");
 21196                });
 197
 21198            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 21199                {
 21200                    b.Property<int>("Id")
 21201                        .ValueGeneratedOnAdd()
 21202                        .HasColumnType("INTEGER");
 21203
 21204                    b.Property<string>("Client")
 21205                        .IsRequired()
 21206                        .HasColumnType("TEXT")
 21207                        .HasMaxLength(32);
 21208
 21209                    b.Property<int?>("IndexBy")
 21210                        .HasColumnType("INTEGER");
 21211
 21212                    b.Property<Guid>("ItemId")
 21213                        .HasColumnType("TEXT");
 21214
 21215                    b.Property<bool>("RememberIndexing")
 21216                        .HasColumnType("INTEGER");
 21217
 21218                    b.Property<bool>("RememberSorting")
 21219                        .HasColumnType("INTEGER");
 21220
 21221                    b.Property<string>("SortBy")
 21222                        .IsRequired()
 21223                        .HasColumnType("TEXT")
 21224                        .HasMaxLength(64);
 21225
 21226                    b.Property<int>("SortOrder")
 21227                        .HasColumnType("INTEGER");
 21228
 21229                    b.Property<Guid>("UserId")
 21230                        .HasColumnType("TEXT");
 21231
 21232                    b.Property<int>("ViewType")
 21233                        .HasColumnType("INTEGER");
 21234
 21235                    b.HasKey("Id");
 21236
 21237                    b.HasIndex("UserId");
 21238
 21239                    b.ToTable("ItemDisplayPreferences");
 21240                });
 241
 21242            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21243                {
 21244                    b.Property<int>("Id")
 21245                        .ValueGeneratedOnAdd()
 21246                        .HasColumnType("INTEGER");
 21247
 21248                    b.Property<int>("Kind")
 21249                        .HasColumnType("INTEGER");
 21250
 21251                    b.Property<Guid?>("Permission_Permissions_Guid")
 21252                        .HasColumnType("TEXT");
 21253
 21254                    b.Property<uint>("RowVersion")
 21255                        .IsConcurrencyToken()
 21256                        .HasColumnType("INTEGER");
 21257
 21258                    b.Property<bool>("Value")
 21259                        .HasColumnType("INTEGER");
 21260
 21261                    b.HasKey("Id");
 21262
 21263                    b.HasIndex("Permission_Permissions_Guid");
 21264
 21265                    b.ToTable("Permissions");
 21266                });
 267
 21268            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21269                {
 21270                    b.Property<int>("Id")
 21271                        .ValueGeneratedOnAdd()
 21272                        .HasColumnType("INTEGER");
 21273
 21274                    b.Property<int>("Kind")
 21275                        .HasColumnType("INTEGER");
 21276
 21277                    b.Property<Guid?>("Preference_Preferences_Guid")
 21278                        .HasColumnType("TEXT");
 21279
 21280                    b.Property<uint>("RowVersion")
 21281                        .IsConcurrencyToken()
 21282                        .HasColumnType("INTEGER");
 21283
 21284                    b.Property<string>("Value")
 21285                        .IsRequired()
 21286                        .HasColumnType("TEXT")
 21287                        .HasMaxLength(65535);
 21288
 21289                    b.HasKey("Id");
 21290
 21291                    b.HasIndex("Preference_Preferences_Guid");
 21292
 21293                    b.ToTable("Preferences");
 21294                });
 295
 21296            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 21297                {
 21298                    b.Property<Guid>("Id")
 21299                        .ValueGeneratedOnAdd()
 21300                        .HasColumnType("TEXT");
 21301
 21302                    b.Property<string>("AudioLanguagePreference")
 21303                        .HasColumnType("TEXT")
 21304                        .HasMaxLength(255);
 21305
 21306                    b.Property<string>("AuthenticationProviderId")
 21307                        .IsRequired()
 21308                        .HasColumnType("TEXT")
 21309                        .HasMaxLength(255);
 21310
 21311                    b.Property<bool>("DisplayCollectionsView")
 21312                        .HasColumnType("INTEGER");
 21313
 21314                    b.Property<bool>("DisplayMissingEpisodes")
 21315                        .HasColumnType("INTEGER");
 21316
 21317                    b.Property<string>("EasyPassword")
 21318                        .HasColumnType("TEXT")
 21319                        .HasMaxLength(65535);
 21320
 21321                    b.Property<bool>("EnableAutoLogin")
 21322                        .HasColumnType("INTEGER");
 21323
 21324                    b.Property<bool>("EnableLocalPassword")
 21325                        .HasColumnType("INTEGER");
 21326
 21327                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 21328                        .HasColumnType("INTEGER");
 21329
 21330                    b.Property<bool>("EnableUserPreferenceAccess")
 21331                        .HasColumnType("INTEGER");
 21332
 21333                    b.Property<bool>("HidePlayedInLatest")
 21334                        .HasColumnType("INTEGER");
 21335
 21336                    b.Property<long>("InternalId")
 21337                        .HasColumnType("INTEGER");
 21338
 21339                    b.Property<int>("InvalidLoginAttemptCount")
 21340                        .HasColumnType("INTEGER");
 21341
 21342                    b.Property<DateTime?>("LastActivityDate")
 21343                        .HasColumnType("TEXT");
 21344
 21345                    b.Property<DateTime?>("LastLoginDate")
 21346                        .HasColumnType("TEXT");
 21347
 21348                    b.Property<int?>("LoginAttemptsBeforeLockout")
 21349                        .HasColumnType("INTEGER");
 21350
 21351                    b.Property<int?>("MaxParentalAgeRating")
 21352                        .HasColumnType("INTEGER");
 21353
 21354                    b.Property<bool>("MustUpdatePassword")
 21355                        .HasColumnType("INTEGER");
 21356
 21357                    b.Property<string>("Password")
 21358                        .HasColumnType("TEXT")
 21359                        .HasMaxLength(65535);
 21360
 21361                    b.Property<string>("PasswordResetProviderId")
 21362                        .IsRequired()
 21363                        .HasColumnType("TEXT")
 21364                        .HasMaxLength(255);
 21365
 21366                    b.Property<bool>("PlayDefaultAudioTrack")
 21367                        .HasColumnType("INTEGER");
 21368
 21369                    b.Property<bool>("RememberAudioSelections")
 21370                        .HasColumnType("INTEGER");
 21371
 21372                    b.Property<bool>("RememberSubtitleSelections")
 21373                        .HasColumnType("INTEGER");
 21374
 21375                    b.Property<int?>("RemoteClientBitrateLimit")
 21376                        .HasColumnType("INTEGER");
 21377
 21378                    b.Property<uint>("RowVersion")
 21379                        .IsConcurrencyToken()
 21380                        .HasColumnType("INTEGER");
 21381
 21382                    b.Property<string>("SubtitleLanguagePreference")
 21383                        .HasColumnType("TEXT")
 21384                        .HasMaxLength(255);
 21385
 21386                    b.Property<int>("SubtitleMode")
 21387                        .HasColumnType("INTEGER");
 21388
 21389                    b.Property<int>("SyncPlayAccess")
 21390                        .HasColumnType("INTEGER");
 21391
 21392                    b.Property<string>("Username")
 21393                        .IsRequired()
 21394                        .HasColumnType("TEXT")
 21395                        .HasMaxLength(255);
 21396
 21397                    b.HasKey("Id");
 21398
 21399                    b.ToTable("Users");
 21400                });
 401
 21402            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 21403                {
 21404                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21405                        .WithMany("AccessSchedules")
 21406                        .HasForeignKey("UserId")
 21407                        .OnDelete(DeleteBehavior.Cascade)
 21408                        .IsRequired();
 21409                });
 410
 21411            modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
 21412                {
 21413                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21414                        .WithOne("DisplayPreferences")
 21415                        .HasForeignKey("Jellyfin.Data.Entities.DisplayPreferences", "UserId")
 21416                        .OnDelete(DeleteBehavior.Cascade)
 21417                        .IsRequired();
 21418                });
 419
 21420            modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
 21421                {
 21422                    b.HasOne("Jellyfin.Data.Entities.DisplayPreferences", null)
 21423                        .WithMany("HomeSections")
 21424                        .HasForeignKey("DisplayPreferencesId")
 21425                        .OnDelete(DeleteBehavior.Cascade)
 21426                        .IsRequired();
 21427                });
 428
 21429            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21430                {
 21431                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21432                        .WithOne("ProfileImage")
 21433                        .HasForeignKey("Jellyfin.Data.Entities.ImageInfo", "UserId");
 21434                });
 435
 21436            modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
 21437                {
 21438                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21439                        .WithMany("ItemDisplayPreferences")
 21440                        .HasForeignKey("UserId")
 21441                        .OnDelete(DeleteBehavior.Cascade)
 21442                        .IsRequired();
 21443                });
 444
 21445            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21446                {
 21447                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21448                        .WithMany("Permissions")
 21449                        .HasForeignKey("Permission_Permissions_Guid");
 21450                });
 451
 21452            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21453                {
 21454                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21455                        .WithMany("Preferences")
 21456                        .HasForeignKey("Preference_Preferences_Guid");
 21457                });
 458#pragma warning restore 612, 618
 21459        }
 460    }
 461}
Generated by: ReportGenerator 5.4.5.0
4/26/2025 - 12:10:59 AM
GitHub | reportgenerator.io

Methods/Properties

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