aboutsummaryrefslogtreecommitdiff
path: root/src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations
AgeCommit message (Collapse)Author
6 daysMerge remote-tracking branch 'upstream/master' into optimize-db-helper-memoryShadowghost
# Conflicts: # src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/JellyfinDbModelSnapshot.cs
8 daysStop user updates from orphaning permission and preference rows (#17645)Tim Eisele
* Stop user updates from orphaning permission and preference rows * Make UserId non-nullable * Remove unnecessary ToList * Update Jellyfin.Server.Implementations/Users/UserManager.cs Co-authored-by: Claus Vium <cvium@users.noreply.github.com> --------- Co-authored-by: Claus Vium <cvium@users.noreply.github.com>
2026-08-12Fix formattingShadowghost
2026-08-12Make the media stream filter index coveringShadowghost
2026-08-11Optimize query helper memoryShadowghost
2026-08-07Fix EF core designer driftsShadowghost
2026-08-01Merge remote-tracking branch 'upstream/master' into fix-byname-queriesShadowghost
# Conflicts: # src/Jellyfin.Database/Jellyfin.Database.Providers.Sqlite/Migrations/JellyfinDbModelSnapshot.cs
2026-08-01Merge pull request #17416 from Shadowghost/enable-duplicate-playlist-childrenCody Robibero
Allow duplicate LinkedChildren for Playlists
2026-07-28Restrict people, genres, studios and artists to names backed by an item the ↵Shadowghost
user can access
2026-07-28Make the /Persons de-duplication use an index instead of grouping the tableShadowghost
2026-07-25Fix favorite filter performanceShadowghost
2026-07-25Fix DatePlayed sorting performanceShadowghost
2026-07-23Allow duplicate LinkedChildren for PlaylistsShadowghost
2026-05-26Backport: Fix/user manager collation (#16919)Bond-009
Backport: Fix/user manager collation
2026-05-21Run tree-wide dotnet formatjakobkukla
2026-05-15Reorder migration handling for extra columnJPVenson
2026-05-07Add OriginalLanguage as option to PreferredAudioLanguage (#12579)Erik W
* Add OriginalLanguage as option to PreferredAudioLanguage * Support for multiple original languages * Add original audio stream indicator * Fetch OriginalLanguage from TMDB * Adapt to EFCore refactor * Fix PlayDefaultAudioTrack OriginalLanguage behavior * Fix better PlayDefaultAudioTrack OriginalLanguage behavior * Add comment to ItemFields * Improved PlayDefaultAudioTrack behavior * Add migration for original language * Use sting.Equals for string comparisons * Always set dto OriginalLanguage * Remove OriginalLanguage from ItemFields --------- Co-authored-by: Lampan-git <lampan-git@users.noreply.github.com>
2026-05-04Fix Playlist and Boxset query and count perfShadowghost
2026-03-08Optimize Search and NextUp queriesShadowghost
2026-02-15Migrate PrimaryVersionId to GUID and fix assignmentShadowghost
2026-02-07Optimize IndicesShadowghost
2026-01-31Optimize Validator and Filter PerformanceShadowghost
2026-01-18Add ImageInfo indexShadowghost
2026-01-18Add optimized indexes for UserData and latest items queriesShadowghost
2026-01-18Remove ExtraIds column and use OwnerId relationship for extrasShadowghost
- Remove ExtraIds property from BaseItemEntity and BaseItem - Update RefreshExtras to query via OwnerId instead of cached ExtraIds - Update GetExtras methods to query database via OwnerIds filter - Add OwnerIds and ExtraTypes filter support to InternalItemsQuery - Add filter handling in BaseItemRepository for new query options - Update HasSpecialFeature/HasTrailer filters to use Extras relationship - Add CleanupOrphanedExtras migration routine - Add database migration to drop ExtraIds column
2026-01-18Normalize OwnerId to GUID and add performance indexesShadowghost
- Change OwnerId from string to Guid for proper foreign key relationships - Add Owner/Extras navigation properties for extras relationship - Add indexes on OwnerId and ExtraType columns for efficient queries - Add optimized composite indexes for latest items queries sorted by DateCreated - Update BaseItemRepository and migration to handle new Guid type
2026-01-18Add LinkedChildren database table for normalized relationshipsShadowghost
Introduces a new database table to store linked child relationships for boxsets, playlists, and video alternate versions. This replaces the JSON-serialized Data column approach with a proper relational structure. - Add LinkedChildEntity and LinkedChildType enum - Add entity configuration with proper foreign keys - Add EF Core migration for SQLite
2025-09-28Fix AddProperParentChildRelationBaseItemWithCascade migration deleting all itemsNiels van Velzen
2025-09-25Fix people deduplication lookup (#14864)JPVenson
2025-09-25Fixes FK on unconnected base items (#14863)JPVenson
2025-09-16Optimize internal querying of UserData, other fixes (#14795)JPVenson
2025-07-22Supress transaction (#14514)JPVenson
2025-07-14Use IDatabaseCreator instead of relying on History repository (#14465)JPVenson
2025-06-26Fix modification checks and make sure to use UTC (#14347)Tim Eisele
2025-06-11Fix UserData cleanup task and queries (#14280)JPVenson
2025-06-09Feature/persistent watch data (#14262)JPVenson
2025-06-03Add multiple options for internal locking (#14047)JPVenson
2025-04-05Fix ancestors (#13827)Tim Eisele
2025-04-05Fix indices and update of ItemValues (#13843)Tim Eisele
2025-04-03Cleanup extracted files (#13760)Tim Eisele
* Cleanup extracted files * Pagination and fixes * Add migration for attachments to MigrateLibraryDb * Unify attachment handling * Don't extract again if files were already extracted * Fix MKS attachment extraction * Always run full extraction on mks * Don't try to extract mjpeg streams as attachments * Fallback to check if attachments were extracted to cache folder * Fixup
2025-04-02Import Keyframes into database (#13771)Tim Eisele
* Migrate keyframe data into database * Clear database table before import to handle failed migrations
2025-04-02Improve dynamic HDR metadata handling (#13277)gnattu
* Add support for bitstream filter to remove dynamic hdr metadata * Add support for ffprobe's only_first_vframe for HDR10+ detection * Add BitStreamFilterOptionType for metadata removal check * Map HDR10+ metadata to VideoRangeType.cs Current implementation uses a hack that abuses the EL flag to avoid database schema changes. Should add proper field once EFCore migration is merged. * Add more Dolby Vision Range types Out of spec ones are problematic and should be marked as a dedicated invalid type and handled by the server to not crash the player. Profile 7 videos should not be treated as normal HDR10 videos at all and should remove the metadata before serving. * Remove dynamic hdr metadata when necessary * Allow direct playback of HDR10+ videos on HDR10 clients * Only use dovi codec tag when dovi metadata is not removed * Handle DV Profile 7 Videos better * Fix HDR10+ with new bitmask * Indicate the presence of HDR10+ in HLS SUPPLEMENTAL-CODECS * Fix Dovi 8.4 not labeled as HLG in HLS * Fallback to dovi_rpu bsf for av1 when possible * Fix dovi_rpu cli for av1 * Use correct EFCore db column for HDR10+ * Undo outdated migration * Add proper hdr10+ migration * Remove outdated migration * Rebase to new db code * Add migrations for Hdr10PlusPresentFlag * Directly use bsf enum * Add xmldocs for SupportsBitStreamFilterWithOption * Make `VideoRangeType.Unknown` explicitly default on api models. * Unset default for non-api model class * Use tuples for bsf dictionary for now
2025-03-30Rework parental ratings (#12615)Tim Eisele
2025-03-25Fixed namespacesJPVenson
2025-03-25WIP fixed namespacesJPVenson
2025-03-24Fixed naming schemeJPVenson
2025-03-24renamed SqLite to SqliteJPVenson