< 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: 1631
Uncovered lines: 0
Coverable lines: 1631
Total lines: 1706
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.6");
 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
 1396                    b.HasData(
 1397                        new
 1398                        {
 1399                            Id = new Guid("00000000-0000-0000-0000-000000000001"),
 1400                            IsFolder = false,
 1401                            IsInMixedFolder = false,
 1402                            IsLocked = false,
 1403                            IsMovie = false,
 1404                            IsRepeat = false,
 1405                            IsSeries = false,
 1406                            IsVirtualItem = false,
 1407                            Name = "This is a placeholder item for UserData that has been detacted from its original ite
 1408                            Type = "PLACEHOLDER"
 1409                        });
 1410                });
 411
 1412            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 1413                {
 1414                    b.Property<Guid>("Id")
 1415                        .ValueGeneratedOnAdd()
 1416                        .HasColumnType("TEXT");
 1417
 1418                    b.Property<byte[]>("Blurhash")
 1419                        .HasColumnType("BLOB");
 1420
 1421                    b.Property<DateTime?>("DateModified")
 1422                        .HasColumnType("TEXT");
 1423
 1424                    b.Property<int>("Height")
 1425                        .HasColumnType("INTEGER");
 1426
 1427                    b.Property<int>("ImageType")
 1428                        .HasColumnType("INTEGER");
 1429
 1430                    b.Property<Guid>("ItemId")
 1431                        .HasColumnType("TEXT");
 1432
 1433                    b.Property<string>("Path")
 1434                        .IsRequired()
 1435                        .HasColumnType("TEXT");
 1436
 1437                    b.Property<int>("Width")
 1438                        .HasColumnType("INTEGER");
 1439
 1440                    b.HasKey("Id");
 1441
 1442                    b.HasIndex("ItemId");
 1443
 1444                    b.ToTable("BaseItemImageInfos");
 1445
 1446                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1447                });
 448
 1449            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 1450                {
 1451                    b.Property<int>("Id")
 1452                        .HasColumnType("INTEGER");
 1453
 1454                    b.Property<Guid>("ItemId")
 1455                        .HasColumnType("TEXT");
 1456
 1457                    b.HasKey("Id", "ItemId");
 1458
 1459                    b.HasIndex("ItemId");
 1460
 1461                    b.ToTable("BaseItemMetadataFields");
 1462
 1463                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1464                });
 465
 1466            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 1467                {
 1468                    b.Property<Guid>("ItemId")
 1469                        .HasColumnType("TEXT");
 1470
 1471                    b.Property<string>("ProviderId")
 1472                        .HasColumnType("TEXT");
 1473
 1474                    b.Property<string>("ProviderValue")
 1475                        .IsRequired()
 1476                        .HasColumnType("TEXT");
 1477
 1478                    b.HasKey("ItemId", "ProviderId");
 1479
 1480                    b.HasIndex("ProviderId", "ProviderValue", "ItemId");
 1481
 1482                    b.ToTable("BaseItemProviders");
 1483
 1484                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1485                });
 486
 1487            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 1488                {
 1489                    b.Property<int>("Id")
 1490                        .HasColumnType("INTEGER");
 1491
 1492                    b.Property<Guid>("ItemId")
 1493                        .HasColumnType("TEXT");
 1494
 1495                    b.HasKey("Id", "ItemId");
 1496
 1497                    b.HasIndex("ItemId");
 1498
 1499                    b.ToTable("BaseItemTrailerTypes");
 1500
 1501                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1502                });
 503
 1504            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 1505                {
 1506                    b.Property<Guid>("ItemId")
 1507                        .HasColumnType("TEXT");
 1508
 1509                    b.Property<int>("ChapterIndex")
 1510                        .HasColumnType("INTEGER");
 1511
 1512                    b.Property<DateTime?>("ImageDateModified")
 1513                        .HasColumnType("TEXT");
 1514
 1515                    b.Property<string>("ImagePath")
 1516                        .HasColumnType("TEXT");
 1517
 1518                    b.Property<string>("Name")
 1519                        .HasColumnType("TEXT");
 1520
 1521                    b.Property<long>("StartPositionTicks")
 1522                        .HasColumnType("INTEGER");
 1523
 1524                    b.HasKey("ItemId", "ChapterIndex");
 1525
 1526                    b.ToTable("Chapters");
 1527
 1528                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1529                });
 530
 1531            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.CustomItemDisplayPreferences", b =>
 1532                {
 1533                    b.Property<int>("Id")
 1534                        .ValueGeneratedOnAdd()
 1535                        .HasColumnType("INTEGER");
 1536
 1537                    b.Property<string>("Client")
 1538                        .IsRequired()
 1539                        .HasMaxLength(32)
 1540                        .HasColumnType("TEXT");
 1541
 1542                    b.Property<Guid>("ItemId")
 1543                        .HasColumnType("TEXT");
 1544
 1545                    b.Property<string>("Key")
 1546                        .IsRequired()
 1547                        .HasColumnType("TEXT");
 1548
 1549                    b.Property<Guid>("UserId")
 1550                        .HasColumnType("TEXT");
 1551
 1552                    b.Property<string>("Value")
 1553                        .HasColumnType("TEXT");
 1554
 1555                    b.HasKey("Id");
 1556
 1557                    b.HasIndex("UserId", "ItemId", "Client", "Key")
 1558                        .IsUnique();
 1559
 1560                    b.ToTable("CustomItemDisplayPreferences");
 1561
 1562                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1563                });
 564
 1565            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 1566                {
 1567                    b.Property<int>("Id")
 1568                        .ValueGeneratedOnAdd()
 1569                        .HasColumnType("INTEGER");
 1570
 1571                    b.Property<int>("ChromecastVersion")
 1572                        .HasColumnType("INTEGER");
 1573
 1574                    b.Property<string>("Client")
 1575                        .IsRequired()
 1576                        .HasMaxLength(32)
 1577                        .HasColumnType("TEXT");
 1578
 1579                    b.Property<string>("DashboardTheme")
 1580                        .HasMaxLength(32)
 1581                        .HasColumnType("TEXT");
 1582
 1583                    b.Property<bool>("EnableNextVideoInfoOverlay")
 1584                        .HasColumnType("INTEGER");
 1585
 1586                    b.Property<int?>("IndexBy")
 1587                        .HasColumnType("INTEGER");
 1588
 1589                    b.Property<Guid>("ItemId")
 1590                        .HasColumnType("TEXT");
 1591
 1592                    b.Property<int>("ScrollDirection")
 1593                        .HasColumnType("INTEGER");
 1594
 1595                    b.Property<bool>("ShowBackdrop")
 1596                        .HasColumnType("INTEGER");
 1597
 1598                    b.Property<bool>("ShowSidebar")
 1599                        .HasColumnType("INTEGER");
 1600
 1601                    b.Property<int>("SkipBackwardLength")
 1602                        .HasColumnType("INTEGER");
 1603
 1604                    b.Property<int>("SkipForwardLength")
 1605                        .HasColumnType("INTEGER");
 1606
 1607                    b.Property<string>("TvHome")
 1608                        .HasMaxLength(32)
 1609                        .HasColumnType("TEXT");
 1610
 1611                    b.Property<Guid>("UserId")
 1612                        .HasColumnType("TEXT");
 1613
 1614                    b.HasKey("Id");
 1615
 1616                    b.HasIndex("UserId", "ItemId", "Client")
 1617                        .IsUnique();
 1618
 1619                    b.ToTable("DisplayPreferences");
 1620
 1621                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1622                });
 623
 1624            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 1625                {
 1626                    b.Property<int>("Id")
 1627                        .ValueGeneratedOnAdd()
 1628                        .HasColumnType("INTEGER");
 1629
 1630                    b.Property<int>("DisplayPreferencesId")
 1631                        .HasColumnType("INTEGER");
 1632
 1633                    b.Property<int>("Order")
 1634                        .HasColumnType("INTEGER");
 1635
 1636                    b.Property<int>("Type")
 1637                        .HasColumnType("INTEGER");
 1638
 1639                    b.HasKey("Id");
 1640
 1641                    b.HasIndex("DisplayPreferencesId");
 1642
 1643                    b.ToTable("HomeSection");
 1644
 1645                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1646                });
 647
 1648            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 1649                {
 1650                    b.Property<int>("Id")
 1651                        .ValueGeneratedOnAdd()
 1652                        .HasColumnType("INTEGER");
 1653
 1654                    b.Property<DateTime>("LastModified")
 1655                        .HasColumnType("TEXT");
 1656
 1657                    b.Property<string>("Path")
 1658                        .IsRequired()
 1659                        .HasMaxLength(512)
 1660                        .HasColumnType("TEXT");
 1661
 1662                    b.Property<Guid?>("UserId")
 1663                        .HasColumnType("TEXT");
 1664
 1665                    b.HasKey("Id");
 1666
 1667                    b.HasIndex("UserId")
 1668                        .IsUnique();
 1669
 1670                    b.ToTable("ImageInfos");
 1671
 1672                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1673                });
 674
 1675            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 1676                {
 1677                    b.Property<int>("Id")
 1678                        .ValueGeneratedOnAdd()
 1679                        .HasColumnType("INTEGER");
 1680
 1681                    b.Property<string>("Client")
 1682                        .IsRequired()
 1683                        .HasMaxLength(32)
 1684                        .HasColumnType("TEXT");
 1685
 1686                    b.Property<int?>("IndexBy")
 1687                        .HasColumnType("INTEGER");
 1688
 1689                    b.Property<Guid>("ItemId")
 1690                        .HasColumnType("TEXT");
 1691
 1692                    b.Property<bool>("RememberIndexing")
 1693                        .HasColumnType("INTEGER");
 1694
 1695                    b.Property<bool>("RememberSorting")
 1696                        .HasColumnType("INTEGER");
 1697
 1698                    b.Property<string>("SortBy")
 1699                        .IsRequired()
 1700                        .HasMaxLength(64)
 1701                        .HasColumnType("TEXT");
 1702
 1703                    b.Property<int>("SortOrder")
 1704                        .HasColumnType("INTEGER");
 1705
 1706                    b.Property<Guid>("UserId")
 1707                        .HasColumnType("TEXT");
 1708
 1709                    b.Property<int>("ViewType")
 1710                        .HasColumnType("INTEGER");
 1711
 1712                    b.HasKey("Id");
 1713
 1714                    b.HasIndex("UserId");
 1715
 1716                    b.ToTable("ItemDisplayPreferences");
 1717
 1718                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1719                });
 720
 1721            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 1722                {
 1723                    b.Property<Guid>("ItemValueId")
 1724                        .ValueGeneratedOnAdd()
 1725                        .HasColumnType("TEXT");
 1726
 1727                    b.Property<string>("CleanValue")
 1728                        .IsRequired()
 1729                        .HasColumnType("TEXT");
 1730
 1731                    b.Property<int>("Type")
 1732                        .HasColumnType("INTEGER");
 1733
 1734                    b.Property<string>("Value")
 1735                        .IsRequired()
 1736                        .HasColumnType("TEXT");
 1737
 1738                    b.HasKey("ItemValueId");
 1739
 1740                    b.HasIndex("Type", "CleanValue");
 1741
 1742                    b.HasIndex("Type", "Value")
 1743                        .IsUnique();
 1744
 1745                    b.ToTable("ItemValues");
 1746
 1747                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1748                });
 749
 1750            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 1751                {
 1752                    b.Property<Guid>("ItemValueId")
 1753                        .HasColumnType("TEXT");
 1754
 1755                    b.Property<Guid>("ItemId")
 1756                        .HasColumnType("TEXT");
 1757
 1758                    b.HasKey("ItemValueId", "ItemId");
 1759
 1760                    b.HasIndex("ItemId");
 1761
 1762                    b.ToTable("ItemValuesMap");
 1763
 1764                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1765                });
 766
 1767            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 1768                {
 1769                    b.Property<Guid>("ItemId")
 1770                        .HasColumnType("TEXT");
 1771
 1772                    b.PrimitiveCollection<string>("KeyframeTicks")
 1773                        .HasColumnType("TEXT");
 1774
 1775                    b.Property<long>("TotalDuration")
 1776                        .HasColumnType("INTEGER");
 1777
 1778                    b.HasKey("ItemId");
 1779
 1780                    b.ToTable("KeyframeData");
 1781
 1782                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1783                });
 784
 1785            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaSegment", b =>
 1786                {
 1787                    b.Property<Guid>("Id")
 1788                        .ValueGeneratedOnAdd()
 1789                        .HasColumnType("TEXT");
 1790
 1791                    b.Property<long>("EndTicks")
 1792                        .HasColumnType("INTEGER");
 1793
 1794                    b.Property<Guid>("ItemId")
 1795                        .HasColumnType("TEXT");
 1796
 1797                    b.Property<string>("SegmentProviderId")
 1798                        .IsRequired()
 1799                        .HasColumnType("TEXT");
 1800
 1801                    b.Property<long>("StartTicks")
 1802                        .HasColumnType("INTEGER");
 1803
 1804                    b.Property<int>("Type")
 1805                        .HasColumnType("INTEGER");
 1806
 1807                    b.HasKey("Id");
 1808
 1809                    b.ToTable("MediaSegments");
 1810
 1811                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1812                });
 813
 1814            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 1815                {
 1816                    b.Property<Guid>("ItemId")
 1817                        .HasColumnType("TEXT");
 1818
 1819                    b.Property<int>("StreamIndex")
 1820                        .HasColumnType("INTEGER");
 1821
 1822                    b.Property<string>("AspectRatio")
 1823                        .HasColumnType("TEXT");
 1824
 1825                    b.Property<float?>("AverageFrameRate")
 1826                        .HasColumnType("REAL");
 1827
 1828                    b.Property<int?>("BitDepth")
 1829                        .HasColumnType("INTEGER");
 1830
 1831                    b.Property<int?>("BitRate")
 1832                        .HasColumnType("INTEGER");
 1833
 1834                    b.Property<int?>("BlPresentFlag")
 1835                        .HasColumnType("INTEGER");
 1836
 1837                    b.Property<string>("ChannelLayout")
 1838                        .HasColumnType("TEXT");
 1839
 1840                    b.Property<int?>("Channels")
 1841                        .HasColumnType("INTEGER");
 1842
 1843                    b.Property<string>("Codec")
 1844                        .HasColumnType("TEXT");
 1845
 1846                    b.Property<string>("CodecTag")
 1847                        .HasColumnType("TEXT");
 1848
 1849                    b.Property<string>("CodecTimeBase")
 1850                        .HasColumnType("TEXT");
 1851
 1852                    b.Property<string>("ColorPrimaries")
 1853                        .HasColumnType("TEXT");
 1854
 1855                    b.Property<string>("ColorSpace")
 1856                        .HasColumnType("TEXT");
 1857
 1858                    b.Property<string>("ColorTransfer")
 1859                        .HasColumnType("TEXT");
 1860
 1861                    b.Property<string>("Comment")
 1862                        .HasColumnType("TEXT");
 1863
 1864                    b.Property<int?>("DvBlSignalCompatibilityId")
 1865                        .HasColumnType("INTEGER");
 1866
 1867                    b.Property<int?>("DvLevel")
 1868                        .HasColumnType("INTEGER");
 1869
 1870                    b.Property<int?>("DvProfile")
 1871                        .HasColumnType("INTEGER");
 1872
 1873                    b.Property<int?>("DvVersionMajor")
 1874                        .HasColumnType("INTEGER");
 1875
 1876                    b.Property<int?>("DvVersionMinor")
 1877                        .HasColumnType("INTEGER");
 1878
 1879                    b.Property<int?>("ElPresentFlag")
 1880                        .HasColumnType("INTEGER");
 1881
 1882                    b.Property<bool?>("Hdr10PlusPresentFlag")
 1883                        .HasColumnType("INTEGER");
 1884
 1885                    b.Property<int?>("Height")
 1886                        .HasColumnType("INTEGER");
 1887
 1888                    b.Property<bool?>("IsAnamorphic")
 1889                        .HasColumnType("INTEGER");
 1890
 1891                    b.Property<bool?>("IsAvc")
 1892                        .HasColumnType("INTEGER");
 1893
 1894                    b.Property<bool>("IsDefault")
 1895                        .HasColumnType("INTEGER");
 1896
 1897                    b.Property<bool>("IsExternal")
 1898                        .HasColumnType("INTEGER");
 1899
 1900                    b.Property<bool>("IsForced")
 1901                        .HasColumnType("INTEGER");
 1902
 1903                    b.Property<bool?>("IsHearingImpaired")
 1904                        .HasColumnType("INTEGER");
 1905
 1906                    b.Property<bool?>("IsInterlaced")
 1907                        .HasColumnType("INTEGER");
 1908
 1909                    b.Property<string>("KeyFrames")
 1910                        .HasColumnType("TEXT");
 1911
 1912                    b.Property<string>("Language")
 1913                        .HasColumnType("TEXT");
 1914
 1915                    b.Property<float?>("Level")
 1916                        .HasColumnType("REAL");
 1917
 1918                    b.Property<string>("NalLengthSize")
 1919                        .HasColumnType("TEXT");
 1920
 1921                    b.Property<string>("Path")
 1922                        .HasColumnType("TEXT");
 1923
 1924                    b.Property<string>("PixelFormat")
 1925                        .HasColumnType("TEXT");
 1926
 1927                    b.Property<string>("Profile")
 1928                        .HasColumnType("TEXT");
 1929
 1930                    b.Property<float?>("RealFrameRate")
 1931                        .HasColumnType("REAL");
 1932
 1933                    b.Property<int?>("RefFrames")
 1934                        .HasColumnType("INTEGER");
 1935
 1936                    b.Property<int?>("Rotation")
 1937                        .HasColumnType("INTEGER");
 1938
 1939                    b.Property<int?>("RpuPresentFlag")
 1940                        .HasColumnType("INTEGER");
 1941
 1942                    b.Property<int?>("SampleRate")
 1943                        .HasColumnType("INTEGER");
 1944
 1945                    b.Property<int>("StreamType")
 1946                        .HasColumnType("INTEGER");
 1947
 1948                    b.Property<string>("TimeBase")
 1949                        .HasColumnType("TEXT");
 1950
 1951                    b.Property<string>("Title")
 1952                        .HasColumnType("TEXT");
 1953
 1954                    b.Property<int?>("Width")
 1955                        .HasColumnType("INTEGER");
 1956
 1957                    b.HasKey("ItemId", "StreamIndex");
 1958
 1959                    b.HasIndex("StreamIndex");
 1960
 1961                    b.HasIndex("StreamType");
 1962
 1963                    b.HasIndex("StreamIndex", "StreamType");
 1964
 1965                    b.HasIndex("StreamIndex", "StreamType", "Language");
 1966
 1967                    b.ToTable("MediaStreamInfos");
 1968
 1969                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1970                });
 971
 1972            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 1973                {
 1974                    b.Property<Guid>("Id")
 1975                        .ValueGeneratedOnAdd()
 1976                        .HasColumnType("TEXT");
 1977
 1978                    b.Property<string>("Name")
 1979                        .IsRequired()
 1980                        .HasColumnType("TEXT");
 1981
 1982                    b.Property<string>("PersonType")
 1983                        .HasColumnType("TEXT");
 1984
 1985                    b.HasKey("Id");
 1986
 1987                    b.HasIndex("Name");
 1988
 1989                    b.ToTable("Peoples");
 1990
 1991                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 1992                });
 993
 1994            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 1995                {
 1996                    b.Property<Guid>("ItemId")
 1997                        .HasColumnType("TEXT");
 1998
 1999                    b.Property<Guid>("PeopleId")
 11000                        .HasColumnType("TEXT");
 11001
 11002                    b.Property<int?>("ListOrder")
 11003                        .HasColumnType("INTEGER");
 11004
 11005                    b.Property<string>("Role")
 11006                        .HasColumnType("TEXT");
 11007
 11008                    b.Property<int?>("SortOrder")
 11009                        .HasColumnType("INTEGER");
 11010
 11011                    b.HasKey("ItemId", "PeopleId");
 11012
 11013                    b.HasIndex("PeopleId");
 11014
 11015                    b.HasIndex("ItemId", "ListOrder");
 11016
 11017                    b.HasIndex("ItemId", "SortOrder");
 11018
 11019                    b.ToTable("PeopleBaseItemMap");
 11020
 11021                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11022                });
 1023
 11024            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 11025                {
 11026                    b.Property<int>("Id")
 11027                        .ValueGeneratedOnAdd()
 11028                        .HasColumnType("INTEGER");
 11029
 11030                    b.Property<int>("Kind")
 11031                        .HasColumnType("INTEGER");
 11032
 11033                    b.Property<Guid?>("Permission_Permissions_Guid")
 11034                        .HasColumnType("TEXT");
 11035
 11036                    b.Property<uint>("RowVersion")
 11037                        .IsConcurrencyToken()
 11038                        .HasColumnType("INTEGER");
 11039
 11040                    b.Property<Guid?>("UserId")
 11041                        .HasColumnType("TEXT");
 11042
 11043                    b.Property<bool>("Value")
 11044                        .HasColumnType("INTEGER");
 11045
 11046                    b.HasKey("Id");
 11047
 11048                    b.HasIndex("UserId", "Kind")
 11049                        .IsUnique()
 11050                        .HasFilter("[UserId] IS NOT NULL");
 11051
 11052                    b.ToTable("Permissions");
 11053
 11054                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11055                });
 1056
 11057            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 11058                {
 11059                    b.Property<int>("Id")
 11060                        .ValueGeneratedOnAdd()
 11061                        .HasColumnType("INTEGER");
 11062
 11063                    b.Property<int>("Kind")
 11064                        .HasColumnType("INTEGER");
 11065
 11066                    b.Property<Guid?>("Preference_Preferences_Guid")
 11067                        .HasColumnType("TEXT");
 11068
 11069                    b.Property<uint>("RowVersion")
 11070                        .IsConcurrencyToken()
 11071                        .HasColumnType("INTEGER");
 11072
 11073                    b.Property<Guid?>("UserId")
 11074                        .HasColumnType("TEXT");
 11075
 11076                    b.Property<string>("Value")
 11077                        .IsRequired()
 11078                        .HasMaxLength(65535)
 11079                        .HasColumnType("TEXT");
 11080
 11081                    b.HasKey("Id");
 11082
 11083                    b.HasIndex("UserId", "Kind")
 11084                        .IsUnique()
 11085                        .HasFilter("[UserId] IS NOT NULL");
 11086
 11087                    b.ToTable("Preferences");
 11088
 11089                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11090                });
 1091
 11092            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.ApiKey", b =>
 11093                {
 11094                    b.Property<int>("Id")
 11095                        .ValueGeneratedOnAdd()
 11096                        .HasColumnType("INTEGER");
 11097
 11098                    b.Property<string>("AccessToken")
 11099                        .IsRequired()
 11100                        .HasColumnType("TEXT");
 11101
 11102                    b.Property<DateTime>("DateCreated")
 11103                        .HasColumnType("TEXT");
 11104
 11105                    b.Property<DateTime>("DateLastActivity")
 11106                        .HasColumnType("TEXT");
 11107
 11108                    b.Property<string>("Name")
 11109                        .IsRequired()
 11110                        .HasMaxLength(64)
 11111                        .HasColumnType("TEXT");
 11112
 11113                    b.HasKey("Id");
 11114
 11115                    b.HasIndex("AccessToken")
 11116                        .IsUnique();
 11117
 11118                    b.ToTable("ApiKeys");
 11119
 11120                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11121                });
 1122
 11123            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 11124                {
 11125                    b.Property<int>("Id")
 11126                        .ValueGeneratedOnAdd()
 11127                        .HasColumnType("INTEGER");
 11128
 11129                    b.Property<string>("AccessToken")
 11130                        .IsRequired()
 11131                        .HasColumnType("TEXT");
 11132
 11133                    b.Property<string>("AppName")
 11134                        .IsRequired()
 11135                        .HasMaxLength(64)
 11136                        .HasColumnType("TEXT");
 11137
 11138                    b.Property<string>("AppVersion")
 11139                        .IsRequired()
 11140                        .HasMaxLength(32)
 11141                        .HasColumnType("TEXT");
 11142
 11143                    b.Property<DateTime>("DateCreated")
 11144                        .HasColumnType("TEXT");
 11145
 11146                    b.Property<DateTime>("DateLastActivity")
 11147                        .HasColumnType("TEXT");
 11148
 11149                    b.Property<DateTime>("DateModified")
 11150                        .HasColumnType("TEXT");
 11151
 11152                    b.Property<string>("DeviceId")
 11153                        .IsRequired()
 11154                        .HasMaxLength(256)
 11155                        .HasColumnType("TEXT");
 11156
 11157                    b.Property<string>("DeviceName")
 11158                        .IsRequired()
 11159                        .HasMaxLength(64)
 11160                        .HasColumnType("TEXT");
 11161
 11162                    b.Property<bool>("IsActive")
 11163                        .HasColumnType("INTEGER");
 11164
 11165                    b.Property<Guid>("UserId")
 11166                        .HasColumnType("TEXT");
 11167
 11168                    b.HasKey("Id");
 11169
 11170                    b.HasIndex("DeviceId");
 11171
 11172                    b.HasIndex("AccessToken", "DateLastActivity");
 11173
 11174                    b.HasIndex("DeviceId", "DateLastActivity");
 11175
 11176                    b.HasIndex("UserId", "DeviceId");
 11177
 11178                    b.ToTable("Devices");
 11179
 11180                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11181                });
 1182
 11183            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.DeviceOptions", b =>
 11184                {
 11185                    b.Property<int>("Id")
 11186                        .ValueGeneratedOnAdd()
 11187                        .HasColumnType("INTEGER");
 11188
 11189                    b.Property<string>("CustomName")
 11190                        .HasColumnType("TEXT");
 11191
 11192                    b.Property<string>("DeviceId")
 11193                        .IsRequired()
 11194                        .HasColumnType("TEXT");
 11195
 11196                    b.HasKey("Id");
 11197
 11198                    b.HasIndex("DeviceId")
 11199                        .IsUnique();
 11200
 11201                    b.ToTable("DeviceOptions");
 11202
 11203                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11204                });
 1205
 11206            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.TrickplayInfo", b =>
 11207                {
 11208                    b.Property<Guid>("ItemId")
 11209                        .HasColumnType("TEXT");
 11210
 11211                    b.Property<int>("Width")
 11212                        .HasColumnType("INTEGER");
 11213
 11214                    b.Property<int>("Bandwidth")
 11215                        .HasColumnType("INTEGER");
 11216
 11217                    b.Property<int>("Height")
 11218                        .HasColumnType("INTEGER");
 11219
 11220                    b.Property<int>("Interval")
 11221                        .HasColumnType("INTEGER");
 11222
 11223                    b.Property<int>("ThumbnailCount")
 11224                        .HasColumnType("INTEGER");
 11225
 11226                    b.Property<int>("TileHeight")
 11227                        .HasColumnType("INTEGER");
 11228
 11229                    b.Property<int>("TileWidth")
 11230                        .HasColumnType("INTEGER");
 11231
 11232                    b.HasKey("ItemId", "Width");
 11233
 11234                    b.ToTable("TrickplayInfos");
 11235
 11236                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11237                });
 1238
 11239            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 11240                {
 11241                    b.Property<Guid>("Id")
 11242                        .ValueGeneratedOnAdd()
 11243                        .HasColumnType("TEXT");
 11244
 11245                    b.Property<string>("AudioLanguagePreference")
 11246                        .HasMaxLength(255)
 11247                        .HasColumnType("TEXT");
 11248
 11249                    b.Property<string>("AuthenticationProviderId")
 11250                        .IsRequired()
 11251                        .HasMaxLength(255)
 11252                        .HasColumnType("TEXT");
 11253
 11254                    b.Property<string>("CastReceiverId")
 11255                        .HasMaxLength(32)
 11256                        .HasColumnType("TEXT");
 11257
 11258                    b.Property<bool>("DisplayCollectionsView")
 11259                        .HasColumnType("INTEGER");
 11260
 11261                    b.Property<bool>("DisplayMissingEpisodes")
 11262                        .HasColumnType("INTEGER");
 11263
 11264                    b.Property<bool>("EnableAutoLogin")
 11265                        .HasColumnType("INTEGER");
 11266
 11267                    b.Property<bool>("EnableLocalPassword")
 11268                        .HasColumnType("INTEGER");
 11269
 11270                    b.Property<bool>("EnableNextEpisodeAutoPlay")
 11271                        .HasColumnType("INTEGER");
 11272
 11273                    b.Property<bool>("EnableUserPreferenceAccess")
 11274                        .HasColumnType("INTEGER");
 11275
 11276                    b.Property<bool>("HidePlayedInLatest")
 11277                        .HasColumnType("INTEGER");
 11278
 11279                    b.Property<long>("InternalId")
 11280                        .HasColumnType("INTEGER");
 11281
 11282                    b.Property<int>("InvalidLoginAttemptCount")
 11283                        .HasColumnType("INTEGER");
 11284
 11285                    b.Property<DateTime?>("LastActivityDate")
 11286                        .HasColumnType("TEXT");
 11287
 11288                    b.Property<DateTime?>("LastLoginDate")
 11289                        .HasColumnType("TEXT");
 11290
 11291                    b.Property<int?>("LoginAttemptsBeforeLockout")
 11292                        .HasColumnType("INTEGER");
 11293
 11294                    b.Property<int>("MaxActiveSessions")
 11295                        .HasColumnType("INTEGER");
 11296
 11297                    b.Property<int?>("MaxParentalRatingScore")
 11298                        .HasColumnType("INTEGER");
 11299
 11300                    b.Property<int?>("MaxParentalRatingSubScore")
 11301                        .HasColumnType("INTEGER");
 11302
 11303                    b.Property<bool>("MustUpdatePassword")
 11304                        .HasColumnType("INTEGER");
 11305
 11306                    b.Property<string>("Password")
 11307                        .HasMaxLength(65535)
 11308                        .HasColumnType("TEXT");
 11309
 11310                    b.Property<string>("PasswordResetProviderId")
 11311                        .IsRequired()
 11312                        .HasMaxLength(255)
 11313                        .HasColumnType("TEXT");
 11314
 11315                    b.Property<bool>("PlayDefaultAudioTrack")
 11316                        .HasColumnType("INTEGER");
 11317
 11318                    b.Property<bool>("RememberAudioSelections")
 11319                        .HasColumnType("INTEGER");
 11320
 11321                    b.Property<bool>("RememberSubtitleSelections")
 11322                        .HasColumnType("INTEGER");
 11323
 11324                    b.Property<int?>("RemoteClientBitrateLimit")
 11325                        .HasColumnType("INTEGER");
 11326
 11327                    b.Property<uint>("RowVersion")
 11328                        .IsConcurrencyToken()
 11329                        .HasColumnType("INTEGER");
 11330
 11331                    b.Property<string>("SubtitleLanguagePreference")
 11332                        .HasMaxLength(255)
 11333                        .HasColumnType("TEXT");
 11334
 11335                    b.Property<int>("SubtitleMode")
 11336                        .HasColumnType("INTEGER");
 11337
 11338                    b.Property<int>("SyncPlayAccess")
 11339                        .HasColumnType("INTEGER");
 11340
 11341                    b.Property<string>("Username")
 11342                        .IsRequired()
 11343                        .HasMaxLength(255)
 11344                        .HasColumnType("TEXT");
 11345
 11346                    b.HasKey("Id");
 11347
 11348                    b.HasIndex("Username")
 11349                        .IsUnique();
 11350
 11351                    b.ToTable("Users");
 11352
 11353                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11354                });
 1355
 11356            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 11357                {
 11358                    b.Property<Guid>("ItemId")
 11359                        .HasColumnType("TEXT");
 11360
 11361                    b.Property<Guid>("UserId")
 11362                        .HasColumnType("TEXT");
 11363
 11364                    b.Property<string>("CustomDataKey")
 11365                        .HasColumnType("TEXT");
 11366
 11367                    b.Property<int?>("AudioStreamIndex")
 11368                        .HasColumnType("INTEGER");
 11369
 11370                    b.Property<bool>("IsFavorite")
 11371                        .HasColumnType("INTEGER");
 11372
 11373                    b.Property<DateTime?>("LastPlayedDate")
 11374                        .HasColumnType("TEXT");
 11375
 11376                    b.Property<bool?>("Likes")
 11377                        .HasColumnType("INTEGER");
 11378
 11379                    b.Property<int>("PlayCount")
 11380                        .HasColumnType("INTEGER");
 11381
 11382                    b.Property<long>("PlaybackPositionTicks")
 11383                        .HasColumnType("INTEGER");
 11384
 11385                    b.Property<bool>("Played")
 11386                        .HasColumnType("INTEGER");
 11387
 11388                    b.Property<double?>("Rating")
 11389                        .HasColumnType("REAL");
 11390
 11391                    b.Property<DateTime?>("RetentionDate")
 11392                        .HasColumnType("TEXT");
 11393
 11394                    b.Property<int?>("SubtitleStreamIndex")
 11395                        .HasColumnType("INTEGER");
 11396
 11397                    b.HasKey("ItemId", "UserId", "CustomDataKey");
 11398
 11399                    b.HasIndex("UserId");
 11400
 11401                    b.HasIndex("ItemId", "UserId", "IsFavorite");
 11402
 11403                    b.HasIndex("ItemId", "UserId", "LastPlayedDate");
 11404
 11405                    b.HasIndex("ItemId", "UserId", "PlaybackPositionTicks");
 11406
 11407                    b.HasIndex("ItemId", "UserId", "Played");
 11408
 11409                    b.ToTable("UserData");
 11410
 11411                    b.HasAnnotation("Sqlite:UseSqlReturningClause", false);
 11412                });
 1413
 11414            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AccessSchedule", b =>
 11415                {
 11416                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11417                        .WithMany("AccessSchedules")
 11418                        .HasForeignKey("UserId")
 11419                        .OnDelete(DeleteBehavior.Cascade)
 11420                        .IsRequired();
 11421                });
 1422
 11423            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AncestorId", b =>
 11424                {
 11425                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11426                        .WithMany("Parents")
 11427                        .HasForeignKey("ItemId")
 11428                        .OnDelete(DeleteBehavior.Cascade)
 11429                        .IsRequired();
 11430
 11431                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "ParentItem")
 11432                        .WithMany("Children")
 11433                        .HasForeignKey("ParentItemId")
 11434                        .OnDelete(DeleteBehavior.Cascade)
 11435                        .IsRequired();
 11436
 11437                    b.Navigation("Item");
 11438
 11439                    b.Navigation("ParentItem");
 11440                });
 1441
 11442            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.AttachmentStreamInfo", b =>
 11443                {
 11444                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11445                        .WithMany()
 11446                        .HasForeignKey("ItemId")
 11447                        .OnDelete(DeleteBehavior.Cascade)
 11448                        .IsRequired();
 11449
 11450                    b.Navigation("Item");
 11451                });
 1452
 11453            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemImageInfo", b =>
 11454                {
 11455                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11456                        .WithMany("Images")
 11457                        .HasForeignKey("ItemId")
 11458                        .OnDelete(DeleteBehavior.Cascade)
 11459                        .IsRequired();
 11460
 11461                    b.Navigation("Item");
 11462                });
 1463
 11464            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemMetadataField", b =>
 11465                {
 11466                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11467                        .WithMany("LockedFields")
 11468                        .HasForeignKey("ItemId")
 11469                        .OnDelete(DeleteBehavior.Cascade)
 11470                        .IsRequired();
 11471
 11472                    b.Navigation("Item");
 11473                });
 1474
 11475            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemProvider", b =>
 11476                {
 11477                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11478                        .WithMany("Provider")
 11479                        .HasForeignKey("ItemId")
 11480                        .OnDelete(DeleteBehavior.Cascade)
 11481                        .IsRequired();
 11482
 11483                    b.Navigation("Item");
 11484                });
 1485
 11486            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemTrailerType", b =>
 11487                {
 11488                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11489                        .WithMany("TrailerTypes")
 11490                        .HasForeignKey("ItemId")
 11491                        .OnDelete(DeleteBehavior.Cascade)
 11492                        .IsRequired();
 11493
 11494                    b.Navigation("Item");
 11495                });
 1496
 11497            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Chapter", b =>
 11498                {
 11499                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11500                        .WithMany("Chapters")
 11501                        .HasForeignKey("ItemId")
 11502                        .OnDelete(DeleteBehavior.Cascade)
 11503                        .IsRequired();
 11504
 11505                    b.Navigation("Item");
 11506                });
 1507
 11508            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 11509                {
 11510                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11511                        .WithMany("DisplayPreferences")
 11512                        .HasForeignKey("UserId")
 11513                        .OnDelete(DeleteBehavior.Cascade)
 11514                        .IsRequired();
 11515                });
 1516
 11517            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.HomeSection", b =>
 11518                {
 11519                    b.HasOne("Jellyfin.Database.Implementations.Entities.DisplayPreferences", null)
 11520                        .WithMany("HomeSections")
 11521                        .HasForeignKey("DisplayPreferencesId")
 11522                        .OnDelete(DeleteBehavior.Cascade)
 11523                        .IsRequired();
 11524                });
 1525
 11526            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ImageInfo", b =>
 11527                {
 11528                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11529                        .WithOne("ProfileImage")
 11530                        .HasForeignKey("Jellyfin.Database.Implementations.Entities.ImageInfo", "UserId")
 11531                        .OnDelete(DeleteBehavior.Cascade);
 11532                });
 1533
 11534            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemDisplayPreferences", b =>
 11535                {
 11536                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11537                        .WithMany("ItemDisplayPreferences")
 11538                        .HasForeignKey("UserId")
 11539                        .OnDelete(DeleteBehavior.Cascade)
 11540                        .IsRequired();
 11541                });
 1542
 11543            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValueMap", b =>
 11544                {
 11545                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11546                        .WithMany("ItemValues")
 11547                        .HasForeignKey("ItemId")
 11548                        .OnDelete(DeleteBehavior.Cascade)
 11549                        .IsRequired();
 11550
 11551                    b.HasOne("Jellyfin.Database.Implementations.Entities.ItemValue", "ItemValue")
 11552                        .WithMany("BaseItemsMap")
 11553                        .HasForeignKey("ItemValueId")
 11554                        .OnDelete(DeleteBehavior.Cascade)
 11555                        .IsRequired();
 11556
 11557                    b.Navigation("Item");
 11558
 11559                    b.Navigation("ItemValue");
 11560                });
 1561
 11562            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.KeyframeData", b =>
 11563                {
 11564                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11565                        .WithMany()
 11566                        .HasForeignKey("ItemId")
 11567                        .OnDelete(DeleteBehavior.Cascade)
 11568                        .IsRequired();
 11569
 11570                    b.Navigation("Item");
 11571                });
 1572
 11573            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.MediaStreamInfo", b =>
 11574                {
 11575                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11576                        .WithMany("MediaStreams")
 11577                        .HasForeignKey("ItemId")
 11578                        .OnDelete(DeleteBehavior.Cascade)
 11579                        .IsRequired();
 11580
 11581                    b.Navigation("Item");
 11582                });
 1583
 11584            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.PeopleBaseItemMap", b =>
 11585                {
 11586                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11587                        .WithMany("Peoples")
 11588                        .HasForeignKey("ItemId")
 11589                        .OnDelete(DeleteBehavior.Cascade)
 11590                        .IsRequired();
 11591
 11592                    b.HasOne("Jellyfin.Database.Implementations.Entities.People", "People")
 11593                        .WithMany("BaseItems")
 11594                        .HasForeignKey("PeopleId")
 11595                        .OnDelete(DeleteBehavior.Cascade)
 11596                        .IsRequired();
 11597
 11598                    b.Navigation("Item");
 11599
 11600                    b.Navigation("People");
 11601                });
 1602
 11603            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Permission", b =>
 11604                {
 11605                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11606                        .WithMany("Permissions")
 11607                        .HasForeignKey("UserId")
 11608                        .OnDelete(DeleteBehavior.Cascade);
 11609                });
 1610
 11611            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Preference", b =>
 11612                {
 11613                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", null)
 11614                        .WithMany("Preferences")
 11615                        .HasForeignKey("UserId")
 11616                        .OnDelete(DeleteBehavior.Cascade);
 11617                });
 1618
 11619            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.Security.Device", b =>
 11620                {
 11621                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 11622                        .WithMany()
 11623                        .HasForeignKey("UserId")
 11624                        .OnDelete(DeleteBehavior.Cascade)
 11625                        .IsRequired();
 11626
 11627                    b.Navigation("User");
 11628                });
 1629
 11630            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.UserData", b =>
 11631                {
 11632                    b.HasOne("Jellyfin.Database.Implementations.Entities.BaseItemEntity", "Item")
 11633                        .WithMany("UserData")
 11634                        .HasForeignKey("ItemId")
 11635                        .OnDelete(DeleteBehavior.Cascade)
 11636                        .IsRequired();
 11637
 11638                    b.HasOne("Jellyfin.Database.Implementations.Entities.User", "User")
 11639                        .WithMany()
 11640                        .HasForeignKey("UserId")
 11641                        .OnDelete(DeleteBehavior.Cascade)
 11642                        .IsRequired();
 11643
 11644                    b.Navigation("Item");
 11645
 11646                    b.Navigation("User");
 11647                });
 1648
 11649            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.BaseItemEntity", b =>
 11650                {
 11651                    b.Navigation("Chapters");
 11652
 11653                    b.Navigation("Children");
 11654
 11655                    b.Navigation("Images");
 11656
 11657                    b.Navigation("ItemValues");
 11658
 11659                    b.Navigation("LockedFields");
 11660
 11661                    b.Navigation("MediaStreams");
 11662
 11663                    b.Navigation("Parents");
 11664
 11665                    b.Navigation("Peoples");
 11666
 11667                    b.Navigation("Provider");
 11668
 11669                    b.Navigation("TrailerTypes");
 11670
 11671                    b.Navigation("UserData");
 11672                });
 1673
 11674            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.DisplayPreferences", b =>
 11675                {
 11676                    b.Navigation("HomeSections");
 11677                });
 1678
 11679            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.ItemValue", b =>
 11680                {
 11681                    b.Navigation("BaseItemsMap");
 11682                });
 1683
 11684            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.People", b =>
 11685                {
 11686                    b.Navigation("BaseItems");
 11687                });
 1688
 11689            modelBuilder.Entity("Jellyfin.Database.Implementations.Entities.User", b =>
 11690                {
 11691                    b.Navigation("AccessSchedules");
 11692
 11693                    b.Navigation("DisplayPreferences");
 11694
 11695                    b.Navigation("ItemDisplayPreferences");
 11696
 11697                    b.Navigation("Permissions");
 11698
 11699                    b.Navigation("Preferences");
 11700
 11701                    b.Navigation("ProfileImage");
 11702                });
 1703#pragma warning restore 612, 618
 11704        }
 1705    }
 1706}
Generated by: ReportGenerator 5.4.7.0
7/4/2025 - 12:12:04 AM
GitHub | reportgenerator.io

Methods/Properties

BuildModel(Microsoft.EntityFrameworkCore.ModelBuilder)