aboutsummaryrefslogtreecommitdiff
path: root/Jellyfin.Server.Implementations/Migrations
diff options
context:
space:
mode:
authorJPVenson <6794763+JPVenson@users.noreply.github.com>2024-10-09 15:20:42 +0000
committerJPVenson <6794763+JPVenson@users.noreply.github.com>2024-10-09 15:20:42 +0000
commit01d834f21abcb65d246b18762b79001929fe845b (patch)
treebc9f61cdb7805a9968f46ab2d7aa9e28bfe2200e /Jellyfin.Server.Implementations/Migrations
parentc2844bda3b7605257d7b2f8d146077cea6dd0b08 (diff)
Fixed (most) tests
Diffstat (limited to 'Jellyfin.Server.Implementations/Migrations')
-rw-r--r--Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.Designer.cs775
-rw-r--r--Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.cs79
-rw-r--r--Jellyfin.Server.Implementations/Migrations/20241009132112_BaseItemRefactor.Designer.cs (renamed from Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.Designer.cs)41
-rw-r--r--Jellyfin.Server.Implementations/Migrations/20241009132112_BaseItemRefactor.cs (renamed from Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs)139
-rw-r--r--Jellyfin.Server.Implementations/Migrations/DesignTimeJellyfinDbFactory.cs3
-rw-r--r--Jellyfin.Server.Implementations/Migrations/JellyfinDbModelSnapshot.cs39
6 files changed, 66 insertions, 1010 deletions
diff --git a/Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.Designer.cs b/Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.Designer.cs
deleted file mode 100644
index 609faa1e60..0000000000
--- a/Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.Designer.cs
+++ /dev/null
@@ -1,775 +0,0 @@
-// <auto-generated />
-using System;
-using Jellyfin.Server.Implementations;
-using Microsoft.EntityFrameworkCore;
-using Microsoft.EntityFrameworkCore.Infrastructure;
-using Microsoft.EntityFrameworkCore.Migrations;
-using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
-
-#nullable disable
-
-namespace Jellyfin.Server.Implementations.Migrations
-{
- [DbContext(typeof(JellyfinDbContext))]
- [Migration("20240907123425_UserDataInJfLib")]
- partial class UserDataInJfLib
- {
- /// <inheritdoc />
- protected override void BuildTargetModel(ModelBuilder modelBuilder)
- {
-#pragma warning disable 612, 618
- modelBuilder.HasAnnotation("ProductVersion", "8.0.8");
-
- modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<int>("DayOfWeek")
- .HasColumnType("INTEGER");
-
- b.Property<double>("EndHour")
- .HasColumnType("REAL");
-
- b.Property<double>("StartHour")
- .HasColumnType("REAL");
-
- b.Property<Guid>("UserId")
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId");
-
- b.ToTable("AccessSchedules");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<DateTime>("DateCreated")
- .HasColumnType("TEXT");
-
- b.Property<string>("ItemId")
- .HasMaxLength(256)
- .HasColumnType("TEXT");
-
- b.Property<int>("LogSeverity")
- .HasColumnType("INTEGER");
-
- b.Property<string>("Name")
- .IsRequired()
- .HasMaxLength(512)
- .HasColumnType("TEXT");
-
- b.Property<string>("Overview")
- .HasMaxLength(512)
- .HasColumnType("TEXT");
-
- b.Property<uint>("RowVersion")
- .IsConcurrencyToken()
- .HasColumnType("INTEGER");
-
- b.Property<string>("ShortOverview")
- .HasMaxLength(512)
- .HasColumnType("TEXT");
-
- b.Property<string>("Type")
- .IsRequired()
- .HasMaxLength(256)
- .HasColumnType("TEXT");
-
- b.Property<Guid>("UserId")
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("DateCreated");
-
- b.ToTable("ActivityLogs");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<string>("Client")
- .IsRequired()
- .HasMaxLength(32)
- .HasColumnType("TEXT");
-
- b.Property<Guid>("ItemId")
- .HasColumnType("TEXT");
-
- b.Property<string>("Key")
- .IsRequired()
- .HasColumnType("TEXT");
-
- b.Property<Guid>("UserId")
- .HasColumnType("TEXT");
-
- b.Property<string>("Value")
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId", "ItemId", "Client", "Key")
- .IsUnique();
-
- b.ToTable("CustomItemDisplayPreferences");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<int>("ChromecastVersion")
- .HasColumnType("INTEGER");
-
- b.Property<string>("Client")
- .IsRequired()
- .HasMaxLength(32)
- .HasColumnType("TEXT");
-
- b.Property<string>("DashboardTheme")
- .HasMaxLength(32)
- .HasColumnType("TEXT");
-
- b.Property<bool>("EnableNextVideoInfoOverlay")
- .HasColumnType("INTEGER");
-
- b.Property<int?>("IndexBy")
- .HasColumnType("INTEGER");
-
- b.Property<Guid>("ItemId")
- .HasColumnType("TEXT");
-
- b.Property<int>("ScrollDirection")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("ShowBackdrop")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("ShowSidebar")
- .HasColumnType("INTEGER");
-
- b.Property<int>("SkipBackwardLength")
- .HasColumnType("INTEGER");
-
- b.Property<int>("SkipForwardLength")
- .HasColumnType("INTEGER");
-
- b.Property<string>("TvHome")
- .HasMaxLength(32)
- .HasColumnType("TEXT");
-
- b.Property<Guid>("UserId")
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId", "ItemId", "Client")
- .IsUnique();
-
- b.ToTable("DisplayPreferences");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<int>("DisplayPreferencesId")
- .HasColumnType("INTEGER");
-
- b.Property<int>("Order")
- .HasColumnType("INTEGER");
-
- b.Property<int>("Type")
- .HasColumnType("INTEGER");
-
- b.HasKey("Id");
-
- b.HasIndex("DisplayPreferencesId");
-
- b.ToTable("HomeSection");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<DateTime>("LastModified")
- .HasColumnType("TEXT");
-
- b.Property<string>("Path")
- .IsRequired()
- .HasMaxLength(512)
- .HasColumnType("TEXT");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId")
- .IsUnique();
-
- b.ToTable("ImageInfos");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<string>("Client")
- .IsRequired()
- .HasMaxLength(32)
- .HasColumnType("TEXT");
-
- b.Property<int?>("IndexBy")
- .HasColumnType("INTEGER");
-
- b.Property<Guid>("ItemId")
- .HasColumnType("TEXT");
-
- b.Property<bool>("RememberIndexing")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("RememberSorting")
- .HasColumnType("INTEGER");
-
- b.Property<string>("SortBy")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("TEXT");
-
- b.Property<int>("SortOrder")
- .HasColumnType("INTEGER");
-
- b.Property<Guid>("UserId")
- .HasColumnType("TEXT");
-
- b.Property<int>("ViewType")
- .HasColumnType("INTEGER");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId");
-
- b.ToTable("ItemDisplayPreferences");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.MediaSegment", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("TEXT");
-
- b.Property<long>("EndTicks")
- .HasColumnType("INTEGER");
-
- b.Property<Guid>("ItemId")
- .HasColumnType("TEXT");
-
- b.Property<string>("SegmentProviderId")
- .IsRequired()
- .HasColumnType("TEXT");
-
- b.Property<long>("StartTicks")
- .HasColumnType("INTEGER");
-
- b.Property<int>("Type")
- .HasColumnType("INTEGER");
-
- b.HasKey("Id");
-
- b.ToTable("MediaSegments");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<int>("Kind")
- .HasColumnType("INTEGER");
-
- b.Property<Guid?>("Permission_Permissions_Guid")
- .HasColumnType("TEXT");
-
- b.Property<uint>("RowVersion")
- .IsConcurrencyToken()
- .HasColumnType("INTEGER");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("TEXT");
-
- b.Property<bool>("Value")
- .HasColumnType("INTEGER");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId", "Kind")
- .IsUnique()
- .HasFilter("[UserId] IS NOT NULL");
-
- b.ToTable("Permissions");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<int>("Kind")
- .HasColumnType("INTEGER");
-
- b.Property<Guid?>("Preference_Preferences_Guid")
- .HasColumnType("TEXT");
-
- b.Property<uint>("RowVersion")
- .IsConcurrencyToken()
- .HasColumnType("INTEGER");
-
- b.Property<Guid?>("UserId")
- .HasColumnType("TEXT");
-
- b.Property<string>("Value")
- .IsRequired()
- .HasMaxLength(65535)
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("UserId", "Kind")
- .IsUnique()
- .HasFilter("[UserId] IS NOT NULL");
-
- b.ToTable("Preferences");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Security.ApiKey", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<string>("AccessToken")
- .IsRequired()
- .HasColumnType("TEXT");
-
- b.Property<DateTime>("DateCreated")
- .HasColumnType("TEXT");
-
- b.Property<DateTime>("DateLastActivity")
- .HasColumnType("TEXT");
-
- b.Property<string>("Name")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("AccessToken")
- .IsUnique();
-
- b.ToTable("ApiKeys");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<string>("AccessToken")
- .IsRequired()
- .HasColumnType("TEXT");
-
- b.Property<string>("AppName")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("TEXT");
-
- b.Property<string>("AppVersion")
- .IsRequired()
- .HasMaxLength(32)
- .HasColumnType("TEXT");
-
- b.Property<DateTime>("DateCreated")
- .HasColumnType("TEXT");
-
- b.Property<DateTime>("DateLastActivity")
- .HasColumnType("TEXT");
-
- b.Property<DateTime>("DateModified")
- .HasColumnType("TEXT");
-
- b.Property<string>("DeviceId")
- .IsRequired()
- .HasMaxLength(256)
- .HasColumnType("TEXT");
-
- b.Property<string>("DeviceName")
- .IsRequired()
- .HasMaxLength(64)
- .HasColumnType("TEXT");
-
- b.Property<bool>("IsActive")
- .HasColumnType("INTEGER");
-
- b.Property<Guid>("UserId")
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("DeviceId");
-
- b.HasIndex("AccessToken", "DateLastActivity");
-
- b.HasIndex("DeviceId", "DateLastActivity");
-
- b.HasIndex("UserId", "DeviceId");
-
- b.ToTable("Devices");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Security.DeviceOptions", b =>
- {
- b.Property<int>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("INTEGER");
-
- b.Property<string>("CustomName")
- .HasColumnType("TEXT");
-
- b.Property<string>("DeviceId")
- .IsRequired()
- .HasColumnType("TEXT");
-
- b.HasKey("Id");
-
- b.HasIndex("DeviceId")
- .IsUnique();
-
- b.ToTable("DeviceOptions");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.TrickplayInfo", b =>
- {
- b.Property<Guid>("ItemId")
- .HasColumnType("TEXT");
-
- b.Property<int>("Width")
- .HasColumnType("INTEGER");
-
- b.Property<int>("Bandwidth")
- .HasColumnType("INTEGER");
-
- b.Property<int>("Height")
- .HasColumnType("INTEGER");
-
- b.Property<int>("Interval")
- .HasColumnType("INTEGER");
-
- b.Property<int>("ThumbnailCount")
- .HasColumnType("INTEGER");
-
- b.Property<int>("TileHeight")
- .HasColumnType("INTEGER");
-
- b.Property<int>("TileWidth")
- .HasColumnType("INTEGER");
-
- b.HasKey("ItemId", "Width");
-
- b.ToTable("TrickplayInfos");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
- {
- b.Property<Guid>("Id")
- .ValueGeneratedOnAdd()
- .HasColumnType("TEXT");
-
- b.Property<string>("AudioLanguagePreference")
- .HasMaxLength(255)
- .HasColumnType("TEXT");
-
- b.Property<string>("AuthenticationProviderId")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("TEXT");
-
- b.Property<string>("CastReceiverId")
- .HasMaxLength(32)
- .HasColumnType("TEXT");
-
- b.Property<bool>("DisplayCollectionsView")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("DisplayMissingEpisodes")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("EnableAutoLogin")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("EnableLocalPassword")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("EnableNextEpisodeAutoPlay")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("EnableUserPreferenceAccess")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("HidePlayedInLatest")
- .HasColumnType("INTEGER");
-
- b.Property<long>("InternalId")
- .HasColumnType("INTEGER");
-
- b.Property<int>("InvalidLoginAttemptCount")
- .HasColumnType("INTEGER");
-
- b.Property<DateTime?>("LastActivityDate")
- .HasColumnType("TEXT");
-
- b.Property<DateTime?>("LastLoginDate")
- .HasColumnType("TEXT");
-
- b.Property<int?>("LoginAttemptsBeforeLockout")
- .HasColumnType("INTEGER");
-
- b.Property<int>("MaxActiveSessions")
- .HasColumnType("INTEGER");
-
- b.Property<int?>("MaxParentalAgeRating")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("MustUpdatePassword")
- .HasColumnType("INTEGER");
-
- b.Property<string>("Password")
- .HasMaxLength(65535)
- .HasColumnType("TEXT");
-
- b.Property<string>("PasswordResetProviderId")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("TEXT");
-
- b.Property<bool>("PlayDefaultAudioTrack")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("RememberAudioSelections")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("RememberSubtitleSelections")
- .HasColumnType("INTEGER");
-
- b.Property<int?>("RemoteClientBitrateLimit")
- .HasColumnType("INTEGER");
-
- b.Property<uint>("RowVersion")
- .IsConcurrencyToken()
- .HasColumnType("INTEGER");
-
- b.Property<string>("SubtitleLanguagePreference")
- .HasMaxLength(255)
- .HasColumnType("TEXT");
-
- b.Property<int>("SubtitleMode")
- .HasColumnType("INTEGER");
-
- b.Property<int>("SyncPlayAccess")
- .HasColumnType("INTEGER");
-
- b.Property<string>("Username")
- .IsRequired()
- .HasMaxLength(255)
- .HasColumnType("TEXT")
- .UseCollation("NOCASE");
-
- b.HasKey("Id");
-
- b.HasIndex("Username")
- .IsUnique();
-
- b.ToTable("Users");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.UserData", b =>
- {
- b.Property<int?>("AudioStreamIndex")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("IsFavorite")
- .HasColumnType("INTEGER");
-
- b.Property<string>("Key")
- .IsRequired()
- .HasColumnType("TEXT");
-
- b.Property<DateTime?>("LastPlayedDate")
- .HasColumnType("TEXT");
-
- b.Property<bool?>("Likes")
- .HasColumnType("INTEGER");
-
- b.Property<int>("PlayCount")
- .HasColumnType("INTEGER");
-
- b.Property<long>("PlaybackPositionTicks")
- .HasColumnType("INTEGER");
-
- b.Property<bool>("Played")
- .HasColumnType("INTEGER");
-
- b.Property<double?>("Rating")
- .HasColumnType("REAL");
-
- b.Property<int?>("SubtitleStreamIndex")
- .HasColumnType("INTEGER");
-
- b.Property<Guid>("UserId")
- .HasColumnType("TEXT");
-
- b.HasIndex("UserId");
-
- b.HasIndex("Key", "UserId")
- .IsUnique();
-
- b.HasIndex("Key", "UserId", "IsFavorite");
-
- b.HasIndex("Key", "UserId", "LastPlayedDate");
-
- b.HasIndex("Key", "UserId", "PlaybackPositionTicks");
-
- b.HasIndex("Key", "UserId", "Played");
-
- b.ToTable("UserData");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", null)
- .WithMany("AccessSchedules")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", null)
- .WithMany("DisplayPreferences")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.HomeSection", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.DisplayPreferences", null)
- .WithMany("HomeSections")
- .HasForeignKey("DisplayPreferencesId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.ImageInfo", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", null)
- .WithOne("ProfileImage")
- .HasForeignKey("Jellyfin.Data.Entities.ImageInfo", "UserId")
- .OnDelete(DeleteBehavior.Cascade);
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", null)
- .WithMany("ItemDisplayPreferences")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", null)
- .WithMany("Permissions")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade);
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Preference", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", null)
- .WithMany("Preferences")
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade);
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.Security.Device", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.UserData", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.User", "User")
- .WithMany()
- .HasForeignKey("UserId")
- .OnDelete(DeleteBehavior.Cascade)
- .IsRequired();
-
- b.Navigation("User");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b =>
- {
- b.Navigation("HomeSections");
- });
-
- modelBuilder.Entity("Jellyfin.Data.Entities.User", b =>
- {
- b.Navigation("AccessSchedules");
-
- b.Navigation("DisplayPreferences");
-
- b.Navigation("ItemDisplayPreferences");
-
- b.Navigation("Permissions");
-
- b.Navigation("Preferences");
-
- b.Navigation("ProfileImage");
- });
-#pragma warning restore 612, 618
- }
- }
-}
diff --git a/Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.cs b/Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.cs
deleted file mode 100644
index cb9a01f5b8..0000000000
--- a/Jellyfin.Server.Implementations/Migrations/20240907123425_UserDataInJfLib.cs
+++ /dev/null
@@ -1,79 +0,0 @@
-using System;
-using Microsoft.EntityFrameworkCore.Migrations;
-
-#nullable disable
-
-namespace Jellyfin.Server.Implementations.Migrations
-{
- /// <inheritdoc />
- public partial class UserDataInJfLib : Migration
- {
- /// <inheritdoc />
- protected override void Up(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.CreateTable(
- name: "UserData",
- columns: table => new
- {
- Key = table.Column<string>(type: "TEXT", nullable: false),
- Rating = table.Column<double>(type: "REAL", nullable: true),
- PlaybackPositionTicks = table.Column<long>(type: "INTEGER", nullable: false),
- PlayCount = table.Column<int>(type: "INTEGER", nullable: false),
- IsFavorite = table.Column<bool>(type: "INTEGER", nullable: false),
- LastPlayedDate = table.Column<DateTime>(type: "TEXT", nullable: true),
- Played = table.Column<bool>(type: "INTEGER", nullable: false),
- AudioStreamIndex = table.Column<int>(type: "INTEGER", nullable: true),
- SubtitleStreamIndex = table.Column<int>(type: "INTEGER", nullable: true),
- Likes = table.Column<bool>(type: "INTEGER", nullable: true),
- UserId = table.Column<Guid>(type: "TEXT", nullable: false)
- },
- constraints: table =>
- {
- table.ForeignKey(
- name: "FK_UserData_Users_UserId",
- column: x => x.UserId,
- principalTable: "Users",
- principalColumn: "Id",
- onDelete: ReferentialAction.Cascade);
- });
-
- migrationBuilder.CreateIndex(
- name: "IX_UserData_Key_UserId",
- table: "UserData",
- columns: new[] { "Key", "UserId" },
- unique: true);
-
- migrationBuilder.CreateIndex(
- name: "IX_UserData_Key_UserId_IsFavorite",
- table: "UserData",
- columns: new[] { "Key", "UserId", "IsFavorite" });
-
- migrationBuilder.CreateIndex(
- name: "IX_UserData_Key_UserId_LastPlayedDate",
- table: "UserData",
- columns: new[] { "Key", "UserId", "LastPlayedDate" });
-
- migrationBuilder.CreateIndex(
- name: "IX_UserData_Key_UserId_PlaybackPositionTicks",
- table: "UserData",
- columns: new[] { "Key", "UserId", "PlaybackPositionTicks" });
-
- migrationBuilder.CreateIndex(
- name: "IX_UserData_Key_UserId_Played",
- table: "UserData",
- columns: new[] { "Key", "UserId", "Played" });
-
- migrationBuilder.CreateIndex(
- name: "IX_UserData_UserId",
- table: "UserData",
- column: "UserId");
- }
-
- /// <inheritdoc />
- protected override void Down(MigrationBuilder migrationBuilder)
- {
- migrationBuilder.DropTable(
- name: "UserData");
- }
- }
-}
diff --git a/Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.Designer.cs b/Jellyfin.Server.Implementations/Migrations/20241009132112_BaseItemRefactor.Designer.cs
index b3e028298f..8e8e6c1253 100644
--- a/Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.Designer.cs
+++ b/Jellyfin.Server.Implementations/Migrations/20241009132112_BaseItemRefactor.Designer.cs
@@ -11,7 +11,7 @@ using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
namespace Jellyfin.Server.Implementations.Migrations
{
[DbContext(typeof(JellyfinDbContext))]
- [Migration("20241009112234_BaseItemRefactor")]
+ [Migration("20241009132112_BaseItemRefactor")]
partial class BaseItemRefactor
{
/// <inheritdoc />
@@ -379,10 +379,6 @@ namespace Jellyfin.Server.Implementations.Migrations
b.HasIndex("PresentationUniqueKey");
- b.HasIndex("SeasonId");
-
- b.HasIndex("SeriesId");
-
b.HasIndex("TopParentId", "Id");
b.HasIndex("UserDataKey", "Type");
@@ -1275,33 +1271,6 @@ namespace Jellyfin.Server.Implementations.Migrations
b.Navigation("Item");
});
- modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Parent")
- .WithMany("DirectChildren")
- .HasForeignKey("ParentId");
-
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Season")
- .WithMany("SeasonEpisodes")
- .HasForeignKey("SeasonId");
-
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Series")
- .WithMany("SeriesEpisodes")
- .HasForeignKey("SeriesId");
-
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "TopParent")
- .WithMany("AllChildren")
- .HasForeignKey("TopParentId");
-
- b.Navigation("Parent");
-
- b.Navigation("Season");
-
- b.Navigation("Series");
-
- b.Navigation("TopParent");
- });
-
modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b =>
{
b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
@@ -1436,14 +1405,10 @@ namespace Jellyfin.Server.Implementations.Migrations
modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b =>
{
- b.Navigation("AllChildren");
-
b.Navigation("AncestorIds");
b.Navigation("Chapters");
- b.Navigation("DirectChildren");
-
b.Navigation("ItemValues");
b.Navigation("MediaStreams");
@@ -1452,10 +1417,6 @@ namespace Jellyfin.Server.Implementations.Migrations
b.Navigation("Provider");
- b.Navigation("SeasonEpisodes");
-
- b.Navigation("SeriesEpisodes");
-
b.Navigation("UserData");
});
diff --git a/Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs b/Jellyfin.Server.Implementations/Migrations/20241009132112_BaseItemRefactor.cs
index f51e385e03..caa731c157 100644
--- a/Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs
+++ b/Jellyfin.Server.Implementations/Migrations/20241009132112_BaseItemRefactor.cs
@@ -11,21 +11,6 @@ namespace Jellyfin.Server.Implementations.Migrations
/// <inheritdoc />
protected override void Up(MigrationBuilder migrationBuilder)
{
- migrationBuilder.DropIndex(
- name: "IX_UserData_Key_UserId",
- table: "UserData");
-
- migrationBuilder.AddColumn<Guid>(
- name: "BaseItemEntityId",
- table: "UserData",
- type: "TEXT",
- nullable: true);
-
- migrationBuilder.AddPrimaryKey(
- name: "PK_UserData",
- table: "UserData",
- columns: new[] { "Key", "UserId" });
-
migrationBuilder.CreateTable(
name: "BaseItems",
columns: table => new
@@ -109,26 +94,6 @@ namespace Jellyfin.Server.Implementations.Migrations
constraints: table =>
{
table.PrimaryKey("PK_BaseItems", x => x.Id);
- table.ForeignKey(
- name: "FK_BaseItems_BaseItems_ParentId",
- column: x => x.ParentId,
- principalTable: "BaseItems",
- principalColumn: "Id");
- table.ForeignKey(
- name: "FK_BaseItems_BaseItems_SeasonId",
- column: x => x.SeasonId,
- principalTable: "BaseItems",
- principalColumn: "Id");
- table.ForeignKey(
- name: "FK_BaseItems_BaseItems_SeriesId",
- column: x => x.SeriesId,
- principalTable: "BaseItems",
- principalColumn: "Id");
- table.ForeignKey(
- name: "FK_BaseItems_BaseItems_TopParentId",
- column: x => x.TopParentId,
- principalTable: "BaseItems",
- principalColumn: "Id");
});
migrationBuilder.CreateTable(
@@ -318,10 +283,38 @@ namespace Jellyfin.Server.Implementations.Migrations
onDelete: ReferentialAction.Cascade);
});
- migrationBuilder.CreateIndex(
- name: "IX_UserData_BaseItemEntityId",
- table: "UserData",
- column: "BaseItemEntityId");
+ migrationBuilder.CreateTable(
+ name: "UserData",
+ columns: table => new
+ {
+ Key = table.Column<string>(type: "TEXT", nullable: false),
+ UserId = table.Column<Guid>(type: "TEXT", nullable: false),
+ Rating = table.Column<double>(type: "REAL", nullable: true),
+ PlaybackPositionTicks = table.Column<long>(type: "INTEGER", nullable: false),
+ PlayCount = table.Column<int>(type: "INTEGER", nullable: false),
+ IsFavorite = table.Column<bool>(type: "INTEGER", nullable: false),
+ LastPlayedDate = table.Column<DateTime>(type: "TEXT", nullable: true),
+ Played = table.Column<bool>(type: "INTEGER", nullable: false),
+ AudioStreamIndex = table.Column<int>(type: "INTEGER", nullable: true),
+ SubtitleStreamIndex = table.Column<int>(type: "INTEGER", nullable: true),
+ Likes = table.Column<bool>(type: "INTEGER", nullable: true),
+ BaseItemEntityId = table.Column<Guid>(type: "TEXT", nullable: true)
+ },
+ constraints: table =>
+ {
+ table.PrimaryKey("PK_UserData", x => new { x.Key, x.UserId });
+ table.ForeignKey(
+ name: "FK_UserData_BaseItems_BaseItemEntityId",
+ column: x => x.BaseItemEntityId,
+ principalTable: "BaseItems",
+ principalColumn: "Id");
+ table.ForeignKey(
+ name: "FK_UserData_Users_UserId",
+ column: x => x.UserId,
+ principalTable: "Users",
+ principalColumn: "Id",
+ onDelete: ReferentialAction.Cascade);
+ });
migrationBuilder.CreateIndex(
name: "IX_AncestorIds_Id",
@@ -369,16 +362,6 @@ namespace Jellyfin.Server.Implementations.Migrations
column: "PresentationUniqueKey");
migrationBuilder.CreateIndex(
- name: "IX_BaseItems_SeasonId",
- table: "BaseItems",
- column: "SeasonId");
-
- migrationBuilder.CreateIndex(
- name: "IX_BaseItems_SeriesId",
- table: "BaseItems",
- column: "SeriesId");
-
- migrationBuilder.CreateIndex(
name: "IX_BaseItems_TopParentId_Id",
table: "BaseItems",
columns: new[] { "TopParentId", "Id" });
@@ -453,21 +436,40 @@ namespace Jellyfin.Server.Implementations.Migrations
table: "Peoples",
column: "Name");
- migrationBuilder.AddForeignKey(
- name: "FK_UserData_BaseItems_BaseItemEntityId",
+ migrationBuilder.CreateIndex(
+ name: "IX_UserData_BaseItemEntityId",
+ table: "UserData",
+ column: "BaseItemEntityId");
+
+ migrationBuilder.CreateIndex(
+ name: "IX_UserData_Key_UserId_IsFavorite",
+ table: "UserData",
+ columns: new[] { "Key", "UserId", "IsFavorite" });
+
+ migrationBuilder.CreateIndex(
+ name: "IX_UserData_Key_UserId_LastPlayedDate",
+ table: "UserData",
+ columns: new[] { "Key", "UserId", "LastPlayedDate" });
+
+ migrationBuilder.CreateIndex(
+ name: "IX_UserData_Key_UserId_PlaybackPositionTicks",
table: "UserData",
- column: "BaseItemEntityId",
- principalTable: "BaseItems",
- principalColumn: "Id");
+ columns: new[] { "Key", "UserId", "PlaybackPositionTicks" });
+
+ migrationBuilder.CreateIndex(
+ name: "IX_UserData_Key_UserId_Played",
+ table: "UserData",
+ columns: new[] { "Key", "UserId", "Played" });
+
+ migrationBuilder.CreateIndex(
+ name: "IX_UserData_UserId",
+ table: "UserData",
+ column: "UserId");
}
/// <inheritdoc />
protected override void Down(MigrationBuilder migrationBuilder)
{
- migrationBuilder.DropForeignKey(
- name: "FK_UserData_BaseItems_BaseItemEntityId",
- table: "UserData");
-
migrationBuilder.DropTable(
name: "AncestorIds");
@@ -490,25 +492,10 @@ namespace Jellyfin.Server.Implementations.Migrations
name: "Peoples");
migrationBuilder.DropTable(
- name: "BaseItems");
+ name: "UserData");
- migrationBuilder.DropPrimaryKey(
- name: "PK_UserData",
- table: "UserData");
-
- migrationBuilder.DropIndex(
- name: "IX_UserData_BaseItemEntityId",
- table: "UserData");
-
- migrationBuilder.DropColumn(
- name: "BaseItemEntityId",
- table: "UserData");
-
- migrationBuilder.CreateIndex(
- name: "IX_UserData_Key_UserId",
- table: "UserData",
- columns: new[] { "Key", "UserId" },
- unique: true);
+ migrationBuilder.DropTable(
+ name: "BaseItems");
}
}
}
diff --git a/Jellyfin.Server.Implementations/Migrations/DesignTimeJellyfinDbFactory.cs b/Jellyfin.Server.Implementations/Migrations/DesignTimeJellyfinDbFactory.cs
index 940cf7c5d5..500c4a1c72 100644
--- a/Jellyfin.Server.Implementations/Migrations/DesignTimeJellyfinDbFactory.cs
+++ b/Jellyfin.Server.Implementations/Migrations/DesignTimeJellyfinDbFactory.cs
@@ -1,5 +1,6 @@
using Microsoft.EntityFrameworkCore;
using Microsoft.EntityFrameworkCore.Design;
+using Microsoft.Extensions.Logging.Abstractions;
namespace Jellyfin.Server.Implementations.Migrations
{
@@ -14,7 +15,7 @@ namespace Jellyfin.Server.Implementations.Migrations
var optionsBuilder = new DbContextOptionsBuilder<JellyfinDbContext>();
optionsBuilder.UseSqlite("Data Source=jellyfin.db");
- return new JellyfinDbContext(optionsBuilder.Options);
+ return new JellyfinDbContext(optionsBuilder.Options, NullLogger<JellyfinDbContext>.Instance);
}
}
}
diff --git a/Jellyfin.Server.Implementations/Migrations/JellyfinDbModelSnapshot.cs b/Jellyfin.Server.Implementations/Migrations/JellyfinDbModelSnapshot.cs
index f74f7d7916..dd280489b1 100644
--- a/Jellyfin.Server.Implementations/Migrations/JellyfinDbModelSnapshot.cs
+++ b/Jellyfin.Server.Implementations/Migrations/JellyfinDbModelSnapshot.cs
@@ -376,10 +376,6 @@ namespace Jellyfin.Server.Implementations.Migrations
b.HasIndex("PresentationUniqueKey");
- b.HasIndex("SeasonId");
-
- b.HasIndex("SeriesId");
-
b.HasIndex("TopParentId", "Id");
b.HasIndex("UserDataKey", "Type");
@@ -1272,33 +1268,6 @@ namespace Jellyfin.Server.Implementations.Migrations
b.Navigation("Item");
});
- modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b =>
- {
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Parent")
- .WithMany("DirectChildren")
- .HasForeignKey("ParentId");
-
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Season")
- .WithMany("SeasonEpisodes")
- .HasForeignKey("SeasonId");
-
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Series")
- .WithMany("SeriesEpisodes")
- .HasForeignKey("SeriesId");
-
- b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "TopParent")
- .WithMany("AllChildren")
- .HasForeignKey("TopParentId");
-
- b.Navigation("Parent");
-
- b.Navigation("Season");
-
- b.Navigation("Series");
-
- b.Navigation("TopParent");
- });
-
modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b =>
{
b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item")
@@ -1433,14 +1402,10 @@ namespace Jellyfin.Server.Implementations.Migrations
modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b =>
{
- b.Navigation("AllChildren");
-
b.Navigation("AncestorIds");
b.Navigation("Chapters");
- b.Navigation("DirectChildren");
-
b.Navigation("ItemValues");
b.Navigation("MediaStreams");
@@ -1449,10 +1414,6 @@ namespace Jellyfin.Server.Implementations.Migrations
b.Navigation("Provider");
- b.Navigation("SeasonEpisodes");
-
- b.Navigation("SeriesEpisodes");
-
b.Navigation("UserData");
});