|
|
|
v30
|
|
|
|
===
|
|
|
|
|
|
|
|
### List of changes
|
|
|
|
|
|
|
|
#### PlaylistMediaRelation table
|
|
|
|
* Updating `media_id` `ON DELETE` clause from `SET NULL` to `CASCADE` (!364)
|
|
|
|
|
|
|
|
#### MediaGroup table
|
|
|
|
* Store the number of media regardless of their presence in `nb_video`/`nb_audio`/`nb_unknown` (!359)
|
|
|
|
* Add a `nb_present_video` column (!359)
|
|
|
|
* Add a `nb_present_audio` column (!359)
|
|
|
|
* Add a `nb_present_unknown` column (!359)
|
|
|
|
* Remove `nb_media` column (!359)
|
|
|
|
|
|
|
|
#### Playlist table
|
|
|
|
* Add a `nb_media` column (!359)
|
|
|
|
* Add a `nb_present_media` column (!359)
|
|
|
|
|
|
|
|
#### Triggers
|
|
|
|
* Add `playlist_update_nb_media_on_media_deletion` (!359)
|
|
|
|
* Add `playlist_update_nb_present_media` (!359)
|
|
|
|
|
|
|
|
|
|
|
|
### Rescan required:
|
|
|
|
* No
|
|
|
|
|
|
|
|
### Used by: |