Jellyfin.Database.Providers.Sqlite.Migrations.AddTypeCleanNameIndex - Jellyfin

Class:	Jellyfin.Database.Providers.Sqlite.Migrations.AddTypeCleanNameIndex
Assembly:	Jellyfin.Database.Providers.Sqlite
File(s):	File 1: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260308123920_AddTypeCleanNameIndex.cs File 2: /srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260308123920_AddTypeCleanNameIndex.Designer.cs

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

22

21

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

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("Type", "TopParentId", "Id");

22

392

22

393

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

22

394

22

395

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

22

396

22

397

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

22

398

22

399

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

22

400

22

401

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

22

402

22

403

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

22

404

22

405

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

22

406

22

407

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

22

408

22

409

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

22

410

22

411

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

22

412

22

413

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

22

414

22

415

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

22

416

22

417

b.ToTable("BaseItems");

22

418

22

419

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

22

420

22

421

b.HasData(

22

422

new

22

423

{

22

424

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

22

425

IsFolder = false,

22

426

IsInMixedFolder = false,

22

427

IsLocked = false,

22

428

IsMovie = false,

22

429

IsRepeat = false,

22

430

IsSeries = false,

22

431

IsVirtualItem = false,

22

432

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

22

433

Type = "PLACEHOLDER"

22

434

});

22

435

});

22

437

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

22

438

{

22

439

b.Property<Guid>("Id")

22

440

.ValueGeneratedOnAdd()

22

441

.HasColumnType("TEXT");

22

442

22

443

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

22

444

.HasColumnType("BLOB");

22

445

22

446

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

22

447

.HasColumnType("TEXT");

22

448

22

449

b.Property<int>("Height")

22

450

.HasColumnType("INTEGER");

22

451

22

452

b.Property<int>("ImageType")

22

453

.HasColumnType("INTEGER");

22

454

22

455

b.Property<Guid>("ItemId")

22

456

.HasColumnType("TEXT");

22

457

22

458

b.Property<string>("Path")

22

459

.IsRequired()

22

460

.HasColumnType("TEXT");

22

461

22

462

b.Property<int>("Width")

22

463

.HasColumnType("INTEGER");

22

464

22

465

b.HasKey("Id");

22

466

22

467

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

22

468

22

469

b.ToTable("BaseItemImageInfos");

22

470

22

471

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

22

472

});

22

474

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

22

475

{

22

476

b.Property<int>("Id")

22

477

.HasColumnType("INTEGER");

22

478

22

479

b.Property<Guid>("ItemId")

22

480

.HasColumnType("TEXT");

22

481

22

482

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

22

483

22

484

b.HasIndex("ItemId");

22

485

22

486

b.ToTable("BaseItemMetadataFields");

22

487

22

488

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

22

489

});

22

491

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

22

492

{

22

493

b.Property<Guid>("ItemId")

22

494

.HasColumnType("TEXT");

22

495

22

496

b.Property<string>("ProviderId")

22

497

.HasColumnType("TEXT");

22

498

22

499

b.Property<string>("ProviderValue")

22

500

.IsRequired()

22

501

.HasColumnType("TEXT");

22

502

22

503

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

22

504

22

505

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

22

506

22

507

b.ToTable("BaseItemProviders");

22

508

22

509

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

22

510

});

22

512

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

22

513

{

22

514

b.Property<int>("Id")

22

515

.HasColumnType("INTEGER");

22

516

22

517

b.Property<Guid>("ItemId")

22

518

.HasColumnType("TEXT");

22

519

22

520

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

22

521

22

522

b.HasIndex("ItemId");

22

523

22

524

b.ToTable("BaseItemTrailerTypes");

22

525

22

526

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

22

527

});

22

529

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

22

530

{

22

531

b.Property<Guid>("ItemId")

22

532

.HasColumnType("TEXT");

22

533

22

534

b.Property<int>("ChapterIndex")

22

535

.HasColumnType("INTEGER");

22

536

22

537

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

22

538

.HasColumnType("TEXT");

22

539

22

540

b.Property<string>("ImagePath")

22

541

.HasColumnType("TEXT");

22

542

22

543

b.Property<string>("Name")

22

544

.HasColumnType("TEXT");

22

545

22

546

b.Property<long>("StartPositionTicks")

22

547

.HasColumnType("INTEGER");

22

548

22

549

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

22

550

22

551

b.ToTable("Chapters");

22

552

22

553

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

22

554

});

22

556

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

22

557

{

22

558

b.Property<int>("Id")

22

559

.ValueGeneratedOnAdd()

22

560

.HasColumnType("INTEGER");

22

561

22

562

b.Property<string>("Client")

22

563

.IsRequired()

22

564

.HasMaxLength(32)

22

565

.HasColumnType("TEXT");

22

566

22

567

b.Property<Guid>("ItemId")

22

568

.HasColumnType("TEXT");

22

569

22

570

b.Property<string>("Key")

22

571

.IsRequired()

22

572

.HasColumnType("TEXT");

22

573

22

574

b.Property<Guid>("UserId")

22

575

.HasColumnType("TEXT");

22

576

22

577

b.Property<string>("Value")

22

578

.HasColumnType("TEXT");

22

579

22

580

b.HasKey("Id");

22

581

22

582

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

22

583

.IsUnique();

22

584

22

585

b.ToTable("CustomItemDisplayPreferences");

22

586

22

587

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

22

588

});

22

590

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

22

591

{

22

592

b.Property<int>("Id")

22

593

.ValueGeneratedOnAdd()

22

594

.HasColumnType("INTEGER");

22

595

22

596

b.Property<int>("ChromecastVersion")

22

597

.HasColumnType("INTEGER");

22

598

22

599

b.Property<string>("Client")

22

600

.IsRequired()

22

601

.HasMaxLength(32)

22

602

.HasColumnType("TEXT");

22

603

22

604

b.Property<string>("DashboardTheme")

22

605

.HasMaxLength(32)

22

606

.HasColumnType("TEXT");

22

607

22

608

b.Property<bool>("EnableNextVideoInfoOverlay")

22

609

.HasColumnType("INTEGER");

22

610

22

611

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

22

612

.HasColumnType("INTEGER");

22

613

22

614

b.Property<Guid>("ItemId")

22

615

.HasColumnType("TEXT");

22

616

22

617

b.Property<int>("ScrollDirection")

22

618

.HasColumnType("INTEGER");

22

619

22

620

b.Property<bool>("ShowBackdrop")

22

621

.HasColumnType("INTEGER");

22

622

22

623

b.Property<bool>("ShowSidebar")

22

624

.HasColumnType("INTEGER");

22

625

22

626

b.Property<int>("SkipBackwardLength")

22

627

.HasColumnType("INTEGER");

22

628

22

629

b.Property<int>("SkipForwardLength")

22

630

.HasColumnType("INTEGER");

22

631

22

632

b.Property<string>("TvHome")

22

633

.HasMaxLength(32)

22

634

.HasColumnType("TEXT");

22

635

22

636

b.Property<Guid>("UserId")

22

637

.HasColumnType("TEXT");

22

638

22

639

b.HasKey("Id");

22

640

22

641

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

22

642

.IsUnique();

22

643

22

644

b.ToTable("DisplayPreferences");

22

645

22

646

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

22

647

});

22

649

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

22

650

{

22

651

b.Property<int>("Id")

22

652

.ValueGeneratedOnAdd()

22

653

.HasColumnType("INTEGER");

22

654

22

655

b.Property<int>("DisplayPreferencesId")

22

656

.HasColumnType("INTEGER");

22

657

22

658

b.Property<int>("Order")

22

659

.HasColumnType("INTEGER");

22

660

22

661

b.Property<int>("Type")

22

662

.HasColumnType("INTEGER");

22

663

22

664

b.HasKey("Id");

22

665

22

666

b.HasIndex("DisplayPreferencesId");

22

667

22

668

b.ToTable("HomeSection");

22

669

22

670

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

22

671

});

22

673

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

22

674

{

22

675

b.Property<int>("Id")

22

676

.ValueGeneratedOnAdd()

22

677

.HasColumnType("INTEGER");

22

678

22

679

b.Property<DateTime>("LastModified")

22

680

.HasColumnType("TEXT");

22

681

22

682

b.Property<string>("Path")

22

683

.IsRequired()

22

684

.HasMaxLength(512)

22

685

.HasColumnType("TEXT");

22

686

22

687

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

22

688

.HasColumnType("TEXT");

22

689

22

690

b.HasKey("Id");

22

691

22

692

b.HasIndex("UserId")

22

693

.IsUnique();

22

694

22

695

b.ToTable("ImageInfos");

22

696

22

697

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

22

698

});

22

700

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

22

701

{

22

702

b.Property<int>("Id")

22

703

.ValueGeneratedOnAdd()

22

704

.HasColumnType("INTEGER");

22

705

22

706

b.Property<string>("Client")

22

707

.IsRequired()

22

708

.HasMaxLength(32)

22

709

.HasColumnType("TEXT");

22

710

22

711

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

22

712

.HasColumnType("INTEGER");

22

713

22

714

b.Property<Guid>("ItemId")

22

715

.HasColumnType("TEXT");

22

716

22

717

b.Property<bool>("RememberIndexing")

22

718

.HasColumnType("INTEGER");

22

719

22

720

b.Property<bool>("RememberSorting")

22

721

.HasColumnType("INTEGER");

22

722

22

723

b.Property<string>("SortBy")

22

724

.IsRequired()

22

725

.HasMaxLength(64)

22

726

.HasColumnType("TEXT");

22

727

22

728

b.Property<int>("SortOrder")

22

729

.HasColumnType("INTEGER");

22

730

22

731

b.Property<Guid>("UserId")

22

732

.HasColumnType("TEXT");

22

733

22

734

b.Property<int>("ViewType")

22

735

.HasColumnType("INTEGER");

22

736

22

737

b.HasKey("Id");

22

738

22

739

b.HasIndex("UserId");

22

740

22

741

b.ToTable("ItemDisplayPreferences");

22

742

22

743

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

22

744

});

22

746

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

22

747

{

22

748

b.Property<Guid>("ItemValueId")

22

749

.ValueGeneratedOnAdd()

22

750

.HasColumnType("TEXT");

22

751

22

752

b.Property<string>("CleanValue")

22

753

.IsRequired()

22

754

.HasColumnType("TEXT");

22

755

22

756

b.Property<int>("Type")

22

757

.HasColumnType("INTEGER");

22

758

22

759

b.Property<string>("Value")

22

760

.IsRequired()

22

761

.HasColumnType("TEXT");

22

762

22

763

b.HasKey("ItemValueId");

22

764

22

765

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

22

766

22

767

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

22

768

.IsUnique();

22

769

22

770

b.ToTable("ItemValues");

22

771

22

772

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

22

773

});

22

775

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

22

776

{

22

777

b.Property<Guid>("ItemValueId")

22

778

.HasColumnType("TEXT");

22

779

22

780

b.Property<Guid>("ItemId")

22

781

.HasColumnType("TEXT");

22

782

22

783

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

22

784

22

785

b.HasIndex("ItemId");

22

786

22

787

b.ToTable("ItemValuesMap");

22

788

22

789

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

22

790

});

22

792

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

22

793

{

22

794

b.Property<Guid>("ItemId")

22

795

.HasColumnType("TEXT");

22

796

22

797

b.PrimitiveCollection<string>("KeyframeTicks")

22

798

.HasColumnType("TEXT");

22

799

22

800

b.Property<long>("TotalDuration")

22

801

.HasColumnType("INTEGER");

22

802

22

803

b.HasKey("ItemId");

22

804

22

805

b.ToTable("KeyframeData");

22

806

22

807

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

22

808

});

22

810

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

22

811

{

22

812

b.Property<Guid>("ParentId")

22

813

.HasColumnType("TEXT");

22

814

22

815

b.Property<Guid>("ChildId")

22

816

.HasColumnType("TEXT");

22

817

22

818

b.Property<int>("ChildType")

22

819

.HasColumnType("INTEGER");

22

820

22

821

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

22

822

.HasColumnType("INTEGER");

22

823

22

824

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

22

825

22

826

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

22

827

22

828

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

22

829

22

830

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

22

831

22

832

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

22

833

22

834

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

22

835

});

22

837

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

22

838

{

22

839

b.Property<Guid>("Id")

22

840

.ValueGeneratedOnAdd()

22

841

.HasColumnType("TEXT");

22

842

22

843

b.Property<long>("EndTicks")

22

844

.HasColumnType("INTEGER");

22

845

22

846

b.Property<Guid>("ItemId")

22

847

.HasColumnType("TEXT");

22

848

22

849

b.Property<string>("SegmentProviderId")

22

850

.IsRequired()

22

851

.HasColumnType("TEXT");

22

852

22

853

b.Property<long>("StartTicks")

22

854

.HasColumnType("INTEGER");

22

855

22

856

b.Property<int>("Type")

22

857

.HasColumnType("INTEGER");

22

858

22

859

b.HasKey("Id");

22

860

22

861

b.ToTable("MediaSegments");

22

862

22

863

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

22

864

});

22

866

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

22

867

{

22

868

b.Property<Guid>("ItemId")

22

869

.HasColumnType("TEXT");

22

870

22

871

b.Property<int>("StreamIndex")

22

872

.HasColumnType("INTEGER");

22

873

22

874

b.Property<string>("AspectRatio")

22

875

.HasColumnType("TEXT");

22

876

22

877

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

22

878

.HasColumnType("REAL");

22

879

22

880

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

22

881

.HasColumnType("INTEGER");

22

882

22

883

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

22

884

.HasColumnType("INTEGER");

22

885

22

886

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

22

887

.HasColumnType("INTEGER");

22

888

22

889

b.Property<string>("ChannelLayout")

22

890

.HasColumnType("TEXT");

22

891

22

892

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

22

893

.HasColumnType("INTEGER");

22

894

22

895

b.Property<string>("Codec")

22

896

.HasColumnType("TEXT");

22

897

22

898

b.Property<string>("CodecTag")

22

899

.HasColumnType("TEXT");

22

900

22

901

b.Property<string>("CodecTimeBase")

22

902

.HasColumnType("TEXT");

22

903

22

904

b.Property<string>("ColorPrimaries")

22

905

.HasColumnType("TEXT");

22

906

22

907

b.Property<string>("ColorSpace")

22

908

.HasColumnType("TEXT");

22

909

22

910

b.Property<string>("ColorTransfer")

22

911

.HasColumnType("TEXT");

22

912

22

913

b.Property<string>("Comment")

22

914

.HasColumnType("TEXT");

22

915

22

916

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

22

917

.HasColumnType("INTEGER");

22

918

22

919

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

22

920

.HasColumnType("INTEGER");

22

921

22

922

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

22

923

.HasColumnType("INTEGER");

22

924

22

925

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

22

926

.HasColumnType("INTEGER");

22

927

22

928

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

22

929

.HasColumnType("INTEGER");

22

930

22

931

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

22

932

.HasColumnType("INTEGER");

22

933

22

934

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

22

935

.HasColumnType("INTEGER");

22

936

22

937

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

22

938

.HasColumnType("INTEGER");

22

939

22

940

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

22

941

.HasColumnType("INTEGER");

22

942

22

943

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

22

944

.HasColumnType("INTEGER");

22

945

22

946

b.Property<bool>("IsDefault")

22

947

.HasColumnType("INTEGER");

22

948

22

949

b.Property<bool>("IsExternal")

22

950

.HasColumnType("INTEGER");

22

951

22

952

b.Property<bool>("IsForced")

22

953

.HasColumnType("INTEGER");

22

954

22

955

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

22

956

.HasColumnType("INTEGER");

22

957

22

958

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

22

959

.HasColumnType("INTEGER");

22

960

22

961

b.Property<string>("KeyFrames")

22

962

.HasColumnType("TEXT");

22

963

22

964

b.Property<string>("Language")

22

965

.HasColumnType("TEXT");

22

966

22

967

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

22

968

.HasColumnType("REAL");

22

969

22

970

b.Property<string>("NalLengthSize")

22

971

.HasColumnType("TEXT");

22

972

22

973

b.Property<string>("Path")

22

974

.HasColumnType("TEXT");

22

975

22

976

b.Property<string>("PixelFormat")

22

977

.HasColumnType("TEXT");

22

978

22

979

b.Property<string>("Profile")

22

980

.HasColumnType("TEXT");

22

981

22

982

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

22

983

.HasColumnType("REAL");

22

984

22

985

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

22

986

.HasColumnType("INTEGER");

22

987

22

988

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

22

989

.HasColumnType("INTEGER");

22

990

22

991

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

22

992

.HasColumnType("INTEGER");

22

993

22

994

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

22

995

.HasColumnType("INTEGER");

22

996

22

997

b.Property<int>("StreamType")

22

998

.HasColumnType("INTEGER");

22

999

22

1000

b.Property<string>("TimeBase")

22

1001

.HasColumnType("TEXT");

22

1002

22

1003

b.Property<string>("Title")

22

1004

.HasColumnType("TEXT");

22

1005

22

1006

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

22

1007

.HasColumnType("INTEGER");

22

1008

22

1009

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

22

1010

22

1011

b.ToTable("MediaStreamInfos");

22

1012

22

1013

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

22

1014

});

22

1016

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

22

1017

{

22

1018

b.Property<Guid>("Id")

22

1019

.ValueGeneratedOnAdd()

22

1020

.HasColumnType("TEXT");

22

1021

22

1022

b.Property<string>("Name")

22

1023

.IsRequired()

22

1024

.HasColumnType("TEXT");

22

1025

22

1026

b.Property<string>("PersonType")

22

1027

.HasColumnType("TEXT");

22

1028

22

1029

b.HasKey("Id");

22

1030

22

1031

b.HasIndex("Name");

22

1032

22

1033

b.ToTable("Peoples");

22

1034

22

1035

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

22

1036

});

22

1038

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

22

1039

{

22

1040

b.Property<Guid>("ItemId")

22

1041

.HasColumnType("TEXT");

22

1042

22

1043

b.Property<Guid>("PeopleId")

22

1044

.HasColumnType("TEXT");

22

1045

22

1046

b.Property<string>("Role")

22

1047

.HasColumnType("TEXT");

22

1048

22

1049

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

22

1050

.HasColumnType("INTEGER");

22

1051

22

1052

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

22

1053

.HasColumnType("INTEGER");

22

1054

22

1055

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

22

1056

22

1057

b.HasIndex("PeopleId");

22

1058

22

1059

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

22

1060

22

1061

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

22

1062

22

1063

b.ToTable("PeopleBaseItemMap");

22

1064

22

1065

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

22

1066

});

22

1068

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

22

1069

{

22

1070

b.Property<int>("Id")

22

1071

.ValueGeneratedOnAdd()

22

1072

.HasColumnType("INTEGER");

22

1073

22

1074

b.Property<int>("Kind")

22

1075

.HasColumnType("INTEGER");

22

1076

22

1077

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

22

1078

.HasColumnType("TEXT");

22

1079

22

1080

b.Property<uint>("RowVersion")

22

1081

.IsConcurrencyToken()

22

1082

.HasColumnType("INTEGER");

22

1083

22

1084

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

22

1085

.HasColumnType("TEXT");

22

1086

22

1087

b.Property<bool>("Value")

22

1088

.HasColumnType("INTEGER");

22

1089

22

1090

b.HasKey("Id");

22

1091

22

1092

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

22

1093

.IsUnique()

22

1094

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

22

1095

22

1096

b.ToTable("Permissions");

22

1097

22

1098

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

22

1099

});

22

1101

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

22

1102

{

22

1103

b.Property<int>("Id")

22

1104

.ValueGeneratedOnAdd()

22

1105

.HasColumnType("INTEGER");

22

1106

22

1107

b.Property<int>("Kind")

22

1108

.HasColumnType("INTEGER");

22

1109

22

1110

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

22

1111

.HasColumnType("TEXT");

22

1112

22

1113

b.Property<uint>("RowVersion")

22

1114

.IsConcurrencyToken()

22

1115

.HasColumnType("INTEGER");

22

1116

22

1117

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

22

1118

.HasColumnType("TEXT");

22

1119

22

1120

b.Property<string>("Value")

22

1121

.IsRequired()

22

1122

.HasMaxLength(65535)

22

1123

.HasColumnType("TEXT");

22

1124

22

1125

b.HasKey("Id");

22

1126

22

1127

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

22

1128

.IsUnique()

22

1129

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

22

1130

22

1131

b.ToTable("Preferences");

22

1132

22

1133

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

22

1134

});

22

1136

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

22

1137

{

22

1138

b.Property<int>("Id")

22

1139

.ValueGeneratedOnAdd()

22

1140

.HasColumnType("INTEGER");

22

1141

22

1142

b.Property<string>("AccessToken")

22

1143

.IsRequired()

22

1144

.HasColumnType("TEXT");

22

1145

22

1146

b.Property<DateTime>("DateCreated")

22

1147

.HasColumnType("TEXT");

22

1148

22

1149

b.Property<DateTime>("DateLastActivity")

22

1150

.HasColumnType("TEXT");

22

1151

22

1152

b.Property<string>("Name")

22

1153

.IsRequired()

22

1154

.HasMaxLength(64)

22

1155

.HasColumnType("TEXT");

22

1156

22

1157

b.HasKey("Id");

22

1158

22

1159

b.HasIndex("AccessToken")

22

1160

.IsUnique();

22

1161

22

1162

b.ToTable("ApiKeys");

22

1163

22

1164

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

22

1165

});

22

1167

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

22

1168

{

22

1169

b.Property<int>("Id")

22

1170

.ValueGeneratedOnAdd()

22

1171

.HasColumnType("INTEGER");

22

1172

22

1173

b.Property<string>("AccessToken")

22

1174

.IsRequired()

22

1175

.HasColumnType("TEXT");

22

1176

22

1177

b.Property<string>("AppName")

22

1178

.IsRequired()

22

1179

.HasMaxLength(64)

22

1180

.HasColumnType("TEXT");

22

1181

22

1182

b.Property<string>("AppVersion")

22

1183

.IsRequired()

22

1184

.HasMaxLength(32)

22

1185

.HasColumnType("TEXT");

22

1186

22

1187

b.Property<DateTime>("DateCreated")

22

1188

.HasColumnType("TEXT");

22

1189

22

1190

b.Property<DateTime>("DateLastActivity")

22

1191

.HasColumnType("TEXT");

22

1192

22

1193

b.Property<DateTime>("DateModified")

22

1194

.HasColumnType("TEXT");

22

1195

22

1196

b.Property<string>("DeviceId")

22

1197

.IsRequired()

22

1198

.HasMaxLength(256)

22

1199

.HasColumnType("TEXT");

22

1200

22

1201

b.Property<string>("DeviceName")

22

1202

.IsRequired()

22

1203

.HasMaxLength(64)

22

1204

.HasColumnType("TEXT");

22

1205

22

1206

b.Property<bool>("IsActive")

22

1207

.HasColumnType("INTEGER");

22

1208

22

1209

b.Property<Guid>("UserId")

22

1210

.HasColumnType("TEXT");

22

1211

22

1212

b.HasKey("Id");

22

1213

22

1214

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

22

1215

22

1216

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

22

1217

22

1218

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

22

1219

22

1220

b.ToTable("Devices");

22

1221

22

1222

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

22

1223

});

22

1225

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

22

1226

{

22

1227

b.Property<int>("Id")

22

1228

.ValueGeneratedOnAdd()

22

1229

.HasColumnType("INTEGER");

22

1230

22

1231

b.Property<string>("CustomName")

22

1232

.HasColumnType("TEXT");

22

1233

22

1234

b.Property<string>("DeviceId")

22

1235

.IsRequired()

22

1236

.HasColumnType("TEXT");

22

1237

22

1238

b.HasKey("Id");

22

1239

22

1240

b.HasIndex("DeviceId")

22

1241

.IsUnique();

22

1242

22

1243

b.ToTable("DeviceOptions");

22

1244

22

1245

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

22

1246

});

22

1248

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

22

1249

{

22

1250

b.Property<Guid>("ItemId")

22

1251

.HasColumnType("TEXT");

22

1252

22

1253

b.Property<int>("Width")

22

1254

.HasColumnType("INTEGER");

22

1255

22

1256

b.Property<int>("Bandwidth")

22

1257

.HasColumnType("INTEGER");

22

1258

22

1259

b.Property<int>("Height")

22

1260

.HasColumnType("INTEGER");

22

1261

22

1262

b.Property<int>("Interval")

22

1263

.HasColumnType("INTEGER");

22

1264

22

1265

b.Property<int>("ThumbnailCount")

22

1266

.HasColumnType("INTEGER");

22

1267

22

1268

b.Property<int>("TileHeight")

22

1269

.HasColumnType("INTEGER");

22

1270

22

1271

b.Property<int>("TileWidth")

22

1272

.HasColumnType("INTEGER");

22

1273

22

1274

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

22

1275

22

1276

b.ToTable("TrickplayInfos");

22

1277

22

1278

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

22

1279

});

22

1281

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

22

1282

{

22

1283

b.Property<Guid>("Id")

22

1284

.ValueGeneratedOnAdd()

22

1285

.HasColumnType("TEXT");

22

1286

22

1287

b.Property<string>("AudioLanguagePreference")

22

1288

.HasMaxLength(255)

22

1289

.HasColumnType("TEXT");

22

1290

22

1291

b.Property<string>("AuthenticationProviderId")

22

1292

.IsRequired()

22

1293

.HasMaxLength(255)

22

1294

.HasColumnType("TEXT");

22

1295

22

1296

b.Property<string>("CastReceiverId")

22

1297

.HasMaxLength(32)

22

1298

.HasColumnType("TEXT");

22

1299

22

1300

b.Property<bool>("DisplayCollectionsView")

22

1301

.HasColumnType("INTEGER");

22

1302

22

1303

b.Property<bool>("DisplayMissingEpisodes")

22

1304

.HasColumnType("INTEGER");

22

1305

22

1306

b.Property<bool>("EnableAutoLogin")

22

1307

.HasColumnType("INTEGER");

22

1308

22

1309

b.Property<bool>("EnableLocalPassword")

22

1310

.HasColumnType("INTEGER");

22

1311

22

1312

b.Property<bool>("EnableNextEpisodeAutoPlay")

22

1313

.HasColumnType("INTEGER");

22

1314

22

1315

b.Property<bool>("EnableUserPreferenceAccess")

22

1316

.HasColumnType("INTEGER");

22

1317

22

1318

b.Property<bool>("HidePlayedInLatest")

22

1319

.HasColumnType("INTEGER");

22

1320

22

1321

b.Property<long>("InternalId")

22

1322

.HasColumnType("INTEGER");

22

1323

22

1324

b.Property<int>("InvalidLoginAttemptCount")

22

1325

.HasColumnType("INTEGER");

22

1326

22

1327

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

22

1328

.HasColumnType("TEXT");

22

1329

22

1330

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

22

1331

.HasColumnType("TEXT");

22

1332

22

1333

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

22

1334

.HasColumnType("INTEGER");

22

1335

22

1336

b.Property<int>("MaxActiveSessions")

22

1337

.HasColumnType("INTEGER");

22

1338

22

1339

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

22

1340

.HasColumnType("INTEGER");

22

1341

22

1342

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

22

1343

.HasColumnType("INTEGER");

22

1344

22

1345

b.Property<bool>("MustUpdatePassword")

22

1346

.HasColumnType("INTEGER");

22

1347

22

1348

b.Property<string>("Password")

22

1349

.HasMaxLength(65535)

22

1350

.HasColumnType("TEXT");

22

1351

22

1352

b.Property<string>("PasswordResetProviderId")

22

1353

.IsRequired()

22

1354

.HasMaxLength(255)

22

1355

.HasColumnType("TEXT");

22

1356

22

1357

b.Property<bool>("PlayDefaultAudioTrack")

22

1358

.HasColumnType("INTEGER");

22

1359

22

1360

b.Property<bool>("RememberAudioSelections")

22

1361

.HasColumnType("INTEGER");

22

1362

22

1363

b.Property<bool>("RememberSubtitleSelections")

22

1364

.HasColumnType("INTEGER");

22

1365

22

1366

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

22

1367

.HasColumnType("INTEGER");

22

1368

22

1369

b.Property<uint>("RowVersion")

22

1370

.IsConcurrencyToken()

22

1371

.HasColumnType("INTEGER");

22

1372

22

1373

b.Property<string>("SubtitleLanguagePreference")

22

1374

.HasMaxLength(255)

22

1375

.HasColumnType("TEXT");

22

1376

22

1377

b.Property<int>("SubtitleMode")

22

1378

.HasColumnType("INTEGER");

22

1379

22

1380

b.Property<int>("SyncPlayAccess")

22

1381

.HasColumnType("INTEGER");

22

1382

22

1383

b.Property<string>("Username")

22

1384

.IsRequired()

22

1385

.HasMaxLength(255)

22

1386

.HasColumnType("TEXT");

22

1387

22

1388

b.HasKey("Id");

22

1389

22

1390

b.HasIndex("Username")

22

1391

.IsUnique();

22

1392

22

1393

b.ToTable("Users");

22

1394

22

1395

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

22

1396

});

22

1398

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

22

1399

{

22

1400

b.Property<Guid>("ItemId")

22

1401

.HasColumnType("TEXT");

22

1402

22

1403

b.Property<Guid>("UserId")

22

1404

.HasColumnType("TEXT");

22

1405

22

1406

b.Property<string>("CustomDataKey")

22

1407

.HasColumnType("TEXT");

22

1408

22

1409

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

22

1410

.HasColumnType("INTEGER");

22

1411

22

1412

b.Property<bool>("IsFavorite")

22

1413

.HasColumnType("INTEGER");

22

1414

22

1415

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

22

1416

.HasColumnType("TEXT");

22

1417

22

1418

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

22

1419

.HasColumnType("INTEGER");

22

1420

22

1421

b.Property<int>("PlayCount")

22

1422

.HasColumnType("INTEGER");

22

1423

22

1424

b.Property<long>("PlaybackPositionTicks")

22

1425

.HasColumnType("INTEGER");

22

1426

22

1427

b.Property<bool>("Played")

22

1428

.HasColumnType("INTEGER");

22

1429

22

1430

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

22

1431

.HasColumnType("REAL");

22

1432

22

1433

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

22

1434

.HasColumnType("TEXT");

22

1435

22

1436

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

22

1437

.HasColumnType("INTEGER");

22

1438

22

1439

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

22

1440

22

1441

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

22

1442

22

1443

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

22

1444

22

1445

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

22

1446

22

1447

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

22

1448

22

1449

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

22

1450

22

1451

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

22

1452

22

1453

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

22

1454

22

1455

b.ToTable("UserData");

22

1456

22

1457

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

22

1458

});

22

1460

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

22

1461

{

22

1462

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

22

1463

.WithMany("AccessSchedules")

22

1464

.HasForeignKey("UserId")

22

1465

.OnDelete(DeleteBehavior.Cascade)

22

1466

.IsRequired();

22

1467

});

22

1469

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

22

1470

{

22

1471

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

22

1472

.WithMany("Parents")

22

1473

.HasForeignKey("ItemId")

22

1474

.OnDelete(DeleteBehavior.Cascade)

22

1475

.IsRequired();

22

1476

22

1477

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

22

1478

.WithMany("Children")

22

1479

.HasForeignKey("ParentItemId")

22

1480

.OnDelete(DeleteBehavior.Cascade)

22

1481

.IsRequired();

22

1482

22

1483

b.Navigation("Item");

22

1484

22

1485

b.Navigation("ParentItem");

22

1486

});

22

1488

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

22

1489

{

22

1490

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

22

1491

.WithMany()

22

1492

.HasForeignKey("ItemId")

22

1493

.OnDelete(DeleteBehavior.Cascade)

22

1494

.IsRequired();

22

1495

22

1496

b.Navigation("Item");

22

1497

});

22

1499

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

22

1500

{

22

1501

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

22

1502

.WithMany("Extras")

22

1503

.HasForeignKey("OwnerId")

22

1504

.OnDelete(DeleteBehavior.NoAction);

22

1505

22

1506

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

22

1507

.WithMany("DirectChildren")

22

1508

.HasForeignKey("ParentId")

22

1509

.OnDelete(DeleteBehavior.Cascade);

22

1510

22

1511

b.Navigation("DirectParent");

22

1512

22

1513

b.Navigation("Owner");

22

1514

});

22

1516

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

22

1517

{

22

1518

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

22

1519

.WithMany("Images")

22

1520

.HasForeignKey("ItemId")

22

1521

.OnDelete(DeleteBehavior.Cascade)

22

1522

.IsRequired();

22

1523

22

1524

b.Navigation("Item");

22

1525

});

22

1527

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

22

1528

{

22

1529

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

22

1530

.WithMany("LockedFields")

22

1531

.HasForeignKey("ItemId")

22

1532

.OnDelete(DeleteBehavior.Cascade)

22

1533

.IsRequired();

22

1534

22

1535

b.Navigation("Item");

22

1536

});

22

1538

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

22

1539

{

22

1540

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

22

1541

.WithMany("Provider")

22

1542

.HasForeignKey("ItemId")

22

1543

.OnDelete(DeleteBehavior.Cascade)

22

1544

.IsRequired();

22

1545

22

1546

b.Navigation("Item");

22

1547

});

22

1549

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

22

1550

{

22

1551

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

22

1552

.WithMany("TrailerTypes")

22

1553

.HasForeignKey("ItemId")

22

1554

.OnDelete(DeleteBehavior.Cascade)

22

1555

.IsRequired();

22

1556

22

1557

b.Navigation("Item");

22

1558

});

22

1560

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

22

1561

{

22

1562

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

22

1563

.WithMany("Chapters")

22

1564

.HasForeignKey("ItemId")

22

1565

.OnDelete(DeleteBehavior.Cascade)

22

1566

.IsRequired();

22

1567

22

1568

b.Navigation("Item");

22

1569

});

22

1571

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

22

1572

{

22

1573

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

22

1574

.WithMany("DisplayPreferences")

22

1575

.HasForeignKey("UserId")

22

1576

.OnDelete(DeleteBehavior.Cascade)

22

1577

.IsRequired();

22

1578

});

22

1580

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

22

1581

{

22

1582

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

22

1583

.WithMany("HomeSections")

22

1584

.HasForeignKey("DisplayPreferencesId")

22

1585

.OnDelete(DeleteBehavior.Cascade)

22

1586

.IsRequired();

22

1587

});

22

1589

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

22

1590

{

22

1591

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

22

1592

.WithOne("ProfileImage")

22

1593

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

22

1594

.OnDelete(DeleteBehavior.Cascade);

22

1595

});

22

1597

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

22

1598

{

22

1599

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

22

1600

.WithMany("ItemDisplayPreferences")

22

1601

.HasForeignKey("UserId")

22

1602

.OnDelete(DeleteBehavior.Cascade)

22

1603

.IsRequired();

22

1604

});

22

1606

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

22

1607

{

22

1608

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

22

1609

.WithMany("ItemValues")

22

1610

.HasForeignKey("ItemId")

22

1611

.OnDelete(DeleteBehavior.Cascade)

22

1612

.IsRequired();

22

1613

22

1614

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

22

1615

.WithMany("BaseItemsMap")

22

1616

.HasForeignKey("ItemValueId")

22

1617

.OnDelete(DeleteBehavior.Cascade)

22

1618

.IsRequired();

22

1619

22

1620

b.Navigation("Item");

22

1621

22

1622

b.Navigation("ItemValue");

22

1623

});

22

1625

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

22

1626

{

22

1627

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

22

1628

.WithMany()

22

1629

.HasForeignKey("ItemId")

22

1630

.OnDelete(DeleteBehavior.Cascade)

22

1631

.IsRequired();

22

1632

22

1633

b.Navigation("Item");

22

1634

});

22

1636

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

22

1637

{

22

1638

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

22

1639

.WithMany("LinkedChildOfEntities")

22

1640

.HasForeignKey("ChildId")

22

1641

.OnDelete(DeleteBehavior.NoAction)

22

1642

.IsRequired();

22

1643

22

1644

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

22

1645

.WithMany("LinkedChildEntities")

22

1646

.HasForeignKey("ParentId")

22

1647

.OnDelete(DeleteBehavior.NoAction)

22

1648

.IsRequired();

22

1649

22

1650

b.Navigation("Child");

22

1651

22

1652

b.Navigation("Parent");

22

1653

});

22

1655

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

22

1656

{

22

1657

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

22

1658

.WithMany("MediaStreams")

22

1659

.HasForeignKey("ItemId")

22

1660

.OnDelete(DeleteBehavior.Cascade)

22

1661

.IsRequired();

22

1662

22

1663

b.Navigation("Item");

22

1664

});

22

1666

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

22

1667

{

22

1668

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

22

1669

.WithMany("Peoples")

22

1670

.HasForeignKey("ItemId")

22

1671

.OnDelete(DeleteBehavior.Cascade)

22

1672

.IsRequired();

22

1673

22

1674

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

22

1675

.WithMany("BaseItems")

22

1676

.HasForeignKey("PeopleId")

22

1677

.OnDelete(DeleteBehavior.Cascade)

22

1678

.IsRequired();

22

1679

22

1680

b.Navigation("Item");

22

1681

22

1682

b.Navigation("People");

22

1683

});

22

1685

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

22

1686

{

22

1687

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

22

1688

.WithMany("Permissions")

22

1689

.HasForeignKey("UserId")

22

1690

.OnDelete(DeleteBehavior.Cascade);

22

1691

});

22

1693

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

22

1694

{

22

1695

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

22

1696

.WithMany("Preferences")

22

1697

.HasForeignKey("UserId")

22

1698

.OnDelete(DeleteBehavior.Cascade);

22

1699

});

22

1701

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

22

1702

{

22

1703

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

22

1704

.WithMany()

22

1705

.HasForeignKey("UserId")

22

1706

.OnDelete(DeleteBehavior.Cascade)

22

1707

.IsRequired();

22

1708

22

1709

b.Navigation("User");

22

1710

});

22

1712

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

22

1713

{

22

1714

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

22

1715

.WithMany("UserData")

22

1716

.HasForeignKey("ItemId")

22

1717

.OnDelete(DeleteBehavior.Cascade)

22

1718

.IsRequired();

22

1719

22

1720

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

22

1721

.WithMany()

22

1722

.HasForeignKey("UserId")

22

1723

.OnDelete(DeleteBehavior.Cascade)

22

1724

.IsRequired();

22

1725

22

1726

b.Navigation("Item");

22

1727

22

1728

b.Navigation("User");

22

1729

});

22

1731

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

22

1732

{

22

1733

b.Navigation("Chapters");

22

1734

22

1735

b.Navigation("Children");

22

1736

22

1737

b.Navigation("DirectChildren");

22

1738

22

1739

b.Navigation("Extras");

22

1740

22

1741

b.Navigation("Images");

22

1742

22

1743

b.Navigation("ItemValues");

22

1744

22

1745

b.Navigation("LinkedChildEntities");

22

1746

22

1747

b.Navigation("LinkedChildOfEntities");

22

1748

22

1749

b.Navigation("LockedFields");

22

1750

22

1751

b.Navigation("MediaStreams");

22

1752

22

1753

b.Navigation("Parents");

22

1754

22

1755

b.Navigation("Peoples");

22

1756

22

1757

b.Navigation("Provider");

22

1758

22

1759

b.Navigation("TrailerTypes");

22

1760

22

1761

b.Navigation("UserData");

22

1762

});

22

1764

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

22

1765

{

22

1766

b.Navigation("HomeSections");

22

1767

});

22

1769

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

22

1770

{

22

1771

b.Navigation("BaseItemsMap");

22

1772

});

22

1774

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

22

1775

{

22

1776

b.Navigation("BaseItems");

22

1777

});

22

1779

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

22

1780

{

22

1781

b.Navigation("AccessSchedules");

22

1782

22

1783

b.Navigation("DisplayPreferences");

22

1784

22

1785

b.Navigation("ItemDisplayPreferences");

22

1786

22

1787

b.Navigation("Permissions");

22

1788

22

1789

b.Navigation("Preferences");

22

1790

22

1791

b.Navigation("ProfileImage");

22

1792

});

22

1794

}

< Summary - Jellyfin

Coverage history

Coverage delta

Metrics

File(s)

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260308123920_AddTypeCleanNameIndex.cs

/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/20260308123920_AddTypeCleanNameIndex.Designer.cs

Methods/Properties