Jellyfin.Database.Providers.Sqlite.Migrations.AddIndicesToImageInfo - Jellyfin

Class:	Jellyfin.Database.Providers.Sqlite.Migrations.AddIndicesToImageInfo
Assembly:	Jellyfin.Database.Providers.Sqlite
File(s):	File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260118182305_AddIndicesToImageInfo.cs File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260118182305_AddIndicesToImageInfo.Designer.cs

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

22

21

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

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

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("ExtraType", "OwnerId");

22

380

22

381

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

22

382

22

383

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

22

384

22

385

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

22

386

22

387

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

22

388

22

389

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

22

390

22

391

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

22

392

22

393

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

22

394

22

395

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

22

396

22

397

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

22

398

22

399

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

22

400

22

401

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

22

402

22

403

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

22

404

22

405

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

22

406

22

407

b.ToTable("BaseItems");

22

408

22

409

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

22

410

22

411

b.HasData(

22

412

new

22

413

{

22

414

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

22

415

IsFolder = false,

22

416

IsInMixedFolder = false,

22

417

IsLocked = false,

22

418

IsMovie = false,

22

419

IsRepeat = false,

22

420

IsSeries = false,

22

421

IsVirtualItem = false,

22

422

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

22

423

Type = "PLACEHOLDER"

22

424

});

22

425

});

22

427

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

22

428

{

22

429

b.Property<Guid>("Id")

22

430

.ValueGeneratedOnAdd()

22

431

.HasColumnType("TEXT");

22

432

22

433

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

22

434

.HasColumnType("BLOB");

22

435

22

436

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

22

437

.HasColumnType("TEXT");

22

438

22

439

b.Property<int>("Height")

22

440

.HasColumnType("INTEGER");

22

441

22

442

b.Property<int>("ImageType")

22

443

.HasColumnType("INTEGER");

22

444

22

445

b.Property<Guid>("ItemId")

22

446

.HasColumnType("TEXT");

22

447

22

448

b.Property<string>("Path")

22

449

.IsRequired()

22

450

.HasColumnType("TEXT");

22

451

22

452

b.Property<int>("Width")

22

453

.HasColumnType("INTEGER");

22

454

22

455

b.HasKey("Id");

22

456

22

457

b.HasIndex("ItemId");

22

458

22

459

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

22

460

22

461

b.ToTable("BaseItemImageInfos");

22

462

22

463

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

22

464

});

22

466

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

22

467

{

22

468

b.Property<int>("Id")

22

469

.HasColumnType("INTEGER");

22

470

22

471

b.Property<Guid>("ItemId")

22

472

.HasColumnType("TEXT");

22

473

22

474

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

22

475

22

476

b.HasIndex("ItemId");

22

477

22

478

b.ToTable("BaseItemMetadataFields");

22

479

22

480

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

22

481

});

22

483

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

22

484

{

22

485

b.Property<Guid>("ItemId")

22

486

.HasColumnType("TEXT");

22

487

22

488

b.Property<string>("ProviderId")

22

489

.HasColumnType("TEXT");

22

490

22

491

b.Property<string>("ProviderValue")

22

492

.IsRequired()

22

493

.HasColumnType("TEXT");

22

494

22

495

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

22

496

22

497

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

22

498

22

499

b.ToTable("BaseItemProviders");

22

500

22

501

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

22

502

});

22

504

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

22

505

{

22

506

b.Property<int>("Id")

22

507

.HasColumnType("INTEGER");

22

508

22

509

b.Property<Guid>("ItemId")

22

510

.HasColumnType("TEXT");

22

511

22

512

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

22

513

22

514

b.HasIndex("ItemId");

22

515

22

516

b.ToTable("BaseItemTrailerTypes");

22

517

22

518

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

22

519

});

22

521

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

22

522

{

22

523

b.Property<Guid>("ItemId")

22

524

.HasColumnType("TEXT");

22

525

22

526

b.Property<int>("ChapterIndex")

22

527

.HasColumnType("INTEGER");

22

528

22

529

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

22

530

.HasColumnType("TEXT");

22

531

22

532

b.Property<string>("ImagePath")

22

533

.HasColumnType("TEXT");

22

534

22

535

b.Property<string>("Name")

22

536

.HasColumnType("TEXT");

22

537

22

538

b.Property<long>("StartPositionTicks")

22

539

.HasColumnType("INTEGER");

22

540

22

541

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

22

542

22

543

b.ToTable("Chapters");

22

544

22

545

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

22

546

});

22

548

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

22

549

{

22

550

b.Property<int>("Id")

22

551

.ValueGeneratedOnAdd()

22

552

.HasColumnType("INTEGER");

22

553

22

554

b.Property<string>("Client")

22

555

.IsRequired()

22

556

.HasMaxLength(32)

22

557

.HasColumnType("TEXT");

22

558

22

559

b.Property<Guid>("ItemId")

22

560

.HasColumnType("TEXT");

22

561

22

562

b.Property<string>("Key")

22

563

.IsRequired()

22

564

.HasColumnType("TEXT");

22

565

22

566

b.Property<Guid>("UserId")

22

567

.HasColumnType("TEXT");

22

568

22

569

b.Property<string>("Value")

22

570

.HasColumnType("TEXT");

22

571

22

572

b.HasKey("Id");

22

573

22

574

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

22

575

.IsUnique();

22

576

22

577

b.ToTable("CustomItemDisplayPreferences");

22

578

22

579

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

22

580

});

22

582

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

22

583

{

22

584

b.Property<int>("Id")

22

585

.ValueGeneratedOnAdd()

22

586

.HasColumnType("INTEGER");

22

587

22

588

b.Property<int>("ChromecastVersion")

22

589

.HasColumnType("INTEGER");

22

590

22

591

b.Property<string>("Client")

22

592

.IsRequired()

22

593

.HasMaxLength(32)

22

594

.HasColumnType("TEXT");

22

595

22

596

b.Property<string>("DashboardTheme")

22

597

.HasMaxLength(32)

22

598

.HasColumnType("TEXT");

22

599

22

600

b.Property<bool>("EnableNextVideoInfoOverlay")

22

601

.HasColumnType("INTEGER");

22

602

22

603

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

22

604

.HasColumnType("INTEGER");

22

605

22

606

b.Property<Guid>("ItemId")

22

607

.HasColumnType("TEXT");

22

608

22

609

b.Property<int>("ScrollDirection")

22

610

.HasColumnType("INTEGER");

22

611

22

612

b.Property<bool>("ShowBackdrop")

22

613

.HasColumnType("INTEGER");

22

614

22

615

b.Property<bool>("ShowSidebar")

22

616

.HasColumnType("INTEGER");

22

617

22

618

b.Property<int>("SkipBackwardLength")

22

619

.HasColumnType("INTEGER");

22

620

22

621

b.Property<int>("SkipForwardLength")

22

622

.HasColumnType("INTEGER");

22

623

22

624

b.Property<string>("TvHome")

22

625

.HasMaxLength(32)

22

626

.HasColumnType("TEXT");

22

627

22

628

b.Property<Guid>("UserId")

22

629

.HasColumnType("TEXT");

22

630

22

631

b.HasKey("Id");

22

632

22

633

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

22

634

.IsUnique();

22

635

22

636

b.ToTable("DisplayPreferences");

22

637

22

638

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

22

639

});

22

641

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

22

642

{

22

643

b.Property<int>("Id")

22

644

.ValueGeneratedOnAdd()

22

645

.HasColumnType("INTEGER");

22

646

22

647

b.Property<int>("DisplayPreferencesId")

22

648

.HasColumnType("INTEGER");

22

649

22

650

b.Property<int>("Order")

22

651

.HasColumnType("INTEGER");

22

652

22

653

b.Property<int>("Type")

22

654

.HasColumnType("INTEGER");

22

655

22

656

b.HasKey("Id");

22

657

22

658

b.HasIndex("DisplayPreferencesId");

22

659

22

660

b.ToTable("HomeSection");

22

661

22

662

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

22

663

});

22

665

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

22

666

{

22

667

b.Property<int>("Id")

22

668

.ValueGeneratedOnAdd()

22

669

.HasColumnType("INTEGER");

22

670

22

671

b.Property<DateTime>("LastModified")

22

672

.HasColumnType("TEXT");

22

673

22

674

b.Property<string>("Path")

22

675

.IsRequired()

22

676

.HasMaxLength(512)

22

677

.HasColumnType("TEXT");

22

678

22

679

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

22

680

.HasColumnType("TEXT");

22

681

22

682

b.HasKey("Id");

22

683

22

684

b.HasIndex("UserId")

22

685

.IsUnique();

22

686

22

687

b.ToTable("ImageInfos");

22

688

22

689

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

22

690

});

22

692

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

22

693

{

22

694

b.Property<int>("Id")

22

695

.ValueGeneratedOnAdd()

22

696

.HasColumnType("INTEGER");

22

697

22

698

b.Property<string>("Client")

22

699

.IsRequired()

22

700

.HasMaxLength(32)

22

701

.HasColumnType("TEXT");

22

702

22

703

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

22

704

.HasColumnType("INTEGER");

22

705

22

706

b.Property<Guid>("ItemId")

22

707

.HasColumnType("TEXT");

22

708

22

709

b.Property<bool>("RememberIndexing")

22

710

.HasColumnType("INTEGER");

22

711

22

712

b.Property<bool>("RememberSorting")

22

713

.HasColumnType("INTEGER");

22

714

22

715

b.Property<string>("SortBy")

22

716

.IsRequired()

22

717

.HasMaxLength(64)

22

718

.HasColumnType("TEXT");

22

719

22

720

b.Property<int>("SortOrder")

22

721

.HasColumnType("INTEGER");

22

722

22

723

b.Property<Guid>("UserId")

22

724

.HasColumnType("TEXT");

22

725

22

726

b.Property<int>("ViewType")

22

727

.HasColumnType("INTEGER");

22

728

22

729

b.HasKey("Id");

22

730

22

731

b.HasIndex("UserId");

22

732

22

733

b.ToTable("ItemDisplayPreferences");

22

734

22

735

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

22

736

});

22

738

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

22

739

{

22

740

b.Property<Guid>("ItemValueId")

22

741

.ValueGeneratedOnAdd()

22

742

.HasColumnType("TEXT");

22

743

22

744

b.Property<string>("CleanValue")

22

745

.IsRequired()

22

746

.HasColumnType("TEXT");

22

747

22

748

b.Property<int>("Type")

22

749

.HasColumnType("INTEGER");

22

750

22

751

b.Property<string>("Value")

22

752

.IsRequired()

22

753

.HasColumnType("TEXT");

22

754

22

755

b.HasKey("ItemValueId");

22

756

22

757

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

22

758

22

759

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

22

760

.IsUnique();

22

761

22

762

b.ToTable("ItemValues");

22

763

22

764

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

22

765

});

22

767

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

22

768

{

22

769

b.Property<Guid>("ItemValueId")

22

770

.HasColumnType("TEXT");

22

771

22

772

b.Property<Guid>("ItemId")

22

773

.HasColumnType("TEXT");

22

774

22

775

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

22

776

22

777

b.HasIndex("ItemId");

22

778

22

779

b.ToTable("ItemValuesMap");

22

780

22

781

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

22

782

});

22

784

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

22

785

{

22

786

b.Property<Guid>("ItemId")

22

787

.HasColumnType("TEXT");

22

788

22

789

b.PrimitiveCollection<string>("KeyframeTicks")

22

790

.HasColumnType("TEXT");

22

791

22

792

b.Property<long>("TotalDuration")

22

793

.HasColumnType("INTEGER");

22

794

22

795

b.HasKey("ItemId");

22

796

22

797

b.ToTable("KeyframeData");

22

798

22

799

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

22

800

});

22

802

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

22

803

{

22

804

b.Property<Guid>("ParentId")

22

805

.HasColumnType("TEXT");

22

806

22

807

b.Property<Guid>("ChildId")

22

808

.HasColumnType("TEXT");

22

809

22

810

b.Property<int>("ChildType")

22

811

.HasColumnType("INTEGER");

22

812

22

813

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

22

814

.HasColumnType("INTEGER");

22

815

22

816

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

22

817

22

818

b.HasIndex("ChildId");

22

819

22

820

b.HasIndex("ParentId");

22

821

22

822

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

22

823

22

824

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

22

825

22

826

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

22

827

22

828

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

22

829

22

830

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

22

831

});

22

833

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

22

834

{

22

835

b.Property<Guid>("Id")

22

836

.ValueGeneratedOnAdd()

22

837

.HasColumnType("TEXT");

22

838

22

839

b.Property<long>("EndTicks")

22

840

.HasColumnType("INTEGER");

22

841

22

842

b.Property<Guid>("ItemId")

22

843

.HasColumnType("TEXT");

22

844

22

845

b.Property<string>("SegmentProviderId")

22

846

.IsRequired()

22

847

.HasColumnType("TEXT");

22

848

22

849

b.Property<long>("StartTicks")

22

850

.HasColumnType("INTEGER");

22

851

22

852

b.Property<int>("Type")

22

853

.HasColumnType("INTEGER");

22

854

22

855

b.HasKey("Id");

22

856

22

857

b.ToTable("MediaSegments");

22

858

22

859

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

22

860

});

22

862

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

22

863

{

22

864

b.Property<Guid>("ItemId")

22

865

.HasColumnType("TEXT");

22

866

22

867

b.Property<int>("StreamIndex")

22

868

.HasColumnType("INTEGER");

22

869

22

870

b.Property<string>("AspectRatio")

22

871

.HasColumnType("TEXT");

22

872

22

873

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

22

874

.HasColumnType("REAL");

22

875

22

876

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

22

877

.HasColumnType("INTEGER");

22

878

22

879

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

22

880

.HasColumnType("INTEGER");

22

881

22

882

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

22

883

.HasColumnType("INTEGER");

22

884

22

885

b.Property<string>("ChannelLayout")

22

886

.HasColumnType("TEXT");

22

887

22

888

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

22

889

.HasColumnType("INTEGER");

22

890

22

891

b.Property<string>("Codec")

22

892

.HasColumnType("TEXT");

22

893

22

894

b.Property<string>("CodecTag")

22

895

.HasColumnType("TEXT");

22

896

22

897

b.Property<string>("CodecTimeBase")

22

898

.HasColumnType("TEXT");

22

899

22

900

b.Property<string>("ColorPrimaries")

22

901

.HasColumnType("TEXT");

22

902

22

903

b.Property<string>("ColorSpace")

22

904

.HasColumnType("TEXT");

22

905

22

906

b.Property<string>("ColorTransfer")

22

907

.HasColumnType("TEXT");

22

908

22

909

b.Property<string>("Comment")

22

910

.HasColumnType("TEXT");

22

911

22

912

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

22

913

.HasColumnType("INTEGER");

22

914

22

915

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

22

916

.HasColumnType("INTEGER");

22

917

22

918

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

22

919

.HasColumnType("INTEGER");

22

920

22

921

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

22

922

.HasColumnType("INTEGER");

22

923

22

924

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

22

925

.HasColumnType("INTEGER");

22

926

22

927

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

22

928

.HasColumnType("INTEGER");

22

929

22

930

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

22

931

.HasColumnType("INTEGER");

22

932

22

933

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

22

934

.HasColumnType("INTEGER");

22

935

22

936

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

22

937

.HasColumnType("INTEGER");

22

938

22

939

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

22

940

.HasColumnType("INTEGER");

22

941

22

942

b.Property<bool>("IsDefault")

22

943

.HasColumnType("INTEGER");

22

944

22

945

b.Property<bool>("IsExternal")

22

946

.HasColumnType("INTEGER");

22

947

22

948

b.Property<bool>("IsForced")

22

949

.HasColumnType("INTEGER");

22

950

22

951

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

22

952

.HasColumnType("INTEGER");

22

953

22

954

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

22

955

.HasColumnType("INTEGER");

22

956

22

957

b.Property<string>("KeyFrames")

22

958

.HasColumnType("TEXT");

22

959

22

960

b.Property<string>("Language")

22

961

.HasColumnType("TEXT");

22

962

22

963

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

22

964

.HasColumnType("REAL");

22

965

22

966

b.Property<string>("NalLengthSize")

22

967

.HasColumnType("TEXT");

22

968

22

969

b.Property<string>("Path")

22

970

.HasColumnType("TEXT");

22

971

22

972

b.Property<string>("PixelFormat")

22

973

.HasColumnType("TEXT");

22

974

22

975

b.Property<string>("Profile")

22

976

.HasColumnType("TEXT");

22

977

22

978

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

22

979

.HasColumnType("REAL");

22

980

22

981

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

22

982

.HasColumnType("INTEGER");

22

983

22

984

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

22

985

.HasColumnType("INTEGER");

22

986

22

987

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

22

988

.HasColumnType("INTEGER");

22

989

22

990

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

22

991

.HasColumnType("INTEGER");

22

992

22

993

b.Property<int>("StreamType")

22

994

.HasColumnType("INTEGER");

22

995

22

996

b.Property<string>("TimeBase")

22

997

.HasColumnType("TEXT");

22

998

22

999

b.Property<string>("Title")

22

1000

.HasColumnType("TEXT");

22

1001

22

1002

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

22

1003

.HasColumnType("INTEGER");

22

1004

22

1005

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

22

1006

22

1007

b.HasIndex("StreamIndex");

22

1008

22

1009

b.HasIndex("StreamType");

22

1010

22

1011

b.HasIndex("StreamIndex", "StreamType");

22

1012

22

1013

b.HasIndex("StreamIndex", "StreamType", "Language");

22

1014

22

1015

b.ToTable("MediaStreamInfos");

22

1016

22

1017

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

22

1018

});

22

1020

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

22

1021

{

22

1022

b.Property<Guid>("Id")

22

1023

.ValueGeneratedOnAdd()

22

1024

.HasColumnType("TEXT");

22

1025

22

1026

b.Property<string>("Name")

22

1027

.IsRequired()

22

1028

.HasColumnType("TEXT");

22

1029

22

1030

b.Property<string>("PersonType")

22

1031

.HasColumnType("TEXT");

22

1032

22

1033

b.HasKey("Id");

22

1034

22

1035

b.HasIndex("Name");

22

1036

22

1037

b.ToTable("Peoples");

22

1038

22

1039

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

22

1040

});

22

1042

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

22

1043

{

22

1044

b.Property<Guid>("ItemId")

22

1045

.HasColumnType("TEXT");

22

1046

22

1047

b.Property<Guid>("PeopleId")

22

1048

.HasColumnType("TEXT");

22

1049

22

1050

b.Property<string>("Role")

22

1051

.HasColumnType("TEXT");

22

1052

22

1053

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

22

1054

.HasColumnType("INTEGER");

22

1055

22

1056

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

22

1057

.HasColumnType("INTEGER");

22

1058

22

1059

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

22

1060

22

1061

b.HasIndex("PeopleId");

22

1062

22

1063

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

22

1064

22

1065

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

22

1066

22

1067

b.ToTable("PeopleBaseItemMap");

22

1068

22

1069

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

22

1070

});

22

1072

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

22

1073

{

22

1074

b.Property<int>("Id")

22

1075

.ValueGeneratedOnAdd()

22

1076

.HasColumnType("INTEGER");

22

1077

22

1078

b.Property<int>("Kind")

22

1079

.HasColumnType("INTEGER");

22

1080

22

1081

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

22

1082

.HasColumnType("TEXT");

22

1083

22

1084

b.Property<uint>("RowVersion")

22

1085

.IsConcurrencyToken()

22

1086

.HasColumnType("INTEGER");

22

1087

22

1088

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

22

1089

.HasColumnType("TEXT");

22

1090

22

1091

b.Property<bool>("Value")

22

1092

.HasColumnType("INTEGER");

22

1093

22

1094

b.HasKey("Id");

22

1095

22

1096

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

22

1097

.IsUnique()

22

1098

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

22

1099

22

1100

b.ToTable("Permissions");

22

1101

22

1102

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

22

1103

});

22

1105

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

22

1106

{

22

1107

b.Property<int>("Id")

22

1108

.ValueGeneratedOnAdd()

22

1109

.HasColumnType("INTEGER");

22

1110

22

1111

b.Property<int>("Kind")

22

1112

.HasColumnType("INTEGER");

22

1113

22

1114

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

22

1115

.HasColumnType("TEXT");

22

1116

22

1117

b.Property<uint>("RowVersion")

22

1118

.IsConcurrencyToken()

22

1119

.HasColumnType("INTEGER");

22

1120

22

1121

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

22

1122

.HasColumnType("TEXT");

22

1123

22

1124

b.Property<string>("Value")

22

1125

.IsRequired()

22

1126

.HasMaxLength(65535)

22

1127

.HasColumnType("TEXT");

22

1128

22

1129

b.HasKey("Id");

22

1130

22

1131

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

22

1132

.IsUnique()

22

1133

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

22

1134

22

1135

b.ToTable("Preferences");

22

1136

22

1137

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

22

1138

});

22

1140

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

22

1141

{

22

1142

b.Property<int>("Id")

22

1143

.ValueGeneratedOnAdd()

22

1144

.HasColumnType("INTEGER");

22

1145

22

1146

b.Property<string>("AccessToken")

22

1147

.IsRequired()

22

1148

.HasColumnType("TEXT");

22

1149

22

1150

b.Property<DateTime>("DateCreated")

22

1151

.HasColumnType("TEXT");

22

1152

22

1153

b.Property<DateTime>("DateLastActivity")

22

1154

.HasColumnType("TEXT");

22

1155

22

1156

b.Property<string>("Name")

22

1157

.IsRequired()

22

1158

.HasMaxLength(64)

22

1159

.HasColumnType("TEXT");

22

1160

22

1161

b.HasKey("Id");

22

1162

22

1163

b.HasIndex("AccessToken")

22

1164

.IsUnique();

22

1165

22

1166

b.ToTable("ApiKeys");

22

1167

22

1168

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

22

1169

});

22

1171

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

22

1172

{

22

1173

b.Property<int>("Id")

22

1174

.ValueGeneratedOnAdd()

22

1175

.HasColumnType("INTEGER");

22

1176

22

1177

b.Property<string>("AccessToken")

22

1178

.IsRequired()

22

1179

.HasColumnType("TEXT");

22

1180

22

1181

b.Property<string>("AppName")

22

1182

.IsRequired()

22

1183

.HasMaxLength(64)

22

1184

.HasColumnType("TEXT");

22

1185

22

1186

b.Property<string>("AppVersion")

22

1187

.IsRequired()

22

1188

.HasMaxLength(32)

22

1189

.HasColumnType("TEXT");

22

1190

22

1191

b.Property<DateTime>("DateCreated")

22

1192

.HasColumnType("TEXT");

22

1193

22

1194

b.Property<DateTime>("DateLastActivity")

22

1195

.HasColumnType("TEXT");

22

1196

22

1197

b.Property<DateTime>("DateModified")

22

1198

.HasColumnType("TEXT");

22

1199

22

1200

b.Property<string>("DeviceId")

22

1201

.IsRequired()

22

1202

.HasMaxLength(256)

22

1203

.HasColumnType("TEXT");

22

1204

22

1205

b.Property<string>("DeviceName")

22

1206

.IsRequired()

22

1207

.HasMaxLength(64)

22

1208

.HasColumnType("TEXT");

22

1209

22

1210

b.Property<bool>("IsActive")

22

1211

.HasColumnType("INTEGER");

22

1212

22

1213

b.Property<Guid>("UserId")

22

1214

.HasColumnType("TEXT");

22

1215

22

1216

b.HasKey("Id");

22

1217

22

1218

b.HasIndex("DeviceId");

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", "ItemId", "LastPlayedDate");

22

1456

22

1457

b.ToTable("UserData");

22

1458

22

1459

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

22

1460

});

22

1462

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

22

1463

{

22

1464

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

22

1465

.WithMany("AccessSchedules")

22

1466

.HasForeignKey("UserId")

22

1467

.OnDelete(DeleteBehavior.Cascade)

22

1468

.IsRequired();

22

1469

});

22

1471

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

22

1472

{

22

1473

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

22

1474

.WithMany("Parents")

22

1475

.HasForeignKey("ItemId")

22

1476

.OnDelete(DeleteBehavior.Cascade)

22

1477

.IsRequired();

22

1478

22

1479

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

22

1480

.WithMany("Children")

22

1481

.HasForeignKey("ParentItemId")

22

1482

.OnDelete(DeleteBehavior.Cascade)

22

1483

.IsRequired();

22

1484

22

1485

b.Navigation("Item");

22

1486

22

1487

b.Navigation("ParentItem");

22

1488

});

22

1490

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

22

1491

{

22

1492

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

22

1493

.WithMany()

22

1494

.HasForeignKey("ItemId")

22

1495

.OnDelete(DeleteBehavior.Cascade)

22

1496

.IsRequired();

22

1497

22

1498

b.Navigation("Item");

22

1499

});

22

1501

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

22

1502

{

22

1503

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

22

1504

.WithMany("Extras")

22

1505

.HasForeignKey("OwnerId")

22

1506

.OnDelete(DeleteBehavior.NoAction);

22

1507

22

1508

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

22

1509

.WithMany("DirectChildren")

22

1510

.HasForeignKey("ParentId")

22

1511

.OnDelete(DeleteBehavior.Cascade);

22

1512

22

1513

b.Navigation("DirectParent");

22

1514

22

1515

b.Navigation("Owner");

22

1516

});

22

1518

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

22

1519

{

22

1520

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

22

1521

.WithMany("Images")

22

1522

.HasForeignKey("ItemId")

22

1523

.OnDelete(DeleteBehavior.Cascade)

22

1524

.IsRequired();

22

1525

22

1526

b.Navigation("Item");

22

1527

});

22

1529

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

22

1530

{

22

1531

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

22

1532

.WithMany("LockedFields")

22

1533

.HasForeignKey("ItemId")

22

1534

.OnDelete(DeleteBehavior.Cascade)

22

1535

.IsRequired();

22

1536

22

1537

b.Navigation("Item");

22

1538

});

22

1540

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

22

1541

{

22

1542

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

22

1543

.WithMany("Provider")

22

1544

.HasForeignKey("ItemId")

22

1545

.OnDelete(DeleteBehavior.Cascade)

22

1546

.IsRequired();

22

1547

22

1548

b.Navigation("Item");

22

1549

});

22

1551

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

22

1552

{

22

1553

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

22

1554

.WithMany("TrailerTypes")

22

1555

.HasForeignKey("ItemId")

22

1556

.OnDelete(DeleteBehavior.Cascade)

22

1557

.IsRequired();

22

1558

22

1559

b.Navigation("Item");

22

1560

});

22

1562

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

22

1563

{

22

1564

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

22

1565

.WithMany("Chapters")

22

1566

.HasForeignKey("ItemId")

22

1567

.OnDelete(DeleteBehavior.Cascade)

22

1568

.IsRequired();

22

1569

22

1570

b.Navigation("Item");

22

1571

});

22

1573

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

22

1574

{

22

1575

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

22

1576

.WithMany("DisplayPreferences")

22

1577

.HasForeignKey("UserId")

22

1578

.OnDelete(DeleteBehavior.Cascade)

22

1579

.IsRequired();

22

1580

});

22

1582

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

22

1583

{

22

1584

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

22

1585

.WithMany("HomeSections")

22

1586

.HasForeignKey("DisplayPreferencesId")

22

1587

.OnDelete(DeleteBehavior.Cascade)

22

1588

.IsRequired();

22

1589

});

22

1591

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

22

1592

{

22

1593

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

22

1594

.WithOne("ProfileImage")

22

1595

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

22

1596

.OnDelete(DeleteBehavior.Cascade);

22

1597

});

22

1599

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

22

1600

{

22

1601

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

22

1602

.WithMany("ItemDisplayPreferences")

22

1603

.HasForeignKey("UserId")

22

1604

.OnDelete(DeleteBehavior.Cascade)

22

1605

.IsRequired();

22

1606

});

22

1608

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

22

1609

{

22

1610

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

22

1611

.WithMany("ItemValues")

22

1612

.HasForeignKey("ItemId")

22

1613

.OnDelete(DeleteBehavior.Cascade)

22

1614

.IsRequired();

22

1615

22

1616

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

22

1617

.WithMany("BaseItemsMap")

22

1618

.HasForeignKey("ItemValueId")

22

1619

.OnDelete(DeleteBehavior.Cascade)

22

1620

.IsRequired();

22

1621

22

1622

b.Navigation("Item");

22

1623

22

1624

b.Navigation("ItemValue");

22

1625

});

22

1627

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

22

1628

{

22

1629

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

22

1630

.WithMany()

22

1631

.HasForeignKey("ItemId")

22

1632

.OnDelete(DeleteBehavior.Cascade)

22

1633

.IsRequired();

22

1634

22

1635

b.Navigation("Item");

22

1636

});

22

1638

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

22

1639

{

22

1640

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

22

1641

.WithMany("LinkedChildOfEntities")

22

1642

.HasForeignKey("ChildId")

22

1643

.OnDelete(DeleteBehavior.NoAction)

22

1644

.IsRequired();

22

1645

22

1646

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

22

1647

.WithMany("LinkedChildEntities")

22

1648

.HasForeignKey("ParentId")

22

1649

.OnDelete(DeleteBehavior.NoAction)

22

1650

.IsRequired();

22

1651

22

1652

b.Navigation("Child");

22

1653

22

1654

b.Navigation("Parent");

22

1655

});

22

1657

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

22

1658

{

22

1659

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

22

1660

.WithMany("MediaStreams")

22

1661

.HasForeignKey("ItemId")

22

1662

.OnDelete(DeleteBehavior.Cascade)

22

1663

.IsRequired();

22

1664

22

1665

b.Navigation("Item");

22

1666

});

22

1668

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

22

1669

{

22

1670

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

22

1671

.WithMany("Peoples")

22

1672

.HasForeignKey("ItemId")

22

1673

.OnDelete(DeleteBehavior.Cascade)

22

1674

.IsRequired();

22

1675

22

1676

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

22

1677

.WithMany("BaseItems")

22

1678

.HasForeignKey("PeopleId")

22

1679

.OnDelete(DeleteBehavior.Cascade)

22

1680

.IsRequired();

22

1681

22

1682

b.Navigation("Item");

22

1683

22

1684

b.Navigation("People");

22

1685

});

22

1687

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

22

1688

{

22

1689

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

22

1690

.WithMany("Permissions")

22

1691

.HasForeignKey("UserId")

22

1692

.OnDelete(DeleteBehavior.Cascade);

22

1693

});

22

1695

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

22

1696

{

22

1697

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

22

1698

.WithMany("Preferences")

22

1699

.HasForeignKey("UserId")

22

1700

.OnDelete(DeleteBehavior.Cascade);

22

1701

});

22

1703

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

22

1704

{

22

1705

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

22

1706

.WithMany()

22

1707

.HasForeignKey("UserId")

22

1708

.OnDelete(DeleteBehavior.Cascade)

22

1709

.IsRequired();

22

1710

22

1711

b.Navigation("User");

22

1712

});

22

1714

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

22

1715

{

22

1716

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

22

1717

.WithMany("UserData")

22

1718

.HasForeignKey("ItemId")

22

1719

.OnDelete(DeleteBehavior.Cascade)

22

1720

.IsRequired();

22

1721

22

1722

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

22

1723

.WithMany()

22

1724

.HasForeignKey("UserId")

22

1725

.OnDelete(DeleteBehavior.Cascade)

22

1726

.IsRequired();

22

1727

22

1728

b.Navigation("Item");

22

1729

22

1730

b.Navigation("User");

22

1731

});

22

1733

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

22

1734

{

22

1735

b.Navigation("Chapters");

22

1736

22

1737

b.Navigation("Children");

22

1738

22

1739

b.Navigation("DirectChildren");

22

1740

22

1741

b.Navigation("Extras");

22

1742

22

1743

b.Navigation("Images");

22

1744

22

1745

b.Navigation("ItemValues");

22

1746

22

1747

b.Navigation("LinkedChildEntities");

22

1748

22

1749

b.Navigation("LinkedChildOfEntities");

22

1750

22

1751

b.Navigation("LockedFields");

22

1752

22

1753

b.Navigation("MediaStreams");

22

1754

22

1755

b.Navigation("Parents");

22

1756

22

1757

b.Navigation("Peoples");

22

1758

22

1759

b.Navigation("Provider");

22

1760

22

1761

b.Navigation("TrailerTypes");

22

1762

22

1763

b.Navigation("UserData");

22

1764

});

22

1766

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

22

1767

{

22

1768

b.Navigation("HomeSections");

22

1769

});

22

1771

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

22

1772

{

22

1773

b.Navigation("BaseItemsMap");

22

1774

});

22

1776

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

22

1777

{

22

1778

b.Navigation("BaseItems");

22

1779

});

22

1781

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

22

1782

{

22

1783

b.Navigation("AccessSchedules");

22

1784

22

1785

b.Navigation("DisplayPreferences");

22

1786

22

1787

b.Navigation("ItemDisplayPreferences");

22

1788

22

1789

b.Navigation("Permissions");

22

1790

22

1791

b.Navigation("Preferences");

22

1792

22

1793

b.Navigation("ProfileImage");

22

1794

});

22

1796

}

< Summary - Jellyfin

Coverage history

Coverage delta

Metrics

File(s)

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260118182305_AddIndicesToImageInfo.cs

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260118182305_AddIndicesToImageInfo.Designer.cs

Methods/Properties