Jellyfin.Server.Implementations.Migrations.AddPrimaryVersionIdIndex - Jellyfin

Class:	Jellyfin.Server.Implementations.Migrations.AddPrimaryVersionIdIndex
Assembly:	Jellyfin.Database.Providers.Sqlite
File(s):	File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260724185102_AddPrimaryVersionIdIndex.cs File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260724185102_AddPrimaryVersionIdIndex.Designer.cs

Covered lines:	1738
Uncovered lines:	4
Coverable lines:	1742
Total lines:	1841
Line coverage:	99.7%

Covered branches:	0
Total branches:	0
Branch coverage:	N/A

Method	Branch coverage	Crap Score	Cyclomatic complexity	Line coverage
File 1: Up(...)	100%	1	1	100%
File 1: Down(...)	100%	2	1	0%
File 2: BuildTargetModel(...)	100%	1	1	100%

#	Line	Line coverage
	`1`	`// <auto-generated />`
	`2`	`using System;`
	`3`	`using Jellyfin.Database.Implementations;`
	`4`	`using Microsoft.EntityFrameworkCore;`
	`5`	`using Microsoft.EntityFrameworkCore.Infrastructure;`
	`6`	`using Microsoft.EntityFrameworkCore.Migrations;`
	`7`	`using Microsoft.EntityFrameworkCore.Storage.ValueConversion;`
	`8`
	`9`	`#nullable disable`
	`10`
	`11`	`namespace Jellyfin.Server.Implementations.Migrations`
	`12`	`{`
	`13`	`[DbContext(typeof(JellyfinDbContext))]`
	`14`	`[Migration("20260724185102_AddPrimaryVersionIdIndex")]`
	`15`	`partial class AddPrimaryVersionIdIndex`
	`16`	`{`
	`17`	`/// <inheritdoc />`
	`18`	`protected override void BuildTargetModel(ModelBuilder modelBuilder)`
	`19`	`{`
	`20`	`#pragma warning disable 612, 618`
22	`21`	`modelBuilder.HasAnnotation("ProductVersion", "10.0.10");`
	`22`
22	`23`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>`
22	`24`	`{`
22	`25`	`b.Property<int>("Id")`
22	`26`	`.ValueGeneratedOnAdd()`
22	`27`	`.HasColumnType("INTEGER");`
22	`28`
22	`29`	`b.Property<int>("DayOfWeek")`
22	`30`	`.HasColumnType("INTEGER");`
22	`31`
22	`32`	`b.Property<double>("EndHour")`
22	`33`	`.HasColumnType("REAL");`
22	`34`
22	`35`	`b.Property<double>("StartHour")`
22	`36`	`.HasColumnType("REAL");`
22	`37`
22	`38`	`b.Property<Guid>("UserId")`
22	`39`	`.HasColumnType("TEXT");`
22	`40`
22	`41`	`b.HasKey("Id");`
22	`42`
22	`43`	`b.HasIndex("UserId");`
22	`44`
22	`45`	`b.ToTable("AccessSchedules");`
22	`46`
22	`47`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`48`	`});`
	`49`
22	`50`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ActivityLog", b =>`
22	`51`	`{`
22	`52`	`b.Property<int>("Id")`
22	`53`	`.ValueGeneratedOnAdd()`
22	`54`	`.HasColumnType("INTEGER");`
22	`55`
22	`56`	`b.Property<DateTime>("DateCreated")`
22	`57`	`.HasColumnType("TEXT");`
22	`58`
22	`59`	`b.Property<string>("ItemId")`
22	`60`	`.HasMaxLength(256)`
22	`61`	`.HasColumnType("TEXT");`
22	`62`
22	`63`	`b.Property<int>("LogSeverity")`
22	`64`	`.HasColumnType("INTEGER");`
22	`65`
22	`66`	`b.Property<string>("Name")`
22	`67`	`.IsRequired()`
22	`68`	`.HasMaxLength(512)`
22	`69`	`.HasColumnType("TEXT");`
22	`70`
22	`71`	`b.Property<string>("Overview")`
22	`72`	`.HasMaxLength(512)`
22	`73`	`.HasColumnType("TEXT");`
22	`74`
22	`75`	`b.Property<uint>("RowVersion")`
22	`76`	`.IsConcurrencyToken()`
22	`77`	`.HasColumnType("INTEGER");`
22	`78`
22	`79`	`b.Property<string>("ShortOverview")`
22	`80`	`.HasMaxLength(512)`
22	`81`	`.HasColumnType("TEXT");`
22	`82`
22	`83`	`b.Property<string>("Type")`
22	`84`	`.IsRequired()`
22	`85`	`.HasMaxLength(256)`
22	`86`	`.HasColumnType("TEXT");`
22	`87`
22	`88`	`b.Property<Guid>("UserId")`
22	`89`	`.HasColumnType("TEXT");`
22	`90`
22	`91`	`b.HasKey("Id");`
22	`92`
22	`93`	`b.HasIndex("DateCreated");`
22	`94`
22	`95`	`b.ToTable("ActivityLogs");`
22	`96`
22	`97`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`98`	`});`
	`99`
22	`100`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>`
22	`101`	`{`
22	`102`	`b.Property<Guid>("ItemId")`
22	`103`	`.HasColumnType("TEXT");`
22	`104`
22	`105`	`b.Property<Guid>("ParentItemId")`
22	`106`	`.HasColumnType("TEXT");`
22	`107`
22	`108`	`b.HasKey("ItemId", "ParentItemId");`
22	`109`
22	`110`	`b.HasIndex("ParentItemId");`
22	`111`
22	`112`	`b.ToTable("AncestorIds");`
22	`113`
22	`114`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`115`	`});`
	`116`
22	`117`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>`
22	`118`	`{`
22	`119`	`b.Property<Guid>("ItemId")`
22	`120`	`.HasColumnType("TEXT");`
22	`121`
22	`122`	`b.Property<int>("Index")`
22	`123`	`.HasColumnType("INTEGER");`
22	`124`
22	`125`	`b.Property<string>("Codec")`
22	`126`	`.HasColumnType("TEXT");`
22	`127`
22	`128`	`b.Property<string>("CodecTag")`
22	`129`	`.HasColumnType("TEXT");`
22	`130`
22	`131`	`b.Property<string>("Comment")`
22	`132`	`.HasColumnType("TEXT");`
22	`133`
22	`134`	`b.Property<string>("Filename")`
22	`135`	`.HasColumnType("TEXT");`
22	`136`
22	`137`	`b.Property<string>("MimeType")`
22	`138`	`.HasColumnType("TEXT");`
22	`139`
22	`140`	`b.HasKey("ItemId", "Index");`
22	`141`
22	`142`	`b.ToTable("AttachmentStreamInfos");`
22	`143`
22	`144`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`145`	`});`
	`146`
22	`147`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>`
22	`148`	`{`
22	`149`	`b.Property<Guid>("Id")`
22	`150`	`.ValueGeneratedOnAdd()`
22	`151`	`.HasColumnType("TEXT");`
22	`152`
22	`153`	`b.Property<string>("Album")`
22	`154`	`.HasColumnType("TEXT");`
22	`155`
22	`156`	`b.Property<string>("AlbumArtists")`
22	`157`	`.HasColumnType("TEXT");`
22	`158`
22	`159`	`b.Property<string>("Artists")`
22	`160`	`.HasColumnType("TEXT");`
22	`161`
22	`162`	`b.Property<int?>("Audio")`
22	`163`	`.HasColumnType("INTEGER");`
22	`164`
22	`165`	`b.Property<Guid?>("ChannelId")`
22	`166`	`.HasColumnType("TEXT");`
22	`167`
22	`168`	`b.Property<string>("CleanName")`
22	`169`	`.HasColumnType("TEXT");`
22	`170`
22	`171`	`b.Property<float?>("CommunityRating")`
22	`172`	`.HasColumnType("REAL");`
22	`173`
22	`174`	`b.Property<float?>("CriticRating")`
22	`175`	`.HasColumnType("REAL");`
22	`176`
22	`177`	`b.Property<string>("CustomRating")`
22	`178`	`.HasColumnType("TEXT");`
22	`179`
22	`180`	`b.Property<string>("Data")`
22	`181`	`.HasColumnType("TEXT");`
22	`182`
22	`183`	`b.Property<DateTime?>("DateCreated")`
22	`184`	`.HasColumnType("TEXT");`
22	`185`
22	`186`	`b.Property<DateTime?>("DateLastMediaAdded")`
22	`187`	`.HasColumnType("TEXT");`
22	`188`
22	`189`	`b.Property<DateTime?>("DateLastRefreshed")`
22	`190`	`.HasColumnType("TEXT");`
22	`191`
22	`192`	`b.Property<DateTime?>("DateLastSaved")`
22	`193`	`.HasColumnType("TEXT");`
22	`194`
22	`195`	`b.Property<DateTime?>("DateModified")`
22	`196`	`.HasColumnType("TEXT");`
22	`197`
22	`198`	`b.Property<DateTime?>("EndDate")`
22	`199`	`.HasColumnType("TEXT");`
22	`200`
22	`201`	`b.Property<string>("EpisodeTitle")`
22	`202`	`.HasColumnType("TEXT");`
22	`203`
22	`204`	`b.Property<string>("ExternalId")`
22	`205`	`.HasColumnType("TEXT");`
22	`206`
22	`207`	`b.Property<string>("ExternalSeriesId")`
22	`208`	`.HasColumnType("TEXT");`
22	`209`
22	`210`	`b.Property<string>("ExternalServiceId")`
22	`211`	`.HasColumnType("TEXT");`
22	`212`
22	`213`	`b.Property<int?>("ExtraType")`
22	`214`	`.HasColumnType("INTEGER");`
22	`215`
22	`216`	`b.Property<string>("ForcedSortName")`
22	`217`	`.HasColumnType("TEXT");`
22	`218`
22	`219`	`b.Property<string>("Genres")`
22	`220`	`.HasColumnType("TEXT");`
22	`221`
22	`222`	`b.Property<int?>("Height")`
22	`223`	`.HasColumnType("INTEGER");`
22	`224`
22	`225`	`b.Property<int?>("IndexNumber")`
22	`226`	`.HasColumnType("INTEGER");`
22	`227`
22	`228`	`b.Property<int?>("InheritedParentalRatingSubValue")`
22	`229`	`.HasColumnType("INTEGER");`
22	`230`
22	`231`	`b.Property<int?>("InheritedParentalRatingValue")`
22	`232`	`.HasColumnType("INTEGER");`
22	`233`
22	`234`	`b.Property<bool>("IsFolder")`
22	`235`	`.HasColumnType("INTEGER");`
22	`236`
22	`237`	`b.Property<bool>("IsInMixedFolder")`
22	`238`	`.HasColumnType("INTEGER");`
22	`239`
22	`240`	`b.Property<bool>("IsLocked")`
22	`241`	`.HasColumnType("INTEGER");`
22	`242`
22	`243`	`b.Property<bool>("IsMovie")`
22	`244`	`.HasColumnType("INTEGER");`
22	`245`
22	`246`	`b.Property<bool>("IsRepeat")`
22	`247`	`.HasColumnType("INTEGER");`
22	`248`
22	`249`	`b.Property<bool>("IsSeries")`
22	`250`	`.HasColumnType("INTEGER");`
22	`251`
22	`252`	`b.Property<bool>("IsVirtualItem")`
22	`253`	`.HasColumnType("INTEGER");`
22	`254`
22	`255`	`b.Property<float?>("LUFS")`
22	`256`	`.HasColumnType("REAL");`
22	`257`
22	`258`	`b.Property<string>("MediaType")`
22	`259`	`.HasColumnType("TEXT");`
22	`260`
22	`261`	`b.Property<string>("Name")`
22	`262`	`.HasColumnType("TEXT");`
22	`263`
22	`264`	`b.Property<float?>("NormalizationGain")`
22	`265`	`.HasColumnType("REAL");`
22	`266`
22	`267`	`b.Property<string>("OfficialRating")`
22	`268`	`.HasColumnType("TEXT");`
22	`269`
22	`270`	`b.Property<string>("OriginalLanguage")`
22	`271`	`.HasColumnType("TEXT");`
22	`272`
22	`273`	`b.Property<string>("OriginalTitle")`
22	`274`	`.HasColumnType("TEXT");`
22	`275`
22	`276`	`b.Property<string>("Overview")`
22	`277`	`.HasColumnType("TEXT");`
22	`278`
22	`279`	`b.Property<Guid?>("OwnerId")`
22	`280`	`.HasColumnType("TEXT");`
22	`281`
22	`282`	`b.Property<Guid?>("ParentId")`
22	`283`	`.HasColumnType("TEXT");`
22	`284`
22	`285`	`b.Property<int?>("ParentIndexNumber")`
22	`286`	`.HasColumnType("INTEGER");`
22	`287`
22	`288`	`b.Property<string>("Path")`
22	`289`	`.HasColumnType("TEXT");`
22	`290`
22	`291`	`b.Property<string>("PreferredMetadataCountryCode")`
22	`292`	`.HasColumnType("TEXT");`
22	`293`
22	`294`	`b.Property<string>("PreferredMetadataLanguage")`
22	`295`	`.HasColumnType("TEXT");`
22	`296`
22	`297`	`b.Property<DateTime?>("PremiereDate")`
22	`298`	`.HasColumnType("TEXT");`
22	`299`
22	`300`	`b.Property<string>("PresentationUniqueKey")`
22	`301`	`.HasColumnType("TEXT");`
22	`302`
22	`303`	`b.Property<Guid?>("PrimaryVersionId")`
22	`304`	`.HasColumnType("TEXT");`
22	`305`
22	`306`	`b.Property<string>("ProductionLocations")`
22	`307`	`.HasColumnType("TEXT");`
22	`308`
22	`309`	`b.Property<int?>("ProductionYear")`
22	`310`	`.HasColumnType("INTEGER");`
22	`311`
22	`312`	`b.Property<long?>("RunTimeTicks")`
22	`313`	`.HasColumnType("INTEGER");`
22	`314`
22	`315`	`b.Property<Guid?>("SeasonId")`
22	`316`	`.HasColumnType("TEXT");`
22	`317`
22	`318`	`b.Property<string>("SeasonName")`
22	`319`	`.HasColumnType("TEXT");`
22	`320`
22	`321`	`b.Property<Guid?>("SeriesId")`
22	`322`	`.HasColumnType("TEXT");`
22	`323`
22	`324`	`b.Property<string>("SeriesName")`
22	`325`	`.HasColumnType("TEXT");`
22	`326`
22	`327`	`b.Property<string>("SeriesPresentationUniqueKey")`
22	`328`	`.HasColumnType("TEXT");`
22	`329`
22	`330`	`b.Property<string>("ShowId")`
22	`331`	`.HasColumnType("TEXT");`
22	`332`
22	`333`	`b.Property<long?>("Size")`
22	`334`	`.HasColumnType("INTEGER");`
22	`335`
22	`336`	`b.Property<string>("SortName")`
22	`337`	`.HasColumnType("TEXT");`
22	`338`
22	`339`	`b.Property<DateTime?>("StartDate")`
22	`340`	`.HasColumnType("TEXT");`
22	`341`
22	`342`	`b.Property<string>("Studios")`
22	`343`	`.HasColumnType("TEXT");`
22	`344`
22	`345`	`b.Property<string>("Tagline")`
22	`346`	`.HasColumnType("TEXT");`
22	`347`
22	`348`	`b.Property<string>("Tags")`
22	`349`	`.HasColumnType("TEXT");`
22	`350`
22	`351`	`b.Property<Guid?>("TopParentId")`
22	`352`	`.HasColumnType("TEXT");`
22	`353`
22	`354`	`b.Property<int?>("TotalBitrate")`
22	`355`	`.HasColumnType("INTEGER");`
22	`356`
22	`357`	`b.Property<string>("Type")`
22	`358`	`.IsRequired()`
22	`359`	`.HasColumnType("TEXT");`
22	`360`
22	`361`	`b.Property<string>("UnratedType")`
22	`362`	`.HasColumnType("TEXT");`
22	`363`
22	`364`	`b.Property<int?>("Width")`
22	`365`	`.HasColumnType("INTEGER");`
22	`366`
22	`367`	`b.HasKey("Id");`
22	`368`
22	`369`	`b.HasIndex("Name");`
22	`370`
22	`371`	`b.HasIndex("OwnerId");`
22	`372`
22	`373`	`b.HasIndex("ParentId");`
22	`374`
22	`375`	`b.HasIndex("Path");`
22	`376`
22	`377`	`b.HasIndex("PresentationUniqueKey");`
22	`378`
22	`379`	`b.HasIndex("PrimaryVersionId")`
22	`380`	`.HasFilter("\"PrimaryVersionId\" IS NOT NULL");`
22	`381`
22	`382`	`b.HasIndex("SeasonId");`
22	`383`
22	`384`	`b.HasIndex("SeriesId");`
22	`385`
22	`386`	`b.HasIndex("SeriesName");`
22	`387`
22	`388`	`b.HasIndex("ExtraType", "OwnerId");`
22	`389`
22	`390`	`b.HasIndex("TopParentId", "Id");`
22	`391`
22	`392`	`b.HasIndex("Type", "CleanName");`
22	`393`
22	`394`	`b.HasIndex("TopParentId", "Type", "IsVirtualItem")`
22	`395`	`.HasFilter("\"PrimaryVersionId\" IS NULL AND (\"OwnerId\" IS NULL OR \"ExtraType\" IS NOT NULL)"`
22	`396`
22	`397`	`b.HasIndex("Type", "TopParentId", "Id");`
22	`398`
22	`399`	`b.HasIndex("Type", "TopParentId", "PresentationUniqueKey");`
22	`400`
22	`401`	`b.HasIndex("Type", "TopParentId", "SortName");`
22	`402`
22	`403`	`b.HasIndex("Type", "TopParentId", "StartDate");`
22	`404`
22	`405`	`b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey");`
22	`406`
22	`407`	`b.HasIndex("TopParentId", "IsFolder", "IsVirtualItem", "DateCreated");`
22	`408`
22	`409`	`b.HasIndex("TopParentId", "MediaType", "IsVirtualItem", "DateCreated");`
22	`410`
22	`411`	`b.HasIndex("TopParentId", "Type", "IsVirtualItem", "DateCreated");`
22	`412`
22	`413`	`b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem");`
22	`414`
22	`415`	`b.HasIndex("Type", "SeriesPresentationUniqueKey", "ParentIndexNumber", "IndexNumber");`
22	`416`
22	`417`	`b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName");`
22	`418`
22	`419`	`b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");`
22	`420`
22	`421`	`b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");`
22	`422`
22	`423`	`b.ToTable("BaseItems");`
22	`424`
22	`425`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`426`
22	`427`	`b.HasData(`
22	`428`	`new`
22	`429`	`{`
22	`430`	`Id = new Guid("00000000-0000-0000-0000-000000000001"),`
22	`431`	`IsFolder = false,`
22	`432`	`IsInMixedFolder = false,`
22	`433`	`IsLocked = false,`
22	`434`	`IsMovie = false,`
22	`435`	`IsRepeat = false,`
22	`436`	`IsSeries = false,`
22	`437`	`IsVirtualItem = false,`
22	`438`	`Name = "This is a placeholder item for UserData that has been detached from its original ite`
22	`439`	`Type = "PLACEHOLDER"`
22	`440`	`});`
22	`441`	`});`
	`442`
22	`443`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>`
22	`444`	`{`
22	`445`	`b.Property<Guid>("Id")`
22	`446`	`.ValueGeneratedOnAdd()`
22	`447`	`.HasColumnType("TEXT");`
22	`448`
22	`449`	`b.Property<byte[]>("Blurhash")`
22	`450`	`.HasColumnType("BLOB");`
22	`451`
22	`452`	`b.Property<DateTime?>("DateModified")`
22	`453`	`.HasColumnType("TEXT");`
22	`454`
22	`455`	`b.Property<int>("Height")`
22	`456`	`.HasColumnType("INTEGER");`
22	`457`
22	`458`	`b.Property<int>("ImageType")`
22	`459`	`.HasColumnType("INTEGER");`
22	`460`
22	`461`	`b.Property<Guid>("ItemId")`
22	`462`	`.HasColumnType("TEXT");`
22	`463`
22	`464`	`b.Property<string>("Path")`
22	`465`	`.IsRequired()`
22	`466`	`.HasColumnType("TEXT");`
22	`467`
22	`468`	`b.Property<int>("Width")`
22	`469`	`.HasColumnType("INTEGER");`
22	`470`
22	`471`	`b.HasKey("Id");`
22	`472`
22	`473`	`b.HasIndex("ItemId", "ImageType");`
22	`474`
22	`475`	`b.ToTable("BaseItemImageInfos");`
22	`476`
22	`477`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`478`	`});`
	`479`
22	`480`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>`
22	`481`	`{`
22	`482`	`b.Property<int>("Id")`
22	`483`	`.HasColumnType("INTEGER");`
22	`484`
22	`485`	`b.Property<Guid>("ItemId")`
22	`486`	`.HasColumnType("TEXT");`
22	`487`
22	`488`	`b.HasKey("Id", "ItemId");`
22	`489`
22	`490`	`b.HasIndex("ItemId");`
22	`491`
22	`492`	`b.ToTable("BaseItemMetadataFields");`
22	`493`
22	`494`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`495`	`});`
	`496`
22	`497`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>`
22	`498`	`{`
22	`499`	`b.Property<Guid>("ItemId")`
22	`500`	`.HasColumnType("TEXT");`

22

21

modelBuilder.HasAnnotation("ProductVersion", "10.0.10");

22

23

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>

22

24

{

22

25

b.Property<int>("Id")

22

26

.ValueGeneratedOnAdd()

22

27

.HasColumnType("INTEGER");

22

28

22

29

b.Property<int>("DayOfWeek")

22

30

.HasColumnType("INTEGER");

22

31

22

32

b.Property<double>("EndHour")

22

33

.HasColumnType("REAL");

22

34

22

35

b.Property<double>("StartHour")

22

36

.HasColumnType("REAL");

22

37

22

38

b.Property<Guid>("UserId")

22

39

.HasColumnType("TEXT");

22

40

22

41

b.HasKey("Id");

22

42

22

43

b.HasIndex("UserId");

22

44

22

45

b.ToTable("AccessSchedules");

22

46

22

47

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

48

});

22

50

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ActivityLog", b =>

22

51

{

22

52

b.Property<int>("Id")

22

53

.ValueGeneratedOnAdd()

22

54

.HasColumnType("INTEGER");

22

55

22

56

b.Property<DateTime>("DateCreated")

22

57

.HasColumnType("TEXT");

22

58

22

59

b.Property<string>("ItemId")

22

60

.HasMaxLength(256)

22

61

.HasColumnType("TEXT");

22

62

22

63

b.Property<int>("LogSeverity")

22

64

.HasColumnType("INTEGER");

22

65

22

66

b.Property<string>("Name")

22

67

.IsRequired()

22

68

.HasMaxLength(512)

22

69

.HasColumnType("TEXT");

22

70

22

71

b.Property<string>("Overview")

22

72

.HasMaxLength(512)

22

73

.HasColumnType("TEXT");

22

74

22

75

b.Property<uint>("RowVersion")

22

76

.IsConcurrencyToken()

22

77

.HasColumnType("INTEGER");

22

78

22

79

b.Property<string>("ShortOverview")

22

80

.HasMaxLength(512)

22

81

.HasColumnType("TEXT");

22

82

22

83

b.Property<string>("Type")

22

84

.IsRequired()

22

85

.HasMaxLength(256)

22

86

.HasColumnType("TEXT");

22

87

22

88

b.Property<Guid>("UserId")

22

89

.HasColumnType("TEXT");

22

90

22

91

b.HasKey("Id");

22

92

22

93

b.HasIndex("DateCreated");

22

94

22

95

b.ToTable("ActivityLogs");

22

96

22

97

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

98

});

22

100

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>

22

101

{

22

102

b.Property<Guid>("ItemId")

22

103

.HasColumnType("TEXT");

22

104

22

105

b.Property<Guid>("ParentItemId")

22

106

.HasColumnType("TEXT");

22

107

22

108

b.HasKey("ItemId", "ParentItemId");

22

109

22

110

b.HasIndex("ParentItemId");

22

111

22

112

b.ToTable("AncestorIds");

22

113

22

114

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

115

});

22

117

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>

22

118

{

22

119

b.Property<Guid>("ItemId")

22

120

.HasColumnType("TEXT");

22

121

22

122

b.Property<int>("Index")

22

123

.HasColumnType("INTEGER");

22

124

22

125

b.Property<string>("Codec")

22

126

.HasColumnType("TEXT");

22

127

22

128

b.Property<string>("CodecTag")

22

129

.HasColumnType("TEXT");

22

130

22

131

b.Property<string>("Comment")

22

132

.HasColumnType("TEXT");

22

133

22

134

b.Property<string>("Filename")

22

135

.HasColumnType("TEXT");

22

136

22

137

b.Property<string>("MimeType")

22

138

.HasColumnType("TEXT");

22

139

22

140

b.HasKey("ItemId", "Index");

22

141

22

142

b.ToTable("AttachmentStreamInfos");

22

143

22

144

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

145

});

22

147

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>

22

148

{

22

149

b.Property<Guid>("Id")

22

150

.ValueGeneratedOnAdd()

22

151

.HasColumnType("TEXT");

22

152

22

153

b.Property<string>("Album")

22

154

.HasColumnType("TEXT");

22

155

22

156

b.Property<string>("AlbumArtists")

22

157

.HasColumnType("TEXT");

22

158

22

159

b.Property<string>("Artists")

22

160

.HasColumnType("TEXT");

22

161

22

162

b.Property<int?>("Audio")

22

163

.HasColumnType("INTEGER");

22

164

22

165

b.Property<Guid?>("ChannelId")

22

166

.HasColumnType("TEXT");

22

167

22

168

b.Property<string>("CleanName")

22

169

.HasColumnType("TEXT");

22

170

22

171

b.Property<float?>("CommunityRating")

22

172

.HasColumnType("REAL");

22

173

22

174

b.Property<float?>("CriticRating")

22

175

.HasColumnType("REAL");

22

176

22

177

b.Property<string>("CustomRating")

22

178

.HasColumnType("TEXT");

22

179

22

180

b.Property<string>("Data")

22

181

.HasColumnType("TEXT");

22

182

22

183

b.Property<DateTime?>("DateCreated")

22

184

.HasColumnType("TEXT");

22

185

22

186

b.Property<DateTime?>("DateLastMediaAdded")

22

187

.HasColumnType("TEXT");

22

188

22

189

b.Property<DateTime?>("DateLastRefreshed")

22

190

.HasColumnType("TEXT");

22

191

22

192

b.Property<DateTime?>("DateLastSaved")

22

193

.HasColumnType("TEXT");

22

194

22

195

b.Property<DateTime?>("DateModified")

22

196

.HasColumnType("TEXT");

22

197

22

198

b.Property<DateTime?>("EndDate")

22

199

.HasColumnType("TEXT");

22

200

22

201

b.Property<string>("EpisodeTitle")

22

202

.HasColumnType("TEXT");

22

203

22

204

b.Property<string>("ExternalId")

22

205

.HasColumnType("TEXT");

22

206

22

207

b.Property<string>("ExternalSeriesId")

22

208

.HasColumnType("TEXT");

22

209

22

210

b.Property<string>("ExternalServiceId")

22

211

.HasColumnType("TEXT");

22

212

22

213

b.Property<int?>("ExtraType")

22

214

.HasColumnType("INTEGER");

22

215

22

216

b.Property<string>("ForcedSortName")

22

217

.HasColumnType("TEXT");

22

218

22

219

b.Property<string>("Genres")

22

220

.HasColumnType("TEXT");

22

221

22

222

b.Property<int?>("Height")

22

223

.HasColumnType("INTEGER");

22

224

22

225

b.Property<int?>("IndexNumber")

22

226

.HasColumnType("INTEGER");

22

227

22

228

b.Property<int?>("InheritedParentalRatingSubValue")

22

229

.HasColumnType("INTEGER");

22

230

22

231

b.Property<int?>("InheritedParentalRatingValue")

22

232

.HasColumnType("INTEGER");

22

233

22

234

b.Property<bool>("IsFolder")

22

235

.HasColumnType("INTEGER");

22

236

22

237

b.Property<bool>("IsInMixedFolder")

22

238

.HasColumnType("INTEGER");

22

239

22

240

b.Property<bool>("IsLocked")

22

241

.HasColumnType("INTEGER");

22

242

22

243

b.Property<bool>("IsMovie")

22

244

.HasColumnType("INTEGER");

22

245

22

246

b.Property<bool>("IsRepeat")

22

247

.HasColumnType("INTEGER");

22

248

22

249

b.Property<bool>("IsSeries")

22

250

.HasColumnType("INTEGER");

22

251

22

252

b.Property<bool>("IsVirtualItem")

22

253

.HasColumnType("INTEGER");

22

254

22

255

b.Property<float?>("LUFS")

22

256

.HasColumnType("REAL");

22

257

22

258

b.Property<string>("MediaType")

22

259

.HasColumnType("TEXT");

22

260

22

261

b.Property<string>("Name")

22

262

.HasColumnType("TEXT");

22

263

22

264

b.Property<float?>("NormalizationGain")

22

265

.HasColumnType("REAL");

22

266

22

267

b.Property<string>("OfficialRating")

22

268

.HasColumnType("TEXT");

22

269

22

270

b.Property<string>("OriginalLanguage")

22

271

.HasColumnType("TEXT");

22

272

22

273

b.Property<string>("OriginalTitle")

22

274

.HasColumnType("TEXT");

22

275

22

276

b.Property<string>("Overview")

22

277

.HasColumnType("TEXT");

22

278

22

279

b.Property<Guid?>("OwnerId")

22

280

.HasColumnType("TEXT");

22

281

22

282

b.Property<Guid?>("ParentId")

22

283

.HasColumnType("TEXT");

22

284

22

285

b.Property<int?>("ParentIndexNumber")

22

286

.HasColumnType("INTEGER");

22

287

22

288

b.Property<string>("Path")

22

289

.HasColumnType("TEXT");

22

290

22

291

b.Property<string>("PreferredMetadataCountryCode")

22

292

.HasColumnType("TEXT");

22

293

22

294

b.Property<string>("PreferredMetadataLanguage")

22

295

.HasColumnType("TEXT");

22

296

22

297

b.Property<DateTime?>("PremiereDate")

22

298

.HasColumnType("TEXT");

22

299

22

300

b.Property<string>("PresentationUniqueKey")

22

301

.HasColumnType("TEXT");

22

302

22

303

b.Property<Guid?>("PrimaryVersionId")

22

304

.HasColumnType("TEXT");

22

305

22

306

b.Property<string>("ProductionLocations")

22

307

.HasColumnType("TEXT");

22

308

22

309

b.Property<int?>("ProductionYear")

22

310

.HasColumnType("INTEGER");

22

311

22

312

b.Property<long?>("RunTimeTicks")

22

313

.HasColumnType("INTEGER");

22

314

22

315

b.Property<Guid?>("SeasonId")

22

316

.HasColumnType("TEXT");

22

317

22

318

b.Property<string>("SeasonName")

22

319

.HasColumnType("TEXT");

22

320

22

321

b.Property<Guid?>("SeriesId")

22

322

.HasColumnType("TEXT");

22

323

22

324

b.Property<string>("SeriesName")

22

325

.HasColumnType("TEXT");

22

326

22

327

b.Property<string>("SeriesPresentationUniqueKey")

22

328

.HasColumnType("TEXT");

22

329

22

330

b.Property<string>("ShowId")

22

331

.HasColumnType("TEXT");

22

332

22

333

b.Property<long?>("Size")

22

334

.HasColumnType("INTEGER");

22

335

22

336

b.Property<string>("SortName")

22

337

.HasColumnType("TEXT");

22

338

22

339

b.Property<DateTime?>("StartDate")

22

340

.HasColumnType("TEXT");

22

341

22

342

b.Property<string>("Studios")

22

343

.HasColumnType("TEXT");

22

344

22

345

b.Property<string>("Tagline")

22

346

.HasColumnType("TEXT");

22

347

22

348

b.Property<string>("Tags")

22

349

.HasColumnType("TEXT");

22

350

22

351

b.Property<Guid?>("TopParentId")

22

352

.HasColumnType("TEXT");

22

353

22

354

b.Property<int?>("TotalBitrate")

22

355

.HasColumnType("INTEGER");

22

356

22

357

b.Property<string>("Type")

22

358

.IsRequired()

22

359

.HasColumnType("TEXT");

22

360

22

361

b.Property<string>("UnratedType")

22

362

.HasColumnType("TEXT");

22

363

22

364

b.Property<int?>("Width")

22

365

.HasColumnType("INTEGER");

22

366

22

367

b.HasKey("Id");

22

368

22

369

b.HasIndex("Name");

22

370

22

371

b.HasIndex("OwnerId");

22

372

22

373

b.HasIndex("ParentId");

22

374

22

375

b.HasIndex("Path");

22

376

22

377

b.HasIndex("PresentationUniqueKey");

22

378

22

379

b.HasIndex("PrimaryVersionId")

22

380

.HasFilter("\"PrimaryVersionId\" IS NOT NULL");

22

381

22

382

b.HasIndex("SeasonId");

22

383

22

384

b.HasIndex("SeriesId");

22

385

22

386

b.HasIndex("SeriesName");

22

387

22

388

b.HasIndex("ExtraType", "OwnerId");

22

389

22

390

b.HasIndex("TopParentId", "Id");

22

391

22

392

b.HasIndex("Type", "CleanName");

22

393

22

394

b.HasIndex("TopParentId", "Type", "IsVirtualItem")

22

395

                        .HasFilter("\"PrimaryVersionId\" IS NULL AND (\"OwnerId\" IS NULL OR \"ExtraType\" IS NOT NULL)"

22

396

22

397

b.HasIndex("Type", "TopParentId", "Id");

22

398

22

399

b.HasIndex("Type", "TopParentId", "PresentationUniqueKey");

22

400

22

401

b.HasIndex("Type", "TopParentId", "SortName");

22

402

22

403

b.HasIndex("Type", "TopParentId", "StartDate");

22

404

22

405

                    b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey");

22

406

22

407

b.HasIndex("TopParentId", "IsFolder", "IsVirtualItem", "DateCreated");

22

408

22

409

b.HasIndex("TopParentId", "MediaType", "IsVirtualItem", "DateCreated");

22

410

22

411

b.HasIndex("TopParentId", "Type", "IsVirtualItem", "DateCreated");

22

412

22

413

                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem");

22

414

22

415

                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "ParentIndexNumber", "IndexNumber");

22

416

22

417

                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName");

22

418

22

419

                    b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");

22

420

22

421

                    b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");

22

422

22

423

b.ToTable("BaseItems");

22

424

22

425

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

426

22

427

b.HasData(

22

428

new

22

429

{

22

430

Id = new Guid("00000000-0000-0000-0000-000000000001"),

22

431

IsFolder = false,

22

432

IsInMixedFolder = false,

22

433

IsLocked = false,

22

434

IsMovie = false,

22

435

IsRepeat = false,

22

436

IsSeries = false,

22

437

IsVirtualItem = false,

22

438

                            Name = "This is a placeholder item for UserData that has been detached from its original ite

22

439

Type = "PLACEHOLDER"

22

440

});

22

441

});

22

443

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>

22

444

{

22

445

b.Property<Guid>("Id")

22

446

.ValueGeneratedOnAdd()

22

447

.HasColumnType("TEXT");

22

448

22

449

b.Property<byte[]>("Blurhash")

22

450

.HasColumnType("BLOB");

22

451

22

452

b.Property<DateTime?>("DateModified")

22

453

.HasColumnType("TEXT");

22

454

22

455

b.Property<int>("Height")

22

456

.HasColumnType("INTEGER");

22

457

22

458

b.Property<int>("ImageType")

22

459

.HasColumnType("INTEGER");

22

460

22

461

b.Property<Guid>("ItemId")

22

462

.HasColumnType("TEXT");

22

463

22

464

b.Property<string>("Path")

22

465

.IsRequired()

22

466

.HasColumnType("TEXT");

22

467

22

468

b.Property<int>("Width")

22

469

.HasColumnType("INTEGER");

22

470

22

471

b.HasKey("Id");

22

472

22

473

b.HasIndex("ItemId", "ImageType");

22

474

22

475

b.ToTable("BaseItemImageInfos");

22

476

22

477

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

478

});

22

480

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>

22

481

{

22

482

b.Property<int>("Id")

22

483

.HasColumnType("INTEGER");

22

484

22

485

b.Property<Guid>("ItemId")

22

486

.HasColumnType("TEXT");

22

487

22

488

b.HasKey("Id", "ItemId");

22

489

22

490

b.HasIndex("ItemId");

22

491

22

492

b.ToTable("BaseItemMetadataFields");

22

493

22

494

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

495

});

22

497

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>

22

498

{

22

499

b.Property<Guid>("ItemId")

22

500

.HasColumnType("TEXT");

22

501

22

502

b.Property<string>("ProviderId")

22

503

.HasColumnType("TEXT");

22

504

22

505

b.Property<string>("ProviderValue")

22

506

.IsRequired()

22

507

.HasColumnType("TEXT");

22

508

22

509

b.HasKey("ItemId", "ProviderId");

22

510

22

511

b.HasIndex("ProviderId", "ItemId", "ProviderValue");

22

512

22

513

b.ToTable("BaseItemProviders");

22

514

22

515

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

516

});

22

518

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>

22

519

{

22

520

b.Property<int>("Id")

22

521

.HasColumnType("INTEGER");

22

522

22

523

b.Property<Guid>("ItemId")

22

524

.HasColumnType("TEXT");

22

525

22

526

b.HasKey("Id", "ItemId");

22

527

22

528

b.HasIndex("ItemId");

22

529

22

530

b.ToTable("BaseItemTrailerTypes");

22

531

22

532

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

533

});

22

535

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>

22

536

{

22

537

b.Property<Guid>("ItemId")

22

538

.HasColumnType("TEXT");

22

539

22

540

b.Property<int>("ChapterIndex")

22

541

.HasColumnType("INTEGER");

22

542

22

543

b.Property<DateTime?>("ImageDateModified")

22

544

.HasColumnType("TEXT");

22

545

22

546

b.Property<string>("ImagePath")

22

547

.HasColumnType("TEXT");

22

548

22

549

b.Property<string>("Name")

22

550

.HasColumnType("TEXT");

22

551

22

552

b.Property<long>("StartPositionTicks")

22

553

.HasColumnType("INTEGER");

22

554

22

555

b.HasKey("ItemId", "ChapterIndex");

22

556

22

557

b.ToTable("Chapters");

22

558

22

559

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

560

});

22

562

            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.CustomItemDisplayPreferences", b =>

22

563

{

22

564

b.Property<int>("Id")

22

565

.ValueGeneratedOnAdd()

22

566

.HasColumnType("INTEGER");

22

567

22

568

b.Property<string>("Client")

22

569

.IsRequired()

22

570

.HasMaxLength(32)

22

571

.HasColumnType("TEXT");

22

572

22

573

b.Property<Guid>("ItemId")

22

574

.HasColumnType("TEXT");

22

575

22

576

b.Property<string>("Key")

22

577

.IsRequired()

22

578

.HasColumnType("TEXT");

22

579

22

580

b.Property<Guid>("UserId")

22

581

.HasColumnType("TEXT");

22

582

22

583

b.Property<string>("Value")

22

584

.HasColumnType("TEXT");

22

585

22

586

b.HasKey("Id");

22

587

22

588

b.HasIndex("UserId", "ItemId", "Client", "Key")

22

589

.IsUnique();

22

590

22

591

b.ToTable("CustomItemDisplayPreferences");

22

592

22

593

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

594

});

22

596

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>

22

597

{

22

598

b.Property<int>("Id")

22

599

.ValueGeneratedOnAdd()

22

600

.HasColumnType("INTEGER");

22

601

22

602

b.Property<int>("ChromecastVersion")

22

603

.HasColumnType("INTEGER");

22

604

22

605

b.Property<string>("Client")

22

606

.IsRequired()

22

607

.HasMaxLength(32)

22

608

.HasColumnType("TEXT");

22

609

22

610

b.Property<string>("DashboardTheme")

22

611

.HasMaxLength(32)

22

612

.HasColumnType("TEXT");

22

613

22

614

b.Property<bool>("EnableNextVideoInfoOverlay")

22

615

.HasColumnType("INTEGER");

22

616

22

617

b.Property<int?>("IndexBy")

22

618

.HasColumnType("INTEGER");

22

619

22

620

b.Property<Guid>("ItemId")

22

621

.HasColumnType("TEXT");

22

622

22

623

b.Property<int>("ScrollDirection")

22

624

.HasColumnType("INTEGER");

22

625

22

626

b.Property<bool>("ShowBackdrop")

22

627

.HasColumnType("INTEGER");

22

628

22

629

b.Property<bool>("ShowSidebar")

22

630

.HasColumnType("INTEGER");

22

631

22

632

b.Property<int>("SkipBackwardLength")

22

633

.HasColumnType("INTEGER");

22

634

22

635

b.Property<int>("SkipForwardLength")

22

636

.HasColumnType("INTEGER");

22

637

22

638

b.Property<string>("TvHome")

22

639

.HasMaxLength(32)

22

640

.HasColumnType("TEXT");

22

641

22

642

b.Property<Guid>("UserId")

22

643

.HasColumnType("TEXT");

22

644

22

645

b.HasKey("Id");

22

646

22

647

b.HasIndex("UserId", "ItemId", "Client")

22

648

.IsUnique();

22

649

22

650

b.ToTable("DisplayPreferences");

22

651

22

652

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

653

});

22

655

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>

22

656

{

22

657

b.Property<int>("Id")

22

658

.ValueGeneratedOnAdd()

22

659

.HasColumnType("INTEGER");

22

660

22

661

b.Property<int>("DisplayPreferencesId")

22

662

.HasColumnType("INTEGER");

22

663

22

664

b.Property<int>("Order")

22

665

.HasColumnType("INTEGER");

22

666

22

667

b.Property<int>("Type")

22

668

.HasColumnType("INTEGER");

22

669

22

670

b.HasKey("Id");

22

671

22

672

b.HasIndex("DisplayPreferencesId");

22

673

22

674

b.ToTable("HomeSection");

22

675

22

676

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

677

});

22

679

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>

22

680

{

22

681

b.Property<int>("Id")

22

682

.ValueGeneratedOnAdd()

22

683

.HasColumnType("INTEGER");

22

684

22

685

b.Property<DateTime>("LastModified")

22

686

.HasColumnType("TEXT");

22

687

22

688

b.Property<string>("Path")

22

689

.IsRequired()

22

690

.HasMaxLength(512)

22

691

.HasColumnType("TEXT");

22

692

22

693

b.Property<Guid?>("UserId")

22

694

.HasColumnType("TEXT");

22

695

22

696

b.HasKey("Id");

22

697

22

698

b.HasIndex("UserId")

22

699

.IsUnique();

22

700

22

701

b.ToTable("ImageInfos");

22

702

22

703

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

704

});

22

706

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>

22

707

{

22

708

b.Property<int>("Id")

22

709

.ValueGeneratedOnAdd()

22

710

.HasColumnType("INTEGER");

22

711

22

712

b.Property<string>("Client")

22

713

.IsRequired()

22

714

.HasMaxLength(32)

22

715

.HasColumnType("TEXT");

22

716

22

717

b.Property<int?>("IndexBy")

22

718

.HasColumnType("INTEGER");

22

719

22

720

b.Property<Guid>("ItemId")

22

721

.HasColumnType("TEXT");

22

722

22

723

b.Property<bool>("RememberIndexing")

22

724

.HasColumnType("INTEGER");

22

725

22

726

b.Property<bool>("RememberSorting")

22

727

.HasColumnType("INTEGER");

22

728

22

729

b.Property<string>("SortBy")

22

730

.IsRequired()

22

731

.HasMaxLength(64)

22

732

.HasColumnType("TEXT");

22

733

22

734

b.Property<int>("SortOrder")

22

735

.HasColumnType("INTEGER");

22

736

22

737

b.Property<Guid>("UserId")

22

738

.HasColumnType("TEXT");

22

739

22

740

b.Property<int>("ViewType")

22

741

.HasColumnType("INTEGER");

22

742

22

743

b.HasKey("Id");

22

744

22

745

b.HasIndex("UserId");

22

746

22

747

b.ToTable("ItemDisplayPreferences");

22

748

22

749

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

750

});

22

752

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>

22

753

{

22

754

b.Property<Guid>("ItemValueId")

22

755

.ValueGeneratedOnAdd()

22

756

.HasColumnType("TEXT");

22

757

22

758

b.Property<string>("CleanValue")

22

759

.IsRequired()

22

760

.HasColumnType("TEXT");

22

761

22

762

b.Property<int>("Type")

22

763

.HasColumnType("INTEGER");

22

764

22

765

b.Property<string>("Value")

22

766

.IsRequired()

22

767

.HasColumnType("TEXT");

22

768

22

769

b.HasKey("ItemValueId");

22

770

22

771

b.HasIndex("Type", "CleanValue");

22

772

22

773

b.HasIndex("Type", "Value")

22

774

.IsUnique();

22

775

22

776

b.ToTable("ItemValues");

22

777

22

778

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

779

});

22

781

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>

22

782

{

22

783

b.Property<Guid>("ItemValueId")

22

784

.HasColumnType("TEXT");

22

785

22

786

b.Property<Guid>("ItemId")

22

787

.HasColumnType("TEXT");

22

788

22

789

b.HasKey("ItemValueId", "ItemId");

22

790

22

791

b.HasIndex("ItemId");

22

792

22

793

b.ToTable("ItemValuesMap");

22

794

22

795

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

796

});

22

798

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>

22

799

{

22

800

b.Property<Guid>("ItemId")

22

801

.HasColumnType("TEXT");

22

802

22

803

b.PrimitiveCollection<string>("KeyframeTicks")

22

804

.HasColumnType("TEXT");

22

805

22

806

b.Property<long>("TotalDuration")

22

807

.HasColumnType("INTEGER");

22

808

22

809

b.HasKey("ItemId");

22

810

22

811

b.ToTable("KeyframeData");

22

812

22

813

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

814

});

22

816

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.LinkedChildEntity", b =>

22

817

{

22

818

b.Property<Guid>("ParentId")

22

819

.HasColumnType("TEXT");

22

820

22

821

b.Property<Guid>("ChildId")

22

822

.HasColumnType("TEXT");

22

823

22

824

b.Property<int>("ChildType")

22

825

.HasColumnType("INTEGER");

22

826

22

827

b.Property<int?>("SortOrder")

22

828

.HasColumnType("INTEGER");

22

829

22

830

b.HasKey("ParentId", "ChildId");

22

831

22

832

b.HasIndex("ChildId", "ChildType");

22

833

22

834

b.HasIndex("ParentId", "ChildType");

22

835

22

836

b.HasIndex("ParentId", "SortOrder");

22

837

22

838

b.ToTable("LinkedChildren", (string)null);

22

839

22

840

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

841

});

22

843

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaSegment", b =>

22

844

{

22

845

b.Property<Guid>("Id")

22

846

.ValueGeneratedOnAdd()

22

847

.HasColumnType("TEXT");

22

848

22

849

b.Property<long>("EndTicks")

22

850

.HasColumnType("INTEGER");

22

851

22

852

b.Property<Guid>("ItemId")

22

853

.HasColumnType("TEXT");

22

854

22

855

b.Property<string>("SegmentProviderId")

22

856

.IsRequired()

22

857

.HasColumnType("TEXT");

22

858

22

859

b.Property<long>("StartTicks")

22

860

.HasColumnType("INTEGER");

22

861

22

862

b.Property<int>("Type")

22

863

.HasColumnType("INTEGER");

22

864

22

865

b.HasKey("Id");

22

866

22

867

b.ToTable("MediaSegments");

22

868

22

869

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

870

});

22

872

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>

22

873

{

22

874

b.Property<Guid>("ItemId")

22

875

.HasColumnType("TEXT");

22

876

22

877

b.Property<int>("StreamIndex")

22

878

.HasColumnType("INTEGER");

22

879

22

880

b.Property<string>("AspectRatio")

22

881

.HasColumnType("TEXT");

22

882

22

883

b.Property<float?>("AverageFrameRate")

22

884

.HasColumnType("REAL");

22

885

22

886

b.Property<int?>("BitDepth")

22

887

.HasColumnType("INTEGER");

22

888

22

889

b.Property<int?>("BitRate")

22

890

.HasColumnType("INTEGER");

22

891

22

892

b.Property<int?>("BlPresentFlag")

22

893

.HasColumnType("INTEGER");

22

894

22

895

b.Property<string>("ChannelLayout")

22

896

.HasColumnType("TEXT");

22

897

22

898

b.Property<int?>("Channels")

22

899

.HasColumnType("INTEGER");

22

900

22

901

b.Property<string>("Codec")

22

902

.HasColumnType("TEXT");

22

903

22

904

b.Property<string>("CodecTag")

22

905

.HasColumnType("TEXT");

22

906

22

907

b.Property<string>("CodecTimeBase")

22

908

.HasColumnType("TEXT");

22

909

22

910

b.Property<string>("ColorPrimaries")

22

911

.HasColumnType("TEXT");

22

912

22

913

b.Property<string>("ColorSpace")

22

914

.HasColumnType("TEXT");

22

915

22

916

b.Property<string>("ColorTransfer")

22

917

.HasColumnType("TEXT");

22

918

22

919

b.Property<string>("Comment")

22

920

.HasColumnType("TEXT");

22

921

22

922

b.Property<int?>("DvBlSignalCompatibilityId")

22

923

.HasColumnType("INTEGER");

22

924

22

925

b.Property<int?>("DvLevel")

22

926

.HasColumnType("INTEGER");

22

927

22

928

b.Property<int?>("DvProfile")

22

929

.HasColumnType("INTEGER");

22

930

22

931

b.Property<int?>("DvVersionMajor")

22

932

.HasColumnType("INTEGER");

22

933

22

934

b.Property<int?>("DvVersionMinor")

22

935

.HasColumnType("INTEGER");

22

936

22

937

b.Property<int?>("ElPresentFlag")

22

938

.HasColumnType("INTEGER");

22

939

22

940

b.Property<bool?>("Hdr10PlusPresentFlag")

22

941

.HasColumnType("INTEGER");

22

942

22

943

b.Property<int?>("Height")

22

944

.HasColumnType("INTEGER");

22

945

22

946

b.Property<bool?>("IsAnamorphic")

22

947

.HasColumnType("INTEGER");

22

948

22

949

b.Property<bool?>("IsAvc")

22

950

.HasColumnType("INTEGER");

22

951

22

952

b.Property<bool>("IsDefault")

22

953

.HasColumnType("INTEGER");

22

954

22

955

b.Property<bool>("IsExternal")

22

956

.HasColumnType("INTEGER");

22

957

22

958

b.Property<bool>("IsForced")

22

959

.HasColumnType("INTEGER");

22

960

22

961

b.Property<bool?>("IsHearingImpaired")

22

962

.HasColumnType("INTEGER");

22

963

22

964

b.Property<bool?>("IsInterlaced")

22

965

.HasColumnType("INTEGER");

22

966

22

967

b.Property<bool>("IsOriginal")

22

968

.HasColumnType("INTEGER");

22

969

22

970

b.Property<string>("KeyFrames")

22

971

.HasColumnType("TEXT");

22

972

22

973

b.Property<string>("Language")

22

974

.HasColumnType("TEXT");

22

975

22

976

b.Property<float?>("Level")

22

977

.HasColumnType("REAL");

22

978

22

979

b.Property<string>("NalLengthSize")

22

980

.HasColumnType("TEXT");

22

981

22

982

b.Property<string>("Path")

22

983

.HasColumnType("TEXT");

22

984

22

985

b.Property<string>("PixelFormat")

22

986

.HasColumnType("TEXT");

22

987

22

988

b.Property<string>("Profile")

22

989

.HasColumnType("TEXT");

22

990

22

991

b.Property<float?>("RealFrameRate")

22

992

.HasColumnType("REAL");

22

993

22

994

b.Property<int?>("RefFrames")

22

995

.HasColumnType("INTEGER");

22

996

22

997

b.Property<int?>("Rotation")

22

998

.HasColumnType("INTEGER");

22

999

22

1000

b.Property<int?>("RpuPresentFlag")

22

1001

.HasColumnType("INTEGER");

22

1002

22

1003

b.Property<int?>("SampleRate")

22

1004

.HasColumnType("INTEGER");

22

1005

22

1006

b.Property<int>("StreamType")

22

1007

.HasColumnType("INTEGER");

22

1008

22

1009

b.Property<string>("TimeBase")

22

1010

.HasColumnType("TEXT");

22

1011

22

1012

b.Property<string>("Title")

22

1013

.HasColumnType("TEXT");

22

1014

22

1015

b.Property<int?>("Width")

22

1016

.HasColumnType("INTEGER");

22

1017

22

1018

b.HasKey("ItemId", "StreamIndex");

22

1019

22

1020

b.ToTable("MediaStreamInfos");

22

1021

22

1022

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1023

});

22

1025

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>

22

1026

{

22

1027

b.Property<Guid>("Id")

22

1028

.ValueGeneratedOnAdd()

22

1029

.HasColumnType("TEXT");

22

1030

22

1031

b.Property<string>("Name")

22

1032

.IsRequired()

22

1033

.HasColumnType("TEXT");

22

1034

22

1035

b.Property<string>("PersonType")

22

1036

.HasColumnType("TEXT");

22

1037

22

1038

b.HasKey("Id");

22

1039

22

1040

b.HasIndex("Name");

22

1041

22

1042

b.ToTable("Peoples");

22

1043

22

1044

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1045

});

22

1047

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>

22

1048

{

22

1049

b.Property<Guid>("ItemId")

22

1050

.HasColumnType("TEXT");

22

1051

22

1052

b.Property<Guid>("PeopleId")

22

1053

.HasColumnType("TEXT");

22

1054

22

1055

b.Property<string>("Role")

22

1056

.HasColumnType("TEXT");

22

1057

22

1058

b.Property<int?>("ListOrder")

22

1059

.HasColumnType("INTEGER");

22

1060

22

1061

b.Property<int?>("SortOrder")

22

1062

.HasColumnType("INTEGER");

22

1063

22

1064

b.HasKey("ItemId", "PeopleId", "Role");

22

1065

22

1066

b.HasIndex("PeopleId");

22

1067

22

1068

b.HasIndex("ItemId", "ListOrder");

22

1069

22

1070

b.HasIndex("ItemId", "SortOrder");

22

1071

22

1072

b.ToTable("PeopleBaseItemMap");

22

1073

22

1074

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1075

});

22

1077

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>

22

1078

{

22

1079

b.Property<int>("Id")

22

1080

.ValueGeneratedOnAdd()

22

1081

.HasColumnType("INTEGER");

22

1082

22

1083

b.Property<int>("Kind")

22

1084

.HasColumnType("INTEGER");

22

1085

22

1086

b.Property<Guid?>("Permission_Permissions_Guid")

22

1087

.HasColumnType("TEXT");

22

1088

22

1089

b.Property<uint>("RowVersion")

22

1090

.IsConcurrencyToken()

22

1091

.HasColumnType("INTEGER");

22

1092

22

1093

b.Property<Guid?>("UserId")

22

1094

.HasColumnType("TEXT");

22

1095

22

1096

b.Property<bool>("Value")

22

1097

.HasColumnType("INTEGER");

22

1098

22

1099

b.HasKey("Id");

22

1100

22

1101

b.HasIndex("UserId", "Kind")

22

1102

.IsUnique()

22

1103

.HasFilter("[UserId] IS NOT NULL");

22

1104

22

1105

b.ToTable("Permissions");

22

1106

22

1107

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1108

});

22

1110

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>

22

1111

{

22

1112

b.Property<int>("Id")

22

1113

.ValueGeneratedOnAdd()

22

1114

.HasColumnType("INTEGER");

22

1115

22

1116

b.Property<int>("Kind")

22

1117

.HasColumnType("INTEGER");

22

1118

22

1119

b.Property<Guid?>("Preference_Preferences_Guid")

22

1120

.HasColumnType("TEXT");

22

1121

22

1122

b.Property<uint>("RowVersion")

22

1123

.IsConcurrencyToken()

22

1124

.HasColumnType("INTEGER");

22

1125

22

1126

b.Property<Guid?>("UserId")

22

1127

.HasColumnType("TEXT");

22

1128

22

1129

b.Property<string>("Value")

22

1130

.IsRequired()

22

1131

.HasMaxLength(65535)

22

1132

.HasColumnType("TEXT");

22

1133

22

1134

b.HasKey("Id");

22

1135

22

1136

b.HasIndex("UserId", "Kind")

22

1137

.IsUnique()

22

1138

.HasFilter("[UserId] IS NOT NULL");

22

1139

22

1140

b.ToTable("Preferences");

22

1141

22

1142

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1143

});

22

1145

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.ApiKey", b =>

22

1146

{

22

1147

b.Property<int>("Id")

22

1148

.ValueGeneratedOnAdd()

22

1149

.HasColumnType("INTEGER");

22

1150

22

1151

b.Property<string>("AccessToken")

22

1152

.IsRequired()

22

1153

.HasColumnType("TEXT");

22

1154

22

1155

b.Property<DateTime>("DateCreated")

22

1156

.HasColumnType("TEXT");

22

1157

22

1158

b.Property<DateTime>("DateLastActivity")

22

1159

.HasColumnType("TEXT");

22

1160

22

1161

b.Property<string>("Name")

22

1162

.IsRequired()

22

1163

.HasMaxLength(64)

22

1164

.HasColumnType("TEXT");

22

1165

22

1166

b.HasKey("Id");

22

1167

22

1168

b.HasIndex("AccessToken")

22

1169

.IsUnique();

22

1170

22

1171

b.ToTable("ApiKeys");

22

1172

22

1173

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1174

});

22

1176

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>

22

1177

{

22

1178

b.Property<int>("Id")

22

1179

.ValueGeneratedOnAdd()

22

1180

.HasColumnType("INTEGER");

22

1181

22

1182

b.Property<string>("AccessToken")

22

1183

.IsRequired()

22

1184

.HasColumnType("TEXT");

22

1185

22

1186

b.Property<string>("AppName")

22

1187

.IsRequired()

22

1188

.HasMaxLength(64)

22

1189

.HasColumnType("TEXT");

22

1190

22

1191

b.Property<string>("AppVersion")

22

1192

.IsRequired()

22

1193

.HasMaxLength(32)

22

1194

.HasColumnType("TEXT");

22

1195

22

1196

b.Property<DateTime>("DateCreated")

22

1197

.HasColumnType("TEXT");

22

1198

22

1199

b.Property<DateTime>("DateLastActivity")

22

1200

.HasColumnType("TEXT");

22

1201

22

1202

b.Property<DateTime>("DateModified")

22

1203

.HasColumnType("TEXT");

22

1204

22

1205

b.Property<string>("DeviceId")

22

1206

.IsRequired()

22

1207

.HasMaxLength(256)

22

1208

.HasColumnType("TEXT");

22

1209

22

1210

b.Property<string>("DeviceName")

22

1211

.IsRequired()

22

1212

.HasMaxLength(64)

22

1213

.HasColumnType("TEXT");

22

1214

22

1215

b.Property<bool>("IsActive")

22

1216

.HasColumnType("INTEGER");

22

1217

22

1218

b.Property<Guid>("UserId")

22

1219

.HasColumnType("TEXT");

22

1220

22

1221

b.HasKey("Id");

22

1222

22

1223

b.HasIndex("AccessToken", "DateLastActivity");

22

1224

22

1225

b.HasIndex("DeviceId", "DateLastActivity");

22

1226

22

1227

b.HasIndex("UserId", "DeviceId");

22

1228

22

1229

b.ToTable("Devices");

22

1230

22

1231

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1232

});

22

1234

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.DeviceOptions", b =>

22

1235

{

22

1236

b.Property<int>("Id")

22

1237

.ValueGeneratedOnAdd()

22

1238

.HasColumnType("INTEGER");

22

1239

22

1240

b.Property<string>("CustomName")

22

1241

.HasColumnType("TEXT");

22

1242

22

1243

b.Property<string>("DeviceId")

22

1244

.IsRequired()

22

1245

.HasColumnType("TEXT");

22

1246

22

1247

b.HasKey("Id");

22

1248

22

1249

b.HasIndex("DeviceId")

22

1250

.IsUnique();

22

1251

22

1252

b.ToTable("DeviceOptions");

22

1253

22

1254

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1255

});

22

1257

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.TrickplayInfo", b =>

22

1258

{

22

1259

b.Property<Guid>("ItemId")

22

1260

.HasColumnType("TEXT");

22

1261

22

1262

b.Property<int>("Width")

22

1263

.HasColumnType("INTEGER");

22

1264

22

1265

b.Property<int>("Bandwidth")

22

1266

.HasColumnType("INTEGER");

22

1267

22

1268

b.Property<int>("Height")

22

1269

.HasColumnType("INTEGER");

22

1270

22

1271

b.Property<int>("Interval")

22

1272

.HasColumnType("INTEGER");

22

1273

22

1274

b.Property<int>("ThumbnailCount")

22

1275

.HasColumnType("INTEGER");

22

1276

22

1277

b.Property<int>("TileHeight")

22

1278

.HasColumnType("INTEGER");

22

1279

22

1280

b.Property<int>("TileWidth")

22

1281

.HasColumnType("INTEGER");

22

1282

22

1283

b.HasKey("ItemId", "Width");

22

1284

22

1285

b.ToTable("TrickplayInfos");

22

1286

22

1287

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1288

});

22

1290

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>

22

1291

{

22

1292

b.Property<Guid>("Id")

22

1293

.ValueGeneratedOnAdd()

22

1294

.HasColumnType("TEXT");

22

1295

22

1296

b.Property<string>("AudioLanguagePreference")

22

1297

.HasMaxLength(255)

22

1298

.HasColumnType("TEXT");

22

1299

22

1300

b.Property<string>("AuthenticationProviderId")

22

1301

.IsRequired()

22

1302

.HasMaxLength(255)

22

1303

.HasColumnType("TEXT");

22

1304

22

1305

b.Property<string>("CastReceiverId")

22

1306

.HasMaxLength(32)

22

1307

.HasColumnType("TEXT");

22

1308

22

1309

b.Property<bool>("DisplayCollectionsView")

22

1310

.HasColumnType("INTEGER");

22

1311

22

1312

b.Property<bool>("DisplayMissingEpisodes")

22

1313

.HasColumnType("INTEGER");

22

1314

22

1315

b.Property<bool>("EnableAutoLogin")

22

1316

.HasColumnType("INTEGER");

22

1317

22

1318

b.Property<bool>("EnableLocalPassword")

22

1319

.HasColumnType("INTEGER");

22

1320

22

1321

b.Property<bool>("EnableNextEpisodeAutoPlay")

22

1322

.HasColumnType("INTEGER");

22

1323

22

1324

b.Property<bool>("EnableUserPreferenceAccess")

22

1325

.HasColumnType("INTEGER");

22

1326

22

1327

b.Property<bool>("HidePlayedInLatest")

22

1328

.HasColumnType("INTEGER");

22

1329

22

1330

b.Property<long>("InternalId")

22

1331

.HasColumnType("INTEGER");

22

1332

22

1333

b.Property<int>("InvalidLoginAttemptCount")

22

1334

.HasColumnType("INTEGER");

22

1335

22

1336

b.Property<DateTime?>("LastActivityDate")

22

1337

.HasColumnType("TEXT");

22

1338

22

1339

b.Property<DateTime?>("LastLoginDate")

22

1340

.HasColumnType("TEXT");

22

1341

22

1342

b.Property<int?>("LoginAttemptsBeforeLockout")

22

1343

.HasColumnType("INTEGER");

22

1344

22

1345

b.Property<int>("MaxActiveSessions")

22

1346

.HasColumnType("INTEGER");

22

1347

22

1348

b.Property<int?>("MaxParentalRatingScore")

22

1349

.HasColumnType("INTEGER");

22

1350

22

1351

b.Property<int?>("MaxParentalRatingSubScore")

22

1352

.HasColumnType("INTEGER");

22

1353

22

1354

b.Property<bool>("MustUpdatePassword")

22

1355

.HasColumnType("INTEGER");

22

1356

22

1357

b.Property<string>("NormalizedUsername")

22

1358

.IsRequired()

22

1359

.HasMaxLength(255)

22

1360

.HasColumnType("TEXT");

22

1361

22

1362

b.Property<string>("Password")

22

1363

.HasMaxLength(65535)

22

1364

.HasColumnType("TEXT");

22

1365

22

1366

b.Property<string>("PasswordResetProviderId")

22

1367

.IsRequired()

22

1368

.HasMaxLength(255)

22

1369

.HasColumnType("TEXT");

22

1370

22

1371

b.Property<bool>("PlayDefaultAudioTrack")

22

1372

.HasColumnType("INTEGER");

22

1373

22

1374

b.Property<bool>("RememberAudioSelections")

22

1375

.HasColumnType("INTEGER");

22

1376

22

1377

b.Property<bool>("RememberSubtitleSelections")

22

1378

.HasColumnType("INTEGER");

22

1379

22

1380

b.Property<int?>("RemoteClientBitrateLimit")

22

1381

.HasColumnType("INTEGER");

22

1382

22

1383

b.Property<uint>("RowVersion")

22

1384

.IsConcurrencyToken()

22

1385

.HasColumnType("INTEGER");

22

1386

22

1387

b.Property<string>("SubtitleLanguagePreference")

22

1388

.HasMaxLength(255)

22

1389

.HasColumnType("TEXT");

22

1390

22

1391

b.Property<int>("SubtitleMode")

22

1392

.HasColumnType("INTEGER");

22

1393

22

1394

b.Property<int>("SyncPlayAccess")

22

1395

.HasColumnType("INTEGER");

22

1396

22

1397

b.Property<string>("Username")

22

1398

.IsRequired()

22

1399

.HasMaxLength(255)

22

1400

.HasColumnType("TEXT");

22

1401

22

1402

b.HasKey("Id");

22

1403

22

1404

b.HasIndex("NormalizedUsername")

22

1405

.IsUnique();

22

1406

22

1407

b.HasIndex("Username")

22

1408

.IsUnique();

22

1409

22

1410

b.ToTable("Users");

22

1411

22

1412

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1413

});

22

1415

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>

22

1416

{

22

1417

b.Property<Guid>("ItemId")

22

1418

.HasColumnType("TEXT");

22

1419

22

1420

b.Property<Guid>("UserId")

22

1421

.HasColumnType("TEXT");

22

1422

22

1423

b.Property<string>("CustomDataKey")

22

1424

.HasColumnType("TEXT");

22

1425

22

1426

b.Property<int?>("AudioStreamIndex")

22

1427

.HasColumnType("INTEGER");

22

1428

22

1429

b.Property<bool>("IsFavorite")

22

1430

.HasColumnType("INTEGER");

22

1431

22

1432

b.Property<DateTime?>("LastPlayedDate")

22

1433

.HasColumnType("TEXT");

22

1434

22

1435

b.Property<bool?>("Likes")

22

1436

.HasColumnType("INTEGER");

22

1437

22

1438

b.Property<int>("PlayCount")

22

1439

.HasColumnType("INTEGER");

22

1440

22

1441

b.Property<long>("PlaybackPositionTicks")

22

1442

.HasColumnType("INTEGER");

22

1443

22

1444

b.Property<bool>("Played")

22

1445

.HasColumnType("INTEGER");

22

1446

22

1447

b.Property<double?>("Rating")

22

1448

.HasColumnType("REAL");

22

1449

22

1450

b.Property<DateTime?>("RetentionDate")

22

1451

.HasColumnType("TEXT");

22

1452

22

1453

b.Property<int?>("SubtitleStreamIndex")

22

1454

.HasColumnType("INTEGER");

22

1455

22

1456

b.HasKey("ItemId", "UserId", "CustomDataKey");

22

1457

22

1458

b.HasIndex("ItemId", "UserId", "IsFavorite");

22

1459

22

1460

b.HasIndex("ItemId", "UserId", "LastPlayedDate");

22

1461

22

1462

b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks");

22

1463

22

1464

b.HasIndex("ItemId", "UserId", "Played");

22

1465

22

1466

b.HasIndex("UserId", "IsFavorite", "ItemId");

22

1467

22

1468

b.HasIndex("UserId", "ItemId", "LastPlayedDate");

22

1469

22

1470

b.HasIndex("UserId", "Played", "ItemId");

22

1471

22

1472

b.ToTable("UserData");

22

1473

22

1474

b.HasAnnotation("Sqlite:UseSqlReturningClause", false);

22

1475

});

22

1477

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>

22

1478

{

22

1479

b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)

22

1480

.WithMany("AccessSchedules")

22

1481

.HasForeignKey("UserId")

22

1482

.OnDelete(DeleteBehavior.Cascade)

22

1483

.IsRequired();

22

1484

});

22

1486

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>

22

1487

{

22

1488

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1489

.WithMany("Parents")

22

1490

.HasForeignKey("ItemId")

22

1491

.OnDelete(DeleteBehavior.Cascade)

22

1492

.IsRequired();

22

1493

22

1494

                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "ParentItem")

22

1495

.WithMany("Children")

22

1496

.HasForeignKey("ParentItemId")

22

1497

.OnDelete(DeleteBehavior.Cascade)

22

1498

.IsRequired();

22

1499

22

1500

b.Navigation("Item");

22

1501

22

1502

b.Navigation("ParentItem");

22

1503

});

22

1505

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>

22

1506

{

22

1507

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1508

.WithMany()

22

1509

.HasForeignKey("ItemId")

22

1510

.OnDelete(DeleteBehavior.Cascade)

22

1511

.IsRequired();

22

1512

22

1513

b.Navigation("Item");

22

1514

});

22

1516

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>

22

1517

{

22

1518

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Owner")

22

1519

.WithMany("Extras")

22

1520

.HasForeignKey("OwnerId")

22

1521

.OnDelete(DeleteBehavior.NoAction);

22

1522

22

1523

                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "DirectParent")

22

1524

.WithMany("DirectChildren")

22

1525

.HasForeignKey("ParentId")

22

1526

.OnDelete(DeleteBehavior.Cascade);

22

1527

22

1528

b.Navigation("DirectParent");

22

1529

22

1530

b.Navigation("Owner");

22

1531

});

22

1533

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>

22

1534

{

22

1535

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1536

.WithMany("Images")

22

1537

.HasForeignKey("ItemId")

22

1538

.OnDelete(DeleteBehavior.Cascade)

22

1539

.IsRequired();

22

1540

22

1541

b.Navigation("Item");

22

1542

});

22

1544

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>

22

1545

{

22

1546

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1547

.WithMany("LockedFields")

22

1548

.HasForeignKey("ItemId")

22

1549

.OnDelete(DeleteBehavior.Cascade)

22

1550

.IsRequired();

22

1551

22

1552

b.Navigation("Item");

22

1553

});

22

1555

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>

22

1556

{

22

1557

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1558

.WithMany("Provider")

22

1559

.HasForeignKey("ItemId")

22

1560

.OnDelete(DeleteBehavior.Cascade)

22

1561

.IsRequired();

22

1562

22

1563

b.Navigation("Item");

22

1564

});

22

1566

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>

22

1567

{

22

1568

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1569

.WithMany("TrailerTypes")

22

1570

.HasForeignKey("ItemId")

22

1571

.OnDelete(DeleteBehavior.Cascade)

22

1572

.IsRequired();

22

1573

22

1574

b.Navigation("Item");

22

1575

});

22

1577

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>

22

1578

{

22

1579

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1580

.WithMany("Chapters")

22

1581

.HasForeignKey("ItemId")

22

1582

.OnDelete(DeleteBehavior.Cascade)

22

1583

.IsRequired();

22

1584

22

1585

b.Navigation("Item");

22

1586

});

22

1588

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>

22

1589

{

22

1590

b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)

22

1591

.WithMany("DisplayPreferences")

22

1592

.HasForeignKey("UserId")

22

1593

.OnDelete(DeleteBehavior.Cascade)

22

1594

.IsRequired();

22

1595

});

22

1597

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>

22

1598

{

22

1599

b.HasOne("Jellyfin.Database.Implementations.Entities.DisplayPreferences", null)

22

1600

.WithMany("HomeSections")

22

1601

.HasForeignKey("DisplayPreferencesId")

22

1602

.OnDelete(DeleteBehavior.Cascade)

22

1603

.IsRequired();

22

1604

});

22

1606

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>

22

1607

{

22

1608

b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)

22

1609

.WithOne("ProfileImage")

22

1610

                        .HasForeignKey("Jellyfin.Database.Implementations.Entities.ImageInfo", "UserId")

22

1611

.OnDelete(DeleteBehavior.Cascade);

22

1612

});

22

1614

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>

22

1615

{

22

1616

b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)

22

1617

.WithMany("ItemDisplayPreferences")

22

1618

.HasForeignKey("UserId")

22

1619

.OnDelete(DeleteBehavior.Cascade)

22

1620

.IsRequired();

22

1621

});

22

1623

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>

22

1624

{

22

1625

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1626

.WithMany("ItemValues")

22

1627

.HasForeignKey("ItemId")

22

1628

.OnDelete(DeleteBehavior.Cascade)

22

1629

.IsRequired();

22

1630

22

1631

b.HasOne("Jellyfin.Database.Implementations.Entities.ItemValue", "ItemValue")

22

1632

.WithMany("BaseItemsMap")

22

1633

.HasForeignKey("ItemValueId")

22

1634

.OnDelete(DeleteBehavior.Cascade)

22

1635

.IsRequired();

22

1636

22

1637

b.Navigation("Item");

22

1638

22

1639

b.Navigation("ItemValue");

22

1640

});

22

1642

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>

22

1643

{

22

1644

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1645

.WithMany()

22

1646

.HasForeignKey("ItemId")

22

1647

.OnDelete(DeleteBehavior.Cascade)

22

1648

.IsRequired();

22

1649

22

1650

b.Navigation("Item");

22

1651

});

22

1653

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.LinkedChildEntity", b =>

22

1654

{

22

1655

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Child")

22

1656

.WithMany("LinkedChildOfEntities")

22

1657

.HasForeignKey("ChildId")

22

1658

.OnDelete(DeleteBehavior.NoAction)

22

1659

.IsRequired();

22

1660

22

1661

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Parent")

22

1662

.WithMany("LinkedChildEntities")

22

1663

.HasForeignKey("ParentId")

22

1664

.OnDelete(DeleteBehavior.NoAction)

22

1665

.IsRequired();

22

1666

22

1667

b.Navigation("Child");

22

1668

22

1669

b.Navigation("Parent");

22

1670

});

22

1672

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>

22

1673

{

22

1674

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1675

.WithMany("MediaStreams")

22

1676

.HasForeignKey("ItemId")

22

1677

.OnDelete(DeleteBehavior.Cascade)

22

1678

.IsRequired();

22

1679

22

1680

b.Navigation("Item");

22

1681

});

22

1683

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>

22

1684

{

22

1685

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1686

.WithMany("Peoples")

22

1687

.HasForeignKey("ItemId")

22

1688

.OnDelete(DeleteBehavior.Cascade)

22

1689

.IsRequired();

22

1690

22

1691

b.HasOne("Jellyfin.Database.Implementations.Entities.People", "People")

22

1692

.WithMany("BaseItems")

22

1693

.HasForeignKey("PeopleId")

22

1694

.OnDelete(DeleteBehavior.Cascade)

22

1695

.IsRequired();

22

1696

22

1697

b.Navigation("Item");

22

1698

22

1699

b.Navigation("People");

22

1700

});

22

1702

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>

22

1703

{

22

1704

b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)

22

1705

.WithMany("Permissions")

22

1706

.HasForeignKey("UserId")

22

1707

.OnDelete(DeleteBehavior.Cascade);

22

1708

});

22

1710

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>

22

1711

{

22

1712

b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)

22

1713

.WithMany("Preferences")

22

1714

.HasForeignKey("UserId")

22

1715

.OnDelete(DeleteBehavior.Cascade);

22

1716

});

22

1718

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>

22

1719

{

22

1720

b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")

22

1721

.WithMany()

22

1722

.HasForeignKey("UserId")

22

1723

.OnDelete(DeleteBehavior.Cascade)

22

1724

.IsRequired();

22

1725

22

1726

b.Navigation("User");

22

1727

});

22

1729

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>

22

1730

{

22

1731

b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")

22

1732

.WithMany("UserData")

22

1733

.HasForeignKey("ItemId")

22

1734

.OnDelete(DeleteBehavior.Cascade)

22

1735

.IsRequired();

22

1736

22

1737

b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")

22

1738

.WithMany()

22

1739

.HasForeignKey("UserId")

22

1740

.OnDelete(DeleteBehavior.Cascade)

22

1741

.IsRequired();

22

1742

22

1743

b.Navigation("Item");

22

1744

22

1745

b.Navigation("User");

22

1746

});

22

1748

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>

22

1749

{

22

1750

b.Navigation("Chapters");

22

1751

22

1752

b.Navigation("Children");

22

1753

22

1754

b.Navigation("DirectChildren");

22

1755

22

1756

b.Navigation("Extras");

22

1757

22

1758

b.Navigation("Images");

22

1759

22

1760

b.Navigation("ItemValues");

22

1761

22

1762

b.Navigation("LinkedChildEntities");

22

1763

22

1764

b.Navigation("LinkedChildOfEntities");

22

1765

22

1766

b.Navigation("LockedFields");

22

1767

22

1768

b.Navigation("MediaStreams");

22

1769

22

1770

b.Navigation("Parents");

22

1771

22

1772

b.Navigation("Peoples");

22

1773

22

1774

b.Navigation("Provider");

22

1775

22

1776

b.Navigation("TrailerTypes");

22

1777

22

1778

b.Navigation("UserData");

22

1779

});

22

1781

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>

22

1782

{

22

1783

b.Navigation("HomeSections");

22

1784

});

22

1786

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>

22

1787

{

22

1788

b.Navigation("BaseItemsMap");

22

1789

});

22

1791

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>

22

1792

{

22

1793

b.Navigation("BaseItems");

22

1794

});

22

1796

modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>

22

1797

{

22

1798

b.Navigation("AccessSchedules");

22

1799

22

1800

b.Navigation("DisplayPreferences");

22

1801

22

1802

b.Navigation("ItemDisplayPreferences");

22

1803

22

1804

b.Navigation("Permissions");

22

1805

22

1806

b.Navigation("Preferences");

22

1807

22

1808

b.Navigation("ProfileImage");

22

1809

});

22

1811

}

< Summary - Jellyfin

Coverage history

Metrics

File(s)

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260724185102_AddPrimaryVersionIdIndex.cs

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260724185102_AddPrimaryVersionIdIndex.Designer.cs

Methods/Properties