|
|
|
# Model v33
|
|
|
|
|
|
|
|
### List of changes:
|
|
|
|
|
|
|
|
#### Media
|
|
|
|
|
|
|
|
* Remove `real_last_played_date` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/446/diffs?commit_id=09b491662495f988587b7b74a8c2603c8853210d)
|
|
|
|
* Mark the `play_count` column as `NOT NULL` (https://code.videolan.org/videolan/medialibrary/-/merge_requests/462/diffs?commit_id=774dcc8e249113533171bf0c5e0893d38ffcf66c)
|
|
|
|
|
|
|
|
#### Playlist
|
|
|
|
|
|
|
|
* Add a `duration` column (https://code.videolan.org/videolan/medialibrary/-/merge_requests/456/diffs?commit_id=f74643569dc30f711b58c5771fd12da8f90296d1)
|
|
|
|
* Add a `playlist_update_duration_on_media_change` trigger (https://code.videolan.org/videolan/medialibrary/-/merge_requests/456/diffs?commit_id=f74643569dc30f711b58c5771fd12da8f90296d1)
|
|
|
|
* Update `playlist_update_nb_media_on_media_deletion` trigger to account for the duration (https://code.videolan.org/videolan/medialibrary/-/merge_requests/456/diffs?commit_id=f74643569dc30f711b58c5771fd12da8f90296d1)
|
|
|
|
* Add `nb_audio` `nb_video` `nb_unknown` `nb_present_audio` `nb_present_video` `nb_present_unknown` columns (https://code.videolan.org/videolan/medialibrary/-/merge_requests/457/diffs?commit_id=1438d2d7aa56085aa4416645f0db70518c6b3e1e)
|
|
|
|
* Deprecate `playlist_update_nb_present_media` trigger (https://code.videolan.org/videolan/medialibrary/-/merge_requests/457/diffs?commit_id=1438d2d7aa56085aa4416645f0db70518c6b3e1e)
|
|
|
|
* Add a `playlist_update_nb_media_on_media_change` trigger (https://code.videolan.org/videolan/medialibrary/-/merge_requests/457/diffs?commit_id=1438d2d7aa56085aa4416645f0db70518c6b3e1e)
|
|
|
|
|
|
|
|
#### Media Group
|
|
|
|
|
|
|
|
* Add `nb_seen` and `nb_present_seen` columns (https://code.videolan.org/videolan/medialibrary/-/merge_requests/462/diffs?commit_id=133d8536f8c65998b0f46a3753c0a6a5448339da)
|
|
|
|
* Update `media_group_update_nb_media_types`, `media_group_decrement_nb_media_on_deletion` and `media_group_update_nb_media_types_presence` triggers to account for the seen state of media (https://code.videolan.org/videolan/medialibrary/-/merge_requests/462/diffs?commit_id=133d8536f8c65998b0f46a3753c0a6a5448339da)
|
|
|
|
|
|
|
|
#### Misc
|
|
|
|
|
|
|
|
* Fix a bug introduced in 30 to 31 migration which caused media groups media count to be invalid if external media were contained in them (https://code.videolan.org/videolan/medialibrary/-/merge_requests/478/diffs?commit_id=f554cba69297cb0dfdbc584c219ff8d81c9fccd9)
|
|
|
|
|
|
|
|
### Rescan required:
|
|
|
|
|
|
|
|
Yes
|
|
|
|
|
|
|
|
### Used by: |
