< Summary - Jellyfin

Information
Class: Jellyfin.Server.Implementations.Migrations.AddUsers
Assembly: Jellyfin.Database.Providers.Sqlite
File(s): File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20200613202153_AddUsers.cs
File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20200613202153_AddUsers.Designer.cs
Line coverage
96%
Covered lines: 432
Uncovered lines: 16
Coverable lines: 448
Total lines: 509
Line coverage: 96.4%
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/20200613202153_AddUsers.cs

#LineLine coverage
 1#pragma warning disable CS1591
 2#pragma warning disable SA1601
 3
 4using System;
 5using Microsoft.EntityFrameworkCore.Migrations;
 6
 7namespace Jellyfin.Server.Implementations.Migrations
 8{
 9    public partial class AddUsers : Migration
 10    {
 11        protected override void Up(MigrationBuilder migrationBuilder)
 12        {
 2113            migrationBuilder.CreateTable(
 2114                name: "Users",
 2115                schema: "jellyfin",
 2116                columns: table => new
 2117                {
 2118                    Id = table.Column<Guid>(nullable: false),
 2119                    Username = table.Column<string>(maxLength: 255, nullable: false),
 2120                    Password = table.Column<string>(maxLength: 65535, nullable: true),
 2121                    EasyPassword = table.Column<string>(maxLength: 65535, nullable: true),
 2122                    MustUpdatePassword = table.Column<bool>(nullable: false),
 2123                    AudioLanguagePreference = table.Column<string>(maxLength: 255, nullable: true),
 2124                    AuthenticationProviderId = table.Column<string>(maxLength: 255, nullable: false),
 2125                    PasswordResetProviderId = table.Column<string>(maxLength: 255, nullable: false),
 2126                    InvalidLoginAttemptCount = table.Column<int>(nullable: false),
 2127                    LastActivityDate = table.Column<DateTime>(nullable: true),
 2128                    LastLoginDate = table.Column<DateTime>(nullable: true),
 2129                    LoginAttemptsBeforeLockout = table.Column<int>(nullable: true),
 2130                    SubtitleMode = table.Column<int>(nullable: false),
 2131                    PlayDefaultAudioTrack = table.Column<bool>(nullable: false),
 2132                    SubtitleLanguagePreference = table.Column<string>(maxLength: 255, nullable: true),
 2133                    DisplayMissingEpisodes = table.Column<bool>(nullable: false),
 2134                    DisplayCollectionsView = table.Column<bool>(nullable: false),
 2135                    EnableLocalPassword = table.Column<bool>(nullable: false),
 2136                    HidePlayedInLatest = table.Column<bool>(nullable: false),
 2137                    RememberAudioSelections = table.Column<bool>(nullable: false),
 2138                    RememberSubtitleSelections = table.Column<bool>(nullable: false),
 2139                    EnableNextEpisodeAutoPlay = table.Column<bool>(nullable: false),
 2140                    EnableAutoLogin = table.Column<bool>(nullable: false),
 2141                    EnableUserPreferenceAccess = table.Column<bool>(nullable: false),
 2142                    MaxParentalAgeRating = table.Column<int>(nullable: true),
 2143                    RemoteClientBitrateLimit = table.Column<int>(nullable: true),
 2144                    InternalId = table.Column<long>(nullable: false),
 2145                    SyncPlayAccess = table.Column<int>(nullable: false),
 2146                    RowVersion = table.Column<uint>(nullable: false)
 2147                },
 2148                constraints: table =>
 2149                {
 2150                    table.PrimaryKey("PK_Users", x => x.Id);
 2151                });
 52
 2153            migrationBuilder.CreateTable(
 2154                name: "AccessSchedules",
 2155                schema: "jellyfin",
 2156                columns: table => new
 2157                {
 2158                    Id = table.Column<int>(nullable: false)
 2159                        .Annotation("Sqlite:Autoincrement", true),
 2160                    UserId = table.Column<Guid>(nullable: false),
 2161                    DayOfWeek = table.Column<int>(nullable: false),
 2162                    StartHour = table.Column<double>(nullable: false),
 2163                    EndHour = table.Column<double>(nullable: false)
 2164                },
 2165                constraints: table =>
 2166                {
 2167                    table.PrimaryKey("PK_AccessSchedules", x => x.Id);
 2168                    table.ForeignKey(
 2169                        name: "FK_AccessSchedules_Users_UserId",
 2170                        column: x => x.UserId,
 2171                        principalSchema: "jellyfin",
 2172                        principalTable: "Users",
 2173                        principalColumn: "Id",
 2174                        onDelete: ReferentialAction.Cascade);
 2175                });
 76
 2177            migrationBuilder.CreateTable(
 2178                name: "ImageInfos",
 2179                schema: "jellyfin",
 2180                columns: table => new
 2181                {
 2182                    Id = table.Column<int>(nullable: false)
 2183                        .Annotation("Sqlite:Autoincrement", true),
 2184                    UserId = table.Column<Guid>(nullable: true),
 2185                    Path = table.Column<string>(maxLength: 512, nullable: false),
 2186                    LastModified = table.Column<DateTime>(nullable: false)
 2187                },
 2188                constraints: table =>
 2189                {
 2190                    table.PrimaryKey("PK_ImageInfos", x => x.Id);
 2191                    table.ForeignKey(
 2192                        name: "FK_ImageInfos_Users_UserId",
 2193                        column: x => x.UserId,
 2194                        principalSchema: "jellyfin",
 2195                        principalTable: "Users",
 2196                        principalColumn: "Id",
 2197                        onDelete: ReferentialAction.Restrict);
 2198                });
 99
 21100            migrationBuilder.CreateTable(
 21101                name: "Permissions",
 21102                schema: "jellyfin",
 21103                columns: table => new
 21104                {
 21105                    Id = table.Column<int>(nullable: false)
 21106                        .Annotation("Sqlite:Autoincrement", true),
 21107                    Kind = table.Column<int>(nullable: false),
 21108                    Value = table.Column<bool>(nullable: false),
 21109                    RowVersion = table.Column<uint>(nullable: false),
 21110                    Permission_Permissions_Guid = table.Column<Guid>(nullable: true)
 21111                },
 21112                constraints: table =>
 21113                {
 21114                    table.PrimaryKey("PK_Permissions", x => x.Id);
 21115                    table.ForeignKey(
 21116                        name: "FK_Permissions_Users_Permission_Permissions_Guid",
 21117                        column: x => x.Permission_Permissions_Guid,
 21118                        principalSchema: "jellyfin",
 21119                        principalTable: "Users",
 21120                        principalColumn: "Id",
 21121                        onDelete: ReferentialAction.Restrict);
 21122                });
 123
 21124            migrationBuilder.CreateTable(
 21125                name: "Preferences",
 21126                schema: "jellyfin",
 21127                columns: table => new
 21128                {
 21129                    Id = table.Column<int>(nullable: false)
 21130                        .Annotation("Sqlite:Autoincrement", true),
 21131                    Kind = table.Column<int>(nullable: false),
 21132                    Value = table.Column<string>(maxLength: 65535, nullable: false),
 21133                    RowVersion = table.Column<uint>(nullable: false),
 21134                    Preference_Preferences_Guid = table.Column<Guid>(nullable: true)
 21135                },
 21136                constraints: table =>
 21137                {
 21138                    table.PrimaryKey("PK_Preferences", x => x.Id);
 21139                    table.ForeignKey(
 21140                        name: "FK_Preferences_Users_Preference_Preferences_Guid",
 21141                        column: x => x.Preference_Preferences_Guid,
 21142                        principalSchema: "jellyfin",
 21143                        principalTable: "Users",
 21144                        principalColumn: "Id",
 21145                        onDelete: ReferentialAction.Restrict);
 21146                });
 147
 21148            migrationBuilder.CreateIndex(
 21149                name: "IX_AccessSchedules_UserId",
 21150                schema: "jellyfin",
 21151                table: "AccessSchedules",
 21152                column: "UserId");
 153
 21154            migrationBuilder.CreateIndex(
 21155                name: "IX_ImageInfos_UserId",
 21156                schema: "jellyfin",
 21157                table: "ImageInfos",
 21158                column: "UserId",
 21159                unique: true);
 160
 21161            migrationBuilder.CreateIndex(
 21162                name: "IX_Permissions_Permission_Permissions_Guid",
 21163                schema: "jellyfin",
 21164                table: "Permissions",
 21165                column: "Permission_Permissions_Guid");
 166
 21167            migrationBuilder.CreateIndex(
 21168                name: "IX_Preferences_Preference_Preferences_Guid",
 21169                schema: "jellyfin",
 21170                table: "Preferences",
 21171                column: "Preference_Preferences_Guid");
 21172        }
 173
 174        protected override void Down(MigrationBuilder migrationBuilder)
 175        {
 0176            migrationBuilder.DropTable(
 0177                name: "AccessSchedules",
 0178                schema: "jellyfin");
 179
 0180            migrationBuilder.DropTable(
 0181                name: "ImageInfos",
 0182                schema: "jellyfin");
 183
 0184            migrationBuilder.DropTable(
 0185                name: "Permissions",
 0186                schema: "jellyfin");
 187
 0188            migrationBuilder.DropTable(
 0189                name: "Preferences",
 0190                schema: "jellyfin");
 191
 0192            migrationBuilder.DropTable(
 0193                name: "Users",
 0194                schema: "jellyfin");
 0195        }
 196    }
 197}

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20200613202153_AddUsers.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("20200613202153_AddUsers")]
 15    partial class AddUsers
 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.4");
 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.ImageInfo", b =>
 2196                {
 2197                    b.Property<int>("Id")
 2198                        .ValueGeneratedOnAdd()
 2199                        .HasColumnType("INTEGER");
 21100
 21101                    b.Property<DateTime>("LastModified")
 21102                        .HasColumnType("TEXT");
 21103
 21104                    b.Property<string>("Path")
 21105                        .IsRequired()
 21106                        .HasColumnType("TEXT")
 21107                        .HasMaxLength(512);
 21108
 21109                    b.Property<Guid?>("UserId")
 21110                        .HasColumnType("TEXT");
 21111
 21112                    b.HasKey("Id");
 21113
 21114                    b.HasIndex("UserId")
 21115                        .IsUnique();
 21116
 21117                    b.ToTable("ImageInfos");
 21118                });
 119
 21120            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21121                {
 21122                    b.Property<int>("Id")
 21123                        .ValueGeneratedOnAdd()
 21124                        .HasColumnType("INTEGER");
 21125
 21126                    b.Property<int>("Kind")
 21127                        .HasColumnType("INTEGER");
 21128
 21129                    b.Property<Guid?>("Permission_Permissions_Guid")
 21130                        .HasColumnType("TEXT");
 21131
 21132                    b.Property<uint>("RowVersion")
 21133                        .IsConcurrencyToken()
 21134                        .HasColumnType("INTEGER");
 21135
 21136                    b.Property<bool>("Value")
 21137                        .HasColumnType("INTEGER");
 21138
 21139                    b.HasKey("Id");
 21140
 21141                    b.HasIndex("Permission_Permissions_Guid");
 21142
 21143                    b.ToTable("Permissions");
 21144                });
 145
 21146            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21147                {
 21148                    b.Property<int>("Id")
 21149                        .ValueGeneratedOnAdd()
 21150                        .HasColumnType("INTEGER");
 21151
 21152                    b.Property<int>("Kind")
 21153                        .HasColumnType("INTEGER");
 21154
 21155                    b.Property<Guid?>("Preference_Preferences_Guid")
 21156                        .HasColumnType("TEXT");
 21157
 21158                    b.Property<uint>("RowVersion")
 21159                        .IsConcurrencyToken()
 21160                        .HasColumnType("INTEGER");
 21161
 21162                    b.Property<string>("Value")
 21163                        .IsRequired()
 21164                        .HasColumnType("TEXT")
 21165                        .HasMaxLength(65535);
 21166
 21167                    b.HasKey("Id");
 21168
 21169                    b.HasIndex("Preference_Preferences_Guid");
 21170
 21171                    b.ToTable("Preferences");
 21172                });
 173
 21174            modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
 21175                {
 21176                    b.Property<Guid>("Id")
 21177                        .ValueGeneratedOnAdd()
 21178                        .HasColumnType("TEXT");
 21179
 21180                    b.Property<string>("AudioLanguagePreference")
 21181                        .HasColumnType("TEXT")
 21182                        .HasMaxLength(255);
 21183
 21184                    b.Property<string>("AuthenticationProviderId")
 21185                        .IsRequired()
 21186                        .HasColumnType("TEXT")
 21187                        .HasMaxLength(255);
 21188
 21189                    b.Property<bool>("DisplayCollectionsView")
 21190                        .HasColumnType("INTEGER");
 21191
 21192                    b.Property<bool>("DisplayMissingEpisodes")
 21193                        .HasColumnType("INTEGER");
 21194
 21195                    b.Property<string>("EasyPassword")
 21196                        .HasColumnType("TEXT")
 21197                        .HasMaxLength(65535);
 21198
 21199                    b.Property<bool>("EnableAutoLogin")
 21200                        .HasColumnType("INTEGER");
 21201
 21202                    b.Property<bool>("EnableLocalPassword")
 21203                        .HasColumnType("INTEGER");
 21204
 21205                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 21206                        .HasColumnType("INTEGER");
 21207
 21208                    b.Property<bool>("EnableUserPreferenceAccess")
 21209                        .HasColumnType("INTEGER");
 21210
 21211                    b.Property<bool>("HidePlayedInLatest")
 21212                        .HasColumnType("INTEGER");
 21213
 21214                    b.Property<long>("InternalId")
 21215                        .HasColumnType("INTEGER");
 21216
 21217                    b.Property<int>("InvalidLoginAttemptCount")
 21218                        .HasColumnType("INTEGER");
 21219
 21220                    b.Property<DateTime?>("LastActivityDate")
 21221                        .HasColumnType("TEXT");
 21222
 21223                    b.Property<DateTime?>("LastLoginDate")
 21224                        .HasColumnType("TEXT");
 21225
 21226                    b.Property<int?>("LoginAttemptsBeforeLockout")
 21227                        .HasColumnType("INTEGER");
 21228
 21229                    b.Property<int?>("MaxParentalAgeRating")
 21230                        .HasColumnType("INTEGER");
 21231
 21232                    b.Property<bool>("MustUpdatePassword")
 21233                        .HasColumnType("INTEGER");
 21234
 21235                    b.Property<string>("Password")
 21236                        .HasColumnType("TEXT")
 21237                        .HasMaxLength(65535);
 21238
 21239                    b.Property<string>("PasswordResetProviderId")
 21240                        .IsRequired()
 21241                        .HasColumnType("TEXT")
 21242                        .HasMaxLength(255);
 21243
 21244                    b.Property<bool>("PlayDefaultAudioTrack")
 21245                        .HasColumnType("INTEGER");
 21246
 21247                    b.Property<bool>("RememberAudioSelections")
 21248                        .HasColumnType("INTEGER");
 21249
 21250                    b.Property<bool>("RememberSubtitleSelections")
 21251                        .HasColumnType("INTEGER");
 21252
 21253                    b.Property<int?>("RemoteClientBitrateLimit")
 21254                        .HasColumnType("INTEGER");
 21255
 21256                    b.Property<uint>("RowVersion")
 21257                        .IsConcurrencyToken()
 21258                        .HasColumnType("INTEGER");
 21259
 21260                    b.Property<string>("SubtitleLanguagePreference")
 21261                        .HasColumnType("TEXT")
 21262                        .HasMaxLength(255);
 21263
 21264                    b.Property<int>("SubtitleMode")
 21265                        .HasColumnType("INTEGER");
 21266
 21267                    b.Property<int>("SyncPlayAccess")
 21268                        .HasColumnType("INTEGER");
 21269
 21270                    b.Property<string>("Username")
 21271                        .IsRequired()
 21272                        .HasColumnType("TEXT")
 21273                        .HasMaxLength(255);
 21274
 21275                    b.HasKey("Id");
 21276
 21277                    b.ToTable("Users");
 21278                });
 279
 21280            modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
 21281                {
 21282                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21283                        .WithMany("AccessSchedules")
 21284                        .HasForeignKey("UserId")
 21285                        .OnDelete(DeleteBehavior.Cascade)
 21286                        .IsRequired();
 21287                });
 288
 21289            modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
 21290                {
 21291                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21292                        .WithOne("ProfileImage")
 21293                        .HasForeignKey("Jellyfin.Data.Entities.ImageInfo", "UserId");
 21294                });
 295
 21296            modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
 21297                {
 21298                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21299                        .WithMany("Permissions")
 21300                        .HasForeignKey("Permission_Permissions_Guid");
 21301                });
 302
 21303            modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
 21304                {
 21305                    b.HasOne("Jellyfin.Data.Entities.User", null)
 21306                        .WithMany("Preferences")
 21307                        .HasForeignKey("Preference_Preferences_Guid");
 21308                });
 309#pragma warning restore 612, 618
 21310        }
 311    }
 312}
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)