diff options
12 files changed, 1 insertions, 6226 deletions
diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Jellyfin.Database.Providers.PgSql.csproj b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Jellyfin.Database.Providers.PgSql.csproj deleted file mode 100644 index 785a3c63a..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Jellyfin.Database.Providers.PgSql.csproj +++ /dev/null @@ -1,50 +0,0 @@ -<Project Sdk="Microsoft.NET.Sdk"> - - <PropertyGroup> - <TargetFramework>net9.0</TargetFramework> - <ImplicitUsings>enable</ImplicitUsings> - <Nullable>enable</Nullable> - <GenerateAssemblyInfo>false</GenerateAssemblyInfo> - <GenerateDocumentationFile>true</GenerateDocumentationFile> - </PropertyGroup> - - - <!-- Code Analyzers --> - <ItemGroup Condition=" '$(Configuration)' == 'Debug' "> - <PackageReference Include="IDisposableAnalyzers"> - <PrivateAssets>all</PrivateAssets> - <IncludeAssets>runtime; build; native; contentfiles; analyzers</IncludeAssets> - </PackageReference> - <PackageReference Include="Microsoft.CodeAnalysis.BannedApiAnalyzers"> - <PrivateAssets>all</PrivateAssets> - <IncludeAssets>runtime; build; native; contentfiles; analyzers</IncludeAssets> - </PackageReference> - <PackageReference Include="SerilogAnalyzer" PrivateAssets="All" /> - <PackageReference Include="StyleCop.Analyzers" PrivateAssets="All" /> - <PackageReference Include="SmartAnalyzers.MultithreadingAnalyzer" PrivateAssets="All" /> - </ItemGroup> - - <ItemGroup> - <Compile Include="..\..\SharedVersion.cs" /> - </ItemGroup> - - <ItemGroup> - <PackageReference Include="Npgsql.EntityFrameworkCore.PostgreSQL" /> - <PackageReference Include="Microsoft.EntityFrameworkCore.Relational" /> - <PackageReference Include="Microsoft.EntityFrameworkCore.Design"> - <PrivateAssets>all</PrivateAssets> - <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets> - </PackageReference> - <PackageReference Include="Microsoft.EntityFrameworkCore.Tools"> - <PrivateAssets>all</PrivateAssets> - <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets> - </PackageReference> - </ItemGroup> - - <ItemGroup> - <ProjectReference Include="..\..\Jellyfin.Data\Jellyfin.Data.csproj" /> - <ProjectReference Include="..\..\MediaBrowser.Controller\MediaBrowser.Controller.csproj" /> - <ProjectReference Include="..\..\MediaBrowser.Model\MediaBrowser.Model.csproj" /> - </ItemGroup> - -</Project> diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.Designer.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.Designer.cs deleted file mode 100644 index 47fff0721..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.Designer.cs +++ /dev/null @@ -1,1624 +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; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace Jellyfin.Database.Providers.PgSql.Migrations -{ - [DbContext(typeof(JellyfinDbContext))] - [Migration("20250127174201_InitMigration")] - partial class InitMigration - { - /// <inheritdoc /> - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "9.0.1") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("DayOfWeek") - .HasColumnType("integer"); - - b.Property<double>("EndHour") - .HasColumnType("double precision"); - - b.Property<double>("StartHour") - .HasColumnType("double precision"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("UserId"); - - b.ToTable("AccessSchedules"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("ItemId") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<int>("LogSeverity") - .HasColumnType("integer"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<string>("Overview") - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<string>("ShortOverview") - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<string>("Type") - .IsRequired() - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("DateCreated"); - - b.ToTable("ActivityLogs"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AncestorId", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("ParentItemId") - .HasColumnType("uuid"); - - b.HasKey("ItemId", "ParentItemId"); - - b.HasIndex("ParentItemId"); - - b.ToTable("AncestorIds"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("Index") - .HasColumnType("integer"); - - b.Property<string>("Codec") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("CodecTag") - .HasColumnType("text"); - - b.Property<string>("Comment") - .HasColumnType("text"); - - b.Property<string>("Filename") - .HasColumnType("text"); - - b.Property<string>("MimeType") - .HasColumnType("text"); - - b.HasKey("ItemId", "Index"); - - b.ToTable("AttachmentStreamInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("Album") - .HasColumnType("text"); - - b.Property<string>("AlbumArtists") - .HasColumnType("text"); - - b.Property<string>("Artists") - .HasColumnType("text"); - - b.Property<int?>("Audio") - .HasColumnType("integer"); - - b.Property<string>("ChannelId") - .HasColumnType("text"); - - b.Property<string>("CleanName") - .HasColumnType("text"); - - b.Property<float?>("CommunityRating") - .HasColumnType("real"); - - b.Property<float?>("CriticRating") - .HasColumnType("real"); - - b.Property<string>("CustomRating") - .HasColumnType("text"); - - b.Property<string>("Data") - .HasColumnType("text"); - - b.Property<DateTime?>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastMediaAdded") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastRefreshed") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastSaved") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("EndDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("EpisodeTitle") - .HasColumnType("text"); - - b.Property<string>("ExternalId") - .HasColumnType("text"); - - b.Property<string>("ExternalSeriesId") - .HasColumnType("text"); - - b.Property<string>("ExternalServiceId") - .HasColumnType("text"); - - b.Property<string>("ExtraIds") - .HasColumnType("text"); - - b.Property<int?>("ExtraType") - .HasColumnType("integer"); - - b.Property<string>("ForcedSortName") - .HasColumnType("text"); - - b.Property<string>("Genres") - .HasColumnType("text"); - - b.Property<int?>("Height") - .HasColumnType("integer"); - - b.Property<int?>("IndexNumber") - .HasColumnType("integer"); - - b.Property<int?>("InheritedParentalRatingValue") - .HasColumnType("integer"); - - b.Property<bool>("IsFolder") - .HasColumnType("boolean"); - - b.Property<bool>("IsInMixedFolder") - .HasColumnType("boolean"); - - b.Property<bool>("IsLocked") - .HasColumnType("boolean"); - - b.Property<bool>("IsMovie") - .HasColumnType("boolean"); - - b.Property<bool>("IsRepeat") - .HasColumnType("boolean"); - - b.Property<bool>("IsSeries") - .HasColumnType("boolean"); - - b.Property<bool>("IsVirtualItem") - .HasColumnType("boolean"); - - b.Property<float?>("LUFS") - .HasColumnType("real"); - - b.Property<string>("MediaType") - .HasColumnType("text"); - - b.Property<string>("Name") - .HasColumnType("text"); - - b.Property<float?>("NormalizationGain") - .HasColumnType("real"); - - b.Property<string>("OfficialRating") - .HasColumnType("text"); - - b.Property<string>("OriginalTitle") - .HasColumnType("text"); - - b.Property<string>("Overview") - .HasColumnType("text"); - - b.Property<string>("OwnerId") - .HasColumnType("text"); - - b.Property<Guid?>("ParentId") - .HasColumnType("uuid"); - - b.Property<int?>("ParentIndexNumber") - .HasColumnType("integer"); - - b.Property<string>("Path") - .HasColumnType("text"); - - b.Property<string>("PreferredMetadataCountryCode") - .HasColumnType("text"); - - b.Property<string>("PreferredMetadataLanguage") - .HasColumnType("text"); - - b.Property<DateTime?>("PremiereDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("PresentationUniqueKey") - .HasColumnType("text"); - - b.Property<string>("PrimaryVersionId") - .HasColumnType("text"); - - b.Property<string>("ProductionLocations") - .HasColumnType("text"); - - b.Property<int?>("ProductionYear") - .HasColumnType("integer"); - - b.Property<long?>("RunTimeTicks") - .HasColumnType("bigint"); - - b.Property<Guid?>("SeasonId") - .HasColumnType("uuid"); - - b.Property<string>("SeasonName") - .HasColumnType("text"); - - b.Property<Guid?>("SeriesId") - .HasColumnType("uuid"); - - b.Property<string>("SeriesName") - .HasColumnType("text"); - - b.Property<string>("SeriesPresentationUniqueKey") - .HasColumnType("text"); - - b.Property<string>("ShowId") - .HasColumnType("text"); - - b.Property<long?>("Size") - .HasColumnType("bigint"); - - b.Property<string>("SortName") - .HasColumnType("text"); - - b.Property<DateTime>("StartDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Studios") - .HasColumnType("text"); - - b.Property<string>("Tagline") - .HasColumnType("text"); - - b.Property<string>("Tags") - .HasColumnType("text"); - - b.Property<Guid?>("TopParentId") - .HasColumnType("uuid"); - - b.Property<int?>("TotalBitrate") - .HasColumnType("integer"); - - b.Property<string>("Type") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("UnratedType") - .HasColumnType("text"); - - b.Property<int?>("Width") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("ParentId"); - - b.HasIndex("Path"); - - b.HasIndex("PresentationUniqueKey"); - - b.HasIndex("TopParentId", "Id"); - - b.HasIndex("Type", "TopParentId", "Id"); - - b.HasIndex("Type", "TopParentId", "PresentationUniqueKey"); - - b.HasIndex("Type", "TopParentId", "StartDate"); - - b.HasIndex("Id", "Type", "IsFolder", "IsVirtualItem"); - - b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey"); - - b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem"); - - b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName"); - - b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated"); - - b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated"); - - b.ToTable("BaseItems"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<byte[]>("Blurhash") - .HasColumnType("bytea"); - - b.Property<DateTime>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<int>("Height") - .HasColumnType("integer"); - - b.Property<int>("ImageType") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("Path") - .IsRequired() - .HasColumnType("text"); - - b.Property<int>("Width") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemImageInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b => - { - b.Property<int>("Id") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("Id", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemMetadataFields"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("ProviderId") - .HasColumnType("text"); - - b.Property<string>("ProviderValue") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("ItemId", "ProviderId"); - - b.HasIndex("ProviderId", "ProviderValue", "ItemId"); - - b.ToTable("BaseItemProviders"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b => - { - b.Property<int>("Id") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("Id", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemTrailerTypes"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("ChapterIndex") - .HasColumnType("integer"); - - b.Property<DateTime?>("ImageDateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("ImagePath") - .HasColumnType("text"); - - b.Property<string>("Name") - .HasColumnType("text"); - - b.Property<long>("StartPositionTicks") - .HasColumnType("bigint"); - - b.HasKey("ItemId", "ChapterIndex"); - - b.ToTable("Chapters"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("Key") - .IsRequired() - .HasColumnType("text"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("ChromecastVersion") - .HasColumnType("integer"); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<string>("DashboardTheme") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<bool>("EnableNextVideoInfoOverlay") - .HasColumnType("boolean"); - - b.Property<int?>("IndexBy") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("ScrollDirection") - .HasColumnType("integer"); - - b.Property<bool>("ShowBackdrop") - .HasColumnType("boolean"); - - b.Property<bool>("ShowSidebar") - .HasColumnType("boolean"); - - b.Property<int>("SkipBackwardLength") - .HasColumnType("integer"); - - b.Property<int>("SkipForwardLength") - .HasColumnType("integer"); - - b.Property<string>("TvHome") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<DateTime>("LastModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Path") - .IsRequired() - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("UserId") - .IsUnique(); - - b.ToTable("ImageInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<int?>("IndexBy") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<bool>("RememberIndexing") - .HasColumnType("boolean"); - - b.Property<bool>("RememberSorting") - .HasColumnType("boolean"); - - b.Property<string>("SortBy") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<int>("SortOrder") - .HasColumnType("integer"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.Property<int>("ViewType") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("UserId"); - - b.ToTable("ItemDisplayPreferences"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b => - { - b.Property<Guid>("ItemValueId") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("CleanValue") - .IsRequired() - .HasColumnType("text"); - - b.Property<int>("Type") - .HasColumnType("integer"); - - b.Property<string>("Value") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("ItemValueId"); - - b.HasIndex("Type", "CleanValue") - .IsUnique(); - - b.ToTable("ItemValues"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValueMap", b => - { - b.Property<Guid>("ItemValueId") - .HasColumnType("uuid"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("ItemValueId", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("ItemValuesMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaSegment", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<long>("EndTicks") - .HasColumnType("bigint"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("SegmentProviderId") - .IsRequired() - .HasColumnType("text"); - - b.Property<long>("StartTicks") - .HasColumnType("bigint"); - - b.Property<int>("Type") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.ToTable("MediaSegments"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("StreamIndex") - .HasColumnType("integer"); - - b.Property<string>("AspectRatio") - .HasColumnType("text"); - - b.Property<float?>("AverageFrameRate") - .HasColumnType("real"); - - b.Property<int?>("BitDepth") - .HasColumnType("integer"); - - b.Property<int?>("BitRate") - .HasColumnType("integer"); - - b.Property<int?>("BlPresentFlag") - .HasColumnType("integer"); - - b.Property<string>("ChannelLayout") - .HasColumnType("text"); - - b.Property<int?>("Channels") - .HasColumnType("integer"); - - b.Property<string>("Codec") - .HasColumnType("text"); - - b.Property<string>("CodecTag") - .HasColumnType("text"); - - b.Property<string>("CodecTimeBase") - .HasColumnType("text"); - - b.Property<string>("ColorPrimaries") - .HasColumnType("text"); - - b.Property<string>("ColorSpace") - .HasColumnType("text"); - - b.Property<string>("ColorTransfer") - .HasColumnType("text"); - - b.Property<string>("Comment") - .HasColumnType("text"); - - b.Property<int?>("DvBlSignalCompatibilityId") - .HasColumnType("integer"); - - b.Property<int?>("DvLevel") - .HasColumnType("integer"); - - b.Property<int?>("DvProfile") - .HasColumnType("integer"); - - b.Property<int?>("DvVersionMajor") - .HasColumnType("integer"); - - b.Property<int?>("DvVersionMinor") - .HasColumnType("integer"); - - b.Property<int?>("ElPresentFlag") - .HasColumnType("integer"); - - b.Property<int?>("Height") - .HasColumnType("integer"); - - b.Property<bool?>("IsAnamorphic") - .HasColumnType("boolean"); - - b.Property<bool?>("IsAvc") - .HasColumnType("boolean"); - - b.Property<bool>("IsDefault") - .HasColumnType("boolean"); - - b.Property<bool>("IsExternal") - .HasColumnType("boolean"); - - b.Property<bool>("IsForced") - .HasColumnType("boolean"); - - b.Property<bool?>("IsHearingImpaired") - .HasColumnType("boolean"); - - b.Property<bool?>("IsInterlaced") - .HasColumnType("boolean"); - - b.Property<string>("KeyFrames") - .HasColumnType("text"); - - b.Property<string>("Language") - .HasColumnType("text"); - - b.Property<float?>("Level") - .HasColumnType("real"); - - b.Property<string>("NalLengthSize") - .HasColumnType("text"); - - b.Property<string>("Path") - .HasColumnType("text"); - - b.Property<string>("PixelFormat") - .HasColumnType("text"); - - b.Property<string>("Profile") - .HasColumnType("text"); - - b.Property<float?>("RealFrameRate") - .HasColumnType("real"); - - b.Property<int?>("RefFrames") - .HasColumnType("integer"); - - b.Property<int?>("Rotation") - .HasColumnType("integer"); - - b.Property<int?>("RpuPresentFlag") - .HasColumnType("integer"); - - b.Property<int?>("SampleRate") - .HasColumnType("integer"); - - b.Property<int>("StreamType") - .HasColumnType("integer"); - - b.Property<string>("TimeBase") - .HasColumnType("text"); - - b.Property<string>("Title") - .HasColumnType("text"); - - b.Property<int?>("Width") - .HasColumnType("integer"); - - b.HasKey("ItemId", "StreamIndex"); - - b.HasIndex("StreamIndex"); - - b.HasIndex("StreamType"); - - b.HasIndex("StreamIndex", "StreamType"); - - b.HasIndex("StreamIndex", "StreamType", "Language"); - - b.ToTable("MediaStreamInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.People", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("PersonType") - .HasColumnType("text"); - - b.HasKey("Id"); - - b.HasIndex("Name"); - - b.ToTable("Peoples"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("PeopleId") - .HasColumnType("uuid"); - - b.Property<int?>("ListOrder") - .HasColumnType("integer"); - - b.Property<string>("Role") - .HasColumnType("text"); - - b.Property<int?>("SortOrder") - .HasColumnType("integer"); - - b.HasKey("ItemId", "PeopleId"); - - b.HasIndex("PeopleId"); - - b.HasIndex("ItemId", "ListOrder"); - - b.HasIndex("ItemId", "SortOrder"); - - b.ToTable("PeopleBaseItemMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("Kind") - .HasColumnType("integer"); - - b.Property<Guid?>("Permission_Permissions_Guid") - .HasColumnType("uuid"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.Property<bool>("Value") - .HasColumnType("boolean"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("Kind") - .HasColumnType("integer"); - - b.Property<Guid?>("Preference_Preferences_Guid") - .HasColumnType("uuid"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.Property<string>("Value") - .IsRequired() - .HasMaxLength(65535) - .HasColumnType("character varying(65535)"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("AccessToken") - .IsRequired() - .HasColumnType("text"); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateLastActivity") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("AccessToken") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("AppName") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<string>("AppVersion") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateLastActivity") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("DeviceId") - .IsRequired() - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<string>("DeviceName") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<bool>("IsActive") - .HasColumnType("boolean"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - 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("uuid"); - - 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("uuid"); - - b.Property<string>("AudioLanguagePreference") - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("AuthenticationProviderId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("CastReceiverId") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<bool>("DisplayCollectionsView") - .HasColumnType("boolean"); - - b.Property<bool>("DisplayMissingEpisodes") - .HasColumnType("boolean"); - - b.Property<bool>("EnableAutoLogin") - .HasColumnType("boolean"); - - b.Property<bool>("EnableLocalPassword") - .HasColumnType("boolean"); - - b.Property<bool>("EnableNextEpisodeAutoPlay") - .HasColumnType("boolean"); - - b.Property<bool>("EnableUserPreferenceAccess") - .HasColumnType("boolean"); - - b.Property<bool>("HidePlayedInLatest") - .HasColumnType("boolean"); - - b.Property<long>("InternalId") - .HasColumnType("bigint"); - - b.Property<int>("InvalidLoginAttemptCount") - .HasColumnType("integer"); - - b.Property<DateTime?>("LastActivityDate") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("LastLoginDate") - .HasColumnType("timestamp with time zone"); - - b.Property<int?>("LoginAttemptsBeforeLockout") - .HasColumnType("integer"); - - b.Property<int>("MaxActiveSessions") - .HasColumnType("integer"); - - b.Property<int?>("MaxParentalAgeRating") - .HasColumnType("integer"); - - b.Property<bool>("MustUpdatePassword") - .HasColumnType("boolean"); - - b.Property<string>("Password") - .HasMaxLength(65535) - .HasColumnType("character varying(65535)"); - - b.Property<string>("PasswordResetProviderId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<bool>("PlayDefaultAudioTrack") - .HasColumnType("boolean"); - - b.Property<bool>("RememberAudioSelections") - .HasColumnType("boolean"); - - b.Property<bool>("RememberSubtitleSelections") - .HasColumnType("boolean"); - - b.Property<int?>("RemoteClientBitrateLimit") - .HasColumnType("integer"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<string>("SubtitleLanguagePreference") - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<int>("SubtitleMode") - .HasColumnType("integer"); - - b.Property<int>("SyncPlayAccess") - .HasColumnType("integer"); - - b.Property<string>("Username") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)") - .UseCollation("NOCASE"); - - b.HasKey("Id"); - - b.HasIndex("Username") - .IsUnique(); - - b.ToTable("Users"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.UserData", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.Property<string>("CustomDataKey") - .HasColumnType("text"); - - b.Property<int?>("AudioStreamIndex") - .HasColumnType("integer"); - - b.Property<bool>("IsFavorite") - .HasColumnType("boolean"); - - b.Property<DateTime?>("LastPlayedDate") - .HasColumnType("timestamp with time zone"); - - b.Property<bool?>("Likes") - .HasColumnType("boolean"); - - b.Property<int>("PlayCount") - .HasColumnType("integer"); - - b.Property<long>("PlaybackPositionTicks") - .HasColumnType("bigint"); - - b.Property<bool>("Played") - .HasColumnType("boolean"); - - b.Property<double?>("Rating") - .HasColumnType("double precision"); - - b.Property<int?>("SubtitleStreamIndex") - .HasColumnType("integer"); - - b.HasKey("ItemId", "UserId", "CustomDataKey"); - - b.HasIndex("UserId"); - - b.HasIndex("ItemId", "UserId", "IsFavorite"); - - b.HasIndex("ItemId", "UserId", "LastPlayedDate"); - - b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks"); - - b.HasIndex("ItemId", "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.AncestorId", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Children") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "ParentItem") - .WithMany("ParentAncestors") - .HasForeignKey("ParentItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("ParentItem"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany() - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Images") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("LockedFields") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Provider") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("TrailerTypes") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Chapters") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - 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.ItemValueMap", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("ItemValues") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.ItemValue", "ItemValue") - .WithMany("BaseItemsMap") - .HasForeignKey("ItemValueId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("ItemValue"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("MediaStreams") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Peoples") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.People", "People") - .WithMany("BaseItems") - .HasForeignKey("PeopleId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("People"); - }); - - 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.BaseItemEntity", "Item") - .WithMany("UserData") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.User", "User") - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("User"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b => - { - b.Navigation("Chapters"); - - b.Navigation("Children"); - - b.Navigation("Images"); - - b.Navigation("ItemValues"); - - b.Navigation("LockedFields"); - - b.Navigation("MediaStreams"); - - b.Navigation("ParentAncestors"); - - b.Navigation("Peoples"); - - b.Navigation("Provider"); - - b.Navigation("TrailerTypes"); - - b.Navigation("UserData"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b => - { - b.Navigation("HomeSections"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b => - { - b.Navigation("BaseItemsMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.People", b => - { - b.Navigation("BaseItems"); - }); - - 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.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs deleted file mode 100644 index ad1d28b13..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250127174201_InitMigration.cs +++ /dev/null @@ -1,1106 +0,0 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace Jellyfin.Database.Providers.PgSql.Migrations -{ - /// <inheritdoc /> - public partial class InitMigration : Migration - { - /// <inheritdoc /> - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.CreateTable( - name: "ActivityLogs", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - Name = table.Column<string>(type: "character varying(512)", maxLength: 512, nullable: false), - Overview = table.Column<string>(type: "character varying(512)", maxLength: 512, nullable: true), - ShortOverview = table.Column<string>(type: "character varying(512)", maxLength: 512, nullable: true), - Type = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: false), - UserId = table.Column<Guid>(type: "uuid", nullable: false), - ItemId = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: true), - DateCreated = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - LogSeverity = table.Column<int>(type: "integer", nullable: false), - RowVersion = table.Column<long>(type: "bigint", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_ActivityLogs", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "ApiKeys", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - DateCreated = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - DateLastActivity = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - Name = table.Column<string>(type: "character varying(64)", maxLength: 64, nullable: false), - AccessToken = table.Column<string>(type: "text", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_ApiKeys", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "BaseItems", - columns: table => new - { - Id = table.Column<Guid>(type: "uuid", nullable: false), - Type = table.Column<string>(type: "text", nullable: false), - Data = table.Column<string>(type: "text", nullable: true), - Path = table.Column<string>(type: "text", nullable: true), - StartDate = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - EndDate = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - ChannelId = table.Column<string>(type: "text", nullable: true), - IsMovie = table.Column<bool>(type: "boolean", nullable: false), - CommunityRating = table.Column<float>(type: "real", nullable: true), - CustomRating = table.Column<string>(type: "text", nullable: true), - IndexNumber = table.Column<int>(type: "integer", nullable: true), - IsLocked = table.Column<bool>(type: "boolean", nullable: false), - Name = table.Column<string>(type: "text", nullable: true), - OfficialRating = table.Column<string>(type: "text", nullable: true), - MediaType = table.Column<string>(type: "text", nullable: true), - Overview = table.Column<string>(type: "text", nullable: true), - ParentIndexNumber = table.Column<int>(type: "integer", nullable: true), - PremiereDate = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - ProductionYear = table.Column<int>(type: "integer", nullable: true), - Genres = table.Column<string>(type: "text", nullable: true), - SortName = table.Column<string>(type: "text", nullable: true), - ForcedSortName = table.Column<string>(type: "text", nullable: true), - RunTimeTicks = table.Column<long>(type: "bigint", nullable: true), - DateCreated = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - DateModified = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - IsSeries = table.Column<bool>(type: "boolean", nullable: false), - EpisodeTitle = table.Column<string>(type: "text", nullable: true), - IsRepeat = table.Column<bool>(type: "boolean", nullable: false), - PreferredMetadataLanguage = table.Column<string>(type: "text", nullable: true), - PreferredMetadataCountryCode = table.Column<string>(type: "text", nullable: true), - DateLastRefreshed = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - DateLastSaved = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - IsInMixedFolder = table.Column<bool>(type: "boolean", nullable: false), - Studios = table.Column<string>(type: "text", nullable: true), - ExternalServiceId = table.Column<string>(type: "text", nullable: true), - Tags = table.Column<string>(type: "text", nullable: true), - IsFolder = table.Column<bool>(type: "boolean", nullable: false), - InheritedParentalRatingValue = table.Column<int>(type: "integer", nullable: true), - UnratedType = table.Column<string>(type: "text", nullable: true), - CriticRating = table.Column<float>(type: "real", nullable: true), - CleanName = table.Column<string>(type: "text", nullable: true), - PresentationUniqueKey = table.Column<string>(type: "text", nullable: true), - OriginalTitle = table.Column<string>(type: "text", nullable: true), - PrimaryVersionId = table.Column<string>(type: "text", nullable: true), - DateLastMediaAdded = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - Album = table.Column<string>(type: "text", nullable: true), - LUFS = table.Column<float>(type: "real", nullable: true), - NormalizationGain = table.Column<float>(type: "real", nullable: true), - IsVirtualItem = table.Column<bool>(type: "boolean", nullable: false), - SeriesName = table.Column<string>(type: "text", nullable: true), - SeasonName = table.Column<string>(type: "text", nullable: true), - ExternalSeriesId = table.Column<string>(type: "text", nullable: true), - Tagline = table.Column<string>(type: "text", nullable: true), - ProductionLocations = table.Column<string>(type: "text", nullable: true), - ExtraIds = table.Column<string>(type: "text", nullable: true), - TotalBitrate = table.Column<int>(type: "integer", nullable: true), - ExtraType = table.Column<int>(type: "integer", nullable: true), - Artists = table.Column<string>(type: "text", nullable: true), - AlbumArtists = table.Column<string>(type: "text", nullable: true), - ExternalId = table.Column<string>(type: "text", nullable: true), - SeriesPresentationUniqueKey = table.Column<string>(type: "text", nullable: true), - ShowId = table.Column<string>(type: "text", nullable: true), - OwnerId = table.Column<string>(type: "text", nullable: true), - Width = table.Column<int>(type: "integer", nullable: true), - Height = table.Column<int>(type: "integer", nullable: true), - Size = table.Column<long>(type: "bigint", nullable: true), - Audio = table.Column<int>(type: "integer", nullable: true), - ParentId = table.Column<Guid>(type: "uuid", nullable: true), - TopParentId = table.Column<Guid>(type: "uuid", nullable: true), - SeasonId = table.Column<Guid>(type: "uuid", nullable: true), - SeriesId = table.Column<Guid>(type: "uuid", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_BaseItems", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "CustomItemDisplayPreferences", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - Client = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - Key = table.Column<string>(type: "text", nullable: false), - Value = table.Column<string>(type: "text", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_CustomItemDisplayPreferences", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "DeviceOptions", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - DeviceId = table.Column<string>(type: "text", nullable: false), - CustomName = table.Column<string>(type: "text", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_DeviceOptions", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "ItemValues", - columns: table => new - { - ItemValueId = table.Column<Guid>(type: "uuid", nullable: false), - Type = table.Column<int>(type: "integer", nullable: false), - Value = table.Column<string>(type: "text", nullable: false), - CleanValue = table.Column<string>(type: "text", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_ItemValues", x => x.ItemValueId); - }); - - migrationBuilder.CreateTable( - name: "MediaSegments", - columns: table => new - { - Id = table.Column<Guid>(type: "uuid", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - Type = table.Column<int>(type: "integer", nullable: false), - EndTicks = table.Column<long>(type: "bigint", nullable: false), - StartTicks = table.Column<long>(type: "bigint", nullable: false), - SegmentProviderId = table.Column<string>(type: "text", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_MediaSegments", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "Peoples", - columns: table => new - { - Id = table.Column<Guid>(type: "uuid", nullable: false), - Name = table.Column<string>(type: "text", nullable: false), - PersonType = table.Column<string>(type: "text", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_Peoples", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "TrickplayInfos", - columns: table => new - { - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - Width = table.Column<int>(type: "integer", nullable: false), - Height = table.Column<int>(type: "integer", nullable: false), - TileWidth = table.Column<int>(type: "integer", nullable: false), - TileHeight = table.Column<int>(type: "integer", nullable: false), - ThumbnailCount = table.Column<int>(type: "integer", nullable: false), - Interval = table.Column<int>(type: "integer", nullable: false), - Bandwidth = table.Column<int>(type: "integer", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_TrickplayInfos", x => new { x.ItemId, x.Width }); - }); - - migrationBuilder.CreateTable( - name: "Users", - columns: table => new - { - Id = table.Column<Guid>(type: "uuid", nullable: false), - Username = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - Password = table.Column<string>(type: "character varying(65535)", maxLength: 65535, nullable: true), - MustUpdatePassword = table.Column<bool>(type: "boolean", nullable: false), - AudioLanguagePreference = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - AuthenticationProviderId = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - PasswordResetProviderId = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: false), - InvalidLoginAttemptCount = table.Column<int>(type: "integer", nullable: false), - LastActivityDate = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - LastLoginDate = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - LoginAttemptsBeforeLockout = table.Column<int>(type: "integer", nullable: true), - MaxActiveSessions = table.Column<int>(type: "integer", nullable: false), - SubtitleMode = table.Column<int>(type: "integer", nullable: false), - PlayDefaultAudioTrack = table.Column<bool>(type: "boolean", nullable: false), - SubtitleLanguagePreference = table.Column<string>(type: "character varying(255)", maxLength: 255, nullable: true), - DisplayMissingEpisodes = table.Column<bool>(type: "boolean", nullable: false), - DisplayCollectionsView = table.Column<bool>(type: "boolean", nullable: false), - EnableLocalPassword = table.Column<bool>(type: "boolean", nullable: false), - HidePlayedInLatest = table.Column<bool>(type: "boolean", nullable: false), - RememberAudioSelections = table.Column<bool>(type: "boolean", nullable: false), - RememberSubtitleSelections = table.Column<bool>(type: "boolean", nullable: false), - EnableNextEpisodeAutoPlay = table.Column<bool>(type: "boolean", nullable: false), - EnableAutoLogin = table.Column<bool>(type: "boolean", nullable: false), - EnableUserPreferenceAccess = table.Column<bool>(type: "boolean", nullable: false), - MaxParentalAgeRating = table.Column<int>(type: "integer", nullable: true), - RemoteClientBitrateLimit = table.Column<int>(type: "integer", nullable: true), - InternalId = table.Column<long>(type: "bigint", nullable: false), - SyncPlayAccess = table.Column<int>(type: "integer", nullable: false), - CastReceiverId = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: true), - RowVersion = table.Column<long>(type: "bigint", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_Users", x => x.Id); - }); - - migrationBuilder.CreateTable( - name: "AncestorIds", - columns: table => new - { - ParentItemId = table.Column<Guid>(type: "uuid", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_AncestorIds", x => new { x.ItemId, x.ParentItemId }); - table.ForeignKey( - name: "FK_AncestorIds_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_AncestorIds_BaseItems_ParentItemId", - column: x => x.ParentItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "AttachmentStreamInfos", - columns: table => new - { - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - Index = table.Column<int>(type: "integer", nullable: false), - Codec = table.Column<string>(type: "text", nullable: false), - CodecTag = table.Column<string>(type: "text", nullable: true), - Comment = table.Column<string>(type: "text", nullable: true), - Filename = table.Column<string>(type: "text", nullable: true), - MimeType = table.Column<string>(type: "text", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_AttachmentStreamInfos", x => new { x.ItemId, x.Index }); - table.ForeignKey( - name: "FK_AttachmentStreamInfos_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "BaseItemImageInfos", - columns: table => new - { - Id = table.Column<Guid>(type: "uuid", nullable: false), - Path = table.Column<string>(type: "text", nullable: false), - DateModified = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - ImageType = table.Column<int>(type: "integer", nullable: false), - Width = table.Column<int>(type: "integer", nullable: false), - Height = table.Column<int>(type: "integer", nullable: false), - Blurhash = table.Column<byte[]>(type: "bytea", nullable: true), - ItemId = table.Column<Guid>(type: "uuid", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_BaseItemImageInfos", x => x.Id); - table.ForeignKey( - name: "FK_BaseItemImageInfos_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "BaseItemMetadataFields", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_BaseItemMetadataFields", x => new { x.Id, x.ItemId }); - table.ForeignKey( - name: "FK_BaseItemMetadataFields_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "BaseItemProviders", - columns: table => new - { - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - ProviderId = table.Column<string>(type: "text", nullable: false), - ProviderValue = table.Column<string>(type: "text", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_BaseItemProviders", x => new { x.ItemId, x.ProviderId }); - table.ForeignKey( - name: "FK_BaseItemProviders_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "BaseItemTrailerTypes", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_BaseItemTrailerTypes", x => new { x.Id, x.ItemId }); - table.ForeignKey( - name: "FK_BaseItemTrailerTypes_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "Chapters", - columns: table => new - { - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - ChapterIndex = table.Column<int>(type: "integer", nullable: false), - StartPositionTicks = table.Column<long>(type: "bigint", nullable: false), - Name = table.Column<string>(type: "text", nullable: true), - ImagePath = table.Column<string>(type: "text", nullable: true), - ImageDateModified = table.Column<DateTime>(type: "timestamp with time zone", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_Chapters", x => new { x.ItemId, x.ChapterIndex }); - table.ForeignKey( - name: "FK_Chapters_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "MediaStreamInfos", - columns: table => new - { - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - StreamIndex = table.Column<int>(type: "integer", nullable: false), - StreamType = table.Column<int>(type: "integer", nullable: false), - Codec = table.Column<string>(type: "text", nullable: true), - Language = table.Column<string>(type: "text", nullable: true), - ChannelLayout = table.Column<string>(type: "text", nullable: true), - Profile = table.Column<string>(type: "text", nullable: true), - AspectRatio = table.Column<string>(type: "text", nullable: true), - Path = table.Column<string>(type: "text", nullable: true), - IsInterlaced = table.Column<bool>(type: "boolean", nullable: true), - BitRate = table.Column<int>(type: "integer", nullable: true), - Channels = table.Column<int>(type: "integer", nullable: true), - SampleRate = table.Column<int>(type: "integer", nullable: true), - IsDefault = table.Column<bool>(type: "boolean", nullable: false), - IsForced = table.Column<bool>(type: "boolean", nullable: false), - IsExternal = table.Column<bool>(type: "boolean", nullable: false), - Height = table.Column<int>(type: "integer", nullable: true), - Width = table.Column<int>(type: "integer", nullable: true), - AverageFrameRate = table.Column<float>(type: "real", nullable: true), - RealFrameRate = table.Column<float>(type: "real", nullable: true), - Level = table.Column<float>(type: "real", nullable: true), - PixelFormat = table.Column<string>(type: "text", nullable: true), - BitDepth = table.Column<int>(type: "integer", nullable: true), - IsAnamorphic = table.Column<bool>(type: "boolean", nullable: true), - RefFrames = table.Column<int>(type: "integer", nullable: true), - CodecTag = table.Column<string>(type: "text", nullable: true), - Comment = table.Column<string>(type: "text", nullable: true), - NalLengthSize = table.Column<string>(type: "text", nullable: true), - IsAvc = table.Column<bool>(type: "boolean", nullable: true), - Title = table.Column<string>(type: "text", nullable: true), - TimeBase = table.Column<string>(type: "text", nullable: true), - CodecTimeBase = table.Column<string>(type: "text", nullable: true), - ColorPrimaries = table.Column<string>(type: "text", nullable: true), - ColorSpace = table.Column<string>(type: "text", nullable: true), - ColorTransfer = table.Column<string>(type: "text", nullable: true), - DvVersionMajor = table.Column<int>(type: "integer", nullable: true), - DvVersionMinor = table.Column<int>(type: "integer", nullable: true), - DvProfile = table.Column<int>(type: "integer", nullable: true), - DvLevel = table.Column<int>(type: "integer", nullable: true), - RpuPresentFlag = table.Column<int>(type: "integer", nullable: true), - ElPresentFlag = table.Column<int>(type: "integer", nullable: true), - BlPresentFlag = table.Column<int>(type: "integer", nullable: true), - DvBlSignalCompatibilityId = table.Column<int>(type: "integer", nullable: true), - IsHearingImpaired = table.Column<bool>(type: "boolean", nullable: true), - Rotation = table.Column<int>(type: "integer", nullable: true), - KeyFrames = table.Column<string>(type: "text", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_MediaStreamInfos", x => new { x.ItemId, x.StreamIndex }); - table.ForeignKey( - name: "FK_MediaStreamInfos_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "ItemValuesMap", - columns: table => new - { - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - ItemValueId = table.Column<Guid>(type: "uuid", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_ItemValuesMap", x => new { x.ItemValueId, x.ItemId }); - table.ForeignKey( - name: "FK_ItemValuesMap_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_ItemValuesMap_ItemValues_ItemValueId", - column: x => x.ItemValueId, - principalTable: "ItemValues", - principalColumn: "ItemValueId", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "PeopleBaseItemMap", - columns: table => new - { - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - PeopleId = table.Column<Guid>(type: "uuid", nullable: false), - SortOrder = table.Column<int>(type: "integer", nullable: true), - ListOrder = table.Column<int>(type: "integer", nullable: true), - Role = table.Column<string>(type: "text", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_PeopleBaseItemMap", x => new { x.ItemId, x.PeopleId }); - table.ForeignKey( - name: "FK_PeopleBaseItemMap_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_PeopleBaseItemMap_Peoples_PeopleId", - column: x => x.PeopleId, - principalTable: "Peoples", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "AccessSchedules", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: false), - DayOfWeek = table.Column<int>(type: "integer", nullable: false), - StartHour = table.Column<double>(type: "double precision", nullable: false), - EndHour = table.Column<double>(type: "double precision", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_AccessSchedules", x => x.Id); - table.ForeignKey( - name: "FK_AccessSchedules_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "Devices", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: false), - AccessToken = table.Column<string>(type: "text", nullable: false), - AppName = table.Column<string>(type: "character varying(64)", maxLength: 64, nullable: false), - AppVersion = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - DeviceName = table.Column<string>(type: "character varying(64)", maxLength: 64, nullable: false), - DeviceId = table.Column<string>(type: "character varying(256)", maxLength: 256, nullable: false), - IsActive = table.Column<bool>(type: "boolean", nullable: false), - DateCreated = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - DateModified = table.Column<DateTime>(type: "timestamp with time zone", nullable: false), - DateLastActivity = table.Column<DateTime>(type: "timestamp with time zone", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_Devices", x => x.Id); - table.ForeignKey( - name: "FK_Devices_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "DisplayPreferences", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - Client = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - ShowSidebar = table.Column<bool>(type: "boolean", nullable: false), - ShowBackdrop = table.Column<bool>(type: "boolean", nullable: false), - ScrollDirection = table.Column<int>(type: "integer", nullable: false), - IndexBy = table.Column<int>(type: "integer", nullable: true), - SkipForwardLength = table.Column<int>(type: "integer", nullable: false), - SkipBackwardLength = table.Column<int>(type: "integer", nullable: false), - ChromecastVersion = table.Column<int>(type: "integer", nullable: false), - EnableNextVideoInfoOverlay = table.Column<bool>(type: "boolean", nullable: false), - DashboardTheme = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: true), - TvHome = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_DisplayPreferences", x => x.Id); - table.ForeignKey( - name: "FK_DisplayPreferences_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "ImageInfos", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: true), - Path = table.Column<string>(type: "character varying(512)", maxLength: 512, nullable: false), - LastModified = table.Column<DateTime>(type: "timestamp with time zone", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_ImageInfos", x => x.Id); - table.ForeignKey( - name: "FK_ImageInfos_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "ItemDisplayPreferences", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - Client = table.Column<string>(type: "character varying(32)", maxLength: 32, nullable: false), - ViewType = table.Column<int>(type: "integer", nullable: false), - RememberIndexing = table.Column<bool>(type: "boolean", nullable: false), - IndexBy = table.Column<int>(type: "integer", nullable: true), - RememberSorting = table.Column<bool>(type: "boolean", nullable: false), - SortBy = table.Column<string>(type: "character varying(64)", maxLength: 64, nullable: false), - SortOrder = table.Column<int>(type: "integer", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_ItemDisplayPreferences", x => x.Id); - table.ForeignKey( - name: "FK_ItemDisplayPreferences_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "Permissions", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: true), - Kind = table.Column<int>(type: "integer", nullable: false), - Value = table.Column<bool>(type: "boolean", nullable: false), - RowVersion = table.Column<long>(type: "bigint", nullable: false), - Permission_Permissions_Guid = table.Column<Guid>(type: "uuid", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_Permissions", x => x.Id); - table.ForeignKey( - name: "FK_Permissions_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "Preferences", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - UserId = table.Column<Guid>(type: "uuid", nullable: true), - Kind = table.Column<int>(type: "integer", nullable: false), - Value = table.Column<string>(type: "character varying(65535)", maxLength: 65535, nullable: false), - RowVersion = table.Column<long>(type: "bigint", nullable: false), - Preference_Preferences_Guid = table.Column<Guid>(type: "uuid", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_Preferences", x => x.Id); - table.ForeignKey( - name: "FK_Preferences_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "UserData", - columns: table => new - { - CustomDataKey = table.Column<string>(type: "text", nullable: false), - ItemId = table.Column<Guid>(type: "uuid", nullable: false), - UserId = table.Column<Guid>(type: "uuid", nullable: false), - Rating = table.Column<double>(type: "double precision", nullable: true), - PlaybackPositionTicks = table.Column<long>(type: "bigint", nullable: false), - PlayCount = table.Column<int>(type: "integer", nullable: false), - IsFavorite = table.Column<bool>(type: "boolean", nullable: false), - LastPlayedDate = table.Column<DateTime>(type: "timestamp with time zone", nullable: true), - Played = table.Column<bool>(type: "boolean", nullable: false), - AudioStreamIndex = table.Column<int>(type: "integer", nullable: true), - SubtitleStreamIndex = table.Column<int>(type: "integer", nullable: true), - Likes = table.Column<bool>(type: "boolean", nullable: true) - }, - constraints: table => - { - table.PrimaryKey("PK_UserData", x => new { x.ItemId, x.UserId, x.CustomDataKey }); - table.ForeignKey( - name: "FK_UserData_BaseItems_ItemId", - column: x => x.ItemId, - principalTable: "BaseItems", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - table.ForeignKey( - name: "FK_UserData_Users_UserId", - column: x => x.UserId, - principalTable: "Users", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateTable( - name: "HomeSection", - columns: table => new - { - Id = table.Column<int>(type: "integer", nullable: false) - .Annotation("Npgsql:ValueGenerationStrategy", NpgsqlValueGenerationStrategy.IdentityByDefaultColumn), - DisplayPreferencesId = table.Column<int>(type: "integer", nullable: false), - Order = table.Column<int>(type: "integer", nullable: false), - Type = table.Column<int>(type: "integer", nullable: false) - }, - constraints: table => - { - table.PrimaryKey("PK_HomeSection", x => x.Id); - table.ForeignKey( - name: "FK_HomeSection_DisplayPreferences_DisplayPreferencesId", - column: x => x.DisplayPreferencesId, - principalTable: "DisplayPreferences", - principalColumn: "Id", - onDelete: ReferentialAction.Cascade); - }); - - migrationBuilder.CreateIndex( - name: "IX_AccessSchedules_UserId", - table: "AccessSchedules", - column: "UserId"); - - migrationBuilder.CreateIndex( - name: "IX_ActivityLogs_DateCreated", - table: "ActivityLogs", - column: "DateCreated"); - - migrationBuilder.CreateIndex( - name: "IX_AncestorIds_ParentItemId", - table: "AncestorIds", - column: "ParentItemId"); - - migrationBuilder.CreateIndex( - name: "IX_ApiKeys_AccessToken", - table: "ApiKeys", - column: "AccessToken", - unique: true); - - migrationBuilder.CreateIndex( - name: "IX_BaseItemImageInfos_ItemId", - table: "BaseItemImageInfos", - column: "ItemId"); - - migrationBuilder.CreateIndex( - name: "IX_BaseItemMetadataFields_ItemId", - table: "BaseItemMetadataFields", - column: "ItemId"); - - migrationBuilder.CreateIndex( - name: "IX_BaseItemProviders_ProviderId_ProviderValue_ItemId", - table: "BaseItemProviders", - columns: new[] { "ProviderId", "ProviderValue", "ItemId" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Id_Type_IsFolder_IsVirtualItem", - table: "BaseItems", - columns: new[] { "Id", "Type", "IsFolder", "IsVirtualItem" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_IsFolder_TopParentId_IsVirtualItem_PresentationUn~", - table: "BaseItems", - columns: new[] { "IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_MediaType_TopParentId_IsVirtualItem_PresentationU~", - table: "BaseItems", - columns: new[] { "MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_ParentId", - table: "BaseItems", - column: "ParentId"); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Path", - table: "BaseItems", - column: "Path"); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_PresentationUniqueKey", - table: "BaseItems", - column: "PresentationUniqueKey"); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_TopParentId_Id", - table: "BaseItems", - columns: new[] { "TopParentId", "Id" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_IsFolder_IsVirtu~", - table: "BaseItems", - columns: new[] { "Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_PresentationUniq~", - table: "BaseItems", - columns: new[] { "Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Type_TopParentId_Id", - table: "BaseItems", - columns: new[] { "Type", "TopParentId", "Id" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Type_TopParentId_IsVirtualItem_PresentationUnique~", - table: "BaseItems", - columns: new[] { "Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Type_TopParentId_PresentationUniqueKey", - table: "BaseItems", - columns: new[] { "Type", "TopParentId", "PresentationUniqueKey" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItems_Type_TopParentId_StartDate", - table: "BaseItems", - columns: new[] { "Type", "TopParentId", "StartDate" }); - - migrationBuilder.CreateIndex( - name: "IX_BaseItemTrailerTypes_ItemId", - table: "BaseItemTrailerTypes", - column: "ItemId"); - - migrationBuilder.CreateIndex( - name: "IX_CustomItemDisplayPreferences_UserId_ItemId_Client_Key", - table: "CustomItemDisplayPreferences", - columns: new[] { "UserId", "ItemId", "Client", "Key" }, - unique: true); - - migrationBuilder.CreateIndex( - name: "IX_DeviceOptions_DeviceId", - table: "DeviceOptions", - column: "DeviceId", - unique: true); - - migrationBuilder.CreateIndex( - name: "IX_Devices_AccessToken_DateLastActivity", - table: "Devices", - columns: new[] { "AccessToken", "DateLastActivity" }); - - migrationBuilder.CreateIndex( - name: "IX_Devices_DeviceId", - table: "Devices", - column: "DeviceId"); - - migrationBuilder.CreateIndex( - name: "IX_Devices_DeviceId_DateLastActivity", - table: "Devices", - columns: new[] { "DeviceId", "DateLastActivity" }); - - migrationBuilder.CreateIndex( - name: "IX_Devices_UserId_DeviceId", - table: "Devices", - columns: new[] { "UserId", "DeviceId" }); - - migrationBuilder.CreateIndex( - name: "IX_DisplayPreferences_UserId_ItemId_Client", - table: "DisplayPreferences", - columns: new[] { "UserId", "ItemId", "Client" }, - unique: true); - - migrationBuilder.CreateIndex( - name: "IX_HomeSection_DisplayPreferencesId", - table: "HomeSection", - column: "DisplayPreferencesId"); - - migrationBuilder.CreateIndex( - name: "IX_ImageInfos_UserId", - table: "ImageInfos", - column: "UserId", - unique: true); - - migrationBuilder.CreateIndex( - name: "IX_ItemDisplayPreferences_UserId", - table: "ItemDisplayPreferences", - column: "UserId"); - - migrationBuilder.CreateIndex( - name: "IX_ItemValues_Type_CleanValue", - table: "ItemValues", - columns: new[] { "Type", "CleanValue" }, - unique: true); - - migrationBuilder.CreateIndex( - name: "IX_ItemValuesMap_ItemId", - table: "ItemValuesMap", - column: "ItemId"); - - migrationBuilder.CreateIndex( - name: "IX_MediaStreamInfos_StreamIndex", - table: "MediaStreamInfos", - column: "StreamIndex"); - - migrationBuilder.CreateIndex( - name: "IX_MediaStreamInfos_StreamIndex_StreamType", - table: "MediaStreamInfos", - columns: new[] { "StreamIndex", "StreamType" }); - - migrationBuilder.CreateIndex( - name: "IX_MediaStreamInfos_StreamIndex_StreamType_Language", - table: "MediaStreamInfos", - columns: new[] { "StreamIndex", "StreamType", "Language" }); - - migrationBuilder.CreateIndex( - name: "IX_MediaStreamInfos_StreamType", - table: "MediaStreamInfos", - column: "StreamType"); - - migrationBuilder.CreateIndex( - name: "IX_PeopleBaseItemMap_ItemId_ListOrder", - table: "PeopleBaseItemMap", - columns: new[] { "ItemId", "ListOrder" }); - - migrationBuilder.CreateIndex( - name: "IX_PeopleBaseItemMap_ItemId_SortOrder", - table: "PeopleBaseItemMap", - columns: new[] { "ItemId", "SortOrder" }); - - migrationBuilder.CreateIndex( - name: "IX_PeopleBaseItemMap_PeopleId", - table: "PeopleBaseItemMap", - column: "PeopleId"); - - migrationBuilder.CreateIndex( - name: "IX_Peoples_Name", - table: "Peoples", - column: "Name"); - - // this was edited manually because "UserId" is a reserved name in pgsql - migrationBuilder.CreateIndex( - name: "IX_Permissions_UserId_Kind", - table: "Permissions", - columns: new[] { "UserId", "Kind" }, - unique: true, - filter: "\"Permissions\".\"UserId\" IS NOT NULL"); - - // this was edited manually because "UserId" is a reserved name in pgsql - migrationBuilder.CreateIndex( - name: "IX_Preferences_UserId_Kind", - table: "Preferences", - columns: new[] { "UserId", "Kind" }, - unique: true, - filter: "\"Preferences\".\"UserId\" IS NOT NULL"); - - migrationBuilder.CreateIndex( - name: "IX_UserData_ItemId_UserId_IsFavorite", - table: "UserData", - columns: new[] { "ItemId", "UserId", "IsFavorite" }); - - migrationBuilder.CreateIndex( - name: "IX_UserData_ItemId_UserId_LastPlayedDate", - table: "UserData", - columns: new[] { "ItemId", "UserId", "LastPlayedDate" }); - - migrationBuilder.CreateIndex( - name: "IX_UserData_ItemId_UserId_PlaybackPositionTicks", - table: "UserData", - columns: new[] { "ItemId", "UserId", "PlaybackPositionTicks" }); - - migrationBuilder.CreateIndex( - name: "IX_UserData_ItemId_UserId_Played", - table: "UserData", - columns: new[] { "ItemId", "UserId", "Played" }); - - migrationBuilder.CreateIndex( - name: "IX_UserData_UserId", - table: "UserData", - column: "UserId"); - - migrationBuilder.CreateIndex( - name: "IX_Users_Username", - table: "Users", - column: "Username", - unique: true); - } - - /// <inheritdoc /> - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.DropTable( - name: "AccessSchedules"); - - migrationBuilder.DropTable( - name: "ActivityLogs"); - - migrationBuilder.DropTable( - name: "AncestorIds"); - - migrationBuilder.DropTable( - name: "ApiKeys"); - - migrationBuilder.DropTable( - name: "AttachmentStreamInfos"); - - migrationBuilder.DropTable( - name: "BaseItemImageInfos"); - - migrationBuilder.DropTable( - name: "BaseItemMetadataFields"); - - migrationBuilder.DropTable( - name: "BaseItemProviders"); - - migrationBuilder.DropTable( - name: "BaseItemTrailerTypes"); - - migrationBuilder.DropTable( - name: "Chapters"); - - migrationBuilder.DropTable( - name: "CustomItemDisplayPreferences"); - - migrationBuilder.DropTable( - name: "DeviceOptions"); - - migrationBuilder.DropTable( - name: "Devices"); - - migrationBuilder.DropTable( - name: "HomeSection"); - - migrationBuilder.DropTable( - name: "ImageInfos"); - - migrationBuilder.DropTable( - name: "ItemDisplayPreferences"); - - migrationBuilder.DropTable( - name: "ItemValuesMap"); - - migrationBuilder.DropTable( - name: "MediaSegments"); - - migrationBuilder.DropTable( - name: "MediaStreamInfos"); - - migrationBuilder.DropTable( - name: "PeopleBaseItemMap"); - - migrationBuilder.DropTable( - name: "Permissions"); - - migrationBuilder.DropTable( - name: "Preferences"); - - migrationBuilder.DropTable( - name: "TrickplayInfos"); - - migrationBuilder.DropTable( - name: "UserData"); - - migrationBuilder.DropTable( - name: "DisplayPreferences"); - - migrationBuilder.DropTable( - name: "ItemValues"); - - migrationBuilder.DropTable( - name: "Peoples"); - - migrationBuilder.DropTable( - name: "BaseItems"); - - migrationBuilder.DropTable( - name: "Users"); - } - } -} diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250205183152_MakeStartEndDateNullable.Designer.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250205183152_MakeStartEndDateNullable.Designer.cs deleted file mode 100644 index 6e8aba54b..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250205183152_MakeStartEndDateNullable.Designer.cs +++ /dev/null @@ -1,1623 +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; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace Jellyfin.Database.Providers.PgSql.Migrations -{ - [DbContext(typeof(JellyfinDbContext))] - [Migration("20250205183152_MakeStartEndDateNullable")] - partial class MakeStartEndDateNullable - { - /// <inheritdoc /> - protected override void BuildTargetModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "9.0.1") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("DayOfWeek") - .HasColumnType("integer"); - - b.Property<double>("EndHour") - .HasColumnType("double precision"); - - b.Property<double>("StartHour") - .HasColumnType("double precision"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("UserId"); - - b.ToTable("AccessSchedules"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("ItemId") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<int>("LogSeverity") - .HasColumnType("integer"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<string>("Overview") - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<string>("ShortOverview") - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<string>("Type") - .IsRequired() - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("DateCreated"); - - b.ToTable("ActivityLogs"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AncestorId", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("ParentItemId") - .HasColumnType("uuid"); - - b.HasKey("ItemId", "ParentItemId"); - - b.HasIndex("ParentItemId"); - - b.ToTable("AncestorIds"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("Index") - .HasColumnType("integer"); - - b.Property<string>("Codec") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("CodecTag") - .HasColumnType("text"); - - b.Property<string>("Comment") - .HasColumnType("text"); - - b.Property<string>("Filename") - .HasColumnType("text"); - - b.Property<string>("MimeType") - .HasColumnType("text"); - - b.HasKey("ItemId", "Index"); - - b.ToTable("AttachmentStreamInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("Album") - .HasColumnType("text"); - - b.Property<string>("AlbumArtists") - .HasColumnType("text"); - - b.Property<string>("Artists") - .HasColumnType("text"); - - b.Property<int?>("Audio") - .HasColumnType("integer"); - - b.Property<string>("ChannelId") - .HasColumnType("text"); - - b.Property<string>("CleanName") - .HasColumnType("text"); - - b.Property<float?>("CommunityRating") - .HasColumnType("real"); - - b.Property<float?>("CriticRating") - .HasColumnType("real"); - - b.Property<string>("CustomRating") - .HasColumnType("text"); - - b.Property<string>("Data") - .HasColumnType("text"); - - b.Property<DateTime?>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastMediaAdded") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastRefreshed") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastSaved") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("EndDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("EpisodeTitle") - .HasColumnType("text"); - - b.Property<string>("ExternalId") - .HasColumnType("text"); - - b.Property<string>("ExternalSeriesId") - .HasColumnType("text"); - - b.Property<string>("ExternalServiceId") - .HasColumnType("text"); - - b.Property<string>("ExtraIds") - .HasColumnType("text"); - - b.Property<int?>("ExtraType") - .HasColumnType("integer"); - - b.Property<string>("ForcedSortName") - .HasColumnType("text"); - - b.Property<string>("Genres") - .HasColumnType("text"); - - b.Property<int?>("Height") - .HasColumnType("integer"); - - b.Property<int?>("IndexNumber") - .HasColumnType("integer"); - - b.Property<int?>("InheritedParentalRatingValue") - .HasColumnType("integer"); - - b.Property<bool>("IsFolder") - .HasColumnType("boolean"); - - b.Property<bool>("IsInMixedFolder") - .HasColumnType("boolean"); - - b.Property<bool>("IsLocked") - .HasColumnType("boolean"); - - b.Property<bool>("IsMovie") - .HasColumnType("boolean"); - - b.Property<bool>("IsRepeat") - .HasColumnType("boolean"); - - b.Property<bool>("IsSeries") - .HasColumnType("boolean"); - - b.Property<bool>("IsVirtualItem") - .HasColumnType("boolean"); - - b.Property<float?>("LUFS") - .HasColumnType("real"); - - b.Property<string>("MediaType") - .HasColumnType("text"); - - b.Property<string>("Name") - .HasColumnType("text"); - - b.Property<float?>("NormalizationGain") - .HasColumnType("real"); - - b.Property<string>("OfficialRating") - .HasColumnType("text"); - - b.Property<string>("OriginalTitle") - .HasColumnType("text"); - - b.Property<string>("Overview") - .HasColumnType("text"); - - b.Property<string>("OwnerId") - .HasColumnType("text"); - - b.Property<Guid?>("ParentId") - .HasColumnType("uuid"); - - b.Property<int?>("ParentIndexNumber") - .HasColumnType("integer"); - - b.Property<string>("Path") - .HasColumnType("text"); - - b.Property<string>("PreferredMetadataCountryCode") - .HasColumnType("text"); - - b.Property<string>("PreferredMetadataLanguage") - .HasColumnType("text"); - - b.Property<DateTime?>("PremiereDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("PresentationUniqueKey") - .HasColumnType("text"); - - b.Property<string>("PrimaryVersionId") - .HasColumnType("text"); - - b.Property<string>("ProductionLocations") - .HasColumnType("text"); - - b.Property<int?>("ProductionYear") - .HasColumnType("integer"); - - b.Property<long?>("RunTimeTicks") - .HasColumnType("bigint"); - - b.Property<Guid?>("SeasonId") - .HasColumnType("uuid"); - - b.Property<string>("SeasonName") - .HasColumnType("text"); - - b.Property<Guid?>("SeriesId") - .HasColumnType("uuid"); - - b.Property<string>("SeriesName") - .HasColumnType("text"); - - b.Property<string>("SeriesPresentationUniqueKey") - .HasColumnType("text"); - - b.Property<string>("ShowId") - .HasColumnType("text"); - - b.Property<long?>("Size") - .HasColumnType("bigint"); - - b.Property<string>("SortName") - .HasColumnType("text"); - - b.Property<DateTime?>("StartDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Studios") - .HasColumnType("text"); - - b.Property<string>("Tagline") - .HasColumnType("text"); - - b.Property<string>("Tags") - .HasColumnType("text"); - - b.Property<Guid?>("TopParentId") - .HasColumnType("uuid"); - - b.Property<int?>("TotalBitrate") - .HasColumnType("integer"); - - b.Property<string>("Type") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("UnratedType") - .HasColumnType("text"); - - b.Property<int?>("Width") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("ParentId"); - - b.HasIndex("Path"); - - b.HasIndex("PresentationUniqueKey"); - - b.HasIndex("TopParentId", "Id"); - - b.HasIndex("Type", "TopParentId", "Id"); - - b.HasIndex("Type", "TopParentId", "PresentationUniqueKey"); - - b.HasIndex("Type", "TopParentId", "StartDate"); - - b.HasIndex("Id", "Type", "IsFolder", "IsVirtualItem"); - - b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey"); - - b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem"); - - b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName"); - - b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated"); - - b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated"); - - b.ToTable("BaseItems"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<byte[]>("Blurhash") - .HasColumnType("bytea"); - - b.Property<DateTime>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<int>("Height") - .HasColumnType("integer"); - - b.Property<int>("ImageType") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("Path") - .IsRequired() - .HasColumnType("text"); - - b.Property<int>("Width") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemImageInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b => - { - b.Property<int>("Id") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("Id", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemMetadataFields"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("ProviderId") - .HasColumnType("text"); - - b.Property<string>("ProviderValue") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("ItemId", "ProviderId"); - - b.HasIndex("ProviderId", "ProviderValue", "ItemId"); - - b.ToTable("BaseItemProviders"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b => - { - b.Property<int>("Id") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("Id", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemTrailerTypes"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("ChapterIndex") - .HasColumnType("integer"); - - b.Property<DateTime?>("ImageDateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("ImagePath") - .HasColumnType("text"); - - b.Property<string>("Name") - .HasColumnType("text"); - - b.Property<long>("StartPositionTicks") - .HasColumnType("bigint"); - - b.HasKey("ItemId", "ChapterIndex"); - - b.ToTable("Chapters"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("Key") - .IsRequired() - .HasColumnType("text"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("ChromecastVersion") - .HasColumnType("integer"); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<string>("DashboardTheme") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<bool>("EnableNextVideoInfoOverlay") - .HasColumnType("boolean"); - - b.Property<int?>("IndexBy") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("ScrollDirection") - .HasColumnType("integer"); - - b.Property<bool>("ShowBackdrop") - .HasColumnType("boolean"); - - b.Property<bool>("ShowSidebar") - .HasColumnType("boolean"); - - b.Property<int>("SkipBackwardLength") - .HasColumnType("integer"); - - b.Property<int>("SkipForwardLength") - .HasColumnType("integer"); - - b.Property<string>("TvHome") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<DateTime>("LastModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Path") - .IsRequired() - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("UserId") - .IsUnique(); - - b.ToTable("ImageInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<int?>("IndexBy") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<bool>("RememberIndexing") - .HasColumnType("boolean"); - - b.Property<bool>("RememberSorting") - .HasColumnType("boolean"); - - b.Property<string>("SortBy") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<int>("SortOrder") - .HasColumnType("integer"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.Property<int>("ViewType") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("UserId"); - - b.ToTable("ItemDisplayPreferences"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b => - { - b.Property<Guid>("ItemValueId") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("CleanValue") - .IsRequired() - .HasColumnType("text"); - - b.Property<int>("Type") - .HasColumnType("integer"); - - b.Property<string>("Value") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("ItemValueId"); - - b.HasIndex("Type", "CleanValue") - .IsUnique(); - - b.ToTable("ItemValues"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValueMap", b => - { - b.Property<Guid>("ItemValueId") - .HasColumnType("uuid"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("ItemValueId", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("ItemValuesMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaSegment", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<long>("EndTicks") - .HasColumnType("bigint"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("SegmentProviderId") - .IsRequired() - .HasColumnType("text"); - - b.Property<long>("StartTicks") - .HasColumnType("bigint"); - - b.Property<int>("Type") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.ToTable("MediaSegments"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("StreamIndex") - .HasColumnType("integer"); - - b.Property<string>("AspectRatio") - .HasColumnType("text"); - - b.Property<float?>("AverageFrameRate") - .HasColumnType("real"); - - b.Property<int?>("BitDepth") - .HasColumnType("integer"); - - b.Property<int?>("BitRate") - .HasColumnType("integer"); - - b.Property<int?>("BlPresentFlag") - .HasColumnType("integer"); - - b.Property<string>("ChannelLayout") - .HasColumnType("text"); - - b.Property<int?>("Channels") - .HasColumnType("integer"); - - b.Property<string>("Codec") - .HasColumnType("text"); - - b.Property<string>("CodecTag") - .HasColumnType("text"); - - b.Property<string>("CodecTimeBase") - .HasColumnType("text"); - - b.Property<string>("ColorPrimaries") - .HasColumnType("text"); - - b.Property<string>("ColorSpace") - .HasColumnType("text"); - - b.Property<string>("ColorTransfer") - .HasColumnType("text"); - - b.Property<string>("Comment") - .HasColumnType("text"); - - b.Property<int?>("DvBlSignalCompatibilityId") - .HasColumnType("integer"); - - b.Property<int?>("DvLevel") - .HasColumnType("integer"); - - b.Property<int?>("DvProfile") - .HasColumnType("integer"); - - b.Property<int?>("DvVersionMajor") - .HasColumnType("integer"); - - b.Property<int?>("DvVersionMinor") - .HasColumnType("integer"); - - b.Property<int?>("ElPresentFlag") - .HasColumnType("integer"); - - b.Property<int?>("Height") - .HasColumnType("integer"); - - b.Property<bool?>("IsAnamorphic") - .HasColumnType("boolean"); - - b.Property<bool?>("IsAvc") - .HasColumnType("boolean"); - - b.Property<bool>("IsDefault") - .HasColumnType("boolean"); - - b.Property<bool>("IsExternal") - .HasColumnType("boolean"); - - b.Property<bool>("IsForced") - .HasColumnType("boolean"); - - b.Property<bool?>("IsHearingImpaired") - .HasColumnType("boolean"); - - b.Property<bool?>("IsInterlaced") - .HasColumnType("boolean"); - - b.Property<string>("KeyFrames") - .HasColumnType("text"); - - b.Property<string>("Language") - .HasColumnType("text"); - - b.Property<float?>("Level") - .HasColumnType("real"); - - b.Property<string>("NalLengthSize") - .HasColumnType("text"); - - b.Property<string>("Path") - .HasColumnType("text"); - - b.Property<string>("PixelFormat") - .HasColumnType("text"); - - b.Property<string>("Profile") - .HasColumnType("text"); - - b.Property<float?>("RealFrameRate") - .HasColumnType("real"); - - b.Property<int?>("RefFrames") - .HasColumnType("integer"); - - b.Property<int?>("Rotation") - .HasColumnType("integer"); - - b.Property<int?>("RpuPresentFlag") - .HasColumnType("integer"); - - b.Property<int?>("SampleRate") - .HasColumnType("integer"); - - b.Property<int>("StreamType") - .HasColumnType("integer"); - - b.Property<string>("TimeBase") - .HasColumnType("text"); - - b.Property<string>("Title") - .HasColumnType("text"); - - b.Property<int?>("Width") - .HasColumnType("integer"); - - b.HasKey("ItemId", "StreamIndex"); - - b.HasIndex("StreamIndex"); - - b.HasIndex("StreamType"); - - b.HasIndex("StreamIndex", "StreamType"); - - b.HasIndex("StreamIndex", "StreamType", "Language"); - - b.ToTable("MediaStreamInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.People", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("PersonType") - .HasColumnType("text"); - - b.HasKey("Id"); - - b.HasIndex("Name"); - - b.ToTable("Peoples"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("PeopleId") - .HasColumnType("uuid"); - - b.Property<int?>("ListOrder") - .HasColumnType("integer"); - - b.Property<string>("Role") - .HasColumnType("text"); - - b.Property<int?>("SortOrder") - .HasColumnType("integer"); - - b.HasKey("ItemId", "PeopleId"); - - b.HasIndex("PeopleId"); - - b.HasIndex("ItemId", "ListOrder"); - - b.HasIndex("ItemId", "SortOrder"); - - b.ToTable("PeopleBaseItemMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("Kind") - .HasColumnType("integer"); - - b.Property<Guid?>("Permission_Permissions_Guid") - .HasColumnType("uuid"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.Property<bool>("Value") - .HasColumnType("boolean"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("Kind") - .HasColumnType("integer"); - - b.Property<Guid?>("Preference_Preferences_Guid") - .HasColumnType("uuid"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.Property<string>("Value") - .IsRequired() - .HasMaxLength(65535) - .HasColumnType("character varying(65535)"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("AccessToken") - .IsRequired() - .HasColumnType("text"); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateLastActivity") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("AccessToken") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("AppName") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<string>("AppVersion") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateLastActivity") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("DeviceId") - .IsRequired() - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<string>("DeviceName") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<bool>("IsActive") - .HasColumnType("boolean"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - 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("uuid"); - - 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("uuid"); - - b.Property<string>("AudioLanguagePreference") - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("AuthenticationProviderId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("CastReceiverId") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<bool>("DisplayCollectionsView") - .HasColumnType("boolean"); - - b.Property<bool>("DisplayMissingEpisodes") - .HasColumnType("boolean"); - - b.Property<bool>("EnableAutoLogin") - .HasColumnType("boolean"); - - b.Property<bool>("EnableLocalPassword") - .HasColumnType("boolean"); - - b.Property<bool>("EnableNextEpisodeAutoPlay") - .HasColumnType("boolean"); - - b.Property<bool>("EnableUserPreferenceAccess") - .HasColumnType("boolean"); - - b.Property<bool>("HidePlayedInLatest") - .HasColumnType("boolean"); - - b.Property<long>("InternalId") - .HasColumnType("bigint"); - - b.Property<int>("InvalidLoginAttemptCount") - .HasColumnType("integer"); - - b.Property<DateTime?>("LastActivityDate") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("LastLoginDate") - .HasColumnType("timestamp with time zone"); - - b.Property<int?>("LoginAttemptsBeforeLockout") - .HasColumnType("integer"); - - b.Property<int>("MaxActiveSessions") - .HasColumnType("integer"); - - b.Property<int?>("MaxParentalAgeRating") - .HasColumnType("integer"); - - b.Property<bool>("MustUpdatePassword") - .HasColumnType("boolean"); - - b.Property<string>("Password") - .HasMaxLength(65535) - .HasColumnType("character varying(65535)"); - - b.Property<string>("PasswordResetProviderId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<bool>("PlayDefaultAudioTrack") - .HasColumnType("boolean"); - - b.Property<bool>("RememberAudioSelections") - .HasColumnType("boolean"); - - b.Property<bool>("RememberSubtitleSelections") - .HasColumnType("boolean"); - - b.Property<int?>("RemoteClientBitrateLimit") - .HasColumnType("integer"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<string>("SubtitleLanguagePreference") - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<int>("SubtitleMode") - .HasColumnType("integer"); - - b.Property<int>("SyncPlayAccess") - .HasColumnType("integer"); - - b.Property<string>("Username") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.HasKey("Id"); - - b.HasIndex("Username") - .IsUnique(); - - b.ToTable("Users"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.UserData", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.Property<string>("CustomDataKey") - .HasColumnType("text"); - - b.Property<int?>("AudioStreamIndex") - .HasColumnType("integer"); - - b.Property<bool>("IsFavorite") - .HasColumnType("boolean"); - - b.Property<DateTime?>("LastPlayedDate") - .HasColumnType("timestamp with time zone"); - - b.Property<bool?>("Likes") - .HasColumnType("boolean"); - - b.Property<int>("PlayCount") - .HasColumnType("integer"); - - b.Property<long>("PlaybackPositionTicks") - .HasColumnType("bigint"); - - b.Property<bool>("Played") - .HasColumnType("boolean"); - - b.Property<double?>("Rating") - .HasColumnType("double precision"); - - b.Property<int?>("SubtitleStreamIndex") - .HasColumnType("integer"); - - b.HasKey("ItemId", "UserId", "CustomDataKey"); - - b.HasIndex("UserId"); - - b.HasIndex("ItemId", "UserId", "IsFavorite"); - - b.HasIndex("ItemId", "UserId", "LastPlayedDate"); - - b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks"); - - b.HasIndex("ItemId", "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.AncestorId", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Children") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "ParentItem") - .WithMany("ParentAncestors") - .HasForeignKey("ParentItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("ParentItem"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany() - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Images") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("LockedFields") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Provider") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("TrailerTypes") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Chapters") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - 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.ItemValueMap", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("ItemValues") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.ItemValue", "ItemValue") - .WithMany("BaseItemsMap") - .HasForeignKey("ItemValueId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("ItemValue"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("MediaStreams") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Peoples") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.People", "People") - .WithMany("BaseItems") - .HasForeignKey("PeopleId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("People"); - }); - - 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.BaseItemEntity", "Item") - .WithMany("UserData") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.User", "User") - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("User"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b => - { - b.Navigation("Chapters"); - - b.Navigation("Children"); - - b.Navigation("Images"); - - b.Navigation("ItemValues"); - - b.Navigation("LockedFields"); - - b.Navigation("MediaStreams"); - - b.Navigation("ParentAncestors"); - - b.Navigation("Peoples"); - - b.Navigation("Provider"); - - b.Navigation("TrailerTypes"); - - b.Navigation("UserData"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b => - { - b.Navigation("HomeSections"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b => - { - b.Navigation("BaseItemsMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.People", b => - { - b.Navigation("BaseItems"); - }); - - 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.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250205183152_MakeStartEndDateNullable.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250205183152_MakeStartEndDateNullable.cs deleted file mode 100644 index 6ed1ddc5a..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/20250205183152_MakeStartEndDateNullable.cs +++ /dev/null @@ -1,55 +0,0 @@ -using System; -using Microsoft.EntityFrameworkCore.Migrations; - -#nullable disable - -namespace Jellyfin.Database.Providers.PgSql.Migrations -{ - /// <inheritdoc /> - public partial class MakeStartEndDateNullable : Migration - { - /// <inheritdoc /> - protected override void Up(MigrationBuilder migrationBuilder) - { - migrationBuilder.AlterColumn<DateTime>( - name: "StartDate", - table: "BaseItems", - type: "timestamp with time zone", - nullable: true, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - - migrationBuilder.AlterColumn<DateTime>( - name: "EndDate", - table: "BaseItems", - type: "timestamp with time zone", - nullable: true, - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone"); - } - - /// <inheritdoc /> - protected override void Down(MigrationBuilder migrationBuilder) - { - migrationBuilder.AlterColumn<DateTime>( - name: "StartDate", - table: "BaseItems", - type: "timestamp with time zone", - nullable: false, - defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone", - oldNullable: true); - - migrationBuilder.AlterColumn<DateTime>( - name: "EndDate", - table: "BaseItems", - type: "timestamp with time zone", - nullable: false, - defaultValue: new DateTime(1, 1, 1, 0, 0, 0, 0, DateTimeKind.Unspecified), - oldClrType: typeof(DateTime), - oldType: "timestamp with time zone", - oldNullable: true); - } - } -} diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/JellyfinDbContextModelSnapshot.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/JellyfinDbContextModelSnapshot.cs deleted file mode 100644 index d67fd89d8..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/JellyfinDbContextModelSnapshot.cs +++ /dev/null @@ -1,1620 +0,0 @@ -// <auto-generated /> -using System; -using Jellyfin.Server.Implementations; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Infrastructure; -using Microsoft.EntityFrameworkCore.Storage.ValueConversion; -using Npgsql.EntityFrameworkCore.PostgreSQL.Metadata; - -#nullable disable - -namespace Jellyfin.Database.Providers.PgSql.Migrations -{ - [DbContext(typeof(JellyfinDbContext))] - partial class JellyfinDbContextModelSnapshot : ModelSnapshot - { - protected override void BuildModel(ModelBuilder modelBuilder) - { -#pragma warning disable 612, 618 - modelBuilder - .HasAnnotation("ProductVersion", "9.0.1") - .HasAnnotation("Relational:MaxIdentifierLength", 63); - - NpgsqlModelBuilderExtensions.UseIdentityByDefaultColumns(modelBuilder); - - modelBuilder.Entity("Jellyfin.Data.Entities.AccessSchedule", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("DayOfWeek") - .HasColumnType("integer"); - - b.Property<double>("EndHour") - .HasColumnType("double precision"); - - b.Property<double>("StartHour") - .HasColumnType("double precision"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("UserId"); - - b.ToTable("AccessSchedules"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ActivityLog", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("ItemId") - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<int>("LogSeverity") - .HasColumnType("integer"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<string>("Overview") - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<string>("ShortOverview") - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<string>("Type") - .IsRequired() - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("DateCreated"); - - b.ToTable("ActivityLogs"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AncestorId", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("ParentItemId") - .HasColumnType("uuid"); - - b.HasKey("ItemId", "ParentItemId"); - - b.HasIndex("ParentItemId"); - - b.ToTable("AncestorIds"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("Index") - .HasColumnType("integer"); - - b.Property<string>("Codec") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("CodecTag") - .HasColumnType("text"); - - b.Property<string>("Comment") - .HasColumnType("text"); - - b.Property<string>("Filename") - .HasColumnType("text"); - - b.Property<string>("MimeType") - .HasColumnType("text"); - - b.HasKey("ItemId", "Index"); - - b.ToTable("AttachmentStreamInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("Album") - .HasColumnType("text"); - - b.Property<string>("AlbumArtists") - .HasColumnType("text"); - - b.Property<string>("Artists") - .HasColumnType("text"); - - b.Property<int?>("Audio") - .HasColumnType("integer"); - - b.Property<string>("ChannelId") - .HasColumnType("text"); - - b.Property<string>("CleanName") - .HasColumnType("text"); - - b.Property<float?>("CommunityRating") - .HasColumnType("real"); - - b.Property<float?>("CriticRating") - .HasColumnType("real"); - - b.Property<string>("CustomRating") - .HasColumnType("text"); - - b.Property<string>("Data") - .HasColumnType("text"); - - b.Property<DateTime?>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastMediaAdded") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastRefreshed") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateLastSaved") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("EndDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("EpisodeTitle") - .HasColumnType("text"); - - b.Property<string>("ExternalId") - .HasColumnType("text"); - - b.Property<string>("ExternalSeriesId") - .HasColumnType("text"); - - b.Property<string>("ExternalServiceId") - .HasColumnType("text"); - - b.Property<string>("ExtraIds") - .HasColumnType("text"); - - b.Property<int?>("ExtraType") - .HasColumnType("integer"); - - b.Property<string>("ForcedSortName") - .HasColumnType("text"); - - b.Property<string>("Genres") - .HasColumnType("text"); - - b.Property<int?>("Height") - .HasColumnType("integer"); - - b.Property<int?>("IndexNumber") - .HasColumnType("integer"); - - b.Property<int?>("InheritedParentalRatingValue") - .HasColumnType("integer"); - - b.Property<bool>("IsFolder") - .HasColumnType("boolean"); - - b.Property<bool>("IsInMixedFolder") - .HasColumnType("boolean"); - - b.Property<bool>("IsLocked") - .HasColumnType("boolean"); - - b.Property<bool>("IsMovie") - .HasColumnType("boolean"); - - b.Property<bool>("IsRepeat") - .HasColumnType("boolean"); - - b.Property<bool>("IsSeries") - .HasColumnType("boolean"); - - b.Property<bool>("IsVirtualItem") - .HasColumnType("boolean"); - - b.Property<float?>("LUFS") - .HasColumnType("real"); - - b.Property<string>("MediaType") - .HasColumnType("text"); - - b.Property<string>("Name") - .HasColumnType("text"); - - b.Property<float?>("NormalizationGain") - .HasColumnType("real"); - - b.Property<string>("OfficialRating") - .HasColumnType("text"); - - b.Property<string>("OriginalTitle") - .HasColumnType("text"); - - b.Property<string>("Overview") - .HasColumnType("text"); - - b.Property<string>("OwnerId") - .HasColumnType("text"); - - b.Property<Guid?>("ParentId") - .HasColumnType("uuid"); - - b.Property<int?>("ParentIndexNumber") - .HasColumnType("integer"); - - b.Property<string>("Path") - .HasColumnType("text"); - - b.Property<string>("PreferredMetadataCountryCode") - .HasColumnType("text"); - - b.Property<string>("PreferredMetadataLanguage") - .HasColumnType("text"); - - b.Property<DateTime?>("PremiereDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("PresentationUniqueKey") - .HasColumnType("text"); - - b.Property<string>("PrimaryVersionId") - .HasColumnType("text"); - - b.Property<string>("ProductionLocations") - .HasColumnType("text"); - - b.Property<int?>("ProductionYear") - .HasColumnType("integer"); - - b.Property<long?>("RunTimeTicks") - .HasColumnType("bigint"); - - b.Property<Guid?>("SeasonId") - .HasColumnType("uuid"); - - b.Property<string>("SeasonName") - .HasColumnType("text"); - - b.Property<Guid?>("SeriesId") - .HasColumnType("uuid"); - - b.Property<string>("SeriesName") - .HasColumnType("text"); - - b.Property<string>("SeriesPresentationUniqueKey") - .HasColumnType("text"); - - b.Property<string>("ShowId") - .HasColumnType("text"); - - b.Property<long?>("Size") - .HasColumnType("bigint"); - - b.Property<string>("SortName") - .HasColumnType("text"); - - b.Property<DateTime?>("StartDate") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Studios") - .HasColumnType("text"); - - b.Property<string>("Tagline") - .HasColumnType("text"); - - b.Property<string>("Tags") - .HasColumnType("text"); - - b.Property<Guid?>("TopParentId") - .HasColumnType("uuid"); - - b.Property<int?>("TotalBitrate") - .HasColumnType("integer"); - - b.Property<string>("Type") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("UnratedType") - .HasColumnType("text"); - - b.Property<int?>("Width") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("ParentId"); - - b.HasIndex("Path"); - - b.HasIndex("PresentationUniqueKey"); - - b.HasIndex("TopParentId", "Id"); - - b.HasIndex("Type", "TopParentId", "Id"); - - b.HasIndex("Type", "TopParentId", "PresentationUniqueKey"); - - b.HasIndex("Type", "TopParentId", "StartDate"); - - b.HasIndex("Id", "Type", "IsFolder", "IsVirtualItem"); - - b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey"); - - b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem"); - - b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName"); - - b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated"); - - b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated"); - - b.ToTable("BaseItems"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<byte[]>("Blurhash") - .HasColumnType("bytea"); - - b.Property<DateTime>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<int>("Height") - .HasColumnType("integer"); - - b.Property<int>("ImageType") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("Path") - .IsRequired() - .HasColumnType("text"); - - b.Property<int>("Width") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemImageInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b => - { - b.Property<int>("Id") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("Id", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemMetadataFields"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("ProviderId") - .HasColumnType("text"); - - b.Property<string>("ProviderValue") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("ItemId", "ProviderId"); - - b.HasIndex("ProviderId", "ProviderValue", "ItemId"); - - b.ToTable("BaseItemProviders"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b => - { - b.Property<int>("Id") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("Id", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("BaseItemTrailerTypes"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("ChapterIndex") - .HasColumnType("integer"); - - b.Property<DateTime?>("ImageDateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("ImagePath") - .HasColumnType("text"); - - b.Property<string>("Name") - .HasColumnType("text"); - - b.Property<long>("StartPositionTicks") - .HasColumnType("bigint"); - - b.HasKey("ItemId", "ChapterIndex"); - - b.ToTable("Chapters"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.CustomItemDisplayPreferences", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("Key") - .IsRequired() - .HasColumnType("text"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("ChromecastVersion") - .HasColumnType("integer"); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<string>("DashboardTheme") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<bool>("EnableNextVideoInfoOverlay") - .HasColumnType("boolean"); - - b.Property<int?>("IndexBy") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("ScrollDirection") - .HasColumnType("integer"); - - b.Property<bool>("ShowBackdrop") - .HasColumnType("boolean"); - - b.Property<bool>("ShowSidebar") - .HasColumnType("boolean"); - - b.Property<int>("SkipBackwardLength") - .HasColumnType("integer"); - - b.Property<int>("SkipForwardLength") - .HasColumnType("integer"); - - b.Property<string>("TvHome") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<DateTime>("LastModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Path") - .IsRequired() - .HasMaxLength(512) - .HasColumnType("character varying(512)"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.HasKey("Id"); - - b.HasIndex("UserId") - .IsUnique(); - - b.ToTable("ImageInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemDisplayPreferences", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("Client") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<int?>("IndexBy") - .HasColumnType("integer"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<bool>("RememberIndexing") - .HasColumnType("boolean"); - - b.Property<bool>("RememberSorting") - .HasColumnType("boolean"); - - b.Property<string>("SortBy") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<int>("SortOrder") - .HasColumnType("integer"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.Property<int>("ViewType") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.HasIndex("UserId"); - - b.ToTable("ItemDisplayPreferences"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b => - { - b.Property<Guid>("ItemValueId") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("CleanValue") - .IsRequired() - .HasColumnType("text"); - - b.Property<int>("Type") - .HasColumnType("integer"); - - b.Property<string>("Value") - .IsRequired() - .HasColumnType("text"); - - b.HasKey("ItemValueId"); - - b.HasIndex("Type", "CleanValue") - .IsUnique(); - - b.ToTable("ItemValues"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValueMap", b => - { - b.Property<Guid>("ItemValueId") - .HasColumnType("uuid"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.HasKey("ItemValueId", "ItemId"); - - b.HasIndex("ItemId"); - - b.ToTable("ItemValuesMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaSegment", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<long>("EndTicks") - .HasColumnType("bigint"); - - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<string>("SegmentProviderId") - .IsRequired() - .HasColumnType("text"); - - b.Property<long>("StartTicks") - .HasColumnType("bigint"); - - b.Property<int>("Type") - .HasColumnType("integer"); - - b.HasKey("Id"); - - b.ToTable("MediaSegments"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<int>("StreamIndex") - .HasColumnType("integer"); - - b.Property<string>("AspectRatio") - .HasColumnType("text"); - - b.Property<float?>("AverageFrameRate") - .HasColumnType("real"); - - b.Property<int?>("BitDepth") - .HasColumnType("integer"); - - b.Property<int?>("BitRate") - .HasColumnType("integer"); - - b.Property<int?>("BlPresentFlag") - .HasColumnType("integer"); - - b.Property<string>("ChannelLayout") - .HasColumnType("text"); - - b.Property<int?>("Channels") - .HasColumnType("integer"); - - b.Property<string>("Codec") - .HasColumnType("text"); - - b.Property<string>("CodecTag") - .HasColumnType("text"); - - b.Property<string>("CodecTimeBase") - .HasColumnType("text"); - - b.Property<string>("ColorPrimaries") - .HasColumnType("text"); - - b.Property<string>("ColorSpace") - .HasColumnType("text"); - - b.Property<string>("ColorTransfer") - .HasColumnType("text"); - - b.Property<string>("Comment") - .HasColumnType("text"); - - b.Property<int?>("DvBlSignalCompatibilityId") - .HasColumnType("integer"); - - b.Property<int?>("DvLevel") - .HasColumnType("integer"); - - b.Property<int?>("DvProfile") - .HasColumnType("integer"); - - b.Property<int?>("DvVersionMajor") - .HasColumnType("integer"); - - b.Property<int?>("DvVersionMinor") - .HasColumnType("integer"); - - b.Property<int?>("ElPresentFlag") - .HasColumnType("integer"); - - b.Property<int?>("Height") - .HasColumnType("integer"); - - b.Property<bool?>("IsAnamorphic") - .HasColumnType("boolean"); - - b.Property<bool?>("IsAvc") - .HasColumnType("boolean"); - - b.Property<bool>("IsDefault") - .HasColumnType("boolean"); - - b.Property<bool>("IsExternal") - .HasColumnType("boolean"); - - b.Property<bool>("IsForced") - .HasColumnType("boolean"); - - b.Property<bool?>("IsHearingImpaired") - .HasColumnType("boolean"); - - b.Property<bool?>("IsInterlaced") - .HasColumnType("boolean"); - - b.Property<string>("KeyFrames") - .HasColumnType("text"); - - b.Property<string>("Language") - .HasColumnType("text"); - - b.Property<float?>("Level") - .HasColumnType("real"); - - b.Property<string>("NalLengthSize") - .HasColumnType("text"); - - b.Property<string>("Path") - .HasColumnType("text"); - - b.Property<string>("PixelFormat") - .HasColumnType("text"); - - b.Property<string>("Profile") - .HasColumnType("text"); - - b.Property<float?>("RealFrameRate") - .HasColumnType("real"); - - b.Property<int?>("RefFrames") - .HasColumnType("integer"); - - b.Property<int?>("Rotation") - .HasColumnType("integer"); - - b.Property<int?>("RpuPresentFlag") - .HasColumnType("integer"); - - b.Property<int?>("SampleRate") - .HasColumnType("integer"); - - b.Property<int>("StreamType") - .HasColumnType("integer"); - - b.Property<string>("TimeBase") - .HasColumnType("text"); - - b.Property<string>("Title") - .HasColumnType("text"); - - b.Property<int?>("Width") - .HasColumnType("integer"); - - b.HasKey("ItemId", "StreamIndex"); - - b.HasIndex("StreamIndex"); - - b.HasIndex("StreamType"); - - b.HasIndex("StreamIndex", "StreamType"); - - b.HasIndex("StreamIndex", "StreamType", "Language"); - - b.ToTable("MediaStreamInfos"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.People", b => - { - b.Property<Guid>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("uuid"); - - b.Property<string>("Name") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("PersonType") - .HasColumnType("text"); - - b.HasKey("Id"); - - b.HasIndex("Name"); - - b.ToTable("Peoples"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("PeopleId") - .HasColumnType("uuid"); - - b.Property<int?>("ListOrder") - .HasColumnType("integer"); - - b.Property<string>("Role") - .HasColumnType("text"); - - b.Property<int?>("SortOrder") - .HasColumnType("integer"); - - b.HasKey("ItemId", "PeopleId"); - - b.HasIndex("PeopleId"); - - b.HasIndex("ItemId", "ListOrder"); - - b.HasIndex("ItemId", "SortOrder"); - - b.ToTable("PeopleBaseItemMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Permission", b => - { - b.Property<int>("Id") - .ValueGeneratedOnAdd() - .HasColumnType("integer"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("Kind") - .HasColumnType("integer"); - - b.Property<Guid?>("Permission_Permissions_Guid") - .HasColumnType("uuid"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.Property<bool>("Value") - .HasColumnType("boolean"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<int>("Kind") - .HasColumnType("integer"); - - b.Property<Guid?>("Preference_Preferences_Guid") - .HasColumnType("uuid"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<Guid?>("UserId") - .HasColumnType("uuid"); - - b.Property<string>("Value") - .IsRequired() - .HasMaxLength(65535) - .HasColumnType("character varying(65535)"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("AccessToken") - .IsRequired() - .HasColumnType("text"); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateLastActivity") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("Name") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - b.Property<string>("AccessToken") - .IsRequired() - .HasColumnType("text"); - - b.Property<string>("AppName") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<string>("AppVersion") - .IsRequired() - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<DateTime>("DateCreated") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateLastActivity") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime>("DateModified") - .HasColumnType("timestamp with time zone"); - - b.Property<string>("DeviceId") - .IsRequired() - .HasMaxLength(256) - .HasColumnType("character varying(256)"); - - b.Property<string>("DeviceName") - .IsRequired() - .HasMaxLength(64) - .HasColumnType("character varying(64)"); - - b.Property<bool>("IsActive") - .HasColumnType("boolean"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - 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"); - - NpgsqlPropertyBuilderExtensions.UseIdentityByDefaultColumn(b.Property<int>("Id")); - - 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("uuid"); - - 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("uuid"); - - b.Property<string>("AudioLanguagePreference") - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("AuthenticationProviderId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<string>("CastReceiverId") - .HasMaxLength(32) - .HasColumnType("character varying(32)"); - - b.Property<bool>("DisplayCollectionsView") - .HasColumnType("boolean"); - - b.Property<bool>("DisplayMissingEpisodes") - .HasColumnType("boolean"); - - b.Property<bool>("EnableAutoLogin") - .HasColumnType("boolean"); - - b.Property<bool>("EnableLocalPassword") - .HasColumnType("boolean"); - - b.Property<bool>("EnableNextEpisodeAutoPlay") - .HasColumnType("boolean"); - - b.Property<bool>("EnableUserPreferenceAccess") - .HasColumnType("boolean"); - - b.Property<bool>("HidePlayedInLatest") - .HasColumnType("boolean"); - - b.Property<long>("InternalId") - .HasColumnType("bigint"); - - b.Property<int>("InvalidLoginAttemptCount") - .HasColumnType("integer"); - - b.Property<DateTime?>("LastActivityDate") - .HasColumnType("timestamp with time zone"); - - b.Property<DateTime?>("LastLoginDate") - .HasColumnType("timestamp with time zone"); - - b.Property<int?>("LoginAttemptsBeforeLockout") - .HasColumnType("integer"); - - b.Property<int>("MaxActiveSessions") - .HasColumnType("integer"); - - b.Property<int?>("MaxParentalAgeRating") - .HasColumnType("integer"); - - b.Property<bool>("MustUpdatePassword") - .HasColumnType("boolean"); - - b.Property<string>("Password") - .HasMaxLength(65535) - .HasColumnType("character varying(65535)"); - - b.Property<string>("PasswordResetProviderId") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<bool>("PlayDefaultAudioTrack") - .HasColumnType("boolean"); - - b.Property<bool>("RememberAudioSelections") - .HasColumnType("boolean"); - - b.Property<bool>("RememberSubtitleSelections") - .HasColumnType("boolean"); - - b.Property<int?>("RemoteClientBitrateLimit") - .HasColumnType("integer"); - - b.Property<long>("RowVersion") - .IsConcurrencyToken() - .HasColumnType("bigint"); - - b.Property<string>("SubtitleLanguagePreference") - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.Property<int>("SubtitleMode") - .HasColumnType("integer"); - - b.Property<int>("SyncPlayAccess") - .HasColumnType("integer"); - - b.Property<string>("Username") - .IsRequired() - .HasMaxLength(255) - .HasColumnType("character varying(255)"); - - b.HasKey("Id"); - - b.HasIndex("Username") - .IsUnique(); - - b.ToTable("Users"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.UserData", b => - { - b.Property<Guid>("ItemId") - .HasColumnType("uuid"); - - b.Property<Guid>("UserId") - .HasColumnType("uuid"); - - b.Property<string>("CustomDataKey") - .HasColumnType("text"); - - b.Property<int?>("AudioStreamIndex") - .HasColumnType("integer"); - - b.Property<bool>("IsFavorite") - .HasColumnType("boolean"); - - b.Property<DateTime?>("LastPlayedDate") - .HasColumnType("timestamp with time zone"); - - b.Property<bool?>("Likes") - .HasColumnType("boolean"); - - b.Property<int>("PlayCount") - .HasColumnType("integer"); - - b.Property<long>("PlaybackPositionTicks") - .HasColumnType("bigint"); - - b.Property<bool>("Played") - .HasColumnType("boolean"); - - b.Property<double?>("Rating") - .HasColumnType("double precision"); - - b.Property<int?>("SubtitleStreamIndex") - .HasColumnType("integer"); - - b.HasKey("ItemId", "UserId", "CustomDataKey"); - - b.HasIndex("UserId"); - - b.HasIndex("ItemId", "UserId", "IsFavorite"); - - b.HasIndex("ItemId", "UserId", "LastPlayedDate"); - - b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks"); - - b.HasIndex("ItemId", "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.AncestorId", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Children") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "ParentItem") - .WithMany("ParentAncestors") - .HasForeignKey("ParentItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("ParentItem"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.AttachmentStreamInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany() - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemImageInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Images") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemMetadataField", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("LockedFields") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemProvider", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Provider") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemTrailerType", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("TrailerTypes") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.Chapter", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Chapters") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - 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.ItemValueMap", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("ItemValues") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.ItemValue", "ItemValue") - .WithMany("BaseItemsMap") - .HasForeignKey("ItemValueId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("ItemValue"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.MediaStreamInfo", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("MediaStreams") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.PeopleBaseItemMap", b => - { - b.HasOne("Jellyfin.Data.Entities.BaseItemEntity", "Item") - .WithMany("Peoples") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.People", "People") - .WithMany("BaseItems") - .HasForeignKey("PeopleId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("People"); - }); - - 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.BaseItemEntity", "Item") - .WithMany("UserData") - .HasForeignKey("ItemId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.HasOne("Jellyfin.Data.Entities.User", "User") - .WithMany() - .HasForeignKey("UserId") - .OnDelete(DeleteBehavior.Cascade) - .IsRequired(); - - b.Navigation("Item"); - - b.Navigation("User"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.BaseItemEntity", b => - { - b.Navigation("Chapters"); - - b.Navigation("Children"); - - b.Navigation("Images"); - - b.Navigation("ItemValues"); - - b.Navigation("LockedFields"); - - b.Navigation("MediaStreams"); - - b.Navigation("ParentAncestors"); - - b.Navigation("Peoples"); - - b.Navigation("Provider"); - - b.Navigation("TrailerTypes"); - - b.Navigation("UserData"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.DisplayPreferences", b => - { - b.Navigation("HomeSections"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.ItemValue", b => - { - b.Navigation("BaseItemsMap"); - }); - - modelBuilder.Entity("Jellyfin.Data.Entities.People", b => - { - b.Navigation("BaseItems"); - }); - - 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.Database/Jellyfin.Database.Providers.PgSql/Migrations/PgSqlDesignTimeJellyfinDbFactory.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/PgSqlDesignTimeJellyfinDbFactory.cs deleted file mode 100644 index bf949d570..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Migrations/PgSqlDesignTimeJellyfinDbFactory.cs +++ /dev/null @@ -1,25 +0,0 @@ -using Jellyfin.Server.Implementations; -using Microsoft.EntityFrameworkCore; -using Microsoft.EntityFrameworkCore.Design; -using Microsoft.Extensions.Logging.Abstractions; - -namespace Jellyfin.Database.Providers.PgSql -{ - /// <summary> - /// The design time factory for <see cref="JellyfinDbContext"/>. - /// This is only used for the creation of migrations and not during runtime. - /// </summary> - internal sealed class PgSqlDesignTimeJellyfinDbFactory : IDesignTimeDbContextFactory<JellyfinDbContext> - { - public JellyfinDbContext CreateDbContext(string[] args) - { - var optionsBuilder = new DbContextOptionsBuilder<JellyfinDbContext>(); - optionsBuilder.UseNpgsql(f => f.MigrationsAssembly(GetType().Assembly)); - - return new JellyfinDbContext( - optionsBuilder.Options, - NullLogger<JellyfinDbContext>.Instance, - new PgSqlDatabaseProvider(null!, NullLogger<PgSqlDatabaseProvider>.Instance)); - } - } -} diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/PgSqlDatabaseProvider.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/PgSqlDatabaseProvider.cs deleted file mode 100644 index ccaf38d2a..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/PgSqlDatabaseProvider.cs +++ /dev/null @@ -1,77 +0,0 @@ -using System; -using System.Diagnostics; -using System.Reflection; -using Jellyfin.Server.Implementations; -using Jellyfin.Server.Implementations.DatabaseConfiguration; -using MediaBrowser.Common.Configuration; -using Microsoft.EntityFrameworkCore; -using Microsoft.Extensions.Logging; -using Npgsql; - -namespace Jellyfin.Database.Providers.PgSql; - -/// <summary> -/// Configures jellyfin to use an Postgres database. -/// </summary> -[JellyfinDatabaseProviderKey("Jellyfin-PgSql")] -public sealed class PgSqlDatabaseProvider : IJellyfinDatabaseProvider -{ - private readonly IConfigurationManager _configurationManager; - private readonly ILogger<PgSqlDatabaseProvider> _logger; - - /// <summary> - /// Initializes a new instance of the <see cref="PgSqlDatabaseProvider"/> class. - /// </summary> - /// <param name="configurationManager">Configuration manager to get PgSQL connection data.</param> - /// <param name="logger">A logger.</param> - public PgSqlDatabaseProvider(IConfigurationManager configurationManager, ILogger<PgSqlDatabaseProvider> logger) - { - _configurationManager = configurationManager; - _logger = logger; - } - - /// <inheritdoc/> - public IDbContextFactory<JellyfinDbContext>? DbContextFactory { get; set; } - - /// <inheritdoc/> - public void Initialise(DbContextOptionsBuilder options) - { - var dbSettings = _configurationManager.GetConfiguration<DatabaseConfigurationOptions>("database"); - - if (dbSettings.PostgreSql is null) - { - throw new InvalidOperationException("Selected PgSQL as database provider but did not provide required configuration. Please see docs."); - } - - var connectionBuilder = new NpgsqlConnectionStringBuilder(); - connectionBuilder.ApplicationName = $"jellyfin+{FileVersionInfo.GetVersionInfo(Assembly.GetEntryAssembly()!.Location).FileVersion}"; - connectionBuilder.CommandTimeout = dbSettings.PostgreSql.Timeout; - connectionBuilder.Database = dbSettings.PostgreSql.DatabaseName; - connectionBuilder.Username = dbSettings.PostgreSql.Username; - connectionBuilder.Password = dbSettings.PostgreSql.Password; - connectionBuilder.Host = dbSettings.PostgreSql.ServerName; - connectionBuilder.Port = dbSettings.PostgreSql.Port; - - var connectionString = connectionBuilder.ToString(); - - options - .UseNpgsql(connectionString, pgSqlOptions => pgSqlOptions.MigrationsAssembly(GetType().Assembly)); - } - - /// <inheritdoc/> - public Task RunScheduledOptimisation(CancellationToken cancellationToken) - { - return Task.CompletedTask; - } - - /// <inheritdoc/> - public void OnModelCreating(ModelBuilder modelBuilder) - { - } - - /// <inheritdoc/> - public Task RunShutdownTask(CancellationToken cancellationToken) - { - return Task.CompletedTask; - } -} diff --git a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Properties/AssemblyInfo.cs b/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Properties/AssemblyInfo.cs deleted file mode 100644 index 27022c7de..000000000 --- a/Jellyfin.Database/Jellyfin.Database.Providers.PgSql/Properties/AssemblyInfo.cs +++ /dev/null @@ -1,23 +0,0 @@ -using System.Reflection; -using System.Resources; -using System.Runtime.CompilerServices; -using System.Runtime.InteropServices; - -// General Information about an assembly is controlled through the following -// set of attributes. Change these attribute values to modify the information -// associated with an assembly. -[assembly: AssemblyTitle("Jellyfin.Database.Providers.PgSql")] -[assembly: AssemblyDescription("")] -[assembly: AssemblyConfiguration("")] -[assembly: AssemblyCompany("Jellyfin Project")] -[assembly: AssemblyProduct("Jellyfin Server")] -[assembly: AssemblyCopyright("Copyright © 2019 Jellyfin Contributors. Code released under the GNU General Public License")] -[assembly: AssemblyTrademark("")] -[assembly: AssemblyCulture("")] -[assembly: NeutralResourcesLanguage("en")] -[assembly: InternalsVisibleTo("Jellyfin.Server.Implementations.Tests")] - -// Setting ComVisible to false makes the types in this assembly not visible -// to COM components. If you need to access a type in this assembly from -// COM, set the ComVisible attribute to true on that type. -[assembly: ComVisible(false)] diff --git a/Jellyfin.Server.Implementations/Extensions/ServiceCollectionExtensions.cs b/Jellyfin.Server.Implementations/Extensions/ServiceCollectionExtensions.cs index 1dd7cfe04..9bf67118d 100644 --- a/Jellyfin.Server.Implementations/Extensions/ServiceCollectionExtensions.cs +++ b/Jellyfin.Server.Implementations/Extensions/ServiceCollectionExtensions.cs @@ -1,9 +1,6 @@ using System; using System.Collections.Generic; -using System.IO; -using System.Linq; using System.Reflection; -using Jellyfin.Database.Providers.PgSql; using Jellyfin.Database.Providers.SqLite; using Jellyfin.Server.Implementations.DatabaseConfiguration; using MediaBrowser.Common.Configuration; @@ -23,7 +20,6 @@ public static class ServiceCollectionExtensions private static IEnumerable<Type> DatabaseProviderTypes() { yield return typeof(SqliteDatabaseProvider); - yield return typeof(PgSqlDatabaseProvider); } private static IDictionary<string, JellyfinDbProviderFactory> GetSupportedDbProviders() diff --git a/Jellyfin.sln b/Jellyfin.sln index e6642c296..5bc1b6ef8 100644 --- a/Jellyfin.sln +++ b/Jellyfin.sln @@ -89,9 +89,7 @@ Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Jellyfin.LiveTv", "src\Jell EndProject Project("{2150E333-8FDC-42A3-9474-1A3956D46DE8}") = "Jellyfin.Database", "Jellyfin.Database", "{4C54CE05-69C8-48FA-8785-39F7F6DB1CAD}" EndProject -Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Jellyfin.Database.SqLite", "Jellyfin.Database\Jellyfin.Database.Providers.SqLite\Jellyfin.Database.Providers.SqLite.csproj", "{A5590358-33CC-4B39-BDE7-DC62FEB03C76}" -EndProject -Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Jellyfin.Database.PgSql", "Jellyfin.Database\Jellyfin.Database.Providers.PgSql\Jellyfin.Database.Providers.PgSql.csproj", "{EC91A604-C99E-44E2-BB74-B4EB2A4B6A0C}" +Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Jellyfin.Database.Providers.SqLite", "Jellyfin.Database\Jellyfin.Database.Providers.SqLite\Jellyfin.Database.Providers.SqLite.csproj", "{A5590358-33CC-4B39-BDE7-DC62FEB03C76}" EndProject Project("{FAE04EC0-301F-11D3-BF4B-00C04F79EFBC}") = "Jellyfin.Database.Implementations", "Jellyfin.Database\Jellyfin.Database.Implementations\Jellyfin.Database.Implementations.csproj", "{8C9F9221-8415-496C-B1F5-E7756F03FA59}" EndProject @@ -253,10 +251,6 @@ Global {A5590358-33CC-4B39-BDE7-DC62FEB03C76}.Debug|Any CPU.Build.0 = Debug|Any CPU {A5590358-33CC-4B39-BDE7-DC62FEB03C76}.Release|Any CPU.ActiveCfg = Release|Any CPU {A5590358-33CC-4B39-BDE7-DC62FEB03C76}.Release|Any CPU.Build.0 = Release|Any CPU - {EC91A604-C99E-44E2-BB74-B4EB2A4B6A0C}.Debug|Any CPU.ActiveCfg = Debug|Any CPU - {EC91A604-C99E-44E2-BB74-B4EB2A4B6A0C}.Debug|Any CPU.Build.0 = Debug|Any CPU - {EC91A604-C99E-44E2-BB74-B4EB2A4B6A0C}.Release|Any CPU.ActiveCfg = Release|Any CPU - {EC91A604-C99E-44E2-BB74-B4EB2A4B6A0C}.Release|Any CPU.Build.0 = Release|Any CPU {8C9F9221-8415-496C-B1F5-E7756F03FA59}.Debug|Any CPU.ActiveCfg = Debug|Any CPU {8C9F9221-8415-496C-B1F5-E7756F03FA59}.Debug|Any CPU.Build.0 = Debug|Any CPU {8C9F9221-8415-496C-B1F5-E7756F03FA59}.Release|Any CPU.ActiveCfg = Release|Any CPU @@ -290,7 +284,6 @@ Global {C4F71272-C6BE-4C30-BE0D-4E6ED651D6D3} = {FBBB5129-006E-4AD7-BAD5-8B7CA1D10ED6} {8C6B2B13-58A4-4506-9DAB-1F882A093FE0} = {C9F0AB5D-F4D7-40C8-A353-3305C86D6D4C} {A5590358-33CC-4B39-BDE7-DC62FEB03C76} = {4C54CE05-69C8-48FA-8785-39F7F6DB1CAD} - {EC91A604-C99E-44E2-BB74-B4EB2A4B6A0C} = {4C54CE05-69C8-48FA-8785-39F7F6DB1CAD} {8C9F9221-8415-496C-B1F5-E7756F03FA59} = {4C54CE05-69C8-48FA-8785-39F7F6DB1CAD} EndGlobalSection GlobalSection(ExtensibilityGlobals) = postSolution diff --git a/tests/Jellyfin.Server.Implementations.Tests/EfMigrations/EfMigrationTests.cs b/tests/Jellyfin.Server.Implementations.Tests/EfMigrations/EfMigrationTests.cs index 78e431be1..3fe2caca7 100644 --- a/tests/Jellyfin.Server.Implementations.Tests/EfMigrations/EfMigrationTests.cs +++ b/tests/Jellyfin.Server.Implementations.Tests/EfMigrations/EfMigrationTests.cs @@ -1,6 +1,3 @@ -using System; -using System.Threading.Tasks; -using Jellyfin.Database.Providers.PgSql; using Jellyfin.Server.Implementations.Migrations; using Microsoft.EntityFrameworkCore; using Xunit; @@ -10,14 +7,6 @@ namespace Jellyfin.Server.Implementations.Tests.EfMigrations; public class EfMigrationTests { [Fact] - public void CheckForUnappliedMigrations_PgSQL() - { - var dbDesignContext = new PgSqlDesignTimeJellyfinDbFactory(); - var context = dbDesignContext.CreateDbContext([]); - Assert.False(context.Database.HasPendingModelChanges(), "There are unapplied changes to the EFCore model for PgSQL. Please create a Migration."); - } - - [Fact] public void CheckForUnappliedMigrations_SqLite() { var dbDesignContext = new SqliteDesignTimeJellyfinDbFactory(); |