Jellyfin.Server.Implementations.Migrations.JellyfinDbModelSnapshot - Jellyfin

Class:	Jellyfin.Server.Implementations.Migrations.JellyfinDbModelSnapshot
Assembly:	Jellyfin.Database.Providers.Sqlite
File(s):	/srv/git/jellyfin/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/JellyfinDbModelSnapshot.cs

Covered lines:	1730
Uncovered lines:	0
Coverable lines:	1730
Total lines:	1808
Line coverage:	100%

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

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

1

18

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

1

20

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

1

21

{

1

22

b.Property<int>("Id")

1

23

.ValueGeneratedOnAdd()

1

24

.HasColumnType("INTEGER");

1

25

1

26

b.Property<int>("DayOfWeek")

1

27

.HasColumnType("INTEGER");

1

28

1

29

b.Property<double>("EndHour")

1

30

.HasColumnType("REAL");

1

31

1

32

b.Property<double>("StartHour")

1

33

.HasColumnType("REAL");

1

34

1

35

b.Property<Guid>("UserId")

1

36

.HasColumnType("TEXT");

1

37

1

38

b.HasKey("Id");

1

39

1

40

b.HasIndex("UserId");

1

41

1

42

b.ToTable("AccessSchedules");

1

43

1

44

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

1

45

});

1

47

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

1

48

{

1

49

b.Property<int>("Id")

1

50

.ValueGeneratedOnAdd()

1

51

.HasColumnType("INTEGER");

1

52

1

53

b.Property<DateTime>("DateCreated")

1

54

.HasColumnType("TEXT");

1

55

1

56

b.Property<string>("ItemId")

1

57

.HasMaxLength(256)

1

58

.HasColumnType("TEXT");

1

59

1

60

b.Property<int>("LogSeverity")

1

61

.HasColumnType("INTEGER");

1

62

1

63

b.Property<string>("Name")

1

64

.IsRequired()

1

65

.HasMaxLength(512)

1

66

.HasColumnType("TEXT");

1

67

1

68

b.Property<string>("Overview")

1

69

.HasMaxLength(512)

1

70

.HasColumnType("TEXT");

1

71

1

72

b.Property<uint>("RowVersion")

1

73

.IsConcurrencyToken()

1

74

.HasColumnType("INTEGER");

1

75

1

76

b.Property<string>("ShortOverview")

1

77

.HasMaxLength(512)

1

78

.HasColumnType("TEXT");

1

79

1

80

b.Property<string>("Type")

1

81

.IsRequired()

1

82

.HasMaxLength(256)

1

83

.HasColumnType("TEXT");

1

84

1

85

b.Property<Guid>("UserId")

1

86

.HasColumnType("TEXT");

1

87

1

88

b.HasKey("Id");

1

89

1

90

b.HasIndex("DateCreated");

1

91

1

92

b.ToTable("ActivityLogs");

1

93

1

94

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

1

95

});

1

97

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

1

98

{

1

99

b.Property<Guid>("ItemId")

1

100

.HasColumnType("TEXT");

1

101

1

102

b.Property<Guid>("ParentItemId")

1

103

.HasColumnType("TEXT");

1

104

1

105

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

1

106

1

107

b.HasIndex("ParentItemId");

1

108

1

109

b.ToTable("AncestorIds");

1

110

1

111

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

1

112

});

1

114

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

1

115

{

1

116

b.Property<Guid>("ItemId")

1

117

.HasColumnType("TEXT");

1

118

1

119

b.Property<int>("Index")

1

120

.HasColumnType("INTEGER");

1

121

1

122

b.Property<string>("Codec")

1

123

.HasColumnType("TEXT");

1

124

1

125

b.Property<string>("CodecTag")

1

126

.HasColumnType("TEXT");

1

127

1

128

b.Property<string>("Comment")

1

129

.HasColumnType("TEXT");

1

130

1

131

b.Property<string>("Filename")

1

132

.HasColumnType("TEXT");

1

133

1

134

b.Property<string>("MimeType")

1

135

.HasColumnType("TEXT");

1

136

1

137

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

1

138

1

139

b.ToTable("AttachmentStreamInfos");

1

140

1

141

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

1

142

});

1

144

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

1

145

{

1

146

b.Property<Guid>("Id")

1

147

.ValueGeneratedOnAdd()

1

148

.HasColumnType("TEXT");

1

149

1

150

b.Property<string>("Album")

1

151

.HasColumnType("TEXT");

1

152

1

153

b.Property<string>("AlbumArtists")

1

154

.HasColumnType("TEXT");

1

155

1

156

b.Property<string>("Artists")

1

157

.HasColumnType("TEXT");

1

158

1

159

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

1

160

.HasColumnType("INTEGER");

1

161

1

162

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

1

163

.HasColumnType("TEXT");

1

164

1

165

b.Property<string>("CleanName")

1

166

.HasColumnType("TEXT");

1

167

1

168

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

1

169

.HasColumnType("REAL");

1

170

1

171

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

1

172

.HasColumnType("REAL");

1

173

1

174

b.Property<string>("CustomRating")

1

175

.HasColumnType("TEXT");

1

176

1

177

b.Property<string>("Data")

1

178

.HasColumnType("TEXT");

1

179

1

180

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

1

181

.HasColumnType("TEXT");

1

182

1

183

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

1

184

.HasColumnType("TEXT");

1

185

1

186

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

1

187

.HasColumnType("TEXT");

1

188

1

189

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

1

190

.HasColumnType("TEXT");

1

191

1

192

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

1

193

.HasColumnType("TEXT");

1

194

1

195

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

1

196

.HasColumnType("TEXT");

1

197

1

198

b.Property<string>("EpisodeTitle")

1

199

.HasColumnType("TEXT");

1

200

1

201

b.Property<string>("ExternalId")

1

202

.HasColumnType("TEXT");

1

203

1

204

b.Property<string>("ExternalSeriesId")

1

205

.HasColumnType("TEXT");

1

206

1

207

b.Property<string>("ExternalServiceId")

1

208

.HasColumnType("TEXT");

1

209

1

210

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

1

211

.HasColumnType("INTEGER");

1

212

1

213

b.Property<string>("ForcedSortName")

1

214

.HasColumnType("TEXT");

1

215

1

216

b.Property<string>("Genres")

1

217

.HasColumnType("TEXT");

1

218

1

219

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

1

220

.HasColumnType("INTEGER");

1

221

1

222

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

1

223

.HasColumnType("INTEGER");

1

224

1

225

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

1

226

.HasColumnType("INTEGER");

1

227

1

228

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

1

229

.HasColumnType("INTEGER");

1

230

1

231

b.Property<bool>("IsFolder")

1

232

.HasColumnType("INTEGER");

1

233

1

234

b.Property<bool>("IsInMixedFolder")

1

235

.HasColumnType("INTEGER");

1

236

1

237

b.Property<bool>("IsLocked")

1

238

.HasColumnType("INTEGER");

1

239

1

240

b.Property<bool>("IsMovie")

1

241

.HasColumnType("INTEGER");

1

242

1

243

b.Property<bool>("IsRepeat")

1

244

.HasColumnType("INTEGER");

1

245

1

246

b.Property<bool>("IsSeries")

1

247

.HasColumnType("INTEGER");

1

248

1

249

b.Property<bool>("IsVirtualItem")

1

250

.HasColumnType("INTEGER");

1

251

1

252

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

1

253

.HasColumnType("REAL");

1

254

1

255

b.Property<string>("MediaType")

1

256

.HasColumnType("TEXT");

1

257

1

258

b.Property<string>("Name")

1

259

.HasColumnType("TEXT");

1

260

1

261

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

1

262

.HasColumnType("REAL");

1

263

1

264

b.Property<string>("OfficialRating")

1

265

.HasColumnType("TEXT");

1

266

1

267

b.Property<string>("OriginalLanguage")

1

268

.HasColumnType("TEXT");

1

269

1

270

b.Property<string>("OriginalTitle")

1

271

.HasColumnType("TEXT");

1

272

1

273

b.Property<string>("Overview")

1

274

.HasColumnType("TEXT");

1

275

1

276

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

1

277

.HasColumnType("TEXT");

1

278

1

279

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

1

280

.HasColumnType("TEXT");

1

281

1

282

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

1

283

.HasColumnType("INTEGER");

1

284

1

285

b.Property<string>("Path")

1

286

.HasColumnType("TEXT");

1

287

1

288

b.Property<string>("PreferredMetadataCountryCode")

1

289

.HasColumnType("TEXT");

1

290

1

291

b.Property<string>("PreferredMetadataLanguage")

1

292

.HasColumnType("TEXT");

1

293

1

294

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

1

295

.HasColumnType("TEXT");

1

296

1

297

b.Property<string>("PresentationUniqueKey")

1

298

.HasColumnType("TEXT");

1

299

1

300

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

1

301

.HasColumnType("TEXT");

1

302

1

303

b.Property<string>("ProductionLocations")

1

304

.HasColumnType("TEXT");

1

305

1

306

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

1

307

.HasColumnType("INTEGER");

1

308

1

309

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

1

310

.HasColumnType("INTEGER");

1

311

1

312

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

1

313

.HasColumnType("TEXT");

1

314

1

315

b.Property<string>("SeasonName")

1

316

.HasColumnType("TEXT");

1

317

1

318

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

1

319

.HasColumnType("TEXT");

1

320

1

321

b.Property<string>("SeriesName")

1

322

.HasColumnType("TEXT");

1

323

1

324

b.Property<string>("SeriesPresentationUniqueKey")

1

325

.HasColumnType("TEXT");

1

326

1

327

b.Property<string>("ShowId")

1

328

.HasColumnType("TEXT");

1

329

1

330

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

1

331

.HasColumnType("INTEGER");

1

332

1

333

b.Property<string>("SortName")

1

334

.HasColumnType("TEXT");

1

335

1

336

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

1

337

.HasColumnType("TEXT");

1

338

1

339

b.Property<string>("Studios")

1

340

.HasColumnType("TEXT");

1

341

1

342

b.Property<string>("Tagline")

1

343

.HasColumnType("TEXT");

1

344

1

345

b.Property<string>("Tags")

1

346

.HasColumnType("TEXT");

1

347

1

348

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

1

349

.HasColumnType("TEXT");

1

350

1

351

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

1

352

.HasColumnType("INTEGER");

1

353

1

354

b.Property<string>("Type")

1

355

.IsRequired()

1

356

.HasColumnType("TEXT");

1

357

1

358

b.Property<string>("UnratedType")

1

359

.HasColumnType("TEXT");

1

360

1

361

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

1

362

.HasColumnType("INTEGER");

1

363

1

364

b.HasKey("Id");

1

365

1

366

b.HasIndex("Name");

1

367

1

368

b.HasIndex("OwnerId");

1

369

1

370

b.HasIndex("ParentId");

1

371

1

372

b.HasIndex("Path");

1

373

1

374

b.HasIndex("PresentationUniqueKey");

1

375

1

376

b.HasIndex("PrimaryVersionId")

1

377

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

1

378

1

379

b.HasIndex("SeasonId");

1

380

1

381

b.HasIndex("SeriesId");

1

382

1

383

b.HasIndex("SeriesName");

1

384

1

385

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

1

386

1

387

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

1

388

1

389

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

1

390

1

391

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

1

392

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

1

393

1

394

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

1

395

1

396

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

1

397

1

398

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

1

399

1

400

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

1

401

1

402

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

1

403

1

404

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

1

405

1

406

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

1

407

1

408

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

1

409

1

410

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

1

411

1

412

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

1

413

1

414

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

1

415

1

416

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

1

417

1

418

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

1

419

1

420

b.ToTable("BaseItems");

1

421

1

422

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

1

423

1

424

b.HasData(

1

425

new

1

426

{

1

427

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

1

428

IsFolder = false,

1

429

IsInMixedFolder = false,

1

430

IsLocked = false,

1

431

IsMovie = false,

1

432

IsRepeat = false,

1

433

IsSeries = false,

1

434

IsVirtualItem = false,

1

435

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

1

436

Type = "PLACEHOLDER"

1

437

});

1

438

});

1

440

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

1

441

{

1

442

b.Property<Guid>("Id")

1

443

.ValueGeneratedOnAdd()

1

444

.HasColumnType("TEXT");

1

445

1

446

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

1

447

.HasColumnType("BLOB");

1

448

1

449

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

1

450

.HasColumnType("TEXT");

1

451

1

452

b.Property<int>("Height")

1

453

.HasColumnType("INTEGER");

1

454

1

455

b.Property<int>("ImageType")

1

456

.HasColumnType("INTEGER");

1

457

1

458

b.Property<Guid>("ItemId")

1

459

.HasColumnType("TEXT");

1

460

1

461

b.Property<string>("Path")

1

462

.IsRequired()

1

463

.HasColumnType("TEXT");

1

464

1

465

b.Property<int>("Width")

1

466

.HasColumnType("INTEGER");

1

467

1

468

b.HasKey("Id");

1

469

1

470

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

1

471

1

472

b.ToTable("BaseItemImageInfos");

1

473

1

474

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

1

475

});

1

477

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

1

478

{

1

479

b.Property<int>("Id")

1

480

.HasColumnType("INTEGER");

1

481

1

482

b.Property<Guid>("ItemId")

1

483

.HasColumnType("TEXT");

1

484

1

485

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

1

486

1

487

b.HasIndex("ItemId");

1

488

1

489

b.ToTable("BaseItemMetadataFields");

1

490

1

491

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

1

492

});

1

494

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

1

495

{

1

496

b.Property<Guid>("ItemId")

1

497

.HasColumnType("TEXT");

1

498

1

499

b.Property<string>("ProviderId")

1

500

.HasColumnType("TEXT");

1

501

1

502

b.Property<string>("ProviderValue")

1

503

.IsRequired()

1

504

.HasColumnType("TEXT");

1

505

1

506

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

1

507

1

508

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

1

509

1

510

b.ToTable("BaseItemProviders");

1

511

1

512

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

1

513

});

1

515

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

1

516

{

1

517

b.Property<int>("Id")

1

518

.HasColumnType("INTEGER");

1

519

1

520

b.Property<Guid>("ItemId")

1

521

.HasColumnType("TEXT");

1

522

1

523

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

1

524

1

525

b.HasIndex("ItemId");

1

526

1

527

b.ToTable("BaseItemTrailerTypes");

1

528

1

529

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

1

530

});

1

532

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

1

533

{

1

534

b.Property<Guid>("ItemId")

1

535

.HasColumnType("TEXT");

1

536

1

537

b.Property<int>("ChapterIndex")

1

538

.HasColumnType("INTEGER");

1

539

1

540

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

1

541

.HasColumnType("TEXT");

1

542

1

543

b.Property<string>("ImagePath")

1

544

.HasColumnType("TEXT");

1

545

1

546

b.Property<string>("Name")

1

547

.HasColumnType("TEXT");

1

548

1

549

b.Property<long>("StartPositionTicks")

1

550

.HasColumnType("INTEGER");

1

551

1

552

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

1

553

1

554

b.ToTable("Chapters");

1

555

1

556

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

1

557

});

1

559

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

1

560

{

1

561

b.Property<int>("Id")

1

562

.ValueGeneratedOnAdd()

1

563

.HasColumnType("INTEGER");

1

564

1

565

b.Property<string>("Client")

1

566

.IsRequired()

1

567

.HasMaxLength(32)

1

568

.HasColumnType("TEXT");

1

569

1

570

b.Property<Guid>("ItemId")

1

571

.HasColumnType("TEXT");

1

572

1

573

b.Property<string>("Key")

1

574

.IsRequired()

1

575

.HasColumnType("TEXT");

1

576

1

577

b.Property<Guid>("UserId")

1

578

.HasColumnType("TEXT");

1

579

1

580

b.Property<string>("Value")

1

581

.HasColumnType("TEXT");

1

582

1

583

b.HasKey("Id");

1

584

1

585

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

1

586

.IsUnique();

1

587

1

588

b.ToTable("CustomItemDisplayPreferences");

1

589

1

590

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

1

591

});

1

593

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

1

594

{

1

595

b.Property<int>("Id")

1

596

.ValueGeneratedOnAdd()

1

597

.HasColumnType("INTEGER");

1

598

1

599

b.Property<int>("ChromecastVersion")

1

600

.HasColumnType("INTEGER");

1

601

1

602

b.Property<string>("Client")

1

603

.IsRequired()

1

604

.HasMaxLength(32)

1

605

.HasColumnType("TEXT");

1

606

1

607

b.Property<string>("DashboardTheme")

1

608

.HasMaxLength(32)

1

609

.HasColumnType("TEXT");

1

610

1

611

b.Property<bool>("EnableNextVideoInfoOverlay")

1

612

.HasColumnType("INTEGER");

1

613

1

614

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

1

615

.HasColumnType("INTEGER");

1

616

1

617

b.Property<Guid>("ItemId")

1

618

.HasColumnType("TEXT");

1

619

1

620

b.Property<int>("ScrollDirection")

1

621

.HasColumnType("INTEGER");

1

622

1

623

b.Property<bool>("ShowBackdrop")

1

624

.HasColumnType("INTEGER");

1

625

1

626

b.Property<bool>("ShowSidebar")

1

627

.HasColumnType("INTEGER");

1

628

1

629

b.Property<int>("SkipBackwardLength")

1

630

.HasColumnType("INTEGER");

1

631

1

632

b.Property<int>("SkipForwardLength")

1

633

.HasColumnType("INTEGER");

1

634

1

635

b.Property<string>("TvHome")

1

636

.HasMaxLength(32)

1

637

.HasColumnType("TEXT");

1

638

1

639

b.Property<Guid>("UserId")

1

640

.HasColumnType("TEXT");

1

641

1

642

b.HasKey("Id");

1

643

1

644

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

1

645

.IsUnique();

1

646

1

647

b.ToTable("DisplayPreferences");

1

648

1

649

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

1

650

});

1

652

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

1

653

{

1

654

b.Property<int>("Id")

1

655

.ValueGeneratedOnAdd()

1

656

.HasColumnType("INTEGER");

1

657

1

658

b.Property<int>("DisplayPreferencesId")

1

659

.HasColumnType("INTEGER");

1

660

1

661

b.Property<int>("Order")

1

662

.HasColumnType("INTEGER");

1

663

1

664

b.Property<int>("Type")

1

665

.HasColumnType("INTEGER");

1

666

1

667

b.HasKey("Id");

1

668

1

669

b.HasIndex("DisplayPreferencesId");

1

670

1

671

b.ToTable("HomeSection");

1

672

1

673

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

1

674

});

1

676

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

1

677

{

1

678

b.Property<int>("Id")

1

679

.ValueGeneratedOnAdd()

1

680

.HasColumnType("INTEGER");

1

681

1

682

b.Property<DateTime>("LastModified")

1

683

.HasColumnType("TEXT");

1

684

1

685

b.Property<string>("Path")

1

686

.IsRequired()

1

687

.HasMaxLength(512)

1

688

.HasColumnType("TEXT");

1

689

1

690

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

1

691

.HasColumnType("TEXT");

1

692

1

693

b.HasKey("Id");

1

694

1

695

b.HasIndex("UserId")

1

696

.IsUnique();

1

697

1

698

b.ToTable("ImageInfos");

1

699

1

700

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

1

701

});

1

703

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

1

704

{

1

705

b.Property<int>("Id")

1

706

.ValueGeneratedOnAdd()

1

707

.HasColumnType("INTEGER");

1

708

1

709

b.Property<string>("Client")

1

710

.IsRequired()

1

711

.HasMaxLength(32)

1

712

.HasColumnType("TEXT");

1

713

1

714

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

1

715

.HasColumnType("INTEGER");

1

716

1

717

b.Property<Guid>("ItemId")

1

718

.HasColumnType("TEXT");

1

719

1

720

b.Property<bool>("RememberIndexing")

1

721

.HasColumnType("INTEGER");

1

722

1

723

b.Property<bool>("RememberSorting")

1

724

.HasColumnType("INTEGER");

1

725

1

726

b.Property<string>("SortBy")

1

727

.IsRequired()

1

728

.HasMaxLength(64)

1

729

.HasColumnType("TEXT");

1

730

1

731

b.Property<int>("SortOrder")

1

732

.HasColumnType("INTEGER");

1

733

1

734

b.Property<Guid>("UserId")

1

735

.HasColumnType("TEXT");

1

736

1

737

b.Property<int>("ViewType")

1

738

.HasColumnType("INTEGER");

1

739

1

740

b.HasKey("Id");

1

741

1

742

b.HasIndex("UserId");

1

743

1

744

b.ToTable("ItemDisplayPreferences");

1

745

1

746

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

1

747

});

1

749

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

1

750

{

1

751

b.Property<Guid>("ItemValueId")

1

752

.ValueGeneratedOnAdd()

1

753

.HasColumnType("TEXT");

1

754

1

755

b.Property<string>("CleanValue")

1

756

.IsRequired()

1

757

.HasColumnType("TEXT");

1

758

1

759

b.Property<int>("Type")

1

760

.HasColumnType("INTEGER");

1

761

1

762

b.Property<string>("Value")

1

763

.IsRequired()

1

764

.HasColumnType("TEXT");

1

765

1

766

b.HasKey("ItemValueId");

1

767

1

768

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

1

769

1

770

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

1

771

.IsUnique();

1

772

1

773

b.ToTable("ItemValues");

1

774

1

775

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

1

776

});

1

778

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

1

779

{

1

780

b.Property<Guid>("ItemValueId")

1

781

.HasColumnType("TEXT");

1

782

1

783

b.Property<Guid>("ItemId")

1

784

.HasColumnType("TEXT");

1

785

1

786

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

1

787

1

788

b.HasIndex("ItemId");

1

789

1

790

b.ToTable("ItemValuesMap");

1

791

1

792

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

1

793

});

1

795

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

1

796

{

1

797

b.Property<Guid>("ItemId")

1

798

.HasColumnType("TEXT");

1

799

1

800

b.PrimitiveCollection<string>("KeyframeTicks")

1

801

.HasColumnType("TEXT");

1

802

1

803

b.Property<long>("TotalDuration")

1

804

.HasColumnType("INTEGER");

1

805

1

806

b.HasKey("ItemId");

1

807

1

808

b.ToTable("KeyframeData");

1

809

1

810

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

1

811

});

1

813

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

1

814

{

1

815

b.Property<Guid>("ParentId")

1

816

.HasColumnType("TEXT");

1

817

1

818

b.Property<int>("SortOrder")

1

819

.HasColumnType("INTEGER");

1

820

1

821

b.Property<Guid>("ChildId")

1

822

.HasColumnType("TEXT");

1

823

1

824

b.Property<int>("ChildType")

1

825

.HasColumnType("INTEGER");

1

826

1

827

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

1

828

1

829

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

1

830

1

831

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

1

832

1

833

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

1

834

1

835

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

1

836

});

1

838

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

1

839

{

1

840

b.Property<Guid>("Id")

1

841

.ValueGeneratedOnAdd()

1

842

.HasColumnType("TEXT");

1

843

1

844

b.Property<long>("EndTicks")

1

845

.HasColumnType("INTEGER");

1

846

1

847

b.Property<Guid>("ItemId")

1

848

.HasColumnType("TEXT");

1

849

1

850

b.Property<string>("SegmentProviderId")

1

851

.IsRequired()

1

852

.HasColumnType("TEXT");

1

853

1

854

b.Property<long>("StartTicks")

1

855

.HasColumnType("INTEGER");

1

856

1

857

b.Property<int>("Type")

1

858

.HasColumnType("INTEGER");

1

859

1

860

b.HasKey("Id");

1

861

1

862

b.ToTable("MediaSegments");

1

863

1

864

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

1

865

});

1

867

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

1

868

{

1

869

b.Property<Guid>("ItemId")

1

870

.HasColumnType("TEXT");

1

871

1

872

b.Property<int>("StreamIndex")

1

873

.HasColumnType("INTEGER");

1

874

1

875

b.Property<string>("AspectRatio")

1

876

.HasColumnType("TEXT");

1

877

1

878

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

1

879

.HasColumnType("REAL");

1

880

1

881

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

1

882

.HasColumnType("INTEGER");

1

883

1

884

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

1

885

.HasColumnType("INTEGER");

1

886

1

887

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

1

888

.HasColumnType("INTEGER");

1

889

1

890

b.Property<string>("ChannelLayout")

1

891

.HasColumnType("TEXT");

1

892

1

893

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

1

894

.HasColumnType("INTEGER");

1

895

1

896

b.Property<string>("Codec")

1

897

.HasColumnType("TEXT");

1

898

1

899

b.Property<string>("CodecTag")

1

900

.HasColumnType("TEXT");

1

901

1

902

b.Property<string>("CodecTimeBase")

1

903

.HasColumnType("TEXT");

1

904

1

905

b.Property<string>("ColorPrimaries")

1

906

.HasColumnType("TEXT");

1

907

1

908

b.Property<string>("ColorSpace")

1

909

.HasColumnType("TEXT");

1

910

1

911

b.Property<string>("ColorTransfer")

1

912

.HasColumnType("TEXT");

1

913

1

914

b.Property<string>("Comment")

1

915

.HasColumnType("TEXT");

1

916

1

917

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

1

918

.HasColumnType("INTEGER");

1

919

1

920

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

1

921

.HasColumnType("INTEGER");

1

922

1

923

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

1

924

.HasColumnType("INTEGER");

1

925

1

926

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

1

927

.HasColumnType("INTEGER");

1

928

1

929

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

1

930

.HasColumnType("INTEGER");

1

931

1

932

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

1

933

.HasColumnType("INTEGER");

1

934

1

935

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

1

936

.HasColumnType("INTEGER");

1

937

1

938

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

1

939

.HasColumnType("INTEGER");

1

940

1

941

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

1

942

.HasColumnType("INTEGER");

1

943

1

944

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

1

945

.HasColumnType("INTEGER");

1

946

1

947

b.Property<bool>("IsDefault")

1

948

.HasColumnType("INTEGER");

1

949

1

950

b.Property<bool>("IsExternal")

1

951

.HasColumnType("INTEGER");

1

952

1

953

b.Property<bool>("IsForced")

1

954

.HasColumnType("INTEGER");

1

955

1

956

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

1

957

.HasColumnType("INTEGER");

1

958

1

959

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

1

960

.HasColumnType("INTEGER");

1

961

1

962

b.Property<bool>("IsOriginal")

1

963

.HasColumnType("INTEGER");

1

964

1

965

b.Property<string>("KeyFrames")

1

966

.HasColumnType("TEXT");

1

967

1

968

b.Property<string>("Language")

1

969

.HasColumnType("TEXT");

1

970

1

971

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

1

972

.HasColumnType("REAL");

1

973

1

974

b.Property<string>("NalLengthSize")

1

975

.HasColumnType("TEXT");

1

976

1

977

b.Property<string>("Path")

1

978

.HasColumnType("TEXT");

1

979

1

980

b.Property<string>("PixelFormat")

1

981

.HasColumnType("TEXT");

1

982

1

983

b.Property<string>("Profile")

1

984

.HasColumnType("TEXT");

1

985

1

986

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

1

987

.HasColumnType("REAL");

1

988

1

989

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

1

990

.HasColumnType("INTEGER");

1

991

1

992

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

1

993

.HasColumnType("INTEGER");

1

994

1

995

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

1

996

.HasColumnType("INTEGER");

1

997

1

998

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

1

999

.HasColumnType("INTEGER");

1

1000

1

1001

b.Property<int>("StreamType")

1

1002

.HasColumnType("INTEGER");

1

1003

1

1004

b.Property<string>("TimeBase")

1

1005

.HasColumnType("TEXT");

1

1006

1

1007

b.Property<string>("Title")

1

1008

.HasColumnType("TEXT");

1

1009

1

1010

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

1

1011

.HasColumnType("INTEGER");

1

1012

1

1013

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

1

1014

1

1015

b.ToTable("MediaStreamInfos");

1

1016

1

1017

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

1

1018

});

1

1020

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

1

1021

{

1

1022

b.Property<Guid>("Id")

1

1023

.ValueGeneratedOnAdd()

1

1024

.HasColumnType("TEXT");

1

1025

1

1026

b.Property<string>("Name")

1

1027

.IsRequired()

1

1028

.HasColumnType("TEXT");

1

1029

1

1030

b.Property<string>("PersonType")

1

1031

.HasColumnType("TEXT");

1

1032

1

1033

b.HasKey("Id");

1

1034

1

1035

b.HasIndex("Name");

1

1036

1

1037

b.ToTable("Peoples");

1

1038

1

1039

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

1

1040

});

1

1042

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

1

1043

{

1

1044

b.Property<Guid>("ItemId")

1

1045

.HasColumnType("TEXT");

1

1046

1

1047

b.Property<Guid>("PeopleId")

1

1048

.HasColumnType("TEXT");

1

1049

1

1050

b.Property<string>("Role")

1

1051

.HasColumnType("TEXT");

1

1052

1

1053

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

1

1054

.HasColumnType("INTEGER");

1

1055

1

1056

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

1

1057

.HasColumnType("INTEGER");

1

1058

1

1059

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

1

1060

1

1061

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

1

1062

1

1063

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

1

1064

1

1065

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

1

1066

1

1067

b.ToTable("PeopleBaseItemMap");

1

1068

1

1069

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

1

1070

});

1

1072

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

1

1073

{

1

1074

b.Property<int>("Id")

1

1075

.ValueGeneratedOnAdd()

1

1076

.HasColumnType("INTEGER");

1

1077

1

1078

b.Property<int>("Kind")

1

1079

.HasColumnType("INTEGER");

1

1080

1

1081

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

1

1082

.HasColumnType("TEXT");

1

1083

1

1084

b.Property<uint>("RowVersion")

1

1085

.IsConcurrencyToken()

1

1086

.HasColumnType("INTEGER");

1

1087

1

1088

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

1

1089

.HasColumnType("TEXT");

1

1090

1

1091

b.Property<bool>("Value")

1

1092

.HasColumnType("INTEGER");

1

1093

1

1094

b.HasKey("Id");

1

1095

1

1096

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

1

1097

.IsUnique()

1

1098

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

1

1099

1

1100

b.ToTable("Permissions");

1

1101

1

1102

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

1

1103

});

1

1105

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

1

1106

{

1

1107

b.Property<int>("Id")

1

1108

.ValueGeneratedOnAdd()

1

1109

.HasColumnType("INTEGER");

1

1110

1

1111

b.Property<int>("Kind")

1

1112

.HasColumnType("INTEGER");

1

1113

1

1114

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

1

1115

.HasColumnType("TEXT");

1

1116

1

1117

b.Property<uint>("RowVersion")

1

1118

.IsConcurrencyToken()

1

1119

.HasColumnType("INTEGER");

1

1120

1

1121

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

1

1122

.HasColumnType("TEXT");

1

1123

1

1124

b.Property<string>("Value")

1

1125

.IsRequired()

1

1126

.HasMaxLength(65535)

1

1127

.HasColumnType("TEXT");

1

1128

1

1129

b.HasKey("Id");

1

1130

1

1131

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

1

1132

.IsUnique()

1

1133

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

1

1134

1

1135

b.ToTable("Preferences");

1

1136

1

1137

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

1

1138

});

1

1140

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

1

1141

{

1

1142

b.Property<int>("Id")

1

1143

.ValueGeneratedOnAdd()

1

1144

.HasColumnType("INTEGER");

1

1145

1

1146

b.Property<string>("AccessToken")

1

1147

.IsRequired()

1

1148

.HasColumnType("TEXT");

1

1149

1

1150

b.Property<DateTime>("DateCreated")

1

1151

.HasColumnType("TEXT");

1

1152

1

1153

b.Property<DateTime>("DateLastActivity")

1

1154

.HasColumnType("TEXT");

1

1155

1

1156

b.Property<string>("Name")

1

1157

.IsRequired()

1

1158

.HasMaxLength(64)

1

1159

.HasColumnType("TEXT");

1

1160

1

1161

b.HasKey("Id");

1

1162

1

1163

b.HasIndex("AccessToken")

1

1164

.IsUnique();

1

1165

1

1166

b.ToTable("ApiKeys");

1

1167

1

1168

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

1

1169

});

1

1171

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

1

1172

{

1

1173

b.Property<int>("Id")

1

1174

.ValueGeneratedOnAdd()

1

1175

.HasColumnType("INTEGER");

1

1176

1

1177

b.Property<string>("AccessToken")

1

1178

.IsRequired()

1

1179

.HasColumnType("TEXT");

1

1180

1

1181

b.Property<string>("AppName")

1

1182

.IsRequired()

1

1183

.HasMaxLength(64)

1

1184

.HasColumnType("TEXT");

1

1185

1

1186

b.Property<string>("AppVersion")

1

1187

.IsRequired()

1

1188

.HasMaxLength(32)

1

1189

.HasColumnType("TEXT");

1

1190

1

1191

b.Property<DateTime>("DateCreated")

1

1192

.HasColumnType("TEXT");

1

1193

1

1194

b.Property<DateTime>("DateLastActivity")

1

1195

.HasColumnType("TEXT");

1

1196

1

1197

b.Property<DateTime>("DateModified")

1

1198

.HasColumnType("TEXT");

1

1199

1

1200

b.Property<string>("DeviceId")

1

1201

.IsRequired()

1

1202

.HasMaxLength(256)

1

1203

.HasColumnType("TEXT");

1

1204

1

1205

b.Property<string>("DeviceName")

1

1206

.IsRequired()

1

1207

.HasMaxLength(64)

1

1208

.HasColumnType("TEXT");

1

1209

1

1210

b.Property<bool>("IsActive")

1

1211

.HasColumnType("INTEGER");

1

1212

1

1213

b.Property<Guid>("UserId")

1

1214

.HasColumnType("TEXT");

1

1215

1

1216

b.HasKey("Id");

1

1217

1

1218

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

1

1219

1

1220

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

1

1221

1

1222

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

1

1223

1

1224

b.ToTable("Devices");

1

1225

1

1226

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

1

1227

});

1

1229

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

1

1230

{

1

1231

b.Property<int>("Id")

1

1232

.ValueGeneratedOnAdd()

1

1233

.HasColumnType("INTEGER");

1

1234

1

1235

b.Property<string>("CustomName")

1

1236

.HasColumnType("TEXT");

1

1237

1

1238

b.Property<string>("DeviceId")

1

1239

.IsRequired()

1

1240

.HasColumnType("TEXT");

1

1241

1

1242

b.HasKey("Id");

1

1243

1

1244

b.HasIndex("DeviceId")

1

1245

.IsUnique();

1

1246

1

1247

b.ToTable("DeviceOptions");

1

1248

1

1249

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

1

1250

});

1

1252

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

1

1253

{

1

1254

b.Property<Guid>("ItemId")

1

1255

.HasColumnType("TEXT");

1

1256

1

1257

b.Property<int>("Width")

1

1258

.HasColumnType("INTEGER");

1

1259

1

1260

b.Property<int>("Bandwidth")

1

1261

.HasColumnType("INTEGER");

1

1262

1

1263

b.Property<int>("Height")

1

1264

.HasColumnType("INTEGER");

1

1265

1

1266

b.Property<int>("Interval")

1

1267

.HasColumnType("INTEGER");

1

1268

1

1269

b.Property<int>("ThumbnailCount")

1

1270

.HasColumnType("INTEGER");

1

1271

1

1272

b.Property<int>("TileHeight")

1

1273

.HasColumnType("INTEGER");

1

1274

1

1275

b.Property<int>("TileWidth")

1

1276

.HasColumnType("INTEGER");

1

1277

1

1278

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

1

1279

1

1280

b.ToTable("TrickplayInfos");

1

1281

1

1282

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

1

1283

});

1

1285

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

1

1286

{

1

1287

b.Property<Guid>("Id")

1

1288

.ValueGeneratedOnAdd()

1

1289

.HasColumnType("TEXT");

1

1290

1

1291

b.Property<string>("AudioLanguagePreference")

1

1292

.HasMaxLength(255)

1

1293

.HasColumnType("TEXT");

1

1294

1

1295

b.Property<string>("AuthenticationProviderId")

1

1296

.IsRequired()

1

1297

.HasMaxLength(255)

1

1298

.HasColumnType("TEXT");

1

1299

1

1300

b.Property<string>("CastReceiverId")

1

1301

.HasMaxLength(32)

1

1302

.HasColumnType("TEXT");

1

1303

1

1304

b.Property<bool>("DisplayCollectionsView")

1

1305

.HasColumnType("INTEGER");

1

1306

1

1307

b.Property<bool>("DisplayMissingEpisodes")

1

1308

.HasColumnType("INTEGER");

1

1309

1

1310

b.Property<bool>("EnableAutoLogin")

1

1311

.HasColumnType("INTEGER");

1

1312

1

1313

b.Property<bool>("EnableLocalPassword")

1

1314

.HasColumnType("INTEGER");

1

1315

1

1316

b.Property<bool>("EnableNextEpisodeAutoPlay")

1

1317

.HasColumnType("INTEGER");

1

1318

1

1319

b.Property<bool>("EnableUserPreferenceAccess")

1

1320

.HasColumnType("INTEGER");

1

1321

1

1322

b.Property<bool>("HidePlayedInLatest")

1

1323

.HasColumnType("INTEGER");

1

1324

1

1325

b.Property<long>("InternalId")

1

1326

.HasColumnType("INTEGER");

1

1327

1

1328

b.Property<int>("InvalidLoginAttemptCount")

1

1329

.HasColumnType("INTEGER");

1

1330

1

1331

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

1

1332

.HasColumnType("TEXT");

1

1333

1

1334

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

1

1335

.HasColumnType("TEXT");

1

1336

1

1337

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

1

1338

.HasColumnType("INTEGER");

1

1339

1

1340

b.Property<int>("MaxActiveSessions")

1

1341

.HasColumnType("INTEGER");

1

1342

1

1343

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

1

1344

.HasColumnType("INTEGER");

1

1345

1

1346

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

1

1347

.HasColumnType("INTEGER");

1

1348

1

1349

b.Property<bool>("MustUpdatePassword")

1

1350

.HasColumnType("INTEGER");

1

1351

1

1352

b.Property<string>("NormalizedUsername")

1

1353

.IsRequired()

1

1354

.HasMaxLength(255)

1

1355

.HasColumnType("TEXT");

1

1356

1

1357

b.Property<string>("Password")

1

1358

.HasMaxLength(65535)

1

1359

.HasColumnType("TEXT");

1

1360

1

1361

b.Property<string>("PasswordResetProviderId")

1

1362

.IsRequired()

1

1363

.HasMaxLength(255)

1

1364

.HasColumnType("TEXT");

1

1365

1

1366

b.Property<bool>("PlayDefaultAudioTrack")

1

1367

.HasColumnType("INTEGER");

1

1368

1

1369

b.Property<bool>("RememberAudioSelections")

1

1370

.HasColumnType("INTEGER");

1

1371

1

1372

b.Property<bool>("RememberSubtitleSelections")

1

1373

.HasColumnType("INTEGER");

1

1374

1

1375

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

1

1376

.HasColumnType("INTEGER");

1

1377

1

1378

b.Property<uint>("RowVersion")

1

1379

.IsConcurrencyToken()

1

1380

.HasColumnType("INTEGER");

1

1381

1

1382

b.Property<string>("SubtitleLanguagePreference")

1

1383

.HasMaxLength(255)

1

1384

.HasColumnType("TEXT");

1

1385

1

1386

b.Property<int>("SubtitleMode")

1

1387

.HasColumnType("INTEGER");

1

1388

1

1389

b.Property<int>("SyncPlayAccess")

1

1390

.HasColumnType("INTEGER");

1

1391

1

1392

b.Property<string>("Username")

1

1393

.IsRequired()

1

1394

.HasMaxLength(255)

1

1395

.HasColumnType("TEXT");

1

1396

1

1397

b.HasKey("Id");

1

1398

1

1399

b.HasIndex("NormalizedUsername")

1

1400

.IsUnique();

1

1401

1

1402

b.HasIndex("Username")

1

1403

.IsUnique();

1

1404

1

1405

b.ToTable("Users");

1

1406

1

1407

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

1

1408

});

1

1410

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

1

1411

{

1

1412

b.Property<Guid>("ItemId")

1

1413

.HasColumnType("TEXT");

1

1414

1

1415

b.Property<Guid>("UserId")

1

1416

.HasColumnType("TEXT");

1

1417

1

1418

b.Property<string>("CustomDataKey")

1

1419

.HasColumnType("TEXT");

1

1420

1

1421

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

1

1422

.HasColumnType("INTEGER");

1

1423

1

1424

b.Property<bool>("IsFavorite")

1

1425

.HasColumnType("INTEGER");

1

1426

1

1427

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

1

1428

.HasColumnType("TEXT");

1

1429

1

1430

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

1

1431

.HasColumnType("INTEGER");

1

1432

1

1433

b.Property<int>("PlayCount")

1

1434

.HasColumnType("INTEGER");

1

1435

1

1436

b.Property<long>("PlaybackPositionTicks")

1

1437

.HasColumnType("INTEGER");

1

1438

1

1439

b.Property<bool>("Played")

1

1440

.HasColumnType("INTEGER");

1

1441

1

1442

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

1

1443

.HasColumnType("REAL");

1

1444

1

1445

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

1

1446

.HasColumnType("TEXT");

1

1447

1

1448

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

1

1449

.HasColumnType("INTEGER");

1

1450

1

1451

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

1

1452

1

1453

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

1

1454

1

1455

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

1

1456

1

1457

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

1

1458

1

1459

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

1

1460

1

1461

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

1

1462

1

1463

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

1

1464

1

1465

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

1

1466

1

1467

b.ToTable("UserData");

1

1468

1

1469

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

1

1470

});

1

1472

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

1

1473

{

1

1474

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

1

1475

.WithMany("AccessSchedules")

1

1476

.HasForeignKey("UserId")

1

1477

.OnDelete(DeleteBehavior.Cascade)

1

1478

.IsRequired();

1

1479

});

1

1481

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

1

1482

{

1

1483

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

1

1484

.WithMany("Parents")

1

1485

.HasForeignKey("ItemId")

1

1486

.OnDelete(DeleteBehavior.Cascade)

1

1487

.IsRequired();

1

1488

1

1489

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

1

1490

.WithMany("Children")

1

1491

.HasForeignKey("ParentItemId")

1

1492

.OnDelete(DeleteBehavior.Cascade)

1

1493

.IsRequired();

1

1494

1

1495

b.Navigation("Item");

1

1496

1

1497

b.Navigation("ParentItem");

1

1498

});

1

1500

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

1

1501

{

1

1502

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

1

1503

.WithMany()

1

1504

.HasForeignKey("ItemId")

1

1505

.OnDelete(DeleteBehavior.Cascade)

1

1506

.IsRequired();

1

1507

1

1508

b.Navigation("Item");

1

1509

});

1

1511

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

1

1512

{

1

1513

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

1

1514

.WithMany("Extras")

1

1515

.HasForeignKey("OwnerId")

1

1516

.OnDelete(DeleteBehavior.NoAction);

1

1517

1

1518

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

1

1519

.WithMany("DirectChildren")

1

1520

.HasForeignKey("ParentId")

1

1521

.OnDelete(DeleteBehavior.Cascade);

1

1522

1

1523

b.Navigation("DirectParent");

1

1524

1

1525

b.Navigation("Owner");

1

1526

});

1

1528

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

1

1529

{

1

1530

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

1

1531

.WithMany("Images")

1

1532

.HasForeignKey("ItemId")

1

1533

.OnDelete(DeleteBehavior.Cascade)

1

1534

.IsRequired();

1

1535

1

1536

b.Navigation("Item");

1

1537

});

1

1539

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

1

1540

{

1

1541

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

1

1542

.WithMany("LockedFields")

1

1543

.HasForeignKey("ItemId")

1

1544

.OnDelete(DeleteBehavior.Cascade)

1

1545

.IsRequired();

1

1546

1

1547

b.Navigation("Item");

1

1548

});

1

1550

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

1

1551

{

1

1552

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

1

1553

.WithMany("Provider")

1

1554

.HasForeignKey("ItemId")

1

1555

.OnDelete(DeleteBehavior.Cascade)

1

1556

.IsRequired();

1

1557

1

1558

b.Navigation("Item");

1

1559

});

1

1561

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

1

1562

{

1

1563

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

1

1564

.WithMany("TrailerTypes")

1

1565

.HasForeignKey("ItemId")

1

1566

.OnDelete(DeleteBehavior.Cascade)

1

1567

.IsRequired();

1

1568

1

1569

b.Navigation("Item");

1

1570

});

1

1572

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

1

1573

{

1

1574

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

1

1575

.WithMany("Chapters")

1

1576

.HasForeignKey("ItemId")

1

1577

.OnDelete(DeleteBehavior.Cascade)

1

1578

.IsRequired();

1

1579

1

1580

b.Navigation("Item");

1

1581

});

1

1583

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

1

1584

{

1

1585

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

1

1586

.WithMany("DisplayPreferences")

1

1587

.HasForeignKey("UserId")

1

1588

.OnDelete(DeleteBehavior.Cascade)

1

1589

.IsRequired();

1

1590

});

1

1592

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

1

1593

{

1

1594

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

1

1595

.WithMany("HomeSections")

1

1596

.HasForeignKey("DisplayPreferencesId")

1

1597

.OnDelete(DeleteBehavior.Cascade)

1

1598

.IsRequired();

1

1599

});

1

1601

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

1

1602

{

1

1603

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

1

1604

.WithOne("ProfileImage")

1

1605

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

1

1606

.OnDelete(DeleteBehavior.Cascade);

1

1607

});

1

1609

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

1

1610

{

1

1611

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

1

1612

.WithMany("ItemDisplayPreferences")

1

1613

.HasForeignKey("UserId")

1

1614

.OnDelete(DeleteBehavior.Cascade)

1

1615

.IsRequired();

1

1616

});

1

1618

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

1

1619

{

1

1620

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

1

1621

.WithMany("ItemValues")

1

1622

.HasForeignKey("ItemId")

1

1623

.OnDelete(DeleteBehavior.Cascade)

1

1624

.IsRequired();

1

1625

1

1626

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

1

1627

.WithMany("BaseItemsMap")

1

1628

.HasForeignKey("ItemValueId")

1

1629

.OnDelete(DeleteBehavior.Cascade)

1

1630

.IsRequired();

1

1631

1

1632

b.Navigation("Item");

1

1633

1

1634

b.Navigation("ItemValue");

1

1635

});

1

1637

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

1

1638

{

1

1639

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

1

1640

.WithMany()

1

1641

.HasForeignKey("ItemId")

1

1642

.OnDelete(DeleteBehavior.Cascade)

1

1643

.IsRequired();

1

1644

1

1645

b.Navigation("Item");

1

1646

});

1

1648

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

1

1649

{

1

1650

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

1

1651

.WithMany("LinkedChildOfEntities")

1

1652

.HasForeignKey("ChildId")

1

1653

.OnDelete(DeleteBehavior.NoAction)

1

1654

.IsRequired();

1

1655

1

1656

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

1

1657

.WithMany("LinkedChildEntities")

1

1658

.HasForeignKey("ParentId")

1

1659

.OnDelete(DeleteBehavior.NoAction)

1

1660

.IsRequired();

1

1661

1

1662

b.Navigation("Child");

1

1663

1

1664

b.Navigation("Parent");

1

1665

});

1

1667

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

1

1668

{

1

1669

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

1

1670

.WithMany("MediaStreams")

1

1671

.HasForeignKey("ItemId")

1

1672

.OnDelete(DeleteBehavior.Cascade)

1

1673

.IsRequired();

1

1674

1

1675

b.Navigation("Item");

1

1676

});

1

1678

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

1

1679

{

1

1680

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

1

1681

.WithMany("Peoples")

1

1682

.HasForeignKey("ItemId")

1

1683

.OnDelete(DeleteBehavior.Cascade)

1

1684

.IsRequired();

1

1685

1

1686

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

1

1687

.WithMany("BaseItems")

1

1688

.HasForeignKey("PeopleId")

1

1689

.OnDelete(DeleteBehavior.Cascade)

1

1690

.IsRequired();

1

1691

1

1692

b.Navigation("Item");

1

1693

1

1694

b.Navigation("People");

1

1695

});

1

1697

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

1

1698

{

1

1699

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

1

1700

.WithMany("Permissions")

1

1701

.HasForeignKey("UserId")

1

1702

.OnDelete(DeleteBehavior.Cascade);

1

1703

});

1

1705

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

1

1706

{

1

1707

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

1

1708

.WithMany("Preferences")

1

1709

.HasForeignKey("UserId")

1

1710

.OnDelete(DeleteBehavior.Cascade);

1

1711

});

1

1713

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

1

1714

{

1

1715

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

1

1716

.WithMany()

1

1717

.HasForeignKey("UserId")

1

1718

.OnDelete(DeleteBehavior.Cascade)

1

1719

.IsRequired();

1

1720

1

1721

b.Navigation("User");

1

1722

});

1

1724

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

1

1725

{

1

1726

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

1

1727

.WithMany("UserData")

1

1728

.HasForeignKey("ItemId")

1

1729

.OnDelete(DeleteBehavior.Cascade)

1

1730

.IsRequired();

1

1731

1

1732

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

1

1733

.WithMany()

1

1734

.HasForeignKey("UserId")

1

1735

.OnDelete(DeleteBehavior.Cascade)

1

1736

.IsRequired();

1

1737

1

1738

b.Navigation("Item");

1

1739

1

1740

b.Navigation("User");

1

1741

});

1

1743

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

1

1744

{

1

1745

b.Navigation("Chapters");

1

1746

1

1747

b.Navigation("Children");

1

1748

1

1749

b.Navigation("DirectChildren");

1

1750

1

1751

b.Navigation("Extras");

1

1752

1

1753

b.Navigation("Images");

1

1754

1

1755

b.Navigation("ItemValues");

1

1756

1

1757

b.Navigation("LinkedChildEntities");

1

1758

1

1759

b.Navigation("LinkedChildOfEntities");

1

1760

1

1761

b.Navigation("LockedFields");

1

1762

1

1763

b.Navigation("MediaStreams");

1

1764

1

1765

b.Navigation("Parents");

1

1766

1

1767

b.Navigation("Peoples");

1

1768

1

1769

b.Navigation("Provider");

1

1770

1

1771

b.Navigation("TrailerTypes");

1

1772

1

1773

b.Navigation("UserData");

1

1774

});

1

1776

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

1

1777

{

1

1778

b.Navigation("HomeSections");

1

1779

});

1

1781

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

1

1782

{

1

1783

b.Navigation("BaseItemsMap");

1

1784

});

1

1786

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

1

1787

{

1

1788

b.Navigation("BaseItems");

1

1789

});

1

1791

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

1

1792

{

1

1793

b.Navigation("AccessSchedules");

1

1794

1

1795

b.Navigation("DisplayPreferences");

1

1796

1

1797

b.Navigation("ItemDisplayPreferences");

1

1798

1

1799

b.Navigation("Permissions");

1

1800

1

1801

b.Navigation("Preferences");

1

1802

1

1803

b.Navigation("ProfileImage");

1

1804

});

1

1806

}

< Summary - Jellyfin

Coverage history

Coverage delta

Metrics

File(s)

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

Methods/Properties