< Summary - Jellyfin

Information
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
Line coverage
100%
Covered lines: 1613
Uncovered lines: 0
Coverable lines: 1613
Total lines: 1688
Line coverage: 100%
Branch coverage
N/A
Covered branches: 0
Total branches: 0
Branch coverage: N/A
Method coverage

Feature is only available for sponsors

Upgrade to PRO version

Coverage history

Coverage history 0 25 50 75 100

Metrics

MethodBranch coverage Crap Score Cyclomatic complexity Line coverage
BuildModel(...)100%11100%

File(s)

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

#LineLine coverage
 1// <auto-generated />
 2using System;
 3using Jellyfin.Database.Implementations;
 4using Microsoft.EntityFrameworkCore;
 5using Microsoft.EntityFrameworkCore.Infrastructure;
 6using Microsoft.EntityFrameworkCore.Storage.ValueConversion;
 7
 8#nullable disable
 9
 10namespace 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
 118            modelBuilder.HasAnnotation("ProductVersion", "9.0.3");
 19
 120            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>
 121                {
 122                    b.Property<int>("Id")
 123                        .ValueGeneratedOnAdd()
 124                        .HasColumnType("INTEGER");
 125
 126                    b.Property<int>("DayOfWeek")
 127                        .HasColumnType("INTEGER");
 128
 129                    b.Property<double>("EndHour")
 130                        .HasColumnType("REAL");
 131
 132                    b.Property<double>("StartHour")
 133                        .HasColumnType("REAL");
 134
 135                    b.Property<Guid>("UserId")
 136                        .HasColumnType("TEXT");
 137
 138                    b.HasKey("Id");
 139
 140                    b.HasIndex("UserId");
 141
 142                    b.ToTable("AccessSchedules");
 143
 144                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 145                });
 46
 147            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ActivityLog", b =>
 148                {
 149                    b.Property<int>("Id")
 150                        .ValueGeneratedOnAdd()
 151                        .HasColumnType("INTEGER");
 152
 153                    b.Property<DateTime>("DateCreated")
 154                        .HasColumnType("TEXT");
 155
 156                    b.Property<string>("ItemId")
 157                        .HasMaxLength(256)
 158                        .HasColumnType("TEXT");
 159
 160                    b.Property<int>("LogSeverity")
 161                        .HasColumnType("INTEGER");
 162
 163                    b.Property<string>("Name")
 164                        .IsRequired()
 165                        .HasMaxLength(512)
 166                        .HasColumnType("TEXT");
 167
 168                    b.Property<string>("Overview")
 169                        .HasMaxLength(512)
 170                        .HasColumnType("TEXT");
 171
 172                    b.Property<uint>("RowVersion")
 173                        .IsConcurrencyToken()
 174                        .HasColumnType("INTEGER");
 175
 176                    b.Property<string>("ShortOverview")
 177                        .HasMaxLength(512)
 178                        .HasColumnType("TEXT");
 179
 180                    b.Property<string>("Type")
 181                        .IsRequired()
 182                        .HasMaxLength(256)
 183                        .HasColumnType("TEXT");
 184
 185                    b.Property<Guid>("UserId")
 186                        .HasColumnType("TEXT");
 187
 188                    b.HasKey("Id");
 189
 190                    b.HasIndex("DateCreated");
 191
 192                    b.ToTable("ActivityLogs");
 193
 194                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 195                });
 96
 197            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>
 198                {
 199                    b.Property<Guid>("ItemId")
 1100                        .HasColumnType("TEXT");
 1101
 1102                    b.Property<Guid>("ParentItemId")
 1103                        .HasColumnType("TEXT");
 1104
 1105                    b.HasKey("ItemId", "ParentItemId");
 1106
 1107                    b.HasIndex("ParentItemId");
 1108
 1109                    b.ToTable("AncestorIds");
 1110
 1111                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1112                });
 113
 1114            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>
 1115                {
 1116                    b.Property<Guid>("ItemId")
 1117                        .HasColumnType("TEXT");
 1118
 1119                    b.Property<int>("Index")
 1120                        .HasColumnType("INTEGER");
 1121
 1122                    b.Property<string>("Codec")
 1123                        .HasColumnType("TEXT");
 1124
 1125                    b.Property<string>("CodecTag")
 1126                        .HasColumnType("TEXT");
 1127
 1128                    b.Property<string>("Comment")
 1129                        .HasColumnType("TEXT");
 1130
 1131                    b.Property<string>("Filename")
 1132                        .HasColumnType("TEXT");
 1133
 1134                    b.Property<string>("MimeType")
 1135                        .HasColumnType("TEXT");
 1136
 1137                    b.HasKey("ItemId", "Index");
 1138
 1139                    b.ToTable("AttachmentStreamInfos");
 1140
 1141                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1142                });
 143
 1144            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 1145                {
 1146                    b.Property<Guid>("Id")
 1147                        .ValueGeneratedOnAdd()
 1148                        .HasColumnType("TEXT");
 1149
 1150                    b.Property<string>("Album")
 1151                        .HasColumnType("TEXT");
 1152
 1153                    b.Property<string>("AlbumArtists")
 1154                        .HasColumnType("TEXT");
 1155
 1156                    b.Property<string>("Artists")
 1157                        .HasColumnType("TEXT");
 1158
 1159                    b.Property<int?>("Audio")
 1160                        .HasColumnType("INTEGER");
 1161
 1162                    b.Property<Guid?>("ChannelId")
 1163                        .HasColumnType("TEXT");
 1164
 1165                    b.Property<string>("CleanName")
 1166                        .HasColumnType("TEXT");
 1167
 1168                    b.Property<float?>("CommunityRating")
 1169                        .HasColumnType("REAL");
 1170
 1171                    b.Property<float?>("CriticRating")
 1172                        .HasColumnType("REAL");
 1173
 1174                    b.Property<string>("CustomRating")
 1175                        .HasColumnType("TEXT");
 1176
 1177                    b.Property<string>("Data")
 1178                        .HasColumnType("TEXT");
 1179
 1180                    b.Property<DateTime?>("DateCreated")
 1181                        .HasColumnType("TEXT");
 1182
 1183                    b.Property<DateTime?>("DateLastMediaAdded")
 1184                        .HasColumnType("TEXT");
 1185
 1186                    b.Property<DateTime?>("DateLastRefreshed")
 1187                        .HasColumnType("TEXT");
 1188
 1189                    b.Property<DateTime?>("DateLastSaved")
 1190                        .HasColumnType("TEXT");
 1191
 1192                    b.Property<DateTime?>("DateModified")
 1193                        .HasColumnType("TEXT");
 1194
 1195                    b.Property<DateTime?>("EndDate")
 1196                        .HasColumnType("TEXT");
 1197
 1198                    b.Property<string>("EpisodeTitle")
 1199                        .HasColumnType("TEXT");
 1200
 1201                    b.Property<string>("ExternalId")
 1202                        .HasColumnType("TEXT");
 1203
 1204                    b.Property<string>("ExternalSeriesId")
 1205                        .HasColumnType("TEXT");
 1206
 1207                    b.Property<string>("ExternalServiceId")
 1208                        .HasColumnType("TEXT");
 1209
 1210                    b.Property<string>("ExtraIds")
 1211                        .HasColumnType("TEXT");
 1212
 1213                    b.Property<int?>("ExtraType")
 1214                        .HasColumnType("INTEGER");
 1215
 1216                    b.Property<string>("ForcedSortName")
 1217                        .HasColumnType("TEXT");
 1218
 1219                    b.Property<string>("Genres")
 1220                        .HasColumnType("TEXT");
 1221
 1222                    b.Property<int?>("Height")
 1223                        .HasColumnType("INTEGER");
 1224
 1225                    b.Property<int?>("IndexNumber")
 1226                        .HasColumnType("INTEGER");
 1227
 1228                    b.Property<int?>("InheritedParentalRatingSubValue")
 1229                        .HasColumnType("INTEGER");
 1230
 1231                    b.Property<int?>("InheritedParentalRatingValue")
 1232                        .HasColumnType("INTEGER");
 1233
 1234                    b.Property<bool>("IsFolder")
 1235                        .HasColumnType("INTEGER");
 1236
 1237                    b.Property<bool>("IsInMixedFolder")
 1238                        .HasColumnType("INTEGER");
 1239
 1240                    b.Property<bool>("IsLocked")
 1241                        .HasColumnType("INTEGER");
 1242
 1243                    b.Property<bool>("IsMovie")
 1244                        .HasColumnType("INTEGER");
 1245
 1246                    b.Property<bool>("IsRepeat")
 1247                        .HasColumnType("INTEGER");
 1248
 1249                    b.Property<bool>("IsSeries")
 1250                        .HasColumnType("INTEGER");
 1251
 1252                    b.Property<bool>("IsVirtualItem")
 1253                        .HasColumnType("INTEGER");
 1254
 1255                    b.Property<float?>("LUFS")
 1256                        .HasColumnType("REAL");
 1257
 1258                    b.Property<string>("MediaType")
 1259                        .HasColumnType("TEXT");
 1260
 1261                    b.Property<string>("Name")
 1262                        .HasColumnType("TEXT");
 1263
 1264                    b.Property<float?>("NormalizationGain")
 1265                        .HasColumnType("REAL");
 1266
 1267                    b.Property<string>("OfficialRating")
 1268                        .HasColumnType("TEXT");
 1269
 1270                    b.Property<string>("OriginalTitle")
 1271                        .HasColumnType("TEXT");
 1272
 1273                    b.Property<string>("Overview")
 1274                        .HasColumnType("TEXT");
 1275
 1276                    b.Property<string>("OwnerId")
 1277                        .HasColumnType("TEXT");
 1278
 1279                    b.Property<Guid?>("ParentId")
 1280                        .HasColumnType("TEXT");
 1281
 1282                    b.Property<int?>("ParentIndexNumber")
 1283                        .HasColumnType("INTEGER");
 1284
 1285                    b.Property<string>("Path")
 1286                        .HasColumnType("TEXT");
 1287
 1288                    b.Property<string>("PreferredMetadataCountryCode")
 1289                        .HasColumnType("TEXT");
 1290
 1291                    b.Property<string>("PreferredMetadataLanguage")
 1292                        .HasColumnType("TEXT");
 1293
 1294                    b.Property<DateTime?>("PremiereDate")
 1295                        .HasColumnType("TEXT");
 1296
 1297                    b.Property<string>("PresentationUniqueKey")
 1298                        .HasColumnType("TEXT");
 1299
 1300                    b.Property<string>("PrimaryVersionId")
 1301                        .HasColumnType("TEXT");
 1302
 1303                    b.Property<string>("ProductionLocations")
 1304                        .HasColumnType("TEXT");
 1305
 1306                    b.Property<int?>("ProductionYear")
 1307                        .HasColumnType("INTEGER");
 1308
 1309                    b.Property<long?>("RunTimeTicks")
 1310                        .HasColumnType("INTEGER");
 1311
 1312                    b.Property<Guid?>("SeasonId")
 1313                        .HasColumnType("TEXT");
 1314
 1315                    b.Property<string>("SeasonName")
 1316                        .HasColumnType("TEXT");
 1317
 1318                    b.Property<Guid?>("SeriesId")
 1319                        .HasColumnType("TEXT");
 1320
 1321                    b.Property<string>("SeriesName")
 1322                        .HasColumnType("TEXT");
 1323
 1324                    b.Property<string>("SeriesPresentationUniqueKey")
 1325                        .HasColumnType("TEXT");
 1326
 1327                    b.Property<string>("ShowId")
 1328                        .HasColumnType("TEXT");
 1329
 1330                    b.Property<long?>("Size")
 1331                        .HasColumnType("INTEGER");
 1332
 1333                    b.Property<string>("SortName")
 1334                        .HasColumnType("TEXT");
 1335
 1336                    b.Property<DateTime?>("StartDate")
 1337                        .HasColumnType("TEXT");
 1338
 1339                    b.Property<string>("Studios")
 1340                        .HasColumnType("TEXT");
 1341
 1342                    b.Property<string>("Tagline")
 1343                        .HasColumnType("TEXT");
 1344
 1345                    b.Property<string>("Tags")
 1346                        .HasColumnType("TEXT");
 1347
 1348                    b.Property<Guid?>("TopParentId")
 1349                        .HasColumnType("TEXT");
 1350
 1351                    b.Property<int?>("TotalBitrate")
 1352                        .HasColumnType("INTEGER");
 1353
 1354                    b.Property<string>("Type")
 1355                        .IsRequired()
 1356                        .HasColumnType("TEXT");
 1357
 1358                    b.Property<string>("UnratedType")
 1359                        .HasColumnType("TEXT");
 1360
 1361                    b.Property<int?>("Width")
 1362                        .HasColumnType("INTEGER");
 1363
 1364                    b.HasKey("Id");
 1365
 1366                    b.HasIndex("ParentId");
 1367
 1368                    b.HasIndex("Path");
 1369
 1370                    b.HasIndex("PresentationUniqueKey");
 1371
 1372                    b.HasIndex("TopParentId", "Id");
 1373
 1374                    b.HasIndex("Type", "TopParentId", "Id");
 1375
 1376                    b.HasIndex("Type", "TopParentId", "PresentationUniqueKey");
 1377
 1378                    b.HasIndex("Type", "TopParentId", "StartDate");
 1379
 1380                    b.HasIndex("Id", "Type", "IsFolder", "IsVirtualItem");
 1381
 1382                    b.HasIndex("MediaType", "TopParentId", "IsVirtualItem", "PresentationUniqueKey");
 1383
 1384                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "IsFolder", "IsVirtualItem");
 1385
 1386                    b.HasIndex("Type", "SeriesPresentationUniqueKey", "PresentationUniqueKey", "SortName");
 1387
 1388                    b.HasIndex("IsFolder", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 1389
 1390                    b.HasIndex("Type", "TopParentId", "IsVirtualItem", "PresentationUniqueKey", "DateCreated");
 1391
 1392                    b.ToTable("BaseItems");
 1393
 1394                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1395                });
 396
 1397            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 1398                {
 1399                    b.Property<Guid>("Id")
 1400                        .ValueGeneratedOnAdd()
 1401                        .HasColumnType("TEXT");
 1402
 1403                    b.Property<byte[]>("Blurhash")
 1404                        .HasColumnType("BLOB");
 1405
 1406                    b.Property<DateTime>("DateModified")
 1407                        .HasColumnType("TEXT");
 1408
 1409                    b.Property<int>("Height")
 1410                        .HasColumnType("INTEGER");
 1411
 1412                    b.Property<int>("ImageType")
 1413                        .HasColumnType("INTEGER");
 1414
 1415                    b.Property<Guid>("ItemId")
 1416                        .HasColumnType("TEXT");
 1417
 1418                    b.Property<string>("Path")
 1419                        .IsRequired()
 1420                        .HasColumnType("TEXT");
 1421
 1422                    b.Property<int>("Width")
 1423                        .HasColumnType("INTEGER");
 1424
 1425                    b.HasKey("Id");
 1426
 1427                    b.HasIndex("ItemId");
 1428
 1429                    b.ToTable("BaseItemImageInfos");
 1430
 1431                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1432                });
 433
 1434            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 1435                {
 1436                    b.Property<int>("Id")
 1437                        .HasColumnType("INTEGER");
 1438
 1439                    b.Property<Guid>("ItemId")
 1440                        .HasColumnType("TEXT");
 1441
 1442                    b.HasKey("Id", "ItemId");
 1443
 1444                    b.HasIndex("ItemId");
 1445
 1446                    b.ToTable("BaseItemMetadataFields");
 1447
 1448                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1449                });
 450
 1451            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 1452                {
 1453                    b.Property<Guid>("ItemId")
 1454                        .HasColumnType("TEXT");
 1455
 1456                    b.Property<string>("ProviderId")
 1457                        .HasColumnType("TEXT");
 1458
 1459                    b.Property<string>("ProviderValue")
 1460                        .IsRequired()
 1461                        .HasColumnType("TEXT");
 1462
 1463                    b.HasKey("ItemId", "ProviderId");
 1464
 1465                    b.HasIndex("ProviderId", "ProviderValue", "ItemId");
 1466
 1467                    b.ToTable("BaseItemProviders");
 1468
 1469                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1470                });
 471
 1472            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 1473                {
 1474                    b.Property<int>("Id")
 1475                        .HasColumnType("INTEGER");
 1476
 1477                    b.Property<Guid>("ItemId")
 1478                        .HasColumnType("TEXT");
 1479
 1480                    b.HasKey("Id", "ItemId");
 1481
 1482                    b.HasIndex("ItemId");
 1483
 1484                    b.ToTable("BaseItemTrailerTypes");
 1485
 1486                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1487                });
 488
 1489            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 1490                {
 1491                    b.Property<Guid>("ItemId")
 1492                        .HasColumnType("TEXT");
 1493
 1494                    b.Property<int>("ChapterIndex")
 1495                        .HasColumnType("INTEGER");
 1496
 1497                    b.Property<DateTime?>("ImageDateModified")
 1498                        .HasColumnType("TEXT");
 1499
 1500                    b.Property<string>("ImagePath")
 1501                        .HasColumnType("TEXT");
 1502
 1503                    b.Property<string>("Name")
 1504                        .HasColumnType("TEXT");
 1505
 1506                    b.Property<long>("StartPositionTicks")
 1507                        .HasColumnType("INTEGER");
 1508
 1509                    b.HasKey("ItemId", "ChapterIndex");
 1510
 1511                    b.ToTable("Chapters");
 1512
 1513                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1514                });
 515
 1516            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.CustomItemDisplayPreferences", b =>
 1517                {
 1518                    b.Property<int>("Id")
 1519                        .ValueGeneratedOnAdd()
 1520                        .HasColumnType("INTEGER");
 1521
 1522                    b.Property<string>("Client")
 1523                        .IsRequired()
 1524                        .HasMaxLength(32)
 1525                        .HasColumnType("TEXT");
 1526
 1527                    b.Property<Guid>("ItemId")
 1528                        .HasColumnType("TEXT");
 1529
 1530                    b.Property<string>("Key")
 1531                        .IsRequired()
 1532                        .HasColumnType("TEXT");
 1533
 1534                    b.Property<Guid>("UserId")
 1535                        .HasColumnType("TEXT");
 1536
 1537                    b.Property<string>("Value")
 1538                        .HasColumnType("TEXT");
 1539
 1540                    b.HasKey("Id");
 1541
 1542                    b.HasIndex("UserId", "ItemId", "Client", "Key")
 1543                        .IsUnique();
 1544
 1545                    b.ToTable("CustomItemDisplayPreferences");
 1546
 1547                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1548                });
 549
 1550            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 1551                {
 1552                    b.Property<int>("Id")
 1553                        .ValueGeneratedOnAdd()
 1554                        .HasColumnType("INTEGER");
 1555
 1556                    b.Property<int>("ChromecastVersion")
 1557                        .HasColumnType("INTEGER");
 1558
 1559                    b.Property<string>("Client")
 1560                        .IsRequired()
 1561                        .HasMaxLength(32)
 1562                        .HasColumnType("TEXT");
 1563
 1564                    b.Property<string>("DashboardTheme")
 1565                        .HasMaxLength(32)
 1566                        .HasColumnType("TEXT");
 1567
 1568                    b.Property<bool>("EnableNextVideoInfoOverlay")
 1569                        .HasColumnType("INTEGER");
 1570
 1571                    b.Property<int?>("IndexBy")
 1572                        .HasColumnType("INTEGER");
 1573
 1574                    b.Property<Guid>("ItemId")
 1575                        .HasColumnType("TEXT");
 1576
 1577                    b.Property<int>("ScrollDirection")
 1578                        .HasColumnType("INTEGER");
 1579
 1580                    b.Property<bool>("ShowBackdrop")
 1581                        .HasColumnType("INTEGER");
 1582
 1583                    b.Property<bool>("ShowSidebar")
 1584                        .HasColumnType("INTEGER");
 1585
 1586                    b.Property<int>("SkipBackwardLength")
 1587                        .HasColumnType("INTEGER");
 1588
 1589                    b.Property<int>("SkipForwardLength")
 1590                        .HasColumnType("INTEGER");
 1591
 1592                    b.Property<string>("TvHome")
 1593                        .HasMaxLength(32)
 1594                        .HasColumnType("TEXT");
 1595
 1596                    b.Property<Guid>("UserId")
 1597                        .HasColumnType("TEXT");
 1598
 1599                    b.HasKey("Id");
 1600
 1601                    b.HasIndex("UserId", "ItemId", "Client")
 1602                        .IsUnique();
 1603
 1604                    b.ToTable("DisplayPreferences");
 1605
 1606                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1607                });
 608
 1609            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 1610                {
 1611                    b.Property<int>("Id")
 1612                        .ValueGeneratedOnAdd()
 1613                        .HasColumnType("INTEGER");
 1614
 1615                    b.Property<int>("DisplayPreferencesId")
 1616                        .HasColumnType("INTEGER");
 1617
 1618                    b.Property<int>("Order")
 1619                        .HasColumnType("INTEGER");
 1620
 1621                    b.Property<int>("Type")
 1622                        .HasColumnType("INTEGER");
 1623
 1624                    b.HasKey("Id");
 1625
 1626                    b.HasIndex("DisplayPreferencesId");
 1627
 1628                    b.ToTable("HomeSection");
 1629
 1630                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1631                });
 632
 1633            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 1634                {
 1635                    b.Property<int>("Id")
 1636                        .ValueGeneratedOnAdd()
 1637                        .HasColumnType("INTEGER");
 1638
 1639                    b.Property<DateTime>("LastModified")
 1640                        .HasColumnType("TEXT");
 1641
 1642                    b.Property<string>("Path")
 1643                        .IsRequired()
 1644                        .HasMaxLength(512)
 1645                        .HasColumnType("TEXT");
 1646
 1647                    b.Property<Guid?>("UserId")
 1648                        .HasColumnType("TEXT");
 1649
 1650                    b.HasKey("Id");
 1651
 1652                    b.HasIndex("UserId")
 1653                        .IsUnique();
 1654
 1655                    b.ToTable("ImageInfos");
 1656
 1657                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1658                });
 659
 1660            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 1661                {
 1662                    b.Property<int>("Id")
 1663                        .ValueGeneratedOnAdd()
 1664                        .HasColumnType("INTEGER");
 1665
 1666                    b.Property<string>("Client")
 1667                        .IsRequired()
 1668                        .HasMaxLength(32)
 1669                        .HasColumnType("TEXT");
 1670
 1671                    b.Property<int?>("IndexBy")
 1672                        .HasColumnType("INTEGER");
 1673
 1674                    b.Property<Guid>("ItemId")
 1675                        .HasColumnType("TEXT");
 1676
 1677                    b.Property<bool>("RememberIndexing")
 1678                        .HasColumnType("INTEGER");
 1679
 1680                    b.Property<bool>("RememberSorting")
 1681                        .HasColumnType("INTEGER");
 1682
 1683                    b.Property<string>("SortBy")
 1684                        .IsRequired()
 1685                        .HasMaxLength(64)
 1686                        .HasColumnType("TEXT");
 1687
 1688                    b.Property<int>("SortOrder")
 1689                        .HasColumnType("INTEGER");
 1690
 1691                    b.Property<Guid>("UserId")
 1692                        .HasColumnType("TEXT");
 1693
 1694                    b.Property<int>("ViewType")
 1695                        .HasColumnType("INTEGER");
 1696
 1697                    b.HasKey("Id");
 1698
 1699                    b.HasIndex("UserId");
 1700
 1701                    b.ToTable("ItemDisplayPreferences");
 1702
 1703                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1704                });
 705
 1706            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 1707                {
 1708                    b.Property<Guid>("ItemValueId")
 1709                        .ValueGeneratedOnAdd()
 1710                        .HasColumnType("TEXT");
 1711
 1712                    b.Property<string>("CleanValue")
 1713                        .IsRequired()
 1714                        .HasColumnType("TEXT");
 1715
 1716                    b.Property<int>("Type")
 1717                        .HasColumnType("INTEGER");
 1718
 1719                    b.Property<string>("Value")
 1720                        .IsRequired()
 1721                        .HasColumnType("TEXT");
 1722
 1723                    b.HasKey("ItemValueId");
 1724
 1725                    b.HasIndex("Type", "CleanValue");
 1726
 1727                    b.HasIndex("Type", "Value")
 1728                        .IsUnique();
 1729
 1730                    b.ToTable("ItemValues");
 1731
 1732                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1733                });
 734
 1735            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 1736                {
 1737                    b.Property<Guid>("ItemValueId")
 1738                        .HasColumnType("TEXT");
 1739
 1740                    b.Property<Guid>("ItemId")
 1741                        .HasColumnType("TEXT");
 1742
 1743                    b.HasKey("ItemValueId", "ItemId");
 1744
 1745                    b.HasIndex("ItemId");
 1746
 1747                    b.ToTable("ItemValuesMap");
 1748
 1749                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1750                });
 751
 1752            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 1753                {
 1754                    b.Property<Guid>("ItemId")
 1755                        .HasColumnType("TEXT");
 1756
 1757                    b.PrimitiveCollection<string>("KeyframeTicks")
 1758                        .HasColumnType("TEXT");
 1759
 1760                    b.Property<long>("TotalDuration")
 1761                        .HasColumnType("INTEGER");
 1762
 1763                    b.HasKey("ItemId");
 1764
 1765                    b.ToTable("KeyframeData");
 1766
 1767                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1768                });
 769
 1770            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaSegment", b =>
 1771                {
 1772                    b.Property<Guid>("Id")
 1773                        .ValueGeneratedOnAdd()
 1774                        .HasColumnType("TEXT");
 1775
 1776                    b.Property<long>("EndTicks")
 1777                        .HasColumnType("INTEGER");
 1778
 1779                    b.Property<Guid>("ItemId")
 1780                        .HasColumnType("TEXT");
 1781
 1782                    b.Property<string>("SegmentProviderId")
 1783                        .IsRequired()
 1784                        .HasColumnType("TEXT");
 1785
 1786                    b.Property<long>("StartTicks")
 1787                        .HasColumnType("INTEGER");
 1788
 1789                    b.Property<int>("Type")
 1790                        .HasColumnType("INTEGER");
 1791
 1792                    b.HasKey("Id");
 1793
 1794                    b.ToTable("MediaSegments");
 1795
 1796                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1797                });
 798
 1799            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 1800                {
 1801                    b.Property<Guid>("ItemId")
 1802                        .HasColumnType("TEXT");
 1803
 1804                    b.Property<int>("StreamIndex")
 1805                        .HasColumnType("INTEGER");
 1806
 1807                    b.Property<string>("AspectRatio")
 1808                        .HasColumnType("TEXT");
 1809
 1810                    b.Property<float?>("AverageFrameRate")
 1811                        .HasColumnType("REAL");
 1812
 1813                    b.Property<int?>("BitDepth")
 1814                        .HasColumnType("INTEGER");
 1815
 1816                    b.Property<int?>("BitRate")
 1817                        .HasColumnType("INTEGER");
 1818
 1819                    b.Property<int?>("BlPresentFlag")
 1820                        .HasColumnType("INTEGER");
 1821
 1822                    b.Property<string>("ChannelLayout")
 1823                        .HasColumnType("TEXT");
 1824
 1825                    b.Property<int?>("Channels")
 1826                        .HasColumnType("INTEGER");
 1827
 1828                    b.Property<string>("Codec")
 1829                        .HasColumnType("TEXT");
 1830
 1831                    b.Property<string>("CodecTag")
 1832                        .HasColumnType("TEXT");
 1833
 1834                    b.Property<string>("CodecTimeBase")
 1835                        .HasColumnType("TEXT");
 1836
 1837                    b.Property<string>("ColorPrimaries")
 1838                        .HasColumnType("TEXT");
 1839
 1840                    b.Property<string>("ColorSpace")
 1841                        .HasColumnType("TEXT");
 1842
 1843                    b.Property<string>("ColorTransfer")
 1844                        .HasColumnType("TEXT");
 1845
 1846                    b.Property<string>("Comment")
 1847                        .HasColumnType("TEXT");
 1848
 1849                    b.Property<int?>("DvBlSignalCompatibilityId")
 1850                        .HasColumnType("INTEGER");
 1851
 1852                    b.Property<int?>("DvLevel")
 1853                        .HasColumnType("INTEGER");
 1854
 1855                    b.Property<int?>("DvProfile")
 1856                        .HasColumnType("INTEGER");
 1857
 1858                    b.Property<int?>("DvVersionMajor")
 1859                        .HasColumnType("INTEGER");
 1860
 1861                    b.Property<int?>("DvVersionMinor")
 1862                        .HasColumnType("INTEGER");
 1863
 1864                    b.Property<int?>("ElPresentFlag")
 1865                        .HasColumnType("INTEGER");
 1866
 1867                    b.Property<bool?>("Hdr10PlusPresentFlag")
 1868                        .HasColumnType("INTEGER");
 1869
 1870                    b.Property<int?>("Height")
 1871                        .HasColumnType("INTEGER");
 1872
 1873                    b.Property<bool?>("IsAnamorphic")
 1874                        .HasColumnType("INTEGER");
 1875
 1876                    b.Property<bool?>("IsAvc")
 1877                        .HasColumnType("INTEGER");
 1878
 1879                    b.Property<bool>("IsDefault")
 1880                        .HasColumnType("INTEGER");
 1881
 1882                    b.Property<bool>("IsExternal")
 1883                        .HasColumnType("INTEGER");
 1884
 1885                    b.Property<bool>("IsForced")
 1886                        .HasColumnType("INTEGER");
 1887
 1888                    b.Property<bool?>("IsHearingImpaired")
 1889                        .HasColumnType("INTEGER");
 1890
 1891                    b.Property<bool?>("IsInterlaced")
 1892                        .HasColumnType("INTEGER");
 1893
 1894                    b.Property<string>("KeyFrames")
 1895                        .HasColumnType("TEXT");
 1896
 1897                    b.Property<string>("Language")
 1898                        .HasColumnType("TEXT");
 1899
 1900                    b.Property<float?>("Level")
 1901                        .HasColumnType("REAL");
 1902
 1903                    b.Property<string>("NalLengthSize")
 1904                        .HasColumnType("TEXT");
 1905
 1906                    b.Property<string>("Path")
 1907                        .HasColumnType("TEXT");
 1908
 1909                    b.Property<string>("PixelFormat")
 1910                        .HasColumnType("TEXT");
 1911
 1912                    b.Property<string>("Profile")
 1913                        .HasColumnType("TEXT");
 1914
 1915                    b.Property<float?>("RealFrameRate")
 1916                        .HasColumnType("REAL");
 1917
 1918                    b.Property<int?>("RefFrames")
 1919                        .HasColumnType("INTEGER");
 1920
 1921                    b.Property<int?>("Rotation")
 1922                        .HasColumnType("INTEGER");
 1923
 1924                    b.Property<int?>("RpuPresentFlag")
 1925                        .HasColumnType("INTEGER");
 1926
 1927                    b.Property<int?>("SampleRate")
 1928                        .HasColumnType("INTEGER");
 1929
 1930                    b.Property<int>("StreamType")
 1931                        .HasColumnType("INTEGER");
 1932
 1933                    b.Property<string>("TimeBase")
 1934                        .HasColumnType("TEXT");
 1935
 1936                    b.Property<string>("Title")
 1937                        .HasColumnType("TEXT");
 1938
 1939                    b.Property<int?>("Width")
 1940                        .HasColumnType("INTEGER");
 1941
 1942                    b.HasKey("ItemId", "StreamIndex");
 1943
 1944                    b.HasIndex("StreamIndex");
 1945
 1946                    b.HasIndex("StreamType");
 1947
 1948                    b.HasIndex("StreamIndex", "StreamType");
 1949
 1950                    b.HasIndex("StreamIndex", "StreamType", "Language");
 1951
 1952                    b.ToTable("MediaStreamInfos");
 1953
 1954                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1955                });
 956
 1957            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 1958                {
 1959                    b.Property<Guid>("Id")
 1960                        .ValueGeneratedOnAdd()
 1961                        .HasColumnType("TEXT");
 1962
 1963                    b.Property<string>("Name")
 1964                        .IsRequired()
 1965                        .HasColumnType("TEXT");
 1966
 1967                    b.Property<string>("PersonType")
 1968                        .HasColumnType("TEXT");
 1969
 1970                    b.HasKey("Id");
 1971
 1972                    b.HasIndex("Name");
 1973
 1974                    b.ToTable("Peoples");
 1975
 1976                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1977                });
 978
 1979            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 1980                {
 1981                    b.Property<Guid>("ItemId")
 1982                        .HasColumnType("TEXT");
 1983
 1984                    b.Property<Guid>("PeopleId")
 1985                        .HasColumnType("TEXT");
 1986
 1987                    b.Property<int?>("ListOrder")
 1988                        .HasColumnType("INTEGER");
 1989
 1990                    b.Property<string>("Role")
 1991                        .HasColumnType("TEXT");
 1992
 1993                    b.Property<int?>("SortOrder")
 1994                        .HasColumnType("INTEGER");
 1995
 1996                    b.HasKey("ItemId", "PeopleId");
 1997
 1998                    b.HasIndex("PeopleId");
 1999
 11000                    b.HasIndex("ItemId", "ListOrder");
 11001
 11002                    b.HasIndex("ItemId", "SortOrder");
 11003
 11004                    b.ToTable("PeopleBaseItemMap");
 11005
 11006                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11007                });
 1008
 11009            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 11010                {
 11011                    b.Property<int>("Id")
 11012                        .ValueGeneratedOnAdd()
 11013                        .HasColumnType("INTEGER");
 11014
 11015                    b.Property<int>("Kind")
 11016                        .HasColumnType("INTEGER");
 11017
 11018                    b.Property<Guid?>("Permission_Permissions_Guid")
 11019                        .HasColumnType("TEXT");
 11020
 11021                    b.Property<uint>("RowVersion")
 11022                        .IsConcurrencyToken()
 11023                        .HasColumnType("INTEGER");
 11024
 11025                    b.Property<Guid?>("UserId")
 11026                        .HasColumnType("TEXT");
 11027
 11028                    b.Property<bool>("Value")
 11029                        .HasColumnType("INTEGER");
 11030
 11031                    b.HasKey("Id");
 11032
 11033                    b.HasIndex("UserId", "Kind")
 11034                        .IsUnique()
 11035                        .HasFilter("[UserId] IS NOT NULL");
 11036
 11037                    b.ToTable("Permissions");
 11038
 11039                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11040                });
 1041
 11042            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 11043                {
 11044                    b.Property<int>("Id")
 11045                        .ValueGeneratedOnAdd()
 11046                        .HasColumnType("INTEGER");
 11047
 11048                    b.Property<int>("Kind")
 11049                        .HasColumnType("INTEGER");
 11050
 11051                    b.Property<Guid?>("Preference_Preferences_Guid")
 11052                        .HasColumnType("TEXT");
 11053
 11054                    b.Property<uint>("RowVersion")
 11055                        .IsConcurrencyToken()
 11056                        .HasColumnType("INTEGER");
 11057
 11058                    b.Property<Guid?>("UserId")
 11059                        .HasColumnType("TEXT");
 11060
 11061                    b.Property<string>("Value")
 11062                        .IsRequired()
 11063                        .HasMaxLength(65535)
 11064                        .HasColumnType("TEXT");
 11065
 11066                    b.HasKey("Id");
 11067
 11068                    b.HasIndex("UserId", "Kind")
 11069                        .IsUnique()
 11070                        .HasFilter("[UserId] IS NOT NULL");
 11071
 11072                    b.ToTable("Preferences");
 11073
 11074                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11075                });
 1076
 11077            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.ApiKey", b =>
 11078                {
 11079                    b.Property<int>("Id")
 11080                        .ValueGeneratedOnAdd()
 11081                        .HasColumnType("INTEGER");
 11082
 11083                    b.Property<string>("AccessToken")
 11084                        .IsRequired()
 11085                        .HasColumnType("TEXT");
 11086
 11087                    b.Property<DateTime>("DateCreated")
 11088                        .HasColumnType("TEXT");
 11089
 11090                    b.Property<DateTime>("DateLastActivity")
 11091                        .HasColumnType("TEXT");
 11092
 11093                    b.Property<string>("Name")
 11094                        .IsRequired()
 11095                        .HasMaxLength(64)
 11096                        .HasColumnType("TEXT");
 11097
 11098                    b.HasKey("Id");
 11099
 11100                    b.HasIndex("AccessToken")
 11101                        .IsUnique();
 11102
 11103                    b.ToTable("ApiKeys");
 11104
 11105                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11106                });
 1107
 11108            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 11109                {
 11110                    b.Property<int>("Id")
 11111                        .ValueGeneratedOnAdd()
 11112                        .HasColumnType("INTEGER");
 11113
 11114                    b.Property<string>("AccessToken")
 11115                        .IsRequired()
 11116                        .HasColumnType("TEXT");
 11117
 11118                    b.Property<string>("AppName")
 11119                        .IsRequired()
 11120                        .HasMaxLength(64)
 11121                        .HasColumnType("TEXT");
 11122
 11123                    b.Property<string>("AppVersion")
 11124                        .IsRequired()
 11125                        .HasMaxLength(32)
 11126                        .HasColumnType("TEXT");
 11127
 11128                    b.Property<DateTime>("DateCreated")
 11129                        .HasColumnType("TEXT");
 11130
 11131                    b.Property<DateTime>("DateLastActivity")
 11132                        .HasColumnType("TEXT");
 11133
 11134                    b.Property<DateTime>("DateModified")
 11135                        .HasColumnType("TEXT");
 11136
 11137                    b.Property<string>("DeviceId")
 11138                        .IsRequired()
 11139                        .HasMaxLength(256)
 11140                        .HasColumnType("TEXT");
 11141
 11142                    b.Property<string>("DeviceName")
 11143                        .IsRequired()
 11144                        .HasMaxLength(64)
 11145                        .HasColumnType("TEXT");
 11146
 11147                    b.Property<bool>("IsActive")
 11148                        .HasColumnType("INTEGER");
 11149
 11150                    b.Property<Guid>("UserId")
 11151                        .HasColumnType("TEXT");
 11152
 11153                    b.HasKey("Id");
 11154
 11155                    b.HasIndex("DeviceId");
 11156
 11157                    b.HasIndex("AccessToken", "DateLastActivity");
 11158
 11159                    b.HasIndex("DeviceId", "DateLastActivity");
 11160
 11161                    b.HasIndex("UserId", "DeviceId");
 11162
 11163                    b.ToTable("Devices");
 11164
 11165                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11166                });
 1167
 11168            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.DeviceOptions", b =>
 11169                {
 11170                    b.Property<int>("Id")
 11171                        .ValueGeneratedOnAdd()
 11172                        .HasColumnType("INTEGER");
 11173
 11174                    b.Property<string>("CustomName")
 11175                        .HasColumnType("TEXT");
 11176
 11177                    b.Property<string>("DeviceId")
 11178                        .IsRequired()
 11179                        .HasColumnType("TEXT");
 11180
 11181                    b.HasKey("Id");
 11182
 11183                    b.HasIndex("DeviceId")
 11184                        .IsUnique();
 11185
 11186                    b.ToTable("DeviceOptions");
 11187
 11188                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11189                });
 1190
 11191            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.TrickplayInfo", b =>
 11192                {
 11193                    b.Property<Guid>("ItemId")
 11194                        .HasColumnType("TEXT");
 11195
 11196                    b.Property<int>("Width")
 11197                        .HasColumnType("INTEGER");
 11198
 11199                    b.Property<int>("Bandwidth")
 11200                        .HasColumnType("INTEGER");
 11201
 11202                    b.Property<int>("Height")
 11203                        .HasColumnType("INTEGER");
 11204
 11205                    b.Property<int>("Interval")
 11206                        .HasColumnType("INTEGER");
 11207
 11208                    b.Property<int>("ThumbnailCount")
 11209                        .HasColumnType("INTEGER");
 11210
 11211                    b.Property<int>("TileHeight")
 11212                        .HasColumnType("INTEGER");
 11213
 11214                    b.Property<int>("TileWidth")
 11215                        .HasColumnType("INTEGER");
 11216
 11217                    b.HasKey("ItemId", "Width");
 11218
 11219                    b.ToTable("TrickplayInfos");
 11220
 11221                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11222                });
 1223
 11224            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 11225                {
 11226                    b.Property<Guid>("Id")
 11227                        .ValueGeneratedOnAdd()
 11228                        .HasColumnType("TEXT");
 11229
 11230                    b.Property<string>("AudioLanguagePreference")
 11231                        .HasMaxLength(255)
 11232                        .HasColumnType("TEXT");
 11233
 11234                    b.Property<string>("AuthenticationProviderId")
 11235                        .IsRequired()
 11236                        .HasMaxLength(255)
 11237                        .HasColumnType("TEXT");
 11238
 11239                    b.Property<string>("CastReceiverId")
 11240                        .HasMaxLength(32)
 11241                        .HasColumnType("TEXT");
 11242
 11243                    b.Property<bool>("DisplayCollectionsView")
 11244                        .HasColumnType("INTEGER");
 11245
 11246                    b.Property<bool>("DisplayMissingEpisodes")
 11247                        .HasColumnType("INTEGER");
 11248
 11249                    b.Property<bool>("EnableAutoLogin")
 11250                        .HasColumnType("INTEGER");
 11251
 11252                    b.Property<bool>("EnableLocalPassword")
 11253                        .HasColumnType("INTEGER");
 11254
 11255                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 11256                        .HasColumnType("INTEGER");
 11257
 11258                    b.Property<bool>("EnableUserPreferenceAccess")
 11259                        .HasColumnType("INTEGER");
 11260
 11261                    b.Property<bool>("HidePlayedInLatest")
 11262                        .HasColumnType("INTEGER");
 11263
 11264                    b.Property<long>("InternalId")
 11265                        .HasColumnType("INTEGER");
 11266
 11267                    b.Property<int>("InvalidLoginAttemptCount")
 11268                        .HasColumnType("INTEGER");
 11269
 11270                    b.Property<DateTime?>("LastActivityDate")
 11271                        .HasColumnType("TEXT");
 11272
 11273                    b.Property<DateTime?>("LastLoginDate")
 11274                        .HasColumnType("TEXT");
 11275
 11276                    b.Property<int?>("LoginAttemptsBeforeLockout")
 11277                        .HasColumnType("INTEGER");
 11278
 11279                    b.Property<int>("MaxActiveSessions")
 11280                        .HasColumnType("INTEGER");
 11281
 11282                    b.Property<int?>("MaxParentalRatingScore")
 11283                        .HasColumnType("INTEGER");
 11284
 11285                    b.Property<int?>("MaxParentalRatingSubScore")
 11286                        .HasColumnType("INTEGER");
 11287
 11288                    b.Property<bool>("MustUpdatePassword")
 11289                        .HasColumnType("INTEGER");
 11290
 11291                    b.Property<string>("Password")
 11292                        .HasMaxLength(65535)
 11293                        .HasColumnType("TEXT");
 11294
 11295                    b.Property<string>("PasswordResetProviderId")
 11296                        .IsRequired()
 11297                        .HasMaxLength(255)
 11298                        .HasColumnType("TEXT");
 11299
 11300                    b.Property<bool>("PlayDefaultAudioTrack")
 11301                        .HasColumnType("INTEGER");
 11302
 11303                    b.Property<bool>("RememberAudioSelections")
 11304                        .HasColumnType("INTEGER");
 11305
 11306                    b.Property<bool>("RememberSubtitleSelections")
 11307                        .HasColumnType("INTEGER");
 11308
 11309                    b.Property<int?>("RemoteClientBitrateLimit")
 11310                        .HasColumnType("INTEGER");
 11311
 11312                    b.Property<uint>("RowVersion")
 11313                        .IsConcurrencyToken()
 11314                        .HasColumnType("INTEGER");
 11315
 11316                    b.Property<string>("SubtitleLanguagePreference")
 11317                        .HasMaxLength(255)
 11318                        .HasColumnType("TEXT");
 11319
 11320                    b.Property<int>("SubtitleMode")
 11321                        .HasColumnType("INTEGER");
 11322
 11323                    b.Property<int>("SyncPlayAccess")
 11324                        .HasColumnType("INTEGER");
 11325
 11326                    b.Property<string>("Username")
 11327                        .IsRequired()
 11328                        .HasMaxLength(255)
 11329                        .HasColumnType("TEXT");
 11330
 11331                    b.HasKey("Id");
 11332
 11333                    b.HasIndex("Username")
 11334                        .IsUnique();
 11335
 11336                    b.ToTable("Users");
 11337
 11338                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11339                });
 1340
 11341            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 11342                {
 11343                    b.Property<Guid>("ItemId")
 11344                        .HasColumnType("TEXT");
 11345
 11346                    b.Property<Guid>("UserId")
 11347                        .HasColumnType("TEXT");
 11348
 11349                    b.Property<string>("CustomDataKey")
 11350                        .HasColumnType("TEXT");
 11351
 11352                    b.Property<int?>("AudioStreamIndex")
 11353                        .HasColumnType("INTEGER");
 11354
 11355                    b.Property<bool>("IsFavorite")
 11356                        .HasColumnType("INTEGER");
 11357
 11358                    b.Property<DateTime?>("LastPlayedDate")
 11359                        .HasColumnType("TEXT");
 11360
 11361                    b.Property<bool?>("Likes")
 11362                        .HasColumnType("INTEGER");
 11363
 11364                    b.Property<int>("PlayCount")
 11365                        .HasColumnType("INTEGER");
 11366
 11367                    b.Property<long>("PlaybackPositionTicks")
 11368                        .HasColumnType("INTEGER");
 11369
 11370                    b.Property<bool>("Played")
 11371                        .HasColumnType("INTEGER");
 11372
 11373                    b.Property<double?>("Rating")
 11374                        .HasColumnType("REAL");
 11375
 11376                    b.Property<int?>("SubtitleStreamIndex")
 11377                        .HasColumnType("INTEGER");
 11378
 11379                    b.HasKey("ItemId", "UserId", "CustomDataKey");
 11380
 11381                    b.HasIndex("UserId");
 11382
 11383                    b.HasIndex("ItemId", "UserId", "IsFavorite");
 11384
 11385                    b.HasIndex("ItemId", "UserId", "LastPlayedDate");
 11386
 11387                    b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks");
 11388
 11389                    b.HasIndex("ItemId", "UserId", "Played");
 11390
 11391                    b.ToTable("UserData");
 11392
 11393                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11394                });
 1395
 11396            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>
 11397                {
 11398                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11399                        .WithMany("AccessSchedules")
 11400                        .HasForeignKey("UserId")
 11401                        .OnDelete(DeleteBehavior.Cascade)
 11402                        .IsRequired();
 11403                });
 1404
 11405            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>
 11406                {
 11407                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11408                        .WithMany("Parents")
 11409                        .HasForeignKey("ItemId")
 11410                        .OnDelete(DeleteBehavior.Cascade)
 11411                        .IsRequired();
 11412
 11413                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "ParentItem")
 11414                        .WithMany("Children")
 11415                        .HasForeignKey("ParentItemId")
 11416                        .OnDelete(DeleteBehavior.Cascade)
 11417                        .IsRequired();
 11418
 11419                    b.Navigation("Item");
 11420
 11421                    b.Navigation("ParentItem");
 11422                });
 1423
 11424            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>
 11425                {
 11426                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11427                        .WithMany()
 11428                        .HasForeignKey("ItemId")
 11429                        .OnDelete(DeleteBehavior.Cascade)
 11430                        .IsRequired();
 11431
 11432                    b.Navigation("Item");
 11433                });
 1434
 11435            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 11436                {
 11437                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11438                        .WithMany("Images")
 11439                        .HasForeignKey("ItemId")
 11440                        .OnDelete(DeleteBehavior.Cascade)
 11441                        .IsRequired();
 11442
 11443                    b.Navigation("Item");
 11444                });
 1445
 11446            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 11447                {
 11448                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11449                        .WithMany("LockedFields")
 11450                        .HasForeignKey("ItemId")
 11451                        .OnDelete(DeleteBehavior.Cascade)
 11452                        .IsRequired();
 11453
 11454                    b.Navigation("Item");
 11455                });
 1456
 11457            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 11458                {
 11459                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11460                        .WithMany("Provider")
 11461                        .HasForeignKey("ItemId")
 11462                        .OnDelete(DeleteBehavior.Cascade)
 11463                        .IsRequired();
 11464
 11465                    b.Navigation("Item");
 11466                });
 1467
 11468            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 11469                {
 11470                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11471                        .WithMany("TrailerTypes")
 11472                        .HasForeignKey("ItemId")
 11473                        .OnDelete(DeleteBehavior.Cascade)
 11474                        .IsRequired();
 11475
 11476                    b.Navigation("Item");
 11477                });
 1478
 11479            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 11480                {
 11481                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11482                        .WithMany("Chapters")
 11483                        .HasForeignKey("ItemId")
 11484                        .OnDelete(DeleteBehavior.Cascade)
 11485                        .IsRequired();
 11486
 11487                    b.Navigation("Item");
 11488                });
 1489
 11490            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 11491                {
 11492                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11493                        .WithMany("DisplayPreferences")
 11494                        .HasForeignKey("UserId")
 11495                        .OnDelete(DeleteBehavior.Cascade)
 11496                        .IsRequired();
 11497                });
 1498
 11499            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 11500                {
 11501                    b.HasOne("Jellyfin.Database.Implementations.Entities.DisplayPreferences", null)
 11502                        .WithMany("HomeSections")
 11503                        .HasForeignKey("DisplayPreferencesId")
 11504                        .OnDelete(DeleteBehavior.Cascade)
 11505                        .IsRequired();
 11506                });
 1507
 11508            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 11509                {
 11510                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11511                        .WithOne("ProfileImage")
 11512                        .HasForeignKey("Jellyfin.Database.Implementations.Entities.ImageInfo", "UserId")
 11513                        .OnDelete(DeleteBehavior.Cascade);
 11514                });
 1515
 11516            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 11517                {
 11518                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11519                        .WithMany("ItemDisplayPreferences")
 11520                        .HasForeignKey("UserId")
 11521                        .OnDelete(DeleteBehavior.Cascade)
 11522                        .IsRequired();
 11523                });
 1524
 11525            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 11526                {
 11527                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11528                        .WithMany("ItemValues")
 11529                        .HasForeignKey("ItemId")
 11530                        .OnDelete(DeleteBehavior.Cascade)
 11531                        .IsRequired();
 11532
 11533                    b.HasOne("Jellyfin.Database.Implementations.Entities.ItemValue", "ItemValue")
 11534                        .WithMany("BaseItemsMap")
 11535                        .HasForeignKey("ItemValueId")
 11536                        .OnDelete(DeleteBehavior.Cascade)
 11537                        .IsRequired();
 11538
 11539                    b.Navigation("Item");
 11540
 11541                    b.Navigation("ItemValue");
 11542                });
 1543
 11544            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 11545                {
 11546                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11547                        .WithMany()
 11548                        .HasForeignKey("ItemId")
 11549                        .OnDelete(DeleteBehavior.Cascade)
 11550                        .IsRequired();
 11551
 11552                    b.Navigation("Item");
 11553                });
 1554
 11555            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 11556                {
 11557                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11558                        .WithMany("MediaStreams")
 11559                        .HasForeignKey("ItemId")
 11560                        .OnDelete(DeleteBehavior.Cascade)
 11561                        .IsRequired();
 11562
 11563                    b.Navigation("Item");
 11564                });
 1565
 11566            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 11567                {
 11568                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11569                        .WithMany("Peoples")
 11570                        .HasForeignKey("ItemId")
 11571                        .OnDelete(DeleteBehavior.Cascade)
 11572                        .IsRequired();
 11573
 11574                    b.HasOne("Jellyfin.Database.Implementations.Entities.People", "People")
 11575                        .WithMany("BaseItems")
 11576                        .HasForeignKey("PeopleId")
 11577                        .OnDelete(DeleteBehavior.Cascade)
 11578                        .IsRequired();
 11579
 11580                    b.Navigation("Item");
 11581
 11582                    b.Navigation("People");
 11583                });
 1584
 11585            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 11586                {
 11587                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11588                        .WithMany("Permissions")
 11589                        .HasForeignKey("UserId")
 11590                        .OnDelete(DeleteBehavior.Cascade);
 11591                });
 1592
 11593            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 11594                {
 11595                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11596                        .WithMany("Preferences")
 11597                        .HasForeignKey("UserId")
 11598                        .OnDelete(DeleteBehavior.Cascade);
 11599                });
 1600
 11601            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 11602                {
 11603                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 11604                        .WithMany()
 11605                        .HasForeignKey("UserId")
 11606                        .OnDelete(DeleteBehavior.Cascade)
 11607                        .IsRequired();
 11608
 11609                    b.Navigation("User");
 11610                });
 1611
 11612            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 11613                {
 11614                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11615                        .WithMany("UserData")
 11616                        .HasForeignKey("ItemId")
 11617                        .OnDelete(DeleteBehavior.Cascade)
 11618                        .IsRequired();
 11619
 11620                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 11621                        .WithMany()
 11622                        .HasForeignKey("UserId")
 11623                        .OnDelete(DeleteBehavior.Cascade)
 11624                        .IsRequired();
 11625
 11626                    b.Navigation("Item");
 11627
 11628                    b.Navigation("User");
 11629                });
 1630
 11631            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 11632                {
 11633                    b.Navigation("Chapters");
 11634
 11635                    b.Navigation("Children");
 11636
 11637                    b.Navigation("Images");
 11638
 11639                    b.Navigation("ItemValues");
 11640
 11641                    b.Navigation("LockedFields");
 11642
 11643                    b.Navigation("MediaStreams");
 11644
 11645                    b.Navigation("Parents");
 11646
 11647                    b.Navigation("Peoples");
 11648
 11649                    b.Navigation("Provider");
 11650
 11651                    b.Navigation("TrailerTypes");
 11652
 11653                    b.Navigation("UserData");
 11654                });
 1655
 11656            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 11657                {
 11658                    b.Navigation("HomeSections");
 11659                });
 1660
 11661            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 11662                {
 11663                    b.Navigation("BaseItemsMap");
 11664                });
 1665
 11666            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 11667                {
 11668                    b.Navigation("BaseItems");
 11669                });
 1670
 11671            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 11672                {
 11673                    b.Navigation("AccessSchedules");
 11674
 11675                    b.Navigation("DisplayPreferences");
 11676
 11677                    b.Navigation("ItemDisplayPreferences");
 11678
 11679                    b.Navigation("Permissions");
 11680
 11681                    b.Navigation("Preferences");
 11682
 11683                    b.Navigation("ProfileImage");
 11684                });
 1685#pragma warning restore 612, 618
 11686        }
 1687    }
 1688}
Generated by: ReportGenerator 5.4.7.0
5/17/2025 - 12:09:40 AM
GitHub | reportgenerator.io

Methods/Properties

BuildModel(Microsoft.EntityFrameworkCore.ModelBuilder)