diff options
Diffstat (limited to 'Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs')
| -rw-r--r-- | Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs | 514 |
1 files changed, 514 insertions, 0 deletions
diff --git a/Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs b/Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs new file mode 100644 index 000000000..f51e385e0 --- /dev/null +++ b/Jellyfin.Server.Implementations/Migrations/20241009112234_BaseItemRefactor.cs @@ -0,0 +1,514 @@ +using System; +using Microsoft.EntityFrameworkCore.Migrations; + +#nullable disable + +namespace Jellyfin.Server.Implementations.Migrations +{ + /// <inheritdoc /> + public partial class BaseItemRefactor : Migration + { + /// <inheritdoc /> + protected override void Up(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropIndex( + name: "IX_UserData_Key_UserId", + table: "UserData"); + + migrationBuilder.AddColumn<Guid>( + name: "BaseItemEntityId", + table: "UserData", + type: "TEXT", + nullable: true); + + migrationBuilder.AddPrimaryKey( + name: "PK_UserData", + table: "UserData", + columns: new[] { "Key", "UserId" }); + + migrationBuilder.CreateTable( + name: "BaseItems", + columns: table => new + { + Id = table.Column<Guid>(type: "TEXT", 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: "TEXT", nullable: false), + EndDate = table.Column<DateTime>(type: "TEXT", nullable: false), + ChannelId = table.Column<string>(type: "TEXT", nullable: true), + IsMovie = table.Column<bool>(type: "INTEGER", 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: "INTEGER", 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: "TEXT", 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: "INTEGER", nullable: true), + DateCreated = table.Column<DateTime>(type: "TEXT", nullable: true), + DateModified = table.Column<DateTime>(type: "TEXT", nullable: true), + IsSeries = table.Column<bool>(type: "INTEGER", nullable: false), + EpisodeTitle = table.Column<string>(type: "TEXT", nullable: true), + IsRepeat = table.Column<bool>(type: "INTEGER", nullable: false), + PreferredMetadataLanguage = table.Column<string>(type: "TEXT", nullable: true), + PreferredMetadataCountryCode = table.Column<string>(type: "TEXT", nullable: true), + DateLastRefreshed = table.Column<DateTime>(type: "TEXT", nullable: true), + DateLastSaved = table.Column<DateTime>(type: "TEXT", nullable: true), + IsInMixedFolder = table.Column<bool>(type: "INTEGER", nullable: false), + LockedFields = table.Column<string>(type: "TEXT", nullable: true), + Studios = table.Column<string>(type: "TEXT", nullable: true), + Audio = 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: "INTEGER", nullable: false), + InheritedParentalRatingValue = table.Column<int>(type: "INTEGER", nullable: true), + UnratedType = table.Column<string>(type: "TEXT", nullable: true), + TrailerTypes = 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: "TEXT", 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: "INTEGER", nullable: false), + SeriesName = table.Column<string>(type: "TEXT", nullable: true), + UserDataKey = 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), + Images = 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<string>(type: "TEXT", 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: "INTEGER", nullable: true), + ParentId = table.Column<Guid>(type: "TEXT", nullable: true), + TopParentId = table.Column<Guid>(type: "TEXT", nullable: true), + SeasonId = table.Column<Guid>(type: "TEXT", nullable: true), + SeriesId = table.Column<Guid>(type: "TEXT", nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_BaseItems", x => x.Id); + table.ForeignKey( + name: "FK_BaseItems_BaseItems_ParentId", + column: x => x.ParentId, + principalTable: "BaseItems", + principalColumn: "Id"); + table.ForeignKey( + name: "FK_BaseItems_BaseItems_SeasonId", + column: x => x.SeasonId, + principalTable: "BaseItems", + principalColumn: "Id"); + table.ForeignKey( + name: "FK_BaseItems_BaseItems_SeriesId", + column: x => x.SeriesId, + principalTable: "BaseItems", + principalColumn: "Id"); + table.ForeignKey( + name: "FK_BaseItems_BaseItems_TopParentId", + column: x => x.TopParentId, + principalTable: "BaseItems", + principalColumn: "Id"); + }); + + migrationBuilder.CreateTable( + name: "AncestorIds", + columns: table => new + { + Id = table.Column<Guid>(type: "TEXT", nullable: false), + ItemId = table.Column<Guid>(type: "TEXT", nullable: false), + AncestorIdText = table.Column<string>(type: "TEXT", nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_AncestorIds", x => new { x.ItemId, x.Id }); + table.ForeignKey( + name: "FK_AncestorIds_BaseItems_ItemId", + column: x => x.ItemId, + principalTable: "BaseItems", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.CreateTable( + name: "AttachmentStreamInfos", + columns: table => new + { + ItemId = table.Column<Guid>(type: "TEXT", 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: "BaseItemProviders", + columns: table => new + { + ItemId = table.Column<Guid>(type: "TEXT", 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: "Chapters", + columns: table => new + { + ItemId = table.Column<Guid>(type: "TEXT", nullable: false), + ChapterIndex = table.Column<int>(type: "INTEGER", nullable: false), + StartPositionTicks = table.Column<long>(type: "INTEGER", nullable: false), + Name = table.Column<string>(type: "TEXT", nullable: true), + ImagePath = table.Column<string>(type: "TEXT", nullable: true), + ImageDateModified = table.Column<DateTime>(type: "TEXT", 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: "ItemValues", + columns: table => new + { + ItemId = table.Column<Guid>(type: "TEXT", 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 => new { x.ItemId, x.Type, x.Value }); + table.ForeignKey( + name: "FK_ItemValues_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: "TEXT", nullable: false), + StreamIndex = table.Column<int>(type: "INTEGER", nullable: false), + StreamType = table.Column<string>(type: "TEXT", nullable: true), + 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: "INTEGER", nullable: false), + BitRate = table.Column<int>(type: "INTEGER", nullable: false), + Channels = table.Column<int>(type: "INTEGER", nullable: false), + SampleRate = table.Column<int>(type: "INTEGER", nullable: false), + IsDefault = table.Column<bool>(type: "INTEGER", nullable: false), + IsForced = table.Column<bool>(type: "INTEGER", nullable: false), + IsExternal = table.Column<bool>(type: "INTEGER", nullable: false), + Height = table.Column<int>(type: "INTEGER", nullable: false), + Width = table.Column<int>(type: "INTEGER", nullable: false), + AverageFrameRate = table.Column<float>(type: "REAL", nullable: false), + RealFrameRate = table.Column<float>(type: "REAL", nullable: false), + Level = table.Column<float>(type: "REAL", nullable: false), + PixelFormat = table.Column<string>(type: "TEXT", nullable: true), + BitDepth = table.Column<int>(type: "INTEGER", nullable: false), + IsAnamorphic = table.Column<bool>(type: "INTEGER", nullable: false), + RefFrames = table.Column<int>(type: "INTEGER", nullable: false), + CodecTag = table.Column<string>(type: "TEXT", nullable: false), + Comment = table.Column<string>(type: "TEXT", nullable: false), + NalLengthSize = table.Column<string>(type: "TEXT", nullable: false), + IsAvc = table.Column<bool>(type: "INTEGER", nullable: false), + Title = table.Column<string>(type: "TEXT", nullable: false), + TimeBase = table.Column<string>(type: "TEXT", nullable: false), + CodecTimeBase = table.Column<string>(type: "TEXT", nullable: false), + ColorPrimaries = table.Column<string>(type: "TEXT", nullable: false), + ColorSpace = table.Column<string>(type: "TEXT", nullable: false), + ColorTransfer = table.Column<string>(type: "TEXT", nullable: false), + DvVersionMajor = table.Column<int>(type: "INTEGER", nullable: false), + DvVersionMinor = table.Column<int>(type: "INTEGER", nullable: false), + DvProfile = table.Column<int>(type: "INTEGER", nullable: false), + DvLevel = table.Column<int>(type: "INTEGER", nullable: false), + RpuPresentFlag = table.Column<int>(type: "INTEGER", nullable: false), + ElPresentFlag = table.Column<int>(type: "INTEGER", nullable: false), + BlPresentFlag = table.Column<int>(type: "INTEGER", nullable: false), + DvBlSignalCompatibilityId = table.Column<int>(type: "INTEGER", nullable: false), + IsHearingImpaired = table.Column<bool>(type: "INTEGER", nullable: false), + Rotation = table.Column<int>(type: "INTEGER", nullable: false), + 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: "Peoples", + columns: table => new + { + ItemId = table.Column<Guid>(type: "TEXT", nullable: false), + Role = table.Column<string>(type: "TEXT", nullable: false), + ListOrder = table.Column<int>(type: "INTEGER", nullable: false), + Name = table.Column<string>(type: "TEXT", nullable: false), + PersonType = table.Column<string>(type: "TEXT", nullable: true), + SortOrder = table.Column<int>(type: "INTEGER", nullable: true) + }, + constraints: table => + { + table.PrimaryKey("PK_Peoples", x => new { x.ItemId, x.Role, x.ListOrder }); + table.ForeignKey( + name: "FK_Peoples_BaseItems_ItemId", + column: x => x.ItemId, + principalTable: "BaseItems", + principalColumn: "Id", + onDelete: ReferentialAction.Cascade); + }); + + migrationBuilder.CreateIndex( + name: "IX_UserData_BaseItemEntityId", + table: "UserData", + column: "BaseItemEntityId"); + + migrationBuilder.CreateIndex( + name: "IX_AncestorIds_Id", + table: "AncestorIds", + column: "Id"); + + migrationBuilder.CreateIndex( + name: "IX_AncestorIds_ItemId_AncestorIdText", + table: "AncestorIds", + columns: new[] { "ItemId", "AncestorIdText" }); + + 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_PresentationUniqueKey_DateCreated", + table: "BaseItems", + columns: new[] { "IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated" }); + + migrationBuilder.CreateIndex( + name: "IX_BaseItems_MediaType_TopParentId_IsVirtualItem_PresentationUniqueKey", + 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_SeasonId", + table: "BaseItems", + column: "SeasonId"); + + migrationBuilder.CreateIndex( + name: "IX_BaseItems_SeriesId", + table: "BaseItems", + column: "SeriesId"); + + migrationBuilder.CreateIndex( + name: "IX_BaseItems_TopParentId_Id", + table: "BaseItems", + columns: new[] { "TopParentId", "Id" }); + + migrationBuilder.CreateIndex( + name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_IsFolder_IsVirtualItem", + table: "BaseItems", + columns: new[] { "Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem" }); + + migrationBuilder.CreateIndex( + name: "IX_BaseItems_Type_SeriesPresentationUniqueKey_PresentationUniqueKey_SortName", + 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_PresentationUniqueKey_DateCreated", + 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_BaseItems_UserDataKey_Type", + table: "BaseItems", + columns: new[] { "UserDataKey", "Type" }); + + migrationBuilder.CreateIndex( + name: "IX_ItemValues_ItemId_Type_CleanValue", + table: "ItemValues", + columns: new[] { "ItemId", "Type", "CleanValue" }); + + 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_Peoples_ItemId_ListOrder", + table: "Peoples", + columns: new[] { "ItemId", "ListOrder" }); + + migrationBuilder.CreateIndex( + name: "IX_Peoples_Name", + table: "Peoples", + column: "Name"); + + migrationBuilder.AddForeignKey( + name: "FK_UserData_BaseItems_BaseItemEntityId", + table: "UserData", + column: "BaseItemEntityId", + principalTable: "BaseItems", + principalColumn: "Id"); + } + + /// <inheritdoc /> + protected override void Down(MigrationBuilder migrationBuilder) + { + migrationBuilder.DropForeignKey( + name: "FK_UserData_BaseItems_BaseItemEntityId", + table: "UserData"); + + migrationBuilder.DropTable( + name: "AncestorIds"); + + migrationBuilder.DropTable( + name: "AttachmentStreamInfos"); + + migrationBuilder.DropTable( + name: "BaseItemProviders"); + + migrationBuilder.DropTable( + name: "Chapters"); + + migrationBuilder.DropTable( + name: "ItemValues"); + + migrationBuilder.DropTable( + name: "MediaStreamInfos"); + + migrationBuilder.DropTable( + name: "Peoples"); + + migrationBuilder.DropTable( + name: "BaseItems"); + + migrationBuilder.DropPrimaryKey( + name: "PK_UserData", + table: "UserData"); + + migrationBuilder.DropIndex( + name: "IX_UserData_BaseItemEntityId", + table: "UserData"); + + migrationBuilder.DropColumn( + name: "BaseItemEntityId", + table: "UserData"); + + migrationBuilder.CreateIndex( + name: "IX_UserData_Key_UserId", + table: "UserData", + columns: new[] { "Key", "UserId" }, + unique: true); + } + } +} |