Jellyfin.Database.Providers.Sqlite.Migrations.AddPartialIndexForItemCounts - Jellyfin

Class:	Jellyfin.Database.Providers.Sqlite.Migrations.AddPartialIndexForItemCounts
Assembly:	Jellyfin.Database.Providers.Sqlite
File(s):	File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260504075755_AddPartialIndexForItemCounts.cs File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260504075755_AddPartialIndexForItemCounts.Designer.cs

Covered lines:	1727
Uncovered lines:	4
Coverable lines:	1731
Total lines:	1830
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.Database.Providers.Sqlite.Migrations`
	`12`	`{`
	`13`	`[DbContext(typeof(JellyfinDbContext))]`
	`14`	`[Migration("20260504075755_AddPartialIndexForItemCounts")]`
	`15`	`partial class AddPartialIndexForItemCounts`
	`16`	`{`
	`17`	`/// <inheritdoc />`
	`18`	`protected override void BuildTargetModel(ModelBuilder modelBuilder)`
	`19`	`{`
	`20`	`#pragma warning disable 612, 618`
22	`21`	`modelBuilder.HasAnnotation("ProductVersion", "10.0.7");`
	`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("SeasonId");`
22	`380`
22	`381`	`b.HasIndex("SeriesId");`
22	`382`
22	`383`	`b.HasIndex("SeriesName");`
22	`384`
22	`385`	`b.HasIndex("ExtraType", "OwnerId");`
22	`386`
22	`387`	`b.HasIndex("TopParentId", "Id");`
22	`388`
22	`389`	`b.HasIndex("Type", "CleanName");`
22	`390`
22	`391`	`b.HasIndex("TopParentId", "Type", "IsVirtualItem")`
22	`392`	`.HasFilter("\"PrimaryVersionId\" IS NULL AND (\"OwnerId\" IS NULL OR \"ExtraType\" IS NOT NULL)"`
22	`393`
22	`394`	`b.HasIndex("Type", "TopParentId", "Id");`
22	`395`
22	`396`	`b.HasIndex("Type", "TopParentId", "PresentationUniqueKey");`
22	`397`
22	`398`	`b.HasIndex("Type", "TopParentId", "SortName");`
22	`399`
22	`400`	`b.HasIndex("Type", "TopParentId", "StartDate");`
22	`401`
22	`402`	`b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey");`
22	`403`
22	`404`	`b.HasIndex("TopParentId", "IsFolder", "IsVirtualItem", "DateCreated");`
22	`405`
22	`406`	`b.HasIndex("TopParentId", "MediaType", "IsVirtualItem", "DateCreated");`
22	`407`
22	`408`	`b.HasIndex("TopParentId", "Type", "IsVirtualItem", "DateCreated");`
22	`409`
22	`410`	`b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem");`
22	`411`
22	`412`	`b.HasIndex("Type", "SeriesPresentationUniqueKey", "ParentIndexNumber", "IndexNumber");`
22	`413`
22	`414`	`b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName");`
22	`415`
22	`416`	`b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");`
22	`417`
22	`418`	`b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");`
22	`419`
22	`420`	`b.ToTable("BaseItems");`
22	`421`
22	`422`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`423`
22	`424`	`b.HasData(`
22	`425`	`new`
22	`426`	`{`
22	`427`	`Id = new Guid("00000000-0000-0000-0000-000000000001"),`
22	`428`	`IsFolder = false,`
22	`429`	`IsInMixedFolder = false,`
22	`430`	`IsLocked = false,`
22	`431`	`IsMovie = false,`
22	`432`	`IsRepeat = false,`
22	`433`	`IsSeries = false,`
22	`434`	`IsVirtualItem = false,`
22	`435`	`Name = "This is a placeholder item for UserData that has been detached from its original ite`
22	`436`	`Type = "PLACEHOLDER"`
22	`437`	`});`
22	`438`	`});`
	`439`
22	`440`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>`
22	`441`	`{`
22	`442`	`b.Property<Guid>("Id")`
22	`443`	`.ValueGeneratedOnAdd()`
22	`444`	`.HasColumnType("TEXT");`
22	`445`
22	`446`	`b.Property<byte[]>("Blurhash")`
22	`447`	`.HasColumnType("BLOB");`
22	`448`
22	`449`	`b.Property<DateTime?>("DateModified")`
22	`450`	`.HasColumnType("TEXT");`
22	`451`
22	`452`	`b.Property<int>("Height")`
22	`453`	`.HasColumnType("INTEGER");`
22	`454`
22	`455`	`b.Property<int>("ImageType")`
22	`456`	`.HasColumnType("INTEGER");`
22	`457`
22	`458`	`b.Property<Guid>("ItemId")`
22	`459`	`.HasColumnType("TEXT");`
22	`460`
22	`461`	`b.Property<string>("Path")`
22	`462`	`.IsRequired()`
22	`463`	`.HasColumnType("TEXT");`
22	`464`
22	`465`	`b.Property<int>("Width")`
22	`466`	`.HasColumnType("INTEGER");`
22	`467`
22	`468`	`b.HasKey("Id");`
22	`469`
22	`470`	`b.HasIndex("ItemId", "ImageType");`
22	`471`
22	`472`	`b.ToTable("BaseItemImageInfos");`
22	`473`
22	`474`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`475`	`});`
	`476`
22	`477`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>`
22	`478`	`{`
22	`479`	`b.Property<int>("Id")`
22	`480`	`.HasColumnType("INTEGER");`
22	`481`
22	`482`	`b.Property<Guid>("ItemId")`
22	`483`	`.HasColumnType("TEXT");`
22	`484`
22	`485`	`b.HasKey("Id", "ItemId");`
22	`486`
22	`487`	`b.HasIndex("ItemId");`
22	`488`
22	`489`	`b.ToTable("BaseItemMetadataFields");`
22	`490`
22	`491`	`b.HasAnnotation("Sqlite:UseSqlReturningClause", false);`
22	`492`	`});`
	`493`
22	`494`	`modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>`
22	`495`	`{`
22	`496`	`b.Property<Guid>("ItemId")`
22	`497`	`.HasColumnType("TEXT");`
22	`498`
22	`499`	`b.Property<string>("ProviderId")`
22	`500`	`.HasColumnType("TEXT");`

22

21

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

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("SeasonId");

22

380

22

381

b.HasIndex("SeriesId");

22

382

22

383

b.HasIndex("SeriesName");

22

384

22

385

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

22

386

22

387

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

22

388

22

389

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

22

390

22

391

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

22

392

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

22

393

22

394

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

22

395

22

396

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

22

397

22

398

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

22

399

22

400

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

22

401

22

402

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

22

403

22

404

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

22

405

22

406

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

22

407

22

408

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

22

409

22

410

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

22

411

22

412

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

22

413

22

414

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

22

415

22

416

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

22

417

22

418

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

22

419

22

420

b.ToTable("BaseItems");

22

421

22

422

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

22

423

22

424

b.HasData(

22

425

new

22

426

{

22

427

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

22

428

IsFolder = false,

22

429

IsInMixedFolder = false,

22

430

IsLocked = false,

22

431

IsMovie = false,

22

432

IsRepeat = false,

22

433

IsSeries = false,

22

434

IsVirtualItem = false,

22

435

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

22

436

Type = "PLACEHOLDER"

22

437

});

22

438

});

22

440

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

22

441

{

22

442

b.Property<Guid>("Id")

22

443

.ValueGeneratedOnAdd()

22

444

.HasColumnType("TEXT");

22

445

22

446

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

22

447

.HasColumnType("BLOB");

22

448

22

449

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

22

450

.HasColumnType("TEXT");

22

451

22

452

b.Property<int>("Height")

22

453

.HasColumnType("INTEGER");

22

454

22

455

b.Property<int>("ImageType")

22

456

.HasColumnType("INTEGER");

22

457

22

458

b.Property<Guid>("ItemId")

22

459

.HasColumnType("TEXT");

22

460

22

461

b.Property<string>("Path")

22

462

.IsRequired()

22

463

.HasColumnType("TEXT");

22

464

22

465

b.Property<int>("Width")

22

466

.HasColumnType("INTEGER");

22

467

22

468

b.HasKey("Id");

22

469

22

470

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

22

471

22

472

b.ToTable("BaseItemImageInfos");

22

473

22

474

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

22

475

});

22

477

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

22

478

{

22

479

b.Property<int>("Id")

22

480

.HasColumnType("INTEGER");

22

481

22

482

b.Property<Guid>("ItemId")

22

483

.HasColumnType("TEXT");

22

484

22

485

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

22

486

22

487

b.HasIndex("ItemId");

22

488

22

489

b.ToTable("BaseItemMetadataFields");

22

490

22

491

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

22

492

});

22

494

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

22

495

{

22

496

b.Property<Guid>("ItemId")

22

497

.HasColumnType("TEXT");

22

498

22

499

b.Property<string>("ProviderId")

22

500

.HasColumnType("TEXT");

22

501

22

502

b.Property<string>("ProviderValue")

22

503

.IsRequired()

22

504

.HasColumnType("TEXT");

22

505

22

506

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

22

507

22

508

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

22

509

22

510

b.ToTable("BaseItemProviders");

22

511

22

512

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

22

513

});

22

515

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

22

516

{

22

517

b.Property<int>("Id")

22

518

.HasColumnType("INTEGER");

22

519

22

520

b.Property<Guid>("ItemId")

22

521

.HasColumnType("TEXT");

22

522

22

523

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

22

524

22

525

b.HasIndex("ItemId");

22

526

22

527

b.ToTable("BaseItemTrailerTypes");

22

528

22

529

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

22

530

});

22

532

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

22

533

{

22

534

b.Property<Guid>("ItemId")

22

535

.HasColumnType("TEXT");

22

536

22

537

b.Property<int>("ChapterIndex")

22

538

.HasColumnType("INTEGER");

22

539

22

540

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

22

541

.HasColumnType("TEXT");

22

542

22

543

b.Property<string>("ImagePath")

22

544

.HasColumnType("TEXT");

22

545

22

546

b.Property<string>("Name")

22

547

.HasColumnType("TEXT");

22

548

22

549

b.Property<long>("StartPositionTicks")

22

550

.HasColumnType("INTEGER");

22

551

22

552

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

22

553

22

554

b.ToTable("Chapters");

22

555

22

556

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

22

557

});

22

559

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

22

560

{

22

561

b.Property<int>("Id")

22

562

.ValueGeneratedOnAdd()

22

563

.HasColumnType("INTEGER");

22

564

22

565

b.Property<string>("Client")

22

566

.IsRequired()

22

567

.HasMaxLength(32)

22

568

.HasColumnType("TEXT");

22

569

22

570

b.Property<Guid>("ItemId")

22

571

.HasColumnType("TEXT");

22

572

22

573

b.Property<string>("Key")

22

574

.IsRequired()

22

575

.HasColumnType("TEXT");

22

576

22

577

b.Property<Guid>("UserId")

22

578

.HasColumnType("TEXT");

22

579

22

580

b.Property<string>("Value")

22

581

.HasColumnType("TEXT");

22

582

22

583

b.HasKey("Id");

22

584

22

585

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

22

586

.IsUnique();

22

587

22

588

b.ToTable("CustomItemDisplayPreferences");

22

589

22

590

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

22

591

});

22

593

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

22

594

{

22

595

b.Property<int>("Id")

22

596

.ValueGeneratedOnAdd()

22

597

.HasColumnType("INTEGER");

22

598

22

599

b.Property<int>("ChromecastVersion")

22

600

.HasColumnType("INTEGER");

22

601

22

602

b.Property<string>("Client")

22

603

.IsRequired()

22

604

.HasMaxLength(32)

22

605

.HasColumnType("TEXT");

22

606

22

607

b.Property<string>("DashboardTheme")

22

608

.HasMaxLength(32)

22

609

.HasColumnType("TEXT");

22

610

22

611

b.Property<bool>("EnableNextVideoInfoOverlay")

22

612

.HasColumnType("INTEGER");

22

613

22

614

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

22

615

.HasColumnType("INTEGER");

22

616

22

617

b.Property<Guid>("ItemId")

22

618

.HasColumnType("TEXT");

22

619

22

620

b.Property<int>("ScrollDirection")

22

621

.HasColumnType("INTEGER");

22

622

22

623

b.Property<bool>("ShowBackdrop")

22

624

.HasColumnType("INTEGER");

22

625

22

626

b.Property<bool>("ShowSidebar")

22

627

.HasColumnType("INTEGER");

22

628

22

629

b.Property<int>("SkipBackwardLength")

22

630

.HasColumnType("INTEGER");

22

631

22

632

b.Property<int>("SkipForwardLength")

22

633

.HasColumnType("INTEGER");

22

634

22

635

b.Property<string>("TvHome")

22

636

.HasMaxLength(32)

22

637

.HasColumnType("TEXT");

22

638

22

639

b.Property<Guid>("UserId")

22

640

.HasColumnType("TEXT");

22

641

22

642

b.HasKey("Id");

22

643

22

644

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

22

645

.IsUnique();

22

646

22

647

b.ToTable("DisplayPreferences");

22

648

22

649

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

22

650

});

22

652

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

22

653

{

22

654

b.Property<int>("Id")

22

655

.ValueGeneratedOnAdd()

22

656

.HasColumnType("INTEGER");

22

657

22

658

b.Property<int>("DisplayPreferencesId")

22

659

.HasColumnType("INTEGER");

22

660

22

661

b.Property<int>("Order")

22

662

.HasColumnType("INTEGER");

22

663

22

664

b.Property<int>("Type")

22

665

.HasColumnType("INTEGER");

22

666

22

667

b.HasKey("Id");

22

668

22

669

b.HasIndex("DisplayPreferencesId");

22

670

22

671

b.ToTable("HomeSection");

22

672

22

673

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

22

674

});

22

676

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

22

677

{

22

678

b.Property<int>("Id")

22

679

.ValueGeneratedOnAdd()

22

680

.HasColumnType("INTEGER");

22

681

22

682

b.Property<DateTime>("LastModified")

22

683

.HasColumnType("TEXT");

22

684

22

685

b.Property<string>("Path")

22

686

.IsRequired()

22

687

.HasMaxLength(512)

22

688

.HasColumnType("TEXT");

22

689

22

690

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

22

691

.HasColumnType("TEXT");

22

692

22

693

b.HasKey("Id");

22

694

22

695

b.HasIndex("UserId")

22

696

.IsUnique();

22

697

22

698

b.ToTable("ImageInfos");

22

699

22

700

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

22

701

});

22

703

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

22

704

{

22

705

b.Property<int>("Id")

22

706

.ValueGeneratedOnAdd()

22

707

.HasColumnType("INTEGER");

22

708

22

709

b.Property<string>("Client")

22

710

.IsRequired()

22

711

.HasMaxLength(32)

22

712

.HasColumnType("TEXT");

22

713

22

714

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

22

715

.HasColumnType("INTEGER");

22

716

22

717

b.Property<Guid>("ItemId")

22

718

.HasColumnType("TEXT");

22

719

22

720

b.Property<bool>("RememberIndexing")

22

721

.HasColumnType("INTEGER");

22

722

22

723

b.Property<bool>("RememberSorting")

22

724

.HasColumnType("INTEGER");

22

725

22

726

b.Property<string>("SortBy")

22

727

.IsRequired()

22

728

.HasMaxLength(64)

22

729

.HasColumnType("TEXT");

22

730

22

731

b.Property<int>("SortOrder")

22

732

.HasColumnType("INTEGER");

22

733

22

734

b.Property<Guid>("UserId")

22

735

.HasColumnType("TEXT");

22

736

22

737

b.Property<int>("ViewType")

22

738

.HasColumnType("INTEGER");

22

739

22

740

b.HasKey("Id");

22

741

22

742

b.HasIndex("UserId");

22

743

22

744

b.ToTable("ItemDisplayPreferences");

22

745

22

746

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

22

747

});

22

749

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

22

750

{

22

751

b.Property<Guid>("ItemValueId")

22

752

.ValueGeneratedOnAdd()

22

753

.HasColumnType("TEXT");

22

754

22

755

b.Property<string>("CleanValue")

22

756

.IsRequired()

22

757

.HasColumnType("TEXT");

22

758

22

759

b.Property<int>("Type")

22

760

.HasColumnType("INTEGER");

22

761

22

762

b.Property<string>("Value")

22

763

.IsRequired()

22

764

.HasColumnType("TEXT");

22

765

22

766

b.HasKey("ItemValueId");

22

767

22

768

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

22

769

22

770

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

22

771

.IsUnique();

22

772

22

773

b.ToTable("ItemValues");

22

774

22

775

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

22

776

});

22

778

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

22

779

{

22

780

b.Property<Guid>("ItemValueId")

22

781

.HasColumnType("TEXT");

22

782

22

783

b.Property<Guid>("ItemId")

22

784

.HasColumnType("TEXT");

22

785

22

786

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

22

787

22

788

b.HasIndex("ItemId");

22

789

22

790

b.ToTable("ItemValuesMap");

22

791

22

792

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

22

793

});

22

795

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

22

796

{

22

797

b.Property<Guid>("ItemId")

22

798

.HasColumnType("TEXT");

22

799

22

800

b.PrimitiveCollection<string>("KeyframeTicks")

22

801

.HasColumnType("TEXT");

22

802

22

803

b.Property<long>("TotalDuration")

22

804

.HasColumnType("INTEGER");

22

805

22

806

b.HasKey("ItemId");

22

807

22

808

b.ToTable("KeyframeData");

22

809

22

810

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

22

811

});

22

813

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

22

814

{

22

815

b.Property<Guid>("ParentId")

22

816

.HasColumnType("TEXT");

22

817

22

818

b.Property<Guid>("ChildId")

22

819

.HasColumnType("TEXT");

22

820

22

821

b.Property<int>("ChildType")

22

822

.HasColumnType("INTEGER");

22

823

22

824

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

22

825

.HasColumnType("INTEGER");

22

826

22

827

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

22

828

22

829

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

22

830

22

831

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

22

832

22

833

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

22

834

22

835

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

22

836

22

837

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

22

838

});

22

840

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

22

841

{

22

842

b.Property<Guid>("Id")

22

843

.ValueGeneratedOnAdd()

22

844

.HasColumnType("TEXT");

22

845

22

846

b.Property<long>("EndTicks")

22

847

.HasColumnType("INTEGER");

22

848

22

849

b.Property<Guid>("ItemId")

22

850

.HasColumnType("TEXT");

22

851

22

852

b.Property<string>("SegmentProviderId")

22

853

.IsRequired()

22

854

.HasColumnType("TEXT");

22

855

22

856

b.Property<long>("StartTicks")

22

857

.HasColumnType("INTEGER");

22

858

22

859

b.Property<int>("Type")

22

860

.HasColumnType("INTEGER");

22

861

22

862

b.HasKey("Id");

22

863

22

864

b.ToTable("MediaSegments");

22

865

22

866

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

22

867

});

22

869

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

22

870

{

22

871

b.Property<Guid>("ItemId")

22

872

.HasColumnType("TEXT");

22

873

22

874

b.Property<int>("StreamIndex")

22

875

.HasColumnType("INTEGER");

22

876

22

877

b.Property<string>("AspectRatio")

22

878

.HasColumnType("TEXT");

22

879

22

880

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

22

881

.HasColumnType("REAL");

22

882

22

883

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

22

884

.HasColumnType("INTEGER");

22

885

22

886

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

22

887

.HasColumnType("INTEGER");

22

888

22

889

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

22

890

.HasColumnType("INTEGER");

22

891

22

892

b.Property<string>("ChannelLayout")

22

893

.HasColumnType("TEXT");

22

894

22

895

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

22

896

.HasColumnType("INTEGER");

22

897

22

898

b.Property<string>("Codec")

22

899

.HasColumnType("TEXT");

22

900

22

901

b.Property<string>("CodecTag")

22

902

.HasColumnType("TEXT");

22

903

22

904

b.Property<string>("CodecTimeBase")

22

905

.HasColumnType("TEXT");

22

906

22

907

b.Property<string>("ColorPrimaries")

22

908

.HasColumnType("TEXT");

22

909

22

910

b.Property<string>("ColorSpace")

22

911

.HasColumnType("TEXT");

22

912

22

913

b.Property<string>("ColorTransfer")

22

914

.HasColumnType("TEXT");

22

915

22

916

b.Property<string>("Comment")

22

917

.HasColumnType("TEXT");

22

918

22

919

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

22

920

.HasColumnType("INTEGER");

22

921

22

922

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

22

923

.HasColumnType("INTEGER");

22

924

22

925

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

22

926

.HasColumnType("INTEGER");

22

927

22

928

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

22

929

.HasColumnType("INTEGER");

22

930

22

931

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

22

932

.HasColumnType("INTEGER");

22

933

22

934

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

22

935

.HasColumnType("INTEGER");

22

936

22

937

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

22

938

.HasColumnType("INTEGER");

22

939

22

940

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

22

941

.HasColumnType("INTEGER");

22

942

22

943

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

22

944

.HasColumnType("INTEGER");

22

945

22

946

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

22

947

.HasColumnType("INTEGER");

22

948

22

949

b.Property<bool>("IsDefault")

22

950

.HasColumnType("INTEGER");

22

951

22

952

b.Property<bool>("IsExternal")

22

953

.HasColumnType("INTEGER");

22

954

22

955

b.Property<bool>("IsForced")

22

956

.HasColumnType("INTEGER");

22

957

22

958

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

22

959

.HasColumnType("INTEGER");

22

960

22

961

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

22

962

.HasColumnType("INTEGER");

22

963

22

964

b.Property<bool>("IsOriginal")

22

965

.HasColumnType("INTEGER");

22

966

22

967

b.Property<string>("KeyFrames")

22

968

.HasColumnType("TEXT");

22

969

22

970

b.Property<string>("Language")

22

971

.HasColumnType("TEXT");

22

972

22

973

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

22

974

.HasColumnType("REAL");

22

975

22

976

b.Property<string>("NalLengthSize")

22

977

.HasColumnType("TEXT");

22

978

22

979

b.Property<string>("Path")

22

980

.HasColumnType("TEXT");

22

981

22

982

b.Property<string>("PixelFormat")

22

983

.HasColumnType("TEXT");

22

984

22

985

b.Property<string>("Profile")

22

986

.HasColumnType("TEXT");

22

987

22

988

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

22

989

.HasColumnType("REAL");

22

990

22

991

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

22

992

.HasColumnType("INTEGER");

22

993

22

994

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

22

995

.HasColumnType("INTEGER");

22

996

22

997

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

22

998

.HasColumnType("INTEGER");

22

999

22

1000

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

22

1001

.HasColumnType("INTEGER");

22

1002

22

1003

b.Property<int>("StreamType")

22

1004

.HasColumnType("INTEGER");

22

1005

22

1006

b.Property<string>("TimeBase")

22

1007

.HasColumnType("TEXT");

22

1008

22

1009

b.Property<string>("Title")

22

1010

.HasColumnType("TEXT");

22

1011

22

1012

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

22

1013

.HasColumnType("INTEGER");

22

1014

22

1015

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

22

1016

22

1017

b.ToTable("MediaStreamInfos");

22

1018

22

1019

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

22

1020

});

22

1022

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

22

1023

{

22

1024

b.Property<Guid>("Id")

22

1025

.ValueGeneratedOnAdd()

22

1026

.HasColumnType("TEXT");

22

1027

22

1028

b.Property<string>("Name")

22

1029

.IsRequired()

22

1030

.HasColumnType("TEXT");

22

1031

22

1032

b.Property<string>("PersonType")

22

1033

.HasColumnType("TEXT");

22

1034

22

1035

b.HasKey("Id");

22

1036

22

1037

b.HasIndex("Name");

22

1038

22

1039

b.ToTable("Peoples");

22

1040

22

1041

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

22

1042

});

22

1044

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

22

1045

{

22

1046

b.Property<Guid>("ItemId")

22

1047

.HasColumnType("TEXT");

22

1048

22

1049

b.Property<Guid>("PeopleId")

22

1050

.HasColumnType("TEXT");

22

1051

22

1052

b.Property<string>("Role")

22

1053

.HasColumnType("TEXT");

22

1054

22

1055

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

22

1056

.HasColumnType("INTEGER");

22

1057

22

1058

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

22

1059

.HasColumnType("INTEGER");

22

1060

22

1061

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

22

1062

22

1063

b.HasIndex("PeopleId");

22

1064

22

1065

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

22

1066

22

1067

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

22

1068

22

1069

b.ToTable("PeopleBaseItemMap");

22

1070

22

1071

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

22

1072

});

22

1074

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

22

1075

{

22

1076

b.Property<int>("Id")

22

1077

.ValueGeneratedOnAdd()

22

1078

.HasColumnType("INTEGER");

22

1079

22

1080

b.Property<int>("Kind")

22

1081

.HasColumnType("INTEGER");

22

1082

22

1083

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

22

1084

.HasColumnType("TEXT");

22

1085

22

1086

b.Property<uint>("RowVersion")

22

1087

.IsConcurrencyToken()

22

1088

.HasColumnType("INTEGER");

22

1089

22

1090

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

22

1091

.HasColumnType("TEXT");

22

1092

22

1093

b.Property<bool>("Value")

22

1094

.HasColumnType("INTEGER");

22

1095

22

1096

b.HasKey("Id");

22

1097

22

1098

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

22

1099

.IsUnique()

22

1100

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

22

1101

22

1102

b.ToTable("Permissions");

22

1103

22

1104

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

22

1105

});

22

1107

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

22

1108

{

22

1109

b.Property<int>("Id")

22

1110

.ValueGeneratedOnAdd()

22

1111

.HasColumnType("INTEGER");

22

1112

22

1113

b.Property<int>("Kind")

22

1114

.HasColumnType("INTEGER");

22

1115

22

1116

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

22

1117

.HasColumnType("TEXT");

22

1118

22

1119

b.Property<uint>("RowVersion")

22

1120

.IsConcurrencyToken()

22

1121

.HasColumnType("INTEGER");

22

1122

22

1123

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

22

1124

.HasColumnType("TEXT");

22

1125

22

1126

b.Property<string>("Value")

22

1127

.IsRequired()

22

1128

.HasMaxLength(65535)

22

1129

.HasColumnType("TEXT");

22

1130

22

1131

b.HasKey("Id");

22

1132

22

1133

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

22

1134

.IsUnique()

22

1135

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

22

1136

22

1137

b.ToTable("Preferences");

22

1138

22

1139

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

22

1140

});

22

1142

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

22

1143

{

22

1144

b.Property<int>("Id")

22

1145

.ValueGeneratedOnAdd()

22

1146

.HasColumnType("INTEGER");

22

1147

22

1148

b.Property<string>("AccessToken")

22

1149

.IsRequired()

22

1150

.HasColumnType("TEXT");

22

1151

22

1152

b.Property<DateTime>("DateCreated")

22

1153

.HasColumnType("TEXT");

22

1154

22

1155

b.Property<DateTime>("DateLastActivity")

22

1156

.HasColumnType("TEXT");

22

1157

22

1158

b.Property<string>("Name")

22

1159

.IsRequired()

22

1160

.HasMaxLength(64)

22

1161

.HasColumnType("TEXT");

22

1162

22

1163

b.HasKey("Id");

22

1164

22

1165

b.HasIndex("AccessToken")

22

1166

.IsUnique();

22

1167

22

1168

b.ToTable("ApiKeys");

22

1169

22

1170

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

22

1171

});

22

1173

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

22

1174

{

22

1175

b.Property<int>("Id")

22

1176

.ValueGeneratedOnAdd()

22

1177

.HasColumnType("INTEGER");

22

1178

22

1179

b.Property<string>("AccessToken")

22

1180

.IsRequired()

22

1181

.HasColumnType("TEXT");

22

1182

22

1183

b.Property<string>("AppName")

22

1184

.IsRequired()

22

1185

.HasMaxLength(64)

22

1186

.HasColumnType("TEXT");

22

1187

22

1188

b.Property<string>("AppVersion")

22

1189

.IsRequired()

22

1190

.HasMaxLength(32)

22

1191

.HasColumnType("TEXT");

22

1192

22

1193

b.Property<DateTime>("DateCreated")

22

1194

.HasColumnType("TEXT");

22

1195

22

1196

b.Property<DateTime>("DateLastActivity")

22

1197

.HasColumnType("TEXT");

22

1198

22

1199

b.Property<DateTime>("DateModified")

22

1200

.HasColumnType("TEXT");

22

1201

22

1202

b.Property<string>("DeviceId")

22

1203

.IsRequired()

22

1204

.HasMaxLength(256)

22

1205

.HasColumnType("TEXT");

22

1206

22

1207

b.Property<string>("DeviceName")

22

1208

.IsRequired()

22

1209

.HasMaxLength(64)

22

1210

.HasColumnType("TEXT");

22

1211

22

1212

b.Property<bool>("IsActive")

22

1213

.HasColumnType("INTEGER");

22

1214

22

1215

b.Property<Guid>("UserId")

22

1216

.HasColumnType("TEXT");

22

1217

22

1218

b.HasKey("Id");

22

1219

22

1220

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

22

1221

22

1222

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

22

1223

22

1224

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

22

1225

22

1226

b.ToTable("Devices");

22

1227

22

1228

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

22

1229

});

22

1231

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

22

1232

{

22

1233

b.Property<int>("Id")

22

1234

.ValueGeneratedOnAdd()

22

1235

.HasColumnType("INTEGER");

22

1236

22

1237

b.Property<string>("CustomName")

22

1238

.HasColumnType("TEXT");

22

1239

22

1240

b.Property<string>("DeviceId")

22

1241

.IsRequired()

22

1242

.HasColumnType("TEXT");

22

1243

22

1244

b.HasKey("Id");

22

1245

22

1246

b.HasIndex("DeviceId")

22

1247

.IsUnique();

22

1248

22

1249

b.ToTable("DeviceOptions");

22

1250

22

1251

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

22

1252

});

22

1254

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

22

1255

{

22

1256

b.Property<Guid>("ItemId")

22

1257

.HasColumnType("TEXT");

22

1258

22

1259

b.Property<int>("Width")

22

1260

.HasColumnType("INTEGER");

22

1261

22

1262

b.Property<int>("Bandwidth")

22

1263

.HasColumnType("INTEGER");

22

1264

22

1265

b.Property<int>("Height")

22

1266

.HasColumnType("INTEGER");

22

1267

22

1268

b.Property<int>("Interval")

22

1269

.HasColumnType("INTEGER");

22

1270

22

1271

b.Property<int>("ThumbnailCount")

22

1272

.HasColumnType("INTEGER");

22

1273

22

1274

b.Property<int>("TileHeight")

22

1275

.HasColumnType("INTEGER");

22

1276

22

1277

b.Property<int>("TileWidth")

22

1278

.HasColumnType("INTEGER");

22

1279

22

1280

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

22

1281

22

1282

b.ToTable("TrickplayInfos");

22

1283

22

1284

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

22

1285

});

22

1287

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

22

1288

{

22

1289

b.Property<Guid>("Id")

22

1290

.ValueGeneratedOnAdd()

22

1291

.HasColumnType("TEXT");

22

1292

22

1293

b.Property<string>("AudioLanguagePreference")

22

1294

.HasMaxLength(255)

22

1295

.HasColumnType("TEXT");

22

1296

22

1297

b.Property<string>("AuthenticationProviderId")

22

1298

.IsRequired()

22

1299

.HasMaxLength(255)

22

1300

.HasColumnType("TEXT");

22

1301

22

1302

b.Property<string>("CastReceiverId")

22

1303

.HasMaxLength(32)

22

1304

.HasColumnType("TEXT");

22

1305

22

1306

b.Property<bool>("DisplayCollectionsView")

22

1307

.HasColumnType("INTEGER");

22

1308

22

1309

b.Property<bool>("DisplayMissingEpisodes")

22

1310

.HasColumnType("INTEGER");

22

1311

22

1312

b.Property<bool>("EnableAutoLogin")

22

1313

.HasColumnType("INTEGER");

22

1314

22

1315

b.Property<bool>("EnableLocalPassword")

22

1316

.HasColumnType("INTEGER");

22

1317

22

1318

b.Property<bool>("EnableNextEpisodeAutoPlay")

22

1319

.HasColumnType("INTEGER");

22

1320

22

1321

b.Property<bool>("EnableUserPreferenceAccess")

22

1322

.HasColumnType("INTEGER");

22

1323

22

1324

b.Property<bool>("HidePlayedInLatest")

22

1325

.HasColumnType("INTEGER");

22

1326

22

1327

b.Property<long>("InternalId")

22

1328

.HasColumnType("INTEGER");

22

1329

22

1330

b.Property<int>("InvalidLoginAttemptCount")

22

1331

.HasColumnType("INTEGER");

22

1332

22

1333

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

22

1334

.HasColumnType("TEXT");

22

1335

22

1336

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

22

1337

.HasColumnType("TEXT");

22

1338

22

1339

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

22

1340

.HasColumnType("INTEGER");

22

1341

22

1342

b.Property<int>("MaxActiveSessions")

22

1343

.HasColumnType("INTEGER");

22

1344

22

1345

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

22

1346

.HasColumnType("INTEGER");

22

1347

22

1348

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

22

1349

.HasColumnType("INTEGER");

22

1350

22

1351

b.Property<bool>("MustUpdatePassword")

22

1352

.HasColumnType("INTEGER");

22

1353

22

1354

b.Property<string>("Password")

22

1355

.HasMaxLength(65535)

22

1356

.HasColumnType("TEXT");

22

1357

22

1358

b.Property<string>("PasswordResetProviderId")

22

1359

.IsRequired()

22

1360

.HasMaxLength(255)

22

1361

.HasColumnType("TEXT");

22

1362

22

1363

b.Property<bool>("PlayDefaultAudioTrack")

22

1364

.HasColumnType("INTEGER");

22

1365

22

1366

b.Property<bool>("RememberAudioSelections")

22

1367

.HasColumnType("INTEGER");

22

1368

22

1369

b.Property<bool>("RememberSubtitleSelections")

22

1370

.HasColumnType("INTEGER");

22

1371

22

1372

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

22

1373

.HasColumnType("INTEGER");

22

1374

22

1375

b.Property<uint>("RowVersion")

22

1376

.IsConcurrencyToken()

22

1377

.HasColumnType("INTEGER");

22

1378

22

1379

b.Property<string>("SubtitleLanguagePreference")

22

1380

.HasMaxLength(255)

22

1381

.HasColumnType("TEXT");

22

1382

22

1383

b.Property<int>("SubtitleMode")

22

1384

.HasColumnType("INTEGER");

22

1385

22

1386

b.Property<int>("SyncPlayAccess")

22

1387

.HasColumnType("INTEGER");

22

1388

22

1389

b.Property<string>("Username")

22

1390

.IsRequired()

22

1391

.HasMaxLength(255)

22

1392

.HasColumnType("TEXT");

22

1393

22

1394

b.HasKey("Id");

22

1395

22

1396

b.HasIndex("Username")

22

1397

.IsUnique();

22

1398

22

1399

b.ToTable("Users");

22

1400

22

1401

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

22

1402

});

22

1404

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

22

1405

{

22

1406

b.Property<Guid>("ItemId")

22

1407

.HasColumnType("TEXT");

22

1408

22

1409

b.Property<Guid>("UserId")

22

1410

.HasColumnType("TEXT");

22

1411

22

1412

b.Property<string>("CustomDataKey")

22

1413

.HasColumnType("TEXT");

22

1414

22

1415

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

22

1416

.HasColumnType("INTEGER");

22

1417

22

1418

b.Property<bool>("IsFavorite")

22

1419

.HasColumnType("INTEGER");

22

1420

22

1421

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

22

1422

.HasColumnType("TEXT");

22

1423

22

1424

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

22

1425

.HasColumnType("INTEGER");

22

1426

22

1427

b.Property<int>("PlayCount")

22

1428

.HasColumnType("INTEGER");

22

1429

22

1430

b.Property<long>("PlaybackPositionTicks")

22

1431

.HasColumnType("INTEGER");

22

1432

22

1433

b.Property<bool>("Played")

22

1434

.HasColumnType("INTEGER");

22

1435

22

1436

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

22

1437

.HasColumnType("REAL");

22

1438

22

1439

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

22

1440

.HasColumnType("TEXT");

22

1441

22

1442

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

22

1443

.HasColumnType("INTEGER");

22

1444

22

1445

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

22

1446

22

1447

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

22

1448

22

1449

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

22

1450

22

1451

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

22

1452

22

1453

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

22

1454

22

1455

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

22

1456

22

1457

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

22

1458

22

1459

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

22

1460

22

1461

b.ToTable("UserData");

22

1462

22

1463

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

22

1464

});

22

1466

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

22

1467

{

22

1468

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

22

1469

.WithMany("AccessSchedules")

22

1470

.HasForeignKey("UserId")

22

1471

.OnDelete(DeleteBehavior.Cascade)

22

1472

.IsRequired();

22

1473

});

22

1475

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

22

1476

{

22

1477

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

22

1478

.WithMany("Parents")

22

1479

.HasForeignKey("ItemId")

22

1480

.OnDelete(DeleteBehavior.Cascade)

22

1481

.IsRequired();

22

1482

22

1483

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

22

1484

.WithMany("Children")

22

1485

.HasForeignKey("ParentItemId")

22

1486

.OnDelete(DeleteBehavior.Cascade)

22

1487

.IsRequired();

22

1488

22

1489

b.Navigation("Item");

22

1490

22

1491

b.Navigation("ParentItem");

22

1492

});

22

1494

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

22

1495

{

22

1496

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

22

1497

.WithMany()

22

1498

.HasForeignKey("ItemId")

22

1499

.OnDelete(DeleteBehavior.Cascade)

22

1500

.IsRequired();

22

1501

22

1502

b.Navigation("Item");

22

1503

});

22

1505

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

22

1506

{

22

1507

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

22

1508

.WithMany("Extras")

22

1509

.HasForeignKey("OwnerId")

22

1510

.OnDelete(DeleteBehavior.NoAction);

22

1511

22

1512

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

22

1513

.WithMany("DirectChildren")

22

1514

.HasForeignKey("ParentId")

22

1515

.OnDelete(DeleteBehavior.Cascade);

22

1516

22

1517

b.Navigation("DirectParent");

22

1518

22

1519

b.Navigation("Owner");

22

1520

});

22

1522

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

22

1523

{

22

1524

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

22

1525

.WithMany("Images")

22

1526

.HasForeignKey("ItemId")

22

1527

.OnDelete(DeleteBehavior.Cascade)

22

1528

.IsRequired();

22

1529

22

1530

b.Navigation("Item");

22

1531

});

22

1533

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

22

1534

{

22

1535

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

22

1536

.WithMany("LockedFields")

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.BaseItemProvider", b =>

22

1545

{

22

1546

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

22

1547

.WithMany("Provider")

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.BaseItemTrailerType", b =>

22

1556

{

22

1557

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

22

1558

.WithMany("TrailerTypes")

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.Chapter", b =>

22

1567

{

22

1568

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

22

1569

.WithMany("Chapters")

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.DisplayPreferences", b =>

22

1578

{

22

1579

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

22

1580

.WithMany("DisplayPreferences")

22

1581

.HasForeignKey("UserId")

22

1582

.OnDelete(DeleteBehavior.Cascade)

22

1583

.IsRequired();

22

1584

});

22

1586

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

22

1587

{

22

1588

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

22

1589

.WithMany("HomeSections")

22

1590

.HasForeignKey("DisplayPreferencesId")

22

1591

.OnDelete(DeleteBehavior.Cascade)

22

1592

.IsRequired();

22

1593

});

22

1595

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

22

1596

{

22

1597

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

22

1598

.WithOne("ProfileImage")

22

1599

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

22

1600

.OnDelete(DeleteBehavior.Cascade);

22

1601

});

22

1603

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

22

1604

{

22

1605

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

22

1606

.WithMany("ItemDisplayPreferences")

22

1607

.HasForeignKey("UserId")

22

1608

.OnDelete(DeleteBehavior.Cascade)

22

1609

.IsRequired();

22

1610

});

22

1612

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

22

1613

{

22

1614

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

22

1615

.WithMany("ItemValues")

22

1616

.HasForeignKey("ItemId")

22

1617

.OnDelete(DeleteBehavior.Cascade)

22

1618

.IsRequired();

22

1619

22

1620

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

22

1621

.WithMany("BaseItemsMap")

22

1622

.HasForeignKey("ItemValueId")

22

1623

.OnDelete(DeleteBehavior.Cascade)

22

1624

.IsRequired();

22

1625

22

1626

b.Navigation("Item");

22

1627

22

1628

b.Navigation("ItemValue");

22

1629

});

22

1631

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

22

1632

{

22

1633

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

22

1634

.WithMany()

22

1635

.HasForeignKey("ItemId")

22

1636

.OnDelete(DeleteBehavior.Cascade)

22

1637

.IsRequired();

22

1638

22

1639

b.Navigation("Item");

22

1640

});

22

1642

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

22

1643

{

22

1644

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

22

1645

.WithMany("LinkedChildOfEntities")

22

1646

.HasForeignKey("ChildId")

22

1647

.OnDelete(DeleteBehavior.NoAction)

22

1648

.IsRequired();

22

1649

22

1650

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

22

1651

.WithMany("LinkedChildEntities")

22

1652

.HasForeignKey("ParentId")

22

1653

.OnDelete(DeleteBehavior.NoAction)

22

1654

.IsRequired();

22

1655

22

1656

b.Navigation("Child");

22

1657

22

1658

b.Navigation("Parent");

22

1659

});

22

1661

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

22

1662

{

22

1663

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

22

1664

.WithMany("MediaStreams")

22

1665

.HasForeignKey("ItemId")

22

1666

.OnDelete(DeleteBehavior.Cascade)

22

1667

.IsRequired();

22

1668

22

1669

b.Navigation("Item");

22

1670

});

22

1672

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

22

1673

{

22

1674

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

22

1675

.WithMany("Peoples")

22

1676

.HasForeignKey("ItemId")

22

1677

.OnDelete(DeleteBehavior.Cascade)

22

1678

.IsRequired();

22

1679

22

1680

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

22

1681

.WithMany("BaseItems")

22

1682

.HasForeignKey("PeopleId")

22

1683

.OnDelete(DeleteBehavior.Cascade)

22

1684

.IsRequired();

22

1685

22

1686

b.Navigation("Item");

22

1687

22

1688

b.Navigation("People");

22

1689

});

22

1691

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

22

1692

{

22

1693

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

22

1694

.WithMany("Permissions")

22

1695

.HasForeignKey("UserId")

22

1696

.OnDelete(DeleteBehavior.Cascade);

22

1697

});

22

1699

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

22

1700

{

22

1701

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

22

1702

.WithMany("Preferences")

22

1703

.HasForeignKey("UserId")

22

1704

.OnDelete(DeleteBehavior.Cascade);

22

1705

});

22

1707

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

22

1708

{

22

1709

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

22

1710

.WithMany()

22

1711

.HasForeignKey("UserId")

22

1712

.OnDelete(DeleteBehavior.Cascade)

22

1713

.IsRequired();

22

1714

22

1715

b.Navigation("User");

22

1716

});

22

1718

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

22

1719

{

22

1720

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

22

1721

.WithMany("UserData")

22

1722

.HasForeignKey("ItemId")

22

1723

.OnDelete(DeleteBehavior.Cascade)

22

1724

.IsRequired();

22

1725

22

1726

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

22

1727

.WithMany()

22

1728

.HasForeignKey("UserId")

22

1729

.OnDelete(DeleteBehavior.Cascade)

22

1730

.IsRequired();

22

1731

22

1732

b.Navigation("Item");

22

1733

22

1734

b.Navigation("User");

22

1735

});

22

1737

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

22

1738

{

22

1739

b.Navigation("Chapters");

22

1740

22

1741

b.Navigation("Children");

22

1742

22

1743

b.Navigation("DirectChildren");

22

1744

22

1745

b.Navigation("Extras");

22

1746

22

1747

b.Navigation("Images");

22

1748

22

1749

b.Navigation("ItemValues");

22

1750

22

1751

b.Navigation("LinkedChildEntities");

22

1752

22

1753

b.Navigation("LinkedChildOfEntities");

22

1754

22

1755

b.Navigation("LockedFields");

22

1756

22

1757

b.Navigation("MediaStreams");

22

1758

22

1759

b.Navigation("Parents");

22

1760

22

1761

b.Navigation("Peoples");

22

1762

22

1763

b.Navigation("Provider");

22

1764

22

1765

b.Navigation("TrailerTypes");

22

1766

22

1767

b.Navigation("UserData");

22

1768

});

22

1770

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

22

1771

{

22

1772

b.Navigation("HomeSections");

22

1773

});

22

1775

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

22

1776

{

22

1777

b.Navigation("BaseItemsMap");

22

1778

});

22

1780

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

22

1781

{

22

1782

b.Navigation("BaseItems");

22

1783

});

22

1785

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

22

1786

{

22

1787

b.Navigation("AccessSchedules");

22

1788

22

1789

b.Navigation("DisplayPreferences");

22

1790

22

1791

b.Navigation("ItemDisplayPreferences");

22

1792

22

1793

b.Navigation("Permissions");

22

1794

22

1795

b.Navigation("Preferences");

22

1796

22

1797

b.Navigation("ProfileImage");

22

1798

});

22

1800

}

< Summary - Jellyfin

Coverage history

Coverage delta

Metrics

File(s)

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260504075755_AddPartialIndexForItemCounts.cs

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260504075755_AddPartialIndexForItemCounts.Designer.cs

Methods/Properties